oracle cpu usage

Solutions on MaxInterview for oracle cpu usage by the best coders in the world

showing results for - "oracle cpu usage"
Miguel
22 Jan 2017
1SELECT PARSING_SCHEMA_NAME, MODULE, SQL_ID, 
2	   round(((CPU_TIME / 1e6) / 60), 2) AS CPU_TIME,
3       EXECUTIONS, ROWS_PROCESSED, DISK_READS, FIRST_LOAD_TIME,
4       LAST_LOAD_TIME, OPTIMIZER_COST, SQL_FULLTEXT
5FROM V$SQLAREA
6WHERE PARSING_SCHEMA_NAME IN ('schema_name')
7ORDER BY PARSING_SCHEMA_NAME, CPU_TIME DESC;