WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| TJTG | 3810413154 | TJTG | 1 | 12-Aug-18 14:08 | 11.2.0.4.0 | NO |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| tjpsb004.ebs.in | Linux x86 64-bit | 24 | 12 | 2 | 63.97 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 30608 | 03-Sep-18 08:30:49 | 347 | 23.6 |
| End Snap: | 30610 | 03-Sep-18 10:31:00 | 425 | 28.8 |
| Elapsed: | 120.18 (mins) | |||
| DB Time: | 1,050.16 (mins) |
Report Summary
Load Profile| Per Second | Per Transaction | Per Exec | Per Call | |
|---|---|---|---|---|
| DB Time(s): | 8.7 | 0.6 | 0.00 | 0.02 |
| DB CPU(s): | 4.7 | 0.3 | 0.00 | 0.01 |
| Redo size (bytes): | 332,590.2 | 23,920.0 | ||
| Logical read (blocks): | 775,163.7 | 55,750.0 | ||
| Block changes: | 1,700.1 | 122.3 | ||
| Physical read (blocks): | 1,364.7 | 98.2 | ||
| Physical write (blocks): | 126.8 | 9.1 | ||
| Read IO requests: | 542.8 | 39.0 | ||
| Write IO requests: | 38.2 | 2.8 | ||
| Read IO (MB): | 10.7 | 0.8 | ||
| Write IO (MB): | 1.0 | 0.1 | ||
| User calls: | 378.3 | 27.2 | ||
| Parses (SQL): | 232.9 | 16.8 | ||
| Hard parses (SQL): | 0.3 | 0.0 | ||
| SQL Work Area (MB): | 4.1 | 0.3 | ||
| Logons: | 0.4 | 0.0 | ||
| Executes (SQL): | 8,178.7 | 588.2 | ||
| Rollbacks: | 2.1 | 0.2 | ||
| Transactions: | 13.9 |
| Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.91 | In-memory Sort %: | 100.00 |
| Library Hit %: | 100.01 | Soft Parse %: | 99.87 |
| Execute to Parse %: | 97.15 | Latch Hit %: | 93.24 |
| Parse CPU to Parse Elapsd %: | 87.47 | % Non-Parse CPU: | 99.52 |
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| DB CPU | 33.9K | 53.9 | |||
| db file sequential read | 3,260,256 | 26K | 8 | 41.3 | User I/O |
| db file scattered read | 218,254 | 1486.9 | 7 | 2.4 | User I/O |
| direct path read | 105,231 | 792.5 | 8 | 1.3 | User I/O |
| db file parallel read | 35,316 | 247.7 | 7 | .4 | User I/O |
| TCP Socket (KGAS) | 4,684 | 154.6 | 33 | .2 | Network |
| direct path read temp | 17,409 | 139.6 | 8 | .2 | User I/O |
| read by other session | 23,522 | 116.9 | 5 | .2 | User I/O |
| enq: TX - row lock contention | 391 | 86.9 | 222 | .1 | Application |
| log file sync | 45,339 | 52.1 | 1 | .1 | Commit |
| Wait Class | Waits | Total Wait Time (sec) | Avg Wait (ms) | % DB time | Avg Active Sessions |
|---|---|---|---|---|---|
| Other | 214,053,854 | 220,989 | 1 | 350.7 | 30.6 |
| DB CPU | 33,934 | 53.9 | 4.7 | ||
| User I/O | 4,179,121 | 28,947 | 7 | 45.9 | 4.0 |
| System I/O | 181,089 | 454 | 3 | .7 | 0.1 |
| Network | 2,428,631 | 363 | 0 | .6 | 0.1 |
| Application | 20,093 | 96 | 5 | .2 | 0.0 |
| Concurrency | 39,176 | 75 | 2 | .1 | 0.0 |
| Commit | 45,349 | 52 | 1 | .1 | 0.0 |
| Configuration | 82 | 6 | 73 | .0 | 0.0 |
| CPUs | Cores | Sockets | Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
|---|---|---|---|---|---|---|---|---|
| 24 | 12 | 2 | 9.60 | 12.29 | 45.2 | 8.8 | 6.3 | 45.9 |
| %Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
|---|---|---|
| 52.5 | 97.0 | 0.0 |
| Read+Write Per Second | Read per Second | Write Per Second | |
|---|---|---|---|
| Total Requests: | 633.5 | 548.1 | 85.5 |
| Database Requests: | 581.0 | 542.8 | 38.2 |
| Optimized Requests: | 0.0 | 0.0 | 0.0 |
| Redo Requests: | 43.1 | 0.6 | 42.5 |
| Total (MB): | 13.8 | 11.4 | 2.4 |
| Database (MB): | 11.7 | 10.7 | 1.0 |
| Optimized Total (MB): | 0.0 | 0.0 | 0.0 |
| Redo (MB): | 1.6 | 0.6 | 1.0 |
| Database (blocks): | 1,491.4 | 1,364.7 | 126.8 |
| Via Buffer Cache (blocks): | 718.9 | 668.7 | 50.3 |
| Direct (blocks): | 772.5 | 696.0 | 76.5 |
| Begin | End | |
|---|---|---|
| Host Mem (MB): | 65,501.3 | 65,501.3 |
| SGA use (MB): | 20,480.0 | 20,480.0 |
| PGA use (MB): | 2,608.1 | 3,996.1 |
| % Host Mem used for SGA+PGA: | 35.25 | 37.37 |
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 13,504M | 13,504M | Std Block Size: | 8K |
| Shared Pool Size: | 5,550M | 5,528M | Log Buffer: | 100,764K |
| Begin | End | |
|---|---|---|
| Memory Usage %: | 79.28 | 81.27 |
| % SQL with executions>1: | 94.74 | 95.33 |
| % Memory for SQL w/exec>1: | 90.99 | 94.04 |
Main Report
- Report Summary
- Wait Events Statistics
- SQL Statistics
- Instance Activity Statistics
- IO Stats
- Buffer Pool Statistics
- Advisory Statistics
- Wait Statistics
- Undo Statistics
- Latch Statistics
- Segment Statistics
- Dictionary Cache Statistics
- Library Cache Statistics
- Memory Statistics
- Streams Statistics
- Resource Limit Statistics
- Shared Server Statistics
- init.ora Parameters
Back to Top
Wait Events Statistics
- Time Model Statistics
- Operating System Statistics
- Operating System Statistics - Detail
- Foreground Wait Class
- Foreground Wait Events
- Background Wait Events
- Wait Event Histogram
- Wait Event Histogram Detail (64 msec to 2 sec)
- Wait Event Histogram Detail (4 sec to 2 min)
- Wait Event Histogram Detail (4 min to 1 hr)
- Service Statistics
- Service Wait Class Stats
Time Model Statistics
- Total time in database user-calls (DB Time): 63009.4s
- Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
- Ordered by % or DB time desc, Statistic name
| Statistic Name | Time (s) | % of DB Time |
|---|---|---|
| sql execute elapsed time | 62,508.71 | 99.21 |
| DB CPU | 33,934.27 | 53.86 |
| PL/SQL execution elapsed time | 2,178.94 | 3.46 |
| inbound PL/SQL rpc elapsed time | 954.32 | 1.51 |
| parse time elapsed | 282.12 | 0.45 |
| hard parse elapsed time | 241.41 | 0.38 |
| connection management call elapsed time | 27.64 | 0.04 |
| hard parse (sharing criteria) elapsed time | 22.55 | 0.04 |
| PL/SQL compilation elapsed time | 5.48 | 0.01 |
| Java execution elapsed time | 3.17 | 0.01 |
| repeated bind elapsed time | 1.25 | 0.00 |
| sequence load elapsed time | 1.05 | 0.00 |
| hard parse (bind mismatch) elapsed time | 0.39 | 0.00 |
| failed parse elapsed time | 0.37 | 0.00 |
| DB time | 63,009.45 | |
| background elapsed time | 269,067.13 | |
| background cpu time | 54,834.97 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
- *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
- ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name
| Statistic | Value | End Value |
|---|---|---|
| BUSY_TIME | 9,150,252 | |
| IDLE_TIME | 7,771,665 | |
| IOWAIT_TIME | 1,072,775 | |
| NICE_TIME | 1 | |
| SYS_TIME | 1,490,008 | |
| USER_TIME | 7,645,726 | |
| LOAD | 10 | 12 |
| VM_IN_BYTES | 1,830,912 | |
| VM_OUT_BYTES | 643,072 | |
| PHYSICAL_MEMORY_BYTES | 68,683,067,392 | |
| NUM_CPUS | 24 | |
| NUM_CPU_CORES | 12 | |
| NUM_CPU_SOCKETS | 2 | |
| GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
| GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
| TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
| TCP_RECEIVE_SIZE_MAX | 4,194,304 | |
| 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 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics - Detail
| Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
|---|---|---|---|---|---|---|
| 03-Sep 08:30:49 | 9.60 | |||||
| 03-Sep 09:30:55 | 5.14 | 54.14 | 45.35 | 8.72 | 45.86 | 5.22 |
| 03-Sep 10:31:00 | 12.29 | 54.01 | 45.02 | 8.89 | 45.99 | 7.46 |
Back to Wait Events Statistics
Back to Top
Foreground Wait Class
- s - second, ms - millisecond - 1000th of a second
- ordered by wait time desc, waits desc
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
- Captured Time accounts for 100.2% of Total DB time 63,009.45 (s)
- Total FG Wait Time: 29,222.57 (s) DB CPU time: 33,934.27 (s)
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
|---|---|---|---|---|---|
| DB CPU | 33,934 | 53.86 | |||
| User I/O | 4,166,170 | 0 | 28,880 | 7 | 45.83 |
| Network | 2,403,475 | 0 | 160 | 0 | 0.25 |
| Application | 20,074 | 0 | 96 | 5 | 0.15 |
| Commit | 45,339 | 0 | 52 | 1 | 0.08 |
| Concurrency | 14,563 | 0 | 27 | 2 | 0.04 |
| Configuration | 82 | 0 | 6 | 73 | 0.01 |
| System I/O | 118 | 0 | 2 | 15 | 0.00 |
| Other | 141 | 16 | 0 | 1 | 0.00 |
Back to Wait Events Statistics
Back to Top
Foreground Wait Events
- s - second, ms - millisecond - 1000th of a second
- Only events with Total Wait Time (s) >= .001 are shown
- ordered by wait time desc, waits desc (idle events last)
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
|---|---|---|---|---|---|---|
| db file sequential read | 3,260,256 | 0 | 26,040 | 8 | 32.52 | 41.33 |
| db file scattered read | 218,254 | 0 | 1,487 | 7 | 2.18 | 2.36 |
| direct path read | 105,231 | 0 | 793 | 8 | 1.05 | 1.26 |
| db file parallel read | 35,316 | 0 | 248 | 7 | 0.35 | 0.39 |
| TCP Socket (KGAS) | 4,684 | 17 | 155 | 33 | 0.05 | 0.25 |
| direct path read temp | 17,409 | 0 | 140 | 8 | 0.17 | 0.22 |
| read by other session | 23,522 | 0 | 117 | 5 | 0.23 | 0.19 |
| enq: TX - row lock contention | 391 | 0 | 87 | 222 | 0.00 | 0.14 |
| log file sync | 45,339 | 0 | 52 | 1 | 0.45 | 0.08 |
| Disk file operations I/O | 26,770 | 0 | 41 | 2 | 0.27 | 0.07 |
| enq: TX - index contention | 204 | 0 | 18 | 87 | 0.00 | 0.03 |
| SQL*Net break/reset to client | 19,671 | 0 | 9 | 0 | 0.20 | 0.01 |
| direct path write | 4,907 | 0 | 6 | 1 | 0.05 | 0.01 |
| utl_file I/O | 471,301 | 0 | 6 | 0 | 4.70 | 0.01 |
| library cache: mutex X | 8,452 | 0 | 5 | 1 | 0.08 | 0.01 |
| buffer busy waits | 2,116 | 0 | 3 | 1 | 0.02 | 0.00 |
| enq: HW - contention | 67 | 0 | 3 | 42 | 0.00 | 0.00 |
| SQL*Net more data to client | 106,045 | 0 | 3 | 0 | 1.06 | 0.00 |
| SQL*Net message to client | 2,278,567 | 0 | 2 | 0 | 22.73 | 0.00 |
| direct path write temp | 3,133 | 0 | 2 | 1 | 0.03 | 0.00 |
| control file sequential read | 110 | 0 | 2 | 16 | 0.00 | 0.00 |
| enq: TX - allocate ITL entry | 3 | 0 | 2 | 583 | 0.00 | 0.00 |
| log file switch (private strand flush incomplete) | 12 | 0 | 1 | 117 | 0.00 | 0.00 |
| latch: cache buffers chains | 2,965 | 0 | 1 | 0 | 0.03 | 0.00 |
| SQL*Net more data from client | 14,179 | 0 | 1 | 0 | 0.14 | 0.00 |
| cursor: pin S | 510 | 0 | 0 | 1 | 0.01 | 0.00 |
| library cache lock | 7 | 0 | 0 | 14 | 0.00 | 0.00 |
| local write wait | 71 | 0 | 0 | 1 | 0.00 | 0.00 |
| log file sequential read | 4 | 0 | 0 | 12 | 0.00 | 0.00 |
| enq: DV - contention | 22 | 0 | 0 | 2 | 0.00 | 0.00 |
| latch free | 39 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: shared pool | 47 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: enqueue hash chains | 26 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: KO - fast object checkpoint | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: RO - fast object reuse | 5 | 0 | 0 | 2 | 0.00 | 0.00 |
| latch: row cache objects | 203 | 0 | 0 | 0 | 0.00 | 0.00 |
| control file parallel write | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
| buffer deadlock | 20 | 100 | 0 | 0 | 0.00 | 0.00 |
| latch: In memory undo latch | 46 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: undo global data | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| reliable message | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: redo allocation | 11 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message from client | 2,278,520 | 0 | 1,373,943 | 603 | 22.73 | |
| Streams AQ: waiting for messages in the queue | 13,307 | 90 | 90,811 | 6824 | 0.13 | |
| pipe get | 5,314 | 99 | 21,632 | 4071 | 0.05 | |
| PL/SQL lock timer | 45,432,242 | 100 | 4,741 | 0 | 453.16 |
Back to Wait Events Statistics
Back to Top
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
- Only events with Total Wait Time (s) >= .001 are shown
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|---|---|---|---|---|---|
| latch free | 213,984,273 | 0 | 220,927 | 1 | 2,134.36 | 82.11 |
| control file sequential read | 30,633 | 0 | 327 | 11 | 0.31 | 0.12 |
| LNS wait on SENDREQ | 17,018 | 0 | 150 | 9 | 0.17 | 0.06 |
| log file parallel write | 89,508 | 0 | 79 | 1 | 0.89 | 0.03 |
| wait list latch free | 60,292 | 0 | 66 | 1 | 0.60 | 0.02 |
| ARCH wait on SENDREQ | 201 | 0 | 53 | 264 | 0.00 | 0.02 |
| db file sequential read | 5,227 | 0 | 52 | 10 | 0.05 | 0.02 |
| library cache: mutex X | 24,539 | 0 | 48 | 2 | 0.24 | 0.02 |
| log file sequential read | 1,819 | 0 | 18 | 10 | 0.02 | 0.01 |
| Log archive I/O | 235 | 0 | 8 | 34 | 0.00 | 0.00 |
| Parameter File I/O | 1,920 | 0 | 8 | 4 | 0.02 | 0.00 |
| db file parallel write | 26,769 | 0 | 8 | 0 | 0.27 | 0.00 |
| control file parallel write | 10,591 | 0 | 7 | 1 | 0.11 | 0.00 |
| db file async I/O submit | 21,369 | 0 | 6 | 0 | 0.21 | 0.00 |
| db file scattered read | 185 | 0 | 3 | 17 | 0.00 | 0.00 |
| direct path read | 256 | 0 | 3 | 12 | 0.00 | 0.00 |
| Disk file operations I/O | 5,283 | 0 | 2 | 0 | 0.05 | 0.00 |
| os thread startup | 39 | 0 | 1 | 20 | 0.00 | 0.00 |
| enq: CF - contention | 7 | 0 | 1 | 79 | 0.00 | 0.00 |
| LGWR wait for redo copy | 11,117 | 0 | 0 | 0 | 0.11 | 0.00 |
| ADR block file write | 10 | 0 | 0 | 12 | 0.00 | 0.00 |
| ADR block file read | 32 | 0 | 0 | 4 | 0.00 | 0.00 |
| SQL*Net break/reset to client | 19 | 0 | 0 | 3 | 0.00 | 0.00 |
| direct path write | 88 | 0 | 0 | 0 | 0.00 | 0.00 |
| asynch descriptor resize | 2,624 | 100 | 0 | 0 | 0.03 | 0.00 |
| SQL*Net message to client | 7,937 | 0 | 0 | 0 | 0.08 | 0.00 |
| log file single write | 48 | 0 | 0 | 0 | 0.00 | 0.00 |
| log file sync | 10 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: shared pool | 30 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: call allocation | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
| db file parallel read | 1 | 0 | 0 | 3 | 0.00 | 0.00 |
| reliable message | 32 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: redo allocation | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
| rdbms ipc message | 128,153 | 34 | 141,319 | 1103 | 1.28 | |
| Streams AQ: qmn slave idle wait | 860,685,889 | 0 | 93,996 | 0 | 8,584.80 | |
| Space Manager: slave idle wait | 4,662 | 93 | 22,478 | 4821 | 0.05 | |
| DIAG idle wait | 14,378 | 100 | 14,391 | 1001 | 0.14 | |
| Streams AQ: waiting for time management or cleanup tasks | 495 | 77 | 7,219 | 14583 | 0.00 | |
| pmon timer | 2,401 | 100 | 7,210 | 3003 | 0.02 | |
| smon timer | 58 | 24 | 7,200 | 124130 | 0.00 | |
| JOX Jit Process Sleep | 469 | 100 | 7,037 | 15004 | 0.00 | |
| Streams AQ: deallocate messages from Streams Pool | 48,095,894 | 0 | 4,177 | 0 | 479.73 | |
| Streams AQ: qmn coordinator idle wait | 48,759,227 | 0 | 2,013 | 0 | 486.34 | |
| LNS ASYNC end of log | 15,521 | 4 | 1,776 | 114 | 0.15 | |
| SQL*Net message from client | 10,522 | 0 | 27 | 3 | 0.10 | |
| class slave wait | 39 | 0 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram
- Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
- % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
- % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
- Ordered by Event (idle events last)
| % of Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
| ADR block file read | 32 | 68.8 | 6.3 | 6.3 | 15.6 | 3.1 | |||
| ADR block file write | 10 | 80.0 | 10.0 | 10.0 | |||||
| ADR file lock | 12 | 100.0 | |||||||
| ARCH wait for archivelog lock | 13 | 100.0 | |||||||
| ARCH wait on SENDREQ | 200 | 98.0 | .5 | 1.0 | .5 | ||||
| Disk file operations I/O | 32K | 94.7 | .1 | .3 | 1.2 | .9 | 1.1 | 1.6 | |
| LGWR wait for redo copy | 11.1K | 99.9 | .1 | ||||||
| LNS wait on SENDREQ | 17K | 99.7 | .2 | .0 | .0 | .1 | .0 | ||
| Log archive I/O | 234 | 12.0 | 5.1 | .9 | 22.2 | 15.4 | 44.4 | ||
| Parameter File I/O | 1920 | 71.4 | 1.5 | 2.8 | 6.3 | 9.2 | 6.9 | 1.9 | |
| SQL*Net break/reset to client | 19.7K | 99.0 | .7 | .2 | .1 | .0 | .0 | .0 | |
| SQL*Net message to client | 2283.8K | 100.0 | .0 | .0 | |||||
| SQL*Net more data from client | 14.2K | 99.9 | .1 | .0 | |||||
| SQL*Net more data to client | 106K | 100.0 | .0 | .0 | .0 | .0 | |||
| TCP Socket (KGAS) | 4670 | 80.3 | 19.5 | .1 | |||||
| asynch descriptor resize | 2629 | 100.0 | |||||||
| buffer busy waits | 2122 | 91.4 | 3.9 | 1.1 | .7 | .6 | 1.0 | 1.4 | |
| buffer deadlock | 20 | 95.0 | 5.0 | ||||||
| control file parallel write | 10.6K | 88.6 | 9.2 | 1.7 | .4 | .1 | .0 | .0 | |
| control file sequential read | 30.7K | 53.3 | 1.3 | 2.6 | 7.0 | 10.6 | 12.0 | 13.1 | |
| cursor: mutex S | 2 | 100.0 | |||||||
| cursor: mutex X | 11 | 100.0 | |||||||
| cursor: pin S | 511 | 91.0 | 1.6 | .2 | 7.2 | ||||
| db file async I/O submit | 21.4K | 97.0 | .8 | .8 | .9 | .4 | .1 | .1 | |
| db file parallel read | 35.4K | 46.8 | 1.7 | 6.0 | 21.8 | 12.8 | 6.5 | 4.3 | |
| db file parallel write | 26.8K | 96.8 | 2.6 | .4 | .1 | .0 | |||
| db file scattered read | 218.4K | 51.6 | 1.9 | 4.2 | 17.8 | 13.0 | 6.8 | 4.7 | |
| db file sequential read | 3266.3K | 37.4 | 1.6 | 7.5 | 26.2 | 13.6 | 8.4 | 5.2 | |
| direct path read | 105.5K | 25.4 | 8.7 | 15.0 | 25.0 | 14.7 | 7.1 | 4.1 | |
| direct path read temp | 17.7K | 37.6 | 3.9 | 7.2 | 21.3 | 15.6 | 9.7 | 4.8 | |
| direct path write | 4996 | 88.2 | 3.8 | 1.3 | 2.9 | 2.8 | .6 | .4 | |
| direct path write temp | 3133 | 84.8 | 11.9 | 2.5 | .7 | .1 | |||
| enq: CF - contention | 7 | 14.3 | 14.3 | 14.3 | 57.1 | ||||
| enq: DV - contention | 22 | 63.6 | 4.5 | 9.1 | 18.2 | 4.5 | |||
| enq: HW - contention | 67 | 3.0 | 6.0 | 1.5 | 6.0 | 17.9 | 22.4 | 43.3 | |
| enq: KO - fast object checkpoint | 7 | 57.1 | 28.6 | 14.3 | |||||
| enq: RO - fast object reuse | 5 | 40.0 | 20.0 | 40.0 | |||||
| enq: TX - allocate ITL entry | 3 | 100.0 | |||||||
| enq: TX - index contention | 204 | 20.1 | 5.9 | 4.9 | 4.9 | 6.9 | 57.4 | ||
| enq: TX - row lock contention | 391 | 71.4 | 22.3 | 1.3 | .3 | 4.9 | |||
| latch free | 213.9M | 46.7 | 51.9 | 1.3 | .1 | .0 | .0 | ||
| latch: In memory undo latch | 46 | 100.0 | |||||||
| latch: cache buffers chains | 2965 | 96.9 | 2.5 | .3 | .3 | .1 | |||
| latch: cache buffers lru chain | 4 | 100.0 | |||||||
| latch: call allocation | 8 | 75.0 | 12.5 | 12.5 | |||||
| latch: enqueue hash chains | 26 | 69.2 | 23.1 | 7.7 | |||||
| latch: object queue header operation | 3 | 100.0 | |||||||
| latch: redo allocation | 21 | 100.0 | |||||||
| latch: row cache objects | 197 | 99.5 | .5 | ||||||
| latch: shared pool | 77 | 90.9 | 1.3 | 7.8 | |||||
| latch: undo global data | 4 | 100.0 | |||||||
| library cache lock | 7 | 42.9 | 14.3 | 14.3 | 28.6 | ||||
| library cache: mutex X | 33K | 84.8 | .3 | .0 | .0 | 14.8 | .0 | ||
| local write wait | 71 | 63.4 | 26.8 | 7.0 | 1.4 | 1.4 | |||
| log file parallel write | 89.5K | 79.6 | 13.9 | 4.2 | 2.0 | .2 | .0 | .0 | |
| log file sequential read | 1822 | 35.7 | 10.8 | 12.3 | 13.6 | 11.1 | 9.4 | 7.1 | |
| log file single write | 48 | 100.0 | |||||||
| log file switch (private strand flush incomplete) | 12 | 16.7 | 25.0 | 58.3 | |||||
| log file sync | 45.4K | 68.0 | 21.7 | 7.8 | 2.1 | .3 | .1 | .1 | |
| os thread startup | 39 | 100.0 | |||||||
| read by other session | 23.5K | 63.0 | 1.6 | 4.3 | 14.4 | 8.3 | 5.0 | 3.4 | |
| reliable message | 44 | 100.0 | |||||||
| utl_file I/O | 471.2K | 100.0 | .0 | .0 | |||||
| wait list latch free | 61K | 1.6 | 97.3 | 1.1 | .0 | .0 | |||
| DIAG idle wait | 14.4K | 100.0 | |||||||
| JOX Jit Process Sleep | 469 | 100.0 | |||||||
| LNS ASYNC end of log | 15.5K | 18.0 | 8.6 | 9.4 | 11.4 | 9.3 | 10.4 | 32.9 | |
| PL/SQL lock timer | 45.4M | 99.0 | 1.0 | .0 | .0 | .0 | .0 | ||
| SQL*Net message from client | 2286.1K | 80.0 | 5.5 | 5.6 | 4.5 | 1.3 | .8 | .9 | 1.4 |
| Space Manager: slave idle wait | 4655 | .2 | .2 | .0 | .0 | .1 | .2 | 1.3 | 98.1 |
| Streams AQ: deallocate messages from Streams Pool | 48.1M | 99.9 | .1 | .0 | .0 | .0 | .0 | ||
| Streams AQ: qmn coordinator idle wait | 48.7M | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
| Streams AQ: qmn slave idle wait | 854M | 99.9 | .1 | .0 | .0 | .0 | .0 | ||
| Streams AQ: waiting for messages in the queue | 13.3K | .1 | .0 | .0 | .0 | .0 | .2 | 6.7 | 92.9 |
| Streams AQ: waiting for time management or cleanup tasks | 498 | 5.4 | 42.6 | 52.0 | |||||
| class slave wait | 39 | 100.0 | |||||||
| pipe get | 5314 | 9.6 | 90.4 | ||||||
| pmon timer | 2400 | 100.0 | |||||||
| rdbms ipc message | 128.2K | 15.4 | 5.5 | 6.3 | 6.6 | 8.0 | 7.8 | 34.0 | 16.5 |
| smon timer | 60 | 1.7 | 1.7 | 1.7 | 15.0 | 80.0 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram Detail (64 msec to 2 sec)
- Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
- Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
- % of Total Waits: total waits for all wait classes, including Idle
- % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
- Ordered by Event (only non-idle events are displayed)
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
| ADR block file read | 1 | 96.9 | 3.1 | ||||||
| ADR block file write | 1 | 90.0 | 10.0 | ||||||
| ARCH wait on SENDREQ | 2 | 98.5 | .5 | .5 | .5 | ||||
| Disk file operations I/O | 526 | 98.4 | 1.4 | .2 | .0 | ||||
| LNS wait on SENDREQ | 13 | 99.9 | .1 | .0 | |||||
| Log archive I/O | 104 | 55.6 | 27.8 | 15.8 | .9 | ||||
| Parameter File I/O | 37 | 98.1 | 1.9 | ||||||
| SQL*Net break/reset to client | 5 | 100.0 | .0 | .0 | .0 | ||||
| SQL*Net more data to client | 1 | 100.0 | .0 | ||||||
| TCP Socket (KGAS) | 913 | 80.3 | 15.2 | 3.8 | .5 | .1 | .0 | .1 | |
| buffer busy waits | 29 | 98.6 | .8 | .6 | |||||
| control file parallel write | 5 | 100.0 | .0 | ||||||
| control file sequential read | 4024 | 86.9 | 12.6 | .5 | .0 | ||||
| db file async I/O submit | 13 | 99.9 | .0 | .0 | .0 | ||||
| db file parallel read | 1529 | 95.7 | 3.3 | 1.0 | .1 | ||||
| db file scattered read | 10.2K | 95.3 | 4.0 | .6 | .0 | .0 | |||
| db file sequential read | 171.3K | 94.8 | 4.6 | .6 | .0 | .0 | |||
| direct path read | 4376 | 95.9 | 3.5 | .6 | .0 | .0 | |||
| direct path read temp | 851 | 95.2 | 4.2 | .6 | .0 | .0 | |||
| direct path write | 19 | 99.6 | .3 | .1 | |||||
| enq: CF - contention | 4 | 42.9 | 28.6 | 14.3 | 14.3 | ||||
| enq: HW - contention | 29 | 56.7 | 22.4 | 16.4 | 4.5 | ||||
| enq: TX - allocate ITL entry | 3 | 100.0 | |||||||
| enq: TX - index contention | 117 | 42.6 | 21.6 | 11.3 | 9.3 | 15.2 | |||
| enq: TX - row lock contention | 1 | 94.9 | .3 | 4.9 | |||||
| library cache lock | 2 | 71.4 | 28.6 | ||||||
| log file parallel write | 19 | 100.0 | .0 | .0 | |||||
| log file sequential read | 130 | 92.9 | 4.1 | 2.6 | .4 | ||||
| log file switch (private strand flush incomplete) | 7 | 41.7 | 41.7 | 8.3 | 8.3 | ||||
| log file sync | 26 | 99.9 | .0 | .0 | .0 | ||||
| read by other session | 797 | 96.6 | 3.1 | .3 | .0 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram Detail (4 sec to 2 min)
- Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
- Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
- % of Total Waits: total waits for all wait classes, including Idle
- % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
- Ordered by Event (only non-idle events are displayed)
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
| ARCH wait on SENDREQ | 1 | 99.5 | .5 | ||||||
| LNS wait on SENDREQ | 6 | 100.0 | .0 | .0 | |||||
| SQL*Net break/reset to client | 1 | 100.0 | .0 | ||||||
| TCP Socket (KGAS) | 5 | 99.9 | .0 | .1 | |||||
| enq: TX - row lock contention | 19 | 95.1 | .3 | 4.6 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram Detail (4 min to 1 hr)
No data exists for this section of the report. Back to Wait Events StatisticsBack to Top
Service Statistics
- ordered by DB Time
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
|---|---|---|---|---|
| TJTG | 54,452 | 33,648 | 7,451 | 5,582,852 |
| SYS$USERS | 8,543 | 283 | 2,369 | 5,700 |
| EBS_CHENNAI | 0 | 0 | 0 | 0 |
| SYS$BACKGROUND | 0 | 0 | 17 | 235 |
Back to Wait Events Statistics
Back to Top
Service Wait Class Stats
- Wait Class info for services in the Service Statistics section.
- Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
- Time Waited (Wt Time) in seconds
| Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
|---|---|---|---|---|---|---|---|---|
| TJTG | 2997230 | 20555 | 14561 | 27 | 0 | 0 | 2379111 | 159 |
| SYS$USERS | 1168882 | 8324 | 1 | 0 | 0 | 0 | 24244 | 1 |
| EBS_CHENNAI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SYS$BACKGROUND | 12941 | 67 | 24609 | 49 | 0 | 0 | 17219 | 203 |
Back to Wait Events Statistics
Back to Top
SQL Statistics
- SQL ordered by Elapsed Time
- SQL ordered by CPU Time
- SQL ordered by User I/O Wait Time
- SQL ordered by Gets
- SQL ordered by Reads
- SQL ordered by Physical Reads (UnOptimized)
- SQL ordered by Executions
- SQL ordered by Parse Calls
- SQL ordered by Sharable Memory
- SQL ordered by Version Count
- Complete List of SQL Text
SQL ordered by Elapsed Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
- %Total - Elapsed Time as a percentage of Total DB time
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Captured SQL account for 99.2% of Total DB Time (s): 63,009
- Captured PL/SQL account for 49.1% of Total DB Time (s): 63,009
| Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 8,738.66 | 2 | 4,369.33 | 13.87 | 34.15 | 65.72 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 8,710.85 | 0 | 13.82 | 33.96 | 65.90 | d83kgsmws1rh0 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | BEGIN APPS.STGI_GLD_MAIN.EXTRA... | |
| 8,041.83 | 0 | 12.76 | 99.99 | 0.00 | gh19xxr7jc9wb | e:SQLGL:cp:tjtg/STGI_GLD_MAILER | BEGIN STGI_GLD_MAIN.MAILER(:er... | |
| 7,483.81 | 2 | 3,741.91 | 11.88 | 14.04 | 86.39 | 1pqj3r61tqvqc | e:PA:cp:tjtg/XXTJBASELINE | BEGIN xxtj_budget_baseline_pkg... |
| 7,210.70 | 0 | 11.44 | 1.67 | 98.93 | 5mh5w2za6dpa5 | sqlplus@tjpsb004.ebs.in (TNS V1-V3) | SELECT /* + RULE */ df.tablesp... | |
| 7,210.68 | 0 | 11.44 | 99.70 | 0.01 | a3fscdh3vfsym | e:(��:alr:И�Ѓ | SELECT grn#, net_grn grn, net_... | |
| 7,068.63 | 6 | 1,178.10 | 11.22 | 14.33 | 86.08 | 1b21pwu4ufmfp | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_VERSIONS SET ... |
| 6,097.00 | 1,865 | 3.27 | 9.68 | 2.08 | 98.51 | 8zy83jv9xwjvm | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_LINES PB SET ... |
| 5,524.95 | 45,468,796 | 0.00 | 8.77 | 11.25 | 0.00 | 1mr4u2r99v9vc | e:SQLAP:bes:oracle.apps.xla.accounting.preaccoun | SELECT PHASE_CODE, STATUS_CODE... |
| 5,045.17 | 3 | 1,681.72 | 8.01 | 98.75 | 0.96 | 40ztcafr39k8m | e:PA:cp:tjtg/STGI_SEIBAN_COSTS_TO_KOUBAN | BEGIN stgi_seiban_costs_kouban... |
| 4,759.89 | 3 | 1,586.63 | 7.55 | 99.67 | 0.03 | 5tkmqssfdyrt4 | e:PA:cp:tjtg/STGI_SEIBAN_COSTS_TO_KOUBAN | SELECT W.TRANSACTION_DATE, TO_... |
| 1,899.87 | 1 | 1,899.87 | 3.02 | 79.24 | 20.39 | a2zjpprag1byn | e:HXC:cp:hxt/XXT_OTL_MAN_HRS_SUPER_USER | /* Formatted on 2015/04/07 17:... |
| 1,717.25 | 65 | 26.42 | 2.73 | 5.99 | 94.79 | ggbphm8skh52r | e:WIP:frm:WIPDJMDF | select 'x' from dual where :1 ... |
| 1,622.97 | 22,080 | 0.07 | 2.58 | 98.99 | 0.43 | 3th40zct78hn3 | e:HXC:cp:hxt/XXT_OTL_EMPDAY_XML | SELECT EMPLOYEENO, NAME, FIT, ... |
| 1,559.70 | 0 | 2.48 | 81.70 | 18.25 | 1c39wvc97qdf9 | rwrun@tjpsb005.ebs.in (TNS V1-V3) | SELECT WE.WIP_ENTITY_NAME WO, ... | |
| 755.51 | 28,152 | 0.03 | 1.20 | 92.63 | 6.80 | 7wrxvg70dwzcj | e:ALR:cp:tjtg/XXTJ_BUDGET_BALANCE | SELECT PROJECT_RATE_DATE, PROJ... |
Back to SQL Statistics
Back to Top
SQL ordered by CPU Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- %Total - CPU Time as a percentage of Total DB CPU
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Captured SQL account for 76.6% of Total CPU Time (s): 33,934
- Captured PL/SQL account for 52.9% of Total CPU Time (s): 33,934
| CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 8,041.15 | 0 | 23.70 | 8,041.83 | 99.99 | 0.00 | gh19xxr7jc9wb | e:SQLGL:cp:tjtg/STGI_GLD_MAILER | BEGIN STGI_GLD_MAIN.MAILER(:er... | |
| 7,189.24 | 0 | 21.19 | 7,210.68 | 99.70 | 0.01 | a3fscdh3vfsym | e:(��:alr:И�Ѓ | SELECT grn#, net_grn grn, net_... | |
| 4,981.93 | 3 | 1,660.64 | 14.68 | 5,045.17 | 98.75 | 0.96 | 40ztcafr39k8m | e:PA:cp:tjtg/STGI_SEIBAN_COSTS_TO_KOUBAN | BEGIN stgi_seiban_costs_kouban... |
| 4,744.24 | 3 | 1,581.41 | 13.98 | 4,759.89 | 99.67 | 0.03 | 5tkmqssfdyrt4 | e:PA:cp:tjtg/STGI_SEIBAN_COSTS_TO_KOUBAN | SELECT W.TRANSACTION_DATE, TO_... |
| 2,984.18 | 2 | 1,492.09 | 8.79 | 8,738.66 | 34.15 | 65.72 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 2,958.03 | 0 | 8.72 | 8,710.85 | 33.96 | 65.90 | d83kgsmws1rh0 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | BEGIN APPS.STGI_GLD_MAIN.EXTRA... | |
| 1,606.66 | 22,080 | 0.07 | 4.73 | 1,622.97 | 98.99 | 0.43 | 3th40zct78hn3 | e:HXC:cp:hxt/XXT_OTL_EMPDAY_XML | SELECT EMPLOYEENO, NAME, FIT, ... |
| 1,505.46 | 1 | 1,505.46 | 4.44 | 1,899.87 | 79.24 | 20.39 | a2zjpprag1byn | e:HXC:cp:hxt/XXT_OTL_MAN_HRS_SUPER_USER | /* Formatted on 2015/04/07 17:... |
| 1,274.29 | 0 | 3.76 | 1,559.70 | 81.70 | 18.25 | 1c39wvc97qdf9 | rwrun@tjpsb005.ebs.in (TNS V1-V3) | SELECT WE.WIP_ENTITY_NAME WO, ... | |
| 1,050.65 | 2 | 525.33 | 3.10 | 7,483.81 | 14.04 | 86.39 | 1pqj3r61tqvqc | e:PA:cp:tjtg/XXTJBASELINE | BEGIN xxtj_budget_baseline_pkg... |
| 1,013.07 | 6 | 168.84 | 2.99 | 7,068.63 | 14.33 | 86.08 | 1b21pwu4ufmfp | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_VERSIONS SET ... |
| 699.81 | 28,152 | 0.02 | 2.06 | 755.51 | 92.63 | 6.80 | 7wrxvg70dwzcj | e:ALR:cp:tjtg/XXTJ_BUDGET_BALANCE | SELECT PROJECT_RATE_DATE, PROJ... |
| 621.40 | 45,468,796 | 0.00 | 1.83 | 5,524.95 | 11.25 | 0.00 | 1mr4u2r99v9vc | e:SQLAP:bes:oracle.apps.xla.accounting.preaccoun | SELECT PHASE_CODE, STATUS_CODE... |
| 421.86 | 1 | 421.86 | 1.24 | 478.83 | 88.10 | 11.66 | 8txssjmgpmms1 | TOAD background query session | SELECT task_number, decode(sub... |
| 390.87 | 31,191 | 0.01 | 1.15 | 410.24 | 95.28 | 4.40 | dgvrbv0rmtnaf | e:ALR:cp:tjtg/XXTJ_BUDGET_BALANCE | SELECT PROJECT_RATE_DATE, PROJ... |
Back to SQL Statistics
Back to Top
SQL ordered by User I/O Wait Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- %Total - User I/O Time as a percentage of Total User I/O Wait time
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Captured SQL account for 109.4% of Total User I/O Wait Time (s): 28,947
- Captured PL/SQL account for 44.7% of Total User I/O Wait Time (s): 28,947
| User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 7,133.46 | 0 | 24.64 | 7,210.70 | 1.67 | 98.93 | 5mh5w2za6dpa5 | sqlplus@tjpsb004.ebs.in (TNS V1-V3) | SELECT /* + RULE */ df.tablesp... | |
| 6,465.57 | 2 | 3,232.78 | 22.34 | 7,483.81 | 14.04 | 86.39 | 1pqj3r61tqvqc | e:PA:cp:tjtg/XXTJBASELINE | BEGIN xxtj_budget_baseline_pkg... |
| 6,084.51 | 6 | 1,014.08 | 21.02 | 7,068.63 | 14.33 | 86.08 | 1b21pwu4ufmfp | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_VERSIONS SET ... |
| 6,006.34 | 1,865 | 3.22 | 20.75 | 6,097.00 | 2.08 | 98.51 | 8zy83jv9xwjvm | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_LINES PB SET ... |
| 5,743.17 | 2 | 2,871.59 | 19.84 | 8,738.66 | 34.15 | 65.72 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 5,740.77 | 0 | 19.83 | 8,710.85 | 33.96 | 65.90 | d83kgsmws1rh0 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | BEGIN APPS.STGI_GLD_MAIN.EXTRA... | |
| 1,627.83 | 65 | 25.04 | 5.62 | 1,717.25 | 5.99 | 94.79 | ggbphm8skh52r | e:WIP:frm:WIPDJMDF | select 'x' from dual where :1 ... |
| 606.34 | 0 | 2.09 | 615.51 | 2.33 | 98.51 | 7whgw57ycjnwj | e:HXC:frm:FNDRSRUN | SELECT WORKGROUP, WORKGROUP VA... | |
| 543.51 | 1 | 543.51 | 1.88 | 559.52 | 4.81 | 97.14 | dfxb82a14d5ts | toad.exe | select pat1.task_number, pabl1... |
| 531.59 | 1 | 531.59 | 1.84 | 543.68 | 2.89 | 97.77 | 2wv3k32gn28jt | e:HXC:cp:hxt/XXT_OTL_COSTCENTER_SUPER_USER | SELECT q2.employee_number empl... |
| 452.10 | 1 | 452.10 | 1.56 | 469.16 | 5.94 | 96.36 | dz05z8wartumr | toad.exe | select count(*) from ( select ... |
| 387.37 | 1 | 387.37 | 1.34 | 1,899.87 | 79.24 | 20.39 | a2zjpprag1byn | e:HXC:cp:hxt/XXT_OTL_MAN_HRS_SUPER_USER | /* Formatted on 2015/04/07 17:... |
| 300.66 | 17 | 17.69 | 1.04 | 314.49 | 5.11 | 95.60 | f3b04944y8d3x | e:TJTG:wf:XXTJCBR | INSERT INTO PJI_FP_XBS_ACCUM_F... |
Back to SQL Statistics
Back to Top
SQL ordered by Gets
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- %Total - Buffer Gets as a percentage of Total Buffer Gets
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Total Buffer Gets: 5,589,328,666
- Captured SQL account for 98.3% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 2,428,562,964 | 0 | 43.45 | 7,210.68 | 99.7 | 0 | a3fscdh3vfsym | e:(��:alr:И�Ѓ | SELECT grn#, net_grn grn, net_... | |
| 705,201,733 | 2 | 352,600,866.50 | 12.62 | 8,738.66 | 34.1 | 65.7 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 704,338,090 | 0 | 12.60 | 8,710.85 | 34 | 65.9 | d83kgsmws1rh0 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | BEGIN APPS.STGI_GLD_MAIN.EXTRA... | |
| 681,899,108 | 0 | 12.20 | 8,041.83 | 100 | 0 | gh19xxr7jc9wb | e:SQLGL:cp:tjtg/STGI_GLD_MAILER | BEGIN STGI_GLD_MAIN.MAILER(:er... | |
| 465,299,278 | 0 | 8.32 | 1,559.70 | 81.7 | 18.3 | 1c39wvc97qdf9 | rwrun@tjpsb005.ebs.in (TNS V1-V3) | SELECT WE.WIP_ENTITY_NAME WO, ... | |
| 394,695,740 | 45,468,796 | 8.68 | 7.06 | 5,524.95 | 11.2 | 0 | 1mr4u2r99v9vc | e:SQLAP:bes:oracle.apps.xla.accounting.preaccoun | SELECT PHASE_CODE, STATUS_CODE... |
| 249,526,080 | 22,080 | 11,301.00 | 4.46 | 1,622.97 | 99 | .4 | 3th40zct78hn3 | e:HXC:cp:hxt/XXT_OTL_EMPDAY_XML | SELECT EMPLOYEENO, NAME, FIT, ... |
| 228,386,245 | 1 | 228,386,245.00 | 4.09 | 1,899.87 | 79.2 | 20.4 | a2zjpprag1byn | e:HXC:cp:hxt/XXT_OTL_MAN_HRS_SUPER_USER | /* Formatted on 2015/04/07 17:... |
| 164,052,814 | 2 | 82,026,407.00 | 2.94 | 7,483.81 | 14 | 86.4 | 1pqj3r61tqvqc | e:PA:cp:tjtg/XXTJBASELINE | BEGIN xxtj_budget_baseline_pkg... |
| 160,587,387 | 6 | 26,764,564.50 | 2.87 | 7,068.63 | 14.3 | 86.1 | 1b21pwu4ufmfp | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_VERSIONS SET ... |
| 144,569,043 | 3 | 48,189,681.00 | 2.59 | 5,045.17 | 98.7 | 1 | 40ztcafr39k8m | e:PA:cp:tjtg/STGI_SEIBAN_COSTS_TO_KOUBAN | BEGIN stgi_seiban_costs_kouban... |
| 132,871,842 | 3 | 44,290,614.00 | 2.38 | 4,759.89 | 99.7 | 0 | 5tkmqssfdyrt4 | e:PA:cp:tjtg/STGI_SEIBAN_COSTS_TO_KOUBAN | SELECT W.TRANSACTION_DATE, TO_... |
| 92,063,069 | 28,152 | 3,270.21 | 1.65 | 755.51 | 92.6 | 6.8 | 7wrxvg70dwzcj | e:ALR:cp:tjtg/XXTJ_BUDGET_BALANCE | SELECT PROJECT_RATE_DATE, PROJ... |
| 84,100,090 | 1 | 84,100,090.00 | 1.50 | 287.95 | 84.7 | 14.8 | 6nqg41vk2zwgb | rwrun@tjpsb005.ebs.in (TNS V1-V3) | SELECT PR_SOURCE, PR, PR_DATE,... |
| 73,684,027 | 2,438 | 30,223.14 | 1.32 | 226.66 | 98.6 | 0 | 0sfn74nbwkmv8 | e:PO:frm:FNDRSRUN | SELECT CONCURRENT_PROGRAM_ID, ... |
| 63,069,315 | 1 | 63,069,315.00 | 1.13 | 478.83 | 88.1 | 11.7 | 8txssjmgpmms1 | TOAD background query session | SELECT task_number, decode(sub... |
| 57,942,151 | 1,944 | 29,805.63 | 1.04 | 331.92 | 99.5 | 0 | 8wpnwadparkdc | e:PA:cp:pa/PATTAR | SELECT * FROM JAI_TAX_DET_FACT... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- %Total - Physical Reads as a percentage of Total Disk Reads
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Total Disk Reads: 9,839,795
- Captured SQL account for 85.5% of Total
| Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 3,656,567 | 65 | 56,254.88 | 37.16 | 1,717.25 | 5.99 | 94.79 | ggbphm8skh52r | e:WIP:frm:WIPDJMDF | select 'x' from dual where :1 ... |
| 1,418,786 | 0 | 14.42 | 8,710.85 | 33.96 | 65.90 | d83kgsmws1rh0 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | BEGIN APPS.STGI_GLD_MAIN.EXTRA... | |
| 1,418,314 | 2 | 709,157.00 | 14.41 | 8,738.66 | 34.15 | 65.72 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 725,895 | 0 | 7.38 | 7,210.70 | 1.67 | 98.93 | 5mh5w2za6dpa5 | sqlplus@tjpsb004.ebs.in (TNS V1-V3) | SELECT /* + RULE */ df.tablesp... | |
| 575,671 | 2 | 287,835.50 | 5.85 | 7,483.81 | 14.04 | 86.39 | 1pqj3r61tqvqc | e:PA:cp:tjtg/XXTJBASELINE | BEGIN xxtj_budget_baseline_pkg... |
| 521,604 | 6 | 86,934.00 | 5.30 | 7,068.63 | 14.33 | 86.08 | 1b21pwu4ufmfp | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_VERSIONS SET ... |
| 514,441 | 1,865 | 275.84 | 5.23 | 6,097.00 | 2.08 | 98.51 | 8zy83jv9xwjvm | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_LINES PB SET ... |
| 283,177 | 2 | 141,588.50 | 2.88 | 184.28 | 5.95 | 94.38 | 75sdj7mrz5vrt | e:TJTG:frm:XXTJ_CBR_FORM | select distinct inventory_item... |
| 266,154 | 1 | 266,154.00 | 2.70 | 559.52 | 4.81 | 97.14 | dfxb82a14d5ts | toad.exe | select pat1.task_number, pabl1... |
| 259,505 | 2 | 129,752.50 | 2.64 | 192.17 | 6.09 | 94.48 | ggjdn7ytnkv2d | e:ALR:cp:tjtg/TJPS_ITEM_RECOVERABLE_UPDATE | BEGIN TJPS_ITEM_RECOVERABLE_UP... |
| 257,324 | 2 | 128,662.00 | 2.62 | 141.13 | 4.81 | 95.88 | 370npks3rtscd | e:ALR:cp:tjtg/TJPS_ITEM_RECOVERABLE_UPDATE | SELECT SEGMENT1 ITEM_CODE, INV... |
| 229,798 | 1 | 229,798.00 | 2.34 | 469.16 | 5.94 | 96.36 | dz05z8wartumr | toad.exe | select count(*) from ( select ... |
Back to SQL Statistics
Back to Top
SQL ordered by Physical Reads (UnOptimized)
- UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
- %Opt - Optimized Reads as percentage of SQL Read Requests
- %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
- Total Physical Read Requests: 3,913,942
- Captured SQL account for 59.6% of Total
- Total UnOptimized Read Requests: 3,913,942
- Captured SQL account for 59.6% of Total
- Total Optimized Read Requests: 1
- Captured SQL account for 0.0% of Total
| UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 856,889 | 856,889 | 0 | 0.00 | 21.89 | d83kgsmws1rh0 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | BEGIN APPS.STGI_GLD_MAIN.EXTRA... | |
| 856,791 | 856,791 | 2 | 428,395.50 | 0.00 | 21.89 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 575,663 | 575,663 | 2 | 287,831.50 | 0.00 | 14.71 | 1pqj3r61tqvqc | e:PA:cp:tjtg/XXTJBASELINE | BEGIN xxtj_budget_baseline_pkg... |
| 521,666 | 521,666 | 6 | 86,944.33 | 0.00 | 13.33 | 1b21pwu4ufmfp | e:TJTG:wf:XXTJCBR | UPDATE PA_BUDGET_VERSIONS SET ... |
| 266,051 | 266,051 | 1 | 266,051.00 | 0.00 | 6.80 | dfxb82a14d5ts | toad.exe | select pat1.task_number, pabl1... |
| 229,740 | 229,740 | 1 | 229,740.00 | 0.00 | 5.87 | dz05z8wartumr | toad.exe | select count(*) from ( select ... |
| 90,276 | 90,276 | 0 | 0.00 | 2.31 | 7whgw57ycjnwj | e:HXC:frm:FNDRSRUN | SELECT WORKGROUP, WORKGROUP VA... | |
| 62,370 | 62,370 | 0 | 0.00 | 1.59 | 1c39wvc97qdf9 | rwrun@tjpsb005.ebs.in (TNS V1-V3) | SELECT WE.WIP_ENTITY_NAME WO, ... | |
| 60,783 | 60,783 | 1 | 60,783.00 | 0.00 | 1.55 | 2wv3k32gn28jt | e:HXC:cp:hxt/XXT_OTL_COSTCENTER_SUPER_USER | SELECT q2.employee_number empl... |
| 40,968 | 40,968 | 17 | 2,409.88 | 0.00 | 1.05 | f3b04944y8d3x | e:TJTG:wf:XXTJCBR | INSERT INTO PJI_FP_XBS_ACCUM_F... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Total Executions: 58,972,904
- Captured SQL account for 80.6% of Total
| Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 45,468,796 | 45,462,455 | 1.00 | 5,524.95 | 11.2 | 0 | 1mr4u2r99v9vc | e:SQLAP:bes:oracle.apps.xla.accounting.preaccoun | SELECT PHASE_CODE, STATUS_CODE... |
| 472,336 | 472,336 | 1.00 | 14.13 | 100.9 | .2 | 7u60uugva48ux | e:PO:frm:JAIN57F4 | SELECT UOM_CODE FROM MTL_UNITS... |
| 321,793 | 292,431 | 0.91 | 16.51 | 76.4 | 8.7 | 0wmwsjy9kd92f | ICM@tjpsb005.ebs.in (TNS V1-V3) | SELECT PROFILE_OPTION_ID, APPL... |
| 310,740 | 86,138 | 0.28 | 10.60 | 87.6 | 2.2 | 7qs7fx89194u1 | ICM@tjpsb005.ebs.in (TNS V1-V3) | SELECT PROFILE_OPTION_VALUE FR... |
| 253,390 | 253,390 | 1.00 | 217.64 | 9.9 | 94.2 | fg043u7465vrx | e:SQLAP:frm:APXINWKB | SELECT (0 - SUM(NVL(AMOUNT, 0)... |
| 135,476 | 135,472 | 1.00 | 56.88 | 96.4 | 0 | dxr4zfffabqu7 | e:PO:frm:JAINSUMY | SELECT OOH.FLOW_STATUS_CODE ST... |
| 86,100 | 18,758 | 0.22 | 3.13 | 85.8 | 0 | 55dc767ajydh3 | e::cp:30 | SELECT PROFILE_OPTION_VALUE FR... |
| 66,180 | 66,180 | 1.00 | 6.76 | 100.1 | 0 | 6frgwbmhjkszt | TOAD background query session | SELECT NVL ((SELECT DR.IMPAIRM... |
| 66,180 | 66,180 | 1.00 | 6.73 | 101.4 | .6 | f2m0fxxuutzwq | TOAD background query session | SELECT NVL ((SELECT DR.DEPRN_R... |
| 42,869 | 42,868 | 1.00 | 25.72 | 41.3 | 1.5 | 2450j0nxcnga5 | ICM@tjpsb005.ebs.in (TNS V1-V3) | declare sql_dummy1 boolean;beg... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 1,679,336
- Captured SQL account for 51.7% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 472,306 | 472,336 | 28.12 | 7u60uugva48ux | e:PO:frm:JAIN57F4 | SELECT UOM_CODE FROM MTL_UNITS... |
| 66,180 | 66,180 | 3.94 | 6frgwbmhjkszt | TOAD background query session | SELECT NVL ((SELECT DR.IMPAIRM... |
| 66,180 | 66,180 | 3.94 | f2m0fxxuutzwq | TOAD background query session | SELECT NVL ((SELECT DR.DEPRN_R... |
| 28,974 | 28,984 | 1.73 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
| 24,613 | 310,740 | 1.47 | 7qs7fx89194u1 | ICM@tjpsb005.ebs.in (TNS V1-V3) | SELECT PROFILE_OPTION_VALUE FR... |
| 19,502 | 321,793 | 1.16 | 0wmwsjy9kd92f | ICM@tjpsb005.ebs.in (TNS V1-V3) | SELECT PROFILE_OPTION_ID, APPL... |
| 17,258 | 17,348 | 1.03 | a2g5ca6utfkv7 | JDBC Thin Client | SELECT USER_ID FROM FND_USER W... |
| 15,891 | 16,683 | 0.95 | gzytps4jufnzx | e:TJTG:fwk:pa.nonconformity.server.Nonconformity | SELECT NNR_TO FROM XXTJ_NNR_AC... |
| 15,712 | 15,712 | 0.94 | 3pyb4n4s3kbg2 | e:TJTG:wf:XXTJCBR | begin :con := "PA_CHNGE_DOC_PO... |
| 13,377 | 86,100 | 0.80 | 55dc767ajydh3 | e::cp:30 | SELECT PROFILE_OPTION_VALUE FR... |
Back to SQL Statistics
Back to Top
SQL ordered by Sharable Memory
- Only Statements with Sharable Memory greater than 1048576 are displayed
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 10,715,810 | 2 | 0.18 | 9fhhc2gu3f2b4 | e:SQLGL:cp:tjtg/STGI_GLD_MAIN | SELECT JV_VOUCHER#, STGI_GLD_M... |
| 10,637,648 | 19 | 0.18 | c23c02bjnh8qw | e:CST:cp:sqlgl/GLPPOSS | INSERT INTO GL_POSTING_INTERIM... |
| 7,256,128 | 0.13 | gpd9jhfgmp9zg | ** SQL Text Not Available ** | ||
| 6,876,992 | 0.12 | gn1tnqt1gv4zr | INSERT INTO PJI_PMV_ORGZ_DIM_T... | ||
| 5,266,686 | 1 | 0.09 | gu3tba9vv77zb | rwrun@tjpsb005.ebs.in (TNS V1-V3) | /* REM +=====================... |
| 5,168,822 | 1 | 0.09 | 0n18y3k48gm34 | rwrun@tjpsb005.ebs.in (TNS V1-V3) | /* REM +======================... |
| 5,141,014 | 1 | 0.09 | gu3tba9vv77zb | rwrun@tjpsb005.ebs.in (TNS V1-V3) | /* REM +=====================... |
| 5,047,150 | 1 | 0.09 | 0n18y3k48gm34 | rwrun@tjpsb005.ebs.in (TNS V1-V3) | /* REM +======================... |
| 4,276,849 | 19 | 0.07 | 3sc3wa7zhw2vn | e:CST:cp:sqlgl/GLPPOSS | update /*+ ORDERED INDEX (B, G... |
| 4,126,123 | 19 | 0.07 | 1t8pmtdkxv6u4 | e:SQLAP:cp:sqlgl/GLPPOSS | INSERT INTO GL_POSTING_INTERIM... |
| 3,949,564 | 3 | 0.07 | dacd5342f9yyw | e:PA:cp:pa/PARTAR | select /*+ LEADING(di) USE_NL(... |
| 3,868,400 | 19 | 0.07 | 00qqgyvc3nhs6 | e:CST:cp:sqlgl/GLPPOSS | insert into GL_BALANCES (ledge... |
| 3,221,207 | 3 | 0.06 | 9mvw4jjmbtnma | e:PA:cp:pa/PARTAR | select di.project_id , di.draf... |
| 2,613,299 | 357 | 0.05 | fpb1n08vhx0sc | e:PA:cp:PASMGR | DELETE PJI_PMV_ORG_DIM_TMP |
| 2,596,590 | 19 | 0.04 | 88xpp75djq2ar | e:CST:cp:sqlgl/GLPPOSS | INSERT INTO GL_POSTING_INTERIM... |
| 2,444,875 | 19 | 0.04 | 1t1ra9dr0v5na | e:CST:cp:sqlgl/GLPPOSS | insert into GL_BALANCES_DELTA ... |
| 2,402,995 | 8 | 0.04 | 17m2h4bjnymmd | e:PO:frm:RCVRCVRC | select * from RCV_VRC_TXS_VEND... |
| 2,394,251 | 2 | 0.04 | fjst7ahx9w9hj | rwrun@tjpsb005.ebs.in (TNS V1-V3) | /* Formatted on 2014/10/07 12... |
| 2,361,755 | 2 | 0.04 | fjst7ahx9w9hj | rwrun@tjpsb005.ebs.in (TNS V1-V3) | /* Formatted on 2014/10/07 12... |
| 2,176,441 | 8 | 0.04 | 26a2tvptkg3hw | e:SQLAP:cp:sqlap/APXEXPER | INSERT ALL WHEN (ZX_LOCATION_M... |
| 2,176,409 | 8 | 0.04 | 26a2tvptkg3hw | e:SQLAP:cp:sqlap/APXEXPER | INSERT ALL WHEN (ZX_LOCATION_M... |
| 2,005,107 | 5 | 0.03 | a39rnrg3rwkwx | e:CE:frm:CEXCABMR | SELECT MULTI_SELECT, TYPE_MEAN... |
| 1,988,883 | 5 | 0.03 | a39rnrg3rwkwx | e:CE:frm:CEXCABMR | SELECT MULTI_SELECT, TYPE_MEAN... |
| 1,769,764 | 27 | 0.03 | 1jwd11bkw0pxg | e:TJTG:wf:XXTJCBR | INSERT INTO PJI_FP_AGGR_PJP1_T... |
| 1,270,363 | 8 | 0.02 | 17m2h4bjnymmd | e:PO:frm:RCVRCVRC | select * from RCV_VRC_TXS_VEND... |
Back to SQL Statistics
Back to Top
SQL ordered by Version Count
- Only Statements with Version Count greater than 20 are displayed
| Version Count | Executions | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|
| 330 | gpd9jhfgmp9zg | ** SQL Text Not Available ** | ||
| 215 | gn1tnqt1gv4zr | INSERT INTO PJI_PMV_ORGZ_DIM_T... | ||
| 194 | 357 | fpb1n08vhx0sc | e:PA:cp:PASMGR | DELETE PJI_PMV_ORG_DIM_TMP |
| 182 | 357 | 9rfkxw1ntzbwt | e:PA:cp:PASMGR | DELETE PJI_PMV_ORGZ_DIM_TMP |
| 52 | 19 | 00qqgyvc3nhs6 | e:CST:cp:sqlgl/GLPPOSS | insert into GL_BALANCES (ledge... |
| 51 | 19 | 88xpp75djq2ar | e:CST:cp:sqlgl/GLPPOSS | INSERT INTO GL_POSTING_INTERIM... |
| 50 | 19 | 1t8pmtdkxv6u4 | e:SQLAP:cp:sqlgl/GLPPOSS | INSERT INTO GL_POSTING_INTERIM... |
| 50 | 19 | c23c02bjnh8qw | e:CST:cp:sqlgl/GLPPOSS | INSERT INTO GL_POSTING_INTERIM... |
| 43 | 19 | 1t1ra9dr0v5na | e:CST:cp:sqlgl/GLPPOSS | insert into GL_BALANCES_DELTA ... |
| 43 | 19 | 1t1ra9dr0v5na | e:CST:cp:sqlgl/GLPPOSS | insert into GL_BALANCES_DELTA ... |
| 41 | 19 | c7tsbdd5uv0ab | e:SQLAP:cp:sqlgl/GLPPOSS | SELECT LE.ledger_id, min(LE.cu... |
| 41 | 19 | c7tsbdd5uv0ab | e:SQLAP:cp:sqlgl/GLPPOSS | SELECT LE.ledger_id, min(LE.cu... |
| 40 | 19 | 3sc3wa7zhw2vn | e:CST:cp:sqlgl/GLPPOSS | update /*+ ORDERED INDEX (B, G... |
| 38 | 19 | 5vcp2gq6hb87p | e:CST:cp:sqlgl/GLPPOSS | select distinct ledger_id from... |
| 30 | 3 | 9mvw4jjmbtnma | e:PA:cp:pa/PARTAR | select di.project_id , di.draf... |
| 30 | 3 | 9mvw4jjmbtnma | e:PA:cp:pa/PARTAR | select di.project_id , di.draf... |
Back to SQL Statistics
Back to Top
Complete List of SQL Text
Back to SQL StatisticsBack to Top
Instance Activity Statistics
- Key Instance Activity Stats
- Other Instance Activity Stats
- Instance Activity Stats - Absolute Values
- Instance Activity Stats - Thread Activity
Key Instance Activity Stats
- Ordered by statistic name
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| db block changes | 12,258,910 | 1,700.14 | 122.27 |
| execute count | 58,972,904 | 8,178.74 | 588.22 |
| logons cumulative | 3,122 | 0.43 | 0.03 |
| opened cursors cumulative | 58,194,863 | 8,070.83 | 580.46 |
| parse count (total) | 1,679,336 | 232.90 | 16.75 |
| parse time elapsed | 18,598 | 2.58 | 0.19 |
| physical reads | 9,839,795 | 1,364.65 | 98.15 |
| physical writes | 914,261 | 126.80 | 9.12 |
| redo size | 2,398,146,200 | 332,590.19 | 23,919.99 |
| session cursor cache hits | 4,093,435 | 567.70 | 40.83 |
| session logical reads | 5,589,328,666 | 775,163.69 | 55,750.01 |
| user calls | 2,727,514 | 378.27 | 27.21 |
| user commits | 85,417 | 11.85 | 0.85 |
| user rollbacks | 14,840 | 2.06 | 0.15 |
| workarea executions - onepass | 9 | 0.00 | 0.00 |
| workarea executions - optimal | 3,480,544 | 482.70 | 34.72 |
Back to Instance Activity Statistics
Back to Top
Other Instance Activity Stats
- Ordered by statistic name
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| Batched IO (bound) vector count | 458,359 | 63.57 | 4.57 |
| Batched IO (full) vector count | 699 | 0.10 | 0.01 |
| Batched IO (space) vector count | 43 | 0.01 | 0.00 |
| Batched IO block miss count | 1,579,849 | 219.10 | 15.76 |
| Batched IO buffer defrag count | 763 | 0.11 | 0.01 |
| Batched IO double miss count | 29,744 | 4.13 | 0.30 |
| Batched IO same unit count | 971,507 | 134.73 | 9.69 |
| Batched IO single block count | 423,062 | 58.67 | 4.22 |
| Batched IO slow jump count | 30,304 | 4.20 | 0.30 |
| Batched IO vector block count | 186,279 | 25.83 | 1.86 |
| Batched IO vector read count | 36,227 | 5.02 | 0.36 |
| Block Cleanout Optim referenced | 6,183 | 0.86 | 0.06 |
| CCursor + sql area evicted | 39 | 0.01 | 0.00 |
| CPU used by this session | 10,011,096 | 1,388.40 | 99.85 |
| CPU used when call started | 1,992,977 | 276.40 | 19.88 |
| CR blocks created | 500,167 | 69.37 | 4.99 |
| Cached Commit SCN referenced | 20,544 | 2.85 | 0.20 |
| Commit SCN cached | 9,355 | 1.30 | 0.09 |
| DBWR checkpoint buffers written | 347,618 | 48.21 | 3.47 |
| DBWR checkpoints | 20 | 0.00 | 0.00 |
| DBWR object drop buffers written | 70 | 0.01 | 0.00 |
| DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 8 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 33 | 0.00 | 0.00 |
| DBWR thread checkpoint buffers written | 306,262 | 42.47 | 3.05 |
| DBWR transaction table writes | 1,810 | 0.25 | 0.02 |
| DBWR undo block writes | 131,678 | 18.26 | 1.31 |
| DFO trees parallelized | 0 | 0.00 | 0.00 |
| DML statements parallelized | 0 | 0.00 | 0.00 |
| Effective IO time | 792,807,274 | 109,951.56 | 7,907.75 |
| HSC Heap Segment Block Changes | 3,357,987 | 465.71 | 33.49 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 76,375 | 10.59 | 0.76 |
| Heap Segment Array Updates | 8,930 | 1.24 | 0.09 |
| IMU CR rollbacks | 12,932 | 1.79 | 0.13 |
| IMU Flushes | 41,475 | 5.75 | 0.41 |
| IMU Redo allocation size | 50,206,508 | 6,962.96 | 500.78 |
| IMU commits | 53,510 | 7.42 | 0.53 |
| IMU contention | 1,807 | 0.25 | 0.02 |
| IMU ktichg flush | 3,142 | 0.44 | 0.03 |
| IMU pool not allocated | 913 | 0.13 | 0.01 |
| IMU recursive-transaction flush | 354 | 0.05 | 0.00 |
| IMU undo allocation size | 199,221,880 | 27,629.36 | 1,987.11 |
| IMU- failed to get a private strand | 913 | 0.13 | 0.01 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 214,895 | 29.80 | 2.14 |
| PX local messages recv'd | 0 | 0.00 | 0.00 |
| PX local messages sent | 0 | 0.00 | 0.00 |
| Parallel operations downgraded 25 to 50 pct | 0 | 0.00 | 0.00 |
| Parallel operations downgraded 75 to 99 pct | 0 | 0.00 | 0.00 |
| Parallel operations downgraded to serial | 5 | 0.00 | 0.00 |
| Parallel operations not downgraded | 0 | 0.00 | 0.00 |
| Requests to/from client | 2,278,242 | 315.96 | 22.72 |
| RowCR - row contention | 3,343 | 0.46 | 0.03 |
| RowCR attempts | 6,262,139 | 868.47 | 62.46 |
| RowCR hits | 6,263,798 | 868.70 | 62.48 |
| SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 3 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 2,278,568 | 316.01 | 22.73 |
| SQL*Net roundtrips to/from dblink | 0 | 0.00 | 0.00 |
| active txn count during cleanout | 565,806 | 78.47 | 5.64 |
| background checkpoints completed | 8 | 0.00 | 0.00 |
| background checkpoints started | 8 | 0.00 | 0.00 |
| background timeouts | 43,365 | 6.01 | 0.43 |
| branch node splits | 45 | 0.01 | 0.00 |
| buffer is not pinned count | 4,028,002,438 | 558,629.03 | 40,176.77 |
| buffer is pinned count | 2,996,957,560 | 415,637.16 | 29,892.75 |
| bytes received via SQL*Net from client | 391,302,562 | 54,268.33 | 3,902.99 |
| bytes received via SQL*Net from dblink | 0 | 0.00 | 0.00 |
| bytes sent via SQL*Net to client | 713,441,538 | 98,944.62 | 7,116.13 |
| bytes sent via SQL*Net to dblink | 0 | 0.00 | 0.00 |
| calls to get snapshot scn: kcmgss | 59,423,656 | 8,241.25 | 592.71 |
| calls to kcmgas | 615,547 | 85.37 | 6.14 |
| calls to kcmgcs | 7,116,072 | 986.90 | 70.98 |
| cell physical IO interconnect bytes | 104,002,232,832 | 14,423,691.96 | 1,037,356.32 |
| change write time | 3,419 | 0.47 | 0.03 |
| cleanout - number of ktugct calls | 460,763 | 63.90 | 4.60 |
| cleanouts and rollbacks - consistent read gets | 364,667 | 50.57 | 3.64 |
| cleanouts only - consistent read gets | 19,084 | 2.65 | 0.19 |
| cluster key scan block gets | 102,326 | 14.19 | 1.02 |
| cluster key scans | 48,677 | 6.75 | 0.49 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 613 | 0.09 | 0.01 |
| commit batch/immediate requested | 613 | 0.09 | 0.01 |
| commit cleanout failures: block lost | 44,517 | 6.17 | 0.44 |
| commit cleanout failures: buffer being written | 4 | 0.00 | 0.00 |
| commit cleanout failures: cannot pin | 369 | 0.05 | 0.00 |
| commit cleanouts | 470,760 | 65.29 | 4.70 |
| commit immediate performed | 613 | 0.09 | 0.01 |
| commit immediate requested | 613 | 0.09 | 0.01 |
| commit txn count during cleanout | 72,818 | 10.10 | 0.73 |
| consistent changes | 65,260,182 | 9,050.70 | 650.93 |
| consistent gets | 5,574,631,821 | 773,125.44 | 55,603.42 |
| consistent gets - examination | 1,965,450,820 | 272,581.24 | 19,604.13 |
| consistent gets direct | 4,548,137 | 630.76 | 45.36 |
| consistent gets from cache | 5,570,083,676 | 772,494.68 | 55,558.05 |
| consistent gets from cache (fastpath) | 3,123,755,453 | 433,222.30 | 31,157.48 |
| cursor authentications | 850 | 0.12 | 0.01 |
| data blocks consistent reads - undo records applied | 63,945,879 | 8,868.42 | 637.82 |
| db block gets | 14,697,882 | 2,038.40 | 146.60 |
| db block gets direct | 19,553 | 2.71 | 0.20 |
| db block gets from cache | 14,678,329 | 2,035.68 | 146.41 |
| db block gets from cache (fastpath) | 3,956,123 | 548.66 | 39.46 |
| deferred (CURRENT) block cleanout applications | 123,297 | 17.10 | 1.23 |
| dirty buffers inspected | 6,624 | 0.92 | 0.07 |
| enqueue conversions | 7,005 | 0.97 | 0.07 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 634,256 | 87.96 | 6.33 |
| enqueue requests | 641,131 | 88.92 | 6.39 |
| enqueue timeouts | 6,469 | 0.90 | 0.06 |
| enqueue waits | 706 | 0.10 | 0.01 |
| exchange deadlocks | 20 | 0.00 | 0.00 |
| failed probes on index block reclamation | 419 | 0.06 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| frame signature mismatch | 0 | 0.00 | 0.00 |
| free buffer inspected | 5,463,905 | 757.77 | 54.50 |
| free buffer requested | 5,692,052 | 789.41 | 56.77 |
| heap block compress | 359,031 | 49.79 | 3.58 |
| hot buffers moved to head of LRU | 5,028,190 | 697.34 | 50.15 |
| immediate (CR) block cleanout applications | 383,751 | 53.22 | 3.83 |
| immediate (CURRENT) block cleanout applications | 83,082 | 11.52 | 0.83 |
| index crx upgrade (positioned) | 48,243 | 6.69 | 0.48 |
| index crx upgrade (prefetch) | 97,290 | 13.49 | 0.97 |
| index fast full scans (full) | 39 | 0.01 | 0.00 |
| index fetch by key | 906,752,852 | 125,754.26 | 9,044.28 |
| index scans kdiixs1 | 957,140,921 | 132,742.40 | 9,546.87 |
| java call heap collected bytes | 70,865,360 | 9,828.06 | 706.84 |
| java call heap collected count | 744,414 | 103.24 | 7.43 |
| java call heap gc count | 700 | 0.10 | 0.01 |
| java call heap live object count | 17,724 | 2.46 | 0.18 |
| java call heap live object count max | 50,386 | 6.99 | 0.50 |
| java call heap live size | 1,067,456 | 148.04 | 10.65 |
| java call heap live size max | 3,103,280 | 430.38 | 30.95 |
| java call heap object count | 107,897 | 14.96 | 1.08 |
| java call heap object count max | 187,851 | 26.05 | 1.87 |
| java call heap total size max | 32,768,000 | 4,544.47 | 326.84 |
| java call heap used size | 7,674,056 | 1,064.29 | 76.54 |
| java call heap used size max | 14,290,688 | 1,981.92 | 142.54 |
| java session heap live size | 20,484,096 | 2,840.86 | 204.32 |
| java session heap live size max | 20,484,096 | 2,840.86 | 204.32 |
| java session heap used size | 20,484,096 | 2,840.86 | 204.32 |
| java session heap used size max | 20,484,096 | 2,840.86 | 204.32 |
| leaf node 90-10 splits | 868 | 0.12 | 0.01 |
| leaf node splits | 11,032 | 1.53 | 0.11 |
| lob reads | 87,541 | 12.14 | 0.87 |
| lob writes | 103,596 | 14.37 | 1.03 |
| lob writes unaligned | 103,595 | 14.37 | 1.03 |
| logical read bytes from cache | 45,750,369,673,216 | 6,344,952,616.86 | 456,330,926.25 |
| max cf enq hold time | 20 | 0.00 | 0.00 |
| messages received | 117,556 | 16.30 | 1.17 |
| messages sent | 117,556 | 16.30 | 1.17 |
| min active SCN optimization applied on CR | 120,216 | 16.67 | 1.20 |
| no buffer to keep pinned count | 46,271,093 | 6,417.17 | 461.52 |
| no work - consistent read gets | 3,551,112,526 | 492,490.90 | 35,420.10 |
| non-idle wait count | 221,038,803 | 30,655.07 | 2,204.72 |
| parse count (describe) | 10 | 0.00 | 0.00 |
| parse count (failures) | 239 | 0.03 | 0.00 |
| parse count (hard) | 2,134 | 0.30 | 0.02 |
| parse time cpu | 16,268 | 2.26 | 0.16 |
| physical read IO requests | 3,913,942 | 542.81 | 39.04 |
| physical read bytes | 80,607,600,640 | 11,179,175.39 | 804,009.70 |
| physical read total IO requests | 3,951,855 | 548.07 | 39.42 |
| physical read total bytes | 85,886,107,136 | 11,911,232.28 | 856,659.46 |
| physical read total multi block requests | 241,553 | 33.50 | 2.41 |
| physical reads cache | 4,821,300 | 668.65 | 48.09 |
| physical reads cache prefetch | 1,307,244 | 181.30 | 13.04 |
| physical reads direct | 5,018,495 | 696.00 | 50.06 |
| physical reads direct (lob) | 20,661 | 2.87 | 0.21 |
| physical reads direct temporary tablespace | 460,204 | 63.82 | 4.59 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 275,409 | 38.20 | 2.75 |
| physical write bytes | 7,489,626,112 | 1,038,709.05 | 74,704.27 |
| physical write total IO requests | 616,142 | 85.45 | 6.15 |
| physical write total bytes | 18,116,117,504 | 2,512,458.54 | 180,696.78 |
| physical write total multi block requests | 25,815 | 3.58 | 0.26 |
| physical writes direct | 551,625 | 76.50 | 5.50 |
| physical writes direct (lob) | 18,349 | 2.54 | 0.18 |
| physical writes direct temporary tablespace | 530,214 | 73.53 | 5.29 |
| physical writes from cache | 362,636 | 50.29 | 3.62 |
| physical writes non checkpoint | 784,240 | 108.76 | 7.82 |
| pinned buffers inspected | 235 | 0.03 | 0.00 |
| pinned cursors current | 238 | 0.03 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 58 | 0.01 | 0.00 |
| process last non-idle time | 7,192 | 1.00 | 0.07 |
| queries parallelized | 0 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 114,762,172 | 15,915.95 | 1,144.68 |
| recursive cpu usage | 1,090,319 | 151.21 | 10.88 |
| redo KB read | 4,997,259 | 693.05 | 49.84 |
| redo KB read (memory) | 663,355 | 92.00 | 6.62 |
| redo KB read (memory) for transport | 663,355 | 92.00 | 6.62 |
| redo KB read for transport | 2,469,222 | 342.45 | 24.63 |
| redo blocks checksummed by FG (exclusive) | 1,307,588 | 181.34 | 13.04 |
| redo blocks written | 4,893,902 | 678.72 | 48.81 |
| redo buffer allocation retries | 326 | 0.05 | 0.00 |
| redo entries | 8,822,599 | 1,223.57 | 88.00 |
| redo entries for lost write detection | 2,745,505 | 380.76 | 27.38 |
| redo log space requests | 22 | 0.00 | 0.00 |
| redo ordering marks | 568 | 0.08 | 0.01 |
| redo size for direct writes | 160,570,124 | 22,268.89 | 1,601.59 |
| redo size for lost write detection | 178,634,932 | 24,774.23 | 1,781.77 |
| redo subscn max counts | 34,964 | 4.85 | 0.35 |
| redo synch long waits | 3,600 | 0.50 | 0.04 |
| redo synch poll writes | 23,022 | 3.19 | 0.23 |
| redo synch polls | 27,245 | 3.78 | 0.27 |
| redo synch time | 5,029 | 0.70 | 0.05 |
| redo synch time (usec) | 52,371,600 | 7,263.23 | 522.37 |
| redo synch time overhead (usec) | 462,096,657 | 64,086.51 | 4,609.12 |
| redo synch time overhead count (<128 msec) | 179 | 0.02 | 0.00 |
| redo synch time overhead count (<2 msec) | 50,030 | 6.94 | 0.50 |
| redo synch time overhead count (<32 msec) | 437 | 0.06 | 0.00 |
| redo synch time overhead count (<8 msec) | 1,535 | 0.21 | 0.02 |
| redo synch time overhead count (>=128 msec) | 187 | 0.03 | 0.00 |
| redo synch writes | 53,555 | 7.43 | 0.53 |
| redo wastage | 25,915,032 | 3,594.06 | 258.49 |
| redo write info find | 52,378 | 7.26 | 0.52 |
| redo write info find fail | 10 | 0.00 | 0.00 |
| redo write time | 7,962 | 1.10 | 0.08 |
| redo writes | 89,512 | 12.41 | 0.89 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 53,284 | 7.39 | 0.53 |
| rollbacks only - consistent read gets | 96,644 | 13.40 | 0.96 |
| root node splits | 1 | 0.00 | 0.00 |
| rows fetched via callback | 789,374,106 | 109,475.43 | 7,873.51 |
| session connect time | 0 | 0.00 | 0.00 |
| shared hash latch upgrades - no wait | 47,933,401 | 6,647.71 | 478.11 |
| shared hash latch upgrades - wait | 3,400 | 0.47 | 0.03 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 6,273,058 | 869.99 | 62.57 |
| sorts (rows) | 56,328,031 | 7,811.93 | 561.84 |
| sql area evicted | 980 | 0.14 | 0.01 |
| sql area purged | 374 | 0.05 | 0.00 |
| summed dirty queue length | 16,894 | 2.34 | 0.17 |
| switch current to new buffer | 117,977 | 16.36 | 1.18 |
| table fetch by rowid | 2,961,360,465 | 410,700.33 | 29,537.69 |
| table fetch continued row | 44,943,645 | 6,233.07 | 448.28 |
| table scan blocks gotten | 641,071,901 | 88,907.93 | 6,394.29 |
| table scan rows gotten | 46,730,074,551 | 6,480,824.33 | 466,102.86 |
| table scans (direct read) | 49 | 0.01 | 0.00 |
| table scans (long tables) | 112 | 0.02 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 984,309 | 136.51 | 9.82 |
| temp space allocated (bytes) | 1,180,696,576 | 163,746.52 | 11,776.70 |
| total cf enq hold time | 34,870 | 4.84 | 0.35 |
| total number of cf enq holders | 986 | 0.14 | 0.01 |
| total number of slots | 6 | 0.00 | 0.00 |
| total number of times SMON posted | 46 | 0.01 | 0.00 |
| transaction rollbacks | 410 | 0.06 | 0.00 |
| transaction tables consistent read rollbacks | 13 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 3,628 | 0.50 | 0.04 |
| undo change vector size | 935,732,312 | 129,773.32 | 9,333.34 |
| user logons cumulative | 3,083 | 0.43 | 0.03 |
| user logouts cumulative | 3,005 | 0.42 | 0.03 |
| write clones created in background | 78 | 0.01 | 0.00 |
| write clones created in foreground | 782 | 0.11 | 0.01 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
| Statistic | Begin Value | End Value |
|---|---|---|
| logons current | 347 | 425 |
| opened cursors current | 8,183 | 12,251 |
| session cursor cache count | 32,932,546 | 33,253,222 |
| session pga memory | 3,793,433,088 | 5,158,674,768 |
| session pga memory max | 6,242,170,432 | 9,564,837,744 |
| session uga memory | 20,390,023,656 | 21,543,194,848 |
| session uga memory max | 1,674,434,669,408 | 1,694,404,651,032 |
| workarea memory allocated | 122,695 | 239,874 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Thread Activity
- Statistics identified by '(derived)' come from sources other than SYSSTAT
| Statistic | Total | per Hour |
|---|---|---|
| log switches (derived) | 8 | 3.99 |
Back to Instance Activity Statistics
Back to Top
IO Stats
- IOStat by Function summary
- IOStat by Filetype summary
- IOStat by Function/Filetype summary
- Tablespace IO Stats
- File IO Stats
IOStat by Function summary
- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- ordered by (Data Read + Write) desc
| Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Direct Reads | 38G | 33.90 | 5.394M | 1.1G | 0.96 | .153M | 0 | |
| Buffer Cache Reads | 36.8G | 508.12 | 5.224M | 0M | 0.00 | 0M | 3514.6K | 7.49 |
| Others | 5G | 5.90 | .703M | 3G | 5.41 | .431M | 48.6K | 7.93 |
| LGWR | 3M | 0.04 | 0M | 7G | 42.54 | .995M | 89.9K | 0.42 |
| Direct Writes | 338M | 0.25 | .047M | 3G | 2.89 | .425M | 0 | |
| DBWR | 0M | 0.00 | 0M | 2.8G | 33.65 | .393M | 0 | |
| Streams AQ | 4M | 0.04 | .001M | 0M | 0.00 | 0M | 309 | 12.92 |
| TOTAL: | 80.1G | 548.24 | 11.37M | 16.9G | 85.46 | 2.396M | 3653.4K | 7.32 |
Back to IO Stats
Back to Top
IOStat by Filetype summary
- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- Small Read and Large Read are average service times, in milliseconds
- Ordered by (Data Read + Write) desc
| Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
|---|---|---|---|---|---|---|---|---|
| Data File | 71.6G | 539.68 | 10.162M | 2.9G | 34.36 | .41M | 8.66 | 78.07 |
| Log File | 4.1G | 0.62 | .588M | 7G | 42.51 | .995M | 4.81 | 2823.43 |
| Temp File | 3.6G | 3.41 | .511M | 4.1G | 3.84 | .58M | 24.75 | 9.17 |
| Archive Log | 242M | 0.03 | .034M | 2.4G | 0.34 | .342M | 56.37 | |
| Control File | 546M | 4.26 | .076M | 496M | 4.41 | .069M | 10.29 | 25.24 |
| Other | 4M | 0.27 | .001M | 0M | 0.00 | 0M | 3.76 | |
| TOTAL: | 80.1G | 548.27 | 11.371M | 16.9G | 85.46 | 2.395M | 8.75 | 124.18 |
Back to IO Stats
Back to Top
IOStat by Function/Filetype summary
- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- Ordered by (Data Read + Write) desc for each function
| Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Direct Reads | 38G | 33.91 | 5.397M | 1.1G | 0.96 | .153M | 0 | |
| Direct Reads (Data File) | 38G | 33.91 | 5.397M | 1.1G | 0.96 | .153M | 0 | |
| Buffer Cache Reads | 36.8G | 508.20 | 5.225M | 0M | 0.00 | 0M | 3479.7K | 7.50 |
| Buffer Cache Reads (Data File) | 36.8G | 508.20 | 5.225M | 0M | 0.00 | 0M | 3479.7K | 7.50 |
| Others | 4.9G | 5.63 | .702M | 3G | 5.41 | .431M | 36.1K | 10.40 |
| Others (Log File) | 4.1G | 0.61 | .588M | 0M | 0.00 | 0M | 164 | 2.71 |
| Others (Archive Log) | 242M | 0.03 | .034M | 2.4G | 0.34 | .342M | 0 | |
| Others (Control File) | 541M | 4.24 | .075M | 493M | 4.37 | .068M | 30.5K | 10.32 |
| Others (Data File) | 42M | 0.75 | .006M | 143M | 0.70 | .02M | 5410 | 11.09 |
| LGWR | 3M | 0.04 | 0M | 7G | 42.55 | .995M | 302 | 9.43 |
| LGWR (Log File) | 0M | 0.01 | 0M | 7G | 42.51 | .995M | 96 | 6.16 |
| LGWR (Control File) | 3M | 0.03 | 0M | 3M | 0.03 | 0M | 206 | 10.96 |
| Direct Writes | 338M | 0.25 | .047M | 3G | 2.89 | .425M | 0 | |
| Direct Writes (Data File) | 338M | 0.25 | .047M | 3G | 2.89 | .425M | 0 | |
| DBWR | 0M | 0.00 | 0M | 2.8G | 33.65 | .393M | 0 | |
| DBWR (Data File) | 0M | 0.00 | 0M | 2.8G | 33.65 | .393M | 0 | |
| Streams AQ | 4M | 0.04 | .001M | 0M | 0.00 | 0M | 309 | 12.92 |
| Streams AQ (Data File) | 4M | 0.04 | .001M | 0M | 0.00 | 0M | 309 | 12.92 |
| TOTAL: | 80.1G | 548.06 | 11.372M | 16.9G | 85.46 | 2.396M | 3516.4K | 7.53 |
Back to IO Stats
Back to Top
Tablespace IO Stats
- ordered by IOs (Reads + Writes) desc
| Tablespace | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|---|---|
| APPS_TS_TX_DATA | 2,979,738 | 413 | 6.60 | 2.51 | 37,400 | 355.54 | 7 | 5 | 32,101 | 2.62 |
| APPS_TS_TX_IDX | 654,232 | 91 | 8.97 | 1.00 | 135,333 | 90.72 | 9 | 19 | 5,046 | 6.23 |
| APPS_UNDOTS1 | 2,244 | 0 | 3.91 | 1.00 | 58,065 | 0.31 | 4 | 8 | 524 | 0.11 |
| TEMP1 | 24,137 | 3 | 0.44 | 19.00 | 27,678 | 0.10 | 14 | 4 | 0 | 0.00 |
| APPS_TS_SEED | 49,810 | 7 | 10.90 | 1.17 | 171 | 6.78 | 11 | 0 | 36 | 19.44 |
| APPS_TS_SUMMARY | 42,060 | 6 | 8.67 | 1.00 | 244 | 5.83 | 9 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | 41,120 | 6 | 7.34 | 1.12 | 700 | 5.60 | 7 | 0 | 68 | 7.65 |
| APPS_TS_ARCHIVE | 25,154 | 3 | 10.87 | 1.00 | 2,382 | 3.49 | 11 | 0 | 0 | 0.00 |
| SYSAUX | 24,595 | 3 | 4.99 | 1.19 | 2,190 | 3.39 | 5 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | 16,137 | 2 | 8.15 | 1.84 | 8,077 | 1.61 | 11 | 1 | 0 | 0.00 |
| SYSTEM | 21,326 | 3 | 4.15 | 45.71 | 1,778 | 1.68 | 7 | 0 | 283 | 10.92 |
| USERS | 19,224 | 3 | 3.90 | 1.00 | 28 | 2.67 | 4 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | 4,571 | 1 | 7.15 | 1.04 | 1,108 | 0.63 | 7 | 0 | 2 | 0.00 |
| TJTG | 5,162 | 1 | 8.41 | 2.07 | 164 | 0.66 | 8 | 0 | 58 | 3.97 |
| APPS_TS_NOLOGGING | 2,601 | 0 | 9.52 | 1.00 | 9 | 0.36 | 10 | 0 | 0 | 0.00 |
| CTXD | 637 | 0 | 3.78 | 1.00 | 17 | 0.09 | 4 | 0 | 0 | 0.00 |
| ODM | 607 | 0 | 4.37 | 1.00 | 7 | 0.08 | 4 | 0 | 0 | 0.00 |
| PORTAL | 89 | 0 | 1.46 | 1.00 | 7 | 0.01 | 1 | 0 | 0 | 0.00 |
| APPS_RO_DATA | 42 | 0 | 0.00 | 1.00 | 7 | 0.01 | 0 | 0 | 0 | 0.00 |
| OLAP | 14 | 0 | 0.00 | 1.00 | 14 | 0.00 | 0 | 0 | 0 | 0.00 |
| APPS_TS_TOOLS | 7 | 0 | 0.00 | 1.00 | 7 | 0.00 | 0 | 0 | 0 | 0.00 |
| OWAPUB | 7 | 0 | 0.00 | 1.00 | 7 | 0.00 | 0 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
File IO Stats
- ordered by Tablespace, File
| Tablespace | Filename | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| APPS_RO_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/apps_ro_data01.dbf | 42 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /oradb/oracle/product/TJTG/db/apps_st/data/a_archive01.dbf | 24,655 | 3 | 10.84 | 1.00 | 3 | 10.84 | 2,251 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /oradb/oracle/product/TJTG/db/apps_st/data/a_archive02.dbf | 381 | 0 | 13.02 | 1.00 | 0 | 13.02 | 87 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /oradb/oracle/product/TJTG/db/apps_st/data/a_archive03.dbf | 118 | 0 | 10.42 | 1.00 | 0 | 10.42 | 44 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /oradb/oracle/product/TJTG/db/apps_st/data/a_int01.dbf | 33,043 | 5 | 8.07 | 1.06 | 5 | 8.07 | 252 | 0 | 35 | 10.00 |
| APPS_TS_INTERFACE | /oradb/oracle/product/TJTG/db/apps_st/data/a_int02.dbf | 6,120 | 1 | 4.53 | 1.42 | 1 | 4.37 | 320 | 0 | 28 | 5.71 |
| APPS_TS_INTERFACE | /oradb/oracle/product/TJTG/db/apps_st/data/a_int03.dbf | 1,957 | 0 | 3.81 | 1.22 | 0 | 3.76 | 128 | 0 | 5 | 2.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media01.dbf | 1,615 | 0 | 11.48 | 1.26 | 0 | 12.53 | 350 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media02.dbf | 703 | 0 | 8.79 | 1.41 | 0 | 10.18 | 249 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media03.dbf | 1,257 | 0 | 8.82 | 1.75 | 0 | 11.77 | 662 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media04.dbf | 1,385 | 0 | 9.63 | 1.58 | 0 | 11.93 | 689 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media05.dbf | 1,656 | 0 | 10.05 | 1.77 | 0 | 13.51 | 878 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media06.dbf | 2,273 | 0 | 6.51 | 1.92 | 0 | 9.37 | 1,308 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media07.dbf | 1,464 | 0 | 6.78 | 2.03 | 0 | 10.34 | 884 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media08.dbf | 1,981 | 0 | 6.26 | 2.15 | 0 | 10.14 | 1,091 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media088.dbf | 2,257 | 0 | 7.75 | 2.00 | 0 | 11.64 | 1,257 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /oradb/oracle/product/TJTG/db/apps_st/data/a_media090.dbf | 1,546 | 0 | 7.22 | 2.11 | 0 | 11.47 | 709 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /oradb/oracle/product/TJTG/db/apps_st/data/a_nolog01.dbf | 2,601 | 0 | 9.52 | 1.00 | 0 | 9.52 | 9 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /oradb/oracle/product/TJTG/db/apps_st/data/a_queue01.dbf | 3,836 | 1 | 6.47 | 1.02 | 1 | 6.46 | 627 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES | /oradb/oracle/product/TJTG/db/apps_st/data/a_queue02.dbf | 666 | 0 | 11.46 | 1.12 | 0 | 11.42 | 472 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES | /oradb/oracle/product/TJTG/db/apps_st/data/a_queue03.dbf | 69 | 0 | 3.62 | 1.41 | 0 | 3.58 | 9 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oradb/oracle/product/TJTG/db/apps_st/data/a_ref01.dbf | 26,676 | 4 | 10.74 | 1.15 | 4 | 10.82 | 58 | 0 | 30 | 20.67 |
| APPS_TS_SEED | /oradb/oracle/product/TJTG/db/apps_st/data/a_ref02.dbf | 20,942 | 3 | 10.84 | 1.17 | 3 | 10.89 | 42 | 0 | 6 | 13.33 |
| APPS_TS_SEED | /oradb/oracle/product/TJTG/db/apps_st/data/a_ref03.dbf | 2,019 | 0 | 13.37 | 1.32 | 0 | 13.61 | 64 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /oradb/oracle/product/TJTG/db/apps_st/data/a_ref04.dbf | 173 | 0 | 15.61 | 1.00 | 0 | 15.61 | 7 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oradb/oracle/product/TJTG/db/apps_st/data/a_summ01.dbf | 39,518 | 5 | 8.67 | 1.00 | 5 | 8.67 | 96 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oradb/oracle/product/TJTG/db/apps_st/data/a_summ02.dbf | 467 | 0 | 11.65 | 1.00 | 0 | 11.65 | 70 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oradb/oracle/product/TJTG/db/apps_st/data/a_summ03.dbf | 1,022 | 0 | 8.19 | 1.00 | 0 | 8.19 | 18 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oradb/oracle/product/TJTG/db/apps_st/data/a_summ04.dbf | 102 | 0 | 8.82 | 1.00 | 0 | 8.82 | 45 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind08.dbf | 951 | 0 | 7.39 | 1.00 | 0 | 7.39 | 15 | 0 | 0 | 0.00 |
| APPS_TS_TOOLS | /oradb/oracle/product/TJTG/db/apps_st/data/apps_ts_tools01.dbf | 7 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data01.dbf | 104,929 | 15 | 7.99 | 2.77 | 12 | 9.20 | 1,432 | 0 | 1,143 | 3.31 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data02.dbf | 152,066 | 21 | 6.89 | 2.84 | 17 | 7.91 | 1,537 | 0 | 1,888 | 2.44 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data03.dbf | 154,183 | 21 | 6.09 | 3.19 | 17 | 7.22 | 2,241 | 0 | 2,438 | 2.02 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data04.dbf | 139,819 | 19 | 5.91 | 3.96 | 14 | 7.45 | 1,884 | 0 | 3,923 | 1.84 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data05.dbf | 37,536 | 5 | 6.99 | 4.24 | 4 | 8.34 | 845 | 0 | 1,443 | 0.51 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data06.dbf | 44,982 | 6 | 7.70 | 2.38 | 6 | 8.16 | 885 | 0 | 576 | 4.58 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data07.dbf | 32,108 | 4 | 7.55 | 2.11 | 4 | 8.00 | 276 | 0 | 317 | 1.92 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data08.dbf | 27,865 | 4 | 7.08 | 2.98 | 3 | 7.82 | 181 | 0 | 664 | 2.55 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data09.dbf | 52,393 | 7 | 4.90 | 4.14 | 5 | 6.61 | 587 | 0 | 2,190 | 0.86 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data10.dbf | 48,525 | 7 | 4.59 | 4.87 | 4 | 6.55 | 469 | 0 | 2,499 | 1.07 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data107.dbf | 51,214 | 7 | 7.38 | 1.89 | 6 | 7.45 | 272 | 0 | 323 | 5.73 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data11.dbf | 36,454 | 5 | 5.85 | 3.78 | 4 | 7.06 | 228 | 0 | 1,197 | 1.60 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data118.dbf | 62,977 | 9 | 5.08 | 1.62 | 8 | 5.11 | 60 | 0 | 165 | 2.12 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data12.dbf | 45,075 | 6 | 5.16 | 3.88 | 4 | 6.67 | 406 | 0 | 1,712 | 1.75 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data13.dbf | 45,723 | 6 | 5.09 | 3.61 | 5 | 6.20 | 323 | 0 | 1,577 | 1.24 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data14.dbf | 32,570 | 5 | 6.19 | 3.49 | 4 | 7.22 | 313 | 0 | 860 | 2.09 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data15.dbf | 34,435 | 5 | 6.39 | 3.56 | 4 | 7.11 | 375 | 0 | 691 | 2.33 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data16.dbf | 32,808 | 5 | 6.57 | 2.88 | 4 | 7.07 | 283 | 0 | 482 | 4.48 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data17.dbf | 33,205 | 5 | 7.65 | 3.11 | 4 | 8.19 | 341 | 0 | 398 | 4.80 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data18.dbf | 28,982 | 4 | 7.65 | 2.59 | 3 | 8.21 | 488 | 0 | 219 | 5.80 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data19.dbf | 16,402 | 2 | 7.72 | 2.06 | 2 | 8.08 | 182 | 0 | 2 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data191.dbf | 53,164 | 7 | 5.77 | 1.61 | 7 | 5.76 | 299 | 0 | 558 | 5.50 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data192.dbf | 75,087 | 10 | 7.29 | 2.36 | 9 | 7.37 | 400 | 0 | 237 | 6.71 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data20.dbf | 5,630 | 1 | 9.81 | 1.26 | 1 | 9.95 | 18 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data201.dbf | 61,270 | 8 | 5.92 | 1.61 | 8 | 6.07 | 231 | 0 | 512 | 4.47 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data208.dbf | 77,477 | 11 | 5.21 | 1.18 | 11 | 5.18 | 156 | 0 | 305 | 4.79 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data209.dbf | 70,754 | 10 | 5.18 | 1.32 | 9 | 5.18 | 41 | 0 | 197 | 7.11 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data21.dbf | 5,173 | 1 | 10.20 | 1.22 | 1 | 10.33 | 11 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data210.dbf | 72,046 | 10 | 5.49 | 1.31 | 10 | 5.49 | 192 | 0 | 277 | 4.84 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data211.dbf | 85,476 | 12 | 5.92 | 1.71 | 11 | 6.00 | 337 | 0 | 625 | 3.54 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data212.dbf | 86,637 | 12 | 6.12 | 1.73 | 11 | 6.19 | 285 | 0 | 657 | 3.36 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data213.dbf | 74,300 | 10 | 5.87 | 1.27 | 10 | 5.86 | 191 | 0 | 280 | 3.68 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data214.dbf | 74,337 | 10 | 5.77 | 1.32 | 10 | 5.70 | 641 | 0 | 476 | 4.83 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data215.dbf | 70,866 | 10 | 6.46 | 1.39 | 9 | 6.37 | 790 | 0 | 543 | 5.21 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data216.dbf | 71,998 | 10 | 7.14 | 1.49 | 9 | 7.09 | 2,872 | 0 | 727 | 5.47 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data217.dbf | 45,798 | 6 | 7.79 | 1.62 | 6 | 7.80 | 2,860 | 0 | 620 | 4.89 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data218.dbf | 36,033 | 5 | 8.35 | 1.60 | 5 | 8.36 | 2,914 | 0 | 537 | 5.47 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data219.dbf | 27,119 | 4 | 9.04 | 1.61 | 3 | 9.11 | 2,033 | 0 | 350 | 5.34 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data22.dbf | 5,311 | 1 | 10.76 | 1.54 | 1 | 11.09 | 15 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data220.dbf | 20,546 | 3 | 8.94 | 1.66 | 3 | 9.04 | 2,300 | 0 | 308 | 5.62 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data23.dbf | 26,073 | 4 | 7.24 | 3.35 | 3 | 7.89 | 270 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data24.dbf | 36,943 | 5 | 7.14 | 2.31 | 5 | 7.30 | 274 | 0 | 2 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data25.dbf | 32,429 | 4 | 7.18 | 2.32 | 4 | 7.45 | 326 | 0 | 3 | 3.33 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data26.dbf | 27,711 | 4 | 7.11 | 2.58 | 3 | 7.65 | 334 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data27.dbf | 29,206 | 4 | 7.43 | 2.32 | 4 | 7.89 | 436 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data28.dbf | 33,123 | 5 | 6.96 | 2.87 | 4 | 7.45 | 447 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data29.dbf | 23,072 | 3 | 8.18 | 2.27 | 3 | 8.67 | 277 | 0 | 1 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data30.dbf | 30,337 | 4 | 6.63 | 2.82 | 4 | 7.11 | 268 | 0 | 4 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data31.dbf | 28,422 | 4 | 7.29 | 2.72 | 3 | 7.89 | 350 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data32.dbf | 37,689 | 5 | 7.26 | 3.49 | 4 | 7.93 | 244 | 0 | 4 | 2.50 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data33.dbf | 29,112 | 4 | 7.15 | 2.95 | 3 | 7.58 | 794 | 0 | 16 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data34.dbf | 25,915 | 4 | 6.75 | 3.54 | 3 | 7.59 | 187 | 0 | 2 | 5.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data35.dbf | 33,138 | 5 | 6.08 | 5.00 | 3 | 7.24 | 282 | 0 | 1 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data36.dbf | 33,603 | 5 | 6.57 | 3.96 | 4 | 7.35 | 209 | 0 | 54 | 2.22 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data37.dbf | 32,295 | 4 | 7.41 | 2.31 | 4 | 7.74 | 259 | 0 | 58 | 1.55 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data38.dbf | 30,559 | 4 | 7.28 | 2.35 | 4 | 7.61 | 317 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data39.dbf | 36,331 | 5 | 7.19 | 2.27 | 4 | 7.50 | 328 | 0 | 5 | 2.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data40.dbf | 33,371 | 5 | 7.61 | 2.24 | 4 | 7.83 | 286 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data41.dbf | 34,451 | 5 | 7.99 | 2.03 | 4 | 8.12 | 335 | 0 | 10 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data42.dbf | 72,116 | 10 | 7.09 | 2.54 | 9 | 7.38 | 512 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_data43.dbf | 80,569 | 11 | 7.58 | 2.37 | 10 | 7.87 | 471 | 0 | 3 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind01.dbf | 43,428 | 6 | 11.19 | 1.00 | 6 | 11.19 | 1,648 | 0 | 169 | 7.22 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind0102.dbf | 6,309 | 1 | 8.57 | 1.00 | 1 | 8.57 | 424 | 0 | 20 | 11.50 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind02.dbf | 37,142 | 5 | 9.22 | 1.00 | 5 | 9.22 | 5,064 | 1 | 87 | 4.83 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind03.dbf | 47,767 | 7 | 11.05 | 1.00 | 7 | 11.05 | 1,850 | 0 | 373 | 6.97 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind04.dbf | 51,223 | 7 | 10.65 | 1.00 | 7 | 10.65 | 4,217 | 1 | 1,117 | 3.98 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind05.dbf | 39,261 | 5 | 8.92 | 1.00 | 5 | 8.92 | 2,114 | 0 | 194 | 6.96 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind06.dbf | 13,538 | 2 | 9.92 | 1.00 | 2 | 9.92 | 4,654 | 1 | 202 | 5.40 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind064.dbf | 5,664 | 1 | 8.05 | 1.00 | 1 | 8.05 | 1,067 | 0 | 16 | 11.25 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind065.dbf | 5,924 | 1 | 7.96 | 1.00 | 1 | 7.96 | 1,026 | 0 | 20 | 9.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind07.dbf | 10,768 | 1 | 8.84 | 1.00 | 1 | 8.84 | 2,820 | 0 | 406 | 4.80 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind09.dbf | 8,226 | 1 | 9.21 | 1.00 | 1 | 9.21 | 1,545 | 0 | 181 | 5.03 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind093.dbf | 7,340 | 1 | 9.61 | 1.00 | 1 | 9.61 | 433 | 0 | 42 | 7.38 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind10.dbf | 1,774 | 0 | 10.82 | 1.00 | 0 | 10.82 | 578 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind101.dbf | 4,912 | 1 | 5.70 | 1.00 | 1 | 5.70 | 70 | 0 | 5 | 38.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind109.dbf | 7,691 | 1 | 8.10 | 1.00 | 1 | 8.10 | 405 | 0 | 27 | 8.15 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind11.dbf | 2,026 | 0 | 10.32 | 1.00 | 0 | 10.32 | 531 | 0 | 3 | 3.33 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind111.dbf | 3,909 | 1 | 6.53 | 1.00 | 1 | 6.53 | 260 | 0 | 16 | 11.25 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind112.dbf | 895 | 0 | 10.78 | 1.00 | 0 | 10.77 | 30 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind113.dbf | 5,558 | 1 | 8.33 | 1.00 | 1 | 8.34 | 234 | 0 | 12 | 14.17 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind114.dbf | 6,230 | 1 | 7.94 | 1.00 | 1 | 7.94 | 246 | 0 | 6 | 16.67 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind115.dbf | 24,880 | 3 | 5.77 | 1.00 | 3 | 5.77 | 488 | 0 | 76 | 6.45 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind116.dbf | 3,850 | 1 | 3.55 | 1.00 | 1 | 3.55 | 34 | 0 | 2 | 5.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind117.dbf | 4,109 | 1 | 5.09 | 1.00 | 1 | 5.09 | 98 | 0 | 32 | 5.31 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind118.dbf | 4,884 | 1 | 6.08 | 1.00 | 1 | 6.08 | 143 | 0 | 20 | 11.50 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind119.dbf | 4,028 | 1 | 4.02 | 1.00 | 1 | 4.02 | 48 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind12.dbf | 1,774 | 0 | 10.34 | 1.00 | 0 | 10.34 | 481 | 0 | 6 | 1.67 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind120.dbf | 6,166 | 1 | 5.17 | 1.00 | 1 | 5.17 | 105 | 0 | 38 | 2.11 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind121.dbf | 8,181 | 1 | 8.11 | 1.00 | 1 | 8.11 | 431 | 0 | 54 | 6.85 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind122.dbf | 6,302 | 1 | 6.18 | 1.00 | 1 | 6.18 | 262 | 0 | 8 | 6.25 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind123.dbf | 4,525 | 1 | 4.64 | 1.00 | 1 | 4.64 | 105 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind124.dbf | 4,528 | 1 | 5.23 | 1.00 | 1 | 5.23 | 130 | 0 | 7 | 5.71 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind125.dbf | 4,977 | 1 | 4.81 | 1.00 | 1 | 4.81 | 344 | 0 | 3 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind126.dbf | 5,371 | 1 | 5.40 | 1.00 | 1 | 5.40 | 425 | 0 | 6 | 6.67 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind127.dbf | 5,374 | 1 | 5.49 | 1.00 | 1 | 5.49 | 523 | 0 | 12 | 10.83 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind128.dbf | 6,153 | 1 | 7.21 | 1.00 | 1 | 7.21 | 853 | 0 | 13 | 3.85 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind129.dbf | 11,654 | 2 | 8.08 | 1.00 | 2 | 8.08 | 9,934 | 1 | 24 | 11.25 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind13.dbf | 1,755 | 0 | 11.01 | 1.00 | 0 | 11.01 | 411 | 0 | 11 | 0.91 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind130.dbf | 11,169 | 2 | 8.82 | 1.00 | 2 | 8.82 | 12,029 | 2 | 35 | 12.29 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind131.dbf | 10,610 | 1 | 8.56 | 1.00 | 1 | 8.55 | 11,957 | 2 | 63 | 6.19 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind132.dbf | 9,445 | 1 | 8.33 | 1.00 | 1 | 8.33 | 11,507 | 2 | 23 | 8.26 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind133.dbf | 9,904 | 1 | 9.01 | 1.00 | 1 | 9.02 | 11,527 | 2 | 26 | 8.85 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind134.dbf | 8,365 | 1 | 8.44 | 1.00 | 1 | 8.44 | 11,322 | 2 | 28 | 3.21 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind135.dbf | 8,211 | 1 | 8.52 | 1.00 | 1 | 8.52 | 11,608 | 2 | 89 | 3.71 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind14.dbf | 1,251 | 0 | 10.52 | 1.00 | 0 | 10.52 | 339 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind15.dbf | 1,963 | 0 | 8.22 | 1.00 | 0 | 8.22 | 429 | 0 | 7 | 5.71 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind16.dbf | 2,314 | 0 | 8.82 | 1.00 | 0 | 8.83 | 446 | 0 | 22 | 1.82 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind17.dbf | 2,629 | 0 | 9.14 | 1.00 | 0 | 9.14 | 643 | 0 | 23 | 9.13 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind18.dbf | 1,172 | 0 | 10.22 | 1.00 | 0 | 10.23 | 134 | 0 | 6 | 23.33 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind189.dbf | 7,916 | 1 | 9.53 | 1.00 | 1 | 9.53 | 527 | 0 | 53 | 11.13 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind19.dbf | 4,106 | 1 | 9.55 | 1.00 | 1 | 9.55 | 807 | 0 | 66 | 5.45 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind20.dbf | 3,910 | 1 | 8.50 | 1.00 | 1 | 8.50 | 759 | 0 | 72 | 7.08 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind21.dbf | 4,248 | 1 | 8.76 | 1.00 | 1 | 8.77 | 600 | 0 | 47 | 3.83 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind22.dbf | 3,169 | 0 | 9.60 | 1.00 | 0 | 9.60 | 348 | 0 | 29 | 8.97 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind23.dbf | 4,637 | 1 | 8.70 | 1.00 | 1 | 8.71 | 419 | 0 | 41 | 10.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind24.dbf | 3,509 | 0 | 9.24 | 1.00 | 0 | 9.24 | 531 | 0 | 29 | 10.34 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind25.dbf | 2,413 | 0 | 8.67 | 1.00 | 0 | 8.67 | 231 | 0 | 16 | 11.25 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind26.dbf | 600 | 0 | 9.37 | 1.00 | 0 | 9.37 | 36 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind27.dbf | 537 | 0 | 9.89 | 1.00 | 0 | 9.89 | 27 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind28.dbf | 420 | 0 | 10.48 | 1.00 | 0 | 10.45 | 17 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind29.dbf | 473 | 0 | 9.89 | 1.00 | 0 | 9.89 | 17 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind30.dbf | 739 | 0 | 9.50 | 1.00 | 0 | 9.50 | 15 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind31.dbf | 375 | 0 | 12.93 | 1.00 | 0 | 12.91 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind32.dbf | 424 | 0 | 9.55 | 1.00 | 0 | 9.55 | 20 | 0 | 5 | 6.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind33.dbf | 648 | 0 | 10.43 | 1.00 | 0 | 10.43 | 28 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind34.dbf | 7,466 | 1 | 9.22 | 1.00 | 1 | 9.22 | 735 | 0 | 57 | 8.42 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind35.dbf | 3,836 | 1 | 9.42 | 1.00 | 1 | 9.42 | 534 | 0 | 15 | 7.33 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind36.dbf | 5,736 | 1 | 9.50 | 1.00 | 1 | 9.50 | 2,113 | 0 | 24 | 6.67 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind37.dbf | 3,880 | 1 | 9.46 | 1.00 | 1 | 9.46 | 595 | 0 | 21 | 7.14 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind38.dbf | 3,564 | 0 | 9.60 | 1.00 | 0 | 9.61 | 602 | 0 | 3 | 3.33 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind39.dbf | 2,735 | 0 | 9.70 | 1.00 | 0 | 9.70 | 378 | 0 | 10 | 11.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind40.dbf | 3,496 | 0 | 9.61 | 1.00 | 0 | 9.61 | 497 | 0 | 15 | 10.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind41.dbf | 3,375 | 0 | 9.40 | 1.00 | 0 | 9.41 | 396 | 0 | 29 | 9.66 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind42.dbf | 3,087 | 0 | 9.82 | 1.00 | 0 | 9.82 | 192 | 0 | 7 | 7.14 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind43.dbf | 3,713 | 1 | 9.38 | 1.00 | 1 | 9.38 | 385 | 0 | 28 | 15.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind44.dbf | 4,090 | 1 | 9.22 | 1.00 | 1 | 9.22 | 311 | 0 | 33 | 6.67 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind44.dbf; | 2,386 | 0 | 8.93 | 1.00 | 0 | 8.93 | 133 | 0 | 5 | 8.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind45.dbf | 4,099 | 1 | 8.85 | 1.00 | 1 | 8.85 | 230 | 0 | 82 | 5.24 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind46.dbf | 3,834 | 1 | 9.43 | 1.00 | 1 | 9.43 | 330 | 0 | 27 | 9.63 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind47.dbf | 3,434 | 0 | 9.20 | 1.00 | 0 | 9.20 | 405 | 0 | 34 | 9.12 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind48.dbf | 3,753 | 1 | 9.87 | 1.00 | 1 | 9.87 | 1,237 | 0 | 49 | 6.12 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind49.dbf | 3,102 | 0 | 9.68 | 1.00 | 0 | 9.69 | 683 | 0 | 20 | 11.50 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind50.dbf | 1,655 | 0 | 8.20 | 1.00 | 0 | 8.20 | 144 | 0 | 13 | 4.62 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind51.dbf | 2,695 | 0 | 8.91 | 1.00 | 0 | 8.91 | 164 | 0 | 47 | 2.98 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind52.dbf | 3,700 | 1 | 9.31 | 1.00 | 1 | 9.31 | 260 | 0 | 59 | 11.53 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind53.dbf | 3,331 | 0 | 9.77 | 1.00 | 0 | 9.77 | 252 | 0 | 48 | 9.58 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind54.dbf | 3,280 | 0 | 9.59 | 1.00 | 0 | 9.59 | 196 | 0 | 56 | 7.68 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind55.dbf | 3,671 | 1 | 9.85 | 1.00 | 1 | 9.86 | 196 | 0 | 15 | 14.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind56.dbf | 3,032 | 0 | 9.33 | 1.00 | 0 | 9.33 | 198 | 0 | 27 | 11.11 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind57.dbf | 4,363 | 1 | 9.48 | 1.00 | 1 | 9.48 | 215 | 0 | 47 | 4.04 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind58.dbf | 3,692 | 1 | 8.65 | 1.00 | 1 | 8.65 | 267 | 0 | 74 | 3.92 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind59.dbf | 3,669 | 1 | 9.42 | 1.00 | 1 | 9.42 | 248 | 0 | 36 | 8.61 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind60.dbf | 2,590 | 0 | 9.88 | 1.00 | 0 | 9.88 | 236 | 0 | 21 | 13.81 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind61.dbf | 3,009 | 0 | 9.35 | 1.00 | 0 | 9.35 | 446 | 0 | 21 | 6.67 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind62.dbf | 4,605 | 1 | 9.49 | 1.00 | 1 | 9.49 | 348 | 0 | 29 | 7.59 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind63.dbf | 10,878 | 2 | 10.24 | 1.00 | 2 | 10.24 | 1,394 | 0 | 161 | 5.09 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind87.dbf | 4,677 | 1 | 9.10 | 1.00 | 1 | 9.10 | 319 | 0 | 24 | 10.00 |
| APPS_TS_TX_IDX | /oradb/oracle/product/TJTG/db/apps_st/data/a_txn_ind95.dbf | 6,546 | 1 | 8.42 | 1.00 | 1 | 8.43 | 331 | 0 | 21 | 15.71 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo01.dbf | 52 | 0 | 10.77 | 1.00 | 0 | 10.77 | 2,274 | 0 | 166 | 0.12 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0101.dbf | 51 | 0 | 4.12 | 1.00 | 0 | 4.12 | 607 | 0 | 7 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0111.dbf | 45 | 0 | 0.44 | 1.00 | 0 | 0.67 | 634 | 0 | 2 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0112.dbf | 9 | 0 | 1.11 | 1.00 | 0 | 2.22 | 678 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0113.dbf | 12 | 0 | 1.67 | 1.00 | 0 | 2.50 | 607 | 0 | 3 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0120.dbf | 44 | 0 | 3.86 | 1.00 | 0 | 3.86 | 606 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0121.dbf | 53 | 0 | 0.57 | 1.00 | 0 | 0.57 | 590 | 0 | 1 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0122.dbf | 89 | 0 | 2.70 | 1.00 | 0 | 2.70 | 522 | 0 | 9 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0124.dbf | 11 | 0 | 4.55 | 1.00 | 0 | 4.55 | 652 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0125.dbf | 11 | 0 | 1.82 | 1.00 | 0 | 1.82 | 830 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0126.dbf | 10 | 0 | 1.00 | 1.00 | 0 | 1.00 | 817 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo0140.dbf | 15 | 0 | 0.00 | 1.00 | 0 | 0.00 | 885 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo02.dbf | 56 | 0 | 12.68 | 1.00 | 0 | 12.68 | 1,629 | 0 | 43 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo03.dbf | 87 | 0 | 12.76 | 1.00 | 0 | 12.76 | 1,396 | 0 | 199 | 0.15 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo04.dbf | 37 | 0 | 6.22 | 1.00 | 0 | 6.49 | 1,380 | 0 | 37 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo05.dbf | 16 | 0 | 2.50 | 1.00 | 0 | 2.50 | 767 | 0 | 6 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo06.dbf | 32 | 0 | 2.81 | 1.00 | 0 | 2.50 | 567 | 0 | 7 | 1.43 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo07.dbf | 50 | 0 | 1.60 | 1.00 | 0 | 1.60 | 710 | 0 | 1 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo08.dbf | 47 | 0 | 0.64 | 1.00 | 0 | 0.64 | 464 | 0 | 1 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo089.dbf | 54 | 0 | 1.30 | 1.00 | 0 | 1.11 | 530 | 0 | 1 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo09.dbf | 50 | 0 | 1.20 | 1.00 | 0 | 1.00 | 514 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo090.dbf | 54 | 0 | 1.30 | 1.00 | 0 | 1.30 | 621 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo091.dbf | 50 | 0 | 0.40 | 1.00 | 0 | 0.60 | 574 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo092.dbf | 15 | 0 | 0.00 | 1.00 | 0 | 0.00 | 1,810 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo093.dbf | 65 | 0 | 5.23 | 1.00 | 0 | 5.23 | 706 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo094.dbf | 22 | 0 | 1.36 | 1.00 | 0 | 1.36 | 2,073 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo095.dbf | 64 | 0 | 1.41 | 1.00 | 0 | 1.41 | 866 | 0 | 3 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo096.dbf | 67 | 0 | 2.99 | 1.00 | 0 | 2.99 | 862 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo097.dbf | 90 | 0 | 6.44 | 1.00 | 0 | 6.44 | 1,000 | 0 | 4 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo098.dbf | 17 | 0 | 0.59 | 1.00 | 0 | 0.59 | 1,717 | 0 | 1 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo099.dbf | 76 | 0 | 4.21 | 1.00 | 0 | 4.08 | 746 | 0 | 3 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo100.dbf | 23 | 0 | 3.04 | 1.00 | 0 | 2.61 | 1,702 | 0 | 2 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo102.dbf | 48 | 0 | 1.04 | 1.00 | 0 | 1.04 | 681 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo103.dbf | 44 | 0 | 4.55 | 1.00 | 0 | 4.55 | 1,466 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo104.dbf | 42 | 0 | 0.00 | 1.00 | 0 | 0.00 | 521 | 0 | 4 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo106.dbf | 45 | 0 | 4.89 | 1.00 | 0 | 4.67 | 545 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo107.dbf | 104 | 0 | 3.56 | 1.00 | 0 | 3.56 | 1,957 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo109.dbf | 50 | 0 | 0.20 | 1.00 | 0 | 0.20 | 661 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo113.dbf | 26 | 0 | 2.31 | 1.00 | 0 | 2.31 | 1,692 | 0 | 2 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo114.dbf | 35 | 0 | 4.57 | 1.00 | 0 | 4.57 | 1,722 | 0 | 2 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo115.dbf | 55 | 0 | 3.64 | 1.00 | 0 | 3.64 | 1,880 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo118.dbf | 44 | 0 | 1.59 | 1.00 | 0 | 1.59 | 664 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo121.dbf | 43 | 0 | 2.56 | 1.00 | 0 | 2.56 | 2,195 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo122.dbf | 26 | 0 | 0.77 | 1.00 | 0 | 0.77 | 1,412 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo123.dbf | 43 | 0 | 0.23 | 1.00 | 0 | 0.23 | 562 | 0 | 2 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo127.dbf | 52 | 0 | 3.27 | 1.00 | 0 | 3.27 | 2,024 | 0 | 2 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo128.dbf | 57 | 0 | 9.65 | 1.00 | 0 | 9.82 | 2,384 | 0 | 0 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo141.dbf | 34 | 0 | 5.29 | 1.00 | 0 | 5.29 | 2,361 | 0 | 1 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo142.dbf | 52 | 0 | 9.62 | 1.00 | 0 | 9.62 | 2,278 | 0 | 6 | 0.00 |
| APPS_UNDOTS1 | /oradb/oracle/product/TJTG/db/apps_st/data/undo143.dbf | 70 | 0 | 5.86 | 1.00 | 0 | 5.86 | 2,724 | 0 | 9 | 0.00 |
| CTXD | /oradb/oracle/product/TJTG/db/apps_st/data/ctxd01.dbf | 637 | 0 | 3.78 | 1.00 | 0 | 3.78 | 17 | 0 | 0 | 0.00 |
| ODM | /oradb/oracle/product/TJTG/db/apps_st/data/odm.dbf | 607 | 0 | 4.37 | 1.00 | 0 | 4.37 | 7 | 0 | 0 | 0.00 |
| OLAP | /oradb/oracle/product/TJTG/db/apps_st/data/olap.dbf | 7 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
| OLAP | /oradb/oracle/product/TJTG/db/apps_st/data/olap01.dbf | 7 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
| OWAPUB | /oradb/oracle/product/TJTG/db/apps_st/data/owad01.dbf | 7 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
| PORTAL | /oradb/oracle/product/TJTG/db/apps_st/data/portal01.dbf | 89 | 0 | 1.46 | 1.00 | 0 | 1.46 | 7 | 0 | 0 | 0.00 |
| SYSAUX | /oradb/oracle/product/TJTG/db/apps_st/data/sysaux01.dbf | 21,254 | 3 | 4.31 | 1.09 | 3 | 4.26 | 1,209 | 0 | 0 | 0.00 |
| SYSAUX | /oradb/oracle/product/TJTG/db/apps_st/data/sysaux02.dbf | 2,900 | 0 | 9.85 | 1.66 | 0 | 9.71 | 887 | 0 | 0 | 0.00 |
| SYSAUX | /oradb/oracle/product/TJTG/db/apps_st/data/sysaux03.dbf | 441 | 0 | 5.83 | 2.98 | 0 | 5.29 | 94 | 0 | 0 | 0.00 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system01.dbf | 592 | 0 | 8.65 | 1.05 | 0 | 8.69 | 272 | 0 | 15 | 5.33 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system012.dbf | 2,539 | 0 | 0.47 | 121.50 | 0 | 9.82 | 118 | 0 | 145 | 11.38 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system013.dbf | 40 | 0 | 7.75 | 1.40 | 0 | 7.57 | 15 | 0 | 0 | 0.00 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system02.dbf | 6,025 | 1 | 2.01 | 95.02 | 0 | 7.08 | 118 | 0 | 16 | 10.00 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system03.dbf | 454 | 0 | 9.16 | 1.12 | 0 | 9.24 | 39 | 0 | 8 | 15.00 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system04.dbf | 489 | 0 | 9.18 | 1.03 | 0 | 9.13 | 67 | 0 | 9 | 17.78 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system05.dbf | 494 | 0 | 11.21 | 1.03 | 0 | 11.20 | 127 | 0 | 11 | 15.45 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system06.dbf | 999 | 0 | 6.28 | 1.86 | 0 | 7.13 | 134 | 0 | 12 | 10.00 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system07.dbf | 1,561 | 0 | 5.64 | 1.70 | 0 | 5.99 | 89 | 0 | 27 | 10.00 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system08.dbf | 2,122 | 0 | 5.05 | 8.75 | 0 | 5.70 | 227 | 0 | 18 | 5.56 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system09.dbf | 1,691 | 0 | 5.59 | 1.55 | 0 | 5.92 | 168 | 0 | 12 | 11.67 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system10.dbf | 1,017 | 0 | 6.44 | 1.78 | 0 | 7.16 | 126 | 0 | 3 | 26.67 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system11.dbf | 1,014 | 0 | 5.72 | 1.04 | 0 | 5.67 | 182 | 0 | 3 | 6.67 |
| SYSTEM | /oradb/oracle/product/TJTG/db/apps_st/data/system12.dbf | 2,289 | 0 | 3.47 | 27.51 | 0 | 4.59 | 96 | 0 | 4 | 5.00 |
| TEMP1 | /oradb_temp/oradata/PROD/temp01.dbf | 47 | 0 | 13.40 | 1.17 | 0 | 14.10 | 100 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp02.dbf | 66 | 0 | 10.30 | 1.00 | 0 | 10.30 | 145 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp03.dbf | 13 | 0 | 10.77 | 1.00 | 0 | 10.77 | 65 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp04.dbf | 63 | 0 | 8.41 | 1.00 | 0 | 8.41 | 85 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp05.dbf | 19 | 0 | 14.21 | 1.00 | 0 | 14.21 | 78 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp06.dbf | 21 | 0 | 15.24 | 1.00 | 0 | 15.24 | 105 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp07.dbf | 6,953 | 1 | 0.10 | 30.26 | 0 | 14.87 | 9,397 | 1 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp08.dbf | 35 | 0 | 18.57 | 1.00 | 0 | 18.57 | 81 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp09.dbf | 18 | 0 | 18.33 | 1.00 | 0 | 18.33 | 126 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp10.dbf | 16,519 | 2 | 0.01 | 14.98 | 0 | 9.13 | 16,605 | 2 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp11.dbf | 26 | 0 | 10.38 | 1.00 | 0 | 10.77 | 125 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp12.dbf | 19 | 0 | 27.37 | 1.00 | 0 | 27.37 | 52 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp13.dbf | 41 | 0 | 23.90 | 1.00 | 0 | 23.90 | 150 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp14.dbf | 157 | 0 | 7.90 | 1.28 | 0 | 7.88 | 214 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp15.dbf | 44 | 0 | 21.82 | 1.00 | 0 | 21.82 | 85 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp16.dbf | 47 | 0 | 19.79 | 1.00 | 0 | 19.79 | 78 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp20.dbf | 14 | 0 | 25.00 | 1.00 | 0 | 25.00 | 45 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp21.dbf | 23 | 0 | 20.43 | 1.00 | 0 | 20.43 | 62 | 0 | 0 | |
| TEMP1 | /oradb_temp/oradata/PROD/temp22.dbf | 12 | 0 | 29.17 | 1.00 | 0 | 30.00 | 80 | 0 | 0 | |
| TJTG | /oradb/oracle/product/TJTG/db/apps_st/data/TGTJ01.dbf | 4,080 | 1 | 7.53 | 1.67 | 1 | 7.41 | 55 | 0 | 28 | 5.36 |
| TJTG | /oradb/oracle/product/TJTG/db/apps_st/data/TGTJ02.dbf | 1,082 | 0 | 11.74 | 3.60 | 0 | 12.09 | 109 | 0 | 30 | 2.67 |
| USERS | /oradb/oracle/product/TJTG/db/apps_st/data/users01.dbf | 14,996 | 2 | 3.65 | 1.00 | 2 | 3.65 | 7 | 0 | 0 | 0.00 |
| USERS | /oradb/oracle/product/TJTG/db/apps_st/data/users02.dbf | 4,172 | 1 | 4.86 | 1.00 | 1 | 4.86 | 7 | 0 | 0 | 0.00 |
| USERS | /oradb/oracle/product/TJTG/db/apps_st/data/users03.dbf | 14 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
| USERS | /oradb/oracle/product/TJTG/db/apps_st/data/users04.dbf | 42 | 0 | 0.00 | 1.00 | 0 | 0.00 | 7 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
Buffer Pool Statistics
Back to TopBuffer Pool Statistics
- Standard block size Pools D: default, K: keep, R: recycle
- Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|---|---|---|---|---|---|---|---|
| D | 1,663,304 | 100 | -15,894,323,088 | 4,821,195 | 362,636 | 0 | 0 | 38,118 |
Back to Buffer Pool Statistics
Back to Top
Checkpoint Activity
- Total Physical Writes: 914,261
| MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
|---|---|---|---|---|---|
| 0 | 0 | 306,262 | 0 | 41,323 | 0 |
Back to Buffer Pool Statistics
Back to Top
Advisory Statistics
- Instance Recovery Stats
- MTTR Advisory
- Buffer Pool Advisory
- PGA Aggr Summary
- PGA Aggr Target Stats
- PGA Aggr Target Histogram
- PGA Memory Advisory
- Shared Pool Advisory
- SGA Target Advisory
- Streams Pool Advisory
- Java Pool Advisory
Instance Recovery Stats
- B: Begin Snapshot, E: End Snapshot
| Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
|---|---|---|---|---|---|---|---|---|---|---|
| B | 0 | 22 | 4509 | 100801 | 100000 | 663552 | 1566389 | 100000 | ||
| E | 0 | 20 | 3466 | 73493 | 100000 | 663552 | 1542904 | 100000 |
Back to Advisory Statistics
Back to Top
MTTR Advisory
No data exists for this section of the report. Back to Advisory StatisticsBack to Top
Buffer Pool Advisory
- Only rows with estimated physical reads >0 are displayed
- ordered by Block Size, Buffers For Estimate
| P | Size for Est (M) | Size Factor | Buffers (thousands) | Est Phys Read Factor | Estimated Phys Reads (thousands) | Est Phys Read Time | Est %DBtime for Rds |
|---|---|---|---|---|---|---|---|
| D | 1,344 | 0.10 | 166 | 8.77 | 2,492,040 | 1 | 7883927.00 |
| D | 2,688 | 0.20 | 331 | 2.94 | 836,270 | 1 | 2284925.00 |
| D | 4,032 | 0.30 | 497 | 2.08 | 591,517 | 1 | 1457291.00 |
| D | 5,376 | 0.40 | 662 | 1.59 | 453,123 | 1 | 989311.00 |
| D | 6,720 | 0.50 | 828 | 1.35 | 383,078 | 1 | 752454.00 |
| D | 8,064 | 0.60 | 993 | 1.20 | 342,053 | 1 | 613729.00 |
| D | 9,408 | 0.70 | 1,159 | 1.12 | 317,050 | 1 | 529181.00 |
| D | 10,752 | 0.80 | 1,324 | 1.06 | 301,579 | 1 | 476865.00 |
| D | 12,096 | 0.90 | 1,490 | 1.03 | 291,532 | 1 | 442891.00 |
| D | 13,440 | 1.00 | 1,655 | 1.00 | 284,479 | 1 | 419039.00 |
| D | 13,504 | 1.00 | 1,663 | 1.00 | 284,211 | 1 | 418134.00 |
| D | 14,784 | 1.09 | 1,821 | 0.98 | 279,671 | 1 | 402782.00 |
| D | 16,128 | 1.19 | 1,987 | 0.97 | 276,019 | 1 | 390435.00 |
| D | 17,472 | 1.29 | 2,152 | 0.96 | 272,700 | 1 | 379209.00 |
| D | 18,816 | 1.39 | 2,318 | 0.95 | 270,047 | 1 | 370239.00 |
| D | 20,160 | 1.49 | 2,483 | 0.94 | 267,318 | 1 | 361012.00 |
| D | 21,504 | 1.59 | 2,649 | 0.93 | 264,840 | 1 | 352632.00 |
| D | 22,848 | 1.69 | 2,814 | 0.93 | 263,285 | 1 | 347374.00 |
| D | 24,192 | 1.79 | 2,980 | 0.92 | 261,882 | 1 | 342627.00 |
| D | 25,536 | 1.89 | 3,145 | 0.89 | 252,083 | 1 | 309494.00 |
| D | 26,880 | 1.99 | 3,311 | 0.79 | 223,417 | 1 | 212559.00 |
Back to Advisory Statistics
Back to Top
PGA Aggr Summary
- PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
| PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
|---|---|---|
| 90.43 | 47,013 | 4,976 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target Stats
- 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 Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) | |
|---|---|---|---|---|---|---|---|---|
| B | 5,120 | 2,843 | 2,608.15 | 107.84 | 4.13 | 100.00 | 0.00 | 524,280 |
| E | 5,120 | 2,067 | 3,996.08 | 220.38 | 5.51 | 100.00 | 0.00 | 524,280 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target Histogram
- Optimal Executions are purely in-memory operations
| Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
|---|---|---|---|---|---|
| 2K | 4K | 3,458,176 | 3,458,176 | 0 | 0 |
| 64K | 128K | 966 | 966 | 0 | 0 |
| 128K | 256K | 532 | 532 | 0 | 0 |
| 256K | 512K | 560 | 560 | 0 | 0 |
| 512K | 1024K | 15,352 | 15,352 | 0 | 0 |
| 1M | 2M | 3,626 | 3,626 | 0 | 0 |
| 2M | 4M | 259 | 259 | 0 | 0 |
| 4M | 8M | 130 | 130 | 0 | 0 |
| 8M | 16M | 100 | 100 | 0 | 0 |
| 16M | 32M | 48 | 48 | 0 | 0 |
| 32M | 64M | 47 | 47 | 0 | 0 |
| 64M | 128M | 8 | 7 | 1 | 0 |
| 128M | 256M | 42 | 42 | 0 | 0 |
| 256M | 512M | 11 | 11 | 0 | 0 |
| 512M | 1024M | 8 | 0 | 8 | 0 |
Back to Advisory Statistics
Back to Top
PGA Memory Advisory
- When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0
| PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count | Estd Time |
|---|---|---|---|---|---|---|
| 640 | 0.13 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 1,280 | 0.25 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 2,560 | 0.50 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 3,840 | 0.75 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 5,120 | 1.00 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 6,144 | 1.20 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 7,168 | 1.40 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 8,192 | 1.60 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 9,216 | 1.80 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 10,240 | 2.00 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 15,360 | 3.00 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 20,480 | 4.00 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 30,720 | 6.00 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
| 40,960 | 8.00 | 52,469,371.18 | 0.00 | 100.00 | 0 | 1,589,134,705 |
Back to Advisory Statistics
Back to Top
Shared Pool Advisory
- SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
- Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.
| Shared Pool Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits (K) |
|---|---|---|---|---|---|---|---|---|
| 3,072 | 0.49 | 146 | 18,461 | 54,357,782 | 0.24 | 172,711,547 | 8769.75 | 1,211,566 |
| 3,712 | 0.59 | 785 | 31,796 | 182,231,284 | 0.80 | 44,838,045 | 2276.74 | 3,924,069 |
| 4,352 | 0.69 | 1,424 | 43,803 | 218,357,382 | 0.96 | 8,711,947 | 442.37 | 344,026 |
| 4,992 | 0.80 | 2,064 | 56,903 | 221,291,372 | 0.97 | 5,777,957 | 293.39 | 355,865 |
| 5,632 | 0.90 | 2,704 | 70,838 | 224,171,577 | 0.99 | 2,897,752 | 147.14 | 366,368 |
| 5,696 | 0.91 | 2,768 | 72,121 | 224,459,745 | 0.99 | 2,609,584 | 132.51 | 367,410 |
| 5,760 | 0.92 | 2,832 | 73,404 | 224,747,660 | 0.99 | 2,321,669 | 117.89 | 368,449 |
| 5,824 | 0.93 | 2,896 | 75,567 | 225,035,594 | 0.99 | 2,033,735 | 103.27 | 369,486 |
| 5,888 | 0.94 | 2,960 | 78,033 | 225,323,232 | 0.99 | 1,746,097 | 88.66 | 370,522 |
| 5,952 | 0.95 | 3,024 | 80,499 | 225,610,868 | 0.99 | 1,458,461 | 74.06 | 371,558 |
| 6,016 | 0.96 | 3,088 | 82,965 | 225,898,383 | 0.99 | 1,170,946 | 59.46 | 372,592 |
| 6,080 | 0.97 | 3,152 | 85,431 | 226,186,145 | 1.00 | 883,184 | 44.85 | 373,627 |
| 6,144 | 0.98 | 3,216 | 87,897 | 226,473,395 | 1.00 | 595,934 | 30.26 | 374,660 |
| 6,208 | 0.99 | 3,280 | 90,363 | 226,760,770 | 1.00 | 308,559 | 15.67 | 375,692 |
| 6,272 | 1.00 | 3,344 | 92,829 | 227,049,635 | 1.00 | 19,694 | 1.00 | 376,767 |
| 6,336 | 1.01 | 3,408 | 95,295 | 227,049,956 | 1.00 | 19,373 | 0.98 | 376,779 |
| 6,400 | 1.02 | 3,472 | 97,761 | 227,050,055 | 1.00 | 19,274 | 0.98 | 376,783 |
| 6,464 | 1.03 | 3,536 | 100,227 | 227,050,125 | 1.00 | 19,204 | 0.98 | 376,785 |
| 6,528 | 1.04 | 3,600 | 102,693 | 227,050,563 | 1.00 | 18,766 | 0.95 | 376,802 |
| 6,592 | 1.05 | 3,664 | 105,159 | 227,050,630 | 1.00 | 18,699 | 0.95 | 376,804 |
| 6,656 | 1.06 | 3,728 | 107,625 | 227,050,650 | 1.00 | 18,679 | 0.95 | 376,805 |
| 6,720 | 1.07 | 3,792 | 110,091 | 227,050,676 | 1.00 | 18,653 | 0.95 | 376,806 |
| 6,784 | 1.08 | 3,856 | 112,557 | 227,050,693 | 1.00 | 18,636 | 0.95 | 376,806 |
| 6,848 | 1.09 | 3,920 | 115,023 | 227,050,733 | 1.00 | 18,596 | 0.94 | 376,807 |
| 6,912 | 1.10 | 3,984 | 117,489 | 227,050,746 | 1.00 | 18,583 | 0.94 | 376,808 |
| 7,552 | 1.20 | 4,624 | 142,154 | 227,051,027 | 1.00 | 18,302 | 0.93 | 376,817 |
| 8,192 | 1.31 | 5,264 | 166,819 | 227,051,429 | 1.00 | 17,900 | 0.91 | 376,831 |
| 8,832 | 1.41 | 5,903 | 187,882 | 227,051,768 | 1.00 | 17,561 | 0.89 | 376,848 |
| 9,472 | 1.51 | 6,543 | 202,628 | 227,052,044 | 1.00 | 17,285 | 0.88 | 376,867 |
| 10,112 | 1.61 | 7,183 | 220,348 | 227,052,224 | 1.00 | 17,105 | 0.87 | 376,887 |
| 10,752 | 1.71 | 7,823 | 238,163 | 227,052,350 | 1.00 | 16,979 | 0.86 | 376,905 |
| 11,392 | 1.82 | 8,463 | 255,978 | 227,052,439 | 1.00 | 16,890 | 0.86 | 376,924 |
| 12,032 | 1.92 | 9,103 | 273,793 | 227,052,527 | 1.00 | 16,802 | 0.85 | 376,938 |
| 12,672 | 2.02 | 9,743 | 291,608 | 227,052,662 | 1.00 | 16,667 | 0.85 | 376,947 |
Back to Advisory Statistics
Back to Top
SGA Target Advisory
| SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
|---|---|---|---|
| 5,120 | 0.25 | 195,959,308 | 2,491,719,436 |
| 7,680 | 0.38 | 24,694,861 | 2,491,719,436 |
| 10,240 | 0.50 | 17,657,008 | 836,219,178 |
| 12,800 | 0.63 | 16,362,181 | 453,094,153 |
| 15,360 | 0.75 | 15,986,366 | 342,030,241 |
| 17,920 | 0.88 | 15,848,988 | 301,560,689 |
| 20,480 | 1.00 | 15,790,563 | 284,196,295 |
| 23,040 | 1.13 | 15,762,140 | 276,011,442 |
| 25,600 | 1.25 | 15,743,191 | 270,043,320 |
| 28,160 | 1.38 | 15,725,822 | 264,842,527 |
| 30,720 | 1.50 | 15,714,768 | 261,886,886 |
| 33,280 | 1.63 | 15,585,286 | 223,406,707 |
| 35,840 | 1.75 | 15,583,707 | 223,406,707 |
| 38,400 | 1.88 | 15,583,708 | 223,406,707 |
| 40,960 | 2.00 | 15,583,708 | 223,406,707 |
Back to Advisory Statistics
Back to Top
Streams Pool Advisory
| Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
|---|---|---|---|---|---|
| 64 | 1.00 | 0 | 0 | 0 | 0 |
| 128 | 2.00 | 0 | 0 | 0 | 0 |
| 192 | 3.00 | 0 | 0 | 0 | 0 |
| 256 | 4.00 | 0 | 0 | 0 | 0 |
| 320 | 5.00 | 0 | 0 | 0 | 0 |
| 384 | 6.00 | 0 | 0 | 0 | 0 |
| 448 | 7.00 | 0 | 0 | 0 | 0 |
| 512 | 8.00 | 0 | 0 | 0 | 0 |
| 576 | 9.00 | 0 | 0 | 0 | 0 |
| 640 | 10.00 | 0 | 0 | 0 | 0 |
| 704 | 11.00 | 0 | 0 | 0 | 0 |
| 768 | 12.00 | 0 | 0 | 0 | 0 |
| 832 | 13.00 | 0 | 0 | 0 | 0 |
| 896 | 14.00 | 0 | 0 | 0 | 0 |
| 960 | 15.00 | 0 | 0 | 0 | 0 |
| 1,024 | 16.00 | 0 | 0 | 0 | 0 |
| 1,088 | 17.00 | 0 | 0 | 0 | 0 |
| 1,152 | 18.00 | 0 | 0 | 0 | 0 |
| 1,216 | 19.00 | 0 | 0 | 0 | 0 |
| 1,280 | 20.00 | 0 | 0 | 0 | 0 |
Back to Advisory Statistics
Back to Top
Java Pool Advisory
| Java Pool Size(M) | JP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits |
|---|---|---|---|---|---|---|---|---|
| 128 | 0.33 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 192 | 0.50 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 256 | 0.67 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 320 | 0.83 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 384 | 1.00 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 448 | 1.17 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 512 | 1.33 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 576 | 1.50 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 640 | 1.67 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 704 | 1.83 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 768 | 2.00 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 832 | 2.17 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 896 | 2.33 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
| 960 | 2.50 | 31 | 498 | 197,106 | 1.00 | 19,694 | 1.00 | 5,563,301 |
Back to Advisory Statistics
Back to Top
Wait Statistics
Back to TopBuffer Wait Statistics
- ordered by wait time desc, waits desc
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|---|---|---|
| data block | 37,588 | 120 | 3 |
| undo header | 401 | 0 | 0 |
| 1st level bmb | 3 | 0 | 17 |
| 2nd level bmb | 1 | 0 | 40 |
| undo block | 123 | 0 | 0 |
| segment header | 2 | 0 | 5 |
Back to Wait Statistics
Back to Top
Enqueue Activity
- only enqueues with waits are shown
- Enqueue stats gathered prior to 10g should not be compared with 10g data
- ordered by Wait Time desc, Waits desc
| Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
|---|---|---|---|---|---|---|
| TX-Transaction (row lock contention) | 3,231 | 410 | 2,821 | 391 | 87 | 221.87 |
| TX-Transaction (index contention) | 992 | 992 | 0 | 204 | 18 | 87.40 |
| HW-Segment High Water Mark | 21,298 | 21,234 | 64 | 67 | 3 | 41.94 |
| TX-Transaction (allocate ITL entry) | 35 | 35 | 0 | 3 | 2 | 583.33 |
| CF-Controlfile Transaction | 8,964 | 8,963 | 1 | 7 | 1 | 80.00 |
| DV-Diana Versioning | 8,871 | 8,871 | 0 | 22 | 0 | 1.36 |
| RO-Multiple Object Reuse (fast object reuse) | 50 | 50 | 0 | 5 | 0 | 2.00 |
| KO-Multiple Object Checkpoint (fast object checkpoint) | 70 | 70 | 0 | 7 | 0 | 0.00 |
Back to Wait Statistics
Back to Top
Undo Statistics
Back to TopUndo Segment Summary
- Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
- STO - Snapshot Too Old count, OOS - Out of Space count
- Undo segment block stats:
- uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
- eS - expired Stolen, eR - expired Released, eU - expired reUsed
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 368 | 108.36 | 111,093 | 8,508 | 67 | 44.5/153.8 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
Undo Segment Stats
- Most recent 35 Undostat rows, ordered by Time desc
| End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 03-Sep 10:24 | 10,261 | 8,170 | 8,508 | 48 | 154 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 10:14 | 696 | 4,267 | 7,906 | 54 | 144 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 10:04 | 13,816 | 9,051 | 7,304 | 57 | 134 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 09:54 | 26,269 | 8,497 | 6,703 | 50 | 124 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 09:44 | 4,316 | 13,077 | 6,102 | 67 | 114 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 09:34 | 13,743 | 12,840 | 5,501 | 44 | 104 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 09:24 | 10,486 | 8,270 | 4,899 | 38 | 94 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 09:14 | 10,373 | 15,257 | 4,298 | 34 | 84 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 09:04 | 5,906 | 4,200 | 3,696 | 34 | 74 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 08:54 | 4,746 | 6,634 | 3,094 | 35 | 65 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 08:44 | 1,084 | 13,666 | 2,493 | 31 | 55 | 0/0 | 0/0/0/0/0/0 |
| 03-Sep 08:34 | 6,659 | 7,164 | 1,892 | 32 | 45 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
Latch Statistics
- Latch Activity
- Latch Sleep Breakdown
- Latch Miss Sources
- Mutex Sleep Summary
- Parent Latch Statistics
- Child Latch Statistics
Latch Activity
- "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
- "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
- "Pct Misses" for both should be very close to 0.0
| Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
|---|---|---|---|---|---|---|
| AQ deq hash table latch | 7,766 | 0.36 | 0.00 | 0 | 0 | |
| AQ deq log cmt cbk chunk latch | 2,946 | 0.88 | 0.00 | 0 | 0 | |
| AQ deq log statistics latch | 195 | 0.00 | 0 | 0 | ||
| AQ dequeue txn counter latch | 46,082 | 2.32 | 0.00 | 0 | 0 | |
| AQ disk delete txn counter latch | 1,697 | 0.00 | 0 | 0 | ||
| AQ ht cmt cbk chunk latch | 2,676 | 0.00 | 0 | 0 | ||
| ASM db client latch | 13,997 | 0.00 | 0 | 0 | ||
| ASM map operation hash table | 2 | 0.00 | 0 | 0 | ||
| ASM network state latch | 114 | 0.00 | 0 | 0 | ||
| AWR Alerted Metric Element list | 120,569 | 0.00 | 0 | 0 | ||
| Change Notification Hash table latch | 2,405 | 0.00 | 0 | 0 | ||
| Consistent RBA | 89,542 | 0.00 | 0.00 | 0 | 0 | |
| DML lock allocation | 1,164,547 | 0.00 | 0.00 | 0 | 0 | |
| DMON Work Queues Latch | 480 | 0.00 | 0 | 0 | ||
| Event Group Locks | 5,751 | 0.00 | 0 | 0 | ||
| FAL Queue | 411 | 0.00 | 0 | 0 | ||
| FIB s.o chain latch | 2,229 | 0.00 | 0 | 0 | ||
| FOB s.o list latch | 54,610 | 0.02 | 0.00 | 0 | 0 | |
| File State Object Pool Parent Latch | 2 | 0.00 | 0 | 0 | ||
| I/O Staticstics latch | 2 | 0.00 | 0 | 0 | ||
| IPC stats buffer allocation latch | 2 | 0.00 | 0 | 0 | ||
| In memory undo latch | 1,129,159 | 0.02 | 0.26 | 0 | 117,131 | 0.01 |
| JOX SGA heap latch | 12,897 | 0.00 | 0 | 0 | ||
| JS Sh mem access | 18 | 0.00 | 0 | 0 | ||
| JS mem alloc latch | 20 | 0.00 | 0 | 0 | ||
| JS queue access latch | 22 | 0.00 | 0 | 0 | ||
| JS queue state obj latch | 52,200 | 0.00 | 0 | 0 | ||
| JS slv state obj latch | 2 | 0.00 | 0 | 0 | ||
| KFC FX Hash Latch | 2 | 0.00 | 0 | 0 | ||
| KFC Hash Latch | 2 | 0.00 | 0 | 0 | ||
| KFCL LE Freelist | 2 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SHM structure | 2 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SVR LIST | 2 | 0.00 | 0 | 0 | ||
| KJC message pool free list | 2 | 0.00 | 0 | 0 | ||
| KJCT flow control latch | 2 | 0.00 | 0 | 0 | ||
| KMG MMAN ready and startup request latch | 2,404 | 0.00 | 0 | 0 | ||
| KTF sga latch | 40 | 0.00 | 0 | 2,344 | 0.00 | |
| KWQMN job cache list latch | 2,992 | 0.94 | 0.00 | 0 | 0 | |
| KWQP Prop Status | 1,034 | 0.00 | 0 | 0 | ||
| KWQS pqsubs latch | 3,035 | 0.00 | 0 | 0 | ||
| KWQS pqueue ctx latch | 3,043 | 0.76 | 0.00 | 0 | 0 | |
| LGWR NS Write | 34,335 | 0.00 | 1.00 | 0 | 0 | |
| Locator state objects pool parent latch | 2 | 0.00 | 0 | 0 | ||
| Lsod array latch | 2 | 0.00 | 0 | 0 | ||
| MQL Tracking Latch | 0 | 0 | 144 | 0.00 | ||
| Memory Management Latch | 2 | 0.00 | 0 | 2,404 | 0.00 | |
| Memory Queue | 48,097,732 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #1 | 2 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #2 | 2 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #3 | 2 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #4 | 2 | 0.00 | 0 | 0 | ||
| Memory Queue Subscriber | 2 | 0.00 | 0 | 0 | ||
| MinActiveScn Latch | 80 | 0.00 | 0 | 0 | ||
| Mutex | 2 | 0.00 | 0 | 0 | ||
| Mutex Stats | 2 | 0.00 | 0 | 0 | ||
| NSV command ID generation latch | 120 | 0.00 | 0 | 0 | ||
| NSV creation/termination latch | 120 | 0.00 | 0 | 0 | ||
| OS process | 10,540 | 0.00 | 0 | 0 | ||
| OS process allocation | 19,709 | 0.05 | 0.00 | 0 | 0 | |
| OS process: request allocation | 5,199 | 0.06 | 0.00 | 0 | 0 | |
| PL/SQL warning settings | 149,208 | 0.01 | 0.00 | 0 | 0 | |
| PX hash array latch | 2 | 0.00 | 0 | 0 | ||
| Policy Hash Table Latch | 2 | 0.00 | 0 | 0 | ||
| QMT | 2 | 0.00 | 0 | 0 | ||
| RSM process latch | 720 | 0.00 | 0 | 0 | ||
| Real-time plan statistics latch | 51,158 | 0.02 | 0.00 | 0 | 0 | |
| Request id generation latch | 120 | 0.00 | 0 | 0 | ||
| SGA IO buffer pool latch | 5,275 | 0.00 | 0 | 15,679 | 0.00 | |
| SGA blob parent | 2 | 0.00 | 0 | 0 | ||
| SGA bucket locks | 2 | 0.00 | 0 | 0 | ||
| SGA heap locks | 2 | 0.00 | 0 | 0 | ||
| SGA pool locks | 2 | 0.00 | 0 | 0 | ||
| SQL memory manager latch | 2 | 0.00 | 0 | 6,967 | 0.00 | |
| SQL memory manager workarea list latch | 1,514,113 | 0.00 | 0.00 | 0 | 0 | |
| Shared B-Tree | 242,346,480 | 0.01 | 0.00 | 0 | 0 | |
| Streams Generic | 2 | 0.00 | 0 | 0 | ||
| Testing | 2 | 0.00 | 0 | 0 | ||
| Token Manager | 2 | 0.00 | 0 | 0 | ||
| WCR: sync | 2 | 0.00 | 0 | 0 | ||
| Write State Object Pool Parent Latch | 2 | 0.00 | 0 | 0 | ||
| X$KSFQP | 13,772 | 0.00 | 0 | 0 | ||
| XDB NFS Security Latch | 2 | 0.00 | 0 | 0 | ||
| XDB unused session pool | 2 | 0.00 | 0 | 0 | ||
| XDB used session pool | 2 | 0.00 | 0 | 0 | ||
| active checkpoint queue latch | 29,384 | 0.00 | 0 | 0 | ||
| active service list | 28,465 | 0.03 | 0.00 | 0 | 5,290 | 0.00 |
| alert log latch | 39 | 0.00 | 0 | 0 | ||
| archive control | 100,051 | 0.00 | 0 | 0 | ||
| archive process latch | 891 | 0.34 | 1.00 | 0 | 0 | |
| begin backup scn array | 5,088 | 0.00 | 0 | 0 | ||
| bq:time manger info latch | 267 | 0.00 | 0 | 0 | ||
| buffer pool | 2 | 0.00 | 0 | 0 | ||
| bufq statistics | 10 | 0.00 | 0 | 0 | ||
| business card | 2 | 0.00 | 0 | 0 | ||
| cache buffer handles | 2,138,552 | 0.01 | 0.00 | 0 | 0 | |
| cache buffers chains | 9,286,424,358 | 0.01 | 0.00 | 1 | 42,148,852 | 0.00 |
| cache buffers lru chain | 1,479,948 | 0.01 | 0.02 | 0 | 46,198,465 | 0.03 |
| cache table scan latch | 218,429 | 0.01 | 0.00 | 0 | 218,429 | 0.00 |
| call allocation | 51,348 | 0.15 | 0.11 | 0 | 0 | |
| cas latch | 2 | 0.00 | 0 | 0 | ||
| change notification client cache latch | 2 | 0.00 | 0 | 0 | ||
| channel handle pool latch | 5,444 | 0.11 | 0.00 | 0 | 0 | |
| channel operations parent latch | 89,827 | 0.01 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 5,390,444 | 0.00 | 0.00 | 0 | 356,230 | 0.00 |
| client/application info | 66,719 | 0.00 | 0 | 0 | ||
| compile environment latch | 3,122 | 0.00 | 0 | 0 | ||
| constraint object allocation | 18 | 0.00 | 0 | 0 | ||
| corrupted undo seg latch | 160,187 | 0.00 | 0 | 0 | ||
| cp cmon/server latch | 2 | 0.00 | 0 | 0 | ||
| cp pool latch | 2 | 0.00 | 0 | 0 | ||
| cp server hash latch | 2 | 0.00 | 0 | 0 | ||
| cp sga latch | 114 | 0.00 | 0 | 0 | ||
| cvmap freelist lock | 2 | 0.00 | 0 | 0 | ||
| deferred cleanup latch | 114 | 0.00 | 0 | 0 | ||
| dml lock allocation | 114 | 0.00 | 0 | 0 | ||
| done queue latch | 2 | 0.00 | 0 | 0 | ||
| dummy allocation | 6,168 | 0.03 | 0.00 | 0 | 0 | |
| eighth spare latch - X parent | 2 | 0.00 | 0 | 0 | ||
| eleventh spare latch - children | 2 | 0.00 | 0 | 0 | ||
| enqueue freelist latch | 2 | 0.00 | 0 | 525,687 | 0.00 | |
| enqueue hash chains | 1,283,289 | 0.18 | 0.01 | 0 | 60 | 0.00 |
| enqueues | 16 | 0.00 | 0 | 0 | ||
| fifteenth spare latch - children | 2 | 0.00 | 0 | 0 | ||
| file cache latch | 3,025 | 0.00 | 0 | 0 | ||
| first Audit Vault latch | 3,082 | 0.10 | 0.00 | 0 | 0 | |
| flashback copy | 2 | 0.00 | 0 | 0 | ||
| fourteenth spare latch - children | 2 | 0.00 | 0 | 0 | ||
| fourth Audit Vault latch | 2 | 0.00 | 0 | 0 | ||
| gc element | 2 | 0.00 | 0 | 0 | ||
| gcs commit scn state | 2 | 0.00 | 0 | 0 | ||
| gcs partitioned table hash | 2 | 0.00 | 0 | 0 | ||
| gcs pcm hashed value bucket hash | 2 | 0.00 | 0 | 0 | ||
| gcs resource freelist | 2 | 0.00 | 0 | 0 | ||
| gcs resource hash | 2 | 0.00 | 0 | 0 | ||
| gcs resource scan list | 2 | 0.00 | 0 | 0 | ||
| gcs resource validate list | 2 | 0.00 | 0 | 0 | ||
| gcs shadows freelist | 2 | 0.00 | 0 | 0 | ||
| ges domain table | 2 | 0.00 | 0 | 0 | ||
| ges enqueue table freelist | 2 | 0.00 | 0 | 0 | ||
| ges group table | 2 | 0.00 | 0 | 0 | ||
| ges process hash list | 2 | 0.00 | 0 | 0 | ||
| ges process parent latch | 2 | 0.00 | 0 | 0 | ||
| ges resource hash list | 2 | 0.00 | 0 | 0 | ||
| ges resource scan list | 2 | 0.00 | 0 | 0 | ||
| ges resource table freelist | 2 | 0.00 | 0 | 0 | ||
| ges value block free list | 2 | 0.00 | 0 | 0 | ||
| global KZLD latch for mem in SGA | 3,077 | 0.00 | 0 | 0 | ||
| global ctx hash table latch | 101,844 | 0.00 | 0 | 0 | ||
| global tx hash mapping | 78 | 0.00 | 0 | 0 | ||
| granule operation | 2 | 0.00 | 0 | 0 | ||
| hash table column usage latch | 1,807 | 0.06 | 0.00 | 0 | 9,223,308 | 0.02 |
| hash table modification latch | 632 | 0.00 | 0 | 0 | ||
| heartbeat check | 2 | 0.00 | 0 | 0 | ||
| internal temp table object number allocation latch | 6 | 0.00 | 0 | 0 | ||
| interrupt manipulation | 18 | 0.00 | 0 | 0 | ||
| intra txn parallel recovery | 2 | 0.00 | 0 | 0 | ||
| io pool granule metadata list | 2 | 0.00 | 0 | 0 | ||
| job workq parent latch | 2 | 0.00 | 0 | 0 | ||
| job_queue_processes parameter latch | 1,570 | 0.00 | 0 | 0 | ||
| k2q lock allocation | 2 | 0.00 | 0 | 0 | ||
| kcbtsemkid latch | 8 | 0.00 | 0 | 0 | ||
| kdlx hb parent latch | 2 | 0.00 | 0 | 0 | ||
| kgb parent | 2 | 0.00 | 0 | 0 | ||
| kgnfs mount latch | 2 | 0.00 | 0 | 0 | ||
| kokc descriptor allocation latch | 68 | 0.00 | 0 | 0 | ||
| ksfv messages | 2 | 0.00 | 0 | 0 | ||
| ksim group membership cache | 2 | 0.00 | 0 | 0 | ||
| kss move lock | 80 | 0.00 | 0 | 0 | ||
| ksuosstats global area | 727 | 0.00 | 0 | 0 | ||
| ksv allocation latch | 270 | 0.00 | 0 | 0 | ||
| ksv class latch | 813 | 0.00 | 0 | 0 | ||
| ksv msg queue latch | 2 | 0.00 | 0 | 0 | ||
| ksz_so allocation latch | 5,199 | 0.12 | 0.00 | 0 | 0 | |
| ktm global data | 239 | 0.00 | 0 | 0 | ||
| kwqbsn:qsga | 194,235,437 | 0.02 | 0.00 | 0 | 0 | |
| kwqi:kchunk latch | 18 | 0.00 | 0 | 0 | ||
| lgwr LWN SCN | 90,393 | 0.31 | 0.00 | 0 | 0 | |
| list of block allocation | 24,180 | 0.01 | 0.00 | 0 | 0 | |
| loader state object freelist | 41,519 | 0.01 | 0.00 | 0 | 0 | |
| lob segment dispenser latch | 2 | 0.00 | 0 | 0 | ||
| lob segment hash table latch | 26 | 0.00 | 0 | 0 | ||
| lob segment query latch | 2 | 0.00 | 0 | 0 | ||
| lock DBA buffer during media recovery | 2 | 0.00 | 0 | 0 | ||
| logical standby cache | 2 | 0.00 | 0 | 0 | ||
| logminer context allocation | 4 | 0.00 | 0 | 0 | ||
| logminer local | 2 | 0.00 | 0 | 0 | ||
| logminer work area | 2 | 0.00 | 0 | 0 | ||
| longop free list parent | 2,660 | 0.00 | 0 | 98 | 0.00 | |
| managed standby latch | 283 | 0.00 | 0 | 0 | ||
| mapped buffers lru chain | 2 | 0.00 | 0 | 0 | ||
| message pool operations parent latch | 1,934 | 0.00 | 0 | 0 | ||
| messages | 416,659 | 0.03 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 95,912 | 2.94 | 0.00 | 0 | 0 | |
| msg queue latch | 2 | 0.00 | 0 | 0 | ||
| multiblock read objects | 789,568 | 0.01 | 0.04 | 0 | 0 | |
| name-service namespace bucket | 2 | 0.00 | 0 | 0 | ||
| ncodef allocation latch | 114 | 0.00 | 0 | 0 | ||
| nineth spare latch - X parent | 2 | 0.00 | 0 | 0 | ||
| object queue header heap | 820,699 | 0.00 | 0 | 826,290 | 0.00 | |
| object queue header operation | 13,980,300 | 0.01 | 0.00 | 0 | 0 | |
| object stats modification | 1,060,079 | 0.00 | 0.22 | 0 | 0 | |
| parallel query alloc buffer | 1,424 | 0.00 | 0 | 0 | ||
| parallel query stats | 2 | 0.00 | 0 | 0 | ||
| parameter list | 13,609 | 0.01 | 0.00 | 0 | 0 | |
| parameter table management | 185,002 | 0.03 | 0.13 | 0 | 0 | |
| peshm | 2 | 0.00 | 0 | 0 | ||
| pesom_free_list | 175,802 | 0.00 | 0.00 | 0 | 0 | |
| pesom_hash_node | 182,174 | 0.00 | 0.00 | 0 | 0 | |
| pesom_heap_alloc | 302 | 0.00 | 0 | 0 | ||
| post/wait queue | 326,758,081 | 4.21 | 0.00 | 2 | 880,255,450 | 9.05 |
| process allocation | 5,238 | 0.23 | 0.00 | 0 | 2,621 | 0.23 |
| process group creation | 5,199 | 0.04 | 0.00 | 0 | 0 | |
| process queue | 2 | 0.00 | 0 | 0 | ||
| process queue reference | 2 | 0.00 | 0 | 0 | ||
| qmn task queue latch | 1,062,012,034 | 72.46 | 0.32 | 220918 | 0 | |
| query server freelists | 2 | 0.00 | 0 | 0 | ||
| queued dump request | 24 | 0.00 | 0 | 0 | ||
| queuing load statistics | 2 | 0.00 | 0 | 0 | ||
| readredo stats and histogram | 15,446 | 0.00 | 0 | 0 | ||
| recovery domain hash list | 2 | 0.00 | 0 | 0 | ||
| redo allocation | 521,598 | 0.47 | 0.01 | 0 | 8,820,659 | 0.10 |
| redo copy | 2 | 0.00 | 0 | 8,823,545 | 0.13 | |
| redo writing | 320,147 | 0.00 | 0.00 | 0 | 0 | |
| resmgr group change latch | 7,436 | 0.00 | 0 | 0 | ||
| resmgr:active threads | 6,168 | 0.00 | 0 | 0 | ||
| resmgr:actses change group | 3,123 | 0.00 | 0 | 0 | ||
| resmgr:actses change state | 2 | 0.00 | 0 | 0 | ||
| resmgr:free threads list | 6,166 | 0.08 | 0.00 | 0 | 0 | |
| resmgr:plan CPU method | 2 | 0.00 | 0 | 0 | ||
| resmgr:resource group CPU method | 2 | 0.00 | 0 | 0 | ||
| resmgr:schema config | 2 | 0.00 | 0 | 0 | ||
| resmgr:session queuing | 2 | 0.00 | 0 | 0 | ||
| rm cas latch | 2 | 0.00 | 0 | 0 | ||
| row cache objects | 19,991,673 | 0.08 | 0.01 | 0 | 387 | 0.00 |
| rules engine aggregate statistics | 1,241 | 0.08 | 0.00 | 0 | 0 | |
| rules engine rule set statistics | 4,034 | 0.02 | 0.00 | 0 | 0 | |
| rules engine rule statistics | 1,352 | 0.00 | 0 | 0 | ||
| second Audit Vault latch | 2 | 0.00 | 0 | 0 | ||
| sequence cache | 349,475 | 0.00 | 0.00 | 0 | 0 | |
| session allocation | 193,961 | 0.00 | 0.00 | 0 | 187,950 | 0.00 |
| session idle bit | 5,639,895 | 0.00 | 0.01 | 0 | 0 | |
| session queue latch | 2 | 0.00 | 0 | 0 | ||
| session state list latch | 18,063 | 0.12 | 0.05 | 0 | 0 | |
| session switching | 4,135 | 0.07 | 0.00 | 0 | 0 | |
| session timer | 2,401 | 0.00 | 0 | 0 | ||
| seventh spare latch - X parent | 2 | 0.00 | 0 | 0 | ||
| shared pool | 97,515,545 | 0.01 | 0.01 | 0 | 416 | 0.48 |
| shared pool sim alloc | 56 | 0.00 | 0 | 0 | ||
| shared pool simulator | 4,102 | 0.00 | 0 | 0 | ||
| sim partition latch | 2 | 0.00 | 0 | 0 | ||
| simulator hash latch | 283,428,456 | 0.00 | 0.00 | 0 | 0 | |
| simulator lru latch | 357,979 | 0.14 | 0.00 | 0 | 282,372,023 | 0.15 |
| sixth spare latch - X parent | 2 | 0.00 | 0 | 0 | ||
| sort extent pool | 63,957 | 0.08 | 0.00 | 0 | 0 | |
| space background state object latch | 30 | 0.00 | 0 | 0 | ||
| space background task latch | 14,290 | 2.13 | 0.10 | 0 | 4,846 | 0.02 |
| state object free list | 4 | 0.00 | 0 | 0 | ||
| statistics aggregation | 280 | 0.00 | 0 | 0 | ||
| tablespace key chain | 2 | 0.00 | 0 | 0 | ||
| temp lob duration state obj allocation | 126 | 0.00 | 0 | 0 | ||
| temporary table state object allocation | 4,134 | 0.17 | 0.00 | 0 | 0 | |
| tenth spare latch - X parent | 2 | 0.00 | 0 | 0 | ||
| test excl. parent l0 | 2 | 0.00 | 0 | 0 | ||
| test excl. parent2 l0 | 2 | 0.00 | 0 | 0 | ||
| thirteenth spare latch - children | 2 | 0.00 | 0 | 0 | ||
| threshold alerts latch | 670 | 0.00 | 0 | 0 | ||
| transaction allocation | 308,116 | 0.00 | 0.00 | 0 | 0 | |
| transaction branch allocation | 2,467 | 0.00 | 0 | 0 | ||
| twelfth spare latch - children | 2 | 0.00 | 0 | 0 | ||
| twenty-fifth spare latch - S par | 2 | 0.00 | 0 | 0 | ||
| twenty-first spare latch - S par | 2 | 0.00 | 0 | 0 | ||
| twenty-fourth spare latch - S par | 2 | 0.00 | 0 | 0 | ||
| twenty-second spare latch - S par | 2 | 0.00 | 0 | 0 | ||
| twenty-third spare latch - S par | 2 | 0.00 | 0 | 0 | ||
| undo global data | 1,767,992 | 0.02 | 0.01 | 0 | 408 | 0.00 |
| virtual circuit buffers | 2 | 0.00 | 0 | 0 | ||
| virtual circuit holder | 2 | 0.00 | 0 | 0 | ||
| virtual circuit queues | 2 | 0.00 | 0 | 0 | ||
| write info latch | 0 | 0 | 89,522 | 0.00 |
Back to Latch Statistics
Back to Top
Latch Sleep Breakdown
- ordered by misses desc
| Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
|---|---|---|---|---|
| qmn task queue latch | 1,062,012,034 | 769,486,561 | 247,743,481 | 568,568,353 |
| post/wait queue | 326,758,081 | 13,765,315 | 8,253 | 13,757,066 |
| cache buffers chains | 9,286,424,358 | 650,395 | 3,175 | 647,433 |
| row cache objects | 19,991,673 | 15,796 | 203 | 15,593 |
| shared pool | 97,515,545 | 8,461 | 77 | 8,384 |
| simulator hash latch | 283,428,456 | 7,775 | 26 | 7,752 |
| mostly latch-free SCN | 95,912 | 2,818 | 2 | 2,816 |
| redo allocation | 521,598 | 2,477 | 24 | 2,456 |
| enqueue hash chains | 1,283,289 | 2,316 | 27 | 2,290 |
| object queue header operation | 13,980,300 | 892 | 3 | 889 |
| simulator lru latch | 357,979 | 511 | 1 | 510 |
| undo global data | 1,767,992 | 441 | 6 | 437 |
| space background task latch | 14,290 | 305 | 32 | 274 |
| cache buffers lru chain | 1,479,948 | 213 | 4 | 209 |
| In memory undo latch | 1,129,159 | 182 | 47 | 136 |
| session idle bit | 5,639,895 | 115 | 1 | 114 |
| multiblock read objects | 789,568 | 80 | 3 | 77 |
| call allocation | 51,348 | 75 | 8 | 67 |
| parameter table management | 185,002 | 60 | 8 | 53 |
| session state list latch | 18,063 | 21 | 1 | 20 |
| object stats modification | 1,060,079 | 9 | 2 | 7 |
| archive process latch | 891 | 3 | 3 | 0 |
| LGWR NS Write | 34,335 | 1 | 1 | 0 |
Back to Latch Statistics
Back to Top
Latch Miss Sources
- only latches with sleeps are shown
- ordered by name, sleeps desc
| Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
|---|---|---|---|---|
| In memory undo latch | ktiFlush: child | 0 | 42 | 11 |
| In memory undo latch | kticmt: child | 0 | 13 | 2 |
| In memory undo latch | ktichg: child | 0 | 3 | 23 |
| In memory undo latch | ktiFlushMe | 0 | 1 | 1 |
| KWQMN job cache list latch | kwqmnuji: update job item | 0 | 1 | 1 |
| LGWR NS Write | kcrrnsltwa | 0 | 1 | 1 |
| PC and Classifier lists for WLM | No latch | 0 | 1 | 0 |
| archive process latch | kcrrgpll | 0 | 2 | 3 |
| archive process latch | kcrrsarc | 0 | 1 | 0 |
| cache buffers chains | kcbgtcr_2 | 0 | 1,534 | 813 |
| cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 1,029 | 1,909 |
| cache buffers chains | kcbrls_2 | 0 | 390 | 120 |
| cache buffers chains | kcbrls: fast release | 0 | 275 | 434 |
| cache buffers chains | kcbgtcr: fast path | 0 | 82 | 72 |
| cache buffers chains | kcbchg1: mod cr pin | 0 | 73 | 10 |
| cache buffers chains | kcbgcur_2 | 0 | 23 | 3 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 22 | 24 |
| cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 7 | 0 |
| cache buffers chains | kcbzwb | 0 | 4 | 1 |
| cache buffers chains | kcbchg1: aux pin | 0 | 3 | 0 |
| cache buffers chains | kcb_cleanout | 0 | 2 | 0 |
| cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 2 | 0 |
| cache buffers chains | kcbgcur: fast path (shr) | 0 | 1 | 0 |
| cache buffers chains | kcbgcur_4 | 0 | 1 | 2 |
| cache buffers chains | kcbget: fast exchange | 0 | 1 | 1 |
| cache buffers chains | kcbget: fast path | 0 | 1 | 0 |
| cache buffers chains | kcbzib: finish processing buffer | 0 | 1 | 0 |
| cache buffers lru chain | kcbzgws | 0 | 4 | 0 |
| call allocation | ksuxds | 0 | 4 | 4 |
| call allocation | ksudlp: top call | 0 | 3 | 3 |
| call allocation | ksuinfos_modact | 0 | 1 | 5 |
| enqueue hash chains | ksqrcl | 0 | 15 | 15 |
| enqueue hash chains | ksqgtl3 | 0 | 10 | 10 |
| enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 2 | 2 |
| lgwr LWN SCN | kcs023 | 0 | 1 | 0 |
| mostly latch-free SCN | kcslcu3 | 0 | 1 | 2 |
| multiblock read objects | kcbzibmlt | 0 | 2 | 0 |
| multiblock read objects | kcbzibmlt: normal mbr free | 0 | 1 | 3 |
| object queue header operation | kcbo_link_q | 0 | 2 | 0 |
| object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 0 |
| object stats modification | ksols_rank | 0 | 2 | 0 |
| parameter table management | ksp_param_table_free | 0 | 8 | 4 |
| post/wait queue | ksliwat:add:nowait | 0 | 4,160 | 0 |
| post/wait queue | ksliwat:add:wait | 0 | 2,984 | 5,346 |
| post/wait queue | kslpstevent:reget | 0 | 604 | 1,525 |
| post/wait queue | kslpstevent:get | 0 | 482 | 1,375 |
| post/wait queue | ksliwat:remove | 0 | 23 | 7 |
| qmn task queue latch | kwqmngettsk: get task | 0 | 173,421,376 | 247,622,765 |
| qmn task queue latch | kwqmnmkrdy: make tasks ready | 0 | 46,474,797 | 84,862 |
| qmn task queue latch | kwqmndntsk: task done but retry | 0 | 27,846,528 | 35,691 |
| qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 614 | 0 |
| qmn task queue latch | kwqmnaddtsk: add task | 0 | 1 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 23 | 0 |
| redo allocation | kcrfwnf:2 | 0 | 1 | 0 |
| row cache objects | kqreqd: reget | 0 | 128 | 1 |
| row cache objects | kqrpre: find obj | 0 | 69 | 9 |
| row cache objects | kqreqd | 0 | 6 | 193 |
| session idle bit | ksuxds | 0 | 1 | 0 |
| session state list latch | kpseqd | 0 | 1 | 0 |
| shared pool | kghfre | 0 | 39 | 11 |
| shared pool | kghalo | 0 | 36 | 38 |
| shared pool | kghupr1 | 0 | 2 | 26 |
| simulator hash latch | kcbsacc: lookup dba | 0 | 25 | 26 |
| simulator hash latch | kcbs_lookup_setid: lookup dba | 0 | 1 | 0 |
| simulator lru latch | kcbs_simulate: simulate set | 0 | 1 | 0 |
| space background task latch | ktsj_grab_task | 0 | 31 | 32 |
| undo global data | ktudba: KSLBEGIN | 0 | 6 | 6 |
Back to Latch Statistics
Back to Top
Mutex Sleep Summary
- ordered by number of sleeps desc
| Mutex Type | Location | Sleeps | Wait Time (ms) |
|---|---|---|---|
| Library Cache | kglhdgn2 106 | 20,684 | 0 |
| Library Cache | kglpndl1 95 | 6,987 | 0 |
| Library Cache | kglpin1 4 | 5,992 | 0 |
| Library Cache | kgllkdl1 85 | 3,615 | 0 |
| Library Cache | kglpnal1 90 | 3,491 | 0 |
| Library Cache | kglhdgn1 62 | 3,052 | 0 |
| Cursor Pin | kksfbc [KKSCHLFSP2] | 403 | 0 |
| Cursor Pin | kksLockDelete [KKSCHLPIN6] | 201 | 0 |
| Library Cache | kgllkc1 57 | 118 | 0 |
| Library Cache | kglget2 2 | 42 | 0 |
| Library Cache | kglget1 1 | 24 | 0 |
| Cursor Parent | kkscsAddChildNode [KKSPRTLOC34] | 11 | 0 |
| Cursor Pin | kkslce [KKSCHLPIN2] | 7 | 0 |
| Library Cache | kglobpn1 71 | 5 | 0 |
| Library Cache | kglGetHandleReference 124 | 4 | 0 |
| Cursor Parent | kkscsPruneChild [KKSPRTLOC35] | 1 | 0 |
| Cursor Pin | kksfbc [KKSCHLPIN1] | 1 | 0 |
| hash table | kkshGetNextChild [KKSHBKLOC1] | 1 | 0 |
Back to Latch Statistics
Back to Top
Parent Latch Statistics
No data exists for this section of the report. Back to Latch StatisticsBack to Top
Child Latch Statistics
No data exists for this section of the report. Back to Latch StatisticsBack to Top
Segment Statistics
- Segments by Logical Reads
- Segments by Physical Reads
- Segments by Physical Read Requests
- Segments by UnOptimized Reads
- Segments by Optimized Reads
- Segments by Direct Physical Reads
- Segments by Physical Writes
- Segments by Physical Write Requests
- Segments by Direct Physical Writes
- Segments by Table Scans
- Segments by DB Blocks Changes
- Segments by Row Lock Waits
- Segments by ITL Waits
- Segments by Buffer Busy Waits
Segments by Logical Reads
- Total Logical Reads: 5,589,328,666
- Captured Segments account for 84.4% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
|---|---|---|---|---|---|---|
| AP | APPS_TS_TX_IDX | AP_INVOICE_LINES_U1 | INDEX | 840,828,560 | 15.04 | |
| AP | APPS_TS_TX_DATA | AP_INVOICE_LINES_ALL | TABLE | 687,351,904 | 12.30 | |
| PO | APPS_TS_TX_IDX | RCV_TRANSACTIONS_U1 | INDEX | 477,214,304 | 8.54 | |
| PO | APPS_TS_TX_DATA | RCV_TRANSACTIONS | TABLE | 413,925,408 | 7.41 | |
| APPLSYS | APPS_TS_SEED | FND_LOOKUP_VALUES_U1 | INDEX | 275,648,480 | 4.93 |
Back to Segment Statistics
Back to Top
Segments by Physical Reads
- Total Physical Reads: 9,839,795
- Captured Segments account for 68.0% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
|---|---|---|---|---|---|---|
| INV | APPS_TS_TX_DATA | MTL_SYSTEM_ITEMS_B | TABLE | 4,406,180 | 44.78 | |
| SYS | SYSTEM | AUD$ | TABLE | 953,029 | 9.69 | |
| PA | APPS_TS_TX_DATA | PA_RESOURCE_ASSIGNMENTS | TABLE | 574,740 | 5.84 | |
| PA | APPS_TS_TX_DATA | PA_BUDGET_LINES | TABLE | 359,094 | 3.65 | |
| HXC | APPS_TS_TX_DATA | HXC_TIME_BUILDING_BLOCKS | TABLE | 101,898 | 1.04 |
Back to Segment Statistics
Back to Top
Segments by Physical Read Requests
- Total Physical Read Requests: 3,913,942
- Captured Segments account for 46.0% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
|---|---|---|---|---|---|---|
| PA | APPS_TS_TX_DATA | PA_RESOURCE_ASSIGNMENTS | TABLE | 574,584 | 14.68 | |
| INV | APPS_TS_TX_DATA | MTL_SYSTEM_ITEMS_B | TABLE | 499,225 | 12.76 | |
| PA | APPS_TS_TX_DATA | PA_BUDGET_LINES | TABLE | 359,094 | 9.17 | |
| HXC | APPS_TS_TX_DATA | HXC_TIME_BUILDING_BLOCKS | TABLE | 101,898 | 2.60 | |
| HXC | APPS_TS_TX_DATA | HXC_TIME_ATTRIBUTES | TABLE | 74,876 | 1.91 |
Back to Segment Statistics
Back to Top
Segments by UnOptimized Reads
- Total UnOptimized Read Requests: 3,913,942
- Captured Segments account for 46.0% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
|---|---|---|---|---|---|---|
| PA | APPS_TS_TX_DATA | PA_RESOURCE_ASSIGNMENTS | TABLE | 574,584 | 14.68 | |
| INV | APPS_TS_TX_DATA | MTL_SYSTEM_ITEMS_B | TABLE | 499,225 | 12.76 | |
| PA | APPS_TS_TX_DATA | PA_BUDGET_LINES | TABLE | 359,094 | 9.17 | |
| HXC | APPS_TS_TX_DATA | HXC_TIME_BUILDING_BLOCKS | TABLE | 101,898 | 2.60 | |
| HXC | APPS_TS_TX_DATA | HXC_TIME_ATTRIBUTES | TABLE | 74,876 | 1.91 |
Back to Segment Statistics
Back to Top
Segments by Optimized Reads
No data exists for this section of the report. Back to Segment StatisticsBack to Top
Segments by Direct Physical Reads
- Total Direct Physical Reads: 5,018,495
- Captured Segments account for 87.7% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
|---|---|---|---|---|---|---|
| INV | APPS_TS_TX_DATA | MTL_SYSTEM_ITEMS_B | TABLE | 3,429,291 | 68.33 | |
| SYS | SYSTEM | AUD$ | TABLE | 953,000 | 18.99 | |
| APPLSYS | APPS_TS_MEDIA | SYS_LOB0000034032C00004$$ | LOB | 18,092 | 0.36 | |
| APPLSYS | APPS_TS_TX_DATA | SYS_LOB0001892337C00040$$ | LOB | 1,080 | 0.02 |
Back to Segment Statistics
Back to Top
Segments by Physical Writes
- Total Physical Writes: 914,261
- Captured Segments account for 16.8% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
|---|---|---|---|---|---|---|
| PJI | APPS_TS_TX_IDX | PJI_FP_XBS_ACCUM_F_N2 | INDEX | 78,321 | 8.57 | |
| APPLSYS | APPS_TS_MEDIA | SYS_LOB0000034032C00004$$ | LOB | 20,659 | 2.26 | |
| APPS | APPS_TS_TX_DATA | XXTJ_ACTUALS_MVIEW | TABLE | 20,580 | 2.25 | |
| PJI | APPS_TS_TX_DATA | PJI_FP_XBS_ACCUM_F | TABLE | 6,958 | 0.76 | |
| PJI | APPS_TS_TX_IDX | PJI_FP_XBS_ACCUM_F_N6 | INDEX | 2,409 | 0.26 |
Back to Segment Statistics
Back to Top
Segments by Physical Write Requests
- Total Physical Write Requestss: 275,409
- Captured Segments account for 39.1% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
|---|---|---|---|---|---|---|
| PJI | APPS_TS_TX_IDX | PJI_FP_XBS_ACCUM_F_N2 | INDEX | 66,980 | 24.32 | |
| APPS | APPS_TS_TX_DATA | XXTJ_ACTUALS_MVIEW | TABLE | 7,909 | 2.87 | |
| APPLSYS | APPS_TS_MEDIA | SYS_LOB0000034032C00004$$ | LOB | 7,793 | 2.83 | |
| PJI | APPS_TS_TX_DATA | PJI_FP_XBS_ACCUM_F | TABLE | 5,314 | 1.93 | |
| PA | APPS_TS_TX_DATA | PA_BUDGET_LINES | TABLE | 1,786 | 0.65 |
Back to Segment Statistics
Back to Top
Segments by Direct Physical Writes
- Total Direct Physical Writes: 551,625
- Captured Segments account for 3.5% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
|---|---|---|---|---|---|---|
| APPLSYS | APPS_TS_MEDIA | SYS_LOB0000034032C00004$$ | LOB | 17,176 | 3.11 | |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_3810413154_30595 | TABLE PARTITION | 1,204 | 0.22 |
| APPLSYS | APPS_TS_TX_DATA | SYS_LOB0001892337C00040$$ | LOB | 1,086 | 0.20 | |
| SYS | SYSAUX | SYS_LOB0000366296C00038$$ | LOB | 22 | 0.00 |
Back to Segment Statistics
Back to Top
Segments by Table Scans
- Total Table Scans: 151
- Captured Segments account for 52.3% of Total
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
|---|---|---|---|---|---|---|
| INV | APPS_TS_TX_DATA | MTL_SYSTEM_ITEMS_B | TABLE | 77 | 50.99 | |
| SYS | SYSTEM | AUD$ | TABLE | 2 | 1.32 |
Back to Segment Statistics
Back to Top
Segments by DB Blocks Changes
- % of Capture shows % of DB Block Changes for each top segment compared
- with total DB Block Changes for all segments captured by the Snapshot
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
|---|---|---|---|---|---|---|
| APPS | APPS_TS_TX_DATA | XXTJ_ACTUALS_MVIEW | TABLE | 47,980,672 | 97.50 | |
| PA | APPS_TS_TX_DATA | PA_PROJ_FP_OPTIONS | TABLE | 96,976 | 0.20 | |
| PJI | APPS_TS_TX_IDX | PJI_FP_XBS_ACCUM_F_N2 | INDEX | 94,688 | 0.19 | |
| PJI | APPS_TS_TX_IDX | PJI_FP_XBS_ACCUM_F_N7 | INDEX | 67,264 | 0.14 | |
| PJI | APPS_TS_TX_IDX | PJI_FP_XBS_ACCUM_F_N5 | INDEX | 66,944 | 0.14 |
Back to Segment Statistics
Back to Top
Segments by Row Lock Waits
- % of Capture shows % of row lock waits for each top segment compared
- with total row lock waits for all segments captured by the Snapshot
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
|---|---|---|---|---|---|---|
| APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 2,821 | 72.33 | |
| APPLSYS | APPS_TS_TX_DATA | FND_CONC_PROG_ONSITE_INFO | TABLE | 311 | 7.97 | |
| APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N1 | INDEX | 118 | 3.03 | |
| APPLSYS | APPS_TS_MEDIA | SYS_IL0000034032C00004$$ | INDEX | 60 | 1.54 | |
| ALR | APPS_TS_TX_DATA | ALR_ALERTS | TABLE | 58 | 1.49 |
Back to Segment Statistics
Back to Top
Segments by ITL Waits
- % of Capture shows % of ITL waits for each top segment compared
- with total ITL waits for all segments captured by the Snapshot
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
|---|---|---|---|---|---|---|
| APPLSYS | APPS_TS_TX_IDX | WF_ITEM_ATTRIBUTE_VALUES_PK | INDEX | 14 | 56.00 | |
| APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 3 | 12.00 | |
| HXC | APPS_TS_TX_IDX | HXC_TIME_ATTRIBUTES_FK2 | INDEX | 2 | 8.00 | |
| PA | APPS_TS_TX_IDX | PA_RESOURCE_ASSIGNMENTS_N6 | INDEX | 2 | 8.00 | |
| HXC | APPS_TS_TX_IDX | HXC_TIME_ATTRIBUTES_F2 | INDEX | 1 | 4.00 |
Back to Segment Statistics
Back to Top
Segments by Buffer Busy Waits
- % of Capture shows % of Buffer Busy Waits for each top segment compared
- with total Buffer Busy Waits for all segments captured by the Snapshot
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
|---|---|---|---|---|---|---|
| APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 563 | 34.35 | |
| APPS | APPS_TS_TX_DATA | XXTJ_ACTUALS_MVIEW | TABLE | 206 | 12.57 | |
| APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N1 | INDEX | 155 | 9.46 | |
| SYS | SYSTEM | AUD$ | TABLE | 145 | 8.85 | |
| APPLSYS | APPS_TS_TX_DATA | FND_CONC_PROG_ONSITE_INFO | TABLE | 99 | 6.04 |
Back to Segment Statistics
Back to Top
Dictionary Cache Stats
- "Pct Misses" should be very low (< 2% in most cases)
- "Final Usage" is the number of cache entries being used
| Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
|---|---|---|---|---|---|---|
| dc_awr_control | 136 | 0.00 | 0 | 4 | 8 | |
| dc_free_extents | 1,582 | 0.00 | 0 | 0 | 209 | |
| dc_global_oids | 56,606 | 0.07 | 0 | 36 | 1,115 | |
| dc_histogram_data | 12,893 | 0.00 | 0 | 0 | 3,524 | |
| dc_histogram_defs | 668,846 | 0.09 | 0 | 0 | 45,529 | |
| dc_object_grants | 1,671 | 0.00 | 0 | 0 | 329 | |
| dc_objects | 1,858,604 | 0.02 | 0 | 114 | 62,538 | |
| dc_profiles | 12,314 | 0.00 | 0 | 0 | 3 | |
| dc_rollback_segments | 13,872 | 0.00 | 0 | 0 | 161 | |
| dc_segments | 82,918 | 0.04 | 0 | 86 | 75,857 | |
| dc_sequences | 1,117 | 0.45 | 0 | 1,117 | 254 | |
| dc_table_scns | 1,093 | 0.00 | 0 | 40 | 53 | |
| dc_tablespace_quotas | 3,156 | 0.00 | 0 | 0 | 67 | |
| dc_tablespaces | 1,832,221 | 0.00 | 0 | 0 | 23 | |
| dc_users | 2,163,321 | 0.00 | 0 | 0 | 1,689 | |
| global database name | 8,401 | 0.00 | 0 | 0 | 2 | |
| kqlsubheap_object | 6 | 0.00 | 0 | 0 | 4 | |
| outstanding_alerts | 240 | 0.00 | 0 | 0 | 19 | |
| qmtmrciq_cache_entries | 21 | 0.00 | 0 | 0 | 1 | |
| qmtmrctn_cache_entries | 21 | 0.00 | 0 | 0 | 1 | |
| qmtmrctq_cache_entries | 21 | 0.00 | 0 | 0 | 1 |
Back to Top
Library Cache Activity
- "Pct Misses" should be very low
| Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
|---|---|---|---|---|---|---|
| ACCOUNT_STATUS | 9,238 | 0.00 | 0 | 0 | 0 | |
| APP CONTEXT | 12,595 | 0.00 | 166,779 | -0.00 | 0 | 0 |
| BODY | 157,521 | 0.02 | 47,841,544 | -0.00 | 4 | 0 |
| CLUSTER | 5 | 0.00 | 5 | 0.00 | 0 | 0 |
| CONTEXT POLICY | 4,534 | 0.00 | 4,534 | 0.00 | 0 | 0 |
| DBLINK | 9,242 | 0.00 | 0 | 0 | 0 | |
| DIRECTORY | 17,816 | 0.00 | 17,816 | 0.00 | 0 | 0 |
| EDITION | 3,575 | 0.00 | 6,657 | 0.00 | 0 | 0 |
| INDEX | 397 | 0.50 | 397 | 0.50 | 0 | 0 |
| JAVA DATA | 73 | 0.00 | 234 | 0.00 | 0 | 0 |
| JAVA RESOURCE | 67 | 0.00 | 67 | 0.00 | 0 | 0 |
| OBJECT ID | 18 | 100.00 | 0 | 0 | 0 | |
| PIPE | 1,431 | 0.00 | 1,437 | 0.00 | 0 | 0 |
| QUEUE | 97,121,868 | 0.00 | 97,146,356 | 0.00 | 19 | 0 |
| RULESET | 145 | 0.00 | 1,241 | 0.00 | 0 | 0 |
| SCHEMA | 3,220 | 0.00 | 0 | 0 | 0 | |
| SECURITY CLASS | 127 | 0.00 | 127 | 0.00 | 0 | 0 |
| SQL AREA | 223,141 | 0.35 | 59,917,467 | -0.03 | 836 | 485 |
| SQL AREA BUILD | 1,592 | 60.99 | 0 | 0 | 0 | |
| SQL AREA STATS | 1,701 | 64.61 | 1,701 | 64.61 | 0 | 0 |
| SUBSCRIPTION | 207 | 0.00 | 207 | 0.00 | 0 | 0 |
| SUMMARY | 127 | 0.00 | 110 | 0.00 | 0 | 9 |
| TABLE/PROCEDURE | 609,508 | 0.01 | 48,972,252 | 0.00 | 122 | 0 |
| TRIGGER | 19,454 | 0.01 | 77,881 | 0.00 | 0 | 0 |
| XDB ACL | 23 | 0.00 | 23 | 0.00 | 0 | 0 |
| XDB CONFIG | 21 | 0.00 | 21 | 0.00 | 0 | 0 |
| XML SCHEMA | 105 | 0.00 | 189 | 0.00 | 0 | 0 |
Back to Top
Memory Statistics
- Memory Dynamic Components
- Memory Resize Operations Summary
- Memory Resize Ops
- Process Memory Summary
- SGA Memory Summary
- SGA breakdown difference
Memory Dynamic Components
- Min/Max sizes since instance startup
- Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
- ordered by Component
| Component | Begin Snap Size (Mb) | Current Size (Mb) | Min Size (Mb) | Max Size (Mb) | Oper Count | Last Op Typ/Mod |
|---|---|---|---|---|---|---|
| ASM Buffer Cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 16K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 2K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 32K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 4K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 8K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT buffer cache | 13,504.00 | 13,504.00 | 13,184.00 | 13,504.00 | 0 | GRO/DEF |
| KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| PGA Target | 5,120.00 | 5,120.00 | 5,120.00 | 5,120.00 | 0 | STA/ |
| RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| SGA Target | 20,480.00 | 20,480.00 | 20,480.00 | 20,480.00 | 0 | STA/ |
| Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| java pool | 384.00 | 384.00 | 384.00 | 384.00 | 0 | SHR/DEF |
| large pool | 64.00 | 64.00 | 64.00 | 64.00 | 0 | STA/ |
| shared pool | 6,272.00 | 6,272.00 | 6,272.00 | 6,528.00 | 0 | SHR/DEF |
| streams pool | 64.00 | 64.00 | 64.00 | 128.00 | 0 | SHR/DEF |
Back to Memory Statistics
Back to Top
Memory Resize Operations Summary
No data exists for this section of the report. Back to Memory StatisticsBack to Top
Memory Resize Ops
No data exists for this section of the report. Back to Memory StatisticsBack to Top
Process Memory Summary
- B: Begin Snap E: End Snap
- All rows below contain absolute values (i.e. not diffed over the interval)
- Max Alloc is Maximum PGA Allocation size at snapshot time
- Hist Max Alloc is the Historical Max Allocation for still-connected processes
- ordered by Begin/End snapshot, Alloc (MB) desc
| Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
|---|---|---|---|---|---|---|---|---|---|
| B | Other | 1,419.60 | 4.58 | 9.65 | 93 | 93 | 310 | 310 | |
B | PL/SQL | 657.26 | 499.59 | 2.12 | 2.72 | 15 | 21 | 310 | 310 |
B | SQL | 248.33 | 163.90 | 0.85 | 3.88 | 43 | 388 | 293 | 285 |
B | Freeable | 147.81 | 0.00 | 0.85 | 1.94 | 19 | 174 | 174 | |
B | JAVA | 136.82 | 128.61 | 3.04 | 0.75 | 8 | 8 | 45 | 45 |
| E | Other | 1,726.77 | 4.73 | 8.22 | 74 | 74 | 365 | 365 | |
E | PL/SQL | 1,190.73 | 891.00 | 3.26 | 4.52 | 21 | 55 | 365 | 365 |
E | Freeable | 424.06 | 0.00 | 2.06 | 12.97 | 174 | 206 | 206 | |
E | SQL | 402.90 | 244.76 | 1.16 | 8.36 | 152 | 824 | 348 | 339 |
E | JAVA | 252.17 | 241.01 | 3.11 | 0.73 | 8 | 8 | 81 | 81 |
Back to Memory Statistics
Back to Top
SGA Memory Summary
| SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
|---|---|---|
| Database Buffers | 14,159,970,304 | |
| Fixed Size | 2,262,656 | |
| Redo Buffers | 103,182,336 | |
| Variable Size | 7,113,542,016 |
Back to Top
SGA breakdown difference
- ordered by Pool, Name
- N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot
| Pool | Name | Begin MB | End MB | % Diff |
|---|---|---|---|---|
| java | JOXLE | 34.30 | 34.30 | 0.00 |
| java | free memory | 289.23 | 289.23 | 0.00 |
| large | PX msg pool | 7.81 | 7.81 | 0.00 |
| large | free memory | 56.19 | 56.19 | 0.00 |
| shared | KGLH0 | 966.58 | 968.74 | 0.22 |
| shared | KGLHD | 154.13 | 154.26 | 0.08 |
| shared | KGLS | 109.31 | 105.08 | -3.86 |
| shared | KKSSP | 65.53 | ||
| shared | KQR L PO | 64.05 | 62.85 | -1.86 |
| shared | KQR M PO | 64.64 | -100.00 | |
| shared | PLMCD | 173.94 | 174.36 | 0.24 |
| shared | SQLA | 2,778.33 | 2,872.36 | 3.38 |
| shared | db_block_hash_buckets | 89.00 | 89.00 | 0.00 |
| shared | free memory | 1,149.84 | 1,035.55 | -9.94 |
| streams | KGH: NO ACCESS | 63.98 | 63.98 | 0.00 |
| streams | KTG hash buckets | 5.04 | 5.04 | 0.00 |
| streams | KWQDL hash ta | 1.28 | 1.29 | 0.30 |
| streams | free memory | 57.68 | 57.68 | -0.01 |
| buffer_cache | 13,504.00 | 13,504.00 | 0.00 | |
| fixed_sga | 2.16 | 2.16 | 0.00 | |
| log_buffer | 98.40 | 98.40 | 0.00 |
Back to Memory Statistics
Back to Top
Streams Statistics
- Streams CPU/IO Usage
- Streams Capture
- Streams Capture Rate
- Streams Apply
- Streams Apply Rate
- Buffered Queues
- Buffered Queue Subscribers
- Rule Set
- Persistent Queues
- Persistent Queues Rate
- Persistent Queue Subscribers
Streams CPU/IO Usage
- Streams processes ordered by CPU Time, descending
| Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
|---|---|---|---|---|
| QMON Slaves | 0812 14:44:55 | 35,266.66 | 4.18 | 0.00 |
| QMON Coordinator | 0812 14:44:45 | 5,193.63 | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Streams Capture
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Streams Capture Rate
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Streams Apply
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Streams Apply Rate
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Buffered Queues
- Ordered by Queue Name
- * indicates queue (re)started between Begin/End snaps
| Queue Name | Enq Msgs | Enq Msgs/sec | Deq Msgs | Deq Msgs/sec | Spill Msgs | Spill Msgs/sec | %Spill Msgs |
|---|---|---|---|---|---|---|---|
| APPLSYS.WF_CONTROL(245634) | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 |
Back to Streams Statistics
Back to Top
Buffered Queue Subscribers
- Ordered by Queue Name, Subscriber Name
- * indicates Subscriber activity (re)started between Begin/End snaps
| Subscriber/Queue | Enq Msgs | Enq Msgs/sec | Deq Msgs | Deq Msgs/sec | Spill Msgs | Spill Msgs/sec | %Spill Msgs |
|---|---|---|---|---|---|---|---|
| WFBESCL_1743(4862)/APPLSYS.WF_CONTROL | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | |
| WFBESCL_1744(4861)/APPLSYS.WF_CONTROL | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | |
| WFBESCL_1745(4860)/APPLSYS.WF_CONTROL | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 |
Back to Streams Statistics
Back to Top
Rule Set
- Rule Sets ordered by Evaluations
- * indicates Rule Set activity (re)started between Begin/End snaps
- SQL per Eval - average # of SQL statements executed for non-SQL free evals
- CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals
| Rule | Evals | No-SQL Eval% | SQL Execs | CPU(s) | Ela(s) | Eval /Sec | SQL per Eval | Ela(s) per Eval | CPU(s) per Eval | Reloads |
|---|---|---|---|---|---|---|---|---|---|---|
| APPLSYS.WF_DEFERRED_R | 624 | 0.00 | 0 | 0.06 | 0.05 | 0.09 | 0.00 | 0.00 | 0.00 | 0 |
| APPLSYS.WF_NOTIFICATION_OUT_R | 481 | 0.00 | 0 | 0.03 | 0.05 | 0.07 | 0.00 | 0.00 | 0.00 | 0 |
| APPLSYS.FND_CP_GSM_OPP_AQ_R | 109 | 0.00 | 0 | 0.02 | 0.01 | 0.02 | 0.00 | 0.00 | 0.00 | 0 |
| APPLSYS.WF_JAVA_DEFERRED_R | 23 | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 |
| APPLSYS.WF_DEFERRED_QUEUE_M_R | 2 | 0.00 | 2 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0 |
Back to Streams Statistics
Back to Top
Persistent Queues
- Ordered by Queue Name
- * indicates queue (re)started between Begin/End snaps
- %Exp Msgs - % of msgs enqueued with expiry
- %Delay Msgs - % of msgs enqueued with delay
- %Trasf Time - % of Enqueue time spent in transformation
- %Eval Time - % of Enqueue time spent in rule evaluation
| Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
|---|---|---|---|---|---|---|---|---|
| APPLSYS.FND_CP_GSM_IPC_AQ(1141527) | 0 | 0 | 0.00 | 0.00 | ||||
| APPLSYS.FND_CP_GSM_OPP_AQ(412748) | 218 | 218 | 100.00 | 0.00 | 1.26 | 589.80 | 0.00 | 2.58 |
| APPLSYS.WF_CONTROL(245634) | 0 | 0 | 0.00 | 0.00 | ||||
| APPLSYS.WF_DEFERRED(173335) | 625 | 621 | 0.00 | 0.00 | 5.23 | 0.31 | 0.00 | 2.55 |
| APPLSYS.WF_DEFERRED_QUEUE_M(173064) | 2 | 1 | 0.00 | 100.00 | 0.14 | 0.00 | 0.00 | 1.06 |
| APPLSYS.WF_ERROR(173358) | 21 | 21 | 0.00 | 0.00 | 0.42 | 0.12 | 0.00 | 0.00 |
| APPLSYS.WF_JAVA_DEFERRED(332881) | 19 | 0 | 0.00 | 0.00 | 0.64 | 16.76 | 0.00 | 1.35 |
| APPLSYS.WF_NOTIFICATION_OUT(1892360) | 481 | 214 | 0.00 | 0.00 | 15.94 | 102.72 | 0.00 | 0.73 |
| ASO.ASO_OF_Q(81809) | 0 | 0 | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Persistent Queues Rate
- Ordered by Queue Name
- * indicates queue (re)started between Begin/End snaps
| Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
|---|---|---|---|---|
| APPLSYS.FND_CP_GSM_IPC_AQ(1141527) | 0.00 | 0.00 | ||
| APPLSYS.FND_CP_GSM_OPP_AQ(412748) | 0.03 | 0.03 | 0.01 | 2.71 |
| APPLSYS.WF_CONTROL(245634) | 0.00 | 0.00 | ||
| APPLSYS.WF_DEFERRED(173335) | 0.09 | 0.09 | 0.01 | 0.00 |
| APPLSYS.WF_DEFERRED_QUEUE_M(173064) | 0.00 | 0.00 | 0.07 | 0.00 |
| APPLSYS.WF_ERROR(173358) | 0.00 | 0.00 | 0.02 | 0.01 |
| APPLSYS.WF_JAVA_DEFERRED(332881) | 0.00 | 0.00 | 0.03 | |
| APPLSYS.WF_NOTIFICATION_OUT(1892360) | 0.07 | 0.03 | 0.03 | 0.48 |
| ASO.ASO_OF_Q(81809) | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Persistent Queue Subscribers
- Ordered by Queue Name, Subscriber Name
- * indicates Subscriber activity (re)started between Begin/End snaps
| Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
|---|---|---|---|---|---|---|
| FNDCPGSMIPC_CARTRIDGE_597639(3180)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_CARTRIDGE_597641(3184)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_CARTRIDGE_597642(3186)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_CARTRIDGE_597643(3188)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_CARTRIDGE_597644(3190)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_CARTRIDGE_597645(3192)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_CARTRIDGE_597646(3194)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | |||
| FNDCPGSMIPC_SERVICE_597639(3181)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597640(3183)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597641(3185)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597642(3187)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597643(3189)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597644(3191)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597645(3193)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| FNDCPGSMIPC_SERVICE_597646(3195)/APPLSYS.FND_CP_GSM_IPC_AQ | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| OPP597643(5317)/APPLSYS.FND_CP_GSM_OPP_AQ | 109 | 109 | 0 | 0.02 | 0.02 | 0.00 |
| OPP597645(5318)/APPLSYS.FND_CP_GSM_OPP_AQ | 109 | 109 | 0 | 0.02 | 0.02 | 0.00 |
| WFBESCL_1743(4862)/APPLSYS.WF_CONTROL | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| WFBESCL_1744(4861)/APPLSYS.WF_CONTROL | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| WFBESCL_1745(4860)/APPLSYS.WF_CONTROL | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| WF_DEFERRED(1)/APPLSYS.WF_DEFERRED | 625 | 624 | 0 | 0.09 | 0.09 | 0.00 |
| APPS(1)/APPLSYS.WF_DEFERRED_QUEUE_M | 2 | 1 | 0 | 0.00 | 0.00 | 0.00 |
| WF_ERROR(1)/APPLSYS.WF_ERROR | 21 | 21 | 0 | 0.00 | 0.00 | 0.00 |
| WF_JAVA_DEFERRED(1)/APPLSYS.WF_JAVA_DEFERRED | 19 | 19 | 0 | 0.00 | 0.00 | 0.00 |
| WF_NOTIFICATION_OUT(1)/APPLSYS.WF_NOTIFICATION_OUT | 481 | 481 | 0 | 0.07 | 0.07 | 0.00 |
Back to Streams Statistics
Back to Top
Resource Limit Stats
No data exists for this section of the report.Back to Top
Shared Server Statistics
- Shared Servers Activity
- Shared Servers Rates
- Shared Servers Utilization
- Shared Servers Common Queue
- Shared Servers Dispatchers
Shared Servers Activity
- Values represent averages for all samples
| Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 0 | 0 |
Back to Shared Server Statistics
Back to Top
Shared Servers Rates
| Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Back to Shared Server Statistics
Back to Top
Shared Servers Utilization
No data exists for this section of the report. Back to Shared Server StatisticsBack to Top
Shared Servers Common Queue
No data exists for this section of the report. Back to Shared Server StatisticsBack to Top
Shared Servers Dispatchers
No data exists for this section of the report. Back to Shared Server StatisticsBack to Top
init.ora Parameters
Back to Topinit.ora Parameters
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| _b_tree_bitmap_plans | FALSE | |
| _fast_full_scan_enabled | FALSE | |
| _gby_hash_aggregation_enabled | FALSE | |
| _like_with_bind_as_equality | TRUE | |
| _optimizer_autostats_job | FALSE | |
| _query_on_physical | FALSE | |
| _remove_aggr_subquery | FALSE | |
| _sort_elimination_cost_ratio | 5 | |
| _system_trig_enabled | TRUE | |
| _trace_files_public | TRUE | |
| aq_tm_processes | 1 | |
| archive_lag_target | 0 | |
| audit_sys_operations | TRUE | |
| audit_trail | DB, EXTENDED | |
| cell_offload_processing | FALSE | |
| compatible | 11.2.0 | |
| control_files | /oradb/oracle/product/TJTG/db/apps_st/data/cntrl01.dbf, /oradb_1/oracle/product/TJTG/db/apps_st/data/cntrl03.dbf, /oradb_2/oracle/product/TJTG/db/apps_st/data/cntrl02.dbf | |
| cursor_sharing | EXACT | |
| db_block_checking | FALSE | |
| db_block_checksum | TRUE | |
| db_block_size | 8192 | |
| db_files | 512 | |
| db_lost_write_protect | FULL | |
| db_name | TJTG | |
| db_unique_name | EBS_CHENNAI | |
| db_writer_processes | 1 | |
| dg_broker_start | TRUE | |
| diagnostic_dest | /orahome/oracle/product/TJTG/db/adr | |
| dml_locks | 10000 | |
| event | 38022 trace name context forever, level 1 | |
| fal_server | ebs_stndby | |
| filesystemio_options | SETALL | |
| job_queue_processes | 8 | |
| log_archive_config | dg_config=(EBS_CHENNAI, EBS_HYDERABAD) | |
| log_archive_dest_1 | LOCATION=/arch/oracle/product/TJTG/db/apps_st/data | |
| log_archive_dest_2 | service="ebs_stndby", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="EBS_HYDERABAD" net_timeout=30, valid_for=(all_logfiles, primary_role) | |
| log_archive_dest_state_2 | ENABLE | |
| log_archive_format | tjtg_%t_%r_%s.arc | |
| log_archive_max_processes | 4 | |
| log_archive_min_succeed_dest | 1 | |
| log_archive_trace | 0 | |
| log_buffer | 52428800 | |
| log_checkpoint_interval | 100000 | |
| log_checkpoints_to_alert | TRUE | |
| max_dump_file_size | 20480 | |
| nls_comp | binary | |
| nls_date_format | DD-MON-RR | |
| nls_length_semantics | BYTE | |
| nls_numeric_characters | ., | |
| nls_sort | binary | |
| nls_territory | america | |
| olap_page_pool_size | 157286400 | |
| open_cursors | 1200 | |
| optimizer_secure_view_merging | FALSE | |
| parallel_max_servers | 8 | |
| parallel_min_servers | 0 | |
| pga_aggregate_target | 5368709120 | |
| plsql_code_type | INTERPRETED | |
| plsql_warnings | DISABLE:ALL | |
| processes | 1200 | |
| resource_manager_plan | ||
| sec_case_sensitive_logon | FALSE | |
| service_names | TJTG, EBS_CHENNAI | |
| session_cached_cursors | 1600 | |
| sessions | 2400 | |
| sga_max_size | 21474836480 | |
| sga_target | 21474836480 | |
| shared_pool_reserved_size | 524288000 | |
| shared_pool_size | 5368709120 | |
| standby_file_management | AUTO | |
| undo_management | AUTO | |
| undo_tablespace | APPS_UNDOTS1 | |
| utl_file_dir | /usr/tmp, /usr/bin, /tmp/OUTBOUND, /orahome/oracle/product/TJTG/db/tech_st/11.2.0/appsutil/outbound/TJTG_tjpsb004, /usr/tmp | |
| workarea_size_policy | AUTO |
Back to init.ora Parameters
Back to Top
init.ora Multi-Valued Parameters
- This section only displays parameters that have more one value
- '(NULL)' indicates a missing parameter value
- A blank in the End Snapshot indicates the same value as the BeginSnapshot
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| audit_trail | DB | |
audit_trail | EXTENDED | |
| control_files | /oradb/oracle/product/TJTG/db/apps_st/data/cntrl01.dbf | |
control_files | /oradb_1/oracle/product/TJTG/db/apps_st/data/cntrl03.dbf | |
control_files | /oradb_2/oracle/product/TJTG/db/apps_st/data/cntrl02.dbf | |
| log_archive_dest_2 | LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="EBS_HYDERABAD" net_timeout=30 | |
log_archive_dest_2 | service="ebs_stndby" | |
log_archive_dest_2 | valid_for=(all_logfiles, primary_role) | |
| service_names | EBS_CHENNAI | |
service_names | TJTG | |
| utl_file_dir | /orahome/oracle/product/TJTG/db/tech_st/11.2.0/appsutil/outbound/TJTG_tjpsb004 | |
utl_file_dir | /tmp/OUTBOUND | |
utl_file_dir | /usr/bin | |
utl_file_dir | /usr/tmp | |
utl_file_dir | /usr/tmp | |
utl_file_dir | /usr/tmp | |
utl_file_dir | /usr/tmp |
Back to init.ora Parameters
Back to Top
Dynamic Remastering Stats
No data exists for this section of the report.Back to Top End of Report
No comments:
Post a Comment