|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: 360 30-Dec-25 14:40:33 65 4.1 | | End Snap: 361 30-Dec-25 14:50:33 64 4.1 | | Elapsed: 10.01 (mins) | | DB Time: 0.08 (mins) | | | |Load Profile Per Second Per Transaction Per Exec Per Call| |~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------| | DB Time(s): 0.0 0.3 0.00 0.01| | DB CPU(s): 0.0 0.3 0.00 0.01| | Background CPU(s): 0.0 0.6 0.00 0.00| | Redo size (bytes): 5,024.7 201,180.3 | | Logical read (blocks): 33.2 1,330.3 | | Block changes: 15.2 607.4 | | Physical read (blocks): 0.0 0.8 | |Physical write (blocks): 3.5 140.5 | | Read IO requests: 0.0 0.8 | | Write IO requests: 0.8 33.1 | | Read IO (MB): 0.0 0.0 | | Write IO (MB): 0.0 1.1 | | IM scan rows: 0.0 0.0 | |Session Logical Read IM: 0.0 0.0 | | User calls: 1.1 43.5 | | Parses (SQL): 4.5 180.8 | | Hard parses (SQL): 0.0 0.1 | | SQL Work Area (MB): 0.5 21.5 | | Logons: 0.0 0.1 | | User logons: 0.0 0.0 | | Executes (SQL): 5.8 233.4 | | Rollbacks: 0.0 0.0 | | Transactions: 0.0 | | | |Instance Efficiency Percentages (Target 100%) | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | Buffer Nowait %: 100.00 Redo NoWait %: 100.00 | | Buffer Hit %: 99.94 In-memory Sort %: 100.00 | | Library Hit %: 99.90 Soft Parse %: 99.93 | | Execute to Parse %: 22.54 Latch Hit %: 99.58 | |Parse CPU to Parse Elapsd %: 400.00 % Non-Parse CPU: 99.70 | | 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 4.6 95.1 | |control file sequential read 2,280 0 15.37us .7 System I | |PGA memory operation 1,042 0 31.18us .7 Other | |SQL*Net message to client 640 0 4.35us .1 Network | |AWR Flush 0 0 .0 Other | |DLM cross inst call completion 0 0 .0 Other | |Data file init write 0 0 .0 User I/O | |Disk file operations I/O 0 0 .0 User I/O | |KSV master wait 0 0 .0 Other | |asynch descriptor resize 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 95.1 0.0 | |System I/O 4,528 4 873.98us 81.6 0.0 | |Other 1,455 0 162.60us 4.9 0.0 | |User I/O 63 0 1.04ms 1.3 0.0 | |Network 640 0 4.35us .1 0.0 | |Commit 1 0 2.58ms .1 0.0 | | | |Host CPU | |~~~~~~~~ Load Average | | CPUs Cores Sockets Begin End %User %System %WIO %Idle | |----- ----- ------- --------- --------- --------- --------- --------- --------- | | 4 4 4 0.05 0.08 0.7 0.5 0.1 98.3 | | | |Instance CPU | |~~~~~~~~~~~~ | | % of total CPU for Instance: 0.6 | | % of busy CPU for Instance: 32.2 | | %DB time waiting for CPU - Resource Mgr: 0.0 | | | |IO Profile Read+Write/Second Read/Second Write/Second | |~~~~~~~~~~ ----------------- --------------- --------------- | | Total Requests: 8.1 6.2 1.8 | | Database Requests: 0.9 0.0 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.1 | | 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): 3.5 0.0 3.5 | | Via Buffer Cache (blocks): 3.5 0.0 3.5 | | 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): 555.3 506.3 | | % Host Mem used for SGA+PGA: 37.04 36.42 | | | |Cache Sizes Begin End | |~~~~~~~~~~~ ---------- ---------- | | Buffer Cache: 1,728M 1,728M Std Block Size: 8K | | Shared Pool Size: 356M 356M Log Buffer: 7,692K | | In-Memory Area: 0M 0M | | | | Shared Pool Statistics Begin End | |~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------ ------ | | Memory Usage %: 82.58 82.47 | | % SQL with executions>1: 86.35 87.52 | | % Memory for SQL w/exec>1: 88.08 89.63 | | | | | |Time Model Statistics DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 4.7 97.3 | |DB CPU 4.6 95.1 34.5| |parse time elapsed 0.0 .9 | |DB time 4.9 | |background elapsed time 10.6 | |background cpu time 8.7 65.5| |total CPU time 13.4 | | ------------------------------------------------------| | | |Operating System Statistics DB/Inst: DB/db1 Snaps: 360-361 | |-> *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 68,972,544 97,914,880 | |INACTIVE_MEMORY_BYTES 4,295,839,744 4,317,061,120 | |SWAP_FREE_BYTES 17,179,328,512 | |BUSY_TIME 4,144 | |IDLE_TIME 234,511 | |IOWAIT_TIME 327 | |NICE_TIME 0 | |SYS_TIME 1,159 | |USER_TIME 1,689 | |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: 360-361 | | | |Snap Time Load %busy %user %sys %idle %iowait | |--------------- -------- -------- -------- -------- -------- -------- | |30-Dec 14:40:33 0.0 N/A N/A N/A N/A N/A | |30-Dec 14:50:33 0.1 1.7 0.7 0.5 98.3 0.1 | | ------------------------------------------------------| | | |Foreground Wait Class DB/Inst: DB/db1 Snaps: 360-361 | |-> 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.5% of Total DB time 4.85 (s)| |-> Total FG Wait Time: .07 (s) DB CPU time: 4.61 (s)| | | | %Time Total Wait | |Wait Class Waits -outs Time (s) Avg wait %DB time | |-------------------- --------------- ----- --------------- ---------- --------- | |DB CPU 5 95.1 | |System I/O 2,280 0 0 15.37us 0.7 | |Other 1,042 0 0 31.18us 0.7 | |Network 640 0 0 4.35us 0.1 | |Commit 0 0 0.0 | |User I/O 0 0 0.0 | | ------------------------------------------------------| | | | | |Foreground Wait Events DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 15.37us 152.0 .7 | |PGA memory operation 1,042 0 31.18us 69.5 .7 | |SQL*Net message to client 640 0 4.35us 42.7 .1 | |SQL*Net message from clien 639 2,980 4663.76ms 42.6 | |watchdog main loop 402 1,206 3000.22ms 26.8 | | ------------------------------------------------------| | | | | |Background Wait Events DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 270 0 2 7.69ms 18.0 19.5 | |db file async I/O submit 496 0 2 3.35ms 33.1 15.7 | |log file parallel write 47 0 0 3.40ms 3.1 1.5 | |latch free 265 0 0 428.51us 17.7 1.1 | |oracle thread bootstrap 2 0 0 38.69ms 0.1 .7 | |db file single write 11 0 0 3.29ms 0.7 .3 | |control file sequential re 1,435 0 0 17.06us 95.7 .2 | |direct path sync 2 0 0 7.99ms 0.1 .2 | |os thread creation 2 0 0 3.25ms 0.1 .1 | |Data file init write 12 0 0 452.67us 0.8 .1 | |Disk file operations I/O 9 0 0 509.44us 0.6 .0 | |KSV master wait 50 100 0 83.96us 3.3 .0 | |db file sequential read 29 0 0 104.38us 1.9 .0 | |log file sync 1 0 0 2.58ms 0.1 .0 | |PGA memory operation 87 0 0 25.62us 5.8 .0 | |rdbms ipc message 3,824 98 10,414 2723.46ms 254.9 | |Space Manager: slave idle 1,477 0 4,785 3239.59ms 98.5 | |class slave wait 46 0 2,453 53.33 s 3.1 | |DIAG idle wait 1,201 100 1,201 1000.22ms 80.1 | |pmon timer 400 100 1,200 3000.23ms 26.7 | |LGWR worker group idle 2 0 1,200 600.00 s 0.1 | |Streams AQ: qmn slave idle 23 0 616 26.78 s 1.5 | |Streams AQ: qmn coordinato 45 0 616 13.69 s 3.0 | |wait for unread message on 601 100 601 1000.24ms 40.1 | |heartbeat redo informer 601 0 601 1000.23ms 40.1 | |lreg timer 200 100 600 3002.08ms 13.3 | |OFS idle 200 100 600 3000.23ms 13.3 | |pman timer 200 100 600 3000.22ms 13.3 | |dispatcher timer 10 100 600 60.00 s 0.7 | |Data Guard: Timer 20 0 600 30.00 s 1.3 | |AQPC idle 20 100 600 30.00 s 1.3 | |Data Guard: Gap Manager 10 0 600 60.00 s 0.7 | |smon timer 2 100 600 300.00 s 0.1 | | ------------------------------------------------------| | | | | |Wait Event Histogram DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 | |DLM cross inst call compl 1 100.0 | |Data file init write 12 8.3 8.3 58.3 25.0| |Disk file operations I/O 18 16.7 11.1 27.8 11.1 5.6 5.6 5.6 16.7| |KSV master wait 50 10.0 2.0 8.0 24.0 32.0 24.0 | |LGWR all worker groups 1 100.0 | |Log archive I/O 8 12.5 12.5 25.0 50.0 | |PGA memory operation 1129 24.3 27.3 21.5 17.1 8.2 1.2 .1 .4| |Redo Transport Open 1 100.0 | |SQL*Net message to client 640 92.8 5.6 .5 .8 .3 | |asynch descriptor resize 3 100.0 | |control file parallel wri 284 100.0| |control file sequential r 3743 30.3 46.6 9.3 11.6 1.8 .2 .1| |datafile move cleanup dur 1 100.0 | |db file async I/O submit 496 100.0| |db file sequential read 28 28.6 25.0 7.1 28.6 10.7 | |db file single write 11 100.0| |direct path sync 2 50.0 50.0| |get branch/thread/sequenc 1 100.0 | |latch free 265 .4 4.9 3.0 3.4 6.0 18.1 24.2 40.0| |log file parallel write 48 100.0| |log file sequential read 13 38.5 7.7 7.7 7.7 38.5 | |log file single write 2 100.0| |log file switch completio 2 100.0| |log file sync 1 100.0| |oracle thread bootstrap 2 100.0| |os thread creation 2 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 640 3.1 96.9| |Space Manager: slave idle 1474 .1 .5 .5 98.8| |Streams AQ: qmn coordinat 45 2.2 2.2 44.4 51.1| |Streams AQ: qmn slave idl 23 4.3 95.7| |class slave wait 48 2.1 2.1 95.8| |dispatcher timer 10 100.0| |heartbeat redo informer 600 100.0| |lreg timer 200 100.0| |pman timer 200 100.0| |pmon timer 400 100.0| |rdbms ipc message 3831 .5 .1 .0 .1 99.3| |smon timer 2 100.0| |wait for unread message o 600 100.0| |watchdog main loop 402 100.0| | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 64 us) DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 50.0 50.0 | |Data file init write 2 8.3 8.3 83.3| |Disk file operations I/O 12 16.7 11.1 27.8 11.1 33.3| |KSV master wait 22 4.0 6.0 2.0 8.0 24.0 56.0| |Log archive I/O 1 12.5 87.5| |PGA memory operation 1018 .9 7.5 15.9 27.3 21.5 17.1 9.8| |Redo Transport Open 1 100.0 | |SQL*Net message to client 638 .8 8.9 43.3 39.8 5.6 .5 .8 .3| |asynch descriptor resize 3 33.3 66.7 | |control file sequential r 3663 .7 10.4 19.1 46.6 9.3 11.6 2.1| |db file sequential read 17 7.1 21.4 25.0 7.1 39.3| |direct path sync 1 50.0 50.0| |get branch/thread/sequenc 1 100.0 | |latch free 31 .4 4.9 3.0 3.4 88.3| |log file sequential read 7 23.1 15.4 7.7 7.7 46.2| | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 32 ms) DB/Inst: DB/db1 Snaps: 360-361 | |-> 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| |------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----| |Data file init write 3 75.0 25.0 | |Disk file operations I/O 3 83.3 11.1 5.6 | |PGA memory operation 4 99.6 .4 | |control file parallel wri 284 69.4 30.6 | |control file sequential r 3 99.9 .1 .0 | |db file async I/O submit 496 91.5 8.5 | |db file single write 11 63.6 36.4 | |direct path sync 1 50.0 50.0 | |latch free 106 60.0 37.7 2.3 | |log file parallel write 48 77.1 20.8 2.1 | |log file single write 2 100.0 | |log file switch completio 2 100.0 | |log file sync 1 100.0 | |os thread creation 2 100.0 | | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 2 sec) DB/Inst: DB/db1 Snaps: 360-361 | |-> 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| |------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----| |oracle thread bootstrap 2 100.0 | | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 2 min) DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Wait Event Histogram (up to 1 hr) DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Service Statistics DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 15| |SYS$USERS 0 0 0 0| |db1XDB 0 0 0 0| | ------------------------------------------------------| | | |Service Wait Class Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 | | 0 0 0 0 0 0 640 0 | |SYS$BACKGROUND | | 76 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: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Top Process Types by Wait Class DB/Inst: DB/db1 Snaps: 360-361 | |-> This table displays top process types ordered by wait class | | | |Proce Description Wait Class Type Wait Time (sec | |----- ------------------------------ ---------------- -------------- | |CKPT checkpoint System I/O 1.8 | |DBW0 db writer process 0 System I/O 1.7 | |MMON Manageability Monitor Process System I/O .3 | |LGWR Redo etc. System I/O .2 | |W space management slave pool Other .1 | |MMON Manageability Monitor Process Other .1 | |ARC3 Archival Process 3 System I/O .0 | |ARC2 Archival Process 2 System I/O .0 | |ARC1 Archival Process 1 System I/O .0 | | Others (foregrounds + unclassi System I/O .0 | |CKPT checkpoint User I/O .0 | | Others (foregrounds + unclassi Other .0 | |ARC3 Archival Process 3 User I/O .0 | |W space management slave pool User I/O .0 | |ARC2 Archival Process 2 User I/O .0 | |ARC1 Archival Process 1 User I/O .0 | |W space management slave pool System I/O .0 | |PSP0 process spawner 0 Other .0 | |M MMON slave class 1 User I/O .0 | | Others (foregrounds + unclassi Network .0 | | ------------------------------------------------------| | | | | |Top Process Types by CPU Used DB/Inst: DB/db1 Snaps: 360-361 | |-> This table displays top process types ordered by CPU time | | | |Proces Description CPU Time (sec) | |------ ------------------------------ -------------- | |VKTM Virtual Keeper of TiMe process 15.6 | |M MMON slave class 1 4.8 | | Others (foregrounds + unclassi 4.6 | |DIA0 diagnosibility process 0 .9 | |DBRM DataBase Resource Manager .4 | |MMNL Manageability Monitor Process .3 | |P Parallel query slave .3 | |W space management slave pool .2 | |GEN1 generic1 .2 | |CKPT checkpoint .2 | |MMON Manageability Monitor Process .2 | |DBW0 db writer process 0 .2 | |PSP0 process spawner 0 .2 | |PMAN process manager .1 | |MZ MMON slave class 2 .1 | |CJQ0 Job Queue Coordinator .1 | |SMCO Space Manager Process .1 | |PMON process cleanup .1 | |TT* Redo Transport .1 | |DIAG diagnosibility process .0 | | ------------------------------------------------------| | | | | |SQL ordered by Elapsed Time DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 106.3% of Total DB Time (s): 5 | |-> Captured PL/SQL account for 1.1% of Total DB Time (s): 5 | | | | Elapsed Elapsed Time | | Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id | |---------------- -------------- ------------- ------ ------ ------ -------------| | 1.2 40 0.03 24.2 93.5 .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 | | | | 1.1 40 0.03 23.1 93.4 .0 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.6 40 0.02 12.8 90.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 12.0 87.9 .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 11.1 87.3 .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 9.3 88.0 .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 1 0.07 1.4 18.2 .0 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.1 964 0.00 1.4 97.8 .0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 0.1 1 0.05 1.1 99.1 .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 964 0.00 1.0 88.7 .0 csnp95dz2r8ss| |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | ------------------------------------------------------| | | | | |SQL ordered by CPU Time DB/Inst: DB/db1 Snaps: 360-361 | |-> 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.3% of Total CPU Time (s): 5 | |-> Captured PL/SQL account for 1.1% of Total CPU Time (s): 5 | | | | CPU CPU per Elapsed | | Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id | |---------- ------------ ---------- ------ ---------- ------ ------ -------------| | 1.1 40 0.03 23.8 1.2 93.5 .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 | | | | 1.0 40 0.03 22.7 1.1 93.4 .0 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.6 40 0.01 12.2 0.6 90.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.5 40 0.01 11.1 0.6 87.9 .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.2 0.5 87.3 .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.4 40 0.01 8.6 0.5 88.0 .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 964 0.00 1.4 0.1 97.8 .0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 0.1 1 0.05 1.2 0.1 99.1 .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 964 0.00 0.9 0.0 88.7 .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.8 0.0 100.2 .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: 360-361 | |-> 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.9% 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 1 0.00 1.3 0.0 88.5 10.8 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, | | | | 0.0 82 0.00 0.5 0.0 98.1 8.3 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 1 0.00 0.1 0.0 97.9 .2 b13g21mgg8y98| |insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, update| |s, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, s| |ystimestamp, dbms_stats_advisor.compute_volatile_flag( m.obj#, m.flags, :fla | |gs, m.inserts, m.updates, m.deletes, s.inserts, s.updates, s.deletes, null, | | | | 0.0 1 0.00 0.1 0.0 90.6 .2 a95n8p4vpxmps| |begin prvt_hdm.execute_slave_actions; end; | | | | 0.0 3 0.00 0.0 0.0 55.7 .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 3 0.00 0.0 0.0 91.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 | | | | 0.0 40 0.00 0.0 0.0 78.4 .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 | | | | 0.0 4 0.00 0.0 0.0 100.3 .0 1jbhwmbh7bp2n| |select /*+ no_monitor no_statement_queuing current_instance */ count(*) from | |sys.scheduler$_cdb_class where lower(affinity) = lower(:1) | | | | 0.0 40 0.00 0.0 0.6 87.9 .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.0 40 0.00 0.0 1.2 93.5 .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 | | | | ------------------------------------------------------| | | | | |SQL ordered by Gets DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 19,955 | |-> Captured SQL account for 79.5% of Total | | | | Buffer Gets Elapsed | | Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id | |----------- ----------- ------------ ------ ---------- ----- ----- -------------| | 4,979 1 4,979.0 25.0 0.1 18.2 0 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 22.3 1.1 93.4 0 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,197 1 1,197.0 6.0 0.0 90.6 .2 a95n8p4vpxmps| |begin prvt_hdm.execute_slave_actions; end; | | | | 1,187 1 1,187.0 5.9 0.0 94.6 0 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,125 964 1.2 5.6 0.1 97.8 0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 1,125 964 1.2 5.6 0.0 88.7 0 csnp95dz2r8ss| |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 798 1 798.0 4.0 0.0 88.5 10.8 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, | | | | 661 110 6.0 3.3 0.0 99.6 0 3dbzmtf9ahvzt| |merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using | | dual on (m.obj# | | = :objn and (:pobjn = 0 | | or m.obj# = :pobjn | | | | 531 1 531.0 2.7 0.0 95.8 0 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 | | | | 437 1 437.0 2.2 0.0 97.9 .2 b13g21mgg8y98| |insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, update| |s, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, s| |ystimestamp, dbms_stats_advisor.compute_volatile_flag( m.obj#, m.flags, :fla | |gs, m.inserts, m.updates, m.deletes, s.inserts, s.updates, s.deletes, null, | | | | 400 200 2.0 2.0 0.0 101.8 0 89w8y2pgn25yd| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select ts# from ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048 | | | | 354 82 4.3 1.8 0.0 98.1 8.3 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 Gets DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 19,955 | |-> Captured SQL account for 79.5% of Total | | | | Buffer Gets Elapsed | | Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id | |----------- ----------- ------------ ------ ---------- ----- ----- -------------| | | | 353 1 353.0 1.8 0.0 92.3 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 | | | | ------------------------------------------------------| | | | | |SQL ordered by Reads DB/Inst: DB/db1 Snaps: 360-361 | |-> %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: 12 | |-> Captured SQL account for 25.0% of Total | | | | Physical Reads Elapsed | | Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id | |----------- ----------- ---------- ------ ---------- ------ ------ -------------| | 2 82 0.0 16.7 0.0 98.1 8.3 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) | | | | 1 1 1.0 8.3 0.0 88.5 10.8 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, | | | | 0 3 0.0 0.0 0.0 55.7 .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 3 0.0 0.0 0.0 91.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 | | | | 0 40 0.0 0.0 0.0 78.4 .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 | | | | 0 4 0.0 0.0 0.0 100.3 .0 1jbhwmbh7bp2n| |select /*+ no_monitor no_statement_queuing current_instance */ count(*) from | |sys.scheduler$_cdb_class where lower(affinity) = lower(:1) | | | | 0 40 0.0 0.0 0.6 87.9 .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 40 0.0 0.0 1.2 93.5 .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 40 0.0 0.0 0.0 74.7 .0 35pqyw7uq9kfh| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select inst_id, count(*) as count from gv$process group by inst_id | | | | 0 2 0.0 0.0 0.0 100.2 .0 375k4awvyfjxu| |select tb.table_id_kewrtb, fl.flvl_int_kewflinfo from WRM$_TABLE_SETTINGS ts, | | x$kewrtb tb, x$kewflinfo fl where ts.dbid = :dbid and upper(ts.table_n | |ame) = upper(tb.table_name_kewrtb) and ts.flush_level_val = fl.flvl_val_kewfl | |info (+) | | | | ------------------------------------------------------| | | | | |SQL ordered by Physical Reads (UnOptimized) DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 12 | |-> Captured SQL account for 1.9E+04% of Total | |-> Total UnOptimized Read Requests: 12 | |-> Captured SQL account for 1.9E+04% 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+04 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 3.E+03 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 2.E+03 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 | | | | 2 2 82 0.0 0.0 16.7 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) | | | | 1 1 1 1.0 0.0 8.3 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, | | | | 0 0 3 0.0 N/A 0.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 3 0.0 N/A 0.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 | | | | 0 0 40 0.0 N/A 0.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 | | | | 0 0 4 0.0 N/A 0.0 1jbhwmbh7bp2n | |select /*+ no_monitor no_statement_queuing current_instance */ count(*) from | |sys.scheduler$_cdb_class where lower(affinity) = lower(:1) | | | | 0 0 40 0.0 N/A 0.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 | | | | ------------------------------------------------------| | | | | |SQL ordered by Executions DB/Inst: DB/db1 Snaps: 360-361 | |-> %CPU - CPU Time as a percentage of Elapsed Time | |-> %IO - User I/O Time as a percentage of Elapsed Time | |-> Total Executions: 3,501 | |-> Captured SQL account for 86.1% of Total | | | | Elapsed | | Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id | |------------ --------------- -------------- ---------- ----- ----- -------------| | 964 964 1.0 0.1 97.8 0 6xvp6nxs4a9n4| |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 964 0 0.0 0.0 88.7 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 101.8 0 89w8y2pgn25yd| |Module: oracledb_exporter@common-server (TNS V1-V3) | |select ts# from ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048 | | | | 110 110 1.0 0.0 99.6 0 3dbzmtf9ahvzt| |merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using | | dual on (m.obj# | | = :objn and (:pobjn = 0 | | or m.obj# = :pobjn | | | | 82 82 1.0 0.0 98.1 8.3 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 78.4 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.6 87.9 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 93.5 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 74.7 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 97.6 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 67.1 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.5 88 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) | | | | | |SQL ordered by Executions DB/Inst: DB/db1 Snaps: 360-361 | |-> %CPU - CPU Time as a percentage of Elapsed Time | |-> %IO - User I/O Time as a percentage of Elapsed Time | |-> Total Executions: 3,501 | |-> Captured SQL account for 86.1% of Total | | | | Elapsed | | Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id | |------------ --------------- -------------- ---------- ----- ----- -------------| | 40 40 1.0 0.6 90.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' | | | | 40 160 4.0 0.5 87.3 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.0 66.5 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 75.3 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.1 93.4 0 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: 360-361 | |-> Total Parse Calls: 2,712 | |-> Captured SQL account for 91.1% of Total | | | | % Total | | Parse Calls Executions Parses SQL Id | |------------ ------------ --------- ------------- | | 964 964 35.55 6xvp6nxs4a9n4 | |select nvl(sum(space),0) from recyclebin$ where ts# = :1 | | | | 964 964 35.55 csnp95dz2r8ss | |select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and bloc | |k# != 0 and space = 0 | | | | 200 200 7.37 89w8y2pgn25yd | |Module: oracledb_exporter@common-server (TNS V1-V3) | |select ts# from ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048 | | | | 110 110 4.06 3dbzmtf9ahvzt | |merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using | | dual on (m.obj# | | = :objn and (:pobjn = 0 | | or m.obj# = :pobjn | | | | 82 82 3.02 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.74 gjaap3w3qbf8c | |select count(*) from ilmobj$ where rownum = 1 | | | | 18 18 0.66 fs4p95w7yg25b | |select pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.o | |bj# and tp.obj# = :oid | | | | 17 17 0.63 fkc81h2686aqc | |select pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.o | |bj# and ip.obj# = :oid | | | | 15 15 0.55 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.37 7am4w4pp3nwtm | |select count(*) from undo$ | | | | ------------------------------------------------------| | | | | |SQL ordered by Sharable Memory DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |SQL ordered by Version Count DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Key Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |db block changes 9,111 15.2 607.4| |execute count 3,501 5.8 233.4| |logons cumulative 2 0.0 0.1| |opened cursors cumulative 2,901 4.8 193.4| |parse count (total) 2,712 4.5 180.8| |parse time elapsed 1 0.0 0.1| |physical reads 12 0.0 0.8| |physical writes 2,108 3.5 140.5| |redo size 3,017,704 5,024.7 201,180.3| |session cursor cache hits 2,656 4.4 177.1| |session logical reads 19,955 33.2 1,330.3| |user calls 652 1.1 43.5| |user commits 15 0.0 1.0| |workarea executions - optimal 866 1.4 57.7| | ------------------------------------------------------| | | | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |ASSM bg: segment fix monitor 1 0.0 0.1| |ASSM cbk:blocks examined 338 0.6 22.5| |ASSM cbk:blocks marked full 91 0.2 6.1| |ASSM gsp:L1 bitmaps examined 255 0.4 17.0| |ASSM gsp:L2 bitmap full 0 0.0 0.0| |ASSM gsp:L2 bitmaps examined 65 0.1 4.3| |ASSM gsp:Search all 1 0.0 0.1| |ASSM gsp:Search hint 3 0.0 0.2| |ASSM gsp:Search steal 1 0.0 0.1| |ASSM gsp:bump HWM 1 0.0 0.1| |ASSM gsp:get free block 247 0.4 16.5| |ASSM gsp:get free data block 190 0.3 12.7| |ASSM gsp:get free index block 57 0.1 3.8| |ASSM gsp:good hint 196 0.3 13.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 16 0.0 1.1| |CCursor + sql area evicted 1 0.0 0.1| |CPU used by this session 1,028 1.7 68.5| |CPU used when call started 444 0.7 29.6| |CR blocks created 16 0.0 1.1| |Cached Commit SCN referenced 0 0.0 0.0| |Client Advertised Receive Window 0 0.0 0.0| |Client Advertised Send Window 0 0.0 0.0| |Client Data Segments In 548 0.9 36.5| |Client Data Segments Out 548 0.9 36.5| |Client Path Maximum Transmission 0 0.0 0.0| |Client Send Congestion Window 0 0.0 0.0| |Client Time (usec) Busy Sending 4,627,000 7,704.3 308,466.7| |Client Time (usec) Last Data Sen 14 0.0 0.9| |Client Time (usec) Round Trip Ti 7,129 11.9 475.3| |Client Time (usec) Round Trip Ti 7,350 12.2 490.0| |Client Total Bytes Acked 16,572 27.6 1,104.8| |Client Total Bytes Received 203,179 338.3 13,545.3| |DBWR checkpoint buffers written 2,108 3.5 140.5| |DBWR checkpoints 0 0.0 0.0| |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 1,516 2.5 101.1| |DDL statements parallelized 0 0.0 0.0| |DFO trees parallelized 0 0.0 0.0| |DML statements retried 0 0.0 0.0| |Effective IO time 0 0.0 0.0| |HSC Heap Segment Block Changes 657 1.1 43.8| |Heap Segment Array Deletes 0 0.0 0.0| |Heap Segment Array Inserts 126 0.2 8.4| |Heap Segment Array Updates 2 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| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |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| |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 137 0.2 9.1| |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 137 0.2 9.1| |KTFB alloc req 11 0.0 0.7| |KTFB alloc space (block) 1,703,936 2,837.2 113,595.7| |KTFB alloc time (ms) 277 0.5 18.5| |KTFB apply req 9 0.0 0.6| |KTFB apply time (ms) 30 0.1 2.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| |PX local messages recv'd 0 0.0 0.0| |PX local messages sent 0 0.0 0.0| |Parallel operations not downgrad 0 0.0 0.0| |Requests to/from client 640 1.1 42.7| |SMON posted for undo segment shr 0 0.0 0.0| |SQL*Net roundtrips to/from clien 640 1.1 42.7| |TBS Extension: bytes extended 10,485,760 17,459.5 699,050.7| |TBS Extension: files extended 1 0.0 0.1| |TBS Extension: tasks created 1 0.0 0.1| |TBS Extension: tasks executed 1 0.0 0.1| |active txn count during cleanout 125 0.2 8.3| |auto extends on undo tablespace 0 0.0 0.0| |background checkpoints completed 2 0.0 0.1| |background checkpoints started 0 0.0 0.0| |background timeouts 3,753 6.3 250.2| |blocks cleaned out using minact 289 0.5 19.3| |branch node splits 0 0.0 0.0| |buffer is not pinned count 6,632 11.0 442.1| |buffer is pinned count 5,354 8.9 356.9| |bytes received via SQL*Net from 12,648 21.1 843.2| |bytes sent via SQL*Net to client 228,909 381.2 15,260.6| |calls to get snapshot scn: kcmgs 3,623 6.0 241.5| |calls to kcmgas 521 0.9 34.7| |calls to kcmgcs 1,595 2.7 106.3| |cell physical IO interconnect by 100,867,584 167,951.4 6,724,505.6| |change write time 2 0.0 0.1| |cleanout - number of ktugct call 131 0.2 8.7| |cleanouts and rollbacks - consis 0 0.0 0.0| |cleanouts only - consistent read 4 0.0 0.3| |cluster key scan block gets 63 0.1 4.2| |cluster key scans 63 0.1 4.2| |commit batch/immediate performed 1 0.0 0.1| |commit batch/immediate requested 1 0.0 0.1| |commit cleanout failures: block 0 0.0 0.0| |commit cleanout failures: buffer 0 0.0 0.0| |commit cleanout failures: callba 16 0.0 1.1| |commit cleanout failures: cannot 0 0.0 0.0| |commit cleanouts 644 1.1 42.9| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |commit cleanouts successfully co 628 1.1 41.9| |commit immediate performed 1 0.0 0.1| |commit immediate requested 1 0.0 0.1| |commit txn count during cleanout 61 0.1 4.1| |consistent changes 77 0.1 5.1| |consistent gets 8,599 14.3 573.3| |consistent gets direct 0 0.0 0.0| |consistent gets examination 1,567 2.6 104.5| |consistent gets examination (fas 1,507 2.5 100.5| |consistent gets from cache 8,599 14.3 573.3| |consistent gets pin 7,032 11.7 468.8| |consistent gets pin (fastpath) 6,949 11.6 463.3| |cursor authentications 0 0.0 0.0| |cursor reload failures 0 0.0 0.0| |data blocks consistent reads - u 29 0.1 1.9| |db block changes 9,111 15.2 607.4| |db block gets 11,356 18.9 757.1| |db block gets direct 0 0.0 0.0| |db block gets from cache 11,356 18.9 757.1| |db block gets from cache (fastpa 8,042 13.4 536.1| |deferred (CURRENT) block cleanou 397 0.7 26.5| |dirty buffers inspected 0 0.0 0.0| |enqueue conversions 122 0.2 8.1| |enqueue releases 7,168 11.9 477.9| |enqueue requests 7,166 11.9 477.7| |enqueue timeouts 0 0.0 0.0| |enqueue waits 0 0.0 0.0| |execute count 3,501 5.8 233.4| |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 208 0.4 13.9| |heap block compress 2 0.0 0.1| |hot buffers moved to head of LRU 0 0.0 0.0| |immediate (CR) block cleanout ap 4 0.0 0.3| |immediate (CURRENT) block cleano 153 0.3 10.2| |index crx upgrade (positioned) 0 0.0 0.0| |index fast full scans (full) 0 0.0 0.0| |index fetch by key 1,222 2.0 81.5| |index range scans 2,142 3.6 142.8| |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 3.9| |lob reads 7 0.0 0.5| |lob writes 8 0.0 0.5| |lob writes unaligned 8 0.0 0.5| |logical read bytes from cache 163,471,360 272,191.0 10,898,090.7| |logons cumulative 2 0.0 0.1| |max cf enq hold time 0 0.0 0.0| |messages received 541 0.9 36.1| |messages sent 541 0.9 36.1| |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 4,283 7.1 285.5| |non-idle wait count 6,692 11.1 446.1| |opened cursors cumulative 2,901 4.8 193.4| |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,712 4.5 180.8| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |parse time cpu 4 0.0 0.3| |parse time elapsed 1 0.0 0.1| |physical read IO requests 12 0.0 0.8| |physical read bytes 98,304 163.7 6,553.6| |physical read total IO requests 3,744 6.2 249.6| |physical read total bytes 61,104,128 101,742.5 4,073,608.5| |physical read total multi block 0 0.0 0.0| |physical reads 12 0.0 0.8| |physical reads cache 12 0.0 0.8| |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 496 0.8 33.1| |physical write bytes 17,268,736 28,753.6 1,151,249.1| |physical write total IO requests 1,107 1.8 73.8| |physical write total bytes 39,763,456 66,208.9 2,650,897.1| |physical write total multi block 109 0.2 7.3| |physical writes 2,108 3.5 140.5| |physical writes direct 0 0.0 0.0| |physical writes direct (lob) 0 0.0 0.0| |physical writes from cache 2,108 3.5 140.5| |physical writes non checkpoint 1,546 2.6 103.1| |pinned buffers inspected 0 0.0 0.0| |prefetched blocks aged out befor 0 0.0 0.0| |process last non-idle time 601 1.0 40.1| |recursive calls 10,904 18.2 726.9| |recursive cpu usage 57 0.1 3.8| |redo KB read 0 0.0 0.0| |redo blocks checksummed by FG (e 3,014 5.0 200.9| |redo blocks written 5,999 10.0 399.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 0 0.0 0.0| |redo entries 5,138 8.6 342.5| |redo log space requests 0 0.0 0.0| |redo ordering marks 0 0.0 0.0| |redo size 3,017,704 5,024.7 201,180.3| |redo size for direct writes 0 0.0 0.0| |redo subscn max counts 0 0.0 0.0| |redo synch long waits 0 0.0 0.0| |redo synch time 0 0.0 0.0| |redo synch time (usec) 2,594 4.3 172.9| |redo synch time overhead (usec) 35 0.1 2.3| |redo synch time overhead count ( 1 0.0 0.1| |redo synch time overhead count ( 0 0.0 0.0| |redo synch time overhead count ( 0 0.0 0.0| |redo synch writes 2 0.0 0.1| |redo wastage 12,824 21.4 854.9| |redo write active strands 47 0.1 3.1| |redo write finish time 160,412 267.1 10,694.1| |redo write gather time 569 1.0 37.9| |redo write info find 1 0.0 0.1| |redo write schedule time 736 1.2 49.1| |redo write size count ( 4KB) 23 0.0 1.5| |redo write size count ( 8KB) 3 0.0 0.2| |redo write size count ( 16KB) 9 0.0 0.6| |redo write size count ( 32KB) 2 0.0 0.1| |redo write size count ( 128KB) 6 0.0 0.4| |redo write size count ( 256KB) 2 0.0 0.1| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |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 16 0.0 1.1| |redo write time (usec) 160,508 267.3 10,700.5| |redo write total time 161,126 268.3 10,741.7| |redo write worker delay (usec) 0 0.0 0.0| |redo write worker delay count 0 0.0 0.0| |redo writes 47 0.1 3.1| |redo writes (group 0) 0 0.0 0.0| |redo writes (group 1) 0 0.0 0.0| |redo writes adaptive all 47 0.1 3.1| |redo writes adaptive worker 0 0.0 0.0| |remote Oradebug requests 0 0.0 0.0| |rollback changes - undo records 2 0.0 0.1| |rollbacks only - consistent read 16 0.0 1.1| |root node splits 0 0.0 0.0| |rows fetched via callback 818 1.4 54.5| |securefile allocation bytes 0 0.0 0.0| |securefile allocation chunks 0 0.0 0.0| |securefile bytes non-transformed 3,944 6.6 262.9| |securefile direct read bytes 0 0.0 0.0| |securefile direct read ops 0 0.0 0.0| |securefile direct write bytes 0 0.0 0.0| |securefile direct write ops 0 0.0 0.0| |securefile number of non-transfo 5 0.0 0.3| |segment cfs allocations 0 0.0 0.0| |segment chunks allocation from d 0 0.0 0.0| |segment dispenser allocations 0 0.0 0.0| |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 0 0.0 0.0| |segment prealloc tasks 0 0.0 0.0| |segment prealloc time (ms) 0 0.0 0.0| |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,656 4.4 177.1| |session logical reads 19,955 33.2 1,330.3| |shared hash latch upgrades - no 100 0.2 6.7| |shared io pool buffer get succes 0 0.0 0.0| |sorts (memory) 884 1.5 58.9| |sorts (rows) 108,898 181.3 7,259.9| |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 8 0.0 0.5| |switch current to new buffer 8 0.0 0.5| |table fetch by rowid 4,011 6.7 267.4| |table fetch continued row 0 0.0 0.0| |table scan blocks gotten 2,795 4.7 186.3| |table scan disk non-IMC rows got 169,017 281.4 11,267.8| |table scan rows gotten 169,017 281.4 11,267.8| |table scans (direct read) 0 0.0 0.0| |table scans (long tables) 0 0.0 0.0| |table scans (rowid ranges) 0 0.0 0.0| |table scans (short tables) 429 0.7 28.6| |total cf enq hold time 551 0.9 36.7| |total number of cf enq holders 220 0.4 14.7| | | |Instance Activity Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> Ordered by statistic name | | | |Statistic Total per Second per Trans| |-------------------------------- ------------------ -------------- -------------| |total number of times SMON poste 0 0.0 0.0| |transaction rollbacks 1 0.0 0.1| |transaction tables consistent re 0 0.0 0.0| |transaction tables consistent re 0 0.0 0.0| |undo change vector size 1,054,616 1,756.0 70,307.7| |user calls 652 1.1 43.5| |user commits 15 0.0 1.0| |user logons cumulative 0 0.0 0.0| |user logouts cumulative 0 0.0 0.0| |workarea executions - optimal 866 1.4 57.7| |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: 360-361 | |-> Statistics with absolute values (should not be diffed) | | | |Statistic Begin Value End Value | |-------------------------------- --------------- --------------- | |logons current 65 64 | |opened cursors current 267 260 | |session cursor cache count 15,467 15,512 | |session pga memory 368,734,520 321,483,624 | |session pga memory max 541,162,424 490,438,120 | |session uga memory 456,878,608 437,293,256 | |session uga memory max 2,566,874,520 2,568,795,448 | | ------------------------------------------------------| | | |Instance Activity Stats - Thread Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 360-361 | |-> '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 67M 6.3 .112M 24M 1.0 .04M 4339 506.53us| |DBWR 0M 0.0 0M 17M 0.8 .028M 502 1.99us| |LGWR 0M 0.0 0M 3M 0.1 .005M 128 1.59ms| |Buffer Cache Re 0M 0.0 0M 0M 0.0 0M 16 162.63us| |TOTAL: 67M 6.3 .112M 44M 1.9 .073M 4985 482.47us| | ------------------------------------------------------| | | |IOStat by Filetype summary DB/Inst: DB/db1 Snaps: 360-361 | |-> '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 60M 6.2 .1M 9M 0.9 .015M 266.95ns .00ns| |Data File 0M 0.1 0M 18M 0.8 .03M .00ns | |Log File 6M 0.0 .01M 2M 0.1 .003M .00ns .00ns| |Archive Log 0M 0.0 0M 6M 0.0 .01M | |TOTAL: 66M 6.3 .11M 35M 1.9 .058M 264.20ns .00ns| | ------------------------------------------------------| | | |IOStat by Function/Filetype summary DB/Inst: DB/db1 Snaps: 360-361 | |-> '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 | | 67M 6.3 .112M 24M 1.0 .04M 3771 26.93us | | Others (Control File) | | 60M 6.2 .1M 8M 0.9 .013M 3732 17.33us | | Others (Data File) | | 1M 0.0 .002M 10M 0.0 .017M 28 1.29ms | | Others (Archive Log) | | 0M 0.0 0M 6M 0.0 .01M 0 | | Others (Log File) | | 6M 0.0 .01M 0M 0.0 0M 11 82.09us | | DBWR (Data File) | | 0M 0.0 0M 17M 0.8 .028M 0 | |DBWR | | 0M 0.0 0M 17M 0.8 .028M 6 .00ns | | DBWR (Control File) | | 0M 0.0 0M 0M 0.0 0M 6 .00ns | |LGWR | | 0M 0.0 0M 3M 0.1 .005M 14 343.36us | | LGWR (Log File) | | 0M 0.0 0M 2M 0.1 .003M 4 1.19ms | | LGWR (Control File) | | 0M 0.0 0M 1M 0.0 .002M 10 6.40us | | Buffer Cache Reads (Data File) | | 0M 0.0 0M 0M 0.0 0M 16 162.63us | |Buffer Cache Reads | | 0M 0.0 0M 0M 0.0 0M 16 162.63us | |TOTAL: | | 67M 6.3 .112M 44M 1.9 .073M 3807 28.63us | | ------------------------------------------------------| | | | | |Tablespace IO Stats DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |File IO Stats DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Buffer Pool Statistics DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 100 19,911 13 2,108 0 0 0| | ------------------------------------------------------| | | |Checkpoint Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> Total Physical Writes: 2,108 | | | | Other Autotune Thread | | MTTR Log Size Log Ckpt Settings Ckpt Ckpt | | Writes Writes Writes Writes Writes Writes | |----------- ----------- ----------- ----------- ----------- ----------- | | 0 0 0 0 2,108 0 | | ------------------------------------------------------| | | |Instance Recovery Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 13 1623 26089 33129 33129 65289 N/A N/A N/A| |E 0 11 288 658 33129 33129 65643 N/A N/A N/A| | ------------------------------------------------------| | | |MTTR Advisory DB/Inst: DB/db1 Snap: 361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffer Pool Advisory DB/Inst: DB/db1 Snap: 361 | |-> 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,609,717 1 3.9E+05 | |D 320 .2 39 3.E+04 3,087,451 1 2.6E+05 | |D 480 .3 59 3.E+04 3,087,409 1 2.6E+05 | |D 640 .4 78 1.9 213 1 11.0 | |D 800 .5 98 1.3 143 1 5.0 | |D 960 .6 117 1.2 127 1 4.0 | |D 1,120 .6 137 1.1 120 1 3.0 | |D 1,280 .7 157 1.0 115 1 2.0 | |D 1,440 .8 176 1.0 110 1 2.0 | |D 1,600 .9 196 1.0 110 1 2.0 | |D 1,728 1.0 211 1.0 110 1 2.0 | |D 1,760 1.0 215 1.0 110 1 2.0 | |D 1,920 1.1 235 1.0 110 1 2.0 | |D 2,080 1.2 255 1.0 110 1 2.0 | |D 2,240 1.3 274 1.0 110 1 2.0 | |D 2,400 1.4 294 1.0 110 1 2.0 | |D 2,560 1.5 313 1.0 110 1 2.0 | |D 2,720 1.6 333 1.0 110 1 2.0 | |D 2,880 1.7 352 1.0 110 1 2.0 | |D 3,040 1.8 372 1.0 109 1 2.0 | |D 3,200 1.9 392 1.0 109 1 2.0 | | ------------------------------------------------------| | | | | |PGA Aggr Summary DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 323 0 | | ------------------------------------------------------| | | |PGA Aggr Target Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 414 555.3 0.0 .0 .0 .0 102,400 | |E 793 448 506.3 0.0 .0 .0 .0 102,400 | | ------------------------------------------------------| | | |PGA Aggr Target Histogram DB/Inst: DB/db1 Snaps: 360-361 | |-> Optimal Executions are purely in-memory operations | | | | Low High | |Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs | |------- ------- -------------- -------------- ------------ ------------ | | 2K 4K 590 590 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 259 259 0 0 | | ------------------------------------------------------| | | |PGA Memory Advisory DB/Inst: DB/db1 Snap: 361 | |-> 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 89,587.0 1,170.2 99.0 36 1.4E+05 | | 198 0.3 89,587.0 1,170.2 99.0 36 1.4E+05 | | 397 0.5 89,587.0 222.0 100.0 0 1.3E+05 | | 595 0.8 89,587.0 131.0 100.0 0 1.3E+05 | | 793 1.0 89,587.0 0.0 100.0 0 1.3E+05 | | 952 1.2 89,587.0 0.0 100.0 0 1.3E+05 | | 1,110 1.4 89,587.0 0.0 100.0 0 1.3E+05 | | 1,269 1.6 89,587.0 0.0 100.0 0 1.3E+05 | | 1,427 1.8 89,587.0 0.0 100.0 0 1.3E+05 | | 1,586 2.0 89,587.0 0.0 100.0 0 1.3E+05 | | 2,379 3.0 89,587.0 0.0 100.0 0 1.3E+05 | | 3,172 4.0 89,587.0 0.0 100.0 0 1.3E+05 | | 4,758 6.0 89,587.0 0.0 100.0 0 1.3E+05 | | 6,344 8.0 89,587.0 0.0 100.0 0 1.3E+05 | | ------------------------------------------------------| | | | | |Shared Pool Advisory DB/Inst: DB/db1 Snap: 361 | |-> 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 31 1,440 7,376 1.0 99 4.7 4,715| | 448 .9 47 1,838 7,400 1.0 75 3.6 4,717| | 464 .9 63 2,476 7,418 1.0 57 2.7 4,717| | 480 1.0 79 4,008 7,435 1.0 40 1.9 4,718| | 496 1.0 94 5,354 7,454 1.0 21 1.0 4,719| | 512 1.0 110 5,806 7,454 1.0 21 1.0 4,719| | 528 1.1 126 6,117 7,454 1.0 21 1.0 4,720| | 544 1.1 142 6,494 7,454 1.0 21 1.0 4,721| | 560 1.1 158 6,871 7,454 1.0 21 1.0 4,721| | 576 1.2 174 7,694 7,454 1.0 21 1.0 4,721| | 592 1.2 190 8,922 7,454 1.0 21 1.0 4,721| | 608 1.2 205 9,559 7,454 1.0 21 1.0 4,721| | 624 1.3 220 10,196 7,454 1.0 21 1.0 4,721| | 640 1.3 221 10,259 7,454 1.0 21 1.0 4,721| | 688 1.4 221 10,259 7,454 1.0 21 1.0 4,721| | 752 1.5 221 10,259 7,454 1.0 21 1.0 4,721| | 816 1.6 221 10,259 7,454 1.0 21 1.0 4,721| | 880 1.8 221 10,259 7,454 1.0 21 1.0 4,721| | 944 1.9 221 10,259 7,454 1.0 21 1.0 4,721| | 1,008 2.0 221 10,259 7,454 1.0 21 1.0 4,721| | ------------------------------------------------------| | | |SGA Target Advisory DB/Inst: DB/db1 Snap: 361 | | | |SGA Target SGA Size Est DB Est Physical | | Size (M) Factor Time (s) Reads | |---------- ---------- ------------ ---------------- | | 1,192 0.5 329,432 3,087,369,687 | | 1,788 0.8 68,864 120,415 | | 2,384 1.0 68,864 110,220 | | 2,980 1.3 68,864 109,636 | | 3,576 1.5 68,864 109,504 | | 4,172 1.8 68,864 109,162 | | 4,768 2.0 68,864 109,162 | | ------------------------------------------------------| | | |Streams Pool Advisory DB/Inst: DB/db1 Snap: 361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Java Pool Advisory DB/Inst: DB/db1 Snap: 361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffer Wait Statistics DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Enqueue Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 | | 955 955 0 0 0 N/A | |SJ-KTSJ Slave Task Cancel (Slave Task Cancel) | | 399 412 0 0 0 N/A | |TM-DML | | 282 282 0 0 0 N/A | |JG-Job Scheduler1 (q mem clnup lck) | | 240 240 0 0 0 N/A | |TX-Transaction | | 209 209 0 0 0 N/A | |WF-AWR Flush | | 20 20 0 0 0 N/A | |HW-Segment High Water Mark | | 18 18 0 0 0 N/A | |WT-AWR CDB-Wide Table Lock | | 18 18 0 0 0 N/A | |TT-Tablespace | | 17 17 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 | |FB-Format Block | | 6 6 0 0 0 N/A | |MR-Media Recovery | | 4 4 0 0 0 N/A | |SE-Session Migration | | 3 3 0 0 0 N/A | |AE-Edition Lock (lock) | | 2 2 0 0 0 N/A | |IS-Instance State | | 2 2 0 0 0 N/A | |PR-Process Startup | | 2 2 0 0 0 N/A | |PV-KSV slave startup (syncstart) | | 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 | |CT-Block Change Tracking (CTWR process start/stop) | | 1 1 0 0 0 N/A | |CT-Block Change Tracking (state) | | 1 1 0 0 0 N/A | |CU-Cursor | | 1 1 0 0 0 N/A | |FD-Flashback Database (Flashback logical operations) | | 1 1 0 0 0 N/A | |FP-File Object (global fob contention) | | 1 1 0 0 0 N/A | |MV-Online Datafile Move (datafile move) | | 1 1 0 0 0 N/A | |RS-Reclaimable Space (read alert level) | | 1 1 0 0 0 N/A | | | |Enqueue Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> 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) | |------------ ------------ ----------- ----------- ------------ -------------- | |SQ-Sequence Cache | | 1 1 0 0 0 N/A | |SW-Suspend Writes | | 1 1 0 0 0 N/A | |TD-KTF map table enqueue (KTF dump entries) | | 1 1 0 0 0 N/A | |WL-Being Written Redo Log | | 1 1 0 0 0 N/A | | ------------------------------------------------------| | | | | |Undo Segment Summary DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Undo Segment Stats DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Latch Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> "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 400 0.0 0 0 N/A| |ASM map operation hash t 1 0.0 0 0 N/A| |ASM network state latch 10 0.0 0 0 N/A| |ASM remote client latch 10 0.0 0 0 N/A| |AWR Alerted Metric Eleme 4,892 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 47 0.0 0 0 N/A| |DML lock allocation 1,014 0.0 0 0 N/A| |Event Group Locks 5 0.0 0 0 N/A| |FAL Queue 32 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 45 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 137 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: 360-361 | |-> "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 11 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 189 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 45 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 188 0.0 0 0 N/A| |OS process 222 0.0 0 0 N/A| |OS process allocation 1,207 0.0 0 0 N/A| |OS process: request allo 5 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: 360-361 | |-> "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| |Real-time descriptor lat 360 0.0 0 0 N/A| |Report Request stats lat 40 0.0 0 0 N/A| |Request holder compeltio 5 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 8 0.0 0 3 0.0| |SQL memory manager latch 1 0.0 0 200 0.0| |SQL memory manager worka 16,390 0.0 0 0 N/A| |SR Stats Stripe Latch 1 0.0 0 0 N/A| |Sched IM Job latch 11 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 704 0.0 0 0 N/A| |active service list 1,893 0.0 0 391 0.0| |archive destination 20 0.0 0 0 N/A| |archive process 39 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 40 0.0 0 0 N/A| |cache buffers chains 59,920 0.0 0 237 0.0| |cache buffers lru chain 2,136 0.0 0 2,368 0.0| |call allocation 134 0.7 0.0 0 0 N/A| |change notification clie 1 0.0 0 0 N/A| |channel handle pool latc 11 0.0 0 0 N/A| |channel operations paren 21 0.0 0 0 N/A| |checkpoint queue latch 12,802 0.0 0 751 0.0| |client/application info 53 0.0 0 0 N/A| |compile environment latc 2 0.0 0 0 N/A| |corrupted undo seg latch 7 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 10 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| |cr slave free list 1 0.0 0 0 N/A| |cvmap freelist lock 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> "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| |------------------------ -------------- ------ ------ ------ ------------ ------| |deferred cleanup latch 10 0.0 0 0 N/A| |dispatcher info 2 0.0 0 0 N/A| |dml lock allocation 10 0.0 0 0 N/A| |done queue latch 1 0.0 0 0 N/A| |dtp latch 5 0.0 0 0 N/A| |dummy allocation 6 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,330 0.2| |enqueue hash chains 14,532 0.1 0.0 0 0 N/A| |fifteenth spare latch - 1 0.0 0 0 N/A| |file cache latch 4,239 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 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 Sql Plan Find 11 0.0 0 0 N/A| |hash table column usage 4 0.0 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| |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 metadata 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> "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| |------------------------ -------------- ------ ------ ------ ------------ ------| |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| |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 7 0.0 0 0 N/A| |kjci process context lat 5 0.0 0 1,699 0.0| |kjci process list latch 2 0.0 0 0 N/A| |kjci request sequence la 1 0.0 0 0 N/A| |kjoedcso state object fr 10 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| |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 5 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 19 0.0 0 0 N/A| |ksv class latch 357 3.6 0.1 0 0 N/A| |ksv msg queue latch 51 0.0 0 50 0.0| |ksz_so allocation latch 5 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 228 0.0 0 0 N/A| |list of block allocation 25 0.0 0 0 N/A| |lob segment dispenser la 1 0.0 0 0 N/A| |lob segment hash table l 13 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 47 0.0| |log write worker phase 1 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> "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| |------------------------ -------------- ------ ------ ------ ------------ ------| |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,704 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 10 0.0 0 0 N/A| |ninth spare latch - X pa 1 0.0 0 0 N/A| |object queue header free 28 0.0 0 0 N/A| |object queue header oper 5,235 0.0 0 0 N/A| |object queue memory 1 0.0 0 0 N/A| |object stats modificatio 3 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 5 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 10 0.0 0 0 N/A| |post/wait queue 1,859 1.1 0.0 0 2,082 2.2| |process allocation 7 0.0 0 0 N/A| |process group creation 5 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 91 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 433 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 509 0.2 0.0 0 5,130 0.0| |redo copy 1 0.0 0 5,130 0.0| |redo transport task 43 0.0 0 0 N/A| |redo writing 1,257 0.0 0 0 N/A| |remote tool request latc 3 0.0 0 0 N/A| |resmgr:active threads 17 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 5 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| |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 14 0.0 0 0 N/A| |service drain list 601 0.0 0 0 N/A| | | |Latch Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> "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| |------------------------ -------------- ------ ------ ------ ------------ ------| |session allocation 570 0.0 0 567 0.4| |session idle bit 2,441 0.0 0 0 N/A| |session queue latch 1 0.0 0 0 N/A| |session state list latch 9 0.0 0 0 N/A| |session statistics 6 0.0 0 0 N/A| |session switching 14 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,103 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 200 0.0 0 0 N/A| |sim partition latch 1 0.0 0 0 N/A| |simulator hash latch 3,150 0.0 0 0 N/A| |simulator lru latch 2,109 0.0 0 1,021 0.0| |sixth spare latch - X pa 1 0.0 0 0 N/A| |sort extent pool 120 0.0 0 0 N/A| |space background task la 1,263 49.6 0.4 0 401 0.2| |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| |temporary table state ob 1 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 20 0.0 0 0 N/A| |transaction allocation 21 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 1,100 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: 360-361 | |-> ordered by misses desc | | | | Get Spin | |Latch Name Requests Misses Sleeps Gets | |-------------------------- --------------- ------------ ----------- ----------- | |space background task latc 1,263 627 265 363 | |ksv class latch 357 13 1 12 | | ------------------------------------------------------| | | | | |Latch Miss Sources DB/Inst: DB/db1 Snaps: 360-361 | |-> only latches with sleeps are shown | |-> ordered by name, sleeps desc | | | | NoWait Waiter | |Latch Name Where Misses Sleeps Sleeps | |------------------------ -------------------------- ------- ---------- -------- | |ksv class latch ksvclsl: rdp - recycle 0 1 0 | |space background task la ktsj_grab_task 0 178 262 | |space background task la ktsj_detach_task 0 86 3 | |space background task la ktsj_smco_purgeexpired 0 1 0 | | ------------------------------------------------------| | | |Mutex Sleep Summary DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Parent Latch Statistics DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Child Latch Statistics DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Segments by Logical Reads DB/Inst: DB/db1 Snaps: 360-361 | |-> Total Logical Reads: 19,955 | |-> Captured Segments account for 86.5% 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.89| |SYS SYSTEM | |RECYCLEBIN$_TS INDEX 265 265 1,872 9.38| |SYS SYSAUX | |WRH$_LATCH_PK 9277899_86 INDEX 73737 73737 1,776 8.90| |SYS SYSTEM | |TS$ TABLE 16 6 1,472 7.38| |SYS SYSAUX | |WRH$_SQL_PLAN TABLE 11147 11147 800 4.01| | ------------------------------------------------------| | | |Segments by Physical Reads DB/Inst: DB/db1 Snaps: 360-361 | |-> Total Physical Reads: 12 | |-> Captured Segments account for 116.7% 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 | |WRH$_CON_SYSSTAT 9277899_86 TABLE 73847 73847 2 16.67| |SYS SYSAUX | |WRH$_PROCESS_WAITTIM 9277899_86 TABLE 73855 73855 2 16.67| |SYS SYSAUX | |WRH$_BG_EVENT_SUMMAR INDEX 11172 11172 1 8.33| |SYS SYSAUX | |WRH$_CON_SYSTEM_EVEN 9277899_86 TABLE 73851 73851 1 8.33| |SYS SYSAUX | |WRH$_CON_SYSTEM_EVEN 9277899_86 INDEX 73853 73853 1 8.33| | ------------------------------------------------------| | | |Segments by Physical Read Requests DB/Inst: DB/db1 Snaps: 360-361 | |-> Total Physical Read Requests: 12 | |-> Captured Segments account for 116.7% 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 | |WRH$_CON_SYSSTAT 9277899_86 TABLE 73847 73847 2 16.67| |SYS SYSAUX | |WRH$_PROCESS_WAITTIM 9277899_86 TABLE 73855 73855 2 16.67| |SYS SYSAUX | |WRH$_BG_EVENT_SUMMAR INDEX 11172 11172 1 8.33| |SYS SYSAUX | |WRH$_CON_SYSTEM_EVEN 9277899_86 TABLE 73851 73851 1 8.33| |SYS SYSAUX | |WRH$_CON_SYSTEM_EVEN 9277899_86 INDEX 73853 73853 1 8.33| | ------------------------------------------------------| | | |Segments by UnOptimized Reads DB/Inst: DB/db1 Snaps: 360-361 | |-> Total UnOptimized Read Requests: 12 | |-> Captured Segments account for 116.7% 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 | |WRH$_CON_SYSSTAT 9277899_86 TABLE 73847 73847 2 16.67| |SYS SYSAUX | |WRH$_PROCESS_WAITTIM 9277899_86 TABLE 73855 73855 2 16.67| |SYS SYSAUX | |WRH$_BG_EVENT_SUMMAR INDEX 11172 11172 1 8.33| |SYS SYSAUX | |WRH$_CON_SYSTEM_EVEN 9277899_86 TABLE 73851 73851 1 8.33| |SYS SYSAUX | |WRH$_CON_SYSTEM_EVEN 9277899_86 INDEX 73853 73853 1 8.33| | ------------------------------------------------------| | | |Segments by Optimized Reads DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Direct Physical Reads DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Physical Writes DB/Inst: DB/db1 Snaps: 360-361 | |-> Total Physical Writes: 2,108 | |-> Captured Segments account for 15.0% 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 2.56| |SYS SYSAUX | |WRH$_LATCH 9277899_86 TABLE 73735 73735 22 1.04| |SYS SYSAUX | |WRH$_SYSMETRIC_HISTO 9277899_86 TABLE 73775 73775 18 .85| |SYS SYSAUX | |WRI$_ADV_PARAMETERS TABLE 8696 8696 17 .81| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 16 .76| | ------------------------------------------------------| | | |Segments by Physical Write Requests DB/Inst: DB/db1 Snaps: 360-361 | |-> Total Physical Write Requests: 496 | |-> Captured Segments account for 47.4% 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 31 6.25| |SYS SYSAUX | |WRH$_SYSSTAT_PK 9277899_86 INDEX 73757 73757 16 3.23| |SYS SYSAUX | |WRH$_EVENT_HISTOGRAM 9277899_86 INDEX 73797 73797 12 2.42| |SYS SYSAUX | |WRH$_SYSSTAT 9277899_86 TABLE 73755 73755 11 2.22| |SYS SYSAUX | |WRH$_LATCH_PK 9277899_86 INDEX 73737 73737 9 1.81| | ------------------------------------------------------| | | |Segments by Direct Physical Writes DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Table Scans DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by DB Blocks Changes DB/Inst: DB/db1 Snaps: 360-361 | |-> % 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 39.18| |SYS SYSAUX | |WRH$_LATCH_PK 9277899_86 INDEX 73737 73737 624 14.55| |SYS SYSAUX | |WRH$_PARAMETER_PK 9277899_86 INDEX 73761 73761 192 4.48| |SYS SYSAUX | |WRH$_EVENT_HISTOGRAM 9277899_86 INDEX 73797 73797 160 3.73| |SYS SYSAUX | |WRH$_SEG_STAT_OBJ_IN INDEX 11341 11341 160 3.73| | ------------------------------------------------------| | | | | |Segments by Row Lock Waits DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by ITL Waits DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Segments by Buffer Busy Waits DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Dictionary Cache Stats DB/Inst: DB/db1 Snaps: 360-361 | |-> "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 61 | |dc_histogram_data 1 0.0 0 N/A 0 1,458 | |dc_histogram_defs 2 0.0 0 N/A 0 2,956 | |dc_objects 714 0.0 0 N/A 0 3,276 | |dc_props 487 0.0 0 N/A 0 3 | |dc_rollback_segments 284 0.0 0 N/A 0 22 | |dc_segments 18 5.6 0 N/A 3 443 | |dc_sequences 1 0.0 0 N/A 1 7 | |dc_tablespaces 280 0.0 0 N/A 0 7 | |dc_users 6 0.0 0 N/A 0 116 | |outstanding_alerts 2 0.0 0 N/A 0 3 | | ------------------------------------------------------| | | |Library Cache Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> "Pct Misses" should be very low | | | | Get Pct Pin Pct Invali- | |Namespace Requests Miss Requests Miss Reloads dations | |--------------- ------------ ------ -------------- ------ ---------- -------- | |BODY 6 0.0 16 0.0 0 0 | |EDITION 2 0.0 4 0.0 0 0 | |SQL AREA 198 1.0 3,765 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 8 0.0 60 0.0 0 0 | |TRIGGER 3 0.0 3 0.0 0 0 | | ------------------------------------------------------| | | | | |Memory Dynamic Components DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Memory Resize Ops DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Process Memory Summary DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 175.2 .0 5.5 8.0 25 N/A 32 32 | | Other 346.8 N/A 4.6 8.1 40 40 75 75 | | PL/SQL 5.1 4.5 .1 .2 1 3 69 65 | | SQL 28.3 26.6 .7 1.7 7 19 42 30 | | Total 555.3 31.2 10.8 18.0 73 61 218 202 | |E Freeable 170.5 .0 5.3 8.0 25 N/A 32 32 | | Other 303.8 N/A 4.1 6.8 29 29 74 74 | | PL/SQL 3.7 3.4 .1 .2 1 2 68 64 | | SQL 28.3 26.6 .7 1.7 7 19 41 29 | | Total 506.3 30.0 10.2 16.6 62 50 215 199 | | ------------------------------------------------------| | | |SGA Memory Summary DB/Inst: DB/db1 Snaps: 360-361 | | | | 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: 360-361 | |-> 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 32.9 32.9 0.09 | |shared KGLHD 7.1 7.1 0.04 | |shared KGLS 5.5 5.5 0.00 | |shared KGLSG 5.0 5.0 0.00 | |shared KQR X PO 5.9 5.9 0.01 | |shared PLMCD 8.1 8.1 0.00 | |shared SO private sga 15.6 15.6 0.00 | |shared SQLA 149.5 149.5 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 61.9 62.4 0.83 | |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: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Replication SGA Usage DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |GoldenGate Capture DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Capture Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Reader DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Coordinator DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Server DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Coordinator Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |GoldenGate Apply Reader and Server Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |XStream Capture DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Capture Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Reader DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Coordinator DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Server DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Coordinator Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |XStream Apply Reader and Server Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Table Statistics by DML Operations DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Table Statistics by Conflict Resolutions DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Replication Large Transaction Statistics DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Replication Long Running Transaction StatisticsDB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Advanced Queue CPU/IO Usage DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffered Queues DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Buffered Queue Subscribers DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Rule Set DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Persistent Queues DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Persistent Queues Rate DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Persistent Queue Subscribers DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | | | |Resource Limit Stats DB/Inst: DB/db1 Snap: 361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Shared Servers Activity DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 360-361 | | | | 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: 360-361 | |-> 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: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Shared Servers Dispatchers DB/Inst: DB/db1 Snaps: 360-361 | |-> 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: 360-361 | |-> 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: 360-361 | |-> 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: 360-361 | |-> Top SQL statements by DB Time along with the top events by DB Time | | for those SQLs. | |-> % Activity is the percentage of DB Time due to the SQL. | |-> % Event is the percentage of DB Time due to the event that the SQL is | | waiting on. | |-> % Row Source is the percentage of DB Time due to the row source for the | | SQL waiting on the event. | |-> Executions is the number of executions of the SQL that were sampled in ASH. | | | | SQL ID Plan Hash Executions % Activity| |----------------------- -------------------- -------------------- --------------| | % Row| |Event % Event Top Row Source Source| |------------------------------ ------- --------------------------------- -------| | aykvshm7zsabd 1829585422 1 33.33| |CPU + Wait for CPU 33.33 FIXED TABLE - FULL 33.33| |select size_for_estimate, size_factor * 100 f, | | estd_physical_read_time, estd_physical_reads | |from v$db_cache_advice where id = '3' | | | | ------------------------------------------------------| | | |Top SQL with Top Row Sources DB/Inst: DB/db1 Snaps: 360-361 | |-> Top SQL statements by DB Time along with the top row sources by DB Time | | for those SQLs. | |-> % Activity is the percentage of DB Time due to the SQL. | |-> % Row Source is the percentage of DB Time spent on the row source by | | that SQL. | |-> % Event is the percentage of DB Time spent on the event by the | | SQL executing the row source. | |-> Executions is the number of executions of the SQL that were sampled in ASH. | | | | SQL ID Plan Hash Executions % Activity| |----------------------- -------------------- -------------------- --------------| | % Row | |Row Source Source Top Event % Event| |---------------------------------------- ------- ----------------------- -------| | aykvshm7zsabd 1829585422 1 33.33| |FIXED TABLE - FULL 33.33 CPU + Wait for CPU 33.33| |select size_for_estimate, size_factor * 100 f, | | estd_physical_read_time, estd_physical_reads | |from v$db_cache_advice where id = '3' | | | | ------------------------------------------------------| | | |Top Sessions DB/Inst: DB/db1 Snaps: 360-361 | |-> '# 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 | |-------------------- ------------------------------ ------------------ -------- | | 8, 5743 66.67 CPU + Wait for CPU 66.67 | |SYS oracle@oracle-....local (MMON) 2/60 [ 3%] 0 | | | | 131,35462 33.33 control file parallel write 33.33 | |SYS oracle@oracle-....local (CKPT) 1/60 [ 2%] 0 | | | | ------------------------------------------------------| | | |Top Blocking Sessions DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top PL/SQL Procedures DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Top Events DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 | | 66.67 0.03 | |control file parallel write System I/O BACKGROUND | | 33.33 0.02 | | ------------------------------------------------------| | | |Top Event P1/P2/P3 Values DB/Inst: DB/db1 Snaps: 360-361 | |-> Top Events by DB Time and the top P1/P2/P3 values for those events. | |-> % Event is the percentage of DB Time due to the event | |-> % Activity is the percentage of DB Time due to the event with the given | | P1,P2,P3 Values. | | | |Event % Event P1, P2, P3 Values % Activity | |------------------------------ ------- ----------------------------- ---------- | |Parameter 1 Parameter 2 Parameter 3 | |-------------------------- -------------------------- --------------------------| |control file parallel write 33.33 "2","3","2" 33.33 | |files block# requests | | | | ------------------------------------------------------| | | |Top DB Objects DB/Inst: DB/db1 Snaps: 360-361 | | | | No data exists for this section of the report. | | ------------------------------------------------------| | | |Activity Over Time DB/Inst: DB/db1 Snaps: 360-361 | |-> 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 | |-------------------- -------- ------------------------------ -------- ------- | |14:40:33 (4.5 min) 2 CPU + Wait for CPU 2 66.67 | |14:45:00 (5.0 min) 1 control file parallel write 1 33.33 | | ------------------------------------------------------| | | | | | | | ADDM Report for Task 'ADDM:1979277899_1_361' | | -------------------------------------------- | | | |Analysis Period | |--------------- | |AWR snapshot range from 360 to 361. | |Time period starts at 30-DEC-25 02.40.33 PM | |Time period ends at 30-DEC-25 02.50.34 PM | | | |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 |