Elapsed Time (s)	CPU Time (s)	Executions 	Elap per Exec (s) 	% Total DB Time	SQL Id	SQL Module	SQL Text
3,263	                32	        1	        3263.49	                2.79	       3ta0ms19fvgds httpd.exe 	SELECT CASE WHEN COUNT >= 1...Elapsed 
6,360	                164	        2	        3180.17	                5.44	       51jx99dm0swv7 cpm_srvscript@ahcaxasmil1b (TNS V1-V3) 	SELECT /*+ CCL<PFT_GET_RP...

Physical Reads	Executions	Reads per Exec 	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
237,654	1	237,654.00	4.15	        42.20	                2877.19	0vcyhc2d4v28d    httpd.exe 	SELECT CASE WHEN COUNT > 50...
160,122	1	160,122.00	2.80	        31.54	                3263.49	3ta0ms19fvgds    httpd.exe 	SELECT CASE WHEN COUNT >= 1...

ECSCDAS1S > /

WAIT_CLASS  NAME                                 TIME_SECS     PCT
----------- ------------------------------ --------------- -------
Other       CGS wait for IPC msg                     97.16     .01
Cluster     gc cr block 2-way                       100.30     .01
Application SQL*Net break/reset to client           107.52     .01
Cluster     gc current block 2-way                  108.99     .01
System I/O  db file parallel write                  109.14     .01
System I/O  log file parallel write                 111.71     .01
Other       PX Deq: Slave Session Stats             112.04     .01
Other       ASM file metadata operation             126.44     .01
Other       PX Deq: reap credit                     131.16     .01
Other       enq: WF - contention                    137.86     .01
System I/O  control file parallel write             143.34     .01
Other       DFS lock handle                         159.61     .01
Network     SQL*Net more data to client             229.51     .01
Concurrency os thread startup                       249.96     .01
Other       reliable message                        378.04     .02
User I/O    db file scattered read                  441.15     .03
User I/O    db file sequential read                 492.50     .03
Other       PX Nsq: PQ load info query              556.99     .03
System I/O  RMAN backup & recovery I/O              691.09     .04
System I/O  control file sequential read          1,837.63     .11
Network     SQL*Net more data from client         2,223.40     .13
User I/O    direct path read                      2,565.99     .15
CPU         server CPU                           71,981.42    4.16
Concurrency library cache lock                1,646,942.02   95.15

ECSCDAS1S > list
  1  SELECT
  2     wait_class,
  3     NAME,
  4     ROUND (time_secs, 2) time_secs,
  5     ROUND (time_secs * 100 / SUM (time_secs) OVER (), 2) pct
  6  FROM
  7     (SELECT
  8        n.wait_class,
  9        e.event NAME,
 10        e.time_waited / 100 time_secs
 11      FROM
 12        v$system_event e,
 13        v$event_name n
 14      WHERE
 15         n.NAME = e.event AND n.wait_class <> 'Idle'
 16      AND
 17         time_waited > 0
 18      UNION
 19      SELECT
 20        'CPU',
 21        'server CPU',
 22        SUM (VALUE / 1000000) time_secs
 23      FROM
 24        v$sys_time_model
 25      WHERE
 26        stat_name IN ('background cpu time', 'DB CPU'))
 27  ORDER BY
 28*    time_secs

ECSESBP1 > @v$sys_time_model_top_Waits_with_BACK_GROUND_60.sql

WAIT_CLASS  NAME                                 TIME_SECS     PCT
----------- ------------------------------ --------------- -------
System I/O  control file parallel write                .01     .01
Cluster     gc current grant busy                      .01     .01
System I/O  log file sequential read                   .01     .01
Commit      log file sync                              .02     .02
Cluster     gc current block 2-way                     .02     .02
Cluster     gc cr block 2-way                          .02     .02
System I/O  log file parallel write                    .02     .02
Other       gcs log flush sync                         .03     .03
System I/O  db file parallel write                     .04     .05
System I/O  Log archive I/O                            .08     .09
User I/O    db file sequential read                    .13     .15
System I/O  control file sequential read               .33     .38
Network     LNS wait on SENDREQ                       1.74    2.01
CPU         server CPU                                5.61    6.47
Network     ARCH wait on SENDREQ                     78.59   90.69

ENWEBTT > @v$sys_time_model_top_Waits_with_BACK_GROUND_60.sql

WAIT_CLASS  NAME                                 TIME_SECS     PCT
----------- ------------------------------ --------------- -------
User I/O    direct path write temp                     .00     .00
User I/O    db file scattered read                     .00     .00
System I/O  RMAN backup & recovery I/O                 .00     .00
User I/O    direct path write                          .00     .00
Network     SQL*Net message to client                  .01     .06
User I/O    Disk file operations I/O                   .01     .06
Network     SQL*Net more data from client              .02     .12
Network     SQL*Net more data to client                .02     .12
User I/O    db file sequential read                    .03     .18
System I/O  db file async I/O submit                   .10     .62
Commit      log file sync                              .23    1.42
System I/O  control file parallel write                .30    1.85
System I/O  log file parallel write                    .45    2.77
User I/O    direct path read                          2.70   16.64
CPU         server CPU                               12.36   76.16

COLUMN wait_class format a11
COLUMN name       format a30
COLUMN time_secs  format 999,999,999.99
COLUMN pct        format 999.99
set pages 40
set termout off
drop table v$sys_time_model_alana purge;
drop table v$sys_time_model_alanb purge;
drop table alanc purge;
create table v$sys_time_model_alana as
SELECT   
   wait_class, 
   NAME, 
   ROUND (time_secs, 2) time_secs,
   ROUND (time_secs * 100 / SUM (time_secs) OVER (), 2) pct
FROM 
   (SELECT 
      n.wait_class, 
      e.event NAME, 
      e.time_waited / 100 time_secs
    FROM 
      v$system_event e, 
      v$event_name n
    WHERE 
       n.NAME = e.event AND n.wait_class <> 'Idle'
    AND 
       time_waited > 0
    UNION
    SELECT 
      'CPU', 
      'server CPU', 
      SUM (VALUE / 1000000) time_secs
    FROM 
      v$sys_time_model
    WHERE 
      stat_name IN ('background cpu time', 'DB CPU'))
ORDER BY 
   time_secs;

execute dbms_lock.sleep(60);

create table v$sys_time_model_alanb as
SELECT   
   wait_class, 
   NAME, 
   ROUND (time_secs, 2) time_secs,
   ROUND (time_secs * 100 / SUM (time_secs) OVER (), 2) pct
FROM 
   (SELECT 
      n.wait_class, 
      e.event NAME, 
      e.time_waited / 100 time_secs
    FROM 
      v$system_event e, 
      v$event_name n
    WHERE 
       n.NAME = e.event AND n.wait_class <> 'Idle'
    AND 
       time_waited > 0
    UNION
    SELECT 
      'CPU', 
      'server CPU', 
      SUM (VALUE / 1000000) time_secs
    FROM 
      v$sys_time_model
    WHERE 
      stat_name IN ('background cpu time', 'DB CPU'))
ORDER BY 
   time_secs;
set termout on
create table alanc as select sum(b.TIME_SECS-a.TIME_SECS) times 
from v$sys_time_model_alanb b, v$sys_time_model_alana a
where b.WAIT_CLASS=a.wait_class and b.NAME=a.name;
select b.WAIT_CLASS,b.NAME,
(b.TIME_SECS-a.TIME_SECS)*1 time_secs,
(b.TIME_SECS-a.TIME_SECS)/decode(c.times,0,1,c.times)*100 "PCT"
from v$sys_time_model_alanb b, v$sys_time_model_alana a, alanc c
where b.WAIT_CLASS=a.wait_class and b.NAME=a.name
order by 4,3;