WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst num Startup Time Release RAC SEPC22162695005sepc221101-Mar-16 09:0311.2.0.1.0NO Host Name Platform CPUs Cores Sockets Memory (GB) sepc221.se.cuhk.edu.hkLinux x86 64-bit84131.04 Snap Id Snap Time Sessions Cursors/Session Begin Snap:305603-Mar-16 13:00:58323.8 End Snap:306904-Mar-16 02:00:34314.0 Elapsed: 779.59 (mins) DB Time: 263.09 (mins) Report Summary Cache Sizes Begin End Buffer Cache:3,584M3,584MStd Block Size:8K Shared Pool Size:3,840M3,840MLog Buffer:147,624K Load Profile Per Second Per Transaction Per Exec Per Call DB Time(s):0.31.60.030.13 DB CPU(s):0.10.30.010.03 Redo size:98,136.2471,437.0 Logical reads:1,047.05,029.6 Block changes:808.93,885.7 Physical reads:301.61,448.7 Physical writes:79.7382.8 User calls:2.612.4 Parses:4.119.4 Hard parses:0.10.3 W/A MB processed:1.99.0 Logons:0.10.4 Executes:10.148.3 Rollbacks:0.00.0 Transactions:0.2 Instance Efficiency Percentages (Target 100%) Buffer Nowait %:100.00Redo NoWait %:99.96 Buffer Hit %:76.31In-memory Sort %:99.98 Library Hit %:99.09Soft Parse %:98.25 Execute to Parse %:59.71Latch Hit %:99.99 Parse CPU to Parse Elapsd %:19.24% Non-Parse CPU:99.86 Shared Pool Statistics Begin End Memory Usage %:12.5413.86 % SQL with executions>1:95.2295.58 % Memory for SQL w/exec>1:91.4090.65 Top 5 Timed Foreground Events Event Waits Time(s) Avg wait (ms) % DB time Wait Class free buffer waits9599,511991760.25Configuration DB CPU 3,149 19.95 direct path write temp67,2141,296198.21User I/O enq: RO - fast object reuse71,0521502876.66Application log file switch (checkpoint incomplete)6329549092.09Configuration Host CPU (CPUs: 8 Cores: 4 Sockets: 1) Load Average Begin Load Average End %User %System %WIO %Idle 0.651.572.00.30.997.7 Instance CPU %Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager) 0.939.70.0 Memory Statistics Begin End Host Mem (MB):31,785.531,785.5 SGA use (MB):8,448.08,448.0 PGA use (MB):121.3388.3 % Host Mem used for SGA+PGA:26.9627.80 Main Report Report Summary Wait Events Statistics SQL Statistics Instance Activity Statistics IO Stats Buffer Pool Statistics Advisory Statistics Wait Statistics Undo Statistics Latch Statistics Segment Statistics Dictionary Cache Statistics Library Cache Statistics Memory Statistics Streams Statistics Resource Limit Statistics Shared Server Statistics init.ora Parameters Back to Top Wait Events Statistics Time Model Statistics Operating System Statistics Operating System Statistics - Detail Foreground Wait Class Foreground Wait Events Background Wait Events Wait Event Histogram Wait Event Histogram Detail (64 msec to 2 sec) Wait Event Histogram Detail (4 sec to 2 min) Wait Event Histogram Detail (4 min to 1 hr) Service Statistics Service Wait Class Stats Back to Top Time Model Statistics Total time in database user-calls (DB Time): 15785.4s 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 time15,540.0098.45 DB CPU3,148.8119.95 parse time elapsed45.620.29 PL/SQL execution elapsed time36.270.23 hard parse elapsed time32.150.20 hard parse (sharing criteria) elapsed time20.550.13 failed parse elapsed time2.210.01 connection management call elapsed time0.870.01 PL/SQL compilation elapsed time0.450.00 repeated bind elapsed time0.120.00 sequence load elapsed time0.070.00 DB time15,785.37 background elapsed time12,955.14 background cpu time234.51 Back to Wait Events Statistics Back to Top Operating System Statistics *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 BUSY_TIME853,130 IDLE_TIME36,483,605 IOWAIT_TIME323,020 NICE_TIME3 SYS_TIME102,704 USER_TIME741,716 LOAD12 PHYSICAL_MEMORY_BYTES33,329,557,504 NUM_CPUS8 NUM_CPU_CORES4 NUM_CPU_SOCKETS1 GLOBAL_RECEIVE_SIZE_MAX4,194,304 GLOBAL_SEND_SIZE_MAX1,048,576 TCP_RECEIVE_SIZE_DEFAULT87,380 TCP_RECEIVE_SIZE_MAX4,194,304 TCP_RECEIVE_SIZE_MIN4,096 TCP_SEND_SIZE_DEFAULT16,384 TCP_SEND_SIZE_MAX4,194,304 TCP_SEND_SIZE_MIN4,096 Back to Wait Events Statistics Back to Top Operating System Statistics - Detail Snap Time Load %busy %user %sys %idle %iowait 03-Mar 13:00:580.65 03-Mar 14:00:030.421.491.250.2298.510.31 03-Mar 15:00:090.611.681.420.2498.320.43 03-Mar 16:00:150.411.501.270.2298.500.29 03-Mar 17:00:210.291.491.250.2198.510.29 03-Mar 18:00:280.201.491.260.2298.510.29 03-Mar 19:00:340.111.491.260.2298.510.28 03-Mar 20:00:400.131.461.230.2198.540.28 03-Mar 21:00:460.361.501.270.2298.500.29 03-Mar 22:00:520.861.931.630.2798.070.65 03-Mar 23:00:571.367.667.330.3092.341.40 04-Mar 00:00:021.662.982.550.3997.022.65 04-Mar 01:00:041.322.522.050.4397.482.00 04-Mar 02:00:341.572.522.060.4297.482.12 Back to Wait Events Statistics Back to Top Foreground Wait Class 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 99.9% of Total DB time 15,785.37 (s) Total FG Wait Time: 12,627.70 (s) DB CPU time: 3,148.81 (s) Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %DB time Configuration1,06659,928931362.89 DB CPU 3,149 19.95 User I/O1,389,80601,41718.98 Application3,14101,0523356.67 Commit3,4080205601.30 Concurrency1500191280.12 Other9,12793610.04 Network94,8140000.00 System I/O15,7210000.00 Back to Wait Events Statistics Back to Top Foreground Wait Events 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 Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % DB time free buffer waits95909,51199170.1060.25 direct path write temp67,21401,296196.908.21 enq: RO - fast object reuse701,0521502870.006.66 log file switch (checkpoint incomplete)60329549090.002.09 log file sync3,4080205600.351.30 db file scattered read91,981011319.450.72 write complete waits7074105840.000.47 buffer busy waits901617880.000.10 log file switch completion350113000.000.07 direct path read temp1,223,392040125.640.03 db file sequential read5,2220310.540.02 ADR block file write6503470.010.02 latch: shared pool11503260.010.02 log file switch (private strand flush incomplete)6034840.000.02 ADR block file read4730350.050.02 direct path sync4011680.000.00 SQL*Net break/reset to client3,1340000.320.00 undo segment extension5396080.010.00 SQL*Net message to client93,7850009.630.00 control file sequential read15,7210001.610.00 enq: CR - block range reuse ckpt400330.000.00 latch: row cache objects200430.000.00 enq: CF - contention100500.000.00 Disk file operations I/O1,9840000.200.00 utl_file I/O50080.000.00 library cache: mutex X180010.000.00 SQL*Net more data from client1,0290000.110.00 asynch descriptor resize8,453100000.870.00 reliable message110000.000.00 SQL*Net message from client93,7850226,54724169.63 jobq slave wait100,42810050,29650110.31 wait for unread message on broadcast channel47,4149846,7689864.87 Streams AQ: waiting for messages in the queue9,36010046,73849930.96 PL/SQL lock timer1100110000.00 Back to Wait Events Statistics Back to Top Background Wait Events 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 Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % bg time db file async I/O submit7,157010,62614850.7482.02 control file parallel write19,04701,320691.9610.19 log file parallel write22,5600551242.324.25 free buffer waits150165110000.001.27 log file switch (checkpoint incomplete)20108541440.000.84 buffer busy waits1104944880.000.38 os thread startup1,904031170.200.24 db file single write245014570.030.11 log file single write10206600.010.05 ADR block file write6503420.010.02 log file sync2902580.000.01 ADR block file read1690290.020.01 latch: shared pool6401190.010.01 control file sequential read63,5500106.530.01 enq: CF - contention8011310.000.01 direct path sync7011290.000.01 db file sequential read6660110.070.01 log file switch completion2013310.000.01 reliable message1,1210000.120.00 rdbms ipc reply1,1140000.110.00 undo segment extension5800120.000.00 enq: JS - queue lock100200.000.00 Disk file operations I/O7680000.080.00 asynch descriptor resize2,965100000.300.00 LGWR wait for redo copy420000.000.00 log file sequential read1020000.010.00 rdbms ipc message207,00193548,658265121.26 DIAG idle wait93,44910093,53110019.60 Streams AQ: waiting for time management or cleanup tasks734948,2336607220.01 dispatcher timer78010046,808600100.08 shared server idle wait1,55910046,785300100.16 Streams AQ: qmn coordinator idle wait3,3405046,775140040.34 Streams AQ: qmn slave idle wait1,707046,775274020.18 pmon timer16,4969446,77028351.69 Space Manager: slave idle wait9,36810046,77049930.96 smon timer1797846,7372611030.02 VKRM Idle1014,400143998840.00 SQL*Net message from client2,6940100.28 class slave wait2620000.03 Back to Wait Events Statistics Back to Top Wait Event Histogram 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 Event Total Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s ADR block file read64266.4.51.15.58.913.93.9 ADR block file write130 9.23.839.247.7 ADR file lock156100.0 Disk file operations I/O2752100.0 LGWR wait for redo copy42100.0 SQL*Net break/reset to client3134100.0 .0 SQL*Net message to client95.8K100.0 SQL*Net more data from client1044100.0 SQL*Net more data to client15100.0 asynch descriptor resize11.4K100.0 buffer busy waits2080.0 5.015.0 buffer deadlock4100.0 control file parallel write19K 5.67.886.6 control file sequential read79.3K100.0 .0.0.0 cr request retry30100.0 db file async I/O submit7158 .0.48.118.560.113.0 db file scattered read92K85.910.61.1.1.41.0.9 db file sequential read591796.4.1.2.61.11.2.5 db file single write245 2.98.25.383.7 direct path read4100.0 direct path read temp1223.4K100.0 .0 direct path sync11 100.0 direct path write25100.0 direct path write temp67.2K.1.0.16.668.610.314.2 enq: CF - contention911.1 11.1 77.8 enq: CR - block range reuse ckpt4 50.050.0 enq: JS - queue lock1 100.0 enq: RO - fast object reuse6 66.733.3 free buffer waits974 3.7 1.794.6 latch free12100.0 latch: In memory undo latch4100.0 latch: cache buffers chains6100.0 latch: cache buffers lru chain38100.0 latch: call allocation20100.0 latch: object queue header operation24100.0 latch: row cache objects2 100.0 latch: shared pool1798.41.12.210.115.635.826.8 library cache: mutex X1894.4 5.6 lock deadlock retry2100.0 log file parallel write22.6K50.0 .21.89.811.426.7.0 log file sequential read102100.0 log file single write102 1.010.89.878.4 log file switch (checkpoint incomplete)8 12.587.5 log file switch (private strand flush incomplete)6 100.0 log file switch completion37 94.65.4 log file sync3437 .55.214.611.967.8 os thread startup1904 68.828.32.9 rdbms ipc reply111499.9 .1 reliable message113299.6.1 .1 .2 undo segment extension5850.0 36.28.65.2 utl_file I/O580.0 20.0 write complete waits7 100.0 DIAG idle wait93.4K 100.0 PL/SQL lock timer1 100.0 SQL*Net message from client96.5K89.5.8.0.0.0.0.29.4 Space Manager: slave idle wait9368.0 .0.199.9 Streams AQ: qmn coordinator idle wait334250.0 50.0 Streams AQ: qmn slave idle wait17082.2 97.8 Streams AQ: waiting for messages in the queue9360 .0 .199.9 Streams AQ: waiting for time management or cleanup tasks7323.3 23.353.4 VKRM Idle1 100.0 class slave wait262100.0 dispatcher timer780 100.0 jobq slave wait100.4K .0.0.0100.0 pmon timer16.5K5.3 .0.0.1.0.194.4 rdbms ipc message207K2.3.1.1.2.3.425.770.9 shared server idle wait1559 100.0 smon timer179.6 .698.9 wait for unread message on broadcast channel47.4K.0.2.9.2.0.098.6 Back to Wait Events Statistics Back to Top Wait Event Histogram Detail (64 msec to 2 sec) 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 Event Waits 64ms to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s ADR block file read2596.13.6.3 ADR block file write6252.323.123.11.5 buffer busy waits180.0 5.0 15.0 control file parallel write16.5K13.437.543.25.7.2.0 control file sequential read6100.0.0.0 db file async I/O submit434326.917.117.614.46.94.0.612.4 db file scattered read83399.1.5.3.0.0 db file sequential read2999.5.4.0.0 db file single write20516.355.925.72.0 direct path read temp1100.0.0 direct path sync11 63.627.39.1 direct path write temp957185.89.93.9.4.0.0 enq: CF - contention722.222.211.133.311.1 enq: CR - block range reuse ckpt250.050.0 enq: RO - fast object reuse4 16.733.316.7 33.3 free buffer waits373.7.1.2.1.4.92.192.5 latch: row cache objects2 100.0 latch: shared pool4873.225.11.7 log file parallel write603673.212.512.41.6.1.0.0.0 log file single write8021.633.343.12.0 log file switch (checkpoint incomplete)1 12.5 87.5 log file switch (private strand flush incomplete)6 16.750.033.3 log file switch completion37 18.937.835.12.75.4 log file sync233132.226.135.75.7.2.1 os thread startup5697.12.2.7 rdbms ipc reply199.9 .1 reliable message299.8.1.1 undo segment extension394.83.41.7 utl_file I/O180.020.0 write complete waits1 14.385.7 Back to Wait Events Statistics Back to Top Wait Event Histogram Detail (4 sec to 2 min) 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 Event Waits 4s to 2m <2s <4s <8s <16s <32s < 1m < 2m >=2m buffer busy waits385.0 10.0 5.0 db file async I/O submit88987.61.16.42.71.7.5 free buffer waits9017.515.342.918.012.34.0 log file parallel write1100.0.0 log file switch (checkpoint incomplete)712.5 12.512.562.5 write complete waits614.342.928.6 14.3 Back to Wait Events Statistics Back to Top Wait Event Histogram Detail (4 min to 1 hr) Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours) % 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 Event Waits 4m to 1h <2m <4m <8m <1/4h <1/2h < 1h >=1h enq: RO - fast object reuse266.7 33.3 Back to Wait Events Statistics Back to Top Service Statistics ordered by DB Time Service Name DB Time (s) DB CPU (s) Physical Reads (K) Logical Reads (K) SYS$USERS14,7103,11514,10548,310 sepc221.se.cuhk.edu.hk1,075340411 SYS$BACKGROUND000253 sepc221XDB0000 Back to Wait Events Statistics Back to Top Service Wait Class Stats 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 Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time SYS$USERS138961114171321900295600 sepc221.se.cuhk.edu.hk195018000652540 SYS$BACKGROUND1713161951810000 Back to Wait Events Statistics Back to Top SQL Statistics SQL ordered by Elapsed Time SQL ordered by CPU Time SQL ordered by User I/O Wait Time SQL ordered by Gets SQL ordered by Reads SQL ordered by Physical Reads (UnOptimized) SQL ordered by Executions SQL ordered by Parse Calls SQL ordered by Sharable Memory SQL ordered by Version Count Complete List of SQL Text Back to Top SQL ordered by Elapsed Time 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 89.9% of Total DB Time (s): 15,785 Captured PL/SQL account for 95.2% of Total DB Time (s): 15,785 Elapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text 10,622.120 67.297.202.609tcqhykww2mr8sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE k_core_end_condi INT;... 8,946.7432,982.2556.684.490.02a1acqk5qmjn6zsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO EDGE_TEMP SELECT /... 1,769.4011,769.4011.2196.503.957mbrxht15aawpsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE scc_end_condi INT; TE... 1,583.207226.1710.0396.184.34gndczj336t878sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO SCC_NEW SELECT /*+... 1,055.063351.696.680.320.099sh2u9up37m0rsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) SELECT COUNT(*) FROM EDGE_TEMP 484.991484.993.0731.4570.53b8x4ucy056gffsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE LP_end_condi INT; TEM... 483.741483.743.0624.1358.882ch03tuq4s1jysqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE top_new_end_condi INT... 446.636580.682.830.490.00cydnuss99swtdOEM.SystemPool BEGIN EM_PING.RECORD_BATCH_HEA... 364.792182.402.3164.9737.569qs78cyf2sq2ssqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO TEMP_K_CORE SELECT... 328.031328.032.0825.1378.771v23hwy2bt7fhsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 252.321252.321.6047.8254.198f34va0bksvtgsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO K_CORE SELECT /*+O... 248.051024.801.5722.3679.08fngfxkt2qjn29sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_MAX SELECT /*+O... 203.031020.301.2931.5771.879t8gwypynmvapsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_COUNT SELECT /*... 202.211561.301.280.840.007j23tu2qk35zjemagent_SQL_oracle_database /* OracleOEM */ BEGIN IF (:1 =... 199.461791.111.260.380.001dhu936zcgb55OEM.SystemPool UPDATE MGMT_AVAILABILITY_MARKE... 188.881791.061.200.400.006r95ktyt1vgmgOEM.BoundedPool SELECT CURRENT_STATUS FROM MGM... 176.24288.121.1234.4268.138wn17km89n1phsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... Back to SQL Statistics Back to Top SQL ordered by CPU Time 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 80.1% of Total CPU Time (s): 3,149 Captured PL/SQL account for 95.2% of Total CPU Time (s): 3,149 CPU Time (s) Executions CPU per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text 1,707.4211,707.4254.221,769.4096.503.957mbrxht15aawp sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE scc_end_condi INT; TE... 1,522.797217.5448.361,583.2096.184.34gndczj336t878 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO SCC_NEW SELECT /*+... 765.060 24.3010,622.127.202.609tcqhykww2mr8sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE k_core_end_condi INT;... 401.383133.7912.758,946.744.490.02a1acqk5qmjn6z sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO EDGE_TEMP SELECT /... 237.002118.507.53364.7964.9737.569qs78cyf2sq2s sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO TEMP_K_CORE SELECT... 152.541152.544.84484.9931.4570.53b8x4ucy056gff sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE LP_end_condi INT; TEM... 120.651120.653.83252.3247.8254.198f34va0bksvtg sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO K_CORE SELECT /*+O... 116.721116.723.71483.7424.1358.882ch03tuq4s1jy sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE top_new_end_condi INT... 82.44182.442.62328.0325.1378.771v23hwy2bt7fhsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 66.88166.882.1270.6894.635.46147mvb3t80fjssqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE key_search_end_condi ... 64.10106.412.04203.0331.5771.879t8gwypynmvapsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_COUNT SELECT /*... 60.67230.331.93176.2434.4268.138wn17km89n1phsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 55.47105.551.76248.0522.3679.08fngfxkt2qjn29sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_MAX SELECT /*+O... Back to SQL Statistics Back to Top SQL ordered by User I/O Wait Time 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 48.2% of Total User I/O Wait Time (s): 1,433 Captured PL/SQL account for 94.9% of Total User I/O Wait Time (s): 1,433 User I/O Time (s) Executions UIO per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text 342.091342.0923.87484.9931.4570.53b8x4ucy056gff sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE LP_end_condi INT; TEM... 284.831284.8319.88483.7424.1358.882ch03tuq4s1jy sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE top_new_end_condi INT... 276.360 19.2910,622.127.202.609tcqhykww2mr8sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE k_core_end_condi INT;... 258.401258.4018.03328.0325.1378.771v23hwy2bt7fh sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 196.161019.6213.69248.0522.3679.08fngfxkt2qjn29 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_MAX SELECT /*+O... 145.931014.5910.18203.0331.5771.879t8gwypynmvap sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_COUNT SELECT /*... 137.02268.519.56364.7964.9737.569qs78cyf2sq2s sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO TEMP_K_CORE SELECT... 136.731136.739.54252.3247.8254.198f34va0bksvtg sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO K_CORE SELECT /*+O... 120.07260.038.38176.2434.4268.138wn17km89n1ph sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 69.90169.904.881,769.4096.503.957mbrxht15aawp sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE scc_end_condi INT; TE... 68.6879.814.791,583.2096.184.34gndczj336t878sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO SCC_NEW SELECT /*+... Back to SQL Statistics Back to Top SQL ordered by Gets 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: 48,973,482 Captured SQL account for 69.9% of Total Buffer Gets Executions Gets per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text 17,295,5500 35.3210,622.127.202.609tcqhykww2mr8 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE k_core_end_condi INT;... 14,216,61834,738,872.6729.038,946.744.490.02a1acqk5qmjn6z sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO EDGE_TEMP SELECT /... 10,820,806110,820,806.0022.101,769.4096.503.957mbrxht15aawp sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE scc_end_condi INT; TE... 8,124,90671,160,700.8616.591,583.2096.184.34gndczj336t878 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO SCC_NEW SELECT /*+... 7,669,00917,669,009.0015.66483.7424.1358.882ch03tuq4s1jy sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE top_new_end_condi INT... 4,332,72514,332,725.008.85484.9931.4570.53b8x4ucy056gff sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE LP_end_condi INT; TEM... 1,894,37811,894,378.003.87328.0325.1378.771v23hwy2bt7fh sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 1,719,1192859,559.503.51176.2434.4268.138wn17km89n1ph sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 1,529,83511,529,835.003.1270.6894.635.46147mvb3t80fjs sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE key_search_end_condi ... 1,326,74010132,674.002.71203.0331.5771.879t8gwypynmvap sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_COUNT SELECT /*... 1,148,9142574,457.002.35364.7964.9737.569qs78cyf2sq2s sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO TEMP_K_CORE SELECT... 1,084,05410108,405.402.21248.0522.3679.08fngfxkt2qjn29 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_MAX SELECT /*+O... 1,063,04611,063,046.002.1733.2760.299.95b6usrg82hwsa3DBMS_SCHEDULER call dbms_stats.gather_databas... 1,044,2663348,088.672.131,055.060.320.099sh2u9up37m0r sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) SELECT COUNT(*) FROM EDGE_TEMP 578,2601578,260.001.18252.3247.8254.198f34va0bksvtg sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO K_CORE SELECT /*+O... Back to SQL Statistics Back to Top SQL ordered by Reads %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: 14,105,729 Captured SQL account for 87.0% of Total Physical Reads Executions Reads per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text 8,154,49018,154,490.0057.811,769.4096.503.957mbrxht15aawp sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE scc_end_condi INT; TE... 7,344,18871,049,169.7152.071,583.2096.184.34gndczj336t878 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO SCC_NEW SELECT /*+... 4,532,3550 32.1310,622.127.202.609tcqhykww2mr8 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE k_core_end_condi INT;... 1,554,2983518,099.3311.028,946.744.490.02a1acqk5qmjn6z sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO EDGE_TEMP SELECT /... 1,289,8982644,949.009.14364.7964.9737.569qs78cyf2sq2s sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO TEMP_K_CORE SELECT... 1,043,6713347,890.337.401,055.060.320.099sh2u9up37m0r sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) SELECT COUNT(*) FROM EDGE_TEMP 644,4881644,488.004.57252.3247.8254.198f34va0bksvtg sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO K_CORE SELECT /*+O... 382,8571382,857.002.71484.9931.4570.53b8x4ucy056gff sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE LP_end_condi INT; TEM... 372,1411372,141.002.64328.0325.1378.771v23hwy2bt7fh sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 297,3831297,383.002.11483.7424.1358.882ch03tuq4s1jy sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE top_new_end_condi INT... 204,7442102,372.001.45176.2434.4268.138wn17km89n1ph sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 201,1801020,118.001.43203.0331.5771.879t8gwypynmvap sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_COUNT SELECT /*... 181,6771018,167.701.29248.0522.3679.08fngfxkt2qjn29 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_MAX SELECT /*+O... Back to SQL Statistics Back to Top SQL ordered by Physical Reads (UnOptimized) 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: 1,320,973 Captured SQL account for 48.8% of Total Total UnOptimized Read Requests: 1,320,973 Captured SQL account for 48.8% of Total Total Optimized Read Requests: 1 Captured SQL account for 0.0% of Total UnOptimized Read Reqs Physical Read Reqs Executions UnOptimized Reqs per Exec %Opt %Total SQL Id SQL Module SQL Text 385,513385,5130 0.0029.189tcqhykww2mr8sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE k_core_end_condi INT;... 358,371358,3711358,371.000.0027.131v23hwy2bt7fh sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 241,230241,2302120,615.000.0018.269qs78cyf2sq2s sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO TEMP_K_CORE SELECT... 204,684204,6842102,342.000.0015.498wn17km89n1ph sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE MAX_NODE_WEIGHT_end_c... 189,229189,2291189,229.000.0014.32b8x4ucy056gff sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE LP_end_condi INT; TEM... 180,793180,7931018,079.300.0013.69fngfxkt2qjn29 sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO LP_MAX SELECT /*+O... 122,456122,4561122,456.000.009.278f34va0bksvtg sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO K_CORE SELECT /*+O... 69,22269,222169,222.000.005.247mbrxht15aawpsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) DECLARE scc_end_condi INT; TE... 62,87362,87378,981.860.004.76gndczj336t878sqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO SCC_NEW SELECT /*+... 13,63313,63334,544.330.001.03a1acqk5qmjn6zsqlplus@sepc221.se.cuhk.edu.hk (TNS V1-V3) INSERT INTO EDGE_TEMP SELECT /... Back to SQL Statistics Back to Top SQL ordered by Executions %CPU - CPU Time as a percentage of Elapsed Time %IO - User I/O Time as a percentage of Elapsed Time Total Executions: 469,888 Captured SQL account for 48.4% of Total Executions Rows Processed Rows per Exec Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text 42,69163,0251.480.7492.990.00cm5vu20fhtnq1 select /*+ connect_by_filterin... 33,24033,2401.000.9433.880.008t43xdhf4d9x2 SELECT CONTEXT_TYPE_ID, CONTEX... 21,45821,4581.000.4739.220.00089dbukv1aanhEM_PING SELECT SYS_EXTRACT_UTC(SYSTIME... 19,84219,8411.00148.430.680.008vwv6hx92ymmmOEM.SystemPool UPDATE MGMT_CURRENT_METRICS SE... 17,05617,0561.008.1135.400.006v7n0y2bq89n8OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM... 16,83216,8321.000.1186.520.027sx5p1ug5ag12DBMS_SCHEDULER SELECT SPARE4 FROM SYS.OPTSTAT... 10,90890.000.4510.530.003972rvxu3knn3emagent_AQMetrics delete from sdo_geor_ddl__tabl... 10,90810,9081.001.6810.390.00a6u3yjca29nqcemagent_AQMetrics declare m_stmt varchar2(512); ... 7,53900.000.2044.740.005hfunyv38vwfpOEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S... 5,7535280.090.6336.740.005ms6rbzdnq16t select job, nvl2(last_date, 1,... 4,88928,1695.761.0096.720.0043ruajmwv9fus insert into histgrm$(obj#, int... Back to SQL Statistics Back to Top SQL ordered by Parse Calls Total Parse Calls: 189,295 Captured SQL account for 49.9% of Total Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text 42,69242,69122.55cm5vu20fhtnq1 select /*+ connect_by_filterin... 10,90810,9085.763972rvxu3knn3emagent_AQMetrics delete from sdo_geor_ddl__tabl... 10,90810,9085.76a6u3yjca29nqcemagent_AQMetrics declare m_stmt varchar2(512); ... 3,0733,0731.6281ky0n97v4zsgemagent_SQL_oracle_database /* OracleOEM */ select s.sid, ... 3,0703,0701.6243c5ykm1mcp2aOMS begin dbms_application_info.se... 3,0453,0451.61a4ct9tx8f9d4aOMS begin execute immediate 'alter... 3,0183,0181.591ytruncyx2kdbOEM.DefaultPool BEGIN MGMT_HTTP_SESSION.sessio... 2,2942,3811.2108bqjmf8490s2SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG... 2,1832,1831.15g00cj285jmgsw update sys.mon_mods$ set inser... 1,5581,5580.822b064ybzkwf1yOEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R... Back to SQL Statistics Back to Top SQL ordered by Sharable Memory Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text 1,656,291130.04gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) F... 1,440,92730.043wrrjm9qtr2myMMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO... 1,155,8891560.03a5pyncg7v0bw3emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA... 1,107,3433120.035fk0v8km2f811perl@sepc221.se.cuhk.edu.hk (TNS V1-V3) select propagation_name, 'BUFF... Back to SQL Statistics Back to Top SQL ordered by Version Count No data exists for this section of the report. Back to SQL Statistics Back to Top Complete List of SQL Text SQL Id SQL Text 089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL 08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 147mvb3t80fjsDECLARE key_search_end_condi INT; TEMP_key_search_end_condi INT; key_search_new_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO key_search select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ * from cp_ini_word; REC_TIMES :=1; WHILE REC_TIMES <=4 LOOP INSERT INTO key_search_new select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ cp_edge_scc.to_id, max(key_search.word1), max(key_search.word2), max(key_search.word3) from key_search, cp_edge_scc where key_search.id=cp_edge_scc.from_id group by cp_edge_scc.to_id; SELECT COUNT(*) INTO key_search_new_end_condi FROM key_search_new; IF key_search_new_end_condi <=0 THEN EXIT; END IF; INSERT INTO TEMP_key_search select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, word1, word2, word3 from key_search_new; SELECT COUNT(*) INTO TEMP_key_search_end_condi FROM TEMP_key_search; IF TEMP_key_search_end_condi <=0 THEN EXIT; END IF; EXECUTE IMMEDIATE 'TRUNCATE TABLE key_search'; INSERT INTO key_search SELECT * FROM TEMP_key_search; EXECUTE IMMEDIATE 'TRUNCATE TABLE TEMP_key_search'; EXECUTE IMMEDIATE 'TRUNCATE TABLE key_search_new'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: key_search'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; 1dhu936zcgb55UPDATE MGMT_AVAILABILITY_MARKER SET MARKER_TIMESTAMP = :B1 WHERE MARKER_TIMESTAMP <= :B1 AND TARGET_GUID IN (SELECT /*+ INDEX(t mgmt_targets_idx_02) */ T.TARGET_GUID FROM MGMT_TARGETS T WHERE T.EMD_URL = :B2 AND T.REP_SIDE_AVAIL = 0 AND NOT EXISTS (SELECT 1 FROM MGMT_BLACKOUT_WINDOWS BW WHERE BW.TARGET_GUID = T.TARGET_GUID AND BW.START_TIME <= :B1 AND (BW.STATUS NOT IN (:B4 , :B3 ) ) ) AND NOT EXISTS (SELECT 1 FROM MGMT_GENSVC_AVAIL_CONFIG BCNAV WHERE BCNAV.TARGET_GUID = T.TARGET_GUID) ) 1v23hwy2bt7fhDECLARE MAX_NODE_WEIGHT_end_condi INT; TEMP_MAX_NODE_WEIGHT_end_condi INT; match_temp_end_condi INT; node_pick_end_condi INT; match_result_end_condi INT; node_match_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO MAX_NODE_WEIGHT select * from wg_node_weight; REC_TIMES :=1; LOOP INSERT INTO node_pick select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ wg_edge.from_id, node2.id, node2.weight, max(node2.weight) over (partition by wg_edge.from_id) from wg_edge , MAX_NODE_WEIGHT node2 where node2.id=wg_edge.to_id; SELECT COUNT(*) INTO node_pick_end_condi FROM node_pick; IF node_pick_end_condi <=0 THEN EXIT; END IF; INSERT INTO match_temp select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ node_pick.id1, min(node_pick.id2) from node_pick where id2_weight=weight group by node_pick.id1; SELECT COUNT(*) INTO match_temp_end_condi FROM match_temp; IF match_temp_end_condi <=0 THEN EXIT; END IF; INSERT INTO match_result select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ temp1.id1, temp1.id2 from match_temp temp1, match_temp temp2 where temp1.id1=temp2.id2 and temp2.id1=temp1.id2; SELECT COUNT(*) INTO match_result_end_condi FROM match_result; IF match_result_end_condi <=0 THEN EXIT; END IF; insert into node_match select * from match_result; --delete from MAX_NODE_WEIGHT using match_result where MAX_NODE_W EIGHT.id=match_result.id1; delete from MAX_NODE_WEIGHT where id in (select id1 from match_result); EXECUTE IMMEDIATE 'TRUNCATE TABLE match_temp'; EXECUTE IMMEDIATE 'TRUNCATE TABLE node_pick'; EXECUTE IMMEDIATE 'TRUNCATE TABLE match_result'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: MAX_NODE_WEIGHT'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; 1ytruncyx2kdbBEGIN MGMT_HTTP_SESSION.session_expired(:1); END; 2b064ybzkwf1yBEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; 2ch03tuq4s1jyDECLARE top_new_end_condi INT; TEMP_top_new_end_condi INT; temp_edge_end_condi INT; dele_node_end_condi INT; sort_result_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO top_new select id /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ from cp_node; REC_TIMES :=1; LOOP INSERT INTO temp_edge select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ cp_edge.from_id, cp_edge.to_id from top_new top1, cp_edge where cp_edge.from_id=top1.id ; SELECT COUNT(*) INTO temp_edge_end_condi FROM temp_edge; IF temp_edge_end_condi <=0 THEN EXIT; END IF; INSERT INTO dele_node select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id from top_new where id not in (select distinct to_id from temp_edge); SELECT COUNT(*) INTO dele_node_end_condi FROM dele_node; IF dele_node_end_condi <=0 THEN EXIT; END IF; insert into sort_result select id from dele_node; -- delete from top_new using dele_node where id= dele_node.id; delete from top_new where top_new.id in (select dele_node.id from dele_node); EXECUTE IMMEDIATE 'TRUNCATE TABLE temp_edge'; EXECUTE IMMEDIATE 'TRUNCATE TABLE dele_node'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: top_new'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; 3972rvxu3knn3delete from sdo_geor_ddl__table$$ 3wrrjm9qtr2mySELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL(JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+) 43c5ykm1mcp2abegin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client_info(:3); dbms_session.set_identifier(:4); end; 43ruajmwv9fusinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7) 5fk0v8km2f811select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance 5hfunyv38vwfpSELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B9 , :B8 , :B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1 5ms6rbzdnq16tselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job 6r95ktyt1vgmgSELECT CURRENT_STATUS FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B1 ) ORDER BY TARGET_GUID FOR UPDATE 6v7n0y2bq89n8BEGIN 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; 7j23tu2qk35zj/* OracleOEM */ BEGIN IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN ---- -- For a read-write database appropriately configured, try to evaluate. ---- dbsnmp.mgmt_response.get_metric_curs(:3); ELSE ---- -- For a read-only database, do not evaluate, but rather return an empty -- cursor. ---- DECLARE TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; BEGIN OPEN data_cursor FOR SELECT -1 FROM dual WHERE 0=1; :3 := data_cursor; END; END IF; END; 7mbrxht15aawpDECLARE scc_end_condi INT; TEMP_scc_end_condi INT; difference_end_condi INT; scc_new_end_condi INT; delta_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO scc select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, id from ok_node; REC_TIMES :=1; LOOP INSERT INTO scc_new select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ ok_edge_scc.to_id, min(scc.val) from scc, ok_edge_scc where scc.id=ok_edge_scc.from_id group by ok_edge_scc.to_id; SELECT COUNT(*) INTO scc_new_end_condi FROM scc_new; IF scc_new_end_condi <=0 THEN EXIT; END IF; INSERT INTO difference select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ distinct scc.id, scc.val-scc_new.val from scc, scc_new where scc.id=scc_new.id; SELECT COUNT(*) INTO difference_end_condi FROM difference; IF difference_end_condi <=0 THEN EXIT; END IF; INSERT INTO delta select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, val from difference where val<0 or val >0; SELECT COUNT(*) INTO delta_end_condi FROM delta; IF delta_end_condi <=0 THEN EXIT; END IF; INSERT INTO TEMP_scc select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, val from scc_new; SELECT COUNT(*) INTO TEMP_scc_end_condi FROM TEMP_scc; IF TEMP_scc_end_condi <=0 THEN EXIT; END IF; EXECUTE IMMEDIATE 'TRUNCATE TABLE scc'; INSERT INTO scc SELECT * FROM TEMP_scc; EXECUTE IMMEDIATE 'TRUNCATE TABLE TEMP_scc'; EXECUTE IMMEDIATE 'TRUNCATE TABLE difference'; EXECUTE IMMEDIATE 'TRUNCATE TABLE scc_new'; EXECUTE IMMEDIATE 'TRUNCATE TABLE delta'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: scc'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; 7sx5p1ug5ag12SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1 81ky0n97v4zsg/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1) 8f34va0bksvtgINSERT INTO K_CORE SELECT /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ OK_NODE.ID, COUNT(OK_EDGE.TO_ID) FROM OK_NODE, OK_EDGE WHERE OK_NODE.ID=OK_EDGE.FROM_ID GROUP BY OK_NODE.ID 8t43xdhf4d9x2SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 ) 8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 8wn17km89n1phDECLARE MAX_NODE_WEIGHT_end_condi INT; TEMP_MAX_NODE_WEIGHT_end_condi INT; match_temp_end_condi INT; node_pick_end_condi INT; match_result_end_condi INT; node_match_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO MAX_NODE_WEIGHT select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ * from wt_node_weight; REC_TIMES :=1; LOOP INSERT INTO node_pick select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ wt_edge.from_id, node2.id, node2.weight, max(node2.weight) over (partition by wt_edge.from_id) from wt_edge , MAX_NODE_WEIGHT node2 where node2.id=wt_edge.to_id; SELECT COUNT(*) INTO node_pick_end_condi FROM node_pick; IF node_pick_end_condi <=0 THEN EXIT; END IF; INSERT INTO match_temp select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ node_pick.id1, min(node_pick.id2) from node_pick where id2_weight=weight group by node_pick.id1; SELECT COUNT(*) INTO match_temp_end_condi FROM match_temp; IF match_temp_end_condi <=0 THEN EXIT; END IF; INSERT INTO match_result select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ temp1.id1, temp1.id2 from match_temp temp1, match_temp temp2 where temp1.id1=temp2.id2 and temp2.id1=temp1.id2; SELECT COUNT(*) INTO match_result_end_condi FROM match_result; IF match_result_end_condi <=0 THEN EXIT; END IF; insert into node_match select * from match_result; --delete from MAX_ NODE_WEIGHT using match_result where MAX_NODE_WEIGHT.id=match_result.id1; delete from MAX_NODE_WEIGHT where id in (select id1 from match_result); EXECUTE IMMEDIATE 'TRUNCATE TABLE match_temp'; EXECUTE IMMEDIATE 'TRUNCATE TABLE node_pick'; EXECUTE IMMEDIATE 'TRUNCATE TABLE match_result'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: MAX_NODE_WEIGHT'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; 9qs78cyf2sq2sINSERT INTO TEMP_K_CORE SELECT /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ CORE_TEMP.ID, COUNT(EDGE_TEMP.TO_ID) FROM CORE_TEMP, EDGE_TEMP WHERE CORE_TEMP.ID=EDGE_TEMP.FROM_ID GROUP BY CORE_TEMP.ID 9sh2u9up37m0rSELECT COUNT(*) FROM EDGE_TEMP 9t8gwypynmvapINSERT INTO LP_COUNT SELECT /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ CP_EDGE.TO_ID, LABEL, COUNT(LABEL) FROM LP, CP_EDGE WHERE LP.ID = CP_EDGE.FROM_ID GROUP BY CP_EDGE.TO_ID, LABEL 9tcqhykww2mr8DECLARE k_core_end_condi INT; TEMP_k_core_end_condi INT; core_temp_end_condi INT; edge_temp_end_condi INT; core_temp2_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO k_core select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ ok_node.id, count(ok_edge.to_id) from ok_node, ok_edge where ok_node.id=ok_edge.from_id group by ok_node.id; REC_TIMES :=1; LOOP INSERT INTO core_temp2 select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id from k_core where deg< 5; SELECT COUNT(*) INTO core_temp2_end_condi FROM core_temp2; IF core_temp2_end_condi <=0 THEN EXIT; END IF; INSERT INTO core_temp select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id from k_core where deg >=5; SELECT COUNT(*) INTO core_temp_end_condi FROM core_temp; IF core_temp_end_condi <=0 THEN EXIT; END IF; INSERT INTO edge_temp select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ ok_edge.from_id, ok_edge.to_id from core_temp temp1, ok_edge, core_temp temp2 where ok_edge.from_id = temp1.id and ok_edge.to_id=temp2.id; SELECT COUNT(*) INTO edge_temp_end_condi FROM edge_temp; IF edge_temp_end_condi <=0 THEN EXIT; END IF; INSERT INTO TEMP_k_core select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ core_temp.id, count(edge_temp.to_id) from core_temp, edge_temp where core_temp.id=edge_temp.from_id group by core_temp.id; SELECT COUNT(*) I NTO TEMP_k_core_end_condi FROM TEMP_k_core; IF TEMP_k_core_end_condi <=0 THEN EXIT; END IF; EXECUTE IMMEDIATE 'TRUNCATE TABLE k_core'; INSERT INTO k_core SELECT * FROM TEMP_k_core; EXECUTE IMMEDIATE 'TRUNCATE TABLE TEMP_k_core'; EXECUTE IMMEDIATE 'TRUNCATE TABLE core_temp'; EXECUTE IMMEDIATE 'TRUNCATE TABLE edge_temp'; EXECUTE IMMEDIATE 'TRUNCATE TABLE core_temp2'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: k_core'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; a1acqk5qmjn6zINSERT INTO EDGE_TEMP SELECT /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ OK_EDGE.FROM_ID, OK_EDGE.TO_ID FROM CORE_TEMP TEMP1, OK_EDGE, CORE_TEMP TEMP2 WHERE OK_EDGE.FROM_ID = TEMP1.ID AND OK_EDGE.TO_ID=TEMP2.ID a4ct9tx8f9d4abegin execute immediate 'alter session set NLS_NUMERIC_CHARACTERS = ''., '''; end; a5pyncg7v0bw3/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%' a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end; b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( ) b8x4ucy056gffDECLARE LP_end_condi INT; TEMP_LP_end_condi INT; LP_COUNT_end_condi INT; LP_MAX_end_condi INT; delta_end_condi INT; difference_end_condi INT; LP_NEW_end_condi INT; REC_TIMES INT; l_start_time PLS_INTEGER; l_end_time PLS_INTEGER; BEGIN l_start_time:=DBMS_UTILITY.GET_TIME(); INSERT INTO LP select id, trunc(dbms_random.value(0, 20)) from cp_node, DUAL; REC_TIMES :=1; WHILE REC_TIMES <=10 LOOP INSERT INTO LP_COUNT select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ cp_edge.to_id, label, count(label) from LP, cp_edge where LP.id = cp_edge.from_id group by cp_edge.to_id, label; SELECT COUNT(*) INTO LP_COUNT_end_condi FROM LP_COUNT; IF LP_COUNT_end_condi <=0 THEN EXIT; END IF; INSERT INTO LP_MAX select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, label, cnt, max(cnt) over (partition by id) from LP_COUNT; SELECT COUNT(*) INTO LP_MAX_end_condi FROM LP_MAX; IF LP_MAX_end_condi <=0 THEN EXIT; END IF; INSERT INTO LP_NEW select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, max(label) from LP_MAX where cnt=max group by id; SELECT COUNT(*) INTO LP_NEW_end_condi FROM LP_NEW; IF LP_NEW_end_condi <=0 THEN EXIT; END IF; INSERT INTO difference select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ LP.id, LP.label-LP_NEW.label from LP, LP_NEW where LP.id=LP_NEW.id; SELECT COUNT(*) INTO difference_end_condi FROM difference; -- IF difference_end_condi <=0 THEN EXIT; -- END IF; -- INSER T INTO delta select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id from difference where label<0 or label>0 ; -- SELECT COUNT(*) INTO delta_end_condi FROM delta; -- IF delta_end_condi <=0 THEN EXIT; -- END IF; INSERT INTO TEMP_LP select /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ id, label from LP_NEW; SELECT COUNT(*) INTO TEMP_LP_end_condi FROM TEMP_LP; IF TEMP_LP_end_condi <=0 THEN EXIT; END IF; EXECUTE IMMEDIATE 'TRUNCATE TABLE LP'; INSERT INTO LP SELECT * FROM TEMP_LP; EXECUTE IMMEDIATE 'TRUNCATE TABLE TEMP_LP'; EXECUTE IMMEDIATE 'TRUNCATE TABLE LP_COUNT'; EXECUTE IMMEDIATE 'TRUNCATE TABLE LP_MAX'; EXECUTE IMMEDIATE 'TRUNCATE TABLE delta'; EXECUTE IMMEDIATE 'TRUNCATE TABLE difference'; EXECUTE IMMEDIATE 'TRUNCATE TABLE LP_NEW'; REC_TIMES:=REC_TIMES+1; END LOOP ; DBMS_OUTPUT.PUT_LINE(REC_TIMES); l_end_time:=DBMS_UTILITY.GET_TIME(); DBMS_OUTPUT.PUT_LINE('Algorithm: LP'); DBMS_OUTPUT.PUT_LINE('Elapsed time: ' || (l_end_time - l_start_time)); END; cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 cydnuss99swtdBEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END; fngfxkt2qjn29INSERT INTO LP_MAX SELECT /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ ID, LABEL, CNT, MAX(CNT) OVER (PARTITION BY ID) FROM LP_COUNT g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn gjm43un5cy843SELECT 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) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) gndczj336t878INSERT INTO SCC_NEW SELECT /*+OPT_PARAM('_optimizer_use_feedback', 'false') */ OK_EDGE_SCC.TO_ID, MIN(SCC.VAL) FROM SCC, OK_EDGE_SCC WHERE SCC.ID=OK_EDGE_SCC.FROM_ID GROUP BY OK_EDGE_SCC.TO_ID Back to SQL Statistics Back to Top Instance Activity Statistics Instance Activity Stats Instance Activity Stats - Absolute Values Instance Activity Stats - Thread Activity Back to Top Instance Activity Stats Ordered by statistic name Statistic Total per Second per Trans Batched IO (bound) vector count00.000.00 Batched IO (full) vector count00.000.00 Batched IO block miss count00.000.00 Batched IO buffer defrag count00.000.00 Batched IO double miss count00.000.00 Batched IO same unit count00.000.00 Batched IO single block count00.000.00 Batched IO slow jump count00.000.00 Batched IO vector block count00.000.00 Batched IO vector read count00.000.00 Block Cleanout Optim referenced1480.000.02 CCursor + sql area evicted430.000.00 CPU used by this session309,7726.6231.81 CPU used when call started226,7584.8523.29 CR blocks created1,9930.040.20 Cached Commit SCN referenced4,6180.100.47 Commit SCN cached223,9504.7923.00 DB time14,876,481318.041,527.83 DBWR checkpoint buffers written372,9377.9738.30 DBWR checkpoints580.000.01 DBWR object drop buffers written223,7044.7822.97 DBWR thread checkpoint buffers written17,1070.371.76 DBWR transaction table writes1,0890.020.11 DBWR undo block writes464,9019.9447.75 DFO trees parallelized00.000.00 HSC Heap Segment Block Changes11,932,715255.111,225.50 HSC IDL Compressed Blocks00.000.00 Heap Segment Array Inserts7,966,999170.32818.22 Heap Segment Array Updates2,2190.050.23 IMU CR rollbacks1,5550.030.16 IMU Flushes13,6680.291.40 IMU Redo allocation size13,288,516284.091,364.74 IMU commits7,8770.170.81 IMU contention400.000.00 IMU ktichg flush2480.010.03 IMU pool not allocated2,4040.050.25 IMU recursive-transaction flush20.000.00 IMU undo allocation size46,641,896997.144,790.17 IMU- failed to get a private strand2,4040.050.25 LOB table id lookup cache misses00.000.00 Number of read IOs issued8,1580.170.84 PX local messages recv'd00.000.00 PX local messages sent00.000.00 Parallel operations downgraded 1 to 25 pct00.000.00 Parallel operations not downgraded00.000.00 RowCR - row contention10.000.00 RowCR attempts14,7890.321.52 RowCR hits14,7880.321.52 SMON posted for undo segment shrink380.000.00 SQL*Net roundtrips to/from client93,7852.009.63 active txn count during cleanout1,166,63224.94119.81 application wait time105,2452.2510.81 background checkpoints completed500.000.01 background checkpoints started510.000.01 background timeouts192,6234.1219.78 branch node splits10.000.00 buffer is not pinned count1,168,29424.98119.99 buffer is pinned count4,915,318105.08504.81 bytes received via SQL*Net from client23,338,868498.952,396.93 bytes sent via SQL*Net to client13,463,922287.841,382.76 calls to get snapshot scn: kcmgss568,51812.1558.39 calls to kcmgas581,59712.4359.73 calls to kcmgcs8,953,161191.41919.50 cell physical IO interconnect bytes152,763,336,1923,265,874.9015,688,953.09 change write time1,3330.030.14 cleanout - number of ktugct calls1,526,38732.63156.76 cleanouts and rollbacks - consistent read gets980.000.01 cleanouts only - consistent read gets359,7027.6936.94 cluster key scan block gets98,5402.1110.12 cluster key scans80,4771.728.27 commit batch performed00.000.00 commit batch requested00.000.00 commit batch/immediate performed70.000.00 commit batch/immediate requested70.000.00 commit cleanout failures: block lost287,4386.1529.52 commit cleanout failures: buffer being written50.000.00 commit cleanout failures: callback failure1950.000.02 commit cleanout failures: cannot pin30.000.00 commit cleanouts363,2017.7637.30 commit cleanouts successfully completed75,5601.627.76 commit immediate performed70.000.00 commit immediate requested70.000.00 commit txn count during cleanout360,5067.7137.02 concurrency wait time10,0610.221.03 consistent changes25,141,739537.502,582.08 consistent gets24,892,175532.162,556.45 consistent gets - examination2,302,28449.22236.45 consistent gets direct1,043,64622.31107.18 consistent gets from cache23,848,529509.852,449.27 consistent gets from cache (fastpath)21,220,179453.662,179.33 cursor authentications7820.020.08 data blocks consistent reads - undo records applied2,3750.050.24 db block changes37,835,356808.873,885.73 db block gets24,081,307514.832,473.18 db block gets direct1,5310.030.16 db block gets from cache24,079,776514.792,473.02 db block gets from cache (fastpath)177,4443.7918.22 deferred (CURRENT) block cleanout applications30,2880.653.11 dirty buffers inspected1,473,59731.50151.34 enqueue conversions13,0900.281.34 enqueue releases1,200,70825.67123.31 enqueue requests1,200,73125.67123.32 enqueue timeouts80.000.00 enqueue waits200.000.00 exchange deadlocks40.000.00 execute count469,88810.0548.26 failed probes on index block reclamation30.000.00 file io service time00.000.00 file io wait time10,741,641,001229,641.851,103,177.67 free buffer inspected13,848,293296.061,422.23 free buffer requested15,707,191335.801,613.14 heap block compress1,0160.020.10 hot buffers moved to head of LRU161,8363.4616.62 immediate (CR) block cleanout applications359,8007.6936.95 immediate (CURRENT) block cleanout applications24,1710.522.48 index crx upgrade (positioned)71,7921.537.37 index crx upgrade (prefetch)10.000.00 index fast full scans (full)1,0830.020.11 index fetch by key541,47911.5855.61 index scans kdiixs1450,6879.6446.29 leaf node 90-10 splits3350.010.03 leaf node splits6570.010.07 lob reads5,8970.130.61 lob writes2,4180.050.25 lob writes unaligned2,4180.050.25 logons cumulative3,4670.070.36 max cf enq hold time200.000.00 messages received21,3240.462.19 messages sent21,3230.462.19 min active SCN optimization applied on CR10.000.00 no work - consistent read gets18,941,754404.951,945.34 non-idle wait count2,534,40354.18260.29 non-idle wait time2,550,99854.54261.99 opened cursors cumulative432,3329.2444.40 parse count (describe)470.000.00 parse count (failures)4990.010.05 parse count (hard)3,3050.070.34 parse count (total)189,2954.0519.44 parse time cpu4280.010.04 parse time elapsed2,2250.050.23 physical read IO requests1,320,97328.24135.67 physical read bytes115,554,131,9682,470,392.1011,867,529.22 physical read total IO requests1,400,66029.94143.85 physical read total bytes116,858,860,5442,498,285.4412,001,526.19 physical read total multi block requests111,7592.3911.48 physical reads14,105,729301.561,448.67 physical reads cache11,356,264242.781,166.30 physical reads cache prefetch11,258,698240.701,156.28 physical reads direct2,749,46558.78282.37 physical reads direct (lob)40.000.00 physical reads direct temporary tablespace2,749,45058.78282.37 physical reads prefetch warmup00.000.00 physical write IO requests1,231,46226.33126.47 physical write bytes30,533,967,872652,775.213,135,870.17 physical write total IO requests1,283,16327.43131.78 physical write total bytes35,904,475,648767,589.453,687,426.89 physical write total multi block requests101,5822.1710.43 physical writes3,727,29179.68382.80 physical writes direct1,702,04936.39174.80 physical writes direct (lob)120.000.00 physical writes direct temporary tablespace1,701,92536.38174.79 physical writes from cache2,025,24243.30207.99 physical writes non checkpoint3,665,20778.36376.42 pinned buffers inspected710.000.01 pinned cursors current20.000.00 prefetch warmup blocks aged out before use1560.000.02 prefetch warmup blocks flushed out before use00.000.00 prefetched blocks aged out before use3,0170.060.31 process last non-idle time217,2504.6422.31 queries parallelized00.000.00 recursive calls1,936,23041.39198.85 recursive cpu usage303,2596.4831.15 redo blocks checksummed by FG (exclusive)1,151,17424.61118.23 redo blocks written9,274,291198.27952.48 redo buffer allocation retries620.000.01 redo entries12,173,954260.261,250.28 redo log space requests4,5740.100.47 redo log space wait time45,1720.974.64 redo ordering marks451,4629.6546.37 redo size4,590,382,05698,136.20471,437.00 redo size for direct writes1,3000.030.13 redo subscn max counts468,41710.0148.11 redo synch time20,6880.442.12 redo synch writes3,4480.070.35 redo wastage3,089,90866.06317.34 redo write time55,1001.185.66 redo writes11,2820.241.16 rollback changes - undo records applied1690.000.02 rollbacks only - consistent read gets1,8200.040.19 rows fetched via callback198,8034.2520.42 session connect time00.000.00 session cursor cache hits168,3473.6017.29 session logical reads48,973,4821,046.995,029.63 shared hash latch upgrades - no wait191,9674.1019.72 shared hash latch upgrades - wait00.000.00 sorts (disk)350.000.00 sorts (memory)149,5703.2015.36 sorts (rows)903,072,89419,306.4992,746.52 sql area evicted430.000.00 sql area purged8840.020.09 summed dirty queue length29,622,803633.303,042.29 switch current to new buffer107,8742.3111.08 table fetch by rowid652,45413.9567.01 table fetch continued row1,2650.030.13 table scan blocks gotten18,643,614398.581,914.72 table scan rows gotten8,273,418,966176,874.58849,688.71 table scans (direct read)20.000.00 table scans (long tables)990.000.01 table scans (rowid ranges)00.000.00 table scans (short tables)64,4821.386.62 temp space allocated (bytes)4,365,221,88893,322.58448,312.82 total cf enq hold time218,0704.6622.40 total number of cf enq holders2,8970.060.30 total number of times SMON posted390.000.00 transaction rollbacks70.000.00 undo change vector size3,593,515,72476,824.54369,057.79 user I/O wait time143,3023.0614.72 user calls120,7112.5812.40 user commits9,7370.211.00 user rollbacks00.000.00 workarea executions - onepass1210.000.01 workarea executions - optimal62,3351.336.40 write clones created in background20.000.00 write clones created in foreground1520.000.02 Back to Instance Activity Statistics Back to Top Instance Activity Stats - Absolute Values Statistics with absolute values (should not be diffed) Statistic Begin Value End Value session uga memory15,119,019,778,12018,954,597,455,736 opened cursors current121123 logons current3231 session uga memory max34,499,204,58439,454,694,136 session pga memory7,802,947,4729,810,982,448 session pga memory max8,709,917,23212,041,779,408 session cursor cache count229,148288,606 Back to Instance Activity Statistics Back to Top Instance Activity Stats - Thread Activity Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour log switches (derived)513.93 Back to Instance Activity Statistics Back to Top IO Stats IOStat by Function summary IOStat by Filetype summary IOStat by Function/Filetype summary Tablespace IO Stats File IO Stats Back to Top IOStat by Function summary '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 Function Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms) Buffer Cache Reads86.6G2.091.896730M0.000M97.6K1.01 Direct Reads21G26.15.4592132.2G0.31.0491921223.4K0.00 DBWR0M0.000M15.5G24.89.33825371581483.95 Direct Writes0M0.000M10.7G1.12.23510167.2K18.78 LGWR170M0.23.0036344.4G0.31.09714423.4K25.23 Others1G1.47.022960582M0.80.012442106.1K24.49 TOTAL:108.8G29.942.3825433.4G27.43.7321331524.8K9.95 Back to IO Stats Back to Top IOStat by Filetype summary '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 Filetype Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Small Read Large Read Data File78.6G1.911.720813.8G4.66.0839960.531.17 Temp File29G26.34.63524524.6G21.67.5385920.000.00 Log File0M0.000M4.4G0.29.0968020.00 Control File1.2G1.69.026552595M0.81.0127200.01 TOTAL:108.8G29.942.3826033.4G27.43.7321120.000.84 Back to IO Stats Back to Top IOStat by Function/Filetype summary '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 Function/File Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms) Buffer Cache Reads 86.6G2.091.896730M0.000M97.6K1.01 Buffer Cache Reads (Data File) 86.6G2.091.896730M0.000M97.6K1.01 Direct Reads 21G26.15.4592132.2G0.31.0491920 Direct Reads (Data File) 21G26.15.4592132.2G0.31.0491920 DBWR 0M0.000M15.5G24.89.3382530 DBWR (Data File) 0M0.000M15.5G24.89.3382530 Direct Writes 0M0.000M10.7G1.12.2351010 Direct Writes (Data File) 0M0.000M10.7G1.12.2351010 LGWR 170M0.23.0036344.4G0.31.09714411.1K0.55 LGWR (Log File) 0M0.000M4.4G0.29.09680220429.94 LGWR (Control File) 170M0.23.00363416M0.02.00034210.9K0.00 Others 1G1.47.022960582M0.80.01244269K0.21 Others (Control File) 1G1.46.022917580M0.79.01239968.4K0.01 Others (Data File) 2M0.01.0000422M0.01.00004256624.67 TOTAL: 108.8G29.942.3825433.4G27.43.732133177.6K0.67 Back to IO Stats Back to Top Tablespace IO Stats ordered by IOs (Reads + Writes) desc Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms) TEMP1,231,934260.003.091,013,6242200.00 UNDOTBS11700.001.00201,124469715.51 SYSTEM87,69421.28117.462,655017946.47 SYSAUX1,30803.061.1214,059000.00 Back to IO Stats Back to Top File IO Stats ordered by Tablespace, File Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms) SYSAUX/u01/app/oracle/oradata/sepc221/sysaux01.dbf1,30803.061.1214,059000.00 SYSTEM/u01/app/oracle/oradata/sepc221/system01.dbf87,69421.28117.462,655017946.47 TEMP/u01/app/oracle/oradata/sepc221/temp01.dbf1,231,934260.003.091,013,624220 UNDOTBS1/u01/app/oracle/oradata/sepc221/undotbs01.dbf1700.001.00201,124469715.51 Back to IO Stats Back to Top Buffer Pool Statistics Buffer Pool Statistics Checkpoint Activity Back to Top Buffer Pool Statistics Standard block size Pools D: default, K: keep, R: recycle Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits D441,8827647,928,15111,356,2622,024,73987844822786 Back to Buffer Pool Statistics Back to Top Checkpoint Activity Total Physical Writes: 3,727,291 MTTR Writes Log Size Writes Log Ckpt Writes Other Settings Writes Autotune Ckpt Writes Thread Ckpt Writes 002,5070355,83014,600 Back to Buffer Pool Statistics Back to Top Advisory Statistics Instance Recovery Stats MTTR Advisory Buffer Pool Advisory PGA Aggr Summary PGA Aggr Target Stats PGA Aggr Target Histogram PGA Memory Advisory Shared Pool Advisory SGA Target Advisory Streams Pool Advisory Java Pool Advisory Back to Top Instance Recovery Stats B: Begin Snapshot, E: End Snapshot Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual RedoBlks Target RedoBlks Log Sz RedoBlks Log Ckpt Timeout RedoBlks Log Ckpt Interval RedoBlks Opt Log Sz(M) Estd RAC Avail Time B07322622441664184478522394881844785 E05096792921266697092239488669709 Back to Advisory Statistics Back to Top MTTR Advisory No data exists for this section of the report. Back to Advisory Statistics Back to Top Buffer Pool Advisory Only rows with estimated physical reads >0 are displayed ordered by Block Size, Buffers For Estimate P Size for Est (M) Size Factor Buffers (thousands) Est Phys Read Factor Estimated Phys Reads (thousands) Est Phys Read Time Est %DBtime for Rds D2560.07321.6519,365123840.00 D5120.14631.1513,47715583.00 D7680.21951.0612,45512415.00 D1,0240.291261.0412,25111781.00 D1,2800.361581.0312,14111441.00 D1,5360.431891.0312,09911309.00 D1,7920.502211.0312,05911186.00 D2,0480.572531.0212,01811059.00 D2,3040.642841.0211,9661896.00 D2,5600.713161.0111,9131732.00 D2,8160.793471.0111,8611572.00 D3,0720.863791.0111,8271465.00 D3,3280.934101.0011,7911356.00 D3,5841.004421.0011,7561245.00 D3,8401.074731.0011,7211167.00 D4,0961.145050.9911,6851167.00 D4,3521.215370.9911,6501167.00 D4,6081.295680.9911,6151167.00 D4,8641.366000.9911,5861167.00 D5,1201.436310.9811,5681167.00 Back to Advisory Statistics Back to Top PGA Aggr Summary 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 62.9787,59651,508 Back to Advisory Statistics Back to Top PGA Aggr Target Stats No data exists for this section of the report. Back to Advisory Statistics Back to Top PGA Aggr Target Histogram Optimal Executions are purely in-memory operations Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs 2K4K60,29460,29400 64K128K10410400 128K256K696900 256K512K17317300 512K1024K92892800 1M2M24424400 2M4M565420 4M8M777700 8M16M595630 16M32M616100 32M64M545400 64M128M151139120 128M256M8464200 256M512M141220 512M1024M886820 Back to Advisory Statistics Back to Top PGA Memory Advisory When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 PGA Target Est (MB) Size Factr W/A MB Processed Estd ExtrW/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count Estd Time 2,0160.13358,749.44122,265.3975.0001,688,830,905 4,0320.25358,749.44117,167.6475.0001,670,932,824 8,0640.50358,749.44117,167.6475.0001,670,932,824 12,0960.75358,749.44117,167.6475.0001,670,932,824 16,1281.00358,749.44117,167.6475.0001,670,932,824 19,3541.20358,749.440.00100.0001,259,560,212 22,5791.40358,749.440.00100.0001,259,560,212 25,8051.60358,749.440.00100.0001,259,560,212 29,0301.80358,749.440.00100.0001,259,560,212 32,2562.00358,749.440.00100.0001,259,560,212 48,3843.00358,749.440.00100.0001,259,560,212 64,5124.00358,749.440.00100.0001,259,560,212 96,7686.00358,749.440.00100.0001,259,560,212 129,0248.00358,749.440.00100.0001,259,560,212 Back to Advisory Statistics Back to Top Shared Pool Advisory 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. Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits (K) 7680.2030016,134106,2621.001751.002,400 1,2800.3341522,282106,2621.001751.003,315 1,7920.4741522,282106,2621.001751.003,315 2,3040.6041522,282106,2621.001751.003,315 2,8160.7341522,282106,2621.001751.003,315 3,3280.8741522,282106,2621.001751.003,315 3,8401.0041522,282106,2621.001751.003,315 4,3521.1341522,282106,2621.001751.003,315 4,8641.2741522,282106,2621.001751.003,315 5,3761.4041522,282106,2621.001751.003,315 5,8881.5341522,282106,2621.001751.003,315 6,4001.6741522,282106,2621.001751.003,315 6,9121.8041522,282106,2621.001751.003,315 7,4241.9341522,282106,2621.001751.003,315 7,9362.0741522,282106,2621.001751.003,315 Back to Advisory Statistics Back to Top SGA Target Advisory SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads 5,2800.6342,67411,946,104 6,3360.7542,59711,839,127 7,3920.8842,59711,755,662 8,4481.0042,59711,755,662 9,5041.1342,59711,755,662 10,5601.2542,59711,755,662 11,6161.3842,59711,755,662 12,6721.5042,59711,755,662 13,7281.6342,59711,755,662 14,7841.7542,59711,755,662 15,8401.8842,59711,755,662 16,8962.0042,59711,755,662 Back to Advisory Statistics Back to Top Streams Pool Advisory Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s) 2561.000000 5122.000000 7683.000000 1,0244.000000 1,2805.000000 1,5366.000000 1,7927.000000 2,0488.000000 2,3049.000000 2,56010.000000 2,81611.000000 3,07212.000000 3,32813.000000 3,58414.000000 3,84015.000000 4,09616.000000 4,35217.000000 4,60818.000000 4,86419.000000 5,12020.000000 Back to Advisory Statistics Back to Top Java Pool Advisory No data exists for this section of the report. Back to Advisory Statistics Back to Top Wait Statistics Buffer Wait Statistics Enqueue Activity Back to Top Buffer Wait Statistics ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) undo header6749737 data block1716946 undo block200 Back to Wait Statistics Back to Top Enqueue Activity 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) RO-Multiple Object Reuse (fast object reuse)626106803133,800.00 CF-Controlfile Transaction21,07421,068691124.44 CR-Reuse Block Range (block range reuse ckpt)5,5965,59604030.00 JS-Job Scheduler (queue lock)169,843169,84301020.00 Back to Wait Statistics Back to Top Undo Statistics Undo Segment Summary Undo Segment Stats Back to Top Undo Segment Summary 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 TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU 2475.3616,8453,051616.2/65.90/00/0/0/0/0/0 Back to Undo Statistics Back to Top Undo Segment Stats Most recent 35 Undostat rows, ordered by Time desc End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU 04-Mar 01:5311,1401642,6644590/00/0/0/0/0/0 04-Mar 01:4310,0931622,0642490/00/0/0/0/0/0 04-Mar 01:3313,7271231,4633390/00/0/0/0/0/0 04-Mar 01:232,2852618624290/00/0/0/0/0/0 04-Mar 01:1330,9851582624190/00/0/0/0/0/0 04-Mar 01:032,1053776544260/00/0/0/0/0/0 04-Mar 00:5313,0611862,4043550/00/0/0/0/0/0 04-Mar 00:4314,1821301,8033450/00/0/0/0/0/0 04-Mar 00:3311,1591571,2613360/00/0/0/0/0/0 04-Mar 00:232,2053346613260/00/0/0/0/0/0 04-Mar 00:1330,6292391,2643360/00/0/0/0/0/0 04-Mar 00:039,0753603,0516660/00/0/0/0/0/0 03-Mar 23:539,8091042,4502560/00/0/0/0/0/0 03-Mar 23:4315,8201421,8504460/00/0/0/0/0/0 03-Mar 23:336,8311761,2713360/00/0/0/0/0/0 03-Mar 23:232,5221066703260/00/0/0/0/0/0 03-Mar 23:1328,8773063015200/00/0/0/0/0/0 03-Mar 23:039,4542796733260/00/0/0/0/0/0 03-Mar 22:5313,673226732160/00/0/0/0/0/0 03-Mar 22:4310,2121656772260/00/0/0/0/0/0 03-Mar 22:3336,1902751,2812360/00/0/0/0/0/0 03-Mar 22:2315,6481706802260/00/0/0/0/0/0 03-Mar 22:1378,3664613795170/00/0/0/0/0/0 03-Mar 22:0334,7793,1219834270/00/0/0/0/0/0 03-Mar 21:539,5492333823170/00/0/0/0/0/0 03-Mar 21:433,9991709863270/00/0/0/0/0/0 03-Mar 21:33251133851170/00/0/0/0/0/0 03-Mar 21:23282009892270/00/0/0/0/0/0 03-Mar 21:13171183882170/00/0/0/0/0/0 03-Mar 21:031762469923280/00/0/0/0/0/0 03-Mar 20:53281043922180/00/0/0/0/0/0 03-Mar 20:43111319953280/00/0/0/0/0/0 03-Mar 20:33291283951180/00/0/0/0/0/0 03-Mar 20:2325949983280/00/0/0/0/0/0 Back to Undo Statistics Back to Top Latch Statistics Latch Activity Latch Sleep Breakdown Latch Miss Sources Mutex Sleep Summary Parent Latch Statistics Child Latch Statistics Back to Top Latch Activity "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 Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss AQ deq hash table latch6190.00 00 AQ deq log cmt cbk chunk latch400.00 00 AQ deq log statistics latch190.00 00 AQ dequeue txn counter latch40,5580.00 00 AQ ht cmt cbk chunk latch780.00 00 ASM db client latch32,6490.00 00 ASM map operation hash table130.00 00 ASM network state latch8260.00 00 AWR Alerted Metric Element list330,8360.00 00 Change Notification Hash table latch15,6120.00 00 Consistent RBA11,3360.00 00 DML lock allocation1,000,4810.00 00 Event Group Locks2,5870.00 00 FIB s.o chain latch80.00 00 FOB s.o list latch5,4870.00 00 File State Object Pool Parent Latch130.00 00 IPC stats buffer allocation latch130.00 00 In memory undo latch185,0420.000.80044,2120.00 JS Sh mem access1010.991.0000 JS broadcast autostart latch40.00 00 JS mem alloc latch1440.00 00 JS queue access latch1570.00 00 JS queue state obj latch339,6860.00 00 KFC FX Hash Latch130.00 00 KFC Hash Latch130.00 00 KFCL LE Freelist130.00 00 KGNFS-NFS:SHM structure130.00 00 KGNFS-NFS:SVR LIST130.00 00 KJC message pool free list130.00 00 KJCT flow control latch130.00 00 KMG MMAN ready and startup request latch15,5870.00 00 KTF sga latch2500.00 013,4390.00 KWQMN job cache list latch1770.00 00 KWQP Prop Status260.00 00 KWQS pqsubs latch1180.00 00 KWQS pqueue ctx latch2,5980.00 00 Locator state objects pool parent latch130.00 00 Lsod array latch130.00 00 MQL Tracking Latch0 09340.00 Memory Management Latch130.00 015,5870.00 Memory Queue130.00 00 Memory Queue Message Subscriber #1130.00 00 Memory Queue Message Subscriber #2130.00 00 Memory Queue Message Subscriber #3130.00 00 Memory Queue Message Subscriber #4130.00 00 Memory Queue Subscriber130.00 00 MinActiveScn Latch2050.00 00 Mutex130.00 00 Mutex Stats130.00 00 OS process19,1620.00 00 OS process allocation28,3520.010.0000 OS process: request allocation5,1490.00 00 PL/SQL warning settings31,7600.00 00 PX hash array latch130.00 00 QMT130.00 00 Real-time plan statistics latch95,5680.00 00 SGA IO buffer pool latch75,0800.00 0164,1950.00 SGA blob parent130.00 00 SGA bucket locks130.00 00 SGA heap locks130.00 00 SGA pool locks130.00 00 SQL memory manager latch1,5690.00 015,1720.00 SQL memory manager workarea list latch1,056,6940.00 00 Shared B-Tree7,2790.00 00 Streams Generic130.00 00 Testing130.00 00 Token Manager130.00 00 WCR: sync130.00 00 Write State Object Pool Parent Latch130.00 00 X$KSFQP130.00 00 XDB NFS Security Latch130.00 00 XDB unused session pool130.00 00 XDB used session pool130.00 00 active checkpoint queue latch20,9430.00 00 active service list107,9040.040.26025,8620.00 begin backup scn array250.00 00 buffer pool130.00 00 business card130.00 00 cache buffer handles842,3370.00 00 cache buffers chains179,100,9360.000.14027,707,1030.00 cache buffers lru chain4,855,9530.270.00029,807,9900.01 cache table scan latch91,9830.00 091,9830.00 call allocation18,6420.360.3100 cas latch130.00 00 change notification client cache latch130.00 00 channel handle pool latch5,5170.020.0000 channel operations parent latch302,2360.000.0000 checkpoint queue latch3,204,1190.000.000488,6080.00 client/application info70,5690.00 00 compile environment latch3,4670.00 00 corrupted undo seg latch5140.00 00 cp cmon/server latch130.00 00 cp pool latch130.00 00 cp server hash latch130.00 00 cp sga latch8260.00 00 cvmap freelist lock130.00 00 database property service latch140.00 00 deferred cleanup latch8260.00 00 dml lock allocation8360.00 00 done queue latch130.00 00 dummy allocation6,9480.160.0000 enqueue hash chains2,415,1000.000.0003570.00 enqueues2,117,3580.000.0000 fifth spare latch130.00 00 file cache latch3,9500.00 00 flashback copy130.00 00 gc element130.00 00 gcs commit scn state130.00 00 gcs partitioned table hash130.00 00 gcs pcm hashed value bucket hash130.00 00 gcs resource freelist130.00 00 gcs resource hash130.00 00 gcs resource scan list130.00 00 gcs shadows freelist130.00 00 ges domain table130.00 00 ges enqueue table freelist130.00 00 ges group table130.00 00 ges process hash list130.00 00 ges process parent latch130.00 00 ges resource hash list130.00 00 ges resource scan list130.00 00 ges resource table freelist130.00 00 ges value block free list130.00 00 global KZLD latch for mem in SGA6680.00 00 global ctx hash table latch150.00 00 global tx hash mapping130.00 00 granule operation130.00 00 hash table column usage latch1,4850.00 0352,7400.02 hash table modification latch1,2580.00 00 heartbeat check130.00 00 internal temp table object number allocation latch450.00 00 intra txn parallel recovery130.00 00 io pool granule metadata list130.00 00 job workq parent latch9070.00 08970.78 job_queue_processes free list latch1,8610.00 00 job_queue_processes parameter latch11,0580.00 00 k2q lock allocation130.00 00 kcbtsemkid latch510.00 00 kdlx hb parent latch130.00 00 kgb parent130.00 00 kks stats3,6150.030.0000 kmcptab latch60.00 00 kmcpvec latch0 020.00 kokc descriptor allocation latch14,0060.00 00 ksfv messages130.00 00 kss move lock5370.00 00 ksuosstats global area3,1570.00 00 ksv allocation latch1,8740.00 00 ksv class latch1,0610.00 00 ksv msg queue latch130.00 00 ksz_so allocation latch5,1490.00 00 ktm global data3280.00 00 kwqbsn:qsga2,8660.00 00 lgwr LWN SCN21,9240.00 00 list of block allocation150,2380.00 00 loader state object freelist3220.00 00 lob segment dispenser latch130.00 00 lob segment hash table latch1690.00 00 lob segment query latch130.00 00 lock DBA buffer during media recovery130.00 00 logical standby cache130.00 00 logminer context allocation260.00 00 logminer work area130.00 00 longop free list parent3,1040.00 02930.00 mapped buffers lru chain130.00 00 message pool operations parent latch5,0990.00 00 messages451,6410.060.0000 mostly latch-free SCN21,9490.010.0000 msg queue latch130.00 00 multiblock read objects192,0680.00 00 name-service namespace bucket130.00 00 ncodef allocation latch8260.00 00 object queue header heap158,6800.00 03,9170.00 object queue header operation34,182,4730.010.0100 object stats modification6590.00 00 parallel query alloc buffer6,0810.00 00 parallel query stats130.00 00 parameter list1,9100.00 00 parameter table management6,9960.00 00 peshm130.00 00 pesom_free_list130.00 00 pesom_hash_node130.00 00 post/wait queue1,782,0660.530.0008,4260.83 process allocation7,0530.010.0002,5740.00 process group creation5,1490.080.0000 process queue130.00 00 process queue reference130.00 00 qmn task queue latch6,8340.00 00 query server freelists130.00 00 queued dump request1560.00 00 queuing load statistics130.00 00 recovery domain hash list130.00 00 redo allocation144,9310.020.00012,173,9720.00 redo copy130.00 012,174,0330.00 redo writing90,1391.260.0000 resmgr group change latch15,4430.00 00 resmgr:active threads10,1290.00 02,4080.00 resmgr:actses change group2,0280.00 00 resmgr:actses change state800.00 00 resmgr:free threads list7,0570.130.0000 resmgr:method mem alloc latch200.00 00 resmgr:plan CPU method1090.00 00 resmgr:resource group CPU method4,6330.00 00 resmgr:schema config3,3570.00 02400.00 resmgr:session queuing610.00 00 rm cas latch130.00 00 row cache objects1,902,0590.010.0100 rules engine aggregate statistics200.00 00 rules engine rule set statistics1,3400.00 00 second spare latch130.00 00 sequence cache6,9900.00 00 session allocation156,4290.000.00052,1320.00 session idle bit290,1010.00 00 session queue latch130.00 00 session state list latch6,4630.020.0000 session switching13,7140.00 00 session timer16,4650.00 00 shared pool685,1060.120.2240 shared pool sim alloc1200.00 00 shared pool simulator9,2410.00 00 sim partition latch130.00 00 simulator hash latch8,352,1460.000.0000 simulator lru latch555,1710.020.0006,028,9390.00 sort extent pool39,3290.00 00 space background state object latch1260.00 00 space background task latch34,5810.000.00031,1730.00 state object free list260.00 00 statistics aggregation7,2800.00 00 tablespace key chain180.00 00 temp lob duration state obj allocation320.00 00 temporary table state object allocation160.00 00 test excl. parent l0130.00 00 test excl. parent2 l0130.00 00 third spare latch130.00 00 threshold alerts latch1,7150.00 00 transaction allocation238,5750.00 00 undo global data2,057,9410.000.00030.00 virtual circuit buffers130.00 00 virtual circuit holder130.00 00 virtual circuit queues130.00 00 Back to Latch Statistics Back to Top Latch Sleep Breakdown ordered by misses desc Latch Name Get Requests Misses Sleeps Spin Gets cache buffers lru chain4,855,95313,2443813,206 object queue header operation34,182,4732,489252,465 shared pool685,106851184672 row cache objects1,902,0592462244 call allocation18,642682148 active service list107,904421131 cache buffers chains179,100,93642636 In memory undo latch185,042541 JS Sh mem access101110 Back to Latch Statistics Back to Top Latch Miss Sources only latches with sleeps are shown ordered by name, sleeps desc Latch Name Where NoWait Misses Sleeps Waiter Sleeps In memory undo latchktiFlush: child040 JS Sh mem accessjsksGetShMemLatch011 active service listkswslogon: session logout01313 cache buffers chainskcbgtcr: fast path030 cache buffers chainskcbgcur_2021 cache buffers chainskcbgtcr: fast path (cr pin)020 cache buffers chainskcbchg1: kslbegin: bufs not pinned012 cache buffers chainskcbgcur_6010 cache buffers lru chainkcbzgws0220 cache buffers lru chainkcbzgb_10104 cache buffers lru chainkcbzgb040 cache buffers lru chainkcbbic20232 call allocationksuxds02120 channel operations parent latchksrchdelete_sub()011 object queue header operationkcbo_unlink_q0252 object queue header operationkcbo_switch_cq051 object queue header operationkcbo_link_q030 object queue header operationkcbo_ivbo020 object queue header operationkcbo_switch_mq_bg0225 row cache objectskqreqd010 row cache objectskqreqd: reget010 shared poolkghalo014984 shared poolkghalp01822 shared poolkghupr101153 shared poolkgh_heap_sizes043 shared poolkghfre0221 Back to Latch Statistics Back to Top Mutex Sleep Summary ordered by number of sleeps desc Mutex Type Location Sleeps Wait Time (ms) Library Cachekglhdgn2 1065,86713 Library Cachekgllkdl1 85150 Library Cachekglget2 21-0 Library Cachekglpndl1 951-0 Back to Latch Statistics Back to Top Parent Latch Statistics No data exists for this section of the report. Back to Latch Statistics Back to Top Child Latch Statistics No data exists for this section of the report. Back to Latch Statistics Back to Top Segment Statistics Segments by Logical Reads Segments by Physical Reads Segments by Physical Read Requests Segments by UnOptimized Reads Segments by Optimized Reads Segments by Direct Physical Reads Segments by Physical Writes Segments by Physical Write Requests Segments by Direct Physical Writes Segments by Table Scans Segments by DB Blocks Changes Segments by Row Lock Waits Segments by ITL Waits Segments by Buffer Busy Waits Back to Top Segments by Logical Reads Total Logical Reads: 48,973,482 Captured Segments account for 79.3% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total SYSSYSTEMOK_EDGE_SCC TABLE8,489,31217.33 SYSTEMPEDGE_TEMP TABLE4,909,36010.02 SYSTEMPEDGE_TEMP TABLE4,896,62410.00 ** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED4,424,1449.03 SYSTEMPEDGE_TEMP TABLE3,850,2727.86 Back to Segment Statistics Back to Top Segments by Physical Reads Total Physical Reads: 14,105,729 Captured Segments account for 87.8% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total SYSSYSTEMOK_EDGE_SCC TABLE8,149,83157.78 SYSSYSTEMOK_EDGE TABLE2,077,96114.73 SYSTEMPEDGE_TEMP TABLE1,043,7007.40 SYSTEMPEDGE_TEMP TABLE1,043,6007.40 SYSSYSTEMCP_EDGE_SCC TABLE56,1650.40 Back to Segment Statistics Back to Top Segments by Physical Read Requests Total Physical Read Requests: 1,320,973 Captured Segments account for 7.9% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Phys Read Requests %Total SYSSYSTEMOK_EDGE_SCC TABLE69,1685.24 SYSSYSTEMOK_EDGE TABLE17,7411.34 SYSTEMPEDGE_TEMP TABLE8,2670.63 SYSTEMPEDGE_TEMP TABLE8,1580.62 SYSSYSTEMCP_EDGE_SCC TABLE4540.03 Back to Segment Statistics Back to Top Segments by UnOptimized Reads Total UnOptimized Read Requests: 1,320,973 Captured Segments account for 7.9% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type UnOptimized Reads %Total SYSSYSTEMOK_EDGE_SCC TABLE69,1685.24 SYSSYSTEMOK_EDGE TABLE17,7411.34 SYSTEMPEDGE_TEMP TABLE8,2670.63 SYSTEMPEDGE_TEMP TABLE8,1580.62 SYSSYSTEMCP_EDGE_SCC TABLE4540.03 Back to Segment Statistics Back to Top Segments by Optimized Reads No data exists for this section of the report. Back to Segment Statistics Back to Top Segments by Direct Physical Reads Total Direct Physical Reads: 2,749,465 Captured Segments account for 38.0% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Reads %Total SYSTEMPEDGE_TEMP TABLE521,83318.98 SYSTEMPEDGE_TEMP TABLE521,79818.98 Back to Segment Statistics Back to Top Segments by Physical Writes Total Physical Writes: 3,727,291 Captured Segments account for 40.1% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Writes %Total SYSTEMPEDGE_TEMP TABLE501,01113.44 SYSTEMPEDGE_TEMP TABLE500,87513.44 SYSTEMPEDGE_TEMP TABLE439,51611.79 SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX9,5420.26 SYSTEMPK_CORE TABLE5,8740.16 Back to Segment Statistics Back to Top Segments by Physical Write Requests Total Physical Write Requestss: 1,231,462 Captured Segments account for 77.5% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Phys Write Requests %Total SYSTEMPEDGE_TEMP TABLE310,49225.21 SYSTEMPEDGE_TEMP TABLE309,63225.14 SYSTEMPEDGE_TEMP TABLE300,86724.43 SYSTEMPK_CORE TABLE4,9090.40 SYSTEMPK_CORE TABLE4,7250.38 Back to Segment Statistics Back to Top Segments by Direct Physical Writes Total Direct Physical Writes: 1,702,049 Captured Segments account for 0.0% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Writes %Total ** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED5520.03 SYSTEMPSYS_TEMP_0FD9D6617_25E0ADE TABLE1250.01 SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_62695005_3054TABLE PARTITION1120.01 SYSSYSAUXSYS_LOB0000006207C00004$$ LOB60.00 SYSSYSAUXSYS_LOB0000006213C00038$$ LOB60.00 Back to Segment Statistics Back to Top Segments by Table Scans Total Table Scans: 1,182 Captured Segments account for 19.5% of Total Owner Tablespace Name Object Name Subobject Name Obj. Type Table Scans %Total SYSSYSTEMI_OBJ2 INDEX1119.39 SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX100.85 SYSSYSAUXWRH$_SERVICE_WAIT_CLASS_PKWRH$_SERVIC_62695005_3030INDEX PARTITION90.76 SYSSYSTEMOK_EDGE_SCC TABLE80.68 SYSSYSAUXWRH$_OSSTAT_PKWRH$_OSSTAT_62695005_3030INDEX PARTITION70.59 Back to Segment Statistics Back to Top Segments by DB Blocks Changes % of Capture shows % of DB Block Changes for each top segment compared with total DB Block Changes for all segments captured by the Snapshot Owner Tablespace Name Object Name Subobject Name Obj. Type DB Block Changes % of Capture ** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED3,945,95219.79 SYSTEMPEDGE_TEMP TABLE3,746,64018.79 SYSTEMPEDGE_TEMP TABLE3,746,41618.79 SYSTEMPEDGE_TEMP TABLE3,746,38418.79 ** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED273,9361.37 Back to Segment Statistics Back to Top Segments by Row Lock Waits % of Capture shows % of row lock waits for each top segment compared with total row lock waits for all segments captured by the Snapshot Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_62695005_3054INDEX PARTITION2100.00 Back to Segment Statistics Back to Top Segments by ITL Waits No data exists for this section of the report. Back to Segment Statistics Back to Top Segments by Buffer Busy Waits % of Capture shows % of Buffer Busy Waits for each top segment compared with total Buffer Busy Waits for all segments captured by the Snapshot Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture SYSSYSTEMJOB$ TABLE17100.00 Back to Segment Statistics Back to Top Dictionary Cache Stats "Pct Misses" should be very low (< 2% in most cases) "Final Usage" is the number of cache entries being used Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage dc_awr_control1,1170.000 261 dc_constraints15033.330 1501 dc_files650.000 05 dc_global_oids55,3180.000 0127 dc_histogram_data23,73213.440 3,77613,740 dc_histogram_defs26,67815.780 2,6897,304 dc_object_grants400.000 097 dc_objects100,9750.410 3695,206 dc_profiles2,2500.000 02 dc_rollback_segments11,7840.000 022 dc_segments15,8490.080 1681,628 dc_sequences540.000 5418 dc_table_scns56100.000 00 dc_tablespaces86,5600.000 07 dc_users290,3540.010 0275 global database name32,8840.000 01 outstanding_alerts3593.060 207 sch_lj_objs1816.670 011 sch_lj_oids844.760 022 Back to Top Library Cache Activity "Pct Misses" should be very low Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations APP CONTEXT1050.001050.0000 BODY24,3270.00113,8410.0000 CLUSTER3260.001330.0000 DBLINK1,3660.000 00 DIRECTORY10.0020.0000 EDITION1,7620.003,3150.0000 INDEX2,8010.142,32811.171420 OBJECT ID73100.000 00 QUEUE111,8050.00134,1180.0000 RULESET200.00200.0000 SCHEMA3,5510.000 00 SQL AREA45,6793.50570,9011.261,1841,155 SUBSCRIPTION1700.001700.0000 TABLE/PROCEDURE74,9820.20174,3550.684250 TEMPORARY INDEX1535.23153100.001450 TEMPORARY TABLE4061.23406100.004010 TRIGGER14,0090.0015,0270.0000 Back to Top Memory Statistics Memory Dynamic Components Memory Resize Operations Summary Memory Resize Ops Process Memory Summary SGA Memory Summary SGA breakdown difference Back to Top Memory Dynamic Components Min/Max sizes since instance startup Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred ordered by Component Component Begin Snap Size (Mb) Current Size (Mb) Min Size (Mb) Max Size (Mb) Oper Count Last Op Typ/Mod ASM Buffer Cache0.000.000.000.000STA/ DEFAULT 16K buffer cache0.000.000.000.000STA/ DEFAULT 2K buffer cache0.000.000.000.000STA/ DEFAULT 32K buffer cache0.000.000.000.000STA/ DEFAULT 4K buffer cache0.000.000.000.000STA/ DEFAULT 8K buffer cache0.000.000.000.000STA/ DEFAULT buffer cache3,584.003,584.003,584.003,584.000STA/ KEEP buffer cache0.000.000.000.000STA/ PGA Target16,128.0016,128.0016,128.0016,128.000STA/ RECYCLE buffer cache0.000.000.000.000STA/ SGA Target8,448.008,448.008,448.008,448.000STA/ Shared IO Pool0.000.000.000.000STA/ java pool256.00256.00256.00256.000STA/ large pool256.00256.00256.00256.000STA/ shared pool3,840.003,840.003,840.003,840.000STA/ streams pool256.00256.00256.00256.000STA/ Back to Memory Statistics Back to Top Memory Resize Operations Summary No data exists for this section of the report. Back to Memory Statistics Back to Top Memory Resize Ops No data exists for this section of the report. Back to Memory Statistics Back to Top Process Memory Summary 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 Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc BOther83.03 2.442.9112253434 Freeable30.190.001.893.0512 1616 PL/SQL7.517.270.230.54333232 SQL0.530.250.030.0302202014 EFreeable301.750.0021.5570.67267 1414 Other76.51 2.322.6712253333 PL/SQL9.489.170.310.63333131 SQL0.620.310.030.0401,3502015 Back to Memory Statistics Back to Top SGA Memory Summary SGA regions Begin Size (Bytes) End Size (Bytes) (if different) Database Buffers3,758,096,384 Fixed Size2,213,776 Redo Buffers151,166,976 Variable Size21,743,274,096 Back to Memory Statistics Back to Top SGA breakdown difference 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 javafree memory256.00256.000.00 largePX msg pool7.817.810.00 largefree memory248.19248.190.00 sharedCCUR44.0551.1916.20 sharedSQLA186.21222.6719.58 sharedfree memory3,358.473,307.95-1.50 streamsfree memory254.73254.73-0.00 buffer_cache3,584.003,584.000.00 fixed_sga2.112.110.00 log_buffer144.16144.160.00 Back to Memory Statistics Back to Top Streams Statistics Streams CPU/IO Usage Streams Capture Streams Capture Rate Streams Apply Streams Apply Rate Buffered Queues Buffered Queue Subscribers Rule Set Persistent Queues Persistent Queues Rate Persistent Queue Subscribers Back to Top Streams CPU/IO Usage Streams processes ordered by Foreground CPU Time, descending Session Type First Logon Foreground CPU time(s) User IO Wait time(s) SYS IO Wait time(s) QMON Slaves0301 09:33:571.590.000.00 QMON Coordinator0301 09:33:470.760.000.00 Back to Streams Statistics Back to Top Streams Capture No data exists for this section of the report. Back to Streams Statistics Back to Top Streams Capture Rate No data exists for this section of the report. Back to Streams Statistics Back to Top Streams Apply No data exists for this section of the report. Back to Streams Statistics Back to Top Streams Apply Rate No data exists for this section of the report. Back to Streams Statistics Back to Top Buffered Queues No data exists for this section of the report. Back to Streams Statistics Back to Top Buffered Queue Subscribers No data exists for this section of the report. Back to Streams Statistics Back to Top Rule Set Rule Sets ordered by Evaluations * indicates Rule Set activity (re)started between Begin/End snaps SQL per Eval - average # of SQL statements executed for non-SQL free evals CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals Rule Evals No-SQL Eval% SQL Execs CPU(s) Ela(s) Eval /Sec SQL per Eval Ela(s) per Eval CPU(s) per Eval Reloads SYS.ALERT_QUE_R 200.0000.000.000.000.000.000.000 Back to Streams Statistics Back to Top Persistent Queues Ordered by Queue Name * indicates queue (re)started between Begin/End snaps %Exp Msgs - % of msgs enqueued with expiry %Delay Msgs - % of msgs enqueued with delay %Trasf Time - % of Enqueue time spent in transformation %Eval Time - % of Enqueue time spent in rule evaluation Queue Name Enq Msgs Deq Msgs %Exp Msgs %Delay Msgs Enq Time(s) Deq Time(s) %Transf Time %Eval Time SYS.ALERT_QUE(12343) 2020100.000.006.3027.370.000.02 SYSMAN.MGMT_NOTIFY_Q(66903) 00 0.000.00 SYSMAN.MGMT_TASK_Q(66573) 8238230.000.000.0912.650.000.00 Back to Streams Statistics Back to Top Persistent Queues Rate Ordered by Queue Name * indicates queue (re)started between Begin/End snaps Queue Name Enqueue Msgs/sec Dequeue Msgs/sec Avg Enqueue sec / msg Avg Dequeue sec / msg SYS.ALERT_QUE(12343) 0.000.000.321.37 SYSMAN.MGMT_NOTIFY_Q(66903) 0.000.00 SYSMAN.MGMT_TASK_Q(66573) 0.020.020.000.02 Back to Streams Statistics Back to Top Persistent Queue Subscribers Ordered by Queue Name, Subscriber Name * indicates Subscriber activity (re)started between Begin/End snaps Subscriber/Queue Enqueue Msgs Dequeue Msgs Expire Msgs Enqueue Msgs/sec Dequeue Msgs/sec Expire Msgs/sec HAE_SUB(1)/SYS.ALERT_QUE 000 SEPC221_SE_CU_3938_SEPC221(22)/SYS.ALERT_QUE 202000.000.000.00 Back to Streams Statistics Back to Top Resource Limit Stats No data exists for this section of the report. Back to Top Shared Server Statistics Shared Servers Activity Shared Servers Rates Shared Servers Utilization Shared Servers Common Queue Shared Servers Dispatchers Back to Top Shared Servers Activity Values represent averages for all samples Avg Total Connections Avg Active Connections Avg Total Shared Srvrs Avg Active Shared Srvrs Avg Total Dispatchers Avg Active Dispatchers 001010 Back to Shared Server Statistics Back to Top Shared Servers Rates Common Queue Per Sec Disp Queue Per Sec Server Msgs/Sec Server KB/Sec Common Queue Total Disp Queue Total Server Total Msgs Server Total(KB) 0000.000000 Back to Shared Server Statistics Back to Top Shared Servers Utilization Statistics are combined for all servers Incoming and Outgoing Net % are included in %Busy Total Server Time (s) %Busy %Idle Incoming Net % Outgoing Net % 46,7700.00100.000.000.00 Back to Shared Server Statistics Back to Top Shared Servers Common Queue No data exists for this section of the report. Back to Shared Server Statistics Back to Top Shared Servers Dispatchers 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 Name Avg Conns Total Disp Time (s) %Busy %Idle Total Queued Total Queue Wait (s) Avg Queue Wait (ms) D0000.0046,7700.00100.0000 Back to Shared Server Statistics Back to Top init.ora Parameters if IP/Public/Source at End snap is different a '*' is displayed Parameter Name Begin value End value (if different) _db_fast_obj_truncateTRUE audit_file_dest/u01/app/oracle/admin/sepc221/adump audit_trailFALSE compatible11.2.0.0.0 control_files/u01/app/oracle/oradata/sepc221/control01.ctl, /u01/app/oracle/flash_recovery_area/sepc221/control02.ctl db_block_size8192 db_domainse.cuhk.edu.hk db_namesepc221 db_recovery_file_dest/u01/app/oracle/flash_recovery_area db_recovery_file_dest_size4070572032 diagnostic_dest/u01/app/oracle dispatchers(PROTOCOL=TCP) (SERVICE=sepc221XDB) memory_max_target25769803776 memory_target25769803776 open_cursors300 processes150 remote_login_passwordfileEXCLUSIVE undo_tablespaceUNDOTBS1 Back to Top Dynamic Remastering Stats No data exists for this section of the report. Back to Top End of Report