List top 10 sql queries in memory using largest CPU time for non sys users

posted Apr 22, 2012, 5:07 PM by Sachchida Ojha


SQL>select sql_id,substr(sql_text,1,20),
disk_reads,
cpu_time,
elapsed_time,
buffer_gets,
parsing_schema_name
FROM table(DBMS_SQLTUNE.SELECT_CURSOR_CACHE(
basic_filter => 'parsing_schema_name <> ''SYS''', ranking_measure1 => 'cpu_time', result_limit =>10));



Comments