oracle的AWR报告样式供参考学习
发布时间：2020-12-12 18:46:20 所属栏目：百科 来源：网络整理
导读：oracle的AWR报告样式供参考学习 WORKLOAD REPOSITORY report for(example for learning) DB Name DB Id Instance Inst num Startup Time Release RAC ORCL 14498***** orcl 1 13-Sep-16 15:09 11.2.0.4.0 NO Host Name Platform CPUs Cores Sockets Memory (
|
oracle的AWR报告样式供参考学习
WORKLOAD REPOSITORY report for(example for learning)
| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC | ORCL 14498***** orcl 1 13-Sep-16 15:09 11.2.0.4.0 NOHost Name | Platform | CPUs | Cores | Sockets | Memory (GB) | rhel6712971 Linux x86 64-bit 4 4 2 31.68Snap Id | Snap Time | Sessions | Cursors/Session | Begin Snap: 3874 22-Feb-17 01:00:49 109 5.2 End Snap: 3882 22-Feb-17 09:00:06 108 5.3 Elapsed: 479.29 (mins) DB Time: 0.32 (mins)Per Second | Per Transaction | Per Exec | Per Call | DB Time(s): 0.0 0.0 0.00 0.00 DB CPU(s): 0.0 0.0 0.00 0.01 Redo size (bytes): 2,477.5 23,996.5 Logical read (blocks): 32.4 314.3 Block changes: 16.4 158.9 Physical read (blocks): 0.2 2.4 Physical write (blocks): 0.5 5.2 Read IO requests: 0.2 2.4 Write IO requests: 0.3 2.7 Read IO (MB): 0.0 0.0 Write IO (MB): 0.0 0.0 User calls: 0.2 2.0 Parses (SQL): 2.1 19.8 Hard parses (SQL): 0.0 0.1 SQL Work Area (MB): 0.0 0.1 Logons: 0.1 0.6 Executes (SQL): 3.3 31.8 Rollbacks: 0.0 0.0 Transactions: 0.1Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class | DB CPU 30.1 159.0 log file sync 738 .5 1 2.7 Commit db file sequential read 6,818 .1 0 .3 User I/O direct path sync 1 0 13 .1 User I/O Disk file operations I/O 208 0 0 .1 User I/O SQL*Net message to client 384 0 0 .0 Network control file sequential read 120 0 0 .0 System I/O latch free 1 0 0 .0 Other latch: shared pool 11 0 0 .0 Concurrency direct path write temp 1 0 0 .0 User I/OWait Class | Waits | Total Wait Time (sec) | Avg Wait (ms) | % DB time | Avg Active Sessions | DB CPU 30 159.0 0.0 System I/O 79,886 22 0 116.1 0.0 Concurrency 1,144 14 12 74.1 0.0 Commit 756 1 1 2.8 0.0 Other 1,773 0 0 1.2 0.0 User I/O 7,839 0 0 .5 0.0 Configuration 2 0 7 .1 0.0 Application 41 0 0 .0 0.0 Network 1,152 0 0 .0 0.0CPUs | Cores | Sockets | Load Average Begin | Load Average End | %User | %System | %WIO | %Idle | 4 4 2 0.00 0.00 0.2 0.1 0.0 99.7%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) | 0.2 76.2 0.0Read+Write Per Second | Read per Second | Write Per Second | Total Requests: 3.4 2.2 1.2 Database Requests: 0.5 0.2 0.3 Optimized Requests: 0.0 0.0 0.0 Redo Requests: 0.2 0.0 0.2 Total (MB): 0.1 0.0 0.0 Database (MB): 0.0 0.0 0.0 Optimized Total (MB): 0.0 0.0 0.0 Redo (MB): 0.0 0.0 0.0 Database (blocks): 0.8 0.2 0.5 Via Buffer Cache (blocks): 0.8 0.2 0.5 Direct (blocks): 0.0 0.0 0.0Begin | End | Host Mem (MB): 32,440.9 32,440.9 SGA use (MB): 2,048.0 2,048.0 PGA use (MB): 263.7 262.4 % Host Mem used for SGA+PGA: 7.13 7.12Begin | End | Buffer Cache: 752M 752M Std Block Size: 8K Shared Pool Size: 985M 984M Log Buffer: 16,140K | Begin | End | Memory Usage %: 85.52 85.56 % SQL with executions>1: 94.56 88.22 % Memory for SQL w/exec>1: 93.33 78.58Statistic Name | Time (s) | % of DB Time | DB CPU 30.11 158.95 sql execute elapsed time 11.41 60.24 PL/SQL execution elapsed time 3.07 16.20 parse time elapsed 1.31 6.90 connection management call elapsed time 0.86 4.54 hard parse (sharing criteria) elapsed time 0.19 0.98 hard parse elapsed time 0.18 0.97 repeated bind elapsed time 0.00 0.01 sequence load elapsed time 0.00 0.00 DB time 18.95 background elapsed time 340.34 background cpu time 218.14Statistic | Value | End Value | BUSY_TIME 32,572 IDLE_TIME 11,431,930 IOWAIT_TIME 2,483 NICE_TIME 229 SYS_TIME 6,473 USER_TIME 25,801 RSRC_MGR_CPU_WAIT_TIME 0 PHYSICAL_MEMORY_BYTES 34,016,796,672 NUM_CPUS 4 NUM_CPU_CORES 4 NUM_CPU_SOCKETS 2 GLOBAL_RECEIVE_SIZE_MAX 4,194,304 GLOBAL_SEND_SIZE_MAX 1,048,586 TCP_RECEIVE_SIZE_DEFAULT 87,380 TCP_RECEIVE_SIZE_MAX 4,304 TCP_RECEIVE_SIZE_MIN 4,096 TCP_SEND_SIZE_DEFAULT 16,384 TCP_SEND_SIZE_MAX 4,304 TCP_SEND_SIZE_MIN 4,096Snap Time | Load | %busy | %user | %sys | %idle | %iowait | 22-Feb 01:00:49 0.00 22-Feb 02:00:51 0.00 0.31 0.25 0.06 99.69 0.02 22-Feb 03:00:53 0.00 0.28 0.22 0.06 99.72 0.02 22-Feb 04:00:55 0.08 0.28 0.22 0.06 99.72 0.02 22-Feb 05:00:57 0.00 0.27 0.22 0.05 99.73 0.02 22-Feb 06:00:59 0.00 0.28 0.22 0.06 99.72 0.02 22-Feb 07:00:02 0.00 0.28 0.22 0.05 99.72 0.02 22-Feb 08:00:04 0.00 0.28 0.22 0.05 99.72 0.02 22-Feb 09:00:06 0.00 0.29 0.23 0.06 99.71 0.03Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time | DB CPU 30 158.95 Commit 738 0 1 1 2.69 User I/O 7,028 0 0 0 0.40 Network 384 0 0 0 0.00 System I/O 120 0 0 0 0.00 Other 1 0 0 0 0.00 Concurrency 11 0 0 0 0.00 Application 0 0 0.00 Configuration 0 0 0.00Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time | log file sync 738 0 1 1 0.25 2.69 db file sequential read 6,818 0 0 0 2.30 0.27 direct path sync 1 0 0 13 0.00 0.07 Disk file operations I/O 208 0 0 0 0.07 0.05 SQL*Net message from client 384 0 115,203 300007 0.13 jobq slave wait 62,178 100 31,138 501 20.94Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time | control file parallel write 10,283 0 14 1 3.46 4.16 os thread startup 1,119 0 14 13 0.38 4.12 db file async I/O submit 8,100 0 4 0 2.73 1.17 log file parallel write 5,725 0 3 1 1.93 1.02 control file sequential read 55,650 0 0 0 18.74 0.12 ADR block file read 120 0 0 1 0.04 0.04 enq: CR - block range reuse ckpt 41 0 0 1 0.01 0.01 log file switch completion 2 0 0 7 0.00 0.00 rdbms ipc reply 2 0 0 7 0.00 0.00 log file sync 18 0 0 1 0.01 0.00 ADR block file write 40 0 0 0 0.01 0.00 Disk file operations I/O 555 0 0 0 0.19 0.00 library cache: mutex X 8 0 0 1 0.00 0.00 asynch descriptor resize 1,311 100 0 0 0.44 0.00 reliable message 106 0 0 0 0.04 0.00 db file single write 14 0 0 0 0.00 0.00 enq: RO - fast object reuse 41 0 0 0 0.01 0.00 db file sequential read 243 0 0 0 0.08 0.00 LGWR wait for redo copy 90 0 0 0 0.03 0.00 log file single write 4 0 0 0 0.00 0.00 rdbms ipc message 146,003 96 344,883 2362 49.18 DIAG idle wait 57,385 100 57,437 1001 19.33 Streams AQ: waiting for time management or cleanup tasks 2 50 57,096 28548010 0.00 Space Manager: slave idle wait 8,441 99 41,858 4959 2.84 dispatcher timer 480 100 28,804 60008 0.16 Streams AQ: qmn slave idle wait 1,027 0 28,765 28009 0.35 Streams AQ: qmn coordinator idle wait 2,054 50 28,765 14004 0.69 smon timer 128 74 28,755 224646 0.04 pmon timer 9,578 100 28,755 3002 3.23 shared server idle wait 958 100 28,748 30008 0.32 VKRM Idle 1 0 14,400 14399900 0.00 SQL*Net message from client 960 0 0 0 0.32 class slave wait 163 0 0 0 0.05% of Waits | Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s | ADR block file read 120 75.0 4.2 8.3 12.5 1s" class="awrcrb"> ADR block file write 40 100.0 1s" class="awrncrb"> ADR file lock 48 100.0 1s" class="awrcrb"> Disk file operations I/O 764 100.0 1s" class="awrncrb"> LGWR wait for redo copy 90 100.0 1s" class="awrcrb"> SQL*Net message to client 1152 100.0 1s" class="awrncrb"> asynch descriptor resize 1311 100.0 1s" class="awrcrb"> buffer busy waits 4 100.0 1s" class="awrncrb"> control file parallel write 10.3K 11.7 85.6 2.1 .2 .1 .1 .2 1s" class="awrcrb"> control file sequential read 55.8K 100.0 1s" class="awrncrb"> db file async I/O submit 8100 96.3 3.1 .3 .1 .0 .1 .0 1s" class="awrcrb"> db file sequential read 7061 100.0 .0 1s" class="awrncrb"> db file single write 14 100.0 1s" class="awrcrb"> direct path sync 1 100.0 1s" class="awrncrb"> direct path write temp 1 100.0 1s" class="awrcrb"> enq: CR - block range reuse ckpt 41 65.9 31.7 2.4 1s" class="awrncrb"> enq: RO - fast object reuse 41 100.0 1s" class="awrcrb"> latch free 2 100.0 1s" class="awrncrb"> latch: cache buffers chains 1 100.0 1s" class="awrcrb"> latch: call allocation 13 100.0 1s" class="awrncrb"> latch: shared pool 12 100.0 1s" class="awrcrb"> library cache: mutex X 8 87.5 12.5 1s" class="awrncrb"> log file parallel write 5725 95.8 1.7 1.3 .9 .2 .0 .1 1s" class="awrcrb"> log file sequential read 4 100.0 1s" class="awrncrb"> log file single write 4 100.0 1s" class="awrcrb"> log file switch completion 2 100.0 1s" class="awrncrb"> log file sync 756 97.8 .9 .4 .3 .1 .1 .4 1s" class="awrcrb"> os thread startup 1119 97.1 2.9 1s" class="awrncrb"> rdbms ipc reply 2 50.0 50.0 1s" class="awrcrb"> reliable message 106 100.0 1s" class="awrncrb"> DIAG idle wait 57.4K 100.0 1s" class="awrcrb"> SQL*Net message from client 1344 85.4 .2 .1 1s" class="awrncrb">14.3 Space Manager: slave idle wait 8438 .0 .0 .0 .0 .5 1s" class="awrcrb">99.5 Streams AQ: qmn coordinator idle wait 2054 50.0 1s" class="awrncrb">50.0 Streams AQ: qmn slave idle wait 1027 1s" class="awrcrb">100.0 Streams AQ: waiting for time management or cleanup tasks 2 50.0 1s" class="awrncrb">50.0 VKRM Idle 1 1s" class="awrcrb">100.0 class slave wait 163 100.0 1s" class="awrncrb"> dispatcher timer 480 1s" class="awrcrb">100.0 jobq slave wait 62.2K .0 .0 100.0 1s" class="awrncrb"> pmon timer 9578 1s" class="awrcrb">100.0 rdbms ipc message 146K 1.4 .3 .2 .4 .6 .2 40.1 1s" class="awrncrb">56.6 shared server idle wait 959 1s" class="awrcrb">100.0 smon timer 128 1.6 1.6 .8 1.6 14.1 1s" class="awrncrb">80.5% of Total Waits | Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s | control file parallel write 25 99.8 .2 .1 .0 =2s" class="awrcrb"> db file async I/O submit 4 100.0 .0 .0 .0 =2s" class="awrncrb"> log file parallel write 4 99.9 .1 =2s" class="awrcrb"> log file sync 3 99.6 .4 =2s" class="awrncrb">Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) | SYS$USERS 19 30 7 385 SYS$BACKGROUND 0 0 0 548 orcl 0 0 0 0 orclXDB 0 0 0 0Service 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$USERS 7028 0 11 0 0 0 384 0 SYS$BACKGROUND 811 0 1132 14 0 0 0 0 orcl 0 0 0 0 0 0 0 0Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text | 9.22 479 0.02 48.68 99.59 0.78 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := ... 2.62 958 0.00 13.81 105.73 0.00 aykvshm7zsabd select size_for_estimate,size... 1.99 958 0.00 10.49 98.54 0.00 772s25v1y0x8k select shared_pool_size_for_es... 1.85 440 0.00 9.75 99.34 2.88 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_... 1.18 8 0.15 6.21 99.93 0.00 bunssq950snhf insert into wrh$_sga_target_ad... 1.16 8 0.15 6.13 99.98 0.00 dayq182sk41ks insert into wrh$_memory_target... 1.15 8 0.14 6.09 99.98 0.00 bm2pwrpcr8ru6 select sga_size s,sga_size_fa... 1.08 27,505 0.00 5.68 100.94 0.00 cm5vu20fhtnq1 select /*+ connect_by_filterin... 0.73 5,748 0.00 3.87 13.11 0.00 5ms6rbzdnq16t select job,nvl2(last_date,1,... 0.60 8 0.08 3.19 99.95 0.00 66gs90fyynks7 insert into wrh$_instance_reco... 0.52 958 0.00 2.74 68.68 0.00 fvkynu9xgck8h select PGA_TARGET_FOR_ESTIMATE... 0.51 3 0.17 2.69 97.25 0.19 bzscyq07w79ab delete /*+ dynamic_sampling(4)... 0.50 8 0.06 2.65 100.29 0.01 4dy1xm4nxc0gf insert into wrh$_system_event ... 0.44 479 0.00 2.30 97.43 0.33 7vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION... 0.42 8 0.05 2.23 99.82 0.00 84k66tf2s7y1c insert into wrh$_bg_event_summ... 0.41 8 0.05 2.14 99.80 0.09 6ajkhukk78nsr begin prvt_hdm.auto_execute( :... 0.39 1 0.39 2.07 99.97 0.00 acc988uzvjmmt delete from WRH$_SYSMETRIC_HIS... 0.38 3 0.13 2.01 100.35 13.65 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) F... 0.33 8 0.04 1.74 100.09 0.01 586b2udq6dbng insert into wrh$_sysstat (snap... 0.33 504 0.00 1.73 96.90 0.00 4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TA... 0.28 48 0.01 1.50 100.71 0.00 6mvfay19q3v4n SELECT COUNT(CLIENT_INFO) FROM... 0.26 47 0.01 1.39 99.37 0.00 dqbhc9r7gz0a5 SELECT DECODE(COUNT(CLIENT_INF... 0.25 1,086 0.00 1.33 97.18 0.51 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR... 0.25 528 0.00 1.32 98.59 0.00 cumjq42201t37 select u1.user#,u2.user#,u3.... 0.24 8 0.03 1.27 99.85 0.01 7g732rx16j8jc insert into WRH$_SERVICE_STAT ... 0.24 721 0.00 1.24 78.93 0.00 0k8522rmdzg4k select privilege# from sysauth... 0.20 528 0.00 1.08 94.92 0.51 aq8yqxyyb40nn update sys.job$ set this_date=... 0.19 1,713 0.00 1.00 104.07 0.00 5kyb5bvnu3s04 SELECT DISTINCT METRIC_GUID FR...CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text | 9.18 479 0.02 30.50 9.22 99.59 0.78 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := ... 2.77 958 0.00 9.18 2.62 105.73 0.00 aykvshm7zsabd select size_for_estimate,size... 1.96 958 0.00 6.50 1.99 98.54 0.00 772s25v1y0x8k select shared_pool_size_for_es... 1.84 440 0.00 6.10 1.85 99.34 2.88 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_... 1.18 8 0.15 3.90 1.18 99.93 0.00 bunssq950snhf insert into wrh$_sga_target_ad... 1.16 8 0.15 3.85 1.16 99.98 0.00 dayq182sk41ks insert into wrh$_memory_target... 1.15 8 0.14 3.83 1.15 99.98 0.00 bm2pwrpcr8ru6 select sga_size s,sga_size_fa... 1.09 27,505 0.00 3.61 1.08 100.94 0.00 cm5vu20fhtnq1 select /*+ connect_by_filterin... 0.60 8 0.08 2.01 0.60 99.95 0.00 66gs90fyynks7 insert into wrh$_instance_reco... 0.50 8 0.06 1.67 0.50 100.29 0.01 4dy1xm4nxc0gf insert into wrh$_system_event ... 0.49 3 0.16 1.64 0.51 97.25 0.19 bzscyq07w79ab delete /*+ dynamic_sampling(4)... 0.42 479 0.00 1.41 0.44 97.43 0.33 7vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION... 0.42 8 0.05 1.40 0.42 99.82 0.00 84k66tf2s7y1c insert into wrh$_bg_event_summ... 0.40 8 0.05 1.34 0.41 99.80 0.09 6ajkhukk78nsr begin prvt_hdm.auto_execute( :... 0.39 1 0.39 1.30 0.39 99.97 0.00 acc988uzvjmmt delete from WRH$_SYSMETRIC_HIS... 0.38 3 0.13 1.27 0.38 100.35 13.65 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) F... 0.36 958 0.00 1.18 0.52 68.68 0.00 fvkynu9xgck8h select PGA_TARGET_FOR_ESTIMATE... 0.33 8 0.04 1.10 0.33 100.09 0.01 586b2udq6dbng insert into wrh$_sysstat (snap... 0.32 504 0.00 1.05 0.33 96.90 0.00 4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TA...User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text | 0.07 479 0.00 76.60 9.22 99.59 0.78 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := ... 0.05 440 0.00 56.83 1.85 99.34 2.88 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_... 0.05 3 0.02 55.73 0.38 100.35 13.65 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) F... 0.01 1 0.01 14.46 0.02 18.06 81.45 848dyu9288c3h SELECT mgmt_metric_value_obj.... 0.00 479 0.00 1.53 0.44 97.43 0.33 7vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION... 0.00 1,086 0.00 1.38 0.25 97.18 0.51 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR... 0.00 528 0.00 1.12 0.20 94.92 0.51 aq8yqxyyb40nn update sys.job$ set this_date=... 0.00 3 0.00 1.04 0.51 97.25 0.19 bzscyq07w79ab delete /*+ dynamic_sampling(4)... 0.00 528 0.00 1.02 0.15 99.91 0.64 47a50dvdgnxc2 update sys.job$ set failures=0... 0.00 1,955 0.00 0.45 0.13 91.42 0.33 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SE...Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text | 243,493 479 508.34 26.10 9.22 99.6 .8 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := ... 155,691 3 51,897.00 16.69 0.51 97.2 .2 bzscyq07w79ab delete /*+ dynamic_sampling(4)... 118,693 1 118,693.00 12.72 0.39 100 0 acc988uzvjmmt delete from WRH$_SYSMETRIC_HIS... 94,754 27,505 3.44 10.16 1.08 100.9 0 cm5vu20fhtnq1 select /*+ connect_by_filterin... 85,127 440 193.47 9.12 1.85 99.3 2.9 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_... 36,041 3 12,013.67 3.86 0.38 100.4 13.7 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) F... 30,917 721 42.88 3.31 0.24 78.9 0 0k8522rmdzg4k select privilege# from sysauth... 19,449 1 19,449.00 2.08 0.07 100.3 .1 9v9n97qj8z1dg delete /*+ dynamic_sampling(4)... 14,907 8 1,863.38 1.60 0.41 99.8 .1 6ajkhukk78nsr begin prvt_hdm.auto_execute( :... 13,608 168 81.00 1.46 0.07 93.7 0 6xvp6nxs4a9n4 select nvl(sum(space),0) from... 13,608 168 81.00 1.46 0.04 106.7 0 csnp95dz2r8ss select file#,block# from recy... 12,044 1 12,044.00 1.29 0.05 101.1 0 0sfsrf0qzvsjv delete from WRH$_SYSMETRIC_SUM... 11,504 5,748 2.00 1.23 0.73 13.1 0 5ms6rbzdnq16t select job,... 10,452 1,086 9.62 1.12 0.25 97.2 .5 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR... 9,828 6 1,638.00 1.05 0.05 105 0 1n1bm7xa28vtq select file#,block#,type#,n... 9,633 1,955 4.93 1.03 0.13 91.4 .3 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SE... 9,583 479 20.01 1.03 0.44 97.4 .3 7vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text | 6,818 479 14.23 97.53 9.22 99.59 0.78 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := ... 6,807 440 15.47 97.37 1.85 99.34 2.88 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_... 6,807 3 2,269.00 97.37 0.38 100.35 13.65 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) F... 85 3 28.33 1.22 0.51 97.25 0.19 bzscyq07w79ab delete /*+ dynamic_sampling(4)... 10 8 1.25 0.14 0.01 111.55 1.34 dcvnnc6bjqshc SELECT TASK_ID,TASK_CLASS FRO... 4 1 4.00 0.06 0.08 99.97 0.11 c2p32r5mzv8hb BEGIN prvt_advisor.delete_expi... 3 1 3.00 0.04 0.07 100.33 0.07 9v9n97qj8z1dg delete /*+ dynamic_sampling(4)... 1 1 1.00 0.01 0.02 18.06 81.45 848dyu9288c3h SELECT mgmt_metric_value_obj.... 0 32 0.00 0.00 0.02 101.37 0.00 00prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID,TRUNC(COLL... 0 1 0.00 0.00 0.00 0.00 0.00 00zqy3yd0r3p3 lock table sys.mon_mods$ in ex...UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text | 6,938 6,938 479 14.48 0.00 99.24 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := ... 6,927 6,927 440 15.74 0.00 99.08 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_... 6,843 6,843 3 2,281.00 0.00 97.88 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) F... 224 224 800 0.28 0.00 3.20 49s332uhbnsma declare vsn varchar2(20); beg... 4 4 1 4.00 0.00 0.06 c2p32r5mzv8hb BEGIN prvt_advisor.delete_expi... 0 0 32 0.00 0.00 00prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID,TRUNC(COLL... 0 0 1 0.00 0.00 00zqy3yd0r3p3 lock table sys.mon_mods$ in ex... 0 0 2,961 0.00 0.00 089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME... 0 0 1,235 0.00 0.00 08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MG... 0 0 419 0.00 0.00 08vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text | 27,505 45,888 1.67 1.08 100.9 0 cm5vu20fhtnq1 select /*+ connect_by_filterin... 5,748 528 0.09 0.73 13.1 0 5ms6rbzdnq16t select job,... 2,961 2,961 1.00 0.07 99.2 0 089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME... 1,955 1,955 1.00 0.13 91.4 .3 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SE... 1,955 1,955 1.00 0.04 100.1 0 gfdn12rn0fg3m SELECT TARGET_GUID FROM MGMT_T... 1,713 1,713 1.00 0.19 104.1 0 5kyb5bvnu3s04 SELECT DISTINCT METRIC_GUID FR... 1,235 742 0.60 0.07 120.4 0 08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MG... 1,086 1,086 1.00 0.25 97.2 .5 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR... 1,056 918 0.87 0.07 97.4 0 g00cj285jmgsw update sys.mon_mods$ set inser... 958 29,698 31.00 1.99 98.5 0 772s25v1y0x8k select shared_pool_size_for_es... 958 19,160 20.00 2.62 105.7 0 aykvshm7zsabd select size_for_estimate,size... 958 13,412 14.00 0.52 68.7 0 fvkynu9xgck8h select PGA_TARGET_FOR_ESTIMATE...Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text | 27,505 27,505 46.76 cm5vu20fhtnq1 select /*+ connect_by_filterin... 1,219 1,235 2.07 08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MG... 1,061 2,961 1.80 089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME... 1,056 1,056 1.80 g00cj285jmgsw update sys.mon_mods$ set inser... 800 800 1.36 49s332uhbnsma declare vsn varchar2(20); beg... 721 721 1.23 0k8522rmdzg4k select privilege# from sysauth... 568 568 0.97 3s58mgk0uy2ws insert into wrm$_snapshot_deta... 528 528 0.90 47a50dvdgnxc2 update sys.job$ set failures=0... 528 528 0.90 aq8yqxyyb40nn update sys.job$ set this_date=... 528 528 0.90 cumjq42201t37 select u1.user#,u3....Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text | 59,422,648 5.76 9m82p8p2d7z84 ** SQL Text Not Available ** 26,327,344 2.55 46zqay3hb3n7d ** SQL Text Not Available ** 16,155,464 1.57 3mqvkt9as1phq ** SQL Text Not Available ** 14,220,615 1 1.38 1wdhux6669jk1 merge /*+ dynamic_sampling(mm... 11,031,918 440 1.07 fsbqktj5vw6n9 select next_run_date,obj#,ru... 8,117,367 16 0.79 69k5bhm12sz98 SELECT dbin.instance_number,d... 4,286,720 0.42 3ypcc0jwu2wxr ** SQL Text Not Available ** 4,196,791 1 0.41 2m7ax0c761q1q delete /*+ dynamic_sampling(m... 3,563,672 105 0.35 bn4b3vjw2mj3u SELECT OBJOID,CLSOID,DECODE(... 3,198,063 528 0.31 cumjq42201t37 select u1.user#,u3.... 2,546,619 32 0.25 00prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID,TRUNC(COLL... 2,174,097 17 0.21 g4gp07gt2z920 update sys.scheduler$_job set ... 1,943,961 48 0.19 cabqn4dp09qck SELECT TASK_CLASS,ROUND(NVL(S... 1,852,963 1 0.18 00zqy3yd0r3p3 lock table sys.mon_mods$ in ex... 1,784,599 690 0.17 9p5tvdmjymwx7 UPDATE MGMT_POLICY_ASSOC_EVAL_... 1,610,136 1,955 0.16 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SE... 1,472,893 8 0.14 dcvnnc6bjqshc SELECT TASK_ID,TASK_CLASS FRO... 1,441,454 48 0.14 ak5crjygnpk60 UPDATE DBMS_LOCK_ALLOCATED SET... 1,335,472 7 0.13 84ygtc6ucuafk DBMS_SCHEDULER update sys.scheduler$_job set ... 1,334,807 122 0.13 3x0kdm7z3yasw SELECT TARGET_TYPE,TYPE_META_... 1,271,631 8 0.12 11p815z8hkfms Oracle Enterprise Manager.purge system performan DELETE MGMT_SYSTEM_PERFORMANCE... 1,190,379 1,056 0.12 g00cj285jmgsw update sys.mon_mods$ set inser... 1,154,622 528 0.11 47a50dvdgnxc2 update sys.job$ set failures=0...Version Count | Executions | SQL Id | SQL Module | SQL Text | 271 46zqay3hb3n7d ** SQL Text Not Available ** 265 3ypcc0jwu2wxr ** SQL Text Not Available ** 249 3mqvkt9as1phq ** SQL Text Not Available ** 232 9m82p8p2d7z84 ** SQL Text Not Available ** 195 1 00zqy3yd0r3p3 lock table sys.mon_mods$ in ex... 190 440 fsbqktj5vw6n9 select next_run_date,ru... 165 1 2m7ax0c761q1q delete /*+ dynamic_sampling(m... 165 1 2m7ax0c761q1q delete /*+ dynamic_sampling(m... 165 7 84ygtc6ucuafk DBMS_SCHEDULER update sys.scheduler$_job set ... 164 1 1wdhux6669jk1 merge /*+ dynamic_sampling(mm... 164 1 1wdhux6669jk1 merge /*+ dynamic_sampling(mm... 163 122 3x0kdm7z3yasw SELECT TARGET_TYPE,TYPE_META_... 163 16 69k5bhm12sz98 SELECT dbin.instance_number,d... 159 48 ak5crjygnpk60 UPDATE DBMS_LOCK_ALLOCATED SET... 154 678 3c1kubcdjnppq update sys.col_usage$ set equa... 122 8 dcvnnc6bjqshc SELECT TASK_ID,TASK_CLASS FRO... 117 690 9p5tvdmjymwx7 UPDATE MGMT_POLICY_ASSOC_EVAL_... 112 32 00prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID,TRUNC(COLL... 111 48 cabqn4dp09qck SELECT TASK_CLASS,ROUND(NVL(S... 108 105 bn4b3vjw2mj3u SELECT OBJOID,DECODE(... 108 105 bn4b3vjw2mj3u SELECT OBJOID,DECODE(... 104 48 1t0vfvhmyjq5c SELECT NVL(AVG(VALUE),0) FRO... 102 5,748 5ms6rbzdnq16t select job,... 102 528 aq8yqxyyb40nn update sys.job$ set this_date=... 99 528 47a50dvdgnxc2 update sys.job$ set failures=0... 96 1,955 gfdn12rn0fg3m SELECT TARGET_GUID FROM MGMT_T... 88 528 cumjq42201t37 select u1.user#,u3.... 82 1,086 18naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR... 78 1,955 8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SE... 77 128 5rygsj4dbw6jt insert into sys.mon_mods$ (obj... 73 17 g4gp07gt2z920 update sys.scheduler$_job set ... 70 1,056 g00cj285jmgsw update sys.mon_mods$ set inser... 63 8 11p815z8hkfms Oracle Enterprise Manager.purge system performan DELETE MGMT_SYSTEM_PERFORMANCE...SQL Id | SQL Text | 00prz3j9n4gyj SELECT METRIC_GUID,TRUNC(COLLECTION_TIMESTAMP,'HH24'),KEY_VALUE,COUNT(TARGET_GUID),AVG(VALUE),MIN(VALUE),MAX(VALUE),STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID,METRIC_GUID,'HH24') 00zqy3yd0r3p3 lock table sys.mon_mods$ in exclusive mode 089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL 08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 08vznc16ycuag SELECT SYS_GUID() FROM SYS.DUAL 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 0sfsrf0qzvsjv delete from WRH$_SYSMETRIC_SUMMARY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id)) 11p815z8hkfms DELETE MGMT_SYSTEM_PERFORMANCE_LOG WHERE TIME < :B2 AND ROWNUM <= :B1 18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME,TIME,DURATION,MODULE,ACTION,IS_TOTAL,NAME,VALUE,CLIENT_DATA,HOST_URL) VALUES (:B9,SYSDATE,:B8,SUBSTR(:B7,512),SUBSTR(:B6,32),:B5,SUBSTR(:B4,128),SUBSTR(:B3,SUBSTR(:B2,SUBSTR(:B1,256)) 1n1bm7xa28vtq select file#,nvl(spare1,0),hwmincr,cachehint,nvl(scanhint,0) from seg$ where ts# = :1 1t0vfvhmyjq5c SELECT NVL(AVG(VALUE),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME='Notification Delivery' AND NAME='Delivery Time' AND TIME>(SYSDATE-(1/24)) 1wdhux6669jk1 merge /*+ dynamic_sampling(mm 4) dynamic_sampling_est_cdn(mm) dynamic_sampling(m 4) dynamic_sampling_est_cdn(m) */ into mon_mods_all$ mm using (select decode(grouping_id(tp.bo#,m.obj#),tp.bo#,m.obj#) obj#,sum(m.inserts) inserts,sum(m.updates) updates,sum(m.deletes) deletes,case when grouping_id(tp.bo#,m.obj#) = 0 then (/* IF THIS IS A PARTITION AGGREGATE THE TRUNCATE BIT */ decode(sum(bitand(m.flags,1)),1) +decode(sum(bitand(m.flags,2)),2) +decode(sum(bitand(m.flags,4)),4) /* ADD NEW KSXM BITS HERE */ ) else (/* IF THIS IS A TABLE DO NOT AGGREAGATE THE TRUNCATE BIT */ decode(sum(bitand(m.flags,4) /* ADD NEW KSXM BITS HERE */ ) end as flags,max(m.timestamp) timestamp,sum(m.drop_segments) drop_segments from sys.mon_mods$ m,(select obj#,bo# from sys.tabpart$ union all select obj#,bo# from sys.tabcompart$) tp where m.obj# = tp.obj# group by rollup(tp.bo#,m.obj#) having grouping_id(tp.bo#,m.obj#) < 3 ) v on (mm.obj# = v.obj#) when matched then update set mm.inserts = mm.inserts + v.inserts,mm.updates = mm.updates + v.updates,mm.deletes = mm.deletes + v.deletes,mm.flags = mm.flags + v.flags - bitand(mm.flags,v.flags) /* bitor(mm.flags,v.flags) */,mm.timestamp = v.timestamp,mm.drop_segments = mm.drop_segments + v.drop_segments when NOT matched then insert (obj#,inserts,updates,deletes,timestamp,flags,drop_segments) values (v.obj#,v.inserts,v.updates,v.deletes,sysdate,v.flags,v.drop_segments) 2m7ax0c761q1q delete /*+ dynamic_sampling(m 4) dynamic_sampling_est_cdn(m) */ from sys.mon_mods$ m where exists (select /*+ unnest */ * from sys.tabcompart$ t where t.obj# = m.obj#) 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_values) 3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),equijoin_preds = equijoin_preds + decode(bitand(:flag,2),nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),range_preds = range_preds + decode(bitand(:flag,8),like_preds = like_preds + decode(bitand(:flag,16),null_preds = null_preds + decode(bitand(:flag,timestamp = :time where obj# = :objn and intcol# = :coln 3mqvkt9as1phq ** SQL Text Not Available ** 3s58mgk0uy2ws insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin_time,end_time) values (:snap_id,:dbid,:instance_number,:bind1,:bind2,:bind3) 3x0kdm7z3yasw SELECT TARGET_TYPE,TYPE_META_VER,NVL(CATEGORY_PROP_1,' '),NVL(CATEGORY_PROP_2,NVL(CATEGORY_PROP_3,NVL(CATEGORY_PROP_4,NVL(CATEGORY_PROP_5,' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 3ypcc0jwu2wxr ** SQL Text Not Available ** 46zqay3hb3n7d ** SQL Text Not Available ** 47a50dvdgnxc2 update sys.job$ set failures=0,this_date=null,flag=:1,last_date=:2,next_date = greatest(:3,sysdate),total=total+(sysdate-nvl(this_date,sysdate)) where job=:4 49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn,2) || substr(vsn,4,7,2) || nvl(substr(vsn,10,'00')); end if; end; 4dy1xm4nxc0gf insert into wrh$_system_event (snap_id,event_id,total_waits,total_timeouts,time_waited_micro,total_waits_fg,total_timeouts_fg,time_waited_micro_fg) select :snap_id,time_waited_micro_fg from v$system_event order by event_id 4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID,LEAD(TASK_TGT.TARGET_GUID,1) OVER (ORDER BY TASK_TGT.TARGET_GUID,POLICY.POLICY_GUID,CFG.EVAL_ORDER) NEXT_TARGET_GUID,POLICY.POLICY_GUID POLICY_GUID,LEAD(POLICY.POLICY_GUID,CFG.EVAL_ORDER) NEXT_POLICY_GUID,POLICY.POLICY_NAME,POLICY.POLICY_TYPE,DECODE(POLICY.POLICY_TYPE,:B3,NVL(CFG.MESSAGE,POLICY.MESSAGE),:B9,CFG.MESSAGE,NULL) MESSAGE,NVL(CFG.MESSAGE_NLSID,POLICY.MESSAGE_NLSID),CFG.MESSAGE_NLSID,NULL) MESSAGE_NLSID,NVL(CFG.CLEAR_MESSAGE,POLICY.CLEAR_MESSAGE),CFG.CLEAR_MESSAGE,NULL) CLEAR_MESSAGE,NVL(CFG.CLEAR_MESSAGE_NLSID,POLICY.CLEAR_MESSAGE_NLSID),CFG.CLEAR_MESSAGE_NLSID,NULL) CLEAR_MESSAGE_NLSID,POLICY.REPO_TIMING_ENABLED,TASK_TGT.COLL_NAME,POLICY.VIOLATION_LEVEL,:B10,0) VIOLATION_TYPE,POLICY.CONDITION_TYPE,POLICY.CONDITION,NVL(CFG.CONDITION_OPERATOR,POLICY.CONDITION_OPERATOR),CFG.CONDITION_OPERATOR,0) CONDITION_OPERATOR,CFG.KEY_VALUE,CFG.KEY_OPERATOR,CFG.IS_EXCEPTION,CFG.NUM_OCCURRENCES,NULL EVALUATION_DATE,DECODE(CFG.IS_EXCEPTION,:B1,MGMT_POLICY_PARAM_VAL_ARRAY(),CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME,CRIT_THRESHOLD,WARN_THRESHOLD,INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS,DECODE(POLICY.CONDITION_TYPE,CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME,BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY),MGMT_NAMEVALUE_ARRAY()) BINDS,DECODE(:B7,MGMT_MEDIUM_STRING_ARRAY(),MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE),CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE,KEY_PART2_VALUE,KEY_PART3_VALUE,KEY_PART4_VALUE,KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY,MGMT_POLICY_ASSOC ASSOC,MGMT_POLICY_ASSOC_CFG CFG,MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID,CFG.EVAL_ORDER,CFG.KEY_VALUE DESC 586b2udq6dbng insert into wrh$_sysstat (snap_id,stat_id,value) select :snap_id,value from v$sysstat order by stat_id 5kyb5bvnu3s04 SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1 5ms6rbzdnq16t select job,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 5rygsj4dbw6jt insert into sys.mon_mods$ (obj#,drop_segments) values (:1,:2,:3,:4,:5,:6,:7) 66gs90fyynks7 insert into wrh$_instance_recovery (snap_id,recovery_estimated_ios,actual_redo_blks,target_redo_blks,log_file_size_redo_blks,log_chkpt_timeout_redo_blks,log_chkpt_interval_redo_blks,fast_start_io_target_redo_blks,target_mttr,estimated_mttr,ckpt_block_writes,optimal_logfile_size,estd_cluster_available_time,writes_mttr,writes_logfile_size,writes_log_checkpoint_settings,writes_other_settings,writes_autotune,writes_full_thread_ckpt) select :snap_id,writes_full_thread_ckpt from v$instance_recovery 69k5bhm12sz98 SELECT dbin.instance_number,dbin.db_name,dbin.instance_name,dbin.host_name,dbin.version,CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce,CAST(s1.end_interval_time AS DATE) as begin_time,CAST(s2.end_interval_time AS DATE) as end_time,ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs,CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect,round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed),(extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed),0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1,WRM$_DATABASE_INSTANCE dbin,WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst 6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid,:inst_num,:end_snap_id ); end; 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 6mvfay19q3v4n SELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO 6xvp6nxs4a9n4 select nvl(sum(space),0) from recyclebin$ where ts# = :1 772s25v1y0x8k select shared_pool_size_for_estimate s,shared_pool_size_factor * 100 f,estd_lc_load_time l,0 from v$shared_pool_advice 7g732rx16j8jc insert into WRH$_SERVICE_STAT (snap_id,service_name_hash,stat.service_name_hash,stat.stat_id,stat.value from v$active_services asvc,v$service_stats stat where asvc.name_hash = stat.service_name_hash 7vcwzqf7mgk3b INSERT INTO MGMT_JOB_EXECUTION (JOB_ID,EXECUTION_ID,STEP_ID,SOURCE_STEP_ID,ORIGINAL_STEP_ID,RESTART_MODE,STEP_NAME,STEP_TYPE,COMMAND_TYPE,ITERATE_PARAM,ITERATE_PARAM_INDEX,PARENT_STEP_ID,STEP_STATUS,START_TIME,TIMEZONE_REGION) VALUES (NULL,NULL,:B4,:B2,MGMT_JOB_ENGINE.SYSDATE_UTC(),'UTC') 848dyu9288c3h SELECT mgmt_metric_value_obj.new(target_guid,null,mgmt_namevalue_array(mgmt_namevalue_obj.new('GROUP_TARGET_GUID',GROUP_TARGET_GUID),mgmt_namevalue_obj.new('MEMBER_TARGET_TYPE',MEMBER_TARGET_TYPE),mgmt_namevalue_obj.new('CATEGORY',CATEGORY),mgmt_namevalue_obj.new('BUCKET1',BUCKET1),mgmt_namevalue_obj.new('BUCKET2',BUCKET2),mgmt_namevalue_obj.new('BUCKET3',BUCKET3),mgmt_namevalue_obj.new('BUCKET4',BUCKET4),mgmt_namevalue_obj.new('BUCKET5',BUCKET5))) from ( with buckets as ( select avgs.target_guid,avgs.target_type,avgs.target_name,NVL(avgs.category_name,'ALL') as category,case when(width_bucket(avgs.compliance_score,101,5)=1) then 1 else 0 end as b1,5)=2) then 1 else 0 end as b2,5)=3) then 1 else 0 end as b3,5)=4) then 1 else 0 end as b4,5)=5) then 1 else 0 end as b5 from ( SELECT t.target_guid,t.target_type,t.target_name,c.category_name,round(AVG(a.compliance_score)) as compliance_score from sysman.mgmt_targets t,sysman.mgmt_category_map c,sysman.mgmt_policy_assoc_eval_summ a,sysman.mgmt_policies p where t.target_guid = a.target_guid and a.policy_guid = c.object_guid and p.policy_guid = a.policy_guid and p.policy_type = 2 and c.class_name = 'Functional' group by t.target_name,t.target_guid,rollup(c.category_name) ) avgs ) SELECT q.group_target_guid,rt.target_guid,NVL(q.member_target_type,'ALL') as member_target_type,q.category as category,sum(q.bucket1) as bucket1,sum(q.bucket2) as bucket2,sum(q.bucket3) as bucket3,sum(q.bucket4) as bucket4,sum(q.bucket5) as bucket5 FROM ( ( SELECT a.source_target_guid as group_target_guid,x.target_type as member_target_type,x.category as category,x.b1 as bucket1,x.b2 as bucket2,x.b3 as bucket3,x.b4 as bucket4,x.b5 as bucket5 FROM sysman.mgmt_flat_target_assoc a,buckets x WHERE a.is_membership = 1 and (a.assoc_target_guid = x.target_guid) ) UNION ALL ( SELECT x.target_guid as group_target_guid,x.b5 as bucket5 FROM buckets x,mgmt_type_properties p WHERE x.target_type = p.target_type and p.property_name = 'is_aggregate' and p.property_value = '1' ) ) q,sysman.mgmt_targets rt WHERE rt.target_type = 'oracle_emrep' GROUP BY q.group_target_guid,rollup(q.member_target_type),q.category) WHERE target_guid IN (SELECT target_guid FROM MGMT_COLLECTION_METRIC_TASKS WHERE TASK_ID = :task_id) order by target_guid 84k66tf2s7y1c insert into wrh$_bg_event_summary (snap_id,time_waited_micro) select :snap_id,total_waits - total_waits_fg,total_timeouts - total_timeouts_fg,time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id 84ygtc6ucuafk update sys.scheduler$_job set job_status = :1 where obj# = :2 8vwv6hx92ymmm UPDATE 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 9m82p8p2d7z84 ** SQL Text Not Available ** 9p5tvdmjymwx7 UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12,SYSDATE),ROWS_EVALUATED = NVL(:B11,TOTAL_VIOLATIONS_LOGGED = NVL(:B10,TOTAL_VIOLATIONS_LOGGED),NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9,:B8 ),MAX_VIOLATION_LEVEL = NVL(:B7,:B6 ),COMPLIANCE_SCORE = NVL(:B5,:B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1 9v9n97qj8z1dg delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2,rownum) acc988uzvjmmt delete from WRH$_SYSMETRIC_HISTORY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id)) ak5crjygnpk60 UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION = SYSDATE + (:B1 /86400) WHERE ROWID = :B2 aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2 aykvshm7zsabd select size_for_estimate,size_factor * 100 f,estd_physical_read_time,estd_physical_reads from v$db_cache_advice where id = '3' bm2pwrpcr8ru6 select sga_size s,sga_size_factor * 100 f,estd_db_time t,estd_physical_reads p from v$sga_target_advice order by sga_size bn4b3vjw2mj3u SELECT OBJOID,DECODE(BITAND(FLAGS,16384),RUNTIME,LETIME),(2*PRI + DECODE(BITAND(STATUS,decode(INST,:1,-1,1))),JOBTYPE,SCHLIM,WT,INST,RUNNOW,ENQ_SCHLIM,INST_ID FROM ( select a.obj# OBJOID,a.class_oid CLSOID,a.next_run_date RUNTIME,a.last_enabled_time LETIME,a.flags FLAGS,a.job_status STATUS,1 JOBTYPE,a.priority PRI,decode(a.schedule_limit,decode(bitand(a.flags,4194304),4194304,b.schedule_limit,NULL),a.schedule_limit) SCHLIM,a.job_weight WT,decode(a.running_instance,a.running_instance) INST,1) RUNNOW,decode(bitand(a.job_status,8388608),1) ENQ_SCHLIM,a.instance_id INST_ID from sys.scheduler$_job a,sys.scheduler$_program b,v$database v,v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags,17179869184) <> 0 ) union all select c.obj#,c.class_oid,c.next_run_date,c.last_enabled_time,c.flags,c.job_status,decode(bitand(c.flags,8589934592),d.priority,pj.priority),d.schedule_limit,decode(pj.schedule_limit,pj.schedule_limit)),d.job_weight,pj.job_weight),decode(c.running_instance,c.running_instance),decode(bitand(c.job_status,c.instance_id INST_ID from sys.scheduler$_lightweight_job c,sys.scheduler$_program d,(select sl.obj# obj#,decode(bitand(sl.flags,sl.program_oid,spj.program_oid) program_oid,spj.priority) priority,spj.job_weight) job_weight,spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl,scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj,v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags,17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS,515) = 1 AND BITAND(FLAGS,1048576) = 0 AND ((BITAND(FLAGS,134217728 + 268435456) = 0) OR (BITAND(STATUS,1024) <> 0)) AND BITAND(FLAGS,4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS,16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags,:5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3,2,7 DESC,1 bunssq950snhf insert into wrh$_sga_target_advice (snap_id,SGA_SIZE,SGA_SIZE_FACTOR,ESTD_DB_TIME,ESTD_PHYSICAL_READS) select :snap_id,ESTD_PHYSICAL_READS from v$sga_target_advice bzscyq07w79ab delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and rownum <= NVL(:2,rownum) c2p32r5mzv8hb BEGIN prvt_advisor.delete_expired_tasks; END; cabqn4dp09qck SELECT TASK_CLASS,ROUND(NVL(SUM(THROUGHPUT),NVL(SUM(TOTAL_VALUE),NVL(SUM(TOTAL_DURATION),0) FROM (SELECT CLIENT_DATA WORKER_ID,ACTION TASK_CLASS,NVL(AVG(VALUE*1000/ DECODE(DURATION,1000,DURATION)),0) THROUGHPUT,SUM(VALUE) TOTAL_VALUE,SUM(DURATION)/1000 TOTAL_DURATION,COUNT(*) RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA,ACTION ) GROUP BY TASK_CLASS cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 csnp95dz2r8ss select file#,block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 cumjq42201t37 select u1.user#,u3.user#,failures,flag,interval#,what,nlsenv,env,field1,next_date from sys.job$ j,sys.user$ u1,sys.user$ u2,sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name dayq182sk41ks insert into wrh$_memory_target_advice (snap_id,memory_size,memory_size_factor,estd_db_time,estd_db_time_factor,version) select :snap_id,version from v$memory_target_advice dcvnnc6bjqshc SELECT TASK_ID,TASK_CLASS FROM MGMT_COLLECTION_TASKS C WHERE FREQUENCY_CODE != 7 AND NOT EXISTS (SELECT 1 FROM MGMT_TASK_QTABLE Q WHERE Q.USER_DATA.TASK_ID = C.TASK_ID) FOR UPDATE dqbhc9r7gz0a5 SELECT DECODE(COUNT(CLIENT_INFO),'down','up') FROM GV$SESSION WHERE CLIENT_INFO = :B1 fsbqktj5vw6n9 select next_run_date,run_job,sch_job from (select decode(bitand(a.flags,a.next_run_date,a.last_enabled_time) next_run_date,a.obj# obj#,1) run_job,a.sch_job sch_job from (select p.obj# obj#,p.flags flags,p.next_run_date next_run_date,p.job_status job_status,p.class_oid class_oid,p.last_enabled_time last_enabled_time,p.instance_id instance_id,1 sch_job from sys.scheduler$_job p where bitand(p.job_status,3) = 1 and ((bitand(p.flags,134217728 + 268435456) = 0) or (bitand(p.job_status,1024) <> 0)) and bitand(p.flags,4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#,q.flags,q.next_run_date,q.job_status,q.class_oid,q.last_enabled_time,q.instance_id,1 from sys.scheduler$_lightweight_job q where bitand(q.job_status,3) = 1 and ((bitand(q.flags,134217728 + 268435456) = 0) or (bitand(q.job_status,1024) <> 0)) and bitand(q.flags,4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job,from_tz(cast(j.next_date as timestamp),to_char(systimestamp,'TZH:TZM')),0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1 fvkynu9xgck8h select PGA_TARGET_FOR_ESTIMATE s,PGA_TARGET_FACTOR * 100 f,ESTD_TIME t,BYTES_PROCESSED b from v$pga_target_advice order by PGA_TARGET_FOR_ESTIMATE g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins,updates = updates + :upd,deletes = deletes + :del,flags = (decode(bitand(flags,:flag),:flag,flags + :flag)),drop_segments = drop_segments + :dropseg,timestamp = :time where obj# = :objn g4gp07gt2z920 update sys.scheduler$_job set last_start_date = :1,running_instance = :2,running_slave = :3,job_status = :4 where obj# = :5 gfdn12rn0fg3m SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :B1 gjm43un5cy843 SELECT SUM(USED),SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED,SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME,SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ 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)Statistic | Total | per Second | per Trans | db block changes 471,768 16.41 158.90 execute count 94,258 3.28 31.75 logons cumulative 1,856 0.06 0.63 opened cursors cumulative 85,640 2.98 28.84 parse count (total) 58,827 2.05 19.81 parse time elapsed 183 0.01 0.06 physical reads 6,991 0.24 2.35 physical writes 15,561 0.54 5.24 redo size 71,245,476 2,477.48 23,996.46 session cursor cache hits 62,944 2.19 21.20 session logical reads 932,997 32.44 314.25 user calls 5,952 0.21 2.00 user commits 2,969 0.10 1.00 user rollbacks 0 0.00 0.00 workarea executions - onepass 0 0.00 0.00 workarea executions - optimal 28,574 0.99 9.62Statistic | Total | per Second | per Trans | Batched IO (bound) vector count 0 0.00 0.00 Batched IO (full) vector count 0 0.00 0.00 Batched IO block miss count 0 0.00 0.00 Batched IO buffer defrag count 0 0.00 0.00 Batched IO double miss count 0 0.00 0.00 Batched IO same unit count 0 0.00 0.00 Batched IO single block count 0 0.00 0.00 Batched IO slow jump count 0 0.00 0.00 Batched IO vector block count 0 0.00 0.00 Batched IO vector read count 0 0.00 0.00 Block Cleanout Optim referenced 66 0.00 0.02 CCursor + sql area evicted 2 0.00 0.00 CPU used by this session 10,107 0.35 3.40 CPU used when call started 1,302 0.05 0.44 CR blocks created 226 0.01 0.08 Cached Commit SCN referenced 0 0.00 0.00 Commit SCN cached 1 0.00 0.00 DBWR checkpoint buffers written 15,418 0.54 5.19 DBWR checkpoints 43 0.00 0.01 DBWR object drop buffers written 0 0.00 0.00 DBWR revisited being-written buffer 0 0.00 0.00 DBWR tablespace checkpoint buffers written 0 0.00 0.00 DBWR thread checkpoint buffers written 0 0.00 0.00 DBWR transaction table writes 820 0.03 0.28 DBWR undo block writes 5,310 0.18 1.79 HSC Heap Segment Block Changes 94,573 3.29 31.85 Heap Segment Array Inserts 894 0.03 0.30 Heap Segment Array Updates 904 0.03 0.30 IMU CR rollbacks 0 0.00 0.00 IMU Flushes 1,078 0.04 0.36 IMU Redo allocation size 2,672,564 92.94 900.16 IMU commits 2,757 0.10 0.93 IMU contention 0 0.00 0.00 IMU ktichg flush 1 0.00 0.00 IMU pool not allocated 27 0.00 0.01 IMU recursive-transaction flush 1 0.00 0.00 IMU undo allocation size 16,468,856 572.68 5,546.94 IMU- failed to get a private strand 27 0.00 0.01 LOB table id lookup cache misses 0 0.00 0.00 Misses for writing mapping 0 0.00 0.00 Number of read IOs issued 0 0.00 0.00 PX local messages recv'd 0 0.00 0.00 PX local messages sent 0 0.00 0.00 Requests to/from client 384 0.01 0.13 RowCR attempts 1,648 0.06 0.56 RowCR hits 1,648 0.06 0.56 SMON posted for undo segment shrink 0 0.00 0.00 SQL*Net roundtrips to/from client 384 0.01 0.13 TBS Extension: bytes extended 0 0.00 0.00 TBS Extension: files extended 0 0.00 0.00 TBS Extension: tasks created 0 0.00 0.00 TBS Extension: tasks executed 0 0.00 0.00 active txn count during cleanout 650 0.02 0.22 auto extends on undo tablespace 0 0.00 0.00 background checkpoints completed 2 0.00 0.00 background checkpoints started 2 0.00 0.00 background timeouts 139,761 4.86 47.07 branch node splits 0 0.00 0.00 buffer is not pinned count 233,381 8.12 78.61 buffer is pinned count 224,771 7.82 75.71 bytes received via SQL*Net from client 112,608 3.92 37.93 bytes sent via SQL*Net to client 238,560 8.30 80.35 calls to get snapshot scn: kcmgss 107,520 3.74 36.21 calls to kcmgas 8,381 0.29 2.82 calls to kcmgcs 20,290 0.71 6.83 cell physical IO interconnect bytes 1,511,389,184 52,556.75 509,056.65 change write time 101 0.00 0.03 cleanout - number of ktugct calls 682 0.02 0.23 cleanouts and rollbacks - consistent read gets 3 0.00 0.00 cleanouts only - consistent read gets 18 0.00 0.01 cluster key scan block gets 19,805 0.69 6.67 cluster key scans 17,394 0.60 5.86 commit batch/immediate performed 480 0.02 0.16 commit batch/immediate requested 480 0.02 0.16 commit cleanout failures: block lost 0 0.00 0.00 commit cleanout failures: buffer being written 0 0.00 0.00 commit cleanout failures: callback failure 46 0.00 0.02 commit cleanout failures: cannot pin 4 0.00 0.00 commit cleanouts 22,369 0.78 7.53 commit cleanouts successfully completed 22,319 0.78 7.52 commit immediate performed 480 0.02 0.16 commit immediate requested 480 0.02 0.16 commit txn count during cleanout 252 0.01 0.08 consistent changes 668 0.02 0.22 consistent gets 466,126 16.21 157.00 consistent gets - examination 159,749 5.56 53.81 consistent gets direct 0 0.00 0.00 consistent gets from cache 466,126 16.21 157.00 consistent gets from cache (fastpath) 283,087 9.84 95.35 cursor authentications 194 0.01 0.07 data blocks consistent reads - undo records applied 524 0.02 0.18 db block gets 466,871 16.23 157.25 db block gets direct 1 0.00 0.00 db block gets from cache 466,870 16.23 157.25 db block gets from cache (fastpath) 128,935 4.48 43.43 deferred (CURRENT) block cleanout applications 10,790 0.38 3.63 dirty buffers inspected 27 0.00 0.01 enqueue conversions 6,405 0.22 2.16 enqueue releases 265,532 9.23 89.43 enqueue requests 265,532 9.23 89.43 enqueue timeouts 0 0.00 0.00 enqueue waits 82 0.00 0.03 exchange deadlocks 0 0.00 0.00 failed probes on index block reclamation 0 0.00 0.00 file io service time 0 0.00 0.00 frame signature mismatch 0 0.00 0.00 free buffer inspected 8,786 0.31 2.96 free buffer requested 13,225 0.46 4.45 global undo segment hints helped 0 0.00 0.00 global undo segment hints were stale 0 0.00 0.00 heap block compress 294 0.01 0.10 hot buffers moved to head of LRU 14,388 0.50 4.85 immediate (CR) block cleanout applications 21 0.00 0.01 immediate (CURRENT) block cleanout applications 7,824 0.27 2.64 index crx upgrade (positioned) 2 0.00 0.00 index crx upgrade (prefetch) 0 0.00 0.00 index fast full scans (full) 139 0.00 0.05 index fetch by key 87,694 3.05 29.54 index scans kdiixs1 103,040 3.58 34.71 leaf node 90-10 splits 159 0.01 0.05 leaf node splits 226 0.01 0.08 lob reads 0 0.00 0.00 lob writes 48 0.00 0.02 lob writes unaligned 48 0.00 0.02 logical read bytes from cache 7,643,103,232 265,779.78 2,574,302.20 max cf enq hold time 0 0.00 0.00 messages received 14,711 0.51 4.95 messages sent 14,711 0.51 4.95 min active SCN optimization applied on CR 0 0.00 0.00 no buffer to keep pinned count 16 0.00 0.01 no work - consistent read gets 264,506 9.20 89.09 non-idle wait count 92,750 3.23 31.24 parse count (describe) 3 0.00 0.00 parse count (failures) 1 0.00 0.00 parse count (hard) 382 0.01 0.13 parse time cpu 155 0.01 0.05 physical read IO requests 6,991 0.24 2.35 physical read bytes 57,270,272 1,991.51 19,289.41 physical read total IO requests 62,835 2.19 21.16 physical read total bytes 971,581,440 33,785.58 327,241.98 physical read total multi block requests 0 0.00 0.00 physical reads cache 6,991 0.24 2.35 physical reads cache prefetch 0 0.00 0.00 physical reads direct 0 0.00 0.00 physical reads direct (lob) 0 0.00 0.00 physical reads direct temporary tablespace 0 0.00 0.00 physical reads prefetch warmup 0 0.00 0.00 physical write IO requests 8,120 0.28 2.73 physical write bytes 127,475,712 4,432.82 42,935.57 physical write total IO requests 34,471 1.20 11.61 physical write total bytes 539,807,744 18,771.17 181,814.67 physical write total multi block requests 322 0.01 0.11 physical writes direct 1 0.00 0.00 physical writes direct (lob) 0 0.00 0.00 physical writes direct temporary tablespace 1 0.00 0.00 physical writes from cache 15,560 0.54 5.24 physical writes non checkpoint 3,804 0.13 1.28 pinned buffers inspected 3 0.00 0.00 pinned cursors current 0 0.00 0.00 prefetch clients - default 0 0.00 0.00 prefetch warmup blocks aged out before use 0 0.00 0.00 prefetched blocks aged out before use 474 0.02 0.16 process last non-idle time 28,802 1.00 9.70 recovery blocks read 0 0.00 0.00 recursive calls 645,679 22.45 217.47 recursive cpu usage 2,311 0.08 0.78 redo KB read 0 0.00 0.00 redo blocks checksummed by FG (exclusive) 27,795 0.97 9.36 redo blocks read for recovery 0 0.00 0.00 redo blocks written 146,996 5.11 49.51 redo buffer allocation retries 2 0.00 0.00 redo entries 226,150 7.86 76.17 redo k-bytes read for recovery 0 0.00 0.00 redo log space requests 2 0.00 0.00 redo ordering marks 149 0.01 0.05 redo size for direct writes 0 0.00 0.00 redo subscn max counts 3,598 0.13 1.21 redo synch long waits 209 0.01 0.07 redo synch time 20 0.00 0.01 redo synch time (usec) 535,164 18.61 180.25 redo synch time overhead (usec) 16,308,256,297 567,100.12 5,492,844.83 redo synch time overhead count (<128 msec) 0 0.00 0.00 redo synch time overhead count (<2 msec) 947 0.03 0.32 redo synch time overhead count (<32 msec) 0 0.00 0.00 redo synch time overhead count (<8 msec) 1 0.00 0.00 redo synch time overhead count (>=128 msec) 17 0.00 0.01 redo synch writes 965 0.03 0.33 redo wastage 1,605,696 55.84 540.82 redo write info find 965 0.03 0.33 redo write info find fail 0 0.00 0.00 redo write time 350 0.01 0.12 redo writes 5,725 0.20 1.93 rollback changes - undo records applied 481 0.02 0.16 rollbacks only - consistent read gets 222 0.01 0.07 root node splits 0 0.00 0.00 rows fetched via callback 28,336 0.99 9.54 session connect time 0 0.00 0.00 shared hash latch upgrades - no wait 13,115 0.46 4.42 shared hash latch upgrades - wait 0 0.00 0.00 sorts (memory) 81,726 2.84 27.53 sorts (rows) 215,544 7.50 72.60 sql area evicted 198 0.01 0.07 sql area purged 21 0.00 0.01 summed dirty queue length 27 0.00 0.01 switch current to new buffer 2,523 0.09 0.85 table fetch by rowid 131,687 4.58 44.35 table fetch continued row 31 0.00 0.01 table scan blocks gotten 101,091 3.52 34.05 table scan rows gotten 6,834,665 237.67 2,302.01 table scans (direct read) 0 0.00 0.00 table scans (long tables) 20 0.00 0.01 table scans (short tables) 10,692 0.37 3.60 temp space allocated (bytes) 0 0.00 0.00 total cf enq hold time 540 0.02 0.18 total number of cf enq holders 301 0.01 0.10 total number of times SMON posted 35 0.00 0.01 transaction rollbacks 480 0.02 0.16 transaction tables consistent read rollbacks 0 0.00 0.00 transaction tables consistent reads - undo records applied 0 0.00 0.00 undo change vector size 32,132,240 1,117.36 10,822.58 user logons cumulative 192 0.01 0.06 user logouts cumulative 192 0.01 0.06 write clones created in background 0 0.00 0.00 write clones created in foreground 0 0.00 0.00Statistic | Begin Value | End Value | logons current 109 108 opened cursors current 570 570 session cursor cache count 14,903,004 14,933,307 session pga memory 622,159,791,536 623,105,584 session pga memory max 715,564,633,488 716,942,482,064 session uga memory 474,829,328 475,020,992,976 session uga memory max 729,434,439,600 730,888,494,792 workarea memory allocated 2,140 2,140Statistic | Total | per Hour | log switches (derived) 2 0.25Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) | Others 871M 1.94 .03M 322M 0.71 .011M 76.4K 0.30 DBWR 0M 0.00 0M 121M 0.28 .004M 8100 0.10 LGWR 1M 0.00 0M 72M 0.20 .003M 11.5K 0.15 Buffer Cache Reads 55M 0.24 .002M 0M 0.00 0M 6991 0.00 Direct Writes 0M 0.00 0M 0M 0.00 0M 1 0.00 TOTAL: 927M 2.19 .032M 515M 1.20 .018M 103K 0.25Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read | Control File 872M 1.94 .03M 321M 0.72 .011M 0.00 Data File 55M 0.25 .002M 120M 0.28 .004M 0.00 Log File 0M 0.00 0M 72M 0.20 .003M 0.00 Temp File 0M 0.00 0M 0M 0.00 0M 0.00 TOTAL: 927M 2.19 .032M 513M 1.20 .018M 0.00Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) | Others 871M 1.94 .03M 322M 0.71 .011M 55.8K 0.00 Others (Control File) 871M 1.94 .03M 321M 0.71 .011M 55.7K 0.00 Others (Data File) 0M 0.00 0M 1M 0.00 0M 84 0.00 DBWR 0M 0.00 0M 121M 0.28 .004M 0 DBWR (Data File) 0M 0.00 0M 121M 0.28 .004M 0 LGWR 1M 0.00 0M 72M 0.20 .003M 38 0.00 LGWR (Log File) 0M 0.00 0M 72M 0.20 .003M 8 0.00 LGWR (Control File) 1M 0.00 0M 0M 0.00 0M 30 0.00 Buffer Cache Reads 55M 0.24 .002M 0M 0.00 0M 6991 0.00 Buffer Cache Reads (Data File) 55M 0.24 .002M 0M 0.00 0M 6991 0.00 Direct Writes 0M 0.00 0M 0M 0.00 0M 0 Direct Writes (Data File) 0M 0.00 0M 0M 0.00 0M 0 TOTAL: 927M 2.19 .032M 515M 1.20 .018M 62.9K 0.00Tablespace | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | Writes | Writes avg/s | Av Writes(ms) | Buffer Waits | Av Buf Wt(ms) | SYSAUX 4,067 0 0.01 1.00 5,561 0.14 0 0 0.44 0 0.00 SYSTEM 1,512 0 0.01 1.00 651 0.05 0 0 0.43 4 0.00 UNDOTBS1 0 0 0.00 0.00 1,907 0.00 0 0 0.64 0 0.00 TBS_IDX 1,328 0 0.01 1.00 0 0.05 0 0 0.00 0 0.00 ZGRS_BIZ 83 0 0.00 1.00 0 0.00 0 0 0.00 0 0.00 TEMP 1 0 0.00 1.00 1 0.00 0 0 0.00 0 0.00Tablespace | Filename | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) | SYSAUX /datafs/oradata/orcl/sysaux01.dbf 4,067 0 0.01 1.00 0 0.01 5,561 0 0 0.00 SYSTEM /datafs/oradata/orcl/system01.dbf 1,512 0 0.01 1.00 0 0.01 651 0 4 0.00 TBS_IDX /datafs/oradata/orcl/tbs_idx.dbf 617 0 0.02 1.00 0 0.00 0 0 0 0.00 TBS_IDX /datafs/oradata/orcl/tbs_idx2.dbf 711 0 0.00 1.00 0 0.01 0 0 0 0.00 TEMP /datafs/oradata/orcl/temp01.dbf 1 0 0.00 1.00 0 0.00 1 0 0 UNDOTBS1 /datafs/oradata/orcl/undotbs01.dbf 0 0 0 1,907 0 0 0.00 ZGRS_BIZ /datafs/oradata/orcl/zgrs_biz.dbf 83 0 0.00 1.00 0 0.00 0 0 0 0.00P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits | D 92,543 99 933,126 6,991 15,560 0 0 4MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes | 0 0 0 0 15,418 0Targt 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 | B 0 8 380 1676 1834 165888 1834 E 0 8 392 1593 1700 165888 1700P | Size for Est (M) | Size Factor | Buffers (thousands) | Est Phys Read Factor | Estimated Phys Reads (thousands) | Est Phys Read Time | Est %DBtime for Rds | D 64 0.08 8 1.87 25,341 1 740.00 D 128 0.17 16 1.65 22,376 1 615.00 D 192 0.25 24 1.52 20,567 1 539.00 D 256 0.33 32 1.41 19,188 1 482.00 D 320 0.42 39 1.33 18,060 1 434.00 D 384 0.50 47 1.25 16,992 1 389.00 D 448 0.58 55 1.17 15,896 1 343.00 D 512 0.67 63 1.10 14,885 1 301.00 D 576 0.75 71 1.04 14,123 1 269.00 D 640 0.83 79 1.02 13,828 1 257.00 D 704 0.92 87 1.01 13,686 1 251.00 D 768 1.00 95 1.00 13,574 1 246.00 D 832 1.08 102 0.99 13,476 1 242.00 D 896 1.17 110 0.99 13,382 1 238.00 D 960 1.25 118 0.98 13,293 1 234.00 D 1,024 1.33 126 0.97 13,205 1 230.00 D 1,088 1.42 134 0.97 13,120 1 227.00 D 1,152 1.50 142 0.96 13,041 1 223.00 D 1,216 1.58 150 0.96 12,968 1 220.00 D 1,280 1.67 158 0.95 12,899 1 218.00PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written | 100.00 342 0Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs | 2K 4K 28,345 28,345 0 0 64K 128K 48 48 0 0 256K 512K 2 2 0 0 512K 1024K 89 89 0 0 1M 2M 79 79 0 0 4M 8M 16 16 0 0PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count | Estd Time | 138 0.13 476,351.83 0.00 100.00 0 42,011,109 276 0.25 476,351.83 0.00 100.00 0 42,109 552 0.50 476,109 828 0.75 476,109 1,104 1.00 476,109 1,325 1.20 476,546 1.40 476,766 1.60 476,987 1.80 476,109 2,208 2.00 476,109 3,312 3.00 476,109 4,416 4.00 476,109 6,624 6.00 476,109 8,832 8.00 476,109Shared 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) | 832 0.68 117 3,369 461,038 0.46 545,311 139.00 81,555 960 0.79 244 6,986 649,305 0.65 357,044 91.01 93,244 1,056 0.87 340 9,471 792,393 0.79 213,956 54.54 101,982 1,072 0.88 355 9,906 815,249 0.81 191,100 48.71 103,394 1,088 0.89 370 10,069 839,148 0.84 167,201 42.62 104,810 1,104 0.91 385 10,232 862,423 0.86 143,926 36.69 106,225 1,120 0.92 400 10,395 886,419 0.88 119,930 30.57 107,639 1,136 0.93 416 10,907 909,728 0.91 96,621 24.63 109,057 1,152 0.95 432 11,210 933,270 0.93 73,079 18.63 110,468 1,168 0.96 448 11,513 955,610 0.95 50,739 12.93 111,835 1,184 0.97 464 11,816 978,027 0.98 28,322 7.22 113,186 1,200 0.99 480 12,119 999,357 1.00 6,992 1.78 114,517 1,216 1.00 496 12,422 1,002,426 1.00 3,923 1.00 114,720 1,232 1.01 512 12,793 1,487 1.00 3,862 0.98 114,740 1,248 1.03 528 12,912 1,509 1.00 3,840 0.98 114,751 1,264 1.04 544 13,398 1,536 1.00 3,813 0.97 114,758 1,280 1.05 560 14,057 1,561 1.00 3,788 0.97 114,766 1,296 1.07 576 14,628 1,575 1.00 3,774 0.96 114,772 1,312 1.08 592 15,209 1,598 1.00 3,751 0.96 114,778 1,328 1.09 608 15,790 1,612 1.00 3,737 0.95 114,784 1,344 1.11 624 16,365 1,624 1.00 3,725 0.95 114,789 1,360 1.12 640 16,940 1,644 1.00 3,705 0.94 114,794 1,472 1.21 752 21,302 1,698 1.00 3,651 0.93 114,807 1,600 1.32 880 26,331 1,721 1.00 3,628 0.92 114,814 1,728 1.42 1,008 31,360 1,758 1.00 3,591 0.92 114,821 1,856 1.53 1,136 36,389 1,796 1.00 3,553 0.91 114,827 1,984 1.63 1,264 41,418 1,823 1.00 3,526 0.90 114,833 2,112 1.74 1,392 46,447 1,869 1.00 3,480 0.89 114,839 2,240 1.84 1,520 51,476 1,886 1.00 3,463 0.88 114,845 2,368 1.95 1,648 56,505 1,917 1.00 3,432 0.87 114,851 2,496 2.05 1,776 61,534 1,948 1.00 3,401 0.87 114,856SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads | 1,024 0.50 597,869 20,404,655 1,536 0.75 54,076 18,755,396 2,048 1.00 53,700 13,145 2,560 1.25 53,555 12,609,023 3,072 1.50 53,437 12,023 3,584 1.75 53,378 12,041,624 4,096 2.00 53,367 11,763,354Class | Waits | Total Wait Time (s) | Avg Time (ms) | data block 4 0 0Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) | CR-Reuse Block Range (block range reuse ckpt) 542 542 0 41 0 1.71 RO-Multiple Object Reuse (fast object reuse) 410 410 0 41 0 0.24Undo 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 | 2 4.61 6,039 1,305 4 15/33.8 0/0 0/0/0/0/0/0End 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 | 22-Feb 08:58 23 103 670 3 22 0/0 0/0/0/0/0/0 22-Feb 08:48 12 73 1,273 2 32 0/0 0/0/0/0/0/0 22-Feb 08:38 17 87 672 1 22 0/0 0/0/0/0/0/0 22-Feb 08:28 12 73 1,276 1 32 0/0 0/0/0/0/0/0 22-Feb 08:18 3,065 567 674 2 22 0/0 0/0/0/0/0/0 22-Feb 08:08 106 160 1,278 3 32 0/0 0/0/0/0/0/0 22-Feb 07:58 15 100 676 2 22 0/0 0/0/0/0/0/0 22-Feb 07:48 19 88 1,278 4 32 0/0 0/0/0/0/0/0 22-Feb 07:38 13 73 677 2 22 0/0 0/0/0/0/0/0 22-Feb 07:28 12 90 76 1 15 0/0 0/0/0/0/0/0 22-Feb 07:18 21 81 678 3 22 0/0 0/0/0/0/0/0 22-Feb 07:08 124 270 77 3 15 0/0 0/0/0/0/0/0 22-Feb 06:58 12 76 681 2 22 0/0 0/0/0/0/0/0 22-Feb 06:48 16 86 1,284 2 32 0/0 0/0/0/0/0/0 22-Feb 06:38 13 73 681 2 22 0/0 0/0/0/0/0/0 22-Feb 06:28 15 88 1,285 2 32 0/0 0/0/0/0/0/0 22-Feb 06:18 10 150 684 1 22 0/0 0/0/0/0/0/0 22-Feb 06:08 119 166 1,285 3 33 0/0 0/0/0/0/0/0 22-Feb 05:58 14 92 684 2 23 0/0 0/0/0/0/0/0 22-Feb 05:48 16 75 1,288 3 33 0/0 0/0/0/0/0/0 22-Feb 05:38 14 91 685 2 23 0/0 0/0/0/0/0/0 22-Feb 05:28 15 73 84 2 15 0/0 0/0/0/0/0/0 22-Feb 05:18 14 168 688 1 23 0/0 0/0/0/0/0/0 22-Feb 05:08 112 196 86 3 15 0/0 0/0/0/0/0/0 22-Feb 04:58 16 76 689 2 23 0/0 0/0/0/0/0/0 22-Feb 04:48 13 87 88 2 15 0/0 0/0/0/0/0/0 22-Feb 04:38 19 73 691 2 24 0/0 0/0/0/0/0/0 22-Feb 04:28 13 105 1,292 1 34 0/0 0/0/0/0/0/0 22-Feb 04:18 13 76 691 2 24 0/0 0/0/0/0/0/0 22-Feb 04:08 131 271 1,295 3 34 0/0 0/0/0/0/0/0 22-Feb 03:58 23 105 693 2 24 0/0 0/0/0/0/0/0 22-Feb 03:48 16 73 1,297 2 34 0/0 0/0/0/0/0/0 22-Feb 03:38 15 104 696 2 24 0/0 0/0/0/0/0/0 22-Feb 03:28 16 73 94 2 15 0/0 0/0/0/0/0/0Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss | AQ deq hash table latch 8 0.00 0 0 ASM db client latch 19,341 0.00 0 0 ASM map operation hash table 8 0.00 0 0 ASM network state latch 456 0.00 0 0 AWR Alerted Metric Element list 239,885 0.00 0 0 Change Notification Hash table latch 9,581 0.00 0 0 Consistent RBA 5,728 0.00 0 0 DML lock allocation 27,634 0.00 0 0 Event Group Locks 3,175 0.00 0 0 FOB s.o list latch 1,526 0.00 0 0 File State Object Pool Parent Latch 8 0.00 0 0 I/O Staticstics latch 8 0.00 0 0 IPC stats buffer allocation latch 8 0.00 0 0 In memory undo latch 48,933 0.00 0 10,179 0.00 JS Sh mem access 60 0.00 0 0 JS mem alloc latch 47 0.00 0 0 JS queue access latch 55 0.00 0 0 JS queue state obj latch 208,820 0.00 0 0 JS slv state obj latch 2,944 0.51 0.07 0 0 KFC FX Hash Latch 8 0.00 0 0 KFC Hash Latch 8 0.00 0 0 KFCL LE Freelist 8 0.00 0 0 KGNFS-NFS:SHM structure 8 0.00 0 0 KGNFS-NFS:SVR LIST 8 0.00 0 0 KJC message pool free list 8 0.00 0 0 KJCT flow control latch 8 0.00 0 0 KMG MMAN ready and startup request latch 9,582 0.00 0 0 KTF sga latch 151 0.00 0 9,117 0.00 KWQMN job cache list latch 9 0.00 0 0 KWQS pqueue ctx latch 504 0.00 0 0 Locator state objects pool parent latch 8 0.00 0 0 Lsod array latch 8 0.00 0 0 MQL Tracking Latch 0 0 575 0.00 Memory Management Latch 8 0.00 0 9,582 0.00 Memory Queue 8 0.00 0 0 Memory Queue Message Subscriber #1 8 0.00 0 0 Memory Queue Message Subscriber #2 8 0.00 0 0 Memory Queue Message Subscriber #3 8 0.00 0 0 Memory Queue Message Subscriber #4 8 0.00 0 0 Memory Queue Subscriber 8 0.00 0 0 MinActiveScn Latch 318 0.00 0 0 Mutex 8 0.00 0 0 Mutex Stats 8 0.00 0 0 OS process 10,850 0.00 0 0 OS process allocation 64,327 0.01 0.00 0 0 OS process: request allocation 2,623 0.00 0 0 PL/SQL warning settings 3,503 0.00 0 0 PX hash array latch 8 0.00 0 0 QMT 8 0.00 0 0 Real-time plan statistics latch 34,967 0.00 0 0 Result Cache: RC Latch 4,218 0.00 0 0 SGA IO buffer pool latch 2 0.00 0 2 0.00 SGA blob parent 8 0.00 0 0 SGA bucket locks 8 0.00 0 0 SGA heap locks 8 0.00 0 0 SGA pool locks 8 0.00 0 0 SQL memory manager latch 966 0.00 0 9,577 0.00 SQL memory manager workarea list latch 649,315 0.00 0 0 Shared B-Tree 2,549 0.00 0 0 Streams Generic 8 0.00 0 0 Testing 8 0.00 0 0 Token Manager 8 0.00 0 0 WCR: sync 8 0.00 0 0 Write State Object Pool Parent Latch 8 0.00 0 0 X$KSFQP 8 0.00 0 0 XDB NFS Security Latch 8 0.00 0 0 XDB unused session pool 8 0.00 0 0 XDB used session pool 8 0.00 0 0 active checkpoint queue latch 18,340 0.00 0 0 active service list 65,657 0.01 0.00 0 33,808 0.00 buffer pool 8 0.00 0 0 business card 8 0.00 0 0 cache buffer handles 70 0.00 0 0 cache buffers chains 2,659,060 0.00 0.17 0 12,192 0.00 cache buffers lru chain 28,817 0.00 0.00 0 31,744 0.00 call allocation 9,795 0.26 0.52 0 0 cas latch 8 0.00 0 0 change notification client cache latch 8 0.00 0 0 channel handle pool latch 2,845 0.00 0 0 channel operations parent latch 142,206 0.00 0.00 0 0 checkpoint queue latch 892,748 0.00 0.00 0 14,960 0.00 client/application info 6,370 0.00 0 0 compile environment latch 1,856 0.00 0 0 corrupted undo seg latch 1,923 0.00 0 0 cp cmon/server latch 8 0.00 0 0 cp pool latch 8 0.00 0 0 cp server hash latch 8 0.00 0 0 cp sga latch 456 0.00 0 0 cvmap freelist lock 8 0.00 0 0 database property service latch 6 0.00 0 0 deferred cleanup latch 456 0.00 0 0 dml lock allocation 538 0.00 0 0 done queue latch 8 0.00 0 0 dummy allocation 3,721 0.00 0 0 eighth spare latch - X parent 8 0.00 0 0 eleventh spare latch - children 8 0.00 0 0 enqueue freelist latch 8 0.00 0 486,894 0.00 enqueue hash chains 537,611 0.00 0.00 0 0 enqueues 2 0.00 0 0 fifteenth spare latch - children 8 0.00 0 0 file cache latch 1,452 0.00 0 0 first Audit Vault latch 192 0.00 0 0 flashback copy 8 0.00 0 0 fourteenth spare latch - children 8 0.00 0 0 fourth Audit Vault latch 8 0.00 0 0 gc element 8 0.00 0 0 gcs commit scn state 8 0.00 0 0 gcs partitioned table hash 8 0.00 0 0 gcs pcm hashed value bucket hash 8 0.00 0 0 gcs resource freelist 8 0.00 0 0 gcs resource hash 8 0.00 0 0 gcs resource scan list 8 0.00 0 0 gcs resource validate list 8 0.00 0 0 gcs shadows freelist 8 0.00 0 0 ges domain table 8 0.00 0 0 ges enqueue table freelist 8 0.00 0 0 ges group table 8 0.00 0 0 ges process hash list 8 0.00 0 0 ges process parent latch 8 0.00 0 0 ges resource hash list 8 0.00 0 0 ges resource scan list 8 0.00 0 0 ges resource table freelist 8 0.00 0 0 ges value block free list 8 0.00 0 0 global KZLD latch for mem in SGA 192 0.00 0 0 global tx hash mapping 8 0.00 0 0 granule operation 8 0.00 0 0 hash table column usage latch 625 0.00 0 16,514 0.00 hash table modification latch 686 0.00 0 0 heartbeat check 8 0.00 0 0 interrupt manipulation 1 0.00 0 0 intra txn parallel recovery 8 0.00 0 0 io pool granule metadata list 8 0.00 0 0 job workq parent latch 553 0.00 0 545 2.02 job_queue_processes free list latch 1,125 0.00 0 0 job_queue_processes parameter latch 6,800 0.00 0 0 k2q lock allocation 8 0.00 0 0 kcbtsemkid latch 2 0.00 0 0 kdlx hb parent latch 8 0.00 0 0 kgb parent 8 0.00 0 0 kgnfs mount latch 8 0.00 0 0 kmcptab latch 3 0.00 0 0 kmcpvec latch 0 0 1 0.00 kokc descriptor allocation latch 44 0.00 0 0 ksfv messages 8 0.00 0 0 ksim group membership cache 8 0.00 0 0 kss move lock 334 0.00 0 0 ksuosstats global area 2,899 0.00 0 0 ksv allocation latch 1,108 0.00 0 0 ksv class latch 660 0.00 0 0 ksv msg queue latch 8 0.00 0 0 ksz_so allocation latch 2,623 0.08 0.00 0 0 ktm global data 469 0.00 0 0 kwqbsn:qsga 1,027 0.00 0 0 lgwr LWN SCN 13,953 0.00 0 0 list of block allocation 2,126 0.05 0.00 0 0 loader state object freelist 44 0.00 0 0 lob segment dispenser latch 8 0.00 0 0 lob segment hash table latch 104 0.00 0 0 lob segment query latch 8 0.00 0 0 lock DBA buffer during media recovery 8 0.00 0 0 logical standby cache 8 0.00 0 0 logminer context allocation 8 0.00 0 0 logminer local 8 0.00 0 0 logminer work area 8 0.00 0 0 longop free list parent 8 0.00 0 0 mapped buffers lru chain 8 0.00 0 0 message pool operations parent latch 333 0.00 0 0 messages 317,025 0.01 0.00 0 0 mostly latch-free SCN 14,022 0.03 0.00 0 0 msg queue latch 8 0.00 0 0 name-service namespace bucket 8 0.00 0 0 ncodef allocation latch 456 0.00 0 0 nineth spare latch - X parent 8 0.00 0 0 object queue header heap 7,363 0.00 0 6,972 0.00 object queue header operation 79,526 0.00 0 0 object stats modification 6,653 0.00 0 0 parallel query alloc buffer 3,768 0.00 0 0 parallel query stats 8 0.00 0 0 parameter list 946 0.00 0 0 parameter table management 8,612 0.00 0 0 peshm 8 0.00 0 0 pesom_free_list 8 0.00 0 0 pesom_hash_node 8 0.00 0 0 post/wait queue 13,822 0.35 0.00 0 12,331 0.08 process allocation 3,742 0.16 0.00 0 1,311 0.00 process group creation 2,623 0.11 0.00 0 0 process queue 8 0.00 0 0 process queue reference 8 0.00 0 0 qmn task queue latch 4,180 0.00 0 0 query server freelists 8 0.00 0 0 queued dump request 96 0.00 0 0 queuing load statistics 8 0.00 0 0 recovery domain hash list 8 0.00 0 0 redo allocation 54,918 0.04 0.00 0 226,086 0.00 redo copy 8 0.00 0 226,092 0.07 redo writing 55,231 0.00 0 0 resmgr group change latch 1,321 0.00 0 0 resmgr:active threads 4,505 0.00 0 1,242 0.00 resmgr:actses change group 950 0.00 0 0 resmgr:actses change state 22 0.00 0 0 resmgr:free threads list 3,741 0.19 0.00 0 0 resmgr:method mem alloc latch 4 0.00 0 0 resmgr:plan CPU method 8 0.00 0 0 resmgr:schema config 1,400 0.00 0 59 0.00 resmgr:session queuing 8 0.00 0 0 rm cas latch 8 0.00 0 0 row cache objects 420,222 0.00 0.00 0 286 0.00 second Audit Vault latch 8 0.00 0 0 sequence cache 2,359 0.00 0 0 session allocation 6,581 0.00 0 3,176 0.00 session idle bit 13,233 0.00 0 0 session queue latch 8 0.00 0 0 session state list latch 5,156 0.00 0 0 session switching 1,776 0.00 0 0 session timer 9,578 0.00 0 0 seventh spare latch - X parent 8 0.00 0 0 shared pool 201,585 0.26 0.02 0 0 shared pool sim alloc 15 0.00 0 0 shared pool simulator 946 0.00 0 0 sim partition latch 8 0.00 0 0 simulator hash latch 58,732 0.00 0 0 simulator lru latch 7,774 0.00 0 50,902 0.00 sixth spare latch - X parent 8 0.00 0 0 sort extent pool 783 0.00 0 0 space background state object latch 80 0.00 0 0 space background task latch 36,311 0.44 0.01 0 19,198 0.00 state object free list 16 0.00 0 0 statistics aggregation 4,480 0.00 0 0 tablespace key chain 8 0.00 0 0 temp lob duration state obj allocation 16 0.00 0 0 temporary table state object allocation 2 0.00 0 0 tenth spare latch - X parent 8 0.00 0 0 test excl. parent l0 8 0.00 0 0 test excl. parent2 l0 8 0.00 0 0 thirteenth spare latch - children 8 0.00 0 0 threshold alerts latch 1,144 0.00 0 0 transaction allocation 7,614 0.01 0.00 0 0 twelfth spare latch - children 8 0.00 0 0 twenty-fifth spare latch - S par 8 0.00 0 0 twenty-first spare latch - S par 8 0.00 0 0 twenty-fourth spare latch - S par 8 0.00 0 0 twenty-second spare latch - S par 8 0.00 0 0 twenty-third spare latch - S par 8 0.00 0 0 undo global data 36,232 0.00 0 0 virtual circuit buffers 8 0.00 0 0 virtual circuit holder 8 0.00 0 0 virtual circuit queues 8 0.00 0 0 write info latch 0 0 5,727 0.00Latch Name | Get Requests | Misses | Sleeps | Spin Gets | shared pool 201,585 534 12 522 space background task latch 36,311 159 1 158 call allocation 9,795 25 13 12 JS slv state obj latch 2,944 15 1 14 cache buffers chains 2,060 6 1 5Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps | JS slv state obj latch jslvStateObjDel:1 0 1 1 cache buffers chains kcbgcur_2 0 1 0 cache buffers chains kcbgtcr: fast path (cr pin) 0 1 1 call allocation ksuxds 0 13 5 shared pool kghalo 0 12 6 space background task latch ktsj_grab_task 0 1 1Mutex Type | Location | Sleeps | Wait Time (ms) | Library Cache kglget2 2 4 0 Library Cache kgllkc1 57 4 0 Library Cache kglhdgn2 106 3 0Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total | SYS SYSTEM I_SYSAUTH1 INDEX 128,048 13.72 SYS SYSAUX WRH$_SYSMETRIC_HISTORY_INDEX INDEX 87,648 9.39 SYS SYSAUX I_WRI$_OPTSTAT_H_ST INDEX 66,224 7.10 SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 65,200 6.99 SYS SYSTEM RECYCLEBIN$ TABLE 55,168 5.91Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total | SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 84 1.20 SYSMAN SYSAUX MGMT_TASK_QTABLE_IDX02 INDEX 3 0.04 SYSMAN SYSAUX SYS_C005714 INDEX 2 0.03 ** MISSING ** TBS_IDX ** TRANSIENT: 145679 ** MISSING ** UNDEFINED 1 0.01 SYS SYSTEM KOTAD$ TABLE 1 0.01Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total | SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 84 1.20 SYSMAN SYSAUX MGMT_TASK_QTABLE_IDX02 INDEX 3 0.04 SYSMAN SYSAUX SYS_C005714 INDEX 2 0.03 ** MISSING ** TBS_IDX ** TRANSIENT: 145679 ** MISSING ** UNDEFINED 1 0.01 SYS SYSTEM KOTAD$ TABLE 1 0.01Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total | SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 84 1.20 SYSMAN SYSAUX MGMT_TASK_QTABLE_IDX02 INDEX 3 0.04 SYSMAN SYSAUX SYS_C005714 INDEX 2 0.03 ** MISSING ** TBS_IDX ** TRANSIENT: 145679 ** MISSING ** UNDEFINED 1 0.01 SYS SYSTEM KOTAD$ TABLE 1 0.01Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total | SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 980 6.30 SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 454 2.92 SYS SYSAUX I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX 424 2.72 SYS SYSAUX WRH$_SYSMETRIC_HISTORY TABLE 298 1.92 SYSMAN SYSAUX MGMT_METRICS_1HOUR_PK INDEX 269 1.73Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total | SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 284 3.50 SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 238 2.93 SYS SYSAUX I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX 199 2.45 SYS SYSAUX WRH$_SYSMETRIC_HISTORY TABLE 166 2.04 SYS SYSAUX WRH$_SYSMETRIC_HISTORY_INDEX INDEX 143 1.76Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total | SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 35 22.01 SYSMAN SYSAUX MGMT_METRICS_1HOUR_PK INDEX 28 17.61 SYSMAN SYSAUX MGMT_CURRENT_METRICS_PK INDEX 7 4.40 SYS SYSTEM I_OBJ2 INDEX 1 0.63Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture | SYS SYSAUX WRH$_SYSMETRIC_HISTORY TABLE 29,712 15.45 SYS SYSAUX WRH$_SYSMETRIC_HISTORY_INDEX INDEX 29,552 15.37 SYS SYSAUX WRI$_OPTSTAT_HISTGRM_HISTORY TABLE 22,832 11.87 SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX 22,160 11.52 SYS SYSAUX I_WRI$_OPTSTAT_H_ST INDEX 21,792 11.33Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture | SYS SYSTEM SEG$ TABLE 4 100.00Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage | dc_awr_control 561 0.00 0 18 1 dc_files 56 0.00 0 0 7 dc_global_oids 1,867 0.00 0 0 51 dc_histogram_data 5,615 3.99 0 0 5,106 dc_histogram_defs 8,803 11.58 0 0 3,436 dc_object_grants 2 0.00 0 0 47 dc_objects 10,052 1.81 0 327 1,797 dc_profiles 946 0.00 0 0 1 dc_rollback_segments 9,712 0.00 0 0 29 dc_segments 2,574 1.59 0 295 944 dc_sequences 5 0.00 0 5 6 dc_tablespaces 9,384 0.00 0 0 8 dc_users 76,661 0.00 0 0 148 global database name 20,041 0.00 0 0 1 outstanding_alerts 256 0.00 0 0 6 sch_lj_oids 35 0.00 0 0 16Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations | ACCOUNT_STATUS 576 0.00 0 0 0 BODY 10,435 0.00 14,714 0.00 0 0 CLUSTER 34 0.00 34 0.00 0 0 DBLINK 592 0.00 0 0 0 EDITION 860 0.00 1,597 0.00 0 0 INDEX 148 0.00 148 3.38 5 0 OBJECT ID 62 100.00 0 0 0 QUEUE 480 0.00 1,727 0.00 0 0 SCHEMA 813 0.12 0 0 0 SQL AREA 11,125 0.98 161,702 0.48 160 613 SQL AREA BUILD 316 68.67 0 0 0 SQL AREA STATS 314 92.36 314 92.36 0 0 SUBSCRIPTION 103 0.00 103 0.00 0 0 TABLE/PROCEDURE 4,590 0.54 21,875 1.07 70 0 TRIGGER 1,820 0.00 2,206 0.00 0 0Component | Begin Snap Size (Mb) | Current Size (Mb) | Min Size (Mb) | Max Size (Mb) | Oper Count | Last Op Typ/Mod | ASM Buffer Cache 0.00 0.00 0.00 0.00 0 STA/ DEFAULT 16K buffer cache 0.00 0.00 0.00 0.00 0 STA/ DEFAULT 2K buffer cache 0.00 0.00 0.00 0.00 0 STA/ DEFAULT 32K buffer cache 0.00 0.00 0.00 0.00 0 STA/ DEFAULT 4K buffer cache 0.00 0.00 0.00 0.00 0 STA/ DEFAULT 8K buffer cache 0.00 0.00 0.00 0.00 0 STA/ DEFAULT buffer cache 752.00 752.00 672.00 1,408.00 0 SHR/IMM KEEP buffer cache 0.00 0.00 0.00 0.00 0 STA/ PGA Target 1,104.00 1,264.00 0 SHR/MAN RECYCLE buffer cache 0.00 0.00 0.00 0.00 0 STA/ SGA Target 2,048.00 2,048.00 1,888.00 2,048.00 0 GRO/DEF Shared IO Pool 0.00 0.00 0.00 0.00 0 STA/ java pool 16.00 16.00 16.00 16.00 0 STA/ large pool 32.00 32.00 32.00 768.00 0 SHR/DEF shared pool 1,216.00 1,216.00 272.00 1,216.00 0 GRO/IMM streams pool 0.00 0.00 0.00 0.00 0 STA/Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | B Other 179.88 1.62 1.70 16 16 111 111 B Freeable 73.63 0.00 1.57 4.32 30 47 47 B SQL 7.01 3.85 0.07 0.12 1 9 97 91 B PL/SQL 3.25 2.37 0.03 0.03 0 2 109 109 E Other 178.70 1.62 1.70 16 16 110 110 E Freeable 73.50 0.00 1.56 4.32 30 47 47 E SQL 6.96 3.85 0.07 0.12 1 9 97 91 E PL/SQL 3.23 2.37 0.03 0.03 0 2 108 108SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) | Database Buffers 788,529,152 Fixed Size 2,257,720 Redo Buffers 16,527,360 Variable Size 2,483,240Pool | Name | Begin MB | End MB | % Diff | java free memory 16.00 16.00 0.00 large PX msg pool 7.81 7.81 0.00 large free memory 24.19 24.19 0.00 shared FileOpenBlock 15.20 15.20 0.00 shared KGLH0 146.86 147.93 0.73 shared KGLHD 21.37 21.51 0.66 shared KTI-UNDO 22.30 22.30 0.00 shared SQLA 471.45 469.98 -0.31 shared dbktb: trace buffer 31.25 31.25 0.00 shared event statistics per sess 37.93 37.93 0.00 shared free memory 142.67 142.12 -0.39 shared kglsim object batch 16.92 16.94 0.11 shared ksunfy : SSO free list 36.08 36.08 0.00 shared private strands 43.12 43.12 0.00 buffer_cache 752.00 752.00 0.00 fixed_sga 2.15 2.15 0.00 log_buffer 15.76 15.76 0.00Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers | 0 0 1 0 1 0Common 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) | 0 0 0 0.00 0 0 0 0Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % | 28,753 0.00 100.00 0.00 0.00Name | Avg Conns | Total Disp Time (s) | %Busy | %Idle | Total Queued | Total Queue Wait (s) | Avg Queue Wait (ms) | D000 0.00 28,753 0.00 100.00 0 0Parameter Name | Begin value | End value (if different) | audit_file_dest /oracle/app/oracle/admin/orcl/adump audit_trail DB compatible 11.2.0.4.0 control_files /datafs/oradata/orcl/control01.ctl,/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl db_block_size 8192 db_domain db_name orcl db_recovery_file_dest /oracle/app/oracle/fast_recovery_area db_recovery_file_dest_size 4385144832 diagnostic_dest /oracle/app/oracle dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB) memory_target 3305111552 open_cursors 300 plsql_warnings DISABLE:ALL processes 2000 remote_login_passwordfile EXCLUSIVE resource_manager_plan SCHEDULER[0x32DA]:DEFAULT_MAINTENANCE_PLAN undo_tablespace UNDOTBS1Parameter Name | Begin value | End value (if different) | control_files /datafs/oradata/orcl/control01.ctl control_files /oracle/app/oracle/fast_recovery_area/orcl/control02.ctl
|---|