WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC ------------ ----------- ------------ -------- --------------- ----------- --- GLDB 2907699466 gldb 1 16-Oct-12 10:08 11.2.0.1.0 NO Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- WIN-VTBNMB5VC5I Microsoft Windows x86 64-bit 4 4 1 11.99 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 801 16-Oct-12 13:00:02 38 3.5 End Snap: 802 16-Oct-12 13:15:05 38 3.5 Elapsed: 15.05 (mins) DB Time: 5.41 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 2,304M 2,304M Std Block Size: 8K Shared Pool Size: 576M 576M Log Buffer: 8,168K Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~ --------------- --------------- ---------- ---------- DB Time(s): 0.4 0.1 0.00 0.01 DB CPU(s): 0.2 0.1 0.00 0.01 Redo size: 5,405,639.8 1,775,432.3 Logical reads: 34,699.7 11,396.8 Block changes: 27,200.9 8,933.9 Physical reads: 0.9 0.3 Physical writes: 511.6 168.0 User calls: 35.1 11.5 Parses: 131.0 43.0 Hard parses: 1.0 0.3 W/A MB processed: 0.1 0.0 Logons: 0.1 0.0 Executes: 163.5 53.7 Rollbacks: 0.0 0.0 Transactions: 3.0 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 99.98 Buffer Hit %: 100.00 In-memory Sort %: 100.00 Library Hit %: 99.90 Soft Parse %: 99.26 Execute to Parse %: 19.87 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 90.34 % Non-Parse CPU: 98.84 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 60.19 65.36 % SQL with executions>1: 86.85 78.20 % Memory for SQL w/exec>1: 80.32 78.81 Top 5 Timed Foreground Events ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg wait % DB Event Waits Time(s) (ms) time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- DB CPU 162 49.8 log file switch (checkpoint in 104 62 596 19.1 Configurat log file sync 2,686 6 2 1.7 Commit log file switch completion 109 3 28 .9 Configurat SQL*Net more data from client 107,321 2 0 .5 Network Host CPU (CPUs: 4 Cores: 4 Sockets: 1) ~~~~~~~~ Load Average Begin End %User %System %WIO %Idle --------- --------- --------- --------- --------- --------- 8.8 1.6 89.5 Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: 4.7 % of busy CPU for Instance: 44.6 %DB time waiting for CPU - Resource Mgr: 0.0 Memory Statistics ~~~~~~~~~~~~~~~~~ Begin End Host Mem (MB): 12,275.1 12,275.1 SGA use (MB): 2,944.0 2,944.0 PGA use (MB): 124.1 125.1 % Host Mem used for SGA+PGA: 24.99 25.00 Time Model Statistics DB/Inst: GLDB/gldb Snaps: 801-802 -> Total time in database user-calls (DB Time): 324.3s -> Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic -> Ordered by % or DB time desc, Statistic name Statistic Name Time (s) % of DB Time ------------------------------------------ ------------------ ------------ sql execute elapsed time 316.6 97.6 DB CPU 161.6 49.8 sequence load elapsed time 24.3 7.5 parse time elapsed 3.0 .9 hard parse elapsed time 1.3 .4 PL/SQL execution elapsed time 0.6 .2 connection management call elapsed time 0.1 .0 repeated bind elapsed time 0.0 .0 DB time 324.3 background elapsed time 69.4 background cpu time 7.0 ------------------------------------------------------------- Operating System Statistics DB/Inst: GLDB/gldb Snaps: 801-802 -> *TIME statistic values are diffed. All others display actual values. End Value is displayed if different -> ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name Statistic Value End Value ------------------------- ---------------------- ---------------- AVG_BUSY_TIME 9,423 AVG_IDLE_TIME 80,860 AVG_SYS_TIME 1,430 AVG_USER_TIME 7,965 BUSY_TIME 37,775 IDLE_TIME 323,519 SYS_TIME 5,823 USER_TIME 31,952 VM_IN_BYTES -9.391060752118678E+18 VM_OUT_BYTES 3,641,582,545,694,720 PHYSICAL_MEMORY_BYTES 12,871,364,608 NUM_CPUS 4 NUM_CPU_CORES 4 NUM_CPU_SOCKETS 1 ------------------------------------------------------------- Operating System Statistics - Detail DB/Inst: GLDB/gldb Snaps: 801-802 Snap Time Load %busy %user %sys %idle %iowait --------------- -------- -------- -------- -------- -------- -------- 16-Oct 13:00:02 0.0 N/A N/A N/A N/A N/A 16-Oct 13:15:05 0.0 10.5 8.8 1.6 89.5 0.0 ------------------------------------------------------------- Foreground Wait Class DB/Inst: GLDB/gldb Snaps: 801-802 -> s - second, ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Captured Time accounts for 72.4% of Total DB time 324.31 (s) -> Total FG Wait Time: 73.22 (s) DB CPU time: 161.57 (s) Avg %Time Total Wait wait Wait Class Waits -outs Time (s) (ms) %DB time -------------------- ---------------- ----- ---------------- -------- --------- DB CPU 162 49.8 Configuration 224 0 65 292 20.2 Commit 2,686 0 6 2 1.7 Network 138,528 0 2 0 0.5 System I/O 201 0 1 3 0.2 User I/O 61 0 0 0 0.0 Application 60 0 0 0 0.0 Other 224 97 0 0 0.0 Concurrency 3 0 0 0 0.0 ------------------------------------------------------------- Foreground Wait Events DB/Inst: GLDB/gldb Snaps: 801-802 -> s - second, ms - millisecond - 1000th of a second -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by wait time desc, waits desc (idle events last) -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % DB Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ log file switch (checkpoin 104 0 62 596 0.0 19.1 log file sync 2,686 0 6 2 1.0 1.7 log file switch completion 109 0 3 28 0.0 .9 SQL*Net more data from cli 107,321 0 2 0 39.0 .5 control file sequential re 201 0 1 3 0.1 .2 log buffer space 1 0 0 287 0.0 .1 log file switch (private s 10 0 0 8 0.0 .0 SQL*Net message to client 31,207 0 0 0 11.3 .0 db file sequential read 17 0 0 1 0.0 .0 SQL*Net break/reset to cli 60 0 0 0 0.0 .0 Disk file operations I/O 44 0 0 0 0.0 .0 ADR block file read 6 0 0 0 0.0 .0 SQL*Net message from clien 31,207 0 6,648 213 11.3 jobq slave wait 1,964 99 1,007 513 0.7 wait for unread message on 910 98 903 992 0.3 Streams AQ: waiting for me 180 100 901 5007 0.1 ------------------------------------------------------------- Background Wait Events DB/Inst: GLDB/gldb Snaps: 801-802 -> ordered by wait time desc, waits desc (idle events last) -> Only events with Total Wait Time (s) >= .001 are shown -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % bg Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ log file parallel write 8,146 0 31 4 3.0 44.3 db file parallel write 12,399 0 19 1 4.5 26.7 control file sequential re 8,378 0 7 1 3.0 10.8 control file parallel writ 2,060 0 1 1 0.7 1.7 enq: CF - contention 101 0 1 8 0.0 1.2 os thread startup 35 0 0 5 0.0 .3 direct path read 322 0 0 0 0.1 .2 log file sequential read 216 0 0 1 0.1 .2 direct path write 207 0 0 0 0.1 .1 db file sequential read 110 0 0 0 0.0 .1 log file single write 216 0 0 0 0.1 .0 LGWR wait for redo copy 746 0 0 0 0.3 .0 ADR block file read 12 0 0 0 0.0 .0 log file sync 1 0 0 3 0.0 .0 Disk file operations I/O 23 0 0 0 0.0 .0 reliable message 16 0 0 0 0.0 .0 rdbms ipc message 13,211 28 11,670 883 4.8 DIAG idle wait 1,782 100 1,807 1014 0.6 smon timer 4 75 969 242265 0.0 Streams AQ: waiting for ti 7 71 965 137865 0.0 pmon timer 413 67 903 2186 0.2 shared server idle wait 30 100 900 30014 0.0 dispatcher timer 15 100 900 60012 0.0 Space Manager: slave idle 180 99 900 4998 0.1 Streams AQ: qmn slave idle 33 0 897 27168 0.0 Streams AQ: qmn coordinato 64 50 897 14008 0.0 SQL*Net message from clien 64 0 0 1 0.0 ------------------------------------------------------------- Wait Event Histogram DB/Inst: GLDB/gldb Snaps: 801-802 -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> % of Waits: value of .0 indicates value was <.05%; value of null is truly 0 -> % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms -> Ordered by Event (idle events last) % of Waits ----------------------------------------------- Total Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ADR block file read 18 100.0 ADR block file write 5 100.0 ADR file lock 6 100.0 Disk file operations I/O 67 100.0 LGWR wait for redo copy 746 100.0 SQL*Net break/reset to cli 60 100.0 SQL*Net message to client 31.3K 100.0 SQL*Net more data from cli 107.4 100.0 asynch descriptor resize 335 100.0 control file parallel writ 2060 99.4 .1 .0 .3 .0 .0 control file sequential re 8579 91.9 3.2 3.7 .5 .1 .1 .6 db file parallel write 12.4K 72.1 10.2 5.8 8.1 2.9 .7 .1 db file sequential read 172 96.5 2.3 1.2 direct path read 322 98.8 .9 .3 direct path write 207 100.0 enq: CF - contention 101 1.0 10.9 30.7 57.4 latch: In memory undo latc 2 100.0 latch: cache buffers chain 4 100.0 latch: object queue header 3 100.0 log buffer space 1 100.0 log file parallel write 8152 35.0 4.4 6.9 51.9 .7 .3 .9 log file sequential read 216 87.0 8.3 4.2 .5 log file single write 216 100.0 log file switch (checkpoin 104 23.1 25.0 19.2 32.7 log file switch (private s 10 40.0 60.0 log file switch completion 109 2.8 1.8 29.4 43.1 2.8 20.2 log file sync 2690 71.0 10.3 13.2 3.9 .5 .2 .9 os thread startup 35 100.0 rdbms ipc reply 16 100.0 reliable message 16 100.0 DIAG idle wait 1782 100.0 SQL*Net message from clien 31.3K 24.9 31.6 3.4 .7 .5 1.8 36.5 .6 Space Manager: slave idle 180 100.0 Streams AQ: qmn coordinato 64 50.0 50.0 Streams AQ: qmn slave idle 33 3.0 97.0 Streams AQ: waiting for me 180 100.0 Streams AQ: waiting for ti 7 28.6 42.9 28.6 class slave wait 7 100.0 dispatcher timer 15 100.0 jobq slave wait 1964 100.0 pmon timer 413 6.3 1.7 .2 1.7 16.0 74.1 rdbms ipc message 13.2K 15.2 .5 7.2 1.3 1.3 2.2 52.3 20.2 shared server idle wait 30 100.0 smon timer 4 100.0 wait for unread message on 911 1.1 .8 .2 97.9 ------------------------------------------------------------- Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: GLDB/gldb Snaps: 801- -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second) -> % of Total Waits: total waits for all wait classes, including Idle -> % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0 -> Ordered by Event (only non-idle events are displayed) % of Total Waits ----------------------------------------------- Waits 64ms Event to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- control file parallel writ 1 100.0 .0 control file sequential re 49 99.4 .5 .0 .0 db file parallel write 8 99.9 .0 .0 .0 log buffer space 1 100.0 log file parallel write 71 99.1 .6 .2 .1 log file switch (checkpoin 53 48.1 1.0 2.9 1.9 2.9 10.6 31.7 1.0 log file switch completion 22 79.8 20.2 log file sync 23 99.1 .5 .2 .0 .1 ------------------------------------------------------------- Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: GLDB/gldb Snaps: 801-80 -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) -> % of Total Waits: total waits for all wait classes, including Idle -> % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0 -> Ordered by Event (only non-idle events are displayed) % of Total Waits ----------------------------------------------- Waits 4s Event to 2m <2s <4s <8s <16s <32s < 1m < 2m >=2m -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- log file switch (checkpoin 1 99.0 1.0 ------------------------------------------------------------- Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Service Statistics DB/Inst: GLDB/gldb Snaps: 801-802 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K) ---------------------------- ------------ ------------ ------------ ------------ gldb 322 161 0 31,306 SYS$USERS 3 1 0 25 SYS$BACKGROUND 0 0 1 9 gldbXDB 0 0 0 0 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> Wait Class info for services in the Service Statistics section. -> Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network -> Time Waited (Wt Time) in seconds Service Name ---------------------------------------------------------------- User I/O User I/O Concurcy Concurcy Admin Admin Network Network Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time --------- --------- --------- --------- --------- --------- --------- --------- gldb 12 0 3 0 0 0 137896 2 SYS$USERS 49 0 0 0 0 0 632 0 SYS$BACKGROUND 657 0 38 0 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: GLDB/gldb Snaps: 801-802 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 -> %Total - Elapsed Time as a percentage of Total DB time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 100.7% of Total DB Time (s): 324 -> Captured PL/SQL account for 0.4% of Total DB Time (s): 324 Elapsed Elapsed Time Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id ---------------- -------------- ------------- ------ ------ ------ ------------- 311.9 22,602 0.01 96.2 50.9 .0 7k1usds2tau95 Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 11.3 112,746 0.00 3.5 60.6 .0 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 0.7 2 0.34 .2 .0 .0 g4gp07gt2z920 update sys.scheduler$_job set last_start_date = :1, running_instance = :2, runn ing_slave = :3, job_status = :4 where obj# = :5 0.5 15 0.03 .1 .0 .7 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 0.4 1 0.39 .1 96.2 .1 bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R EADS from v$sga_target_advice 0.4 1 0.38 .1 97.6 .0 dayq182sk41ks insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memo ry_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) sel ect :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice 0.4 1 0.38 .1 97.7 .0 bm2pwrpcr8ru6 select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size 0.4 3 0.13 .1 .0 .0 9juw6s4yy5pzp Module: emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, ' BROKEN', 1, 0) broken, DECODE(STATE,'FAILED',1,0) failed FROM DBA_SCHEDULER_JOBS ) 0.2 360 0.00 .1 .0 .0 6v7n0y2bq89n8 Module: OEM.SystemPool BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get _scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END; 0.2 30 0.01 .0 9.8 .0 2b064ybzkwf1y Module: OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: GLDB/gldb Snaps: 801-802 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - CPU Time as a percentage of Total DB CPU -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 103.5% of Total CPU Time (s): 162 -> Captured PL/SQL account for 0.2% of Total CPU Time (s): 162 CPU CPU per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- 158.8 22,602 0.01 98.3 311.9 50.9 .0 7k1usds2tau95 Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 6.8 112,746 0.00 4.2 11.3 60.6 .0 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 0.4 1 0.37 0.2 0.4 96.2 .1 bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R EADS from v$sga_target_advice 0.4 1 0.37 0.2 0.4 97.7 .0 bm2pwrpcr8ru6 select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size 0.4 1 0.37 0.2 0.4 97.6 .0 dayq182sk41ks insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memo ry_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) sel ect :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice 0.1 58 0.00 0.0 0.0 881.9 .0 43c5ykm1mcp2a Module: OMS begin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client _info(:3); dbms_session.set_identifier(:4); end; 0.1 19 0.00 0.0 0.1 60.1 .5 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_val ues) 0.1 1 0.06 0.0 0.1 97.5 .0 a8j39qb13tqkr Module: emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID,DECODE(RECINFO.TYPE,NULL, 'Uncategor ized',RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMP ACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 ,'MM-DD-YYYY HH24:MI:SS') START_TIME, TO _DATE(:B2 ,'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUN 0.0 1 0.05 0.0 0.0 126.5 .0 5dfmd823r8dsp insert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, compone nt, oper_type, start_time, end_time, target_size, oper_mode, parameter, initi al_size, final_size, status) select snap_id, dbid, instance_num, compo nent, oper_type, start_time, max(end_time), target_size, max(oper_mode), 0.0 1 0.03 0.0 0.0 122.3 2.9 5k5v1ah25fb2c Module: OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END; ------------------------------------------------------------- SQL ordered by User I/O Wait Time DB/Inst: GLDB/gldb Snaps: 801-802 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - User I/O Time as a percentage of Total User I/O Wait time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 3.3% of Total User I/O Wait Time (s): -> Captured PL/SQL account for 1.7% of Total User I/O Wait Time (s): User I/O UIO per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- 0.0 22,602 0.00 2.3 311.9 50.9 .0 7k1usds2tau95 Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 0.0 15 0.00 1.2 0.5 .0 .7 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 0.0 244 0.00 0.5 0.0 124.4 5.1 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 0.0 1 0.00 0.3 0.0 122.3 2.9 5k5v1ah25fb2c Module: OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END; 0.0 19 0.00 0.2 0.1 60.1 .5 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_val ues) 0.0 58 0.00 0.1 0.0 .0 3.7 0kkhhb2w93cx0 update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,: 17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 0.0 1 0.00 0.1 0.4 96.2 .1 bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R EADS from v$sga_target_advice 0.0 5 0.00 0.1 0.0 222.3 1.7 5uy533jsc8hyh Module: Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1 0.0 1 0.00 0.1 0.1 21.5 .2 gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024 )-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME , SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE 0.0 2 0.00 0.0 0.0 435.0 2.6 d8mayxqw0wnpv SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_N AME = 'DROP_USER' ------------------------------------------------------------- SQL ordered by Gets DB/Inst: GLDB/gldb Snaps: 801-802 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - Buffer Gets as a percentage of Total Buffer Gets -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Buffer Gets: 31,341,226 -> Captured SQL account for 101.1% of Total Buffer Gets Elapsed Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ------------ ------ ---------- ------ ------ ----------- 31,308,611 22,602 1,385.2 99.9 311.9 50.9 .0 7k1usds2tau Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 339,209 112,746 3.0 1.1 11.3 60.6 .0 4m7m0t6fjcs update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 16,477 15 1,098.5 0.1 0.5 .0 .7 6gvch1xu9ca DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 6,121 19 322.2 0.0 0.1 60.1 .5 3am9cfkvx7g CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_val ues) 5,093 1 5,093.0 0.0 0.1 21.5 .2 gjm43un5cy8 SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024 )-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME , SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE 3,296 869 3.8 0.0 0.1 .0 .0 1umfsnn451y Module: OdbcDbTrace64.exe delete from DbLoaderStatus where LoaderName = 'WIN-VTBNMB5VC5I' 3,003 849 3.5 0.0 0.0 .0 .0 cm5vu20fhtn select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 2,776 704 3.9 0.0 0.1 22.2 .0 df9md17q736 Module: OdbcDbTrace64.exe Update GLT_PROBE_STATUS SET CONN_CURR_TIMESTAMP=CURRENT_DATE,CONN_DATA_TIMESTAMP =CURRENT_DATE where PROBE_NAME='CDRGen' AND PROBE_IP_ADDR='192.168.30.20' AND CO NN_TYPE=2 2,461 798 3.1 0.0 0.1 .0 .0 0ysq85ju8aj Module: OdbcDbTrace64.exe INSERT INTO DbLoaderStatus ( LoaderName, ProbeName, IpAddrPort, Status,OkFrameCo unt, ErrorFrameCount) VALUES ( :1, :2, :3, :4, :5, :6 ) 2,226 244 9.1 0.0 0.0 124.4 5.1 8vwv6hx92ym UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 ------------------------------------------------------------- SQL ordered by Reads DB/Inst: GLDB/gldb Snaps: 801-802 -> %Total - Physical Reads as a percentage of Total Disk Reads -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Disk Reads: 801 -> Captured SQL account for 1.9% of Total Physical Reads Elapsed Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ---------- ------ ---------- ------ ------ ------------- 8 22,602 0.0 1.0 311.9 50.9 .0 7k1usds2tau95 Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 5 15 0.3 0.6 0.5 .0 .7 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 4 244 0.0 0.5 0.0 124.4 5.1 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 2 1 2.0 0.2 0.0 122.3 2.9 5k5v1ah25fb2c Module: OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END; 1 58 0.0 0.1 0.0 .0 3.7 0kkhhb2w93cx0 update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,: 17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 1 5 0.2 0.1 0.0 222.3 1.7 5uy533jsc8hyh Module: Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1 1 1 1.0 0.1 0.4 96.2 .1 bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R EADS from v$sga_target_advice 0 5 0.0 0.0 0.0 210.0 .0 00prz3j9n4gyj Module: Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET _GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION _TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GU 0 474 0.0 0.0 0.0 .0 .0 089dbukv1aanh Module: EM_PING SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL 0 50 0.0 0.0 0.0 .0 .0 08bqjmf8490s2 Module: OMS SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 ------------------------------------------------------------- SQL ordered by Physical Reads (UnOptimized)DB/Inst: GLDB/gldb Snaps: 801-802 -> UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs -> %Opt - Optimized Reads as percentage of SQL Read Requests -> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs -> Total Physical Read Requests: 801 -> Captured SQL account for 9.5% of Total -> Total UnOptimized Read Requests: 801 -> Captured SQL account for 9.5% of Total -> Total Optimized Read Requests: 1 -> Captured SQL account for 0.0% of Total UnOptimized Physical UnOptimized Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id ----------- ----------- ---------- ------------ ------ ------ ------------- 86 86 1 86.0 0.0 10.7 1qhza1uh1xcf9 Module: emagent_SQL_oracle_database /* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32 ); l_flash_recovery_area VARCHAR2(512); l_flash_recovery_size NUMBER; l_us able_area NUMBER; l_space_used NUMBER; l_reclaimable_area NUMBER; l_nonrec laimable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_curs 21 21 3 7.0 0.0 2.6 9juw6s4yy5pzp Module: emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, ' BROKEN', 1, 0) broken, DECODE(STATE,'FAILED',1,0) failed FROM DBA_SCHEDULER_JOBS ) 21 21 3 7.0 0.0 2.6 b987hw04sm2s0 Module: Admin Connection select count(*) from dba_hist_baseline where dbid = :1 17 17 15 1.1 0.0 2.1 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 14 14 5 2.8 0.0 1.7 934ur8r7tqbjx Module: emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE 12 12 19 0.6 0.0 1.5 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_val ues) 10 10 22 0.5 0.0 1.2 49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn,1,2) || substr(vsn,4,2) || s 8 8 22,602 0.0 0.0 1.0 7k1usds2tau95 Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 7 7 1 7.0 0.0 0.9 fcsu9qb17sk52 Module: emagent_SQL_oracle_database /* OracleOEM */ DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TY PE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM 6 6 2 3.0 0.0 0.7 7d92gmwphtza8 Module: emagent_SQL_oracle_database SELECT OWNER,JOB_NAME,COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_I DX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP' ------------------------------------------------------------- SQL ordered by Executions DB/Inst: GLDB/gldb Snaps: 801-802 -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Executions: 147,696 -> Captured SQL account for 96.0% of Total Elapsed Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id ------------ --------------- -------------- ---------- ------ ------ ----------- 112,746 112,746 1.0 11.3 60.6 .0 4m7m0t6fjcs update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 22,602 2,254,901 99.8 311.9 50.9 .0 7k1usds2tau Module: OdbcDbTrace64.exe INSERT INTO /*+ APPEND_VALUES */GLT_PROT_TRAFFIC_SUM_VOIP ( trafficSumID, probeN ame, callingNumber, calledNumber, callID, startTime, duration, callSuccess, fail ureCause, postDialDelay, sessionDisconnectDelay, rtporiginationIPAddress, rtpdes tinationIPAddress, siporiginationIPAddress, sipdestinationIPAddress, ErrorCode, 869 797 0.9 0.1 .0 .0 1umfsnn451y Module: OdbcDbTrace64.exe delete from DbLoaderStatus where LoaderName = 'WIN-VTBNMB5VC5I' 849 1,256 1.5 0.0 .0 .0 cm5vu20fhtn select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 798 798 1.0 0.1 .0 .0 0ysq85ju8aj Module: OdbcDbTrace64.exe INSERT INTO DbLoaderStatus ( LoaderName, ProbeName, IpAddrPort, Status,OkFrameCo unt, ErrorFrameCount) VALUES ( :1, :2, :3, :4, :5, :6 ) 765 765 1.0 0.0 .0 .0 8t43xdhf4d9 Module: OEM.BoundedPool SELECT CONTEXT_TYPE_ID,CONTEXT_TYPE,TRACE_LEVEL,NULL,NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 ) 704 704 1.0 0.1 22.2 .0 df9md17q736 Module: OdbcDbTrace64.exe Update GLT_PROBE_STATUS SET CONN_CURR_TIMESTAMP=CURRENT_DATE,CONN_DATA_TIMESTAMP =CURRENT_DATE where PROBE_NAME='CDRGen' AND PROBE_IP_ADDR='192.168.30.20' AND CO NN_TYPE=2 532 532 1.0 0.0 40.3 .2 bsa0wjtftg3 select file# from file$ where ts#=:1 474 474 1.0 0.0 .0 .0 089dbukv1aa Module: EM_PING SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL 360 360 1.0 0.2 .0 .0 6v7n0y2bq89 Module: OEM.SystemPool BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get _scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END; ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Parse Calls: 118,356 -> Captured SQL account for 97.9% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 112,746 112,746 95.26 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 849 849 0.72 cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 704 704 0.59 df9md17q736da Module: OdbcDbTrace64.exe Update GLT_PROBE_STATUS SET CONN_CURR_TIMESTAMP=CURRENT_DATE,CONN_DATA_TIMESTAMP =CURRENT_DATE where PROBE_NAME='CDRGen' AND PROBE_IP_ADDR='192.168.30.20' AND CO NN_TYPE=2 532 532 0.45 bsa0wjtftg3uw select file# from file$ where ts#=:1 210 210 0.18 3972rvxu3knn3 Module: emagent_AQMetrics delete from sdo_geor_ddl__table$$ 104 104 0.09 au7jux77bsqqm Module: OdbcDbTrace64.exe Update GLT_PROBE_STATUS SET CONN_CURR_TIMESTAMP=CURRENT_DATE where PROBE_NAME='C DRGen' AND PROBE_IP_ADDR='192.168.30.20' AND CONN_TYPE=2 103 103 0.09 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 103 103 0.09 g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob j# = :objn 58 58 0.05 0kkhhb2w93cx0 update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,: 17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 58 58 0.05 43c5ykm1mcp2a Module: OMS begin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client _info(:3); dbms_session.set_identifier(:4); end; ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- Batched IO (bound) vector count 0 0.0 0.0 Batched IO (full) vector count 0 0.0 0.0 Batched IO block miss count 0 0.0 0.0 Batched IO double miss count 0 0.0 0.0 Batched IO same unit count 0 0.0 0.0 Batched IO single block count 0 0.0 0.0 Batched IO vector block count 0 0.0 0.0 Batched IO vector read count 0 0.0 0.0 Block Cleanout Optim referenced 5,083 5.6 1.9 CCursor + sql area evicted 0 0.0 0.0 CPU used by this session 16,206 17.9 5.9 CPU used when call started 16,151 17.9 5.9 CR blocks created 94 0.1 0.0 DB time 304,545 337.2 110.7 DBWR checkpoint buffers written 461,273 510.7 167.7 DBWR checkpoints 108 0.1 0.0 DBWR revisited being-written buf 4 0.0 0.0 DBWR thread checkpoint buffers w 461,273 510.7 167.7 DBWR transaction table writes 540 0.6 0.2 DBWR undo block writes 202,747 224.5 73.7 HSC Heap Segment Block Changes 2,370,671 2,624.7 862.1 Heap Segment Array Inserts 89 0.1 0.0 Heap Segment Array Updates 136 0.2 0.1 IMU CR rollbacks 92 0.1 0.0 IMU Flushes 1,051 1.2 0.4 IMU Redo allocation size 45,030,332 49,855.8 16,374.7 IMU commits 1,742 1.9 0.6 IMU contention 42 0.1 0.0 IMU ktichg flush 6 0.0 0.0 IMU pool not allocated 262 0.3 0.1 IMU recursive-transaction flush 144 0.2 0.1 IMU undo allocation size 27,068,808 29,969.5 9,843.2 IMU- failed to get a private str 262 0.3 0.1 Number of read IOs issued 0 0.0 0.0 RowCR attempts 15 0.0 0.0 RowCR hits 15 0.0 0.0 SMON posted for undo segment shr 1 0.0 0.0 SQL*Net roundtrips to/from clien 31,207 34.6 11.4 active txn count during cleanout 163,525 181.1 59.5 application wait time 1 0.0 0.0 background checkpoints completed 108 0.1 0.0 background checkpoints started 108 0.1 0.0 background timeouts 3,775 4.2 1.4 branch node splits 147 0.2 0.1 buffer is not pinned count 132,471 146.7 48.2 buffer is pinned count 14,435 16.0 5.3 bytes received via SQL*Net from 937,770,190 1,038,261.4 341,007.3 bytes sent via SQL*Net to client 4,440,938 4,916.8 1,614.9 calls to get snapshot scn: kcmgs 303,759 336.3 110.5 calls to kcmgas 399,698 442.5 145.3 calls to kcmgcs 331,814 367.4 120.7 cell physical IO interconnect by 9,046,428,672 10,015,842.0 3,289,610.4 change write time 3,805 4.2 1.4 cleanout - number of ktugct call 187,189 207.3 68.1 cleanouts and rollbacks - consis 0 0.0 0.0 cleanouts only - consistent read 2 0.0 0.0 cluster key scan block gets 2,240 2.5 0.8 cluster key scans 2,008 2.2 0.7 commit batch performed 0 0.0 0.0 commit batch requested 0 0.0 0.0 Instance Activity Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- commit batch/immediate performed 108 0.1 0.0 commit batch/immediate requested 108 0.1 0.0 commit cleanout failures: block 3 0.0 0.0 commit cleanout failures: buffer 590 0.7 0.2 commit cleanout failures: callba 11,985 13.3 4.4 commit cleanouts 794,982 880.2 289.1 commit cleanouts successfully co 782,404 866.3 284.5 commit immediate performed 108 0.1 0.0 commit immediate requested 108 0.1 0.0 commit txn count during cleanout 63,393 70.2 23.1 concurrency wait time 18 0.0 0.0 consistent changes 209 0.2 0.1 consistent gets 414,286 458.7 150.7 consistent gets - examination 349,954 387.5 127.3 consistent gets direct 22 0.0 0.0 consistent gets from cache 414,264 458.7 150.6 consistent gets from cache (fast 59,579 66.0 21.7 cursor authentications 6 0.0 0.0 data blocks consistent reads - u 158 0.2 0.1 db block changes 24,568,172 27,200.9 8,933.9 db block gets 30,926,940 34,241.1 11,246.2 db block gets direct 34 0.0 0.0 db block gets from cache 30,926,906 34,241.0 11,246.2 db block gets from cache (fastpa 9,013,258 9,979.1 3,277.6 deferred (CURRENT) block cleanou 540,590 598.5 196.6 dirty buffers inspected 23 0.0 0.0 enqueue conversions 452 0.5 0.2 enqueue releases 432,534 478.9 157.3 enqueue requests 432,537 478.9 157.3 enqueue timeouts 2 0.0 0.0 enqueue waits 101 0.1 0.0 execute count 147,696 163.5 53.7 failed probes on index block rec 0 0.0 0.0 file io wait time 1,212,362,628 1,342,279.1 440,859.1 free buffer inspected 313,431 347.0 114.0 free buffer requested 368,052 407.5 133.8 heap block compress 1,233 1.4 0.5 hot buffers moved to head of LRU 58,406 64.7 21.2 immediate (CR) block cleanout ap 2 0.0 0.0 immediate (CURRENT) block cleano 116,667 129.2 42.4 index crx upgrade (positioned) 1,438 1.6 0.5 index fast full scans (full) 4 0.0 0.0 index fetch by key 122,891 136.1 44.7 index scans kdiixs1 10,069 11.2 3.7 leaf node 90-10 splits 10,468 11.6 3.8 leaf node splits 40,712 45.1 14.8 lob reads 3 0.0 0.0 lob writes 57 0.1 0.0 lob writes unaligned 57 0.1 0.0 logons cumulative 70 0.1 0.0 max cf enq hold time 0 0.0 0.0 messages received 21,611 23.9 7.9 messages sent 21,611 23.9 7.9 min active SCN optimization appl 3 0.0 0.0 no work - consistent read gets 15,471 17.1 5.6 non-idle wait count 179,576 198.8 65.3 non-idle wait time 13,256 14.7 4.8 opened cursors cumulative 120,326 133.2 43.8 parse count (describe) 0 0.0 0.0 parse count (failures) 0 0.0 0.0 Instance Activity Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- parse count (hard) 879 1.0 0.3 parse count (total) 118,356 131.0 43.0 parse time cpu 187 0.2 0.1 parse time elapsed 207 0.2 0.1 physical read IO requests 801 0.9 0.3 physical read bytes 6,561,792 7,265.0 2,386.1 physical read total IO requests 9,602 10.6 3.5 physical read total bytes 147,361,792 163,153.1 53,586.1 physical read total multi block 0 0.0 0.0 physical reads 801 0.9 0.3 physical reads cache 131 0.2 0.1 physical reads cache prefetch 0 0.0 0.0 physical reads direct 670 0.7 0.2 physical reads direct (lob) 0 0.0 0.0 physical reads direct temporary 0 0.0 0.0 physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 270,943 300.0 98.5 physical write bytes 3,785,170,944 4,190,789.0 1,376,425.8 physical write total IO requests 287,285 318.1 104.5 physical write total bytes 8,899,066,880 9,852,688.9 3,236,024.3 physical write total multi block 18,184 20.1 6.6 physical writes 462,057 511.6 168.0 physical writes direct 682 0.8 0.3 physical writes direct (lob) 34 0.0 0.0 physical writes direct temporary 0 0.0 0.0 physical writes from cache 461,375 510.8 167.8 physical writes non checkpoint 360,695 399.4 131.2 pinned cursors current 0 0.0 0.0 prefetch warmup blocks aged out 860 1.0 0.3 process last non-idle time 0 0.0 0.0 recursive calls 1,614,235 1,787.2 587.0 recursive cpu usage 1,318 1.5 0.5 redo blocks checksummed by FG (e 2,835,134 3,139.0 1,031.0 redo blocks written 9,856,022 10,912.2 3,584.0 redo buffer allocation retries 1,820 2.0 0.7 redo entries 12,344,681 13,667.5 4,489.0 redo log space requests 2,408 2.7 0.9 redo log space wait time 6,502 7.2 2.4 redo ordering marks 235,740 261.0 85.7 redo size 4,882,438,688 5,405,639.8 1,775,432.3 redo size for direct writes 1,768 2.0 0.6 redo subscn max counts 390,381 432.2 142.0 redo synch time 436 0.5 0.2 redo synch writes 2,761 3.1 1.0 redo wastage 2,232,172 2,471.4 811.7 redo write time 3,157 3.5 1.2 redo writes 8,146 9.0 3.0 rollback changes - undo records 222 0.3 0.1 rollbacks only - consistent read 94 0.1 0.0 rows fetched via callback 2,057 2.3 0.8 session connect time 0 0.0 0.0 session logical reads 31,341,226 34,699.7 11,396.8 shared hash latch upgrades - no 4,531 5.0 1.7 sorts (memory) 4,444 4.9 1.6 sorts (rows) 12,631 14.0 4.6 sql area evicted 0 0.0 0.0 sql area purged 0 0.0 0.0 summed dirty queue length 25 0.0 0.0 switch current to new buffer 1,302 1.4 0.5 table fetch by rowid 7,719 8.6 2.8 Instance Activity Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- table fetch continued row 0 0.0 0.0 table scan blocks gotten 4,932 5.5 1.8 table scan rows gotten 240,721 266.5 87.5 table scans (short tables) 1,324 1.5 0.5 temp space allocated (bytes) 0 0.0 0.0 total cf enq hold time 2,566 2.8 0.9 total number of cf enq holders 934 1.0 0.3 total number of times SMON poste 1 0.0 0.0 transaction rollbacks 108 0.1 0.0 undo change vector size 1,339,003,852 1,482,491.2 486,910.5 user I/O wait time 27 0.0 0.0 user calls 31,737 35.1 11.5 user commits 2,750 3.0 1.0 user rollbacks 0 0.0 0.0 workarea executions - optimal 1,922 2.1 0.7 write clones created in backgrou 4 0.0 0.0 write clones created in foregrou 5,700 6.3 2.1 ------------------------------------------------------------- Instance Activity Stats - Absolute Values DB/Inst: GLDB/gldb Snaps: 801-802 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session uga memory max 750,552,440 817,535,216 session pga memory 510,818,224 550,829,960 session pga memory max 600,194,192 658,073,720 session cursor cache count 13,870 15,066 session uga memory 8.333127925E+11 9.149206806E+11 opened cursors current 134 134 logons current 38 38 ------------------------------------------------------------- Instance Activity Stats - Thread Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 108 430.46 ------------------------------------------------------------- IOStat by Function summary DB/Inst: GLDB/gldb Snaps: 801-802 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> ordered by (Data Read + Write) desc Reads: Reqs Data Writes: Reqs Data Waits: Avg Function Name Data per sec per sec Data per sec per sec Count Tm(ms) --------------- ------- ------- ------- ------- ------- ------- ------- ------- LGWR 99M 7.2 .109608 4.7G 15.9 5.36972 7836 0.5 DBWR 0M 0.0 0M 3.5G 299.2 3.99020 0 N/A Others 36M 2.5 .039857 30M 2.2 .033214 3263 0.8 Direct Reads 5M 0.7 .005535 0M 0.0 0M 0 N/A Direct Writes 0M 0.0 0M 5M 0.7 .005535 0 N/A Buffer Cache Re 1M 0.2 .001107 0M 0.0 0M 148 0.2 TOTAL: 141M 10.6 .156109 8.3G 318.1 9.39867 11.2K 0.6 ------------------------------------------------------------- IOStat by Filetype summary DB/Inst: GLDB/gldb Snaps: 801-802 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> Small Read and Large Read are average service times, in milliseconds -> Ordered by (Data Read + Write) desc Reads: Reqs Data Writes: Reqs Data Small Large Filetype Name Data per sec per sec Data per sec per sec Read Read --------------- ------- ------- ------- ------- ------- ------- ------- ------- Log File 0M 0.2 0M 4.7G 13.5 5.33208 0.4 N/A Data File 7M 0.9 .007750 3.5G 300.0 3.99684 0.7 N/A Control File 134M 9.5 .148359 64M 4.6 .070858 0.7 N/A Temp File 0M 0.0 0M 1M 0.0 .001107 N/A N/A TOTAL: 141M 10.7 .156109 8.3G 318.1 9.40089 0.7 N/A ------------------------------------------------------------- IOStat by Function/Filetype summary DB/Inst: GLDB/gldb Snaps: 801-802 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> Ordered by (Data Read + Write) desc for each function Reads: Reqs Data Writes: Reqs Data Waits: Avg Data per sec per sec Data per sec per sec Count Tm(ms) ------- ------- ------- ------- ------- ------- ------- ------- LGWR 99M 7.2 .109608 4.7G 15.9 5.36972 6756 0.6 LGWR (Log File) 0M 0.2 0M 4.7G 13.5 5.33208 432 0.2 LGWR (Control File) 99M 7.0 .109608 34M 2.4 .037643 6324 0.6 DBWR 0M 0.0 0M 3.5G 299.2 3.99020 0 N/A DBWR (Data File) 0M 0.0 0M 3.5G 299.2 3.99020 0 N/A Others 35M 2.5 .038750 30M 2.2 .033214 2283 0.8 Others (Control File) 35M 2.5 .038750 30M 2.2 .033214 2255 0.8 Others (Data File) 0M 0.0 0M 0M 0.0 0M 28 0.5 Direct Reads 5M 0.7 .005535 0M 0.0 0M 0 N/A Direct Reads (Data File) 5M 0.7 .005535 0M 0.0 0M 0 N/A Direct Writes 0M 0.0 0M 5M 0.7 .005535 0 N/A Direct Writes (Data File) 0M 0.0 0M 5M 0.7 .005535 0 N/A Buffer Cache Reads 1M 0.2 .001107 0M 0.0 0M 153 0.2 Buffer Cache Reads (Data File) 1M 0.2 .001107 0M 0.0 0M 153 0.2 TOTAL: 140M 10.7 .155002 8.3G 318.1 9.39867 9192 0.6 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> ordered by IOs (Reads + Writes) desc Tablespace ------------------------------ Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------- ------- ------------ -------- ---------- ------- GLCOMM 116 0 0.0 1.0 156,740 174 0 0.0 UNDOTBS1 108 0 0.0 1.0 112,347 124 0 0.0 SYSAUX 211 0 0.1 1.0 1,168 1 0 0.0 SYSTEM 109 0 0.0 1.0 462 1 0 0.0 EXAMPLE 108 0 0.0 1.0 108 0 0 0.0 USERS 108 0 0.0 1.0 108 0 0 0.0 TEMP 0 0 0.0 N/A 10 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------- ------- ------------ -------- ---------- ------- EXAMPLE D:\ORACLE\ORADATA\GLDB\EXAMPLE01.DBF 108 0 0.0 1.0 108 0 0 0.0 GLCOMM D:\ORACLE\ORADATA\GLDB\GLCOMM01.DBF 116 0 0.0 1.0 156,740 174 0 0.0 SYSAUX D:\ORACLE\ORADATA\GLDB\SYSAUX01.DBF 211 0 0.1 1.0 1,168 1 0 0.0 SYSTEM D:\ORACLE\ORADATA\GLDB\SYSTEM01.DBF 109 0 0.0 1.0 462 1 0 0.0 TEMP D:\ORACLE\ORADATA\GLDB\TEMP01.DBF 0 0 N/A N/A 10 0 0 N/A UNDOTBS1 D:\ORACLE\ORADATA\GLDB\UNDOTBS01.DBF 108 0 0.0 1.0 112,347 124 0 0.0 USERS D:\ORACLE\ORADATA\GLDB\USERS01.DBF 108 0 0.0 1.0 108 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: GLDB/gldb Snaps: 801-802 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k Free Writ Buffer Number of Pool Buffer Physical Physical Buff Comp Busy P Buffers Hit% Gets Reads Writes Wait Wait Waits --- ---------- ---- ------------ ------------ ----------- ------ ------ -------- D 283,680 100 31,341,148 124 461,375 0 0 0 ------------------------------------------------------------- Checkpoint Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Physical Writes: 462,057 Other Autotune Thread MTTR Log Size Log Ckpt Settings Ckpt Ckpt Writes Writes Writes Writes Writes Writes ----------- ----------- ----------- ----------- ----------- ----------- 0 443,812 0 0 0 17,461 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> B: Begin Snapshot, E: End Snapshot Estd Targt Estd Log Ckpt Log Ckpt Opt RAC MTTR MTTR Recovery Actual Target Log Sz Timeout Interval Log Avail (s) (s) Estd IOs RedoBlks RedoBlks RedoBlks RedoBlks RedoBlks Sz(M) Time - ----- ----- -------- -------- -------- -------- -------- -------- ------ ----- B 0 12 9056 165665 165888 165888 412181 N/A N/A N/A E 0 11 8785 177427 165888 165888 452802 N/A N/A N/A ------------------------------------------------------------- MTTR Advisory DB/Inst: GLDB/gldb Snap: 802 No data exists for this section of the report. ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: GLDB/gldb Snap: 802 -> Only rows with estimated physical reads >0 are displayed -> ordered by Block Size, Buffers For Estimate Est Phys Estimated Est Size for Size Buffers Read Phys Reads Est Phys %DBtime P Est (M) Factor (thousands) Factor (thousands) Read Time for Rds --- -------- ------ ------------ ------ -------------- ------------ ------- D 224 .1 28 1.2 42 1 11.0 D 448 .2 55 1.2 41 1 10.0 D 672 .3 83 1.0 36 1 8.0 D 896 .4 110 1.0 35 1 8.0 D 1,120 .5 138 1.0 35 1 8.0 D 1,344 .6 165 1.0 35 1 8.0 D 1,568 .7 193 1.0 35 1 8.0 D 1,792 .8 221 1.0 34 1 8.0 D 2,016 .9 248 1.0 34 1 8.0 D 2,240 1.0 276 1.0 34 1 8.0 D 2,304 1.0 284 1.0 34 1 8.0 D 2,464 1.1 303 1.0 34 1 8.0 D 2,688 1.2 331 1.0 34 1 8.0 D 2,912 1.3 359 1.0 34 1 8.0 D 3,136 1.4 386 1.0 34 1 8.0 D 3,360 1.5 414 1.0 34 1 8.0 D 3,584 1.6 441 1.0 34 1 8.0 D 3,808 1.7 469 1.0 34 1 8.0 D 4,032 1.8 496 1.0 34 1 8.0 D 4,256 1.8 524 1.0 34 1 8.0 D 4,480 1.9 552 1.0 34 1 8.0 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: GLDB/gldb Snaps: 801-802 -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ------------------ -------------------------- 100.0 43 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: GLDB/gldb Snaps: 801-802 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 1,884 1,884 0 0 64K 128K 2 2 0 0 512K 1024K 28 28 0 0 1M 2M 6 6 0 0 4M 8M 2 2 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: GLDB/gldb Snap: 802 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd P Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overallo Estd Est (MB) Factr Processed Written to Disk Hit % Count Time ---------- ------- ---------------- ---------------- ------ -------- ------- 246 0.1 618.5 0.0 100.0 0 1.1E+05 492 0.3 618.5 0.0 100.0 0 1.1E+05 984 0.5 618.5 0.0 100.0 0 1.1E+05 1,476 0.8 618.5 0.0 100.0 0 1.1E+05 1,968 1.0 618.5 0.0 100.0 0 1.1E+05 2,362 1.2 618.5 0.0 100.0 0 1.1E+05 2,755 1.4 618.5 0.0 100.0 0 1.1E+05 3,149 1.6 618.5 0.0 100.0 0 1.1E+05 3,542 1.8 618.5 0.0 100.0 0 1.1E+05 3,936 2.0 618.5 0.0 100.0 0 1.1E+05 5,904 3.0 618.5 0.0 100.0 0 1.1E+05 7,872 4.0 618.5 0.0 100.0 0 1.1E+05 11,808 6.0 618.5 0.0 100.0 0 1.1E+05 15,744 8.0 618.5 0.0 100.0 0 1.1E+05 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: GLDB/gldb Snap: 802 -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor -> Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid. Est LC Est LC Est LC Est LC Shared SP Est LC Time Time Load Load Est LC Pool Size Size Est LC Saved Saved Time Time Mem Obj Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Hits (K) -------- ----- -------- ------------ -------- ------ ------- ------ ------------ 192 .3 20 1,485 3,123 1.0 51 1.8 1,445 256 .4 84 5,602 3,130 1.0 44 1.6 4,676 320 .6 147 8,194 3,146 1.0 28 1.0 4,679 384 .7 197 10,325 3,146 1.0 28 1.0 4,679 448 .8 209 11,078 3,146 1.0 28 1.0 4,679 512 .9 209 11,078 3,146 1.0 28 1.0 4,679 576 1.0 209 11,078 3,146 1.0 28 1.0 4,679 640 1.1 209 11,078 3,146 1.0 28 1.0 4,679 704 1.2 209 11,078 3,146 1.0 28 1.0 4,679 768 1.3 209 11,078 3,146 1.0 28 1.0 4,679 832 1.4 209 11,078 3,146 1.0 28 1.0 4,679 896 1.6 209 11,078 3,146 1.0 28 1.0 4,679 960 1.7 209 11,078 3,146 1.0 28 1.0 4,679 1,024 1.8 209 11,078 3,146 1.0 28 1.0 4,679 1,088 1.9 209 11,078 3,146 1.0 28 1.0 4,679 1,152 2.0 209 11,078 3,146 1.0 28 1.0 4,679 ------------------------------------------------------------- SGA Target Advisory DB/Inst: GLDB/gldb Snap: 802 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 736 0.3 678 42,310 1,472 0.5 675 34,640 2,208 0.8 675 34,431 2,944 1.0 675 34,209 3,680 1.3 675 34,206 4,416 1.5 675 34,192 5,152 1.8 675 34,192 5,888 2.0 675 34,192 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: GLDB/gldb Snap: 802 No data exists for this section of the report. ------------------------------------------------------------- Java Pool Advisory DB/Inst: GLDB/gldb Snap: 802 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Enqueue Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> only enqueues with waits are shown -> Enqueue stats gathered prior to 10g should not be compared with 10g data -> ordered by Wait Time desc, Waits desc Enqueue Type (Request Reason) ------------------------------------------------------------------------------ Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) ------------ ------------ ----------- ----------- ------------ -------------- CF-Controlfile Transaction 2,386 2,384 2 101 1 8.42 ------------------------------------------------------------- Undo Segment Summary DB/Inst: GLDB/gldb Snaps: 801-802 -> Min/Max TR (mins) - Min and Max Tuned Retention (minutes) -> STO - Snapshot Too Old count, OOS - Out of Space count -> Undo segment block stats: -> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed -> eS - expired Stolen, eR - expired Released, eU - expired reUsed Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/ TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU ---- ---------- --------------- -------- -------- --------- ----- -------------- 2 152.2 117,061 710 4 26.9/26.9 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> Most recent 35 Undostat rows, ordered by Time desc Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/ End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU ------------ ----------- ------------ ------- ------- ------- ----- ------------ 16-Oct 13:08 152,210 117,061 710 4 27 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ AQ deq hash table latch 1 0.0 0 0 N/A AQ dequeue txn counter l 780 0.0 0 0 N/A ASM db client latch 738 0.0 0 0 N/A ASM map operation hash t 1 0.0 0 0 N/A ASM network state latch 109 0.0 0 0 N/A AWR Alerted Metric Eleme 6,441 0.0 0 0 N/A Change Notification Hash 300 0.0 0 0 N/A Consistent RBA 8,258 0.0 0.0 0 0 N/A DML lock allocation 250,983 0.0 0 0 N/A Event Group Locks 52 0.0 0 0 N/A FOB s.o list latch 134 0.0 0 0 N/A File State Object Pool P 1 0.0 0 0 N/A IPC stats buffer allocat 1 0.0 0 0 N/A In memory undo latch 65,692 0.0 1.0 0 3,439 0.0 JS Sh mem access 3 0.0 0 0 N/A JS broadcast autostart l 17 0.0 0 0 N/A JS mem alloc latch 2 0.0 0 0 N/A JS queue access latch 3 0.0 0 0 N/A JS queue state obj latch 6,658 0.0 0 0 N/A JS slv state obj latch 177 0.0 0 0 N/A KFC FX Hash Latch 1 0.0 0 0 N/A KFC Hash Latch 1 0.0 0 0 N/A KFCL LE Freelist 1 0.0 0 0 N/A KGNFS-NFS:SHM structure 1 0.0 0 0 N/A KGNFS-NFS:SVR LIST 1 0.0 0 0 N/A KJC message pool free li 1 0.0 0 0 N/A KJCT flow control latch 1 0.0 0 0 N/A KMG MMAN ready and start 300 0.0 0 0 N/A KTF sga latch 5 0.0 0 302 0.0 KWQMN job cache list lat 11 0.0 0 0 N/A KWQS pqueue ctx latch 21 0.0 0 0 N/A Locator state objects po 1 0.0 0 0 N/A Lsod array latch 1 0.0 0 0 N/A MQL Tracking Latch 0 N/A 0 18 0.0 Memory Management Latch 1 0.0 0 300 0.0 Memory Queue 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Subscriber 1 0.0 0 0 N/A MinActiveScn Latch 5 0.0 0 0 N/A Mutex 1 0.0 0 0 N/A Mutex Stats 1 0.0 0 0 N/A OS process 364 0.0 0 0 N/A OS process allocation 542 0.0 0 0 N/A OS process: request allo 102 0.0 0 0 N/A PL/SQL warning settings 572 0.0 0 0 N/A PX hash array latch 1 0.0 0 0 N/A QMT 1 0.0 0 0 N/A Real-time plan statistic 15 0.0 0 0 N/A SGA IO buffer pool latch 6,873 0.0 0 12,516 0.0 SGA blob parent 1 0.0 0 0 N/A SGA bucket locks 1 0.0 0 0 N/A SGA heap locks 1 0.0 0 0 N/A SGA pool locks 1 0.0 0 0 N/A SQL memory manager latch 31 0.0 0 300 0.0 SQL memory manager worka 21,052 0.0 0 0 N/A Shared B-Tree 114 0.0 0 0 N/A Streams Generic 1 0.0 0 0 N/A Latch Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ Testing 1 0.0 0 0 N/A Token Manager 1 0.0 0 0 N/A WCR: sync 1 0.0 0 0 N/A Write State Object Pool 1 0.0 0 0 N/A X$KSFQP 1 0.0 0 0 N/A XDB NFS Security Latch 1 0.0 0 0 N/A XDB unused session pool 1 0.0 0 0 N/A XDB used session pool 1 0.0 0 0 N/A active checkpoint queue 13,997 0.0 0 0 N/A active service list 2,191 0.1 0.0 0 1,017 0.0 begin backup scn array 34 0.0 0 0 N/A buffer pool 1 0.0 0 0 N/A business card 1 0.0 0 0 N/A cache buffer handles 53 0.0 0 0 N/A cache buffers chains 126,018,209 0.0 0.1 0 367,909 0.0 cache buffers lru chain 469,759 0.0 0.0 0 822,397 0.0 call allocation 493 0.4 0.0 0 0 N/A cas latch 1 0.0 0 0 N/A change notification clie 1 0.0 0 0 N/A channel handle pool latc 107 0.0 0 0 N/A channel operations paren 6,950 0.0 0 0 N/A checkpoint queue latch 726,366 0.0 0.0 0 460,726 0.0 client/application info 1,409 0.0 0 0 N/A compile environment latc 70 0.0 0 0 N/A corrupted undo seg latch 774 0.0 0 0 N/A cp cmon/server latch 1 0.0 0 0 N/A cp pool latch 1 0.0 0 0 N/A cp server hash latch 1 0.0 0 0 N/A cp sga latch 109 0.0 0 0 N/A cvmap freelist lock 1 0.0 0 0 N/A deferred cleanup latch 109 0.0 0 0 N/A dml lock allocation 109 0.0 0 0 N/A done queue latch 1 0.0 0 0 N/A dummy allocation 141 0.0 0 0 N/A enqueue hash chains 865,961 0.0 0.0 0 0 N/A enqueues 89,143 0.0 0 0 N/A fifth spare latch 1 0.0 0 0 N/A file cache latch 578 0.0 0 0 N/A flashback copy 1 0.0 0 0 N/A gc element 1 0.0 0 0 N/A gcs commit scn state 1 0.0 0 0 N/A gcs partitioned table ha 1 0.0 0 0 N/A gcs pcm hashed value buc 1 0.0 0 0 N/A gcs resource freelist 1 0.0 0 0 N/A gcs resource hash 1 0.0 0 0 N/A gcs resource scan list 1 0.0 0 0 N/A gcs shadows freelist 1 0.0 0 0 N/A ges domain table 1 0.0 0 0 N/A ges enqueue table freeli 1 0.0 0 0 N/A ges group table 1 0.0 0 0 N/A ges process hash list 1 0.0 0 0 N/A ges process parent latch 1 0.0 0 0 N/A ges resource hash list 1 0.0 0 0 N/A ges resource scan list 1 0.0 0 0 N/A ges resource table freel 1 0.0 0 0 N/A ges value block free lis 1 0.0 0 0 N/A global KZLD latch for me 16 0.0 0 0 N/A global tx hash mapping 1 0.0 0 0 N/A granule operation 1 0.0 0 0 N/A hash table column usage 105 0.0 0 7,508 0.0 Latch Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ hash table modification 10 0.0 0 0 N/A heartbeat check 1 0.0 0 0 N/A intra txn parallel recov 1 0.0 0 0 N/A io pool granule metadata 1 0.0 0 0 N/A job workq parent latch 20 0.0 0 19 0.0 job_queue_processes free 42 0.0 0 0 N/A job_queue_processes para 216 0.0 0 0 N/A k2q lock allocation 1 0.0 0 0 N/A kcbtsemkid latch 108 0.0 0 0 N/A kdlx hb parent latch 1 0.0 0 0 N/A kgb parent 1 0.0 0 0 N/A kks stats 1,758 0.0 0 0 N/A kokc descriptor allocati 286 0.0 0 0 N/A ksfv messages 1 0.0 0 0 N/A kss move lock 15 0.0 0 0 N/A ksuosstats global area 63 0.0 0 0 N/A ksv allocation latch 137 0.0 0 0 N/A ksv class latch 29 0.0 0 0 N/A ksv msg queue latch 1 0.0 0 0 N/A ksz_so allocation latch 102 0.0 0 0 N/A ktm global data 7 0.0 0 0 N/A kwqbsn:qsga 44 0.0 0 0 N/A lgwr LWN SCN 8,225 0.3 0.0 0 0 N/A list of block allocation 56,536 0.0 0 0 N/A loader state object free 1,424 0.0 0 0 N/A lob segment dispenser la 1 0.0 0 0 N/A lob segment hash table l 3 0.0 0 0 N/A lob segment query latch 1 0.0 0 0 N/A lock DBA buffer during m 1 0.0 0 0 N/A logical standby cache 1 0.0 0 0 N/A logminer context allocat 1 0.0 0 0 N/A logminer work area 1 0.0 0 0 N/A longop free list parent 1 0.0 0 0 N/A mapped buffers lru chain 1 0.0 0 0 N/A message pool operations 125 0.0 0 0 N/A messages 61,369 0.0 0.0 0 0 N/A mostly latch-free SCN 8,305 1.0 0.0 0 0 N/A msg queue latch 1 0.0 0 0 N/A name-service namespace b 1 0.0 0 0 N/A ncodef allocation latch 109 0.0 0 0 N/A object queue header heap 51,362 0.0 0 233 0.0 object queue header oper 2,071,118 0.0 0.0 0 0 N/A object stats modificatio 12 0.0 0 0 N/A parallel query alloc buf 121 0.0 0 0 N/A parallel query stats 1 0.0 0 0 N/A parameter list 52 0.0 0 0 N/A parameter table manageme 142 0.0 0 0 N/A peshm 1 0.0 0 0 N/A pesom_free_list 1 0.0 0 0 N/A pesom_hash_node 1 0.0 0 0 N/A post/wait queue 5,074 0.0 0 3,491 0.0 process allocation 137 0.0 0 51 0.0 process group creation 102 0.0 0 0 N/A process queue 1 0.0 0 0 N/A process queue reference 1 0.0 0 0 N/A qmn task queue latch 132 1.5 0.0 0 0 N/A query server freelists 1 0.0 0 0 N/A queued dump request 3 0.0 0 0 N/A queuing load statistics 1 0.0 0 0 N/A recovery domain hash lis 1 0.0 0 0 N/A Latch Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ redo allocation 49,070 0.2 0.0 0 12,346,115 0.0 redo copy 1 0.0 0 12,346,243 0.0 redo writing 41,063 0.0 0.0 0 0 N/A resmgr group change latc 304 0.0 0 0 N/A resmgr:active threads 146 0.0 0 0 N/A resmgr:actses change gro 53 0.0 0 0 N/A resmgr:actses change sta 6 0.0 0 0 N/A resmgr:free threads list 140 1.4 0.0 0 0 N/A resmgr:plan CPU method 1 0.0 0 0 N/A resmgr:resource group CP 1 0.0 0 0 N/A resmgr:schema config 1 0.0 0 0 N/A resmgr:session queuing 1 0.0 0 0 N/A rm cas latch 1 0.0 0 0 N/A row cache objects 904,104 0.0 0 0 N/A second spare latch 1 0.0 0 0 N/A sequence cache 6,984,750 0.0 0.0 0 0 N/A session allocation 78,412 0.0 0 26,137 0.0 session idle bit 89,542 0.0 0 0 N/A session queue latch 1 0.0 0 0 N/A session state list latch 136 0.0 0 0 N/A session switching 365 0.0 0 0 N/A session timer 362 0.0 0 0 N/A shared pool 64,693 0.1 0.0 0 0 N/A shared pool sim alloc 65 0.0 0 0 N/A shared pool simulator 2,689 0.0 0 0 N/A sim partition latch 1 0.0 0 0 N/A simulator hash latch 1,511,994 0.0 0.0 0 0 N/A simulator lru latch 237,325 0.0 0.0 0 1,230,847 0.0 sort extent pool 146 0.0 0 0 N/A space background task la 663 0.0 0 600 0.0 state object free list 2 0.0 0 0 N/A statistics aggregation 560 0.0 0 0 N/A tablespace key chain 1 0.0 0 0 N/A temp lob duration state 4 0.0 0 0 N/A test excl. parent l0 1 0.0 0 0 N/A test excl. parent2 l0 1 0.0 0 0 N/A third spare latch 1 0.0 0 0 N/A threshold alerts latch 30 0.0 0 0 N/A transaction allocation 4,556 0.0 0 0 N/A undo global data 905,122 0.0 0 0 N/A virtual circuit buffers 1 0.0 0 0 N/A virtual circuit holder 1 0.0 0 0 N/A virtual circuit queues 1 0.0 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: GLDB/gldb Snaps: 801-802 -> ordered by misses desc Get Spin Latch Name Requests Misses Sleeps Gets -------------------------- --------------- ------------ ----------- ----------- object queue header operat 2,071,118 226 3 223 cache buffers chains 126,018,209 42 4 38 In memory undo latch 65,692 2 2 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: GLDB/gldb Snaps: 801-802 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- In memory undo latch ktiFlush: child 0 1 0 In memory undo latch kticflush_2 0 1 0 cache buffers chains kcbget: pin buffer 0 3 0 cache buffers chains kcbbxsv 0 1 4 object queue header oper kcbo_unlink_q 0 2 0 object queue header oper kcbo_switch_cq 0 1 0 ------------------------------------------------------------- Mutex Sleep Summary DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Parent Latch Statistics DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Logical Reads: 31,341,226 -> Captured Segments account for 96.9% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 6,921,760 22.09 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 6,858,576 21.88 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 6,810,864 21.73 SYSTEM GLCOMM PK_GLT_PROT_TRAFFIC_ INDEX 6,798,240 21.69 SYSTEM GLCOMM GLT_PROT_TRAFFIC_SUM TABLE 2,725,120 8.70 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Physical Reads: 801 -> Captured Segments account for 7.2% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_SQL_PLAN TABLE 12 1.50 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 8 1.00 SYS SYSAUX WRH$_SQLTEXT TABLE 6 .75 SYS SYSAUX WRH$_SYSMETRIC_HISTO INDEX 6 .75 SYS SYSAUX SYS_LOB0000006207C00 LOB 5 .62 ------------------------------------------------------------- Segments by Physical Read Requests DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Physical Read Requests: 801 -> Captured Segments account for 7.2% of Total Tablespace Subobject Obj. Phys Read Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_SQL_PLAN TABLE 12 1.50 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 8 1.00 SYS SYSAUX WRH$_SQLTEXT TABLE 6 .75 SYS SYSAUX WRH$_SYSMETRIC_HISTO INDEX 6 .75 SYS SYSAUX SYS_LOB0000006207C00 LOB 5 .62 ------------------------------------------------------------- Segments by UnOptimized Reads DB/Inst: GLDB/gldb Snaps: 801-802 -> Total UnOptimized Read Requests: 801 -> Captured Segments account for 7.2% of Total Tablespace Subobject Obj. UnOptimized Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_SQL_PLAN TABLE 12 1.50 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 8 1.00 SYS SYSAUX WRH$_SQLTEXT TABLE 6 .75 SYS SYSAUX WRH$_SYSMETRIC_HISTO INDEX 6 .75 SYS SYSAUX SYS_LOB0000006207C00 LOB 5 .62 ------------------------------------------------------------- Segments by Optimized Reads DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Segments by Direct Physical Reads DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Segments by Physical Writes DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Physical Writes: 462,057 -> Captured Segments account for 55.7% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSTEM GLCOMM GLT_PROT_TRAFFIC_SUM TABLE 122,889 26.60 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 64,612 13.98 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 58,097 12.57 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 6,071 1.31 SYSTEM GLCOMM PK_GLT_PROT_TRAFFIC_ INDEX 4,621 1.00 ------------------------------------------------------------- Segments by Physical Write Requests DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Physical Write Requestss: 270,943 -> Captured Segments account for 58.2% of Total Tablespace Subobject Obj. Phys Write Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSTEM GLCOMM GLT_PROT_TRAFFIC_SUM TABLE 72,437 26.74 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 40,114 14.81 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 39,070 14.42 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 2,907 1.07 SYSTEM GLCOMM PK_GLT_PROT_TRAFFIC_ INDEX 2,047 .76 ------------------------------------------------------------- Segments by Direct Physical Writes DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Direct Physical Writes: 682 -> Captured Segments account for 5.0% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX SYS_LOB0000006213C00 LOB 25 3.67 SYS SYSAUX SYS_LOB0000006207C00 LOB 9 1.32 ------------------------------------------------------------- Segments by Table Scans DB/Inst: GLDB/gldb Snaps: 801-802 -> Total Table Scans: 4 -> Captured Segments account for 25.0% of Total Tablespace Subobject Obj. Table Owner Name Object Name Name Type Scans %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSMAN SYSAUX MGMT_CURRENT_METRICS INDEX 1 25.00 ------------------------------------------------------------- Segments by DB Blocks Changes DB/Inst: GLDB/gldb Snaps: 801-802 -> % of Capture shows % of DB Block Changes for each top segment compared -> with total DB Block Changes for all segments captured by the Snapshot Tablespace Subobject Obj. DB Block % of Owner Name Object Name Name Type Changes Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSTEM GLCOMM GLT_PROT_TRAFFIC_SUM TABLE 2,783,600 22.43 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 2,470,032 19.90 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 2,432,192 19.59 SYSTEM GLCOMM GLI_TRAFFIC_SUM_VOIP INDEX 2,311,040 18.62 SYSTEM GLCOMM PK_GLT_PROT_TRAFFIC_ INDEX 2,294,528 18.49 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Segments by ITL Waits DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: GLDB/gldb Snaps: 801-802 -> "Pct Misses" should be very low (< 2% in most cases) -> "Final Usage" is the number of cache entries being used Get Pct Scan Pct Mod Final Cache Requests Miss Reqs Miss Reqs Usage ------------------------- ------------ ------ ------- ----- -------- ---------- dc_awr_control 19 0.0 0 N/A 2 1 dc_files 6 0.0 0 N/A 0 6 dc_global_oids 1,046 0.0 0 N/A 0 100 dc_histogram_data 98 0.0 0 N/A 0 2,337 dc_histogram_defs 17,036 0.0 0 N/A 0 5,333 dc_object_grants 107 0.0 0 N/A 0 156 dc_objects 7,092 0.0 0 N/A 5 2,756 dc_profiles 53 0.0 0 N/A 0 2 dc_rollback_segments 203 0.0 0 N/A 0 22 dc_segments 4,179 0.0 0 N/A 59 1,189 dc_sequences 112,656 0.0 0 N/A 112,656 11 dc_tablespaces 2,153 0.0 0 N/A 0 8 dc_users 6,240 0.0 0 N/A 0 109 global database name 661 0.0 0 N/A 0 1 outstanding_alerts 5 0.0 0 N/A 0 6 sch_lj_oids 2 0.0 0 N/A 0 3 ------------------------------------------------------------- Library Cache Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- APP CONTEXT 35 0.0 35 0.0 0 0 BODY 308 0.0 2,013 0.0 0 0 CLUSTER 12 0.0 3 0.0 0 0 DBLINK 33 0.0 0 N/A 0 0 EDITION 42 0.0 77 0.0 0 0 QUEUE 2,296 0.0 2,736 0.0 0 0 SCHEMA 51 0.0 0 N/A 0 0 SQL AREA 3,457 76.2 265,146 1.0 0 0 SUBSCRIPTION 2 0.0 2 0.0 0 0 TABLE/PROCEDURE 2,990 0.0 2,261,657 0.0 0 0 TRIGGER 212 0.0 240 0.0 0 0 ------------------------------------------------------------- Memory Dynamic Components DB/Inst: GLDB/gldb Snaps: 801-802 -> Min/Max sizes since instance startup -> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred -> ordered by Component Begin Snap Current Min Max Oper Last Op Component Size (Mb) Size (Mb) Size (Mb) Size (Mb) Count Typ/Mod --------------- ----------- ----------- ----------- ----------- ------ ------- ASM Buffer Cach .00 .00 .00 .00 0 STA/ DEFAULT 16K buf .00 .00 .00 .00 0 STA/ DEFAULT 2K buff .00 .00 .00 .00 0 STA/ DEFAULT 32K buf .00 .00 .00 .00 0 STA/ DEFAULT 4K buff .00 .00 .00 .00 0 STA/ DEFAULT 8K buff .00 .00 .00 .00 0 STA/ DEFAULT buffer 2,304.00 2,304.00 2,304.00 2,304.00 0 INI/IMM KEEP buffer cac .00 .00 .00 .00 0 STA/ PGA Target 1,968.00 1,968.00 1,968.00 1,968.00 0 STA/ RECYCLE buffer .00 .00 .00 .00 0 STA/ SGA Target 2,944.00 2,944.00 2,944.00 2,944.00 0 STA/ Shared IO Pool .00 .00 .00 .00 0 STA/ java pool 16.00 16.00 16.00 16.00 0 STA/ large pool 16.00 16.00 .00 16.00 0 GRO/IMM shared pool 576.00 576.00 576.00 576.00 0 STA/ streams pool .00 .00 .00 .00 0 STA/ ------------------------------------------------------------- Memory Resize Operations Summary DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Memory Resize Ops DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Process Memory Summary DB/Inst: GLDB/gldb Snaps: 801-802 -> B: Begin Snap E: End Snap -> All rows below contain absolute values (i.e. not diffed over the interval) -> Max Alloc is Maximum PGA Allocation size at snapshot time -> Hist Max Alloc is the Historical Max Allocation for still-connected processes -> ordered by Begin/End snapshot, Alloc (MB) desc Hist Avg Std Dev Max Max Alloc Used Alloc Alloc Alloc Alloc Num Num Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc - -------- --------- --------- -------- -------- ------- ------- ------ ------ B Other 87.6 N/A 2.2 3.0 18 18 40 40 Freeable 25.3 .0 1.4 1.7 7 N/A 18 18 PL/SQL 10.2 7.6 .3 .5 2 3 38 38 SQL 1.0 .1 .0 .1 0 6 26 20 E Other 83.2 N/A 2.1 2.5 15 15 40 40 Freeable 30.9 .0 1.5 2.6 12 N/A 20 20 PL/SQL 10.2 7.5 .3 .5 2 3 38 38 SQL .7 .1 .0 .0 0 6 26 20 ------------------------------------------------------------- SGA Memory Summary DB/Inst: GLDB/gldb Snaps: 801-802 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 2,415,919,104 Fixed Size 2,184,632 Redo Buffers 8,364,032 Variable Size 2,701,134,408 ------------------- sum 5,127,602,176 ------------------------------------------------------------- SGA breakdown difference DB/Inst: GLDB/gldb Snaps: 801-802 -> ordered by Pool, Name -> N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot Pool Name Begin MB End MB % Diff ------ ------------------------------ -------------- -------------- ------- java free memory 16.0 16.0 0.00 large PX msg pool 7.5 7.5 0.00 large free memory 8.5 8.5 0.00 shared ASH buffers 8.0 8.0 0.00 shared CCUR 26.0 29.4 13.11 shared FileOpenBlock 10.5 10.5 0.00 shared KGLH0 8.4 8.4 -0.05 shared KGLHD 11.6 13.0 12.00 shared KGLS 15.1 15.1 0.00 shared PCUR 16.7 20.1 20.24 shared PLDIA 6.0 6.0 0.00 shared PLMCD 11.8 11.8 0.00 shared SQLA 122.4 143.1 16.88 shared db_block_hash_buckets 22.3 22.3 0.00 shared free memory 229.3 199.5 -12.98 shared row cache 7.2 7.2 0.00 buffer_cache 2,304.0 2,304.0 0.00 fixed_sga 2.1 2.1 0.00 log_buffer 8.0 8.0 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture Rate DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply Rate DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queue Subscribers DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queues DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queues Rate DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queue Subscribers DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Resource Limit Stats DB/Inst: GLDB/gldb Snap: 802 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Activity DB/Inst: GLDB/gldb Snaps: 801-802 -> Values represent averages for all samples Avg Total Avg Active Avg Total Avg Active Avg Total Avg Active Connections Connections Shared Srvrs Shared Srvrs Dispatchers Dispatchers ------------ ------------ ------------ ------------ ------------ ------------ 0 0 1 0 1 0 ------------------------------------------------------------- Shared Servers Rates DB/Inst: GLDB/gldb Snaps: 801-802 Common Disp Common Disp Server Queue Queue Server Server Queue Queue Total Server Per Sec Per Sec Msgs/Sec KB/Sec Total Total Msgs Total(KB) -------- -------- -------- --------- ---------- ---------- ---------- ---------- 0 0 0 0.0 0 0 0 0 ------------------------------------------------------------- Shared Servers Utilization DB/Inst: GLDB/gldb Snaps: 801-802 -> Statistics are combined for all servers -> Incoming and Outgoing Net % are included in %Busy Total Server Incoming Outgoing Time (s) %Busy %Idle Net % Net % -------------- -------- -------- --------- --------- 903 0.0 100.0 0.0 0.0 ------------------------------------------------------------- Shared Servers Common Queue DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Dispatchers DB/Inst: GLDB/gldb Snaps: 801-802 -> Ordered by %Busy, descending -> Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue -> Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots Avg Total Disp Total Total Queue Avg Queue Name Conns Time (s) %Busy %Idle Queued Wait (s) Wait (ms) ------- --------- ---------- -------- -------- ---------- ----------- ---------- D000 0.0 903 0.0 100.0 0 0 ------------------------------------------------------------- init.ora Parameters DB/Inst: GLDB/gldb Snaps: 801-802 -> if IP/Public/Source at End snap is different a '*' is displayed End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- audit_file_dest D:\ORACLE\ADMIN\GLDB\ADUMP audit_trail DB compatible 11.2.0.0.0 control_files D:\ORACLE\FLASH_RECOVERY_AREA\GLD db_block_size 8192 db_domain db_name gldb db_recovery_file_dest D:\Oracle\flash_recovery_area db_recovery_file_dest_size 4102029312 diagnostic_dest D:\ORACLE dispatchers (PROTOCOL=TCP) (SERVICE=gldbXDB) memory_target 5150605312 open_cursors 300 processes 150 remote_login_passwordfile EXCLUSIVE undo_tablespace UNDOTBS1 ------------------------------------------------------------- Dynamic Remastering Stats DB/Inst: GLDB/gldb Snaps: 801-802 No data exists for this section of the report. ------------------------------------------------------------- End of Report