|OUTPUT | |--------------------------------------------------------------------------------| |WORKLOAD REPOSITORY report for | | | |DB Name DB Id Unique Name DB Role Edition Release RAC CDB| |------------ ----------- ----------- ---------------- ------- ---------- --- ---| |DB 1979277899 db PRIMARY EE 19.0.0.0.0 NO NO | | | |Instance Inst Num Startup Time | |------------ -------- --------------- | |db1 1 28-Dec-25 19:00 | | | |Host Name Platform CPUs Cores Sockets Memory(GB) | |---------------- -------------------------------- ---- ----- ------- ---------- | |oracle-19c-ol7-1 Linux x86 64-bit 4 4 4 7.75 | | | | Snap Id Snap Time Sessions Curs/Sess | | --------- ------------------- -------- --------- | |Begin Snap: 331 30-Dec-25 09:50:16 65 3.9 | | End Snap: 332 30-Dec-25 10:00:17 65 3.9 | | Elapsed: 10.01 (mins) | | DB Time: 0.09 (mins) | | | |Load Profile Per Second Per Transaction Per Exec Per Call| |~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------| | DB Time(s): 0.0 0.4 0.00 0.01| | DB CPU(s): 0.0 0.4 0.00 0.01| | Background CPU(s): 0.0 0.7 0.00 0.00| | Redo size (bytes): 5,085.1 218,144.0 | | Logical read (blocks): 33.9 1,454.0 | | Block changes: 15.8 675.5 | | Physical read (blocks): 0.2 8.4 | |Physical write (blocks): 1.2 52.8 | | Read IO requests: 0.2 8.4 | | Write IO requests: 0.8 33.1 | | Read IO (MB): 0.0 0.1 | | Write IO (MB): 0.0 0.4 | | IM scan rows: 0.0 0.0 | |Session Logical Read IM: 0.0 0.0 | | User calls: 1.1 47.0 | | Parses (SQL): 4.4 186.4 | | Hard parses (SQL): 0.0 0.1 | | SQL Work Area (MB): 0.5 22.7 | | Logons: 0.0 0.1 | | User logons: 0.0 0.1 | | Executes (SQL): 5.7 242.6 | | Rollbacks: 0.0 0.0 | | Transactions: 0.0 | | | |Instance Efficiency Percentages (Target 100%) | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | Buffer Nowait %: 100.00 Redo NoWait %: 99.96 | | Buffer Hit %: 99.42 In-memory Sort %: 100.00 | | Library Hit %: 99.89 Soft Parse %: 99.92 | | Execute to Parse %: 23.17 Latch Hit %: 99.56 | |Parse CPU to Parse Elapsd %: 166.67 % Non-Parse CPU: 99.66 | | Flash Cache Hit %: 0.00 | | | |Top 10 Foreground Events by Total Wait Time | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | Total Wait Avg % DB Wait | |Event Waits Time (sec) Wait time Class | |------------------------------ ----------- ---------- --------- ------ -------- | |DB CPU 5.2 94.7 | |control file sequential read 2,280 0 16.72us .7 System I | |PGA memory operation 1,083 0 34.29us .7 Other | |SQL*Net message to client 642 0 4.78us .1 Network | |log file sync 1 0 3.05ms .1 Commit | |Disk file operations I/O 7 0 100.29us .0 User I/O | |asynch descriptor resize 1 0 36.00us .0 Other | |AWR Flush 0 0 .0 Other | |KSV master wait 0 0 .0 Other | |LGWR all worker groups 0 0 .0 Other | | | |Wait Classes by Total Wait Time | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | Avg Avg | | Total Wait Wait % DB Active | |Wait Class Waits Time (sec) Time time Sessions | |---------------- ---------------- ---------------- ---------- ------ -------- | |DB CPU 5 94.7 0.0 | |System I/O 4,451 4 850.60us 68.9 0.0 | |Other 1,406 0 136.34us 3.5 0.0 | |Configuration 2 0 41.16ms 1.5 0.0 | |User I/O 158 0 416.11us 1.2 0.0 | |Network 645 0 4.76us .1 0.0 | |Commit 1 0 3.05ms .1 0.0 | | | |Host CPU | |~~~~~~~~ Load Average | | CPUs Cores Sockets Begin End %User %System %WIO %Idle | |----- ----- ------- --------- --------- --------- --------- --------- --------- | | 4 4 4 0.00 0.10 0.8 0.5 0.1 98.2 | | | |Instance CPU | |~~~~~~~~~~~~ | | % of total CPU for Instance: 0.6 | | % of busy CPU for Instance: 33.4 | | %DB time waiting for CPU - Resource Mgr: 0.0 | | | |IO Profile Read+Write/Second Read/Second Write/Second | |~~~~~~~~~~ ----------------- --------------- --------------- | | Total Requests: 8.1 6.3 1.7 | | Database Requests: 1.0 0.2 0.8 | | Optimized Requests: 0.0 0.0 0.0 | | Redo Requests: 0.1 0.0 0.1 | | Total (MB): 0.2 0.1 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): 1.4 0.2 1.2 | | Via Buffer Cache (blocks): 1.4 0.2 1.2 | | Direct (blocks): 0.0 0.0 0.0 | | | |Memory Statistics | |~~~~~~~~~~~~~~~~~ Begin End | | ------------ ------------ | | Host Mem (MB): 7,935.1 7,935.1 | | SGA use (MB): 2,384.0 2,384.0 | | PGA use (MB): 556.5 557.8 | | % Host Mem used for SGA+PGA: 37.06 37.07 | | | |Cache Sizes Begin End | |~~~~~~~~~~~ ---------- ---------- | | Buffer Cache: 1,728M 1,728M Std Block Size: 8K | | Shared Pool Size: 355M 355M Log Buffer: 7,692K | | In-Memory Area: 0M 0M | | | | Shared Pool Statistics Begin End | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------ ------ | | Memory Usage %: 82.06 82.19 | | % SQL with executions>1: 82.62 86.06 | | % Memory for SQL w/exec>1: 77.86 88.07 | | | | | |Time Model Statistics DB/Inst: DB/db1 Snaps: 331-332 | |-> DB Time represents total time in user calls | |-> DB CPU represents CPU time of foreground processes | |-> Total CPU Time represents foreground and background processes | |-> Statistics including the word "background" measure background process | | time, therefore do not contribute to the DB time statistic | |-> Ordered by % of DB time in descending order, followed by Statistic Name | | | | % of % of Total| |Statistic Name Time (s) DB Time CPU Time| |------------------------------------------ ------------------ ------- ----------| |sql execute elapsed time 5.3 97.0 | |DB CPU 5.2 94.7 35.4| |parse time elapsed 0.1 1.0 | |connection management call elapsed time 0.0 .2 | |DB time 5.5 | |background elapsed time 10.3 | |background cpu time 9.5 64.6| |total CPU time 14.7 | | ------------------------------------------------------| | | |Operating System Statistics DB/Inst: DB/db1 Snaps: 331-332 | |-> *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 | |------------------------- ---------------------- ---------------- | |FREE_MEMORY_BYTES 72,499,200 77,336,576 | |INACTIVE_MEMORY_BYTES 4,289,900,544 4,286,697,472 | |SWAP_FREE_BYTES 17,179,328,512 | |BUSY_TIME 4,402 | |IDLE_TIME 234,204 | |IOWAIT_TIME 324 | |NICE_TIME 0 | |SYS_TIME 1,212 | |USER_TIME 1,835 | |LOAD 0 0 | |RSRC_MGR_CPU_WAIT_TIME 0 | |VM_IN_BYTES 0 | |VM_OUT_BYTES 0 | |PHYSICAL_MEMORY_BYTES 8,320,524,288 | |NUM_CPUS 4 | |NUM_CPU_CORES 4 | |NUM_CPU_SOCKETS 4 | |GLOBAL_RECEIVE_SIZE_MAX 4,194,304 | |GLOBAL_SEND_SIZE_MAX 1,048,576 | |TCP_RECEIVE_SIZE_DEFAULT 131,072 | |TCP_RECEIVE_SIZE_MAX 6,291,456 | |TCP_RECEIVE_SIZE_MIN 4,096 | |TCP_SEND_SIZE_DEFAULT 16,384 | |TCP_SEND_SIZE_MAX 4,194,304 | |TCP_SEND_SIZE_MIN 4,096 | | ------------------------------------------------------| | | |Operating System Statistics - Detail DB/Inst: DB/db1 Snaps: 331-332 | | | |Snap Time Load %busy %user %sys %idle %iowait | |--------------- -------- -------- -------- -------- -------- -------- | |30-Dec 09:50:16 0.0 N/A N/A N/A N/A N/A | |30-Dec 10:00:17 0.1 1.8 0.8 0.5 98.2 0.1 | | ------------------------------------------------------| | | |Foreground Wait Class DB/Inst: DB/db1 Snaps: 331-332 | |-> s - second, ms - millisecond, us - microsecond, ns - nanosecond | |-> 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 96.2% of Total DB time 5.50 (s)| |-> Total FG Wait Time: .08 (s) DB CPU time: 5.21 (s)| | | | %Time Total Wait | |Wait Class Waits -outs Time (s) Avg wait %DB time | |-------------------- --------------- ----- --------------- ---------- --------- | |DB CPU 5 94.7 | |System I/O 2,280 0 0 16.72us 0.7 | |Other 1,084 0 0 34.29us 0.7 | |Network 642 0 0 4.78us 0.1 | |Commit 1 0 0 3.05ms 0.1 | |User I/O 7 0 0 100.29us 0.0 | |Configuration 0 0 0.0 | | ------------------------------------------------------| | | | | |Foreground Wait Events DB/Inst: DB/db1 Snaps: 331-332 | |-> s - second, ms - millisecond, us - microsecond, ns - nanosecond | |-> 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 | | | | Total | | %Time Wait Waits % DB | |Event Waits -outs Time (s) Avg wait /txn time | |-------------------------- ----------- ----- -------- --------- -------- ------ | |control file sequential re 2,280 0 16.72us 162.9 .7 | |PGA memory operation 1,083 0 34.29us 77.4 .7 | |SQL*Net message to client 642 0 4.78us 45.9 .1 | |log file sync 1 0 3.05ms 0.1 .1 | |SQL*Net message from clien 638 2,995 4693.58ms 45.6 | |watchdog main loop 402 1,206 3000.23ms 28.7 | | ------------------------------------------------------| | | | | |Background Wait Events DB/Inst: DB/db1 Snaps: 331-332 | |-> 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 | | | | Total | | %Time Wait Waits % bg | |Event Waits -outs Time (s) Avg wait /txn time | |-------------------------- ----------- ----- -------- --------- -------- ------ | |control file parallel writ 260 0 2 7.81ms 18.6 19.6 | |db file async I/O submit 462 0 2 3.31ms 33.0 14.8 | |log file parallel write 39 0 0 3.79ms 2.8 1.4 | |latch free 228 0 0 463.72us 16.3 1.0 | |log file switch completion 2 0 0 41.16ms 0.1 .8 | |oracle thread bootstrap 1 0 0 39.32ms 0.1 .4 | |Disk file operations I/O 11 0 0 2.66ms 0.8 .3 | |control file sequential re 1,386 0 0 18.34us 99.0 .2 | |db file single write 5 0 0 4.15ms 0.4 .2 | |db file sequential read 134 0 0 91.93us 9.6 .1 | |Log archive I/O 8 0 0 790.25us 0.6 .1 | |log file single write 2 0 0 2.95ms 0.1 .1 | |KSV master wait 49 100 0 93.18us 3.5 .0 | |os thread creation 1 0 0 3.61ms 0.1 .0 | |log file sequential read 13 0 0 225.77us 0.9 .0 | |direct path write 1 0 0 2.64ms 0.1 .0 | |PGA memory operation 35 0 0 30.29us 2.5 .0 | |rdbms ipc message 3,823 98 10,799 2824.85ms 273.1 | |Space Manager: slave idle 1,488 0 4,805 3229.11ms 106.3 | |class slave wait 45 0 2,997 66.59 s 3.2 | |LGWR worker group idle 2 0 1,545 772.65 s 0.1 | |DIAG idle wait 1,200 100 1,200 1000.22ms 85.7 | |pmon timer 400 100 1,200 3000.23ms 28.6 | |Streams AQ: qmn slave idle 22 0 616 28.00 s 1.6 | |Streams AQ: qmn coordinato 44 0 616 14.00 s 3.1 | |lreg timer 201 100 603 3001.23ms 14.4 | |heartbeat redo informer 601 0 601 1000.25ms 42.9 | |wait for unread message on 601 100 601 1000.21ms 42.9 | |dispatcher timer 10 100 600 60.01 s 0.7 | |OFS idle 200 100 600 3000.25ms 14.3 | |pman timer 200 100 600 3000.22ms 14.3 | |Data Guard: Timer 20 0 600 30.00 s 1.4 | |AQPC idle 20 100 600 30.00 s 1.4 | |Data Guard: Gap Manager 10 0 600 60.00 s 0.7 | |smon timer 2 100 600 300.00 s 0.1 | |SQL*Net message from clien 4 0 0 1.43ms 0.3 | | ------------------------------------------------------| | | | | |Wait Event Histogram DB/Inst: DB/db1 Snaps: 331-332 | |-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 | |-> Units for % of Total Waits: | | us is microseconds | |-> % of Total Waits: value of .0 indicates value was <.05%; | | value of null is truly 0 | |-> Ordered by Event (idle events last) | | | | % of Total Waits | | -----------------------------------------------| | Total | |Event Waits <8us <16us <32us <64us <128u <256u <512u >=512| |------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----| |AWR Flush 2 100.0 | |Disk file operations I/O 18 5.6 22.2 22.2 22.2 11.1 16.7| |KSV master wait 49 10.2 20.4 44.9 22.4 2.0 | |LGWR all worker groups 1 100.0 | |LGWR wait for redo copy 2 50.0 50.0 | |Log archive I/O 8 12.5 12.5 75.0| |PGA memory operation 1118 12.5 25.0 30.2 21.1 9.7 1.1 .3 .1| |Redo Transport Open 1 100.0 | |SQL*Net message to client 645 93.8 5.1 .2 .8 .2 | |asynch descriptor resize 2 50.0 50.0 | |control file parallel wri 260 100.0| |control file sequential r 3666 18.8 56.6 8.9 13.9 1.4 .2 .0 .1| |db file async I/O submit 462 100.0| |db file sequential read 130 40.8 28.5 12.3 3.8 2.3 3.1 6.2 3.1| |db file single write 5 100.0| |direct path write 1 100.0| |get branch/thread/sequenc 1 100.0 | |latch free 228 5.3 3.1 .9 2.6 13.2 29.4 45.6| |log file parallel write 40 100.0| |log file sequential read 13 23.1 7.7 15.4 7.7 46.2 | |log file single write 2 100.0| |log file switch completio 2 100.0| |log file sync 1 100.0| |oracle thread bootstrap 1 100.0| |os thread creation 1 100.0| |AQPC idle 20 100.0| |DIAG idle wait 1200 100.0| |Data Guard: Gap Manager 10 100.0| |Data Guard: Timer 20 100.0| |LGWR worker group idle 2 100.0| |OFS idle 201 100.0| |SQL*Net message from clie 646 .2 .6 99.2| |Space Manager: slave idle 1487 .1 .4 .4 .1 99.0| |Streams AQ: qmn coordinat 44 4.5 4.5 40.9 50.0| |Streams AQ: qmn slave idl 22 100.0| |class slave wait 45 2.2 97.8| |dispatcher timer 10 100.0| |heartbeat redo informer 601 100.0| |lreg timer 201 100.0| |pman timer 200 100.0| |pmon timer 400 100.0| |rdbms ipc message 3823 .5 .0 .1 .1 99.3| |smon timer 2 100.0| |wait for unread message o 601 100.0| |watchdog main loop 402 100.0| | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 64 us) DB/Inst: DB/db1 Snaps: 331-332 | |-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 | |-> Units for % of Total Waits: | | us is microseconds | |-> % of Total Waits: total waits for all wait classes, including Idle | |-> % of Total Waits: value of .0 indicates value was <.05%; | | value of null is truly 0 | |-> Ordered by Event (only non-idle events are displayed) | | | | % of Total Waits | | -----------------------------------------------| | Waits | | 1us | |Event - 64us <1us <2us <4us <8us <16us <32us <64us >=64u| |------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----| |AWR Flush 2 100.0 | |Disk file operations I/O 9 5.6 22.2 22.2 50.0| |KSV master wait 15 2.0 8.2 20.4 69.4| |LGWR all worker groups 1 100.0 | |LGWR wait for redo copy 1 50.0 50.0| |Log archive I/O 1 12.5 87.5| |PGA memory operation 994 .2 1.8 10.6 25.0 30.2 21.1 11.1| |Redo Transport Open 1 100.0 | |SQL*Net message to client 644 .3 2.9 42.8 47.8 5.1 .2 .8 .2| |asynch descriptor resize 2 50.0 50.0 | |control file sequential r 3604 .4 4.3 14.1 56.6 8.9 13.9 1.7| |db file sequential read 111 2.3 38.5 28.5 12.3 3.8 14.6| |get branch/thread/sequenc 1 100.0 | |latch free 21 5.3 3.1 .9 90.8| |log file sequential read 6 23.1 7.7 15.4 53.8| | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 32 ms) DB/Inst: DB/db1 Snaps: 331-332 | |-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 | |-> Units for % of Total Waits: | | us is microseconds, | | ms is 1024 microseconds (approximately 1 millisecond) | |-> % of Total Waits: total waits for all wait classes, including Idle | |-> % of Total Waits: value of .0 indicates value was <.05%; | | value of null is truly 0 | |-> Ordered by Event (only non-idle events are displayed) | | | | % of Total Waits | | -----------------------------------------------| | Waits | | 1ms | |Event to 32m <512 <1ms <2ms <4ms <8ms <16ms <32ms >=32m| |------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----| |Disk file operations I/O 3 83.3 5.6 5.6 5.6 | |Log archive I/O 6 25.0 25.0 50.0 | |PGA memory operation 1 99.9 .1 | |control file parallel wri 260 70.0 30.0 | |control file sequential r 3 99.9 .0 .1 | |db file async I/O submit 462 93.9 6.1 | |db file sequential read 4 96.9 1.5 1.5 | |db file single write 5 40.0 60.0 | |direct path write 1 100.0 | |latch free 104 54.4 43.0 2.6 | |log file parallel write 40 2.5 67.5 25.0 5.0 | |log file single write 2 100.0 | |log file sync 1 100.0 | |os thread creation 1 100.0 | | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 2 sec) DB/Inst: DB/db1 Snaps: 331-332 | |-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 | |-> Units for % of Total Waits: | | ms is milliseconds | | s is 1024 milliseconds (approximately 1 second) | |-> % of Total Waits: total waits for all wait classes, including Idle | |-> % of Total Waits: value of .0 indicates value was <.05%; | | value of null is truly 0 | |-> Ordered by Event (only non-idle events are displayed) | | | | % of Total Waits | | -----------------------------------------------| | Waits | | 64ms | |Event to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s| |------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----| |log file switch completio 2 100.0 | |oracle thread bootstrap 1 100.0 | | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 2 min) DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 1 hr) DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Service Statistics DB/Inst: DB/db1 Snaps: 331-332 | |-> ordered by DB Time | | | | Physical Logical| |Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K)| |---------------------------- ------------ ------------ ------------ ------------| |db 5 5 0 4| |SYS$BACKGROUND 0 0 0 16| |SYS$USERS 0 0 0 0| |db1XDB 0 0 0 0| | ------------------------------------------------------| | | |Service Wait Class Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Wait Class info for services in the Service Statistics section. | |-> Total Waits and Time Waited displayed for the following wait | | classes: User I/O, Concurrency, Administrative, Network | |-> Time Waited (Wt Time) in seconds | | | |Service Name | |---------------------------------------------------------------- | | User I/O User I/O Concurcy Concurcy Admin Admin Network Network | |Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time | |--------- --------- --------- --------- --------- --------- --------- --------- | |db | | 7 0 0 0 0 0 642 0 | |SYS$BACKGROUND | | 134 0 0 0 0 0 0 0 | |SYS$USERS | | 0 0 0 0 0 0 0 0 | | ------------------------------------------------------| | | |Top 10 Channel Waits DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Top Process Types by Wait Class DB/Inst: DB/db1 Snaps: 331-332 | |-> This table displays top process types ordered by wait class | | | |Proce Description Wait Class Type Wait Time (sec | |----- ------------------------------ ---------------- -------------- | |CKPT checkpoint System I/O 1.7 | |DBW0 db writer process 0 System I/O 1.5 | |MMON Manageability Monitor Process System I/O .3 | |LGWR Redo etc. System I/O .2 | |W space management slave pool Other .1 | |M MMON slave class 1 Configuration .1 | |MMON Manageability Monitor Process Other .0 | | Others (foregrounds + unclassi System I/O .0 | | Others (foregrounds + unclassi Other .0 | |ARC0 Archival Process 0 System I/O .0 | |ARC0 Archival Process 0 User I/O .0 | |CKPT checkpoint User I/O .0 | |M MMON slave class 1 User I/O .0 | |PSP0 process spawner 0 Other .0 | | Others (foregrounds + unclassi Network .0 | | Others (foregrounds + unclassi Commit .0 | | Others (foregrounds + unclassi User I/O .0 | |TT* Redo Transport System I/O .0 | |W space management slave pool User I/O .0 | |M MMON slave class 1 System I/O .0 | | ------------------------------------------------------| | | | | |Top Process Types by CPU Used DB/Inst: DB/db1 Snaps: 331-332 | |-> This table displays top process types ordered by CPU time | | | |Proces Description CPU Time (sec) | |------ ------------------------------ -------------- | |VKTM Virtual Keeper of TiMe process 15.8 | |M MMON slave class 1 5.8 | | Others (foregrounds + unclassi 5.2 | |DIA0 diagnosibility process 0 .9 | |DBRM DataBase Resource Manager .4 | |MMNL Manageability Monitor Process .3 | |P Parallel query slave .3 | |GEN1 generic1 .2 | |W space management slave pool .2 | |CKPT checkpoint .2 | |MMON Manageability Monitor Process .2 | |PSP0 process spawner 0 .2 | |PMAN process manager .1 | |DBW0 db writer process 0 .1 | |SMCO Space Manager Process .1 | |CJQ0 Job Queue Coordinator .1 | |PMON process cleanup .1 | |TT* Redo Transport .1 | |DIAG diagnosibility process .0 | |SVCB services background monitor .0 | | ------------------------------------------------------| | | | | |SQL ordered by Elapsed Time DB/Inst: DB/db1 Snaps: 331-332 | |-> 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 104.3% of Total DB Time (s): 5 | |-> Captured PL/SQL account for 0.6% of Total DB Time (s): 5 | | | | Elapsed Elapsed Time | | Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id | |---------------- -------------- ------------- ------ ------ ------ -------------| | 1.3 40 0.03 24.3 92.3 .1 gwvsgs914uucj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT dt.tablespace_name as tablespace, dt.contents as type, dt.blo | |ck_size * dtum.used_space as bytes, dt.block_size * dtum.tablespace_size as | |max_bytes, dt.block_size * (dtum.tablespace_size - dtum.used_space) as free, | | dtum.used_percent FROM dba_tablespace_usage_metrics dtum, dba_tablespaces | | | | 1.2 40 0.03 21.8 94.2 .0 297ftus7cqvs0| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select * from ( select inst_id, sql_id, elapsed_time / 1000000 as elapsed, subst| |rb(replace(sql_text,'',' '),1,55) as sql_text from gv$sqlstats order by elapse | |d_time desc ) where rownum <= 15 | | | | 0.7 40 0.02 12.3 91.5 .0 a790m2x2yqvt7| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT name, VALUE AS total_since_startup FROM SYS.V_$SYSSTAT WHERE name = 'redo| | size' | | | | 0.7 40 0.02 12.2 87.5 .0 1wntj2ba2jfdj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, value from gv$parameter where name in ('cpu_count', 'sga_m| |ax_size', 'pga_aggregate_limit') group by inst_id, name, value | | | | 0.6 40 0.01 10.8 88.2 .0 acpqqkw9r3s1a| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, value from gv$sysstat where name in ('parse count (total)'| |, 'execute count', 'user commits', 'user rollbacks') group by inst_id, name, val| |ue | | | | 0.6 40 0.01 10.6 89.4 .0 7hpmq26yc44ts| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select metric_name cache_hit_type, value from gv$sysmetric where group_id=2 and | |metric_id in (2000,2050,2112,2110) | | | | 0.1 963 0.00 1.5 104.1 .0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 0.1 963 0.00 1.0 91.4 .0 csnp95dz2r8ss| |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 0.1 1 0.05 1.0 98.5 .0 9qrhhm7pf2ghv| |insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_numbe | |r, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, 0 per_ | |pdb, :srcdbid con_dbid, :snap_id, :instance_number, sv.hash, sv.ordinal, subs | |tr(sv.value, 1, 512), sv.isdefault, sv.ismodified from v$system_parameter2 | | | | 0.1 40 0.00 .9 65.0 .0 c6wgw00huga5s| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, wait_class, round(time_waited/100,3) time_waited_sec | |_total, con_id from gv$system_wait_class where wait_class <> 'Idle' group by | | inst_id, wait_class, con_id, round(time_waited/100,3) | | | | ------------------------------------------------------| | | | | |SQL ordered by CPU Time DB/Inst: DB/db1 Snaps: 331-332 | |-> 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 100.0% of Total CPU Time (s): 5 | |-> Captured PL/SQL account for 0.6% of Total CPU Time (s): 5 | | | | CPU CPU per Elapsed | | Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id | |---------- ------------ ---------- ------ ---------- ------ ------ -------------| | 1.2 40 0.03 23.7 1.3 92.3 .1 gwvsgs914uucj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT dt.tablespace_name as tablespace, dt.contents as type, dt.blo | |ck_size * dtum.used_space as bytes, dt.block_size * dtum.tablespace_size as | |max_bytes, dt.block_size * (dtum.tablespace_size - dtum.used_space) as free, | | dtum.used_percent FROM dba_tablespace_usage_metrics dtum, dba_tablespaces | | | | 1.1 40 0.03 21.7 1.2 94.2 .0 297ftus7cqvs0| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select * from ( select inst_id, sql_id, elapsed_time / 1000000 as elapsed, subst| |rb(replace(sql_text,'',' '),1,55) as sql_text from gv$sqlstats order by elapse | |d_time desc ) where rownum <= 15 | | | | 0.6 40 0.02 11.8 0.7 91.5 .0 a790m2x2yqvt7| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT name, VALUE AS total_since_startup FROM SYS.V_$SYSSTAT WHERE name = 'redo| | size' | | | | 0.6 40 0.01 11.2 0.7 87.5 .0 1wntj2ba2jfdj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, value from gv$parameter where name in ('cpu_count', 'sga_m| |ax_size', 'pga_aggregate_limit') group by inst_id, name, value | | | | 0.5 40 0.01 10.0 0.6 88.2 .0 acpqqkw9r3s1a| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, value from gv$sysstat where name in ('parse count (total)'| |, 'execute count', 'user commits', 'user rollbacks') group by inst_id, name, val| |ue | | | | 0.5 40 0.01 10.0 0.6 89.4 .0 7hpmq26yc44ts| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select metric_name cache_hit_type, value from gv$sysmetric where group_id=2 and | |metric_id in (2000,2050,2112,2110) | | | | 0.1 963 0.00 1.6 0.1 104.1 .0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 0.1 1 0.05 1.0 0.1 98.5 .0 9qrhhm7pf2ghv| |insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_numbe | |r, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, 0 per_ | |pdb, :srcdbid con_dbid, :snap_id, :instance_number, sv.hash, sv.ordinal, subs | |tr(sv.value, 1, 512), sv.isdefault, sv.ismodified from v$system_parameter2 | | | | 0.0 963 0.00 1.0 0.1 91.4 .0 csnp95dz2r8ss| |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 0.0 1 0.04 0.7 0.0 97.9 .0 dcbt0gjzjwwbs| |insert into wrh$_sga_target_advice (dbid, per_pdb, con_dbid, snap_id, instance | |_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) selec | |t :dbid, 0 per_pdb, :srcdbid con_dbid, :snap_id, :instance_number, SGA_SI | |ZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS FROM v$sga_target_advi | | | | ------------------------------------------------------| | | | | |SQL ordered by User I/O Wait Time DB/Inst: DB/db1 Snaps: 331-332 | |-> 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 1.6% of Total User I/O Wait Time (s): | |-> Captured PL/SQL account for 0.1% of Total User I/O Wait Time (s): | | | | User I/O UIO per Elapsed | | Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id | |---------- ------------ ---------- ------ ---------- ------ ------ -------------| | 0.0 40 0.00 1.1 1.3 92.3 .1 gwvsgs914uucj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT dt.tablespace_name as tablespace, dt.contents as type, dt.blo | |ck_size * dtum.used_space as bytes, dt.block_size * dtum.tablespace_size as | |max_bytes, dt.block_size * (dtum.tablespace_size - dtum.used_space) as free, | | dtum.used_percent FROM dba_tablespace_usage_metrics dtum, dba_tablespaces | | | | 0.0 1 0.00 0.2 0.0 94.6 1.4 bjck50zs3nc95| |insert into WRH$_SYSSTAT (dbid, per_pdb, con_dbid, snap_id, instance_number, s | |tat_id, value) select /*+ use_hash(v$sysstat) */ :dbid, 0 per_pdb, :srcdbid | |con_dbid, :snap_id, :instance_number, stat_id, value FROM v$sysstat syssta | |t WHERE (1 = 1) | | | | 0.0 1 0.00 0.1 0.0 100.1 13.0 6h3cwmunz5z8q| |select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)), max(bitand(nvl(opt| |ion$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),| |64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 and | |col# is not null group by privilege#, col#, grantee# order by col#, grantee# | | | | 0.0 1 0.00 0.1 0.0 96.2 .4 a95n8p4vpxmps| |begin prvt_hdm.execute_slave_actions; end; | | | | 0.0 1 0.00 0.1 0.0 100.5 .3 djpp498nvsryc| |insert into wrh$_parameter (dbid, per_pdb, con_dbid, snap_id, instance_number, | | parameter_hash, value, isdefault, ismodified) select :dbid, 0 per_pdb, :srcd | |bid con_dbid, :snap_id, :instance_number, hash, substr(value, 1, 512), isdefau | |lt, ismodified from v$system_parameter sp | | | | 0.0 1 0.00 0.0 0.0 .0 5.3 a4n4ayr88dbhy| |select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),max(bitand(nvl| |(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$| |,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 | |group by grantee#,privilege#,nvl(col#,0) order by grantee# | | | | 0.0 1 0.00 0.0 0.0 99.5 .1 drktaf71uygnb| |BEGIN sys.prvt_hdm.auto_execute( db_id => :bind_dbid, | | inst_id => :bind_inst, end_snap => :bind_snap, t | |ime_left_in_secs => :bind_time); END; | | | | 0.0 82 0.00 0.0 0.0 99.1 .2 f7xnvp44nukp7| |insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin | |_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2 | |,:bind3,:step_id) | | | | 0.0 3 0.00 0.0 0.0 98.6 .0 062savj8zgzut| |UPDATE sys.wri$_adv_parameters SET datatype = :1,value = :2, flags = :3, descrip| |tion = :4 WHERE task_id = :5 AND name = :6 | | | | 0.0 1 0.00 0.0 0.0 84.2 .0 0fr8zhn4ymu3v| |select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtyp | |e$ where obj# = :1 order by intcol# asc | | | | ------------------------------------------------------| | | | | |SQL ordered by Gets DB/Inst: DB/db1 Snaps: 331-332 | |-> 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: 20,356 | |-> Captured SQL account for 73.2% of Total | | | | Buffer Gets Elapsed | | Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id | |----------- ----------- ------------ ------ ---------- ----- ----- -------------| | 4,991 1 4,991.0 24.5 0.0 94.6 1.4 bjck50zs3nc95| |insert into WRH$_SYSSTAT (dbid, per_pdb, con_dbid, snap_id, instance_number, s | |tat_id, value) select /*+ use_hash(v$sysstat) */ :dbid, 0 per_pdb, :srcdbid | |con_dbid, :snap_id, :instance_number, stat_id, value FROM v$sysstat syssta | |t WHERE (1 = 1) | | | | 4,440 40 111.0 21.8 1.3 92.3 .1 gwvsgs914uucj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT dt.tablespace_name as tablespace, dt.contents as type, dt.blo | |ck_size * dtum.used_space as bytes, dt.block_size * dtum.tablespace_size as | |max_bytes, dt.block_size * (dtum.tablespace_size - dtum.used_space) as free, | | dtum.used_percent FROM dba_tablespace_usage_metrics dtum, dba_tablespaces | | | | 1,123 963 1.2 5.5 0.1 104.1 0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 1,123 963 1.2 5.5 0.1 91.4 0 csnp95dz2r8ss| |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 1,113 1 1,113.0 5.5 0.0 96.2 .4 a95n8p4vpxmps| |begin prvt_hdm.execute_slave_actions; end; | | | | 1,103 1 1,103.0 5.4 0.0 99.5 .1 drktaf71uygnb| |BEGIN sys.prvt_hdm.auto_execute( db_id => :bind_dbid, | | inst_id => :bind_inst, end_snap => :bind_snap, t | |ime_left_in_secs => :bind_time); END; | | | | 751 1 751.0 3.7 0.0 98.2 0 3aa3xb3t0a9hb| | UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject | |_name, tablespace_name, object_type, partition_type, index_type, base_ob | |j#, base_object_name, base_object_owner) = (SELECT snap_id + 1, | | nvl(ownername_kewrseg, owner), nvl(objname_kewrseg, | | | | 535 1 535.0 2.6 0.0 100.5 .3 djpp498nvsryc| |insert into wrh$_parameter (dbid, per_pdb, con_dbid, snap_id, instance_number, | | parameter_hash, value, isdefault, ismodified) select :dbid, 0 per_pdb, :srcd | |bid con_dbid, :snap_id, :instance_number, hash, substr(value, 1, 512), isdefau | |lt, ismodified from v$system_parameter sp | | | | 400 200 2.0 2.0 0.0 100.2 0 89w8y2pgn25yd| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select ts# from ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048 | | | | 353 1 353.0 1.7 0.0 91.9 0 9x2prazfz86dz| | select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, t.obj# from tab$ t, seg$ s | |where bitand(s.spare1, 4503599627370496) = 4503599627370496 and bitand(s.spare1,| | 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block | |# UNION select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, tab.obj# from tabpa | | | | 343 82 4.2 1.7 0.0 99.1 .2 f7xnvp44nukp7| |insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin | |_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2 | |,:bind3,:step_id) | | | | ------------------------------------------------------| | | | | |SQL ordered by Reads DB/Inst: DB/db1 Snaps: 331-332 | |-> %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: 118 | |-> Captured SQL account for 28.8% of Total | | | | Physical Reads Elapsed | | Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id | |----------- ----------- ---------- ------ ---------- ------ ------ -------------| | 24 1 24.0 20.3 0.0 94.6 1.4 bjck50zs3nc95| |insert into WRH$_SYSSTAT (dbid, per_pdb, con_dbid, snap_id, instance_number, s | |tat_id, value) select /*+ use_hash(v$sysstat) */ :dbid, 0 per_pdb, :srcdbid | |con_dbid, :snap_id, :instance_number, stat_id, value FROM v$sysstat syssta | |t WHERE (1 = 1) | | | | 7 1 7.0 5.9 0.0 100.5 .3 djpp498nvsryc| |insert into wrh$_parameter (dbid, per_pdb, con_dbid, snap_id, instance_number, | | parameter_hash, value, isdefault, ismodified) select :dbid, 0 per_pdb, :srcd | |bid con_dbid, :snap_id, :instance_number, hash, substr(value, 1, 512), isdefau | |lt, ismodified from v$system_parameter sp | | | | 1 1 1.0 0.8 0.0 100.1 13.0 6h3cwmunz5z8q| |select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)), max(bitand(nvl(opt| |ion$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),| |64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 and | |col# is not null group by privilege#, col#, grantee# order by col#, grantee# | | | | 1 1 1.0 0.8 0.0 .0 5.3 a4n4ayr88dbhy| |select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),max(bitand(nvl| |(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$| |,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 | |group by grantee#,privilege#,nvl(col#,0) order by grantee# | | | | 1 1 1.0 0.8 0.0 96.2 .4 a95n8p4vpxmps| |begin prvt_hdm.execute_slave_actions; end; | | | | 1 1 1.0 0.8 0.0 99.5 .1 drktaf71uygnb| |BEGIN sys.prvt_hdm.auto_execute( db_id => :bind_dbid, | | inst_id => :bind_inst, end_snap => :bind_snap, t | |ime_left_in_secs => :bind_time); END; | | | | 1 82 0.0 0.8 0.0 99.1 .2 f7xnvp44nukp7| |insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin | |_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2 | |,:bind3,:step_id) | | | | 0 3 0.0 0.0 0.0 98.6 .0 062savj8zgzut| |UPDATE sys.wri$_adv_parameters SET datatype = :1,value = :2, flags = :3, descrip| |tion = :4 WHERE task_id = :5 AND name = :6 | | | | 0 1 0.0 0.0 0.0 84.2 .0 0fr8zhn4ymu3v| |select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtyp | |e$ where obj# = :1 order by intcol# asc | | | | 0 10 0.0 0.0 0.0 96.4 .0 0kkhhb2w93cx0| |update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e| |xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod| |e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:| |17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 | | | | ------------------------------------------------------| | | | | |SQL ordered by Physical Reads (UnOptimized) DB/Inst: DB/db1 Snaps: 331-332 | |-> UnOptimized Read Reqs = Physical Read Reqs - | | (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile) | |-> %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: 118 | |-> Captured SQL account for 2.0E+03% of Total | |-> Total UnOptimized Read Requests: 118 | |-> Captured SQL account for 2.0E+03% of Total | |-> Total Optimized Read Requests: 1 | |-> Captured SQL account for 0.0% of Total | | | |UnOptimized Physical UnOptimized | | Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id | |----------- ----------- ---------- ------------ ------ ------ ------------- | | 1,680 1,680 40 42.0 0.0 1.E+03 gwvsgs914uucj | |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT dt.tablespace_name as tablespace, dt.contents as type, dt.blo | |ck_size * dtum.used_space as bytes, dt.block_size * dtum.tablespace_size as | |max_bytes, dt.block_size * (dtum.tablespace_size - dtum.used_space) as free, | | dtum.used_percent FROM dba_tablespace_usage_metrics dtum, dba_tablespaces | | | | 320 320 40 8.0 0.0 271.2 3nph4hb9vqcsr | |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, total_mb*1024*1024 as total, free_mb*1024*1024 as free fro| |m gv$asm_diskgroup_stat where exists (select 1 from gv$datafile where name like | |'+%') and inst_id = (select max(inst_id) from gv$instance) group by inst_id, nam| |e, total_mb, free_mb | | | | 280 280 40 7.0 0.0 237.3 gu39816m1d37k | |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT inst_id, platform_name, 1 as value FROM gv$database GROUP BY inst_id, pla| |tform_name | | | | 24 24 1 24.0 0.0 20.3 bjck50zs3nc95 | |insert into WRH$_SYSSTAT (dbid, per_pdb, con_dbid, snap_id, instance_number, s | |tat_id, value) select /*+ use_hash(v$sysstat) */ :dbid, 0 per_pdb, :srcdbid | |con_dbid, :snap_id, :instance_number, stat_id, value FROM v$sysstat syssta | |t WHERE (1 = 1) | | | | 7 7 1 7.0 0.0 5.9 djpp498nvsryc | |insert into wrh$_parameter (dbid, per_pdb, con_dbid, snap_id, instance_number, | | parameter_hash, value, isdefault, ismodified) select :dbid, 0 per_pdb, :srcd | |bid con_dbid, :snap_id, :instance_number, hash, substr(value, 1, 512), isdefau | |lt, ismodified from v$system_parameter sp | | | | 1 1 1 1.0 0.0 0.8 6h3cwmunz5z8q | |select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)), max(bitand(nvl(opt| |ion$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),| |64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 and | |col# is not null group by privilege#, col#, grantee# order by col#, grantee# | | | | 1 1 1 1.0 0.0 0.8 a4n4ayr88dbhy | |select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),max(bitand(nvl| |(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$| |,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 | |group by grantee#,privilege#,nvl(col#,0) order by grantee# | | | | 1 1 1 1.0 0.0 0.8 a95n8p4vpxmps | |begin prvt_hdm.execute_slave_actions; end; | | | | 1 1 1 1.0 0.0 0.8 drktaf71uygnb | |BEGIN sys.prvt_hdm.auto_execute( db_id => :bind_dbid, | | inst_id => :bind_inst, end_snap => :bind_snap, t | |ime_left_in_secs => :bind_time); END; | | | | 1 1 82 0.0 0.0 0.8 f7xnvp44nukp7 | |insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin | |_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2 | |,:bind3,:step_id) | | | | ------------------------------------------------------| | | | | |SQL ordered by Executions DB/Inst: DB/db1 Snaps: 331-332 | |-> %CPU - CPU Time as a percentage of Elapsed Time | |-> %IO - User I/O Time as a percentage of Elapsed Time | |-> Total Executions: 3,397 | |-> Captured SQL account for 87.4% of Total | | | | Elapsed | | Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id | |------------ --------------- -------------- ---------- ----- ----- -------------| | 963 963 1.0 0.1 104.1 0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 963 0 0.0 0.1 91.4 0 csnp95dz2r8ss| |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 200 200 1.0 0.0 100.2 0 89w8y2pgn25yd| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select ts# from ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048 | | | | 82 82 1.0 0.0 99.1 .2 f7xnvp44nukp7| |insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin | |_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2 | |,:bind3,:step_id) | | | | 40 120 3.0 0.0 72.8 0 0qxtp4g35g6wu| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, status, type, count(*) as value from gv$session group by inst_id| |, status, type | | | | 40 120 3.0 0.7 87.5 0 1wntj2ba2jfdj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, value from gv$parameter where name in ('cpu_count', 'sga_m| |ax_size', 'pga_aggregate_limit') group by inst_id, name, value | | | | 40 600 15.0 1.2 94.2 0 297ftus7cqvs0| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select * from ( select inst_id, sql_id, elapsed_time / 1000000 as elapsed, subst| |rb(replace(sql_text,'',' '),1,55) as sql_text from gv$sqlstats order by elapse | |d_time desc ) where rownum <= 15 | | | | 40 40 1.0 0.0 77.8 0 35pqyw7uq9kfh| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, count(*) as count from gv$process group by inst_id | | | | 40 0 0.0 0.0 91 0 3nph4hb9vqcsr| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, total_mb*1024*1024 as total, free_mb*1024*1024 as free fro| |m gv$asm_diskgroup_stat where exists (select 1 from gv$datafile where name like | |'+%') and inst_id = (select max(inst_id) from gv$instance) group by inst_id, nam| |e, total_mb, free_mb | | | | 40 1,080 27.0 0.0 72.5 0 57yy15zq3vzdb| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, resource_name, current_utilization, case when trim(limit_value) | |like 'UNLIMITED' then '-1' else trim(limit_value) end as limit_value from gv$res| |ource_limit group by inst_id, resource_name, current_utilization, limit_value | | | | 40 160 4.0 0.6 89.4 0 7hpmq26yc44ts| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select metric_name cache_hit_type, value from gv$sysmetric where group_id=2 and | |metric_id in (2000,2050,2112,2110) | | | | 40 40 1.0 0.0 99.9 0 9r2mwyj6k0j9c| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select version as db_version , 1 as value from v$instance | | | | 40 40 1.0 0.7 91.5 0 a790m2x2yqvt7| |Module: oracledb_exporter@common-server (TNS V1-V3) | | | |SQL ordered by Executions DB/Inst: DB/db1 Snaps: 331-332 | |-> %CPU - CPU Time as a percentage of Elapsed Time | |-> %IO - User I/O Time as a percentage of Elapsed Time | |-> Total Executions: 3,397 | |-> Captured SQL account for 87.4% of Total | | | | Elapsed | | Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id | |------------ --------------- -------------- ---------- ----- ----- -------------| |SELECT name, VALUE AS total_since_startup FROM SYS.V_$SYSSTAT WHERE name = 'redo| | size' | | | | 40 160 4.0 0.6 88.2 0 acpqqkw9r3s1a| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, name, value from gv$sysstat where name in ('parse count (total)'| |, 'execute count', 'user commits', 'user rollbacks') group by inst_id, name, val| |ue | | | | 40 360 9.0 0.1 65 0 c6wgw00huga5s| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, wait_class, round(time_waited/100,3) time_waited_sec | |_total, con_id from gv$system_wait_class where wait_class <> 'Idle' group by | | inst_id, wait_class, con_id, round(time_waited/100,3) | | | | 40 40 1.0 0.0 68.6 0 gu39816m1d37k| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT inst_id, platform_name, 1 as value FROM gv$database GROUP BY inst_id, pla| |tform_name | | | | 40 200 5.0 1.3 92.3 .1 gwvsgs914uucj| |Module: oracledb_exporter@common-server (TNS V1-V3) | |SELECT dt.tablespace_name as tablespace, dt.contents as type, dt.blo | |ck_size * dtum.used_space as bytes, dt.block_size * dtum.tablespace_size as | |max_bytes, dt.block_size * (dtum.tablespace_size - dtum.used_space) as free, | | dtum.used_percent FROM dba_tablespace_usage_metrics dtum, dba_tablespaces | | | | ------------------------------------------------------| | | | | |SQL ordered by Parse Calls DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Parse Calls: 2,610 | |-> Captured SQL account for 91.4% of Total | | | | % Total | | Parse Calls Executions Parses SQL Id | |------------ ------------ --------- ------------- | | 963 963 36.90 6xvp6nxs4a9n4 | |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 963 963 36.90 csnp95dz2r8ss | |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 200 200 7.66 89w8y2pgn25yd | |Module: oracledb_exporter@common-server (TNS V1-V3) | |select ts# from ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048 | | | | 82 82 3.14 f7xnvp44nukp7 | |insert into wrm$_snapshot_details (snap_id,dbid,instance_number,table_id,begin | |_time,end_time,step_id) values (:snap_id,:dbid,:instance_number,:bind1,:bind2 | |,:bind3,:step_id) | | | | 20 20 0.77 gjaap3w3qbf8c | |select count(*) from ilmobj$ where rownum = 1 | | | | 19 19 0.73 fkc81h2686aqc | |select pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.o | |bj# and ip.obj# = :oid | | | | 17 17 0.65 fs4p95w7yg25b | |select pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.o | |bj# and tp.obj# = :oid | | | | 15 15 0.57 6n2qqv1brfhpp | |select ind.type#, ind.property, base_obj.obj#, base_owner.name, base_obj.name | | from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# | | = :oid and ind.dataobj# = :doid and ind.bo# = base_obj | |.obj# and base_obj.owner# = base_owner.user# | | | | 10 10 0.38 7am4w4pp3nwtm | |select count(*) from undo$ | | | | 10 10 0.38 c9umxngkc3byq | |select sql_id, sql_exec_id, dbop_name, dbop_exec_id, to_char(sql_exec_start, 'mm| |:dd:yyyy hh24:mi:ss'), to_char(first_refresh_time, 'mm:dd:yyyy hh24:mi:ss'), to_| |char(last_refresh_time, 'mm:dd:yyyy hh24:mi:ss'), elapsed_time, px_servers_alloc| |ated, sid, session_serial#, key, con_id from v$sql_monitor where report_id = 0 a| | | | ------------------------------------------------------| | | | | |SQL ordered by Sharable Memory DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |SQL ordered by Version Count DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Key Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |db block changes 9,457 15.8 675.5| |execute count 3,397 5.7 242.6| |logons cumulative 2 0.0 0.1| |opened cursors cumulative 2,811 4.7 200.8| |parse count (total) 2,610 4.4 186.4| |parse time elapsed 3 0.0 0.2| |physical reads 118 0.2 8.4| |physical writes 739 1.2 52.8| |redo size 3,054,016 5,085.1 218,144.0| |session cursor cache hits 2,547 4.2 181.9| |session logical reads 20,356 33.9 1,454.0| |user calls 658 1.1 47.0| |user commits 14 0.0 1.0| |workarea executions - optimal 869 1.5 62.1| | ------------------------------------------------------| | | | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |ASSM bg: segment fix monitor 1 0.0 0.1| |ASSM cbk:blocks examined 384 0.6 27.4| |ASSM cbk:blocks marked full 114 0.2 8.1| |ASSM gsp:L1 bitmaps examined 298 0.5 21.3| |ASSM gsp:L2 bitmap full 2 0.0 0.1| |ASSM gsp:L2 bitmaps examined 155 0.3 11.1| |ASSM gsp:Search all 8 0.0 0.6| |ASSM gsp:Search hint 13 0.0 0.9| |ASSM gsp:Search steal 8 0.0 0.6| |ASSM gsp:bump HWM 8 0.0 0.6| |ASSM gsp:get free block 272 0.5 19.4| |ASSM gsp:get free data block 213 0.4 15.2| |ASSM gsp:get free index block 59 0.1 4.2| |ASSM gsp:good hint 268 0.5 19.1| |ASSM gsp:reject db 0 0.0 0.0| |ASSM rsv:fill reserve 0 0.0 0.0| |ASSM wasted db state change 2 0.0 0.1| |Batched IO (bound) vector count 0 0.0 0.0| |Batched IO block miss count 0 0.0 0.0| |Batched IO buffer defrag count 0 0.0 0.0| |Batched IO double miss count 0 0.0 0.0| |Batched IO same unit count 0 0.0 0.0| |Batched IO single block count 0 0.0 0.0| |Batched IO vector block count 0 0.0 0.0| |Batched IO vector read count 0 0.0 0.0| |Block Cleanout Optim referenced 23 0.0 1.6| |CCursor + sql area evicted 1 0.0 0.1| |CPU used by this session 1,172 2.0 83.7| |CPU used when call started 504 0.8 36.0| |CR blocks created 18 0.0 1.3| |Cached Commit SCN referenced 0 0.0 0.0| |Client Advertised Receive Window 7 0.0 0.5| |Client Advertised Send Window 7 0.0 0.5| |Client Data Segments In 574 1.0 41.0| |Client Data Segments Out 576 1.0 41.1| |Client Path Maximum Transmission 1,500 2.5 107.1| |Client Send Congestion Window 10 0.0 0.7| |Client Time (usec) Busy Sending 5,472,000 9,111.2 390,857.1| |Client Time (usec) Round Trip Ti 7,688 12.8 549.1| |Client Time (usec) Round Trip Ti 3,883 6.5 277.4| |Client Total Bytes Acked 19,734 32.9 1,409.6| |Client Total Bytes Received 213,282 355.1 15,234.4| |DBWR checkpoint buffers written 734 1.2 52.4| |DBWR checkpoints 1 0.0 0.1| |DBWR object drop buffers written 0 0.0 0.0| |DBWR thread checkpoint buffers w 0 0.0 0.0| |DBWR transaction table writes 10 0.0 0.7| |DBWR undo block writes 210 0.4 15.0| |DML statements retried 0 0.0 0.0| |Effective IO time 0 0.0 0.0| |HSC Heap Segment Block Changes 668 1.1 47.7| |Heap Segment Array Deletes 0 0.0 0.0| |Heap Segment Array Inserts 139 0.2 9.9| |Heap Segment Array Updates 1 0.0 0.1| |Heatmap BlkLevel Flushed 0 0.0 0.0| |Heatmap BlkLevel Flushed to BF 0 0.0 0.0| |Heatmap BlkLevel Ranges Flushed 0 0.0 0.0| |Heatmap Blklevel Flush Task Coun 0 0.0 0.0| |IMU Flushes 0 0.0 0.0| |IMU Redo allocation size 0 0.0 0.0| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |IMU commits 0 0.0 0.0| |IMU contention 0 0.0 0.0| |IMU ktichg flush 0 0.0 0.0| |IMU pool not allocated 135 0.2 9.6| |IMU recursive-transaction flush 0 0.0 0.0| |IMU undo allocation size 0 0.0 0.0| |IMU- failed to get a private str 135 0.2 9.6| |KTFB alloc req 8 0.0 0.6| |KTFB alloc space (block) 2,490,368 4,146.6 177,883.4| |KTFB alloc time (ms) 224 0.4 16.0| |KTFB apply req 0 0.0 0.0| |KTFB apply time (ms) 0 0.0 0.0| |KTFB commit req 0 0.0 0.0| |KTFB commit time (ms) 0 0.0 0.0| |KTFB free req 0 0.0 0.0| |KTFB free space (block) 0 0.0 0.0| |KTFB free time (ms) 0 0.0 0.0| |LOB table id lookup cache misses 0 0.0 0.0| |Number of read IOs issued 0 0.0 0.0| |Requests to/from client 642 1.1 45.9| |SMON posted for undo segment shr 0 0.0 0.0| |SQL*Net roundtrips to/from clien 642 1.1 45.9| |TBS Extension: bytes extended 0 0.0 0.0| |TBS Extension: files extended 0 0.0 0.0| |TBS Extension: tasks created 0 0.0 0.0| |TBS Extension: tasks executed 0 0.0 0.0| |active txn count during cleanout 146 0.2 10.4| |auto extends on undo tablespace 0 0.0 0.0| |background checkpoints completed 1 0.0 0.1| |background checkpoints started 1 0.0 0.1| |background timeouts 3,754 6.3 268.1| |blocks cleaned out using minact 225 0.4 16.1| |branch node splits 1 0.0 0.1| |buffer is not pinned count 6,138 10.2 438.4| |buffer is pinned count 5,244 8.7 374.6| |bytes received via SQL*Net from 21,290 35.5 1,520.7| |bytes sent via SQL*Net to client 237,662 395.7 16,975.9| |calls to get snapshot scn: kcmgs 3,620 6.0 258.6| |calls to kcmgas 426 0.7 30.4| |calls to kcmgcs 1,760 2.9 125.7| |cell physical IO interconnect by 94,009,856 156,532.3 6,714,989.7| |change write time 2 0.0 0.1| |cleanout - number of ktugct call 153 0.3 10.9| |cleanouts and rollbacks - consis 0 0.0 0.0| |cleanouts only - consistent read 5 0.0 0.4| |cluster key scan block gets 86 0.1 6.1| |cluster key scans 80 0.1 5.7| |commit batch/immediate performed 0 0.0 0.0| |commit batch/immediate requested 0 0.0 0.0| |commit cleanout failures: block 0 0.0 0.0| |commit cleanout failures: buffer 0 0.0 0.0| |commit cleanout failures: callba 18 0.0 1.3| |commit cleanout failures: cannot 0 0.0 0.0| |commit cleanouts 518 0.9 37.0| |commit cleanouts successfully co 500 0.8 35.7| |commit immediate performed 0 0.0 0.0| |commit immediate requested 0 0.0 0.0| |commit txn count during cleanout 65 0.1 4.6| |consistent changes 177 0.3 12.6| |consistent gets 8,404 14.0 600.3| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |consistent gets direct 0 0.0 0.0| |consistent gets examination 1,424 2.4 101.7| |consistent gets examination (fas 1,338 2.2 95.6| |consistent gets from cache 8,404 14.0 600.3| |consistent gets pin 6,980 11.6 498.6| |consistent gets pin (fastpath) 6,897 11.5 492.6| |cursor authentications 0 0.0 0.0| |cursor reload failures 0 0.0 0.0| |data blocks consistent reads - u 35 0.1 2.5| |db block changes 9,457 15.8 675.5| |db block gets 11,952 19.9 853.7| |db block gets direct 0 0.0 0.0| |db block gets from cache 11,952 19.9 853.7| |db block gets from cache (fastpa 8,342 13.9 595.9| |deferred (CURRENT) block cleanou 293 0.5 20.9| |dirty buffers inspected 0 0.0 0.0| |enqueue conversions 125 0.2 8.9| |enqueue releases 6,907 11.5 493.4| |enqueue requests 6,907 11.5 493.4| |enqueue timeouts 0 0.0 0.0| |enqueue waits 0 0.0 0.0| |execute count 3,397 5.7 242.6| |failed probes on index block rec 0 0.0 0.0| |file io service time 0 0.0 0.0| |free buffer inspected 0 0.0 0.0| |free buffer requested 444 0.7 31.7| |heap block compress 5 0.0 0.4| |hot buffers moved to head of LRU 0 0.0 0.0| |immediate (CR) block cleanout ap 5 0.0 0.4| |immediate (CURRENT) block cleano 162 0.3 11.6| |index crx upgrade (positioned) 0 0.0 0.0| |index fast full scans (full) 0 0.0 0.0| |index fetch by key 1,130 1.9 80.7| |index range scans 2,149 3.6 153.5| |index reclamation/extension swit 0 0.0 0.0| |leaf node 90-10 splits 6 0.0 0.4| |leaf node splits 58 0.1 4.1| |lob reads 59 0.1 4.2| |lob writes 57 0.1 4.1| |lob writes unaligned 57 0.1 4.1| |logical read bytes from cache 166,756,352 277,659.8 11,911,168.0| |logons cumulative 2 0.0 0.1| |max cf enq hold time 4 0.0 0.3| |messages received 502 0.8 35.9| |messages sent 502 0.8 35.9| |min active SCN optimization appl 0 0.0 0.0| |no buffer to keep pinned count 0 0.0 0.0| |no work - consistent read gets 3,889 6.5 277.8| |non-idle wait count 6,656 11.1 475.4| |opened cursors cumulative 2,811 4.7 200.8| |parse count (describe) 0 0.0 0.0| |parse count (failures) 0 0.0 0.0| |parse count (hard) 2 0.0 0.1| |parse count (total) 2,610 4.4 186.4| |parse time cpu 5 0.0 0.4| |parse time elapsed 3 0.0 0.2| |physical read IO requests 118 0.2 8.4| |physical read bytes 966,656 1,609.5 69,046.9| |physical read total IO requests 3,807 6.3 271.9| |physical read total bytes 69,766,144 116,165.0 4,983,296.0| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |physical read total multi block 9 0.0 0.6| |physical reads 118 0.2 8.4| |physical reads cache 118 0.2 8.4| |physical reads cache prefetch 0 0.0 0.0| |physical reads direct 0 0.0 0.0| |physical reads direct (lob) 0 0.0 0.0| |physical reads prefetch warmup 0 0.0 0.0| |physical write IO requests 463 0.8 33.1| |physical write bytes 6,053,888 10,080.1 432,420.6| |physical write total IO requests 1,038 1.7 74.1| |physical write total bytes 24,243,712 40,367.3 1,731,693.7| |physical write total multi block 21 0.0 1.5| |physical writes 739 1.2 52.8| |physical writes direct 5 0.0 0.4| |physical writes direct (lob) 5 0.0 0.4| |physical writes from cache 734 1.2 52.4| |physical writes non checkpoint 280 0.5 20.0| |pinned buffers inspected 0 0.0 0.0| |pinned cursors current 1 0.0 0.1| |prefetched blocks aged out befor 0 0.0 0.0| |process last non-idle time 600 1.0 42.9| |recursive calls 10,767 17.9 769.1| |recursive cpu usage 63 0.1 4.5| |redo KB read 6,428 10.7 459.1| |redo blocks checksummed by FG (e 3,000 5.0 214.3| |redo blocks written 5,948 9.9 424.9| |redo blocks written (group 0) 0 0.0 0.0| |redo blocks written (group 1) 0 0.0 0.0| |redo buffer allocation retries 2 0.0 0.1| |redo entries 5,312 8.8 379.4| |redo log space requests 2 0.0 0.1| |redo ordering marks 0 0.0 0.0| |redo size 3,054,016 5,085.1 218,144.0| |redo size for direct writes 0 0.0 0.0| |redo subscn max counts 6 0.0 0.4| |redo synch long waits 0 0.0 0.0| |redo synch time 0 0.0 0.0| |redo synch time (usec) 3,065 5.1 218.9| |redo synch time overhead (usec) 78 0.1 5.6| |redo synch time overhead count ( 1 0.0 0.1| |redo synch time overhead count ( 0 0.0 0.0| |redo synch writes 1 0.0 0.1| |redo wastage 11,924 19.9 851.7| |redo write active strands 40 0.1 2.9| |redo write finish time 150,715 251.0 10,765.4| |redo write gather time 787 1.3 56.2| |redo write info find 1 0.0 0.1| |redo write schedule time 933 1.6 66.6| |redo write size count ( 4KB) 23 0.0 1.6| |redo write size count ( 8KB) 5 0.0 0.4| |redo write size count ( 16KB) 1 0.0 0.1| |redo write size count ( 32KB) 2 0.0 0.1| |redo write size count ( 128KB) 4 0.0 0.3| |redo write size count ( 256KB) 3 0.0 0.2| |redo write size count ( 512KB) 1 0.0 0.1| |redo write size count (1024KB) 0 0.0 0.0| |redo write size count (inf) 1 0.0 0.1| |redo write time 15 0.0 1.1| |redo write time (usec) 150,812 251.1 10,772.3| |redo write total time 151,470 252.2 10,819.3| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |redo write worker delay (usec) 0 0.0 0.0| |redo write worker delay count 0 0.0 0.0| |redo writes 40 0.1 2.9| |redo writes (group 0) 0 0.0 0.0| |redo writes (group 1) 0 0.0 0.0| |redo writes adaptive all 40 0.1 2.9| |redo writes adaptive worker 0 0.0 0.0| |remote Oradebug requests 0 0.0 0.0| |rollback changes - undo records 0 0.0 0.0| |rollbacks only - consistent read 18 0.0 1.3| |root node splits 0 0.0 0.0| |rows fetched via callback 714 1.2 51.0| |securefile allocation bytes 40,960 68.2 2,925.7| |securefile allocation chunks 1 0.0 0.1| |securefile bytes non-transformed 46,052 76.7 3,289.4| |securefile direct read bytes 0 0.0 0.0| |securefile direct read ops 0 0.0 0.0| |securefile direct write bytes 40,960 68.2 2,925.7| |securefile direct write ops 1 0.0 0.1| |securefile number of non-transfo 13 0.0 0.9| |segment cfs allocations 0 0.0 0.0| |segment chunks allocation from d 1 0.0 0.1| |segment dispenser allocations 1 0.0 0.1| |segment dispenser load empty 0 0.0 0.0| |segment dispenser load tasks 0 0.0 0.0| |segment prealloc bytes 0 0.0 0.0| |segment prealloc ops 1 0.0 0.1| |segment prealloc tasks 0 0.0 0.0| |segment prealloc time (ms) 13 0.0 0.9| |segment prealloc ufs2cfs bytes 0 0.0 0.0| |segment total chunk allocation 0 0.0 0.0| |session connect time 0 0.0 0.0| |session cursor cache hits 2,547 4.2 181.9| |session logical reads 20,356 33.9 1,454.0| |shared hash latch upgrades - no 81 0.1 5.8| |shared io pool buffer get succes 1 0.0 0.1| |sorts (memory) 891 1.5 63.6| |sorts (rows) 81,799 136.2 5,842.8| |sql area evicted 1 0.0 0.1| |sql area purged 1 0.0 0.1| |summed dirty queue length 0 0.0 0.0| |switch current caused by our pin 13 0.0 0.9| |switch current to new buffer 13 0.0 0.9| |table fetch by rowid 3,925 6.5 280.4| |table fetch continued row 0 0.0 0.0| |table scan blocks gotten 2,349 3.9 167.8| |table scan disk non-IMC rows got 116,678 194.3 8,334.1| |table scan rows gotten 116,678 194.3 8,334.1| |table scans (direct read) 0 0.0 0.0| |table scans (long tables) 0 0.0 0.0| |table scans (short tables) 296 0.5 21.1| |temp space allocated (bytes) 0 0.0 0.0| |total cf enq hold time 487 0.8 34.8| |total number of cf enq holders 214 0.4 15.3| |total number of times SMON poste 0 0.0 0.0| |transaction rollbacks 0 0.0 0.0| |transaction tables consistent re 0 0.0 0.0| |transaction tables consistent re 0 0.0 0.0| |undo change vector size 1,050,136 1,748.5 75,009.7| |user calls 658 1.1 47.0| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |user commits 14 0.0 1.0| |user logons cumulative 1 0.0 0.1| |user logouts cumulative 1 0.0 0.1| |workarea executions - optimal 869 1.5 62.1| |write clones created in backgrou 0 0.0 0.0| |write clones created in foregrou 0 0.0 0.0| | ------------------------------------------------------| | | | | |Instance Activity Stats - Absolute Values DB/Inst: DB/db1 Snaps: 331-332 | |-> Statistics with absolute values (should not be diffed) | | | |Statistic Begin Value End Value | |-------------------------------- --------------- --------------- | |logons current 65 65 | |opened cursors current 256 256 | |session cursor cache count 14,520 14,483 | |session pga memory 416,772,408 416,444,728 | |session pga memory max 595,867,928 596,785,432 | |session uga memory 446,132,696 446,791,960 | |session uga memory max 2,356,894,184 2,361,446,096 | | ------------------------------------------------------| | | |Instance Activity Stats - Thread Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> Statistics identified by '(derived)' come from sources other than SYSSTAT | | | |Statistic Total per Hour | |-------------------------------- ------------------ --------- | |log switches (derived) 1 5.99 | | ------------------------------------------------------| | | |IOStat by Function summary DB/Inst: DB/db1 Snaps: 331-332 | |-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 | | other columns suffixed with K,M,G,T,P are in multiples of 1000 | |-> ordered by (Data Read + Write) desc | | | | Reads: Reqs Data Writes: Reqs Data Waits: Avg | |Function Name Data per sec per sec Data per sec per sec Count Time | |--------------- ------- ------- ------- ------- ------- ------- ------- --------| |Others 58M 6.1 .097M 8M 0.8 .013M 4147 489.55us| |DBWR 0M 0.0 0M 6M 0.8 .01M 462 2.16us| |LGWR 0M 0.0 0M 2M 0.1 .003M 78 1.69ms| |Buffer Cache Re 1M 0.2 .002M 0M 0.0 0M 113 71.52us| |Direct Writes 0M 0.0 0M 0M 0.0 0M 1 .00ns| |TOTAL: 59M 6.3 .098M 16M 1.7 .027M 4801 452.27us| | ------------------------------------------------------| | | |IOStat by Filetype summary DB/Inst: DB/db1 Snaps: 331-332 | |-> '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 | |-> Ordered by (Data Read + Write) desc | | | | Reads: Reqs Data Writes: Reqs Data Small Large| |Filetype Name Data per sec per sec Data per sec per sec Read Read| |-------------- ------- ------- ------- ------- ------- ------- -------- --------| |Control File 57M 6.1 .095M 7M 0.8 .012M 549.75ns | |Data File 1M 0.2 .002M 5M 0.8 .008M 24.39us | |Log File 0M 0.0 0M 2M 0.1 .003M | |TOTAL: 58M 6.3 .097M 14M 1.7 .023M 1.33us | | ------------------------------------------------------| | | |IOStat by Function/Filetype summary DB/Inst: DB/db1 Snaps: 331-332 | |-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 | | other columns suffixed with K,M,G,T,P are in multiples of 1000 | |-> Ordered by (Data Read + Write) desc for each function | | | | Reads: Reqs Data Writes: Reqs Data Waits: Avg | | Data per sec per sec Data per sec per sec Count Time | | ------- ------- ------- ------- ------- ------- ------- ---------- | |Others | | 58M 6.1 .097M 8M 0.8 .013M 3653 22.49us | | Others (Control File) | | 57M 6.1 .095M 8M 0.8 .013M 3638 17.35us | | Others (Data File) | | 1M 0.0 .002M 0M 0.0 0M 15 1.33ms | | DBWR (Data File) | | 0M 0.0 0M 6M 0.8 .01M 0 | |DBWR | | 0M 0.0 0M 6M 0.8 .01M 0 | | LGWR (Log File) | | 0M 0.0 0M 2M 0.1 .003M 0 | |LGWR | | 0M 0.0 0M 2M 0.1 .003M 0 | | Buffer Cache Reads (Data File) | | 1M 0.2 .002M 0M 0.0 0M 113 71.52us | |Buffer Cache Reads | | 1M 0.2 .002M 0M 0.0 0M 113 71.52us | |TOTAL: | | 59M 6.3 .098M 16M 1.7 .027M 3766 23.68us | | ------------------------------------------------------| | | | | |Tablespace IO Stats DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |File IO Stats DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Buffer Pool Statistics DB/Inst: DB/db1 Snaps: 331-332 | |-> Standard block size Pools D: default, K: keep, R: recycle | |-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k | | | | Free Writ Buffer| | Number of Pool Buffer Physical Physical Buff Comp Busy| |P Buffers Hit% Gets Reads Writes Wait Wait Waits| |--- ---------- ---- ------------ ------------ ----------- ------ ------ --------| |D 211,464 99 19,950 118 734 0 0 0| | ------------------------------------------------------| | | |Checkpoint Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Physical Writes: 739 | | | | Other Autotune Thread | | MTTR Log Size Log Ckpt Settings Ckpt Ckpt | | Writes Writes Writes Writes Writes Writes | |----------- ----------- ----------- ----------- ----------- ----------- | | 0 0 0 0 734 0 | | ------------------------------------------------------| | | |Instance Recovery Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> B: Begin Snapshot, E: End Snapshot | | | | Estd| | Targt Estd Log Ckpt Log Ckpt Opt RAC| | MTTR MTTR Recovery Actual Target Log Sz Timeout Interval Log Avail| | (s) (s) Estd IOs RedoBlks RedoBlks RedoBlks RedoBlks RedoBlks Sz(M) Time| |- ----- ----- -------- -------- -------- -------- -------- -------- ------ -----| |B 0 11 212 818 33129 33129 79953 N/A N/A N/A| |E 0 11 292 485 33129 33129 60173 N/A N/A N/A| | ------------------------------------------------------| | | |MTTR Advisory DB/Inst: DB/db1 Snap: 332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffer Pool Advisory DB/Inst: DB/db1 Snap: 332 | |-> Only rows with estimated physical reads >0 are displayed | |-> ordered by Block Size, Buffers For Estimate | | | | Est | | Phys Estimated Est | | Size for Size Buffers Read Phys Reads Est Phys %DBtime | |P Est (M) Factor (thousands) Factor (thousands) Read Time for Rds | |--- -------- ------ ------------ ------ -------------- ------------ ------- | |D 160 .1 20 4.E+04 4,791,401 1 4.0E+05 | |D 320 .2 39 3.E+04 3,209,136 1 2.6E+05 | |D 480 .3 59 3.E+04 3,209,095 1 2.6E+05 | |D 640 .4 78 2.0 214 1 11.0 | |D 800 .5 98 1.3 142 1 5.0 | |D 960 .6 117 1.2 125 1 3.0 | |D 1,120 .6 137 1.1 119 1 3.0 | |D 1,280 .7 157 1.0 113 1 2.0 | |D 1,440 .8 176 1.0 109 1 2.0 | |D 1,600 .9 196 1.0 109 1 2.0 | |D 1,728 1.0 211 1.0 109 1 2.0 | |D 1,760 1.0 215 1.0 109 1 2.0 | |D 1,920 1.1 235 1.0 109 1 2.0 | |D 2,080 1.2 255 1.0 108 1 2.0 | |D 2,240 1.3 274 1.0 108 1 2.0 | |D 2,400 1.4 294 1.0 108 1 2.0 | |D 2,560 1.5 313 1.0 108 1 2.0 | |D 2,720 1.6 333 1.0 108 1 2.0 | |D 2,880 1.7 352 1.0 108 1 2.0 | |D 3,040 1.8 372 1.0 108 1 2.0 | |D 3,200 1.9 392 1.0 108 1 2.0 | | ------------------------------------------------------| | | | | |PGA Aggr Summary DB/Inst: DB/db1 Snaps: 331-332 | |-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory | | | |PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written | |--------------- ------------------ -------------------------- | | 100.0 317 0 | | ------------------------------------------------------| | | |PGA Aggr Target Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> B: Begin Snap E: End Snap (rows dentified with B or E contain data | | which is absolute i.e. not diffed over the interval) | |-> Auto PGA Target - actual workarea memory target | |-> W/A PGA Used - amount of memory used for all Workareas (manual + auto) | |-> %PGA W/A Mem - percentage of PGA memory allocated to workareas | |-> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt | |-> %Man W/A Mem - percentage of workarea memory under manual control | | | | %PGA %Auto %Man | | PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem | | Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K) | |- ---------- ---------- ---------- ---------- ------ ------ ------ ---------- | |B 793 371 556.5 0.0 .0 .0 .0 102,400 | |E 793 370 557.8 0.0 .0 .0 .0 102,400 | | ------------------------------------------------------| | | |PGA Aggr Target Histogram DB/Inst: DB/db1 Snaps: 331-332 | |-> Optimal Executions are purely in-memory operations | | | | Low High | |Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs | |------- ------- -------------- -------------- ------------ ------------ | | 2K 4K 597 597 0 0 | | 64K 128K 5 5 0 0 | | 128K 256K 2 2 0 0 | | 256K 512K 8 8 0 0 | | 512K 1024K 2 2 0 0 | | 1M 2M 255 255 0 0 | | ------------------------------------------------------| | | |PGA Memory Advisory DB/Inst: DB/db1 Snap: 332 | |-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value | | where Estd PGA Overalloc Count is 0 | | | | Estd Extra Estd P Estd PGA | |PGA Target Size W/A MB W/A MB Read/ Cache Overallo Estd | | Est (MB) Factr Processed Written to Disk Hit % Count Time | |---------- ------- ---------------- ---------------- ------ -------- ------- | | 99 0.1 79,988.7 1,085.5 99.0 30 1.2E+05 | | 198 0.3 79,988.7 1,085.5 99.0 30 1.2E+05 | | 397 0.5 79,988.7 222.0 100.0 0 1.2E+05 | | 595 0.8 79,988.7 131.0 100.0 0 1.2E+05 | | 793 1.0 79,988.7 0.0 100.0 0 1.2E+05 | | 952 1.2 79,988.7 0.0 100.0 0 1.2E+05 | | 1,110 1.4 79,988.7 0.0 100.0 0 1.2E+05 | | 1,269 1.6 79,988.7 0.0 100.0 0 1.2E+05 | | 1,427 1.8 79,988.7 0.0 100.0 0 1.2E+05 | | 1,586 2.0 79,988.7 0.0 100.0 0 1.2E+05 | | 2,379 3.0 79,988.7 0.0 100.0 0 1.2E+05 | | 3,172 4.0 79,988.7 0.0 100.0 0 1.2E+05 | | 4,758 6.0 79,988.7 0.0 100.0 0 1.2E+05 | | 6,344 8.0 79,988.7 0.0 100.0 0 1.2E+05 | | ------------------------------------------------------| | | | | |Shared Pool Advisory DB/Inst: DB/db1 Snap: 332 | |-> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor | |-> Note there is often a 1:Many correlation between a single logical object | | in the Library Cache, and the physical number of memory objects associated | | with it. Therefore comparing the number of Lib Cache objects (e.g. in | | v$librarycache), with the number of Lib Cache Memory Objects is invalid. | | | | Est LC Est LC Est LC Est LC | | Shared SP Est LC Time Time Load Load Est LC| | Pool Size Size Est LC Saved Saved Time Time Mem Obj| | Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Hits (K)| |-------- ----- -------- ------------ -------- ------ ------- ------ ------------| | 432 .9 33 1,336 7,040 1.0 92 4.6 4,659| | 448 .9 48 1,948 7,061 1.0 71 3.6 4,660| | 464 .9 64 2,880 7,078 1.0 54 2.7 4,661| | 480 1.0 80 4,427 7,094 1.0 38 1.9 4,662| | 496 1.0 96 5,377 7,112 1.0 20 1.0 4,663| | 512 1.0 112 5,689 7,112 1.0 20 1.0 4,663| | 528 1.1 128 6,070 7,112 1.0 20 1.0 4,663| | 544 1.1 144 6,451 7,112 1.0 20 1.0 4,664| | 560 1.1 160 6,832 7,112 1.0 20 1.0 4,664| | 576 1.2 175 8,088 7,112 1.0 20 1.0 4,665| | 592 1.2 191 8,980 7,112 1.0 20 1.0 4,665| | 608 1.2 207 9,619 7,112 1.0 20 1.0 4,665| | 624 1.3 219 10,099 7,112 1.0 20 1.0 4,665| | 640 1.3 219 10,099 7,112 1.0 20 1.0 4,665| | 688 1.4 219 10,099 7,112 1.0 20 1.0 4,665| | 752 1.5 219 10,099 7,112 1.0 20 1.0 4,665| | 816 1.6 219 10,099 7,112 1.0 20 1.0 4,665| | 880 1.8 219 10,099 7,112 1.0 20 1.0 4,665| | 944 1.9 219 10,099 7,112 1.0 20 1.0 4,665| | 1,008 2.0 219 10,099 7,112 1.0 20 1.0 4,665| | ------------------------------------------------------| | | |SGA Target Advisory DB/Inst: DB/db1 Snap: 332 | | | |SGA Target SGA Size Est DB Est Physical | | Size (M) Factor Time (s) Reads | |---------- ---------- ------------ ---------------- | | 1,192 0.5 332,770 3,208,744,174 | | 1,788 0.8 68,360 118,530 | | 2,384 1.0 68,360 108,813 | | 2,980 1.3 68,360 108,291 | | 3,576 1.5 68,360 108,149 | | 4,172 1.8 68,360 107,801 | | 4,768 2.0 68,360 107,801 | | ------------------------------------------------------| | | |Streams Pool Advisory DB/Inst: DB/db1 Snap: 332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Java Pool Advisory DB/Inst: DB/db1 Snap: 332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffer Wait Statistics DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Enqueue Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> only enqueues with requests are shown | |-> Enqueue stats gathered prior to 10g should not be compared with 10g data | |-> ordered by Wait Time desc, Waits desc, Requests desc | | | |Enqueue Type (Request Reason) | |------------------------------------------------------------------------------ | | Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) | |------------ ------------ ----------- ----------- ------------ -------------- | |JG-Job Scheduler1 | | 2,520 2,520 0 0 0 N/A | |JG-Job Scheduler1 (queue lock) | | 2,520 2,520 0 0 0 N/A | |CF-Controlfile Transaction | | 922 922 0 0 0 N/A | |SJ-KTSJ Slave Task Cancel (Slave Task Cancel) | | 397 403 0 0 0 N/A | |JG-Job Scheduler1 (q mem clnup lck) | | 240 240 0 0 0 N/A | |TM-DML | | 173 173 0 0 0 N/A | |TX-Transaction | | 110 110 0 0 0 N/A | |HW-Segment High Water Mark | | 22 22 0 0 0 N/A | |TT-Tablespace | | 21 21 0 0 0 N/A | |WF-AWR Flush | | 20 20 0 0 0 N/A | |WT-AWR CDB-Wide Table Lock | | 18 18 0 0 0 N/A | |FB-Format Block | | 14 14 0 0 0 N/A | |TH-Threshold Chain (metric threshold evaluation) | | 10 10 0 0 0 N/A | |AF-Advisor Framework (task serialization) | | 7 7 0 0 0 N/A | |MR-Media Recovery | | 5 5 0 0 0 N/A | |AE-Edition Lock (lock) | | 2 2 0 0 0 N/A | |SH-Active Session History Flushing | | 2 2 0 0 0 N/A | |TA-Instance Undo | | 2 2 0 0 0 N/A | |TO-Temp Object | | 2 2 0 0 0 N/A | |CU-Cursor | | 1 1 0 0 0 N/A | |DW-In memory Dispenser | | 1 1 0 0 0 N/A | |IS-Instance State | | 1 1 0 0 0 N/A | |PR-Process Startup | | 1 1 0 0 0 N/A | |PV-KSV slave startup (syncstart) | | 1 1 0 0 0 N/A | |SE-Session Migration | | 1 1 0 0 0 N/A | |TD-KTF map table enqueue (KTF dump entries) | | 1 1 0 0 0 N/A | | ------------------------------------------------------| | | | | |Undo Segment Summary DB/Inst: DB/db1 Snaps: 331-332 | |-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes) | |-> STO - Snapshot Too Old count, OOS - Out of Space count | |-> Undo segment block stats: | |-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed | |-> eS - expired Stolen, eR - expired Released, eU - expired reUsed | | | |Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/ | | TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU | |---- ---------- --------------- -------- -------- --------- ----- --------------| | 2 .2 509 208 4 16.5/16.5 0/0 0/0/0/0/0/0 | | ------------------------------------------------------| | | |Undo Segment Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> Most recent 35 Undostat rows, ordered by Time desc | | | | Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/ | |End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU | |------------ ----------- ------------ ------- ------- ------- ----- ------------| |30-Dec 09:50 203 509 208 4 16 0/0 0/0/0/0/0/0 | | ------------------------------------------------------| | | | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |AQ Background: interrupt 1 0.0 0 22 0.0| |AQ Coord jobx_kwsbgsgn l 20 0.0 0 0 N/A| |AQ Message drive state o 1 0.0 0 0 N/A| |AQ Sharded master pool l 20 0.0 0 0 N/A| |AQ deq hash table latch 1 0.0 0 0 N/A| |ASM db client latch 399 0.0 0 0 N/A| |ASM map operation hash t 1 0.0 0 0 N/A| |ASM network state latch 9 0.0 0 0 N/A| |ASM remote client latch 9 0.0 0 0 N/A| |AWR Alerted Metric Eleme 4,909 0.0 0 0 N/A| |Autotask management 10 0.0 0 0 N/A| |Change Notification Hash 200 0.0 0 0 N/A| |Column stats entry latch 1 0.0 0 0 N/A| |Consistent RBA 42 0.0 0 0 N/A| |DML lock allocation 786 0.0 0 0 N/A| |Event Group Locks 5 0.0 0 0 N/A| |FAL Queue 34 0.0 0 0 N/A| |FIB s.o chain latch 2 0.0 0 0 N/A| |FOB consolidated s.o lis 2 0.0 0 0 N/A| |File State Object Pool P 1 0.0 0 0 N/A| |GCS logfile block 1 0.0 0 0 N/A| |GCS logfile write queue 1 0.0 0 0 N/A| |Hang Manager wait event 40 0.0 0 0 N/A| |I/O Staticstics latch 1 0.0 0 0 N/A| |ILM Stats Stripe Latch 1 0.0 0 0 N/A| |ILM Stats main anchor la 43 0.0 0 0 N/A| |ILM access tracking exte 1 0.0 0 0 N/A| |ILM activity tracking la 1 0.0 0 0 N/A| |IM Global dictionary lat 1 0.0 0 0 N/A| |IM Global dictionary que 1 0.0 0 0 N/A| |IM Global dictionary rw 1 0.0 0 0 N/A| |IM area sb latch 1 0.0 0 0 N/A| |IM area scb latch 1 0.0 0 0 N/A| |IM emb latch 1 0.0 0 0 N/A| |IM seg hdr latch 1 0.0 0 0 N/A| |IMFS defer write list 1 0.0 0 0 N/A| |IMXT hash table latch 1 0.0 0 0 N/A| |IPC stats buffer allocat 1 0.0 0 0 N/A| |In memory undo latch 1 0.0 0 135 0.0| |JS Sh mem access 121 0.0 0 0 N/A| |JS queue access latch 1 0.0 0 0 N/A| |JS queue state obj latch 5,040 0.0 0 0 N/A| |JS slv state obj latch 1 0.0 0 0 N/A| |KCNIBR - invalid block r 1 0.0 0 0 N/A| |KDCStatHash latch 1 0.0 0 0 N/A| |KDFI Buffer Latch 1 0.0 0 0 N/A| |KDFI Hash Bucket Latch 1 0.0 0 0 N/A| |KDFI Hash Elem Latch 1 0.0 0 0 N/A| |KDMADO action list latch 1 0.0 0 0 N/A| |KDMADO bll latch 1 0.0 0 0 N/A| |KDMADO latch 1 0.0 0 0 N/A| |KFC FX Hash Latch 1 0.0 0 0 N/A| |KFC Hash Latch 1 0.0 0 0 N/A| |KFCL LE Freelist 1 0.0 0 0 N/A| |KFIAS client latch 1 0.0 0 0 N/A| |KFIAS cluster latch 1 0.0 0 0 N/A| |KFIAS endpoint latch 1 0.0 0 0 N/A| |KFIAS node latch 1 0.0 0 0 N/A| |KFIAS process latch 1 0.0 0 0 N/A| |KFIAS queue latch 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |KGNFS-NFS:SHM structure 1 0.0 0 0 N/A| |KGNFS-NFS:SVR LIST 1 0.0 0 0 N/A| |KJC message pool KGH cal 1 0.0 0 0 N/A| |KJC message pool free li 1 0.0 0 0 N/A| |KJC message pool pending 1 0.0 0 0 N/A| |KJCT flow control latch 1 0.0 0 0 N/A| |KMG MMAN ready and start 201 0.0 0 0 N/A| |KSFS OFS ctx level paren 1 0.0 0 0 N/A| |KSFS OFS req layer paren 1 0.0 0 0 N/A| |KSFS OFS sess layer pare 1 0.0 0 0 N/A| |KSFS Receive and Send Qu 1 0.0 0 0 N/A| |KSFS id table parent lat 1 0.0 0 0 N/A| |KSFS ksfs_node latch 1 0.0 0 0 N/A| |KSFSD name cache parent 1 0.0 0 0 N/A| |KSGL LS Segment latch 1 0.0 0 0 N/A| |KSGL SGA anchor latch 1 0.0 0 0 N/A| |KSIPC ASPC anchor latch 1 0.0 0 0 N/A| |KSIPC SGA allocation par 10 0.0 0 0 N/A| |KSIPCGSN Hash Table latc 1 0.0 0 0 N/A| |KSIPCGSN Namespace latch 1 0.0 0 0 N/A| |KSK PDB IO STAT 1 0.0 0 0 N/A| |KSRMA SGA anchor latch 1 0.0 0 0 N/A| |KSRMF SGA anchor latch 1 0.0 0 0 N/A| |KSWL SGA anchor latch 1 0.0 0 0 N/A| |KSXR hang analysis phase 1 0.0 0 0 N/A| |KSXR hang analysis phase 1 0.0 0 0 N/A| |KTF sga latch 1 0.0 0 188 0.0| |KTILM latch 1 0.0 0 0 N/A| |KTU in-memory txn table 1 0.0 0 0 N/A| |KTURMA ODPSCN latch 1 0.0 0 0 N/A| |KTURMA SGA allocation pa 1 0.0 0 0 N/A| |KWQMN job cache list lat 44 0.0 0 0 N/A| |Latch for NonceHistory 1 0.0 0 0 N/A| |Locator state objects po 1 0.0 0 0 N/A| |Lost write change tracki 1 0.0 0 0 N/A| |Lsod array latch 1 0.0 0 0 N/A| |MGA asr alloc latch 10 0.0 0 0 N/A| |MGA heap latch 1 0.0 0 0 N/A| |MGA shared context latch 1 0.0 0 0 N/A| |MGA shared context root 10 0.0 0 0 N/A| |MQL Tracking Latch 0 N/A 0 12 0.0| |Memory Management Latch 0 N/A 0 201 0.0| |Memory Queue 1 0.0 0 0 N/A| |Memory Queue Message Sub 1 0.0 0 0 N/A| |Memory Queue Message Sub 1 0.0 0 0 N/A| |Memory Queue Message Sub 1 0.0 0 0 N/A| |Memory Queue Message Sub 1 0.0 0 0 N/A| |Memory Queue Subscriber 1 0.0 0 0 N/A| |Message cache latch 1 0.0 0 0 N/A| |MinActiveScn Latch 20 0.0 0 0 N/A| |Mutex 1 0.0 0 0 N/A| |Mutex Stats 1 0.0 0 0 N/A| |Nologging Standby SCN Ti 187 0.0 0 0 N/A| |OS process 218 0.0 0 0 N/A| |OS process allocation 1,202 0.0 0 0 N/A| |OS process: request allo 4 0.0 0 0 N/A| |PDB Hash Table Latch 1 0.0 0 0 N/A| |PDB LRU structure 1 0.0 0 0 N/A| |PL/SQL warning settings 2 0.0 0 0 N/A| |PX hash array latch 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |Parent latch for depende 1 0.0 0 0 N/A| |Parent latch for query h 1 0.0 0 0 N/A| |Parent latch for segment 1 0.0 0 0 N/A| |QMT 1 0.0 0 0 N/A| |RTT parent context 1 0.0 0 0 N/A| |Real-time descriptor lat 280 0.0 0 0 N/A| |Report Request stats lat 40 0.0 0 0 N/A| |Request holder compeltio 3 0.0 0 0 N/A| |Retry Ht elm latch 1 0.0 0 0 N/A| |Retry bkt latch 1 0.0 0 0 N/A| |SGA Logging Bkt Latch 1 0.0 0 0 N/A| |SGA Logging Log Latch 1,617 0.0 0 0 N/A| |SGA blob parent 1 0.0 0 0 N/A| |SGA bucket locks 1 0.0 0 0 N/A| |SGA heap locks 1 0.0 0 0 N/A| |SGA pool locks 1 0.0 0 0 N/A| |SO private so latch 3 0.0 0 4 0.0| |SQL memory manager latch 1 0.0 0 200 0.0| |SQL memory manager worka 16,364 0.0 0 0 N/A| |SR Stats Stripe Latch 1 0.0 0 0 N/A| |Sched IM Job latch 10 0.0 0 0 N/A| |Sched InMem Job Cache 1 0.0 0 0 N/A| |Shared B-Tree 23 0.0 0 0 N/A| |Streams Generic 1 0.0 0 0 N/A| |Subscriber Ht elm latch 1 0.0 0 0 N/A| |Testing 1 0.0 0 0 N/A| |Token Manager 1 0.0 0 0 N/A| |Txn Ht elm latch 1 0.0 0 0 N/A| |Txn bkt latch 1 0.0 0 0 N/A| |UM object latch 1 0.0 0 0 N/A| |WCR: sync 1 0.0 0 0 N/A| |Write State Object Pool 1 0.0 0 0 N/A| |X$KSFQP 1 0.0 0 0 N/A| |XDB NFS Security Latch 1 0.0 0 0 N/A| |XDB unused session pool 1 0.0 0 0 N/A| |XDB used session pool 1 0.0 0 0 N/A| |active checkpoint queue 668 0.0 0 0 N/A| |active service list 1,896 0.0 0 506 0.0| |alert log latch 2 0.0 0 0 N/A| |archive destination 54 0.0 0 0 N/A| |archive process 44 0.0 0 0 N/A| |begin backup scn array 1 0.0 0 0 N/A| |buffer pool 1 0.0 0 0 N/A| |business card 1 0.0 0 0 N/A| |cache buffer handles 36 0.0 0 0 N/A| |cache buffers chains 55,637 0.0 0 368 0.0| |cache buffers lru chain 761 0.0 0 1,124 0.0| |call allocation 114 0.0 0 0 N/A| |change notification clie 1 0.0 0 0 N/A| |channel handle pool latc 9 0.0 0 0 N/A| |channel operations paren 15 0.0 0 0 N/A| |checkpoint queue latch 12,482 0.0 0 733 0.0| |client/application info 58 1.7 0.0 0 0 N/A| |compile environment latc 2 0.0 0 0 N/A| |cp handoff latch 1 0.0 0 0 N/A| |cp pool latch 1 0.0 0 0 N/A| |cp server hash latch 1 0.0 0 0 N/A| |cp sga latch 9 0.0 0 0 N/A| |cp srv type state latch 601 0.0 0 0 N/A| |cp srv type wait latch 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |cr slave free list 1 0.0 0 0 N/A| |cvmap freelist lock 1 0.0 0 0 N/A| |deferred cleanup latch 9 0.0 0 0 N/A| |dispatcher info 2 0.0 0 0 N/A| |dml lock allocation 9 0.0 0 0 N/A| |done queue latch 1 0.0 0 0 N/A| |dtp latch 3 0.0 0 0 N/A| |dummy allocation 5 0.0 0 0 N/A| |eighth spare latch - X p 1 0.0 0 0 N/A| |eleventh spare latch - c 1 0.0 0 0 N/A| |enqueue freelist latch 1 0.0 0 13,212 0.3| |enqueue hash chains 13,934 0.2 0.0 0 0 N/A| |fast space usage latch 1 0.0 0 0 N/A| |fifteenth spare latch - 1 0.0 0 0 N/A| |file cache latch 4,224 0.0 0 0 N/A| |first Audit Vault latch 1 0.0 0 0 N/A| |flash file access latch 1 0.0 0 0 N/A| |flashback copy 1 0.0 0 0 N/A| |fourteenth spare latch - 1 0.0 0 0 N/A| |fourth Audit Vault latch 1 0.0 0 0 N/A| |gc element 1 0.0 0 0 N/A| |gcs commit scn state 1 0.0 0 0 N/A| |gcs nodemap pool 1 0.0 0 0 N/A| |gcs opaque info freelist 1 0.0 0 0 N/A| |gcs partitioned table ha 1 0.0 0 0 N/A| |gcs pcm hashed value buc 1 0.0 0 0 N/A| |gcs resource freelist 1 0.0 0 0 N/A| |gcs resource hash 1 0.0 0 0 N/A| |gcs resource scan list 1 0.0 0 0 N/A| |gcs resource timerq list 1 0.0 0 0 N/A| |gcs resource validate li 1 0.0 0 0 N/A| |gcs shadows freelist 1 0.0 0 0 N/A| |ges cached resource list 1 0.0 0 0 N/A| |ges domain table 1 0.0 0 0 N/A| |ges enqueue table freeli 1 0.0 0 0 N/A| |ges group table 1 0.0 0 0 N/A| |ges process hash list 1 0.0 0 0 N/A| |ges process parent latch 1 0.0 0 0 N/A| |ges remote lock freelist 1 0.0 0 0 N/A| |ges resource hash list 1 0.0 0 0 N/A| |ges resource scan list 1 0.0 0 0 N/A| |ges resource table freel 1 0.0 0 0 N/A| |ges timeout list 1 0.0 0 0 N/A| |ges value block free lis 1 0.0 0 0 N/A| |global KZLD latch for au 1 0.0 0 0 N/A| |global tx hash mapping 1 0.0 0 0 N/A| |granule from data transf 1 0.0 0 0 N/A| |gws:Sharding global desc 40 0.0 0 0 N/A| |hash table column usage 0 N/A 0 14 0.0| |hash table expression us 1 0.0 0 0 N/A| |hash table sql contorl l 1 0.0 0 0 N/A| |heartbeat check 1 0.0 0 0 N/A| |imc buf hdl lat 1 0.0 0 0 N/A| |imc cr clone buf 1 0.0 0 0 N/A| |imc hash lat 1 0.0 0 0 N/A| |imc sj lat 1 0.0 0 0 N/A| |imc srchsp lat 1 0.0 0 0 N/A| |imc-txn-wrk-lat 1 0.0 0 0 N/A| |in-memory area latch 1 0.0 0 0 N/A| |in-memory columnar segme 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |in-memory columnar ts ex 1 0.0 0 0 N/A| |in-memory global pool la 1 0.0 0 0 N/A| |intra txn parallel recov 1 0.0 0 0 N/A| |io pool granule list 2 0.0 0 0 N/A| |io pool granule metadata 5 0.0 0 0 N/A| |job workq parent latch 1 0.0 0 0 N/A| |job_queue_processes para 10 0.0 0 0 N/A| |k2q lock allocation 1 0.0 0 0 N/A| |kKCN Cqn SGA 1 0.0 0 0 N/A| |kcb DW scan objtemp hash 1 0.0 0 0 N/A| |kcbtsemkid latch 1 0.0 0 0 N/A| |kcn buffer chains 1 0.0 0 0 N/A| |kdlx hb parent latch 1 0.0 0 0 N/A| |kgb parent 1 0.0 0 0 N/A| |kgnfs mount latch 1 0.0 0 0 N/A| |kjbr roi instance map 1 0.0 0 0 N/A| |kjci objects freelist la 1 0.0 0 0 N/A| |kjci process context lat 1 0.0 0 1,662 0.0| |kjoedcso state object fr 9 0.0 0 0 N/A| |kjoeq omni enqueue hash 1 0.0 0 0 N/A| |kjoer owner hash bucket 1 0.0 0 0 N/A| |kjsca protect pkey hash 1 0.0 0 0 N/A| |kjsca protect service ha 1 0.0 0 0 N/A| |kokc descriptor allocati 12 0.0 0 0 N/A| |kpoxft latch 0 N/A 0 1 0.0| |krso process 35 0.0 0 0 N/A| |ksevn object root latch 200 0.0 0 0 N/A| |ksfv messages 1 0.0 0 0 N/A| |ksi resource reuse count 1 0.0 0 0 N/A| |ksim group membership ca 1 0.0 0 0 N/A| |ksns object latch 1 0.0 0 0 N/A| |kss move lock 3 0.0 0 0 N/A| |ksuosstats global area 48 0.0 0 230 0.0| |ksutcpistat latch 1 0.0 0 0 N/A| |ksv allocation latch 13 0.0 0 0 N/A| |ksv class latch 343 4.7 0.0 0 0 N/A| |ksv msg queue latch 50 0.0 0 49 0.0| |ksz_so allocation latch 4 0.0 0 0 N/A| |ktfbn latch 129 0.0 0 0 N/A| |ktm adg jrnls 1 0.0 0 0 N/A| |ktm adg lookuptable leve 1 0.0 0 0 N/A| |ktm adg lookuptable leve 1 0.0 0 0 N/A| |ktm adg space 1 0.0 0 0 N/A| |ktm adg stages 1 0.0 0 0 N/A| |ktm adg worklink 1 0.0 0 0 N/A| |ktm global data 11 0.0 0 0 N/A| |ktm prv jrnls 1 0.0 0 0 N/A| |ktmpj HT ls 1 0.0 0 0 N/A| |kwqbsn:qsga 22 0.0 0 0 N/A| |kwslbmdl: metadata latch 21 0.0 0 0 N/A| |kwslbql: queue latch 1 0.0 0 0 N/A| |kwslbutl: uncommitted tx 1 0.0 0 0 N/A| |kwsptQcachLt: queue cach 1 0.0 0 0 N/A| |kwsptTrncTsksLt: trunc t 1 0.0 0 0 N/A| |kwsptjobAdPtLt: AdPt lis 15 0.0 0 0 N/A| |kwsslLat: skiplist latch 1 0.0 0 0 N/A| |kxfxscanrate_latch 1 0.0 0 0 N/A| |lgwr LWN SCN 223 0.0 0 0 N/A| |list of block allocation 24 0.0 0 0 N/A| |lob segment dispenser la 4 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |lob segment hash table l 18 0.0 0 0 N/A| |lob segment query latch 1 0.0 0 0 N/A| |lock DBA buffer during m 1 0.0 0 0 N/A| |log write info 0 N/A 0 41 0.0| |log write worker phase 1 0.0 0 0 N/A| |logical standby cache 1 0.0 0 0 N/A| |logminer context allocat 1 0.0 0 0 N/A| |logminer local 1 0.0 0 0 N/A| |logminer work area 1 0.0 0 0 N/A| |longop free list parent 1 0.0 0 0 N/A| |managed standby 20 0.0 0 0 N/A| |message bitmap latch 1 0.0 0 0 N/A| |message pool operations 1 0.0 0 0 N/A| |messages 8,627 0.0 0 0 N/A| |msg queue latch 1 0.0 0 0 N/A| |name-service namespace b 1 0.0 0 0 N/A| |ncodef allocation latch 9 0.0 0 0 N/A| |ninth spare latch - X pa 1 0.0 0 0 N/A| |object queue header free 31 0.0 0 0 N/A| |object queue header oper 2,620 0.0 0 0 N/A| |object queue memory 1 0.0 0 0 N/A| |object stats modificatio 2 0.0 0 0 N/A| |parallel query alloc buf 1 0.0 0 72 0.0| |parallel query stats 1 0.0 0 0 N/A| |parameter table manageme 4 0.0 0 0 N/A| |pdb enqueue hash chains 1 0.0 0 0 N/A| |peshm 1 0.0 0 0 N/A| |pesom_free_list 1 0.0 0 0 N/A| |pesom_hash_node 1 0.0 0 0 N/A| |pkey global statistics 1 0.0 0 0 N/A| |pmon dead latch 9 0.0 0 0 N/A| |post/wait queue 1,863 0.6 0.0 0 2,083 2.4| |process allocation 5 0.0 0 0 N/A| |process group creation 4 0.0 0 0 N/A| |process memory detail 1 0.0 0 0 N/A| |process pkey statistics 1 0.0 0 0 N/A| |process queue 1 0.0 0 0 N/A| |process queue reference 1 0.0 0 0 N/A| |qmn task queue latch 88 0.0 0 0 N/A| |quarantine object 10 0.0 0 0 N/A| |query server freelists 1 0.0 0 0 N/A| |query server process 432 0.0 0 0 N/A| |queued dump request 2 0.0 0 0 N/A| |queuing load statistics 1 0.0 0 0 N/A| |read-moslty lock queue u 1 0.0 0 0 N/A| |recovery domain hash buc 1 0.0 0 0 N/A| |redo allocation 609 0.0 0 5,111 0.0| |redo copy 1 0.0 0 5,111 0.0| |redo gen encryption key 1 0.0 0 0 N/A| |redo transport task 45 0.0 0 0 N/A| |redo writing 1,209 0.0 0 0 N/A| |remote tool request latc 2 0.0 0 0 N/A| |resmgr group change latc 1 0.0 0 0 N/A| |resmgr:active threads 16 0.0 0 10 0.0| |resmgr:actses change gro 3 0.0 0 0 N/A| |resmgr:actses change sta 1 0.0 0 0 N/A| |resmgr:free threads list 4 0.0 0 0 N/A| |resmgr:plan CPU method 1 0.0 0 0 N/A| |resmgr:plan change alloc 1 0.0 0 0 N/A| |resmgr:plan change latch 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for | | willing-to-wait latch get requests | |-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests | |-> "Pct Misses" for both should be very close to 0.0 | | | | Pct Avg Wait Pct| | Get Get Slps Time NoWait NoWait| |Latch Name Requests Miss /Miss (s) Requests Miss| |------------------------ -------------- ------ ------ ------ ------------ ------| |resmgr:resource group CP 21 0.0 0 0 N/A| |resmgr:schema config 27 0.0 0 10 0.0| |resmgr:session queuing 1 0.0 0 0 N/A| |row cache objects 1 0.0 0 0 N/A| |second Audit Vault latch 1 0.0 0 0 N/A| |sequence cache 12 0.0 0 0 N/A| |service drain list 601 0.0 0 0 N/A| |session allocation 571 0.0 0 568 0.4| |session idle bit 2,451 0.0 0 0 N/A| |session queue latch 1 0.0 0 0 N/A| |session state list latch 2 0.0 0 0 N/A| |session statistics 5 0.0 0 0 N/A| |session switching 12 0.0 0 0 N/A| |session timer 200 0.0 0 0 N/A| |seventh spare latch - X 1 0.0 0 0 N/A| |sga hash table parent la 1 0.0 0 0 N/A| |shard latch 1 0.0 0 0 N/A| |shardgroup list latch 2 0.0 0 0 N/A| |shared pool 2,066 0.0 0 0 N/A| |shared pool sim alloc 1 0.0 0 0 N/A| |shared pool simulator 7 0.0 0 0 N/A| |shared server configurat 201 0.0 0 0 N/A| |sim partition latch 1 0.0 0 0 N/A| |simulator hash latch 2,187 0.0 0 0 N/A| |simulator lru latch 735 0.0 0 1,444 0.0| |sixth spare latch - X pa 1 0.0 0 0 N/A| |sort extent pool 117 0.0 0 0 N/A| |space background task la 1,209 51.0 0.4 0 403 0.0| |state object free list 2 0.0 0 0 N/A| |statistics aggregation 145 0.0 0 0 N/A| |subscriber Ht bkt 1 0.0 0 0 N/A| |tablespace key chain 1 0.0 0 0 N/A| |temp lob duration state 6 0.0 0 0 N/A| |tenth spare latch - X pa 1 0.0 0 0 N/A| |test excl. parent l0 1 0.0 0 0 N/A| |test excl. parent2 l0 1 0.0 0 0 N/A| |test excl. parent2 lmid 1 0.0 0 0 N/A| |test mixed exclusive 1 0.0 0 0 N/A| |test mode exclusive 1 0.0 0 0 N/A| |test open exclusive 1 0.0 0 0 N/A| |test pdb exclusive 1 0.0 0 0 N/A| |test shared parent2 lmid 1 0.0 0 0 N/A| |thirteenth spare latch - 1 0.0 0 0 N/A| |threshold alerts latch 19 0.0 0 0 N/A| |transaction allocation 15 0.0 0 0 N/A| |twelfth spare latch - ch 1 0.0 0 0 N/A| |twenty-fifth spare latch 1 0.0 0 0 N/A| |twenty-first spare latch 1 0.0 0 0 N/A| |twenty-fourth spare latc 1 0.0 0 0 N/A| |twenty-second spare latc 1 0.0 0 0 N/A| |twenty-third spare latch 1 0.0 0 0 N/A| |undo global data 732 0.0 0 0 N/A| |virtual circuit buffers 1 0.0 0 0 N/A| |virtual circuit holder 1 0.0 0 0 N/A| |virtual circuit queues 1 0.0 0 0 N/A| | ------------------------------------------------------| | | | | |Latch Sleep Breakdown DB/Inst: DB/db1 Snaps: 331-332 | |-> ordered by misses desc | | | | Get Spin | |Latch Name Requests Misses Sleeps Gets | |-------------------------- --------------- ------------ ----------- ----------- | |space background task latc 1,209 616 229 388 | | ------------------------------------------------------| | | | | |Latch Miss Sources DB/Inst: DB/db1 Snaps: 331-332 | |-> only latches with sleeps are shown | |-> ordered by name, sleeps desc | | | | NoWait Waiter | |Latch Name Where Misses Sleeps Sleeps | |------------------------ -------------------------- ------- ---------- -------- | |space background task la ktsj_grab_task 0 153 222 | |space background task la ktsj_detach_task 0 71 7 | |space background task la ktsj_smco_purgeexpired 0 5 0 | | ------------------------------------------------------| | | |Mutex Sleep Summary DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Parent Latch Statistics DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Child Latch Statistics DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Segments by Logical Reads DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Logical Reads: 20,356 | |-> Captured Segments account for 87.7% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. Logical | |Object Name Name Type Obj# Dataobj# Reads %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 4,768 23.42| |SYS SYSAUX | |WRH$_LATCH_PK 9277899_86 INDEX 73737 73737 2,080 10.22| |SYS SYSTEM | |RECYCLEBIN$_TS INDEX 265 265 2,032 9.98| |SYS SYSTEM | |TS$ TABLE 16 6 1,456 7.15| |SYS SYSAUX | |WRH$_SQL_PLAN TABLE 11147 11147 944 4.64| | ------------------------------------------------------| | | |Segments by Physical Reads DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Physical Reads: 118 | |-> Captured Segments account for 85.6% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. Physical | |Object Name Name Type Obj# Dataobj# Reads %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |SYS_LOB0000011147C00 LOB 11148 11148 14 11.86| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 14 11.86| |SYS SYSAUX | |WRH$_SYSSTAT 9277899_86 TABLE 73755 73755 10 8.47| |SYS SYSAUX | |WRH$_LATCH 9277899_86 TABLE 73735 73735 8 6.78| |SYS SYSAUX | |WRH$_SQL_PLAN_PK INDEX 11150 11150 8 6.78| | ------------------------------------------------------| | | |Segments by Physical Read Requests DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Physical Read Requests: 118 | |-> Captured Segments account for 85.6% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. Phys Read | |Object Name Name Type Obj# Dataobj# Requests %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |SYS_LOB0000011147C00 LOB 11148 11148 14 11.86| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 14 11.86| |SYS SYSAUX | |WRH$_SYSSTAT 9277899_86 TABLE 73755 73755 10 8.47| |SYS SYSAUX | |WRH$_LATCH 9277899_86 TABLE 73735 73735 8 6.78| |SYS SYSAUX | |WRH$_SQL_PLAN_PK INDEX 11150 11150 8 6.78| | ------------------------------------------------------| | | |Segments by UnOptimized Reads DB/Inst: DB/db1 Snaps: 331-332 | |-> Total UnOptimized Read Requests: 118 | |-> Captured Segments account for 85.6% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. UnOptimized | |Object Name Name Type Obj# Dataobj# Reads %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |SYS_LOB0000011147C00 LOB 11148 11148 14 11.86| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 14 11.86| |SYS SYSAUX | |WRH$_SYSSTAT 9277899_86 TABLE 73755 73755 10 8.47| |SYS SYSAUX | |WRH$_LATCH 9277899_86 TABLE 73735 73735 8 6.78| |SYS SYSAUX | |WRH$_SQL_PLAN_PK INDEX 11150 11150 8 6.78| | ------------------------------------------------------| | | |Segments by Optimized Reads DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Direct Physical Reads DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Physical Writes DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Physical Writes: 739 | |-> Captured Segments account for 47.1% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. Physical | |Object Name Name Type Obj# Dataobj# Writes %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |WRH$_SQLSTAT_INDEX 9277899_86 INDEX 73723 73723 54 7.31| |SYS SYSAUX | |WRH$_EVENT_HISTOGRAM 9277899_86 INDEX 73797 73797 31 4.19| |SYS SYSAUX | |WRH$_SQLTEXT TABLE 11139 11139 19 2.57| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 16 2.17| |SYS SYSAUX | |WRH$_SYSSTAT 9277899_86 TABLE 73755 73755 13 1.76| | ------------------------------------------------------| | | |Segments by Physical Write Requests DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Physical Write Requests: 463 | |-> Captured Segments account for 58.1% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. Phys Write | |Object Name Name Type Obj# Dataobj# Requests %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |WRH$_SQLSTAT_INDEX 9277899_86 INDEX 73723 73723 28 6.05| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 16 3.46| |SYS SYSAUX | |WRH$_EVENT_HISTOGRAM 9277899_86 INDEX 73797 73797 13 2.81| |SYS SYSAUX | |WRH$_LATCH 9277899_86 TABLE 73735 73735 11 2.38| |SYS SYSAUX | |WRH$_SQL_PLAN_PK INDEX 11150 11150 11 2.38| | ------------------------------------------------------| | | |Segments by Direct Physical Writes DB/Inst: DB/db1 Snaps: 331-332 | |-> Total Direct Physical Writes: 5 | |-> Captured Segments account for 100.0% of Total | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. Direct | |Object Name Name Type Obj# Dataobj# Writes %Total| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |SYS_LOB0000011147C00 LOB 11148 11148 5 100.00| | ------------------------------------------------------| | | |Segments by Table Scans DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by DB Blocks Changes DB/Inst: DB/db1 Snaps: 331-332 | |-> % of Capture shows % of DB Block Changes for each top segment compared | |-> with total DB Block Changes for all segments captured by the Snapshot | |-> When ** MISSING ** occurs, some of the object attributes may not be available| | | | Tablespace | |Owner Name | |-------------------- ---------- | | Subobject Obj. DB Block % of| |Object Name Name Type Obj# Dataobj# Changes Capture| |-------------------- ---------- ----- ---------- ---------- ------------ -------| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 1,680 35.96| |SYS SYSAUX | |WRH$_LATCH_PK 9277899_86 INDEX 73737 73737 704 15.07| |SYS SYSAUX | |WRH$_EVENT_HISTOGRAM 9277899_86 INDEX 73797 73797 208 4.45| |SYS SYSAUX | |WRH$_SQL_PLAN TABLE 11147 11147 208 4.45| |SYS SYSAUX | |WRH$_PARAMETER_PK 9277899_86 INDEX 73761 73761 192 4.11| | ------------------------------------------------------| | | | | |Segments by Row Lock Waits DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by ITL Waits DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Buffer Busy Waits DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Dictionary Cache Stats DB/Inst: DB/db1 Snaps: 331-332 | |-> "Pct Misses" should be very low (< 2% in most cases) | |-> "Final Usage" is the number of cache entries being used | | | | Get Pct Scan Pct Mod Final | |Cache Requests Miss Reqs Miss Reqs Usage | |------------------------- ------------ ------ ------- ----- -------- ---------- | |dc_awr_control 18 0.0 0 N/A 4 1 | |dc_global_oids 6 0.0 0 N/A 0 59 | |dc_histogram_data 1 0.0 0 N/A 0 1,445 | |dc_histogram_defs 2 0.0 0 N/A 0 2,916 | |dc_objects 719 0.1 0 N/A 0 3,215 | |dc_profiles 2 0.0 0 N/A 0 1 | |dc_props 486 0.0 0 N/A 0 3 | |dc_rollback_segments 284 0.0 0 N/A 0 22 | |dc_segments 15 0.0 0 N/A 7 560 | |dc_tablespaces 282 0.0 0 N/A 0 7 | |dc_users 42 0.0 4 0.0 0 113 | |outstanding_alerts 1 0.0 0 N/A 0 3 | | ------------------------------------------------------| | | |Library Cache Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> "Pct Misses" should be very low | | | | Get Pct Pin Pct Invali- | |Namespace Requests Miss Requests Miss Reloads dations | |--------------- ------------ ------ -------------- ------ ---------- -------- | |ACCOUNT_STATUS 4 0.0 0 N/A 0 0 | |AUDIT POLICY 2 0.0 2 0.0 0 0 | |BODY 2 0.0 12 0.0 0 0 | |DBLINK 4 0.0 0 N/A 0 0 | |EDITION 2 0.0 4 0.0 0 0 | |SCHEMA 1 0.0 0 N/A 0 0 | |SQL AREA 225 0.9 3,571 0.1 1 1 | |SQL AREA BUILD 1 100.0 0 N/A 0 0 | |SQL AREA STATS 2 50.0 2 50.0 0 0 | |TABLE/PROCEDURE 7 0.0 77 1.3 1 0 | |TRIGGER 4 0.0 4 0.0 0 0 | | ------------------------------------------------------| | | | | |Memory Dynamic Components DB/Inst: DB/db1 Snaps: 331-332 | |-> Min/Max sizes since instance startup | |-> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred | |-> ordered by Component | | | | Begin Snap Current Min Max Oper Last Op | |Component Size (Mb) Size (Mb) Size (Mb) Size (Mb) Count Typ/Mod | |--------------- ----------- ----------- ----------- ----------- ------ ------- | |ASM Buffer Cach .00 .00 .00 .00 0 STA/ | |DEFAULT 16K buf .00 .00 .00 .00 0 STA/ | |DEFAULT 2K buff .00 .00 .00 .00 0 STA/ | |DEFAULT 32K buf .00 .00 .00 .00 0 STA/ | |DEFAULT 4K buff .00 .00 .00 .00 0 STA/ | |DEFAULT 8K buff .00 .00 .00 .00 0 STA/ | |DEFAULT buffer 1,728.00 1,728.00 1,728.00 1,728.00 0 INI/ | |Data Transfer C .00 .00 .00 .00 0 STA/ | |In Memory RO Ex .00 .00 .00 .00 0 STA/ | |In Memory RW Ex .00 .00 .00 .00 0 STA/ | |In-Memory Area .00 .00 .00 .00 0 STA/ | |KEEP buffer cac .00 .00 .00 .00 0 STA/ | |PGA Target 800.00 800.00 800.00 800.00 0 STA/ | |RECYCLE buffer .00 .00 .00 .00 0 STA/ | |SGA Target 2,384.00 2,384.00 2,384.00 2,384.00 0 STA/ | |Shared IO Pool 128.00 128.00 128.00 128.00 0 STA/ | |java pool .00 .00 .00 .00 0 STA/ | |large pool 16.00 16.00 16.00 16.00 0 STA/ | |memoptimize buf .00 .00 .00 .00 0 STA/ | |shared pool 496.00 496.00 496.00 496.00 0 STA/ | |streams pool .00 .00 .00 .00 0 STA/ | |unified pga poo .00 .00 .00 .00 0 STA/ | | ------------------------------------------------------| | | |Memory Resize Operations Summary DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Memory Resize Ops DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Process Memory Summary DB/Inst: DB/db1 Snaps: 331-332 | |-> 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 | |-> Top 10 containers by Alloc (MB) at end snapshot time are displayed | | | | Hist | | Avg Std Dev Max Max | | Alloc Used Alloc Alloc Alloc Alloc Num Num | | Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc | | - -------- --------- --------- -------- -------- ------- ------- ------ ------ | |B Freeable 132.3 .0 4.7 10.1 50 N/A 28 28 | | Other 392.7 N/A 5.2 9.6 58 58 75 75 | | PL/SQL 5.9 5.3 .1 .3 1 3 65 65 | | SQL 25.7 23.9 .7 1.6 7 10 38 30 | | Total 556.5 29.2 10.7 21.6 116 71 206 198 | |E Freeable 133.8 .0 4.8 10.0 50 N/A 28 28 | | Other 392.7 N/A 5.2 9.7 59 59 75 75 | | PL/SQL 5.9 5.3 .1 .3 1 3 65 65 | | SQL 25.4 23.7 .7 1.6 7 10 38 30 | | Total 557.8 28.9 10.8 21.5 116 72 206 198 | | ------------------------------------------------------| | | |SGA Memory Summary DB/Inst: DB/db1 Snaps: 331-332 | | | | End Size (Bytes) | |SGA regions Begin Size (Bytes) (if different) | |------------------------------ ------------------- ------------------- | |Database Buffers 1,946,157,056 | |Fixed Size 8,899,624 | |Redo Buffers 7,876,608 | |Variable Size 536,870,912 | | ------------------- | |sum 2,499,804,200 | | ------------------------------------------------------| | | |SGA breakdown difference by Pool and Name DB/Inst: DB/db1 Snaps: 331-332 | |-> 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 | |------ ------------------------------ -------------- -------------- ------- | |large PX msg pool .5 .5 0.00 | |large free memory 15.5 15.5 0.00 | |shared ASH buffers 8.0 8.0 0.00 | |shared KGLH0 31.3 31.3 0.10 | |shared KGLHD 6.9 6.9 0.04 | |shared KGLS 7.4 7.5 0.68 | |shared KGLSG 5.0 5.0 0.00 | |shared KQR X PO 5.8 5.8 0.02 | |shared PLMCD 7.9 7.9 0.00 | |shared SO private sga 15.6 15.6 0.00 | |shared SQLA 147.4 147.4 0.01 | |shared db_block_hash_buckets 8.0 8.0 0.00 | |shared file state object 5.8 5.8 0.00 | |shared free memory 63.7 63.2 -0.81 | |shared ksunfy_meta 1 12.8 12.8 0.00 | |shared private strands 7.1 7.1 0.00 | |shared row cache .0 .0 0.00 | |shared row cache hash 5.7 5.7 0.00 | |shared row cache mutex 8.6 8.6 0.00 | |shared write state object 7.9 7.9 0.00 | | buffer_cache 1,728.0 1,728.0 0.00 | | fixed_sga 8.5 8.5 0.00 | | log_buffer 7.5 7.5 0.00 | | shared_io_pool 128.0 128.0 0.00 | | ------------------------------------------------------| | | | | |Replication System Resource Usage DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Replication SGA Usage DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |GoldenGate Capture DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Capture Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Reader DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Coordinator DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Server DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Coordinator Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Reader and Server Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |XStream Capture DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Capture Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Reader DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Coordinator DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Server DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Coordinator Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Reader and Server Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Table Statistics by DML Operations DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Table Statistics by Conflict Resolutions DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Replication Large Transaction Statistics DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Replication Long Running Transaction StatisticsDB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Advanced Queue CPU/IO Usage DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffered Queues DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffered Queue Subscribers DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Rule Set DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Persistent Queues DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Persistent Queues Rate DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Persistent Queue Subscribers DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Resource Limit Stats DB/Inst: DB/db1 Snap: 332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Shared Servers Activity DB/Inst: DB/db1 Snaps: 331-332 | |-> Values represent averages for all samples | | | | Avg Total Avg Active Avg Total Avg Active Avg Total Avg Active | | Connections Connections Shared Srvrs Shared Srvrs Dispatchers Dispatchers | |------------ ------------ ------------ ------------ ------------ ------------ | | 0 0 1 0 1 0 | | ------------------------------------------------------| | | |Shared Servers Rates DB/Inst: DB/db1 Snaps: 331-332 | | | | Common Disp Common Disp Server | | Queue Queue Server Server Queue Queue Total Server| | Per Sec Per Sec Msgs/Sec KB/Sec Total Total Msgs Total(KB)| |-------- -------- -------- --------- ---------- ---------- ---------- ----------| | 0 0 0 0.0 0 0 0 0| | ------------------------------------------------------| | | |Shared Servers Utilization DB/Inst: DB/db1 Snaps: 331-332 | |-> Statistics are combined for all servers | |-> Incoming and Outgoing Net % are included in %Busy | | | | Total Server Incoming Outgoing | | Time (s) %Busy %Idle Net % Net % | |-------------- -------- -------- --------- --------- | | 601 0.0 100.0 0.0 0.0 | | ------------------------------------------------------| | | |Shared Servers Common Queue DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Shared Servers Dispatchers DB/Inst: DB/db1 Snaps: 331-332 | |-> Ordered by %Busy, descending | |-> Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue | |-> Name suffixes: | | "(N)" - dispatcher started between begin and end snapshots | | "(R)" - dispatcher re-started between begin and end snapshots | | | | Avg Total Disp Total Total Queue Avg Queue| |Name Conns Time (s) %Busy %Idle Queued Wait (s) Wait (ms)| |------- --------- ---------- -------- -------- ---------- ----------- ----------| |D000 0.0 601 0.0 100.0 0 0 | | ------------------------------------------------------| | | | | |Modified Parameters DB/Inst: DB/db1 Snaps: 331-332 | |-> This section shows all the modified initialization parameters that | |were in effect during the entire snapshot interval | |-> End Value is displayed only if the parameter value was modified within | |the snapshot interval | | | | End value | |Parameter Name Begin value (if different) | |----------------------------- --------------------------------- -------------- | |audit_file_dest /u01/app/oracle/admin/db/adump | |audit_trail DB | |compatible 19.0.0 | |control_files /u01/app/oracle/oradata/DB/contro | |db_block_size 8192 | |db_name db | |diagnostic_dest /u01/app/oracle | |dispatchers (PROTOCOL=TCP) (SERVICE=db1XDB) | |log_archive_dest_1 LOCATION=/u01/arch/db | |nls_language AMERICAN | |nls_territory AMERICA | |open_cursors 300 | |pga_aggregate_target 831520768 | |processes 320 | |remote_login_passwordfile EXCLUSIVE | |sga_target 2499805184 | |undo_tablespace UNDOTBS1 | | ------------------------------------------------------| | | | | |Modified Multi-Valued Parameters DB/Inst: DB/db1 Snaps: 331-332 | |-> This section only displays parameters that have more than one value | |->'(NULL)' indicates a missing parameter value | |-> A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot| | | | End value | |Parameter Name Begin value (if different) | |----------------------------- --------------------------------- -------------- | |control_files /u01/app/oracle/oradata/DB/contro | | /u01/app/oracle/oradata/DB/contro | | ------------------------------------------------------| | | |Top SQL with Top Events DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top SQL with Top Row Sources DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top Sessions DB/Inst: DB/db1 Snaps: 331-332 | |-> '# Samples Active' shows the number of ASH samples in which the session | | was found waiting for that particular event. The percentage shown | | in this column is calculated with respect to wall clock time | | and not total database activity. | |-> 'XIDs' shows the number of distinct transaction IDs sampled in ASH | | when the session was waiting for that particular event | | | | Sid, Serial# % Activity Event % Event | |--------------- ---------- ------------------------------ ---------- | |User Program # Samples Active XIDs | |-------------------- ------------------------------ ------------------ -------- | | 1,61310 100.00 CPU + Wait for CPU 100.00 | |SYS oracle@oracle-....local (PSP0) 2/60 [ 3%] 0 | | | | ------------------------------------------------------| | | |Top Blocking Sessions DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top PL/SQL Procedures DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top Events DB/Inst: DB/db1 Snaps: 331-332 | |-> Top Events by DB Time | |-> % Activity is the percentage of DB Time due to the event | | | |Event Event Class Session Type | |----------------------------------- --------------- --------------- | | Avg Active | |% Activity Sessions | |---------- ---------- | |CPU + Wait for CPU CPU BACKGROUND | | 100.00 0.03 | | ------------------------------------------------------| | | |Top Event P1/P2/P3 Values DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top DB Objects DB/Inst: DB/db1 Snaps: 331-332 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Activity Over Time DB/Inst: DB/db1 Snaps: 331-332 | |-> Analysis period is divided into smaller time slots as indicated | | in the 'Slot Time (Duration)'. | |-> Top 3 events are reported in each of those slots | |-> 'Slot Count' shows the number of ASH samples in that slot | |-> 'Event Count' shows the number of ASH samples waiting for | | that event in that slot | |-> '% Event' is 'Event Count' over all ASH samples in the analysis period | | | | Slot Event | |Slot Time (Duration) Count Event Count % Event | |-------------------- -------- ------------------------------ -------- ------- | |09:50:16 (4.7 min) 2 CPU + Wait for CPU 2 100.00 | | ------------------------------------------------------| | | | | | | | ADDM Report for Task 'ADDM:1979277899_1_332' | | -------------------------------------------- | | | |Analysis Period | |--------------- | |AWR snapshot range from 331 to 332. | |Time period starts at 30-DEC-25 09.50.17 AM | |Time period ends at 30-DEC-25 10.00.17 AM | | | |Analysis Target | |--------------- | |Database 'DB' with DB ID 1979277899. | |Database version 19.0.0.0.0. | |ADDM performed an analysis of instance db1, numbered 1 and hosted at | |oracle-19c-ol7-121.pollo.local. | | | |Activity During the Analysis Period | |----------------------------------- | |Total database time was 5 seconds. | |The average number of active sessions was .01. | | | | | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | | |There are no findings to report. | | | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | | | Additional Information | | ---------------------- | | | |Miscellaneous Information | |------------------------- | |There was no significant database activity to run the ADDM. | | | |End of Report |