oracleScriptsUncategorized

CPU Usage Queries

CPU usage Queries Historical CPU Usage From the below query we can modify the END_INTERVAL_TIME as required by adjusting from where clause. set linesize 200 set pagesize 120 col module for a60 SELECT   mymodule "Module", SUM (cpu_time) "CPU Time", SUM (wait_time) "Wait Time",          SUM (cpu_time) + SUM (wait_time) "Total Time"     FROM (SELECT a.module