Skip to content

Instantly share code, notes, and snippets.

------------------------------ sqlreal/last version: 20170609 ------------------------------
alter session set CURSOR_SHARING = force;
with gu$sql as (
SELECT
round(db_time / db_exec / 1000, 2) ela_ms
,round(db_cpu / db_exec / 1000, 2) cpu_ms
,round((db_time-db_cpu) / db_exec / 1000, 2) wait_ms
,round(db_buffer / db_exec, 2) gets
,round(db_io / db_exec, 2) reads
,round(db_rows/db_exec,0) dbrows