WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 220594996 VIS 1 10.2.0.3.0 NO r12db.sanmateo.ibm.com

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 995 26-Mar-09 21:37:43 169 35.5
End Snap: 996 26-Mar-09 23:00:35 169 34.0
Elapsed:   82.86 (mins)    
DB Time:   555.32 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 8,128M 8,128M Std Block Size: 8K
Shared Pool Size: 2,000M 2,000M Log Buffer: 30,724K

Load Profile

  Per Second Per Transaction
Redo size: 3,572,179.06 49,710.54
Logical reads: 656,497.44 9,135.84
Block changes: 24,544.35 341.56
Physical reads: 142.01 1.98
Physical writes: 342.73 4.77
User calls: 4,675.01 65.06
Parses: 3,703.04 51.53
Hard parses: 0.10 0.00
Sorts: 3,530.97 49.14
Logons: 0.05 0.00
Executes: 42,713.87 594.41
Transactions: 71.86  

% Blocks changed per Read: 3.74 Recursive Call %: 95.08
Rollback per transaction %: 1.43 Rows per Sort: 1.89

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.94 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 100.01 Soft Parse %: 100.00
Execute to Parse %: 91.33 Latch Hit %: 96.42
Parse CPU to Parse Elapsd %: 87.49 % Non-Parse CPU: 99.14

Shared Pool Statistics

  Begin End
Memory Usage %: 21.88 23.01
% SQL with executions>1: 87.33 94.42
% Memory for SQL w/exec>1: 89.11 90.77

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   28,533   85.6  
enq: UL - contention 56,040 2,896 52 8.7 Application
log file sync 151,429 788 5 2.4 Commit
latch: cache buffers chains 13,355,671 764 0 2.3 Concurrency
wait list latch free 12,617 136 11 .4 Other

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 32,165.32 96.54
DB CPU 28,532.91 85.63
PL/SQL execution elapsed time 10,635.94 31.92
parse time elapsed 342.26 1.03
repeated bind elapsed time 17.03 0.05
inbound PL/SQL rpc elapsed time 10.93 0.03
sequence load elapsed time 3.99 0.01
hard parse elapsed time 2.17 0.01
connection management call elapsed time 0.47 0.00
PL/SQL compilation elapsed time 0.27 0.00
hard parse (sharing criteria) elapsed time 0.06 0.00
Java execution elapsed time 0.05 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 33,319.31  
background elapsed time 1,405.05  
background cpu time 190.48  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
Application 62,846 0.12 2,898 46 0.18
Concurrency 15,456,865 0.02 987 0 43.26
Commit 151,429 0.00 788 5 0.42
Other 267,957 63.17 156 1 0.75
User I/O 710,167 0.00 51 0 1.99
Network 22,536,879 0.00 21 0 63.08
System I/O 287,277 0.00 20 0 0.80
Configuration 8,985 0.00 2 0 0.03

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
enq: UL - contention 56,040 0.13 2,896 52 0.16
log file sync 151,429 0.00 788 5 0.42
latch: cache buffers chains 13,355,671 0.00 764 0 37.38
wait list latch free 12,617 0.00 136 11 0.04
buffer busy waits 1,838,962 0.00 120 0 5.15
enq: TX - index contention 118,143 0.00 47 0 0.33
db file sequential read 703,385 0.00 46 0 1.97
cursor: pin S wait on X 4,708 65.31 33 7 0.01
control file parallel write 2,233 0.00 18 8 0.01
SQL*Net message to client 21,811,957 0.00 18 0 61.05
latch: In memory undo latch 121,687 0.00 17 0 0.34
read by other session 5,320 0.00 5 1 0.01
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 4884 0.00
latch free 21,358 0.00 5 0 0.06
SQL*Net more data from client 722,670 0.00 4 0 2.02
buffer deadlock 174,048 97.22 3 0 0.49
kksfbc child completion 70 75.71 3 38 0.00
enq: TX - row lock contention 5,160 0.00 2 0 0.01
latch: library cache 10,457 0.00 2 0 0.03
os thread startup 55 0.00 2 35 0.00
latch: cache buffer handles 7,507 0.00 2 0 0.02
log file parallel write 216,671 0.00 1 0 0.61
enq: SQ - contention 8,852 0.00 1 0 0.02
latch: undo global data 5,952 0.00 1 0 0.02
latch: library cache pin 5,048 0.00 1 0 0.01
db file parallel write 67,679 0.00 1 0 0.19
log file switch completion 29 0.00 0 16 0.00
SQL*Net break/reset to client 1,646 0.00 0 0 0.00
latch: session allocation 1,501 0.00 0 0 0.00
LGWR wait for redo copy 6,012 0.00 0 0 0.02
rdbms ipc reply 521 0.00 0 1 0.00
latch: library cache lock 1,638 0.00 0 0 0.00
latch: redo allocation 677 0.00 0 0 0.00
enq: CU - contention 6 0.00 0 24 0.00
cursor: pin S 37,257 0.00 0 0 0.10
latch: row cache objects 470 0.00 0 0 0.00
latch: cache buffers lru chain 262 0.00 0 0 0.00
SQL*Net more data to client 2,252 0.00 0 0 0.01
latch: object queue header operation 46 0.00 0 1 0.00
enq: HW - contention 76 0.00 0 0 0.00
latch: enqueue hash chains 86 0.00 0 0 0.00
control file sequential read 690 0.00 0 0 0.00
db file scattered read 35 0.00 0 0 0.00
cursor: pin X 2 50.00 0 5 0.00
latch: checkpoint queue latch 26 0.00 0 0 0.00
latch: shared pool 12 0.00 0 0 0.00
enq: TX - allocate ITL entry 25 0.00 0 0 0.00
direct path read 996 0.00 0 0 0.00
latch: messages 8 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
direct path write temp 109 0.00 0 0 0.00
cursor: mutex X 14 0.00 0 0 0.00
direct path read temp 109 0.00 0 0 0.00
direct path write 213 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
log file sequential read 2 0.00 0 0 0.00
undo segment extension 1 0.00 0 0 0.00
SQL*Net message from client 21,811,947 0.00 282,357 13 61.05
Streams AQ: waiting for messages in the queue 11,511 98.19 98,068 8519 0.03
pipe get 5,951 99.33 24,264 4077 0.02
PL/SQL lock timer 2,925 99.76 23,069 7887 0.01
Streams AQ: qmn slave idle wait 1,369 0.00 5,347 3906 0.00
Streams AQ: qmn coordinator idle wait 2,268 34.08 4,848 2138 0.01
Streams AQ: waiting for time management or cleanup tasks 3 100.00 2,189 729684 0.00
jobq slave wait 595 97.14 1,732 2911 0.00
class slave wait 2 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
control file parallel write 2,233 0.00 18 8 0.01
events in waitclass Other 6,700 0.01 6 1 0.02
os thread startup 55 0.00 2 35 0.00
log file parallel write 216,671 0.00 1 0 0.61
db file parallel write 67,679 0.00 1 0 0.19
db file sequential read 71 0.00 0 2 0.00
latch: cache buffers chains 29 0.00 0 1 0.00
control file sequential read 656 0.00 0 0 0.00
buffer busy waits 4 0.00 0 1 0.00
direct path read 996 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
direct path write 213 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
log file sequential read 2 0.00 0 0 0.00
rdbms ipc message 445,045 3.71 46,325 104 1.25
Streams AQ: qmn slave idle wait 1,369 0.00 5,347 3906 0.00
pmon timer 2,024 83.55 4,851 2397 0.01
Streams AQ: qmn coordinator idle wait 2,268 34.08 4,848 2138 0.01
smon timer 243 2.88 4,591 18892 0.00
Streams AQ: waiting for time management or cleanup tasks 3 100.00 2,189 729684 0.00
class slave wait 2 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 3,162,388
IDLE_TIME 2,803,087
IOWAIT_TIME 61,010
NICE_TIME 49
SYS_TIME 189,145
USER_TIME 2,944,247
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 339,052
NUM_CPUS 12
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 33,317.50 28,531.60 704,829 3,263,847,163
SYS$USERS 1.80 1.30 119 11,483
SYS$BACKGROUND 0.00 0.00 1,051 83,319

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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
VIS 708569 5090 15456777 98549 0 0 22536387 2115
SYS$USERS 327 16 0 0 0 0 1 0
SYS$BACKGROUND 1269 12 88 194 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
19,968 19,870 249,233 0.08 59.93 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
19,872 19,774 249,671 0.08 59.64 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
3,724 1,191 60 62.06 11.18 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
1,398 1,307 249,987 0.01 4.19 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
1,241 1,238 3,748,793 0.00 3.72 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,026 1,024 3,747,687 0.00 3.08 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,012 887 249,792 0.00 3.04 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
932 931 4,247,316 0.00 2.80 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
905 903 1,499,267 0.00 2.72 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
893 891 2,748,986 0.00 2.68 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
816 412 12,499 0.07 2.45 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
650 643 28,392,138 0.00 1.95 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
633 579 249,995 0.00 1.90 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
585 60 12,512 0.05 1.76 73rvua18a9ytx PYUSLV declare ret number ; BEGIN hr_...
503 502 1,124,666 0.00 1.51 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
468 467 2,749,822 0.00 1.41 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
440 438 10,720,406 0.00 1.32 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
419 419 13,593,609 0.00 1.26 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
403 397 249,840 0.00 1.21 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
401 397 249,991 0.00 1.20 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
393 343 249,984 0.00 1.18 36z3h9rgkd8aa PYUSLV begin ...
366 365 249,901 0.00 1.10 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
19,870 19,968 249,233 0.08 59.93 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
19,774 19,872 249,671 0.08 59.64 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,307 1,398 249,987 0.01 4.19 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
1,238 1,241 3,748,793 0.00 3.72 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,191 3,724 60 19.86 11.18 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
1,024 1,026 3,747,687 0.00 3.08 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
931 932 4,247,316 0.00 2.80 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
903 905 1,499,267 0.00 2.72 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
891 893 2,748,986 0.00 2.68 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
887 1,012 249,792 0.00 3.04 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
643 650 28,392,138 0.00 1.95 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
579 633 249,995 0.00 1.90 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
502 503 1,124,666 0.00 1.51 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
467 468 2,749,822 0.00 1.41 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
438 440 10,720,406 0.00 1.32 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
419 419 13,593,609 0.00 1.26 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
412 816 12,499 0.03 2.45 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
397 403 249,840 0.00 1.21 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
397 401 249,991 0.00 1.20 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
365 366 249,901 0.00 1.10 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
343 393 249,984 0.00 1.18 36z3h9rgkd8aa PYUSLV begin ...
60 585 12,512 0.00 1.76 73rvua18a9ytx PYUSLV declare ret number ; BEGIN hr_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
2,235,379,554 249,671 8,953.30 68.49 19774.11 19871.80 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
2,213,043,065 249,233 8,879.41 67.80 19870.03 19967.86 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
251,949,867 3,748,793 67.21 7.72 1238.33 1240.86 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
248,589,156 1,499,267 165.81 7.62 903.49 904.70 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
210,990,547 60 3,516,509.12 6.46 1191.43 3723.69 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
198,425,050 3,747,687 52.95 6.08 1024.38 1026.14 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
184,034,366 2,748,986 66.95 5.64 891.05 892.82 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
139,288,914 1,124,666 123.85 4.27 501.71 502.62 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
122,248,530 13,593,609 8.99 3.75 418.53 419.37 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
118,565,998 249,987 474.29 3.63 1307.06 1397.52 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
118,009,125 10,720,406 11.01 3.62 437.88 439.99 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
85,142,247 28,392,138 3.00 2.61 643.18 650.27 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
77,293,256 249,991 309.18 2.37 397.21 401.47 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
67,470,207 249,792 270.11 2.07 887.04 1011.71 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
59,342,224 249,840 237.52 1.82 397.37 403.09 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
55,818,693 2,749,822 20.30 1.71 467.02 468.42 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
55,148,110 248,875 221.59 1.69 244.81 245.66 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS...
54,360,244 13,594,588 4.00 1.67 267.06 267.94 9wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_...
50,810,066 75,038 677.12 1.56 281.65 282.08 6gb9bfzbwqugc PYUSLV SELECT RGE.STARTING_PERSON_ID,...
47,533,326 4,247,316 11.19 1.46 930.82 932.12 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
43,536,041 249,901 174.21 1.33 364.59 366.28 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
41,039,933 499,802 82.11 1.26 116.14 116.38 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
37,487,798 3,119,615 12.02 1.15 212.63 212.82 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
34,841,297 249,612 139.58 1.07 294.13 294.30 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ...
34,072,791 12,499 2,726.04 1.04 412.34 815.64 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
32,910,599 499,729 65.86 1.01 146.89 147.88 b0j6srzdfp5jf PYUSLV select /*+ ORDERED USE_NL(AA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
429,965 249,671 1.72 60.90 19774.11 19871.80 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
426,276 249,233 1.71 60.38 19870.03 19967.86 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
63,789 2,749,822 0.02 9.03 467.02 468.42 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
59,813 249,986 0.24 8.47 284.77 294.27 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC...
50,164 499,802 0.10 7.11 116.14 116.38 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
40,675 249,991 0.16 5.76 397.21 401.47 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
25,109 248,875 0.10 3.56 244.81 245.66 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS...
20,753 499,729 0.04 2.94 146.89 147.88 b0j6srzdfp5jf PYUSLV select /*+ ORDERED USE_NL(AA...
17,592 4,247,316 0.00 2.49 930.82 932.12 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
15,699 1,499,267 0.01 2.22 903.49 904.70 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
13,792 60 229.87 1.95 1191.43 3723.69 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
10,451 249,901 0.04 1.48 364.59 366.28 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
28,392,138 43,826,491 1.54 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
13,594,588 13,606,464 1.00 0.00 0.00 9wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_...
13,593,609 13,597,089 1.00 0.00 0.00 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
10,720,406 10,729,869 1.00 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
4,247,316 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
3,748,793 3,747,651 1.00 0.00 0.00 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,747,687 3,741,576 1.00 0.00 0.00 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,119,615 3,124,317 1.00 0.00 0.00 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
2,749,822 2,749,810 1.00 0.00 0.00 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
2,749,451 2,749,839 1.00 0.00 0.00 cw5jzzppcw0kj PYUSLV SELECT PAY_ACTION_INFORMATION_...
2,748,986 2,745,211 1.00 0.00 0.00 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
3,725,953 3,747,687 20.24 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,725,385 3,748,793 20.24 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
2,735,188 2,748,986 14.86 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,484,406 1,499,267 8.06 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
1,110,985 1,124,666 6.03 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
745,089 749,395 4.05 fqgs7vbu8htby PYUSLV SELECT fnd_number.number_to_ca...
499,641 499,690 2.71 83kbt99vg4svq PYUSLV begin ...
497,662 499,780 2.70 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
495,900 499,802 2.69 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
249,953 249,999 1.36 97mt0g20bcfc3 PYUSLV begin ...
249,933 249,984 1.36 36z3h9rgkd8aa PYUSLV begin ...
249,813 249,987 1.36 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
249,440 249,233 1.35 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
249,119 249,671 1.35 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
248,535 249,935 1.35 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim...
245,393 249,884 1.33 d7shgtk3p7s4u PYUSLV SELECT /*+ ordered index(BAL...
222,270 222,270 1.21 cr74qtm56vcq6 NACHA BEGIN PAY_US_NACHA_TAPE.RUN_FO...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
01pkua627ktjk SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y')
02k10jzw8c495 SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
165d2bgc2b9hr SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment within a Government Reporting Entity for YTD based on run balances */ pay_run_balances prb, pay_defined_balances pdb, pay_payroll_actions ppa, pay_assignment_actions paa where paa.assignment_action_id = :ASSIGNMENT_ACTION_ID and prb.tax_unit_id = :TAX_UNIT_ID and ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id and paa.assignment_id = prb.assignment_id and prb.action_sequence <= paa.action_sequence and prb.effective_date >= trunc(ppa.effective_date, 'Y')
2z261p0p82p32 BEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I12, :T3, :I3, :T8, :I14, :N6, :I10, :T7, :I13, :N4, :I8, :D1, :N12, :I18, :N10, :I16, :N7, :I11, :N11, :I17, :T6, :I6, :N1, :T2, :I2, :N5, :I9, :N9, :I15, :FFERLN, :FFERCD, :FFERMT); END;
36z3h9rgkd8aa begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3n5uwzsh3y8gr SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S ', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2
3rg5fyfgd5uwc begin pay_US_rules.get_time_def_for_entry( :element_entry_id, :assignment_id, :assignment_action_id, :business_group_id, :time_def_id); end;
4ds53shhfcynn declare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3u declare begin pay_archive.process_employee(:asg_action); end;
4gz4b2bh1fs14 SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
5sfm6rppc4y8x BEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
6500rnmy4f88w SELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE
699jt64x8hadf UPDATE PAY_ASSIGNMENT_ACTIONS SET SERIAL_NUMBER = :B2 WHERE ASSIGNMENT_ACTION_ID = :B1
6gb9bfzbwqugc SELECT RGE.STARTING_PERSON_ID, RGE.ENDING_PERSON_ID, RGE.CHUNK_NUMBER, NVL(RGE.RAND_CHUNK_NUMBER, RGE.CHUNK_NUMBER) FROM PAY_POPULATION_RANGES RGE WHERE RGE.PAYROLL_ACTION_ID = :B1 AND RGE.RANGE_STATUS = 'U' AND ROWNUM < 2
6v07302134wyf INSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
73rvua18a9ytx declare ret number ; BEGIN hr_nonrun_asact . get_next_pop_chunk ( :pactid , :atype , :l_lckhandle , :lub , :lul , :chunk_method , :threads , :slave_no , :curr_chunk , :max_chunks , :stperson:stperson_ind , :endperson:endperson_ind , :chunk:chunk_ind , :rand_chunk:rand_chunk_ind ) ; END ;
7d66dw0vz7yaa begin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7mmdd7sypzu9x BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N5, :T4, :I4, :N4, :N3, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
7rks7t2gukcwn SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decod e(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') /* Within Jurisdiction */ and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
7y9t68kb4mc6q BEGIN pay_us_action_arch.action_action_creation(:pactid, :stperson, :endperson, :chunk); END;
83kbt99vg4svq begin hr_nonrun_asact.reinterlock (:assactid, :pactype); end;
8v2cvg5zhw9ua SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
97mt0g20bcfc3 begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9jv68n0ctas75 begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
9wupzu1crbdbb SELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1
b0j6srzdfp5jf select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , decode(RR.source_type, 'E', nvl(EE.creator_type, 'X'), 'I', decode(EE.creator_type, null , 'X', 'N')) , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned))), 'YYYY/MM/DD') , EL2.transfer_to_gl_flag , decode(:b3, null , null , hr_cost.get_context_value(:b3, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b5, null , null , hr_cost.get_context_value(:b5, RR.run_result_i d, RR.element_type_id, PA.date_earned)) , decode(:b7, null , null , hr_cost.get_context_value(:b7, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b9, null , null , hr_cost.get_context_value(:b9, RR.run_result_id, RR.element_type_id, PA.date_earned)) from pay_assignment_actions AA , pay_payroll_actions PA , per_all_assignments_f PERA , pay_run_results RR , pay_element_entries_f EE , pay_element_types_f ET , pay_element_classifications EC , fnd_currencies FC , pay_input_values_f IV , pay_run_result_values RRV , pay_link_input_values_f LIV , pay_element_links_f EL , pay_element_links_f EL2 where ((((((((((((((((((((((((((((((AA.assignment_action_id=:b11 and AA.payroll_action_id=PA.payroll_action_id) and RR.assignment_action_id=:b11) and RR.status like 'P%') and RR.element_type_id=ET.element_type_id) and RRV.run_result_id=RR.run_result_id) and IV.input_value_id=RRV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between IV.effective_start_date and IV.effective_end_date) and IV.element_type_id=ET.element_type_id) and RRV.result_value is not null ) and (decode(:b13, 'Y', 1, fnd_number.canonical_to_number(RRV.result_value))+decode(LIV.DEFAULT_VALUE, 'M', 0, 0))<>0) and RRV.input_value_id=LIV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between LIV.effective_start_date and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_id=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_type<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) order by 17, 8, 14
cr74qtm56vcq6 BEGIN PAY_US_NACHA_TAPE.RUN_FORMULA; END;
cw5jzzppcw0kj SELECT PAY_ACTION_INFORMATION_S.NEXTVAL FROM SYS.DUAL
d7shgtk3p7s4u SELECT /*+ ordered index(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(BACT PAY_PAYROLL_ACTIONS_PK) index(ASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(PACT PAY_PAYROLL_ACTIONS_PK) index(INTLCK2 PAY_ACTION_INTERLOCKS_FK1) index(PPASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(PPACT PAY_PAYROLL_ACTIONS_PK) index(RR PAY_RUN_RESULTS_N50) index(TARGET PAY_RUN_RESULT_VALUES_N50) index(FEED PAY_BALANCE_FEEDS_F_N50) */ fnd_number.number_to_canonical(/*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0) ) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action _id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and nvl(PACT.future_process_mode, 'Y') = 'Y' and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and pay_core_utils.include_action_in_payment(BACT.action_type, BAL_ASSACT.assignment_action_id, ASSACT.assignment_action_id) = 'Y' and NOT EXISTS (SELECT /*+ NO_PUSH_SUBQ */ NULL FROM pay_payroll_actions RPACT , pay_assignment_actions RASSACT , pay_action_interlocks RINTLK where ASSACT.assignment_action_id = RINTLK.locked_action_id and RINTLK.locking_action_id = RASSACT.assignment_action_id and RPACT.payroll_action_id = RASSACT.payroll_action_id and RPACT.action_type = 'V')
dab1prc9qyv3v begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end;
dz7tyjxnar7gt SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT. action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and R R.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and exists (select null from pay_taxability_rules TR , pay_element_types_f ET , pay_balance_types BT where ET.element_type_id = RR.element_type_id and PACT.date_earned between ET.effective_start_date and ET.effective_end_date and BT.balance_type_id = :U1 and TR.classification_id = ET.classification_id + 0 and TR.tax_category = ET.element_information1 and TR.tax_type = BT.tax_type and TR.jurisdiction_code = '00-000-0000' and nvl(TR.status, 'VALID') <> 'D' )
fnnymj5r1f0n8 SELECT PBG.LEGISLATION_CODE FROM PER_BUSINESS_GROUPS PBG WHERE PBG.BUSINESS_GROUP_ID = :B1
fqgs7vbu8htby SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment For Run */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_payroll_actions PACT where ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA')
g2daxnc5b7rav SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.ac tion_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assig nment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date
g4jp561h1bs98 select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id , to_char(null ) , PEPD.time_definition_id , nvl(ET.time_definition_type, 'N') , to_char(decode(ET.processing_type, 'R', to_date(null , :b1), EE.date_earned), :b1) , decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ) , decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ) , EE.label_identifier , decode(ACT.action_status, 'B', decode(EE.creator_type, 'EE', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b10, :b11:b12, EE.creator_id, ACT.act ion_sequence), 'RR', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b14, :b11:b16, EE.creator_id, ACT.action_sequence), 1), 1) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'AE', to_char(EE.source_start_date, :b1), 'AD', to_char(EE.source_start_date, :b1), null ) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'AE', to_char(EE.source_end_date, :b1), 'AD', to_char(EE.source_end_date, :b1), null ) from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where (((((((((((((((ACT.assignment_action_id=:b29 and EE.assignment_id=:b30) and ((:b31='N' and to_date(:b32, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b31='Y' and EE.effective_start_date<=to_date(:b32, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , decode(nvl(ET.time_definition_type, 'N'), 'N', to_date(:b32, :b1), pay_core_utils.get_time_period_start(ACT.payroll_action_id)), pay_interpreter_pkg.prorate_start_date(:b29, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b32, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.elem ent_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b31='N' or ET.proration_group_id is null ) or (:b31='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b32, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ((((ET.processing_type='N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b32, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
gq04p7vgjcmkg SELECT PPT.CATEGORY CATEGORY, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_METHOD, PEA.PRENOTE_DATE PRENOTE_DATE, PPT.VALIDATION_DAYS VALID_DAYS, PPM.PERCENTAGE PERCENTAGE, PPM.AMOUNT AMOUNT, OPM.ORG_PAYMENT_METHOD_ID ORG_METHOD, HR_PRE_PAY.SET_CASH_RULE(PPT.CATEGORY, OPM.PMETH_INFORMATION1) CASH_RULE, OPM.CURRENCY_CODE PAYMENT_CURRENCY, PPT.PRE_VALIDATION_REQUIRED VALIDATION_REQUIRED, PPT.VALIDATION_VALUE VALIDATION_VALUE, OPM.EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID FROM PAY_EXTERNAL_ACCOUNTS PEA, PAY_PAYMENT_TYPES PPT, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_ASSIGNMENT_ACTIONS ACT WHERE ACT.ASSIGNMENT_ACTION_ID=:B4 AND PPM.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PPM.RUN_TYPE_ID = :B3 AND PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND OPM.DEFINED_BALANCE_ID = :B2 AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN PPM.EFFECTIVE_START_DATE AND PPM.EFFECTIVE_END_DATE AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE ORDER BY PPM.PERSON_ID, PPM.PRIORITY
grg3zu94xp62h SELECT PDB.BALANCE_TYPE_ID, PDR.ROUTE_ID, PDR.BALANCE_TYPE_COLUMN, PDR.RETRIEVAL_COLUMN, NVL(PDR.DECODE_REQUIRED, 'N'), NVL(JURISDICTION_LEVEL, 0) FROM PAY_DEFINED_BALANCES PDB, PAY_DIMENSION_ROUTES PDR, PAY_BALANCE_TYPES PBT WHERE PDB.DEFINED_BALANCE_ID = :B2 AND PDB.BALANCE_DIMENSION_ID = PDR.BALANCE_DIMENSION_ID AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID AND PDR.PRIORITY = :B1
gxa19cf01sb0c SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, PTS.MEANING, PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS WHERE PTS.ASSIGNMENT_ID = :B2 AND PTS.JURISDICTION_CODE LIKE :B1

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 2,904,679 584.24 8.13
CPU used when call started 2,904,485 584.20 8.13
CR blocks created 11,978,260 2,409.26 33.53
Cached Commit SCN referenced 1,166 0.23 0.00
Commit SCN cached 2 0.00 0.00
DB time 14,505,437 2,917.57 40.60
DBWR checkpoint buffers written 1,687,255 339.37 4.72
DBWR checkpoints 1 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 9 0.00 0.00
DBWR thread checkpoint buffers written 1,595,113 320.84 4.46
DBWR transaction table writes 585 0.12 0.00
DBWR undo block writes 883,944 177.79 2.47
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 226,118,447 45,480.65 632.91
IMU Flushes 201,300 40.49 0.56
IMU Redo allocation size 3,372,765,424 678,385.83 9,440.44
IMU commits 157,148 31.61 0.44
IMU contention 80,111 16.11 0.22
IMU ktichg flush 114 0.02 0.00
IMU pool not allocated 780 0.16 0.00
IMU recursive-transaction flush 7,665 1.54 0.02
IMU undo allocation size 5,362,087,224 1,078,510.82 15,008.59
IMU- failed to get a private strand 780 0.16 0.00
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 50 to 75 pct 0 0.00 0.00
Parallel operations not downgraded 0 0.00 0.00
SMON posted for undo segment shrink 6 0.00 0.00
SQL*Net roundtrips to/from client 21,811,512 4,387.09 61.05
active txn count during cleanout 53,010,853 10,662.41 148.38
application wait time 289,830 58.30 0.81
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 17,464 3.51 0.05
branch node splits 346 0.07 0.00
buffer is not pinned count 1,497,417,307 301,185.10 4,191.30
buffer is pinned count 704,430,865 141,686.67 1,971.72
bytes received via SQL*Net from client 5,741,961,638 1,154,917.38 16,071.86
bytes sent via SQL*Net to client 3,211,127,962 645,874.66 8,988.01
calls to get snapshot scn: kcmgss 228,826,930 46,025.42 640.49
calls to kcmgas 13,424,982 2,700.25 37.58
calls to kcmgcs 557,246 112.08 1.56
change write time 34,025 6.84 0.10
cleanout - number of ktugct calls 12,101,498 2,434.05 33.87
cleanouts and rollbacks - consistent read gets 11,360,967 2,285.10 31.80
cleanouts only - consistent read gets 96,870 19.48 0.27
cluster key scan block gets 16,510 3.32 0.05
cluster key scans 885 0.18 0.00
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 16,959 3.41 0.05
commit batch/immediate requested 16,959 3.41 0.05
commit cleanout failures: block lost 243 0.05 0.00
commit cleanout failures: buffer being written 378 0.08 0.00
commit cleanout failures: callback failure 172,037 34.60 0.48
commit cleanout failures: cannot pin 56,129 11.29 0.16
commit cleanouts 5,328,184 1,071.69 14.91
commit cleanouts successfully completed 5,099,397 1,025.67 14.27
commit immediate performed 16,959 3.41 0.05
commit immediate requested 16,959 3.41 0.05
commit txn count during cleanout 937,585 188.58 2.62
concurrency wait time 98,742 19.86 0.28
consistent changes 723,096,820 145,441.08 2,023.96
consistent gets 3,109,177,236 625,368.66 8,702.65
consistent gets - examination 1,859,078,297 373,928.28 5,203.60
consistent gets direct 0 0.00 0.00
consistent gets from cache 3,109,177,236 625,368.66 8,702.65
cursor authentications 542 0.11 0.00
data blocks consistent reads - undo records applied 722,313,134 145,283.45 2,021.77
db block changes 122,028,410 24,544.35 341.56
db block gets 154,764,588 31,128.79 433.19
db block gets direct 100 0.02 0.00
db block gets from cache 154,764,488 31,128.77 433.19
deferred (CURRENT) block cleanout applications 543,945 109.41 1.52
dirty buffers inspected 2,156 0.43 0.01
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 76,226 15.33 0.21
enqueue releases 2,293,166 461.24 6.42
enqueue requests 2,294,396 461.49 6.42
enqueue timeouts 1,230 0.25 0.00
enqueue waits 161,488 32.48 0.45
exchange deadlocks 174,071 35.01 0.49
execute count 212,362,745 42,713.87 594.41
failed probes on index block reclamation 42 0.01 0.00
free buffer inspected 4,569,759 919.14 12.79
free buffer requested 13,861,613 2,788.07 38.80
global undo segment hints helped 0 0.00 0.00
heap block compress 291,684 58.67 0.82
hot buffers moved to head of LRU 477,896 96.12 1.34
immediate (CR) block cleanout applications 11,457,866 2,304.59 32.07
immediate (CURRENT) block cleanout applications 919,078 184.86 2.57
index crx upgrade (found) 911,170 183.27 2.55
index crx upgrade (positioned) 28,369,595 5,706.16 79.41
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 386,362,845 77,711.62 1,081.44
index scans kdiixs1 353,708,542 71,143.66 990.04
java call heap collected bytes 0 0.00 0.00
java call heap collected count 0 0.00 0.00
java call heap gc count 0 0.00 0.00
java call heap live object count 0 0.00 0.00
java call heap live object count max 0 0.00 0.00
java call heap live size 0 0.00 0.00
java call heap live size max 0 0.00 0.00
java call heap object count 0 0.00 0.00
java call heap object count max 0 0.00 0.00
java call heap total size 0 0.00 0.00
java call heap total size max 0 0.00 0.00
java call heap used size 0 0.00 0.00
java call heap used size max 0 0.00 0.00
leaf node 90-10 splits 40,129 8.07 0.11
leaf node splits 102,025 20.52 0.29
lob reads 0 0.00 0.00
lob writes 45 0.01 0.00
lob writes unaligned 45 0.01 0.00
local undo segment hints helped 0 0.00 0.00
logons cumulative 268 0.05 0.00
messages received 535,768 107.76 1.50
messages sent 535,768 107.76 1.50
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,181,854,217 237,713.88 3,308.03
opened cursors cumulative 16,910,192 3,401.25 47.33
parse count (failures) 0 0.00 0.00
parse count (hard) 496 0.10 0.00
parse count (total) 18,410,591 3,703.04 51.53
parse time cpu 24,481 4.92 0.07
parse time elapsed 27,981 5.63 0.08
physical read IO requests 704,339 141.67 1.97
physical read bytes 5,783,781,376 1,163,328.85 16,188.92
physical read total IO requests 705,242 141.85 1.97
physical read total bytes 5,796,815,872 1,165,950.56 16,225.40
physical read total multi block requests 144 0.03 0.00
physical reads 706,028 142.01 1.98
physical reads cache 703,397 141.48 1.97
physical reads cache prefetch 163 0.03 0.00
physical reads direct 2,631 0.53 0.01
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 1,635 0.33 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 383,461 77.13 1.07
physical write bytes 13,958,815,744 2,807,625.67 39,070.99
physical write total IO requests 689,735 138.73 1.93
physical write total bytes 32,441,867,776 6,525,239.86 90,805.41
physical write total multi block requests 474,949 95.53 1.33
physical writes 1,703,957 342.73 4.77
physical writes direct 1,946 0.39 0.01
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 1,635 0.33 0.00
physical writes from cache 1,702,011 342.34 4.76
physical writes non checkpoint 1,115,329 224.33 3.12
pinned buffers inspected 2,461 0.49 0.01
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 66,844 13.44 0.19
process last non-idle time 4,786 0.96 0.01
queries parallelized 0 0.00 0.00
recursive aborts on index block reclamation 113 0.02 0.00
recursive calls 449,599,065 90,430.73 1,258.44
recursive cpu usage 2,552,471 513.39 7.14
redo blocks written 36,028,253 7,246.59 100.84
redo buffer allocation retries 11 0.00 0.00
redo entries 60,918,237 12,252.87 170.51
redo log space requests 29 0.01 0.00
redo log space wait time 52 0.01 0.00
redo ordering marks 694,619 139.71 1.94
redo size 17,759,984,808 3,572,179.06 49,710.54
redo subscn max counts 1,152,329 231.78 3.23
redo synch time 81,006 16.29 0.23
redo synch writes 118,381 23.81 0.33
redo wastage 79,832,940 16,057.31 223.45
redo write time 74,241 14.93 0.21
redo writer latching time 36 0.01 0.00
redo writes 216,671 43.58 0.61
rollback changes - undo records applied 71,752 14.43 0.20
rollbacks only - consistent read gets 717,728 144.36 2.01
rows fetched via callback 228,920,521 46,044.24 640.75
session connect time 0 0.00 0.00
session cursor cache hits 18,388,083 3,698.51 51.47
session logical reads 3,263,941,824 656,497.44 9,135.84
session pga memory max 7,982,288 1,605.53 22.34
session uga memory 77,309,920,960 15,549,837.66 216,391.95
session uga memory max 634,900,744 127,701.64 1,777.10
shared hash latch upgrades - no wait 30,859,376 6,206.94 86.38
shared hash latch upgrades - wait 1,008,610 202.87 2.82
sorts (disk) 0 0.00 0.00
sorts (memory) 17,555,105 3,530.97 49.14
sorts (rows) 33,181,263 6,673.96 92.87
space was found by tune down 0 0.00 0.00
sql area evicted 0 0.00 0.00
sql area purged 0 0.00 0.00
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 9,420 1.89 0.03
switch current to new buffer 287,921 57.91 0.81
table fetch by rowid 953,554,463 191,794.49 2,669.02
table fetch continued row 6,989 1.41 0.02
table scan blocks gotten 98,309,629 19,773.64 275.17
table scan rows gotten 992,848,007 199,697.85 2,779.00
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 1 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 12,770,966 2,568.71 35.75
total number of times SMON posted 236 0.05 0.00
transaction rollbacks 16,959 3.41 0.05
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 6,239,102,904 1,254,910.57 17,463.37
user I/O wait time 5,125 1.03 0.01
user calls 23,242,984 4,675.01 65.06
user commits 352,149 70.83 0.99
user rollbacks 5,119 1.03 0.01
workarea executions - onepass 6 0.00 0.00
workarea executions - optimal 11,173,008 2,247.30 31.27
write clones created in background 5 0.00 0.00
write clones created in foreground 6,641 1.34 0.02

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 28,981 34,765
opened cursors current 6,000 5,738
logons current 169 169

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 1 0.72

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_TS_TX_DATA 436,396 88 0.05 1.00 63,517 13 187,114 0.05
APPS_TS_TX_IDX 266,800 54 0.08 1.00 199,533 40 905,893 0.11
APPS_UNDOTS1 40 0 0.25 1.00 119,437 24 749,779 0.03
SYSTEM 83 0 3.13 1.00 380 0 310 2.16
SYSAUX 166 0 1.33 1.00 199 0 0 0.00
TEMP1 109 0 0.55 15.00 140 0 0 0.00
APPS_TS_INTERFACE 157 0 0.19 1.00 28 0 0 0.00
APPS_TS_SEED 138 0 1.81 1.39 5 0 1,035 2.09
APPS_TS_ARCHIVE 16 0 3.13 1.00 120 0 29 0.34
APPS_TS_SUMMARY 53 0 0.19 1.00 13 0 0 0.00
APPS_TS_MEDIA 36 0 0.56 1.00 7 0 0 0.00
APPS_CALCLIP 20 0 0.00 1.00 4 0 0 0.00
APPS_TS_QUEUES 19 0 0.00 1.00 4 0 0 0.00
TEMP2 0 0 0.00   18 0 0 0.00
DCM 13 0 0.00 1.00 2 0 0 0.00
GEOR_TBS 13 0 0.77 1.00 2 0 0 0.00
APPS_TS_DISCO 8 0 0.00 1.00 3 0 0 0.00
CWMLITE 8 0 0.00 1.00 2 0 0 0.00
IAS_META 8 0 2.50 1.00 1 0 0 0.00
B2B_DT 7 0 2.86 1.00 1 0 0 0.00
B2B_RT 7 0 0.00 1.00 1 0 0 0.00
DISCO_PTM5_CACHE 7 0 0.00 1.00 1 0 0 0.00
DSGATEWAY_TAB 7 0 0.00 1.00 1 0 0 0.00
WCRSYS_TS 7 0 0.00 1.00 1 0 0 0.00
APPS_OMO 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO_OLAP 6 0 0.00 1.00 1 0 0 0.00
B2B_IDX 6 0 0.00 1.00 1 0 0 0.00
B2B_LOB 6 0 0.00 1.00 1 0 0 0.00
BAM 6 0 0.00 1.00 1 0 0 0.00
DISCO_PTM5_META 6 0 0.00 1.00 1 0 0 0.00
MTR 6 0 0.00 1.00 1 0 0 0.00
NOETIX 6 0 0.00 1.00 1 0 0 0.00
OCATS 6 0 0.00 1.00 1 0 0 0.00
OLTS_ATTRSTORE 6 0 0.00 1.00 1 0 0 0.00
OLTS_BATTRSTORE 6 0 0.00 1.00 1 0 0 0.00
OLTS_CT_STORE 6 0 0.00 1.00 1 0 0 0.00
OLTS_DEFAULT 6 0 0.00 1.00 1 0 0 0.00
OLTS_SVRMGSTORE 6 0 0.00 1.00 1 0 0 0.00
OPMOR 6 0 0.00 1.00 1 0 0 0.00
ORABPEL 6 0 0.00 1.00 1 0 0 0.00
PORTAL 6 0 0.00 1.00 1 0 0 0.00
PORTAL_DOC 6 0 0.00 1.00 1 0 0 0.00
PORTAL_IDX 6 0 0.00 1.00 1 0 0 0.00
PORTAL_LOG 6 0 0.00 1.00 1 0 0 0.00
RE 6 0 0.00 1.00 1 0 0 0.00
UDDISYS_TS 6 0 0.00 1.00 1 0 0 0.00
XDB 6 0 0.00 1.00 1 0 0 0.00
HTMLDB 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_NOLOGGING 3 0 0.00 1.00 1 0 0 0.00
ODM_DATA 2 0 0.00 1.00 1 0 0 0.00
SYNCSERVER 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_TOOLS 1 0 10.00 1.00 1 0 0 0.00
CTXSYS 1 0 10.00 1.00 1 0 0 0.00
NON_APPS_TS_DATA 1 0 10.00 1.00 1 0 0 0.00
OWAPUB 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip1.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip2.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip3.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_OMO /ds2/oracle/VIS/db/apps_st/data/omo1.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_ARCHIVE /ds2/oracle/VIS/db/apps_st/data/archive1.dbf 16 0 3.13 1.00 120 0 29 0.34
APPS_TS_DISCO /ds2/oracle/VIS/db/apps_st/data/disco1.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO /ds2/oracle/VIS/db/apps_st/data/disco2.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO /ds2/oracle/VIS/db/apps_st/data/disco3.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO_OLAP /ds2/oracle/VIS/db/apps_st/data/disco_drake1.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interfac27.d 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface.db 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface1.d 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface10. 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface11. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface12. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface13. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface14. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface15. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface16. 7 0 4.29 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface17. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface18. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface19. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface2.d 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface20. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface21. 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface22. 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface23. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface24. 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface25. 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface26. 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface3.d 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface4.d 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface5.d 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface6.d 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface7.d 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface8.d 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface9.d 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media1.dbf 3 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media2.dbf 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media3.dbf 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media4.dbf 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media5.dbf 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media6.dbf 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media7.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_NOLOGGING /ds2/oracle/VIS/db/apps_st/data/nologging1.dbf 3 0 0.00 1.00 1 0 0 0.00
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues1.dbf 3 0 0.00 1.00 1 0 0 0.00
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues2.dbf 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues3.dbf 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues4.dbf 7 0 0.00 1.00 1 0 0 0.00
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference1.dbf 101 0 1.98 1.16 1 0 889 2.07
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference2.dbf 27 0 0.74 2.41 1 0 74 1.35
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference3.dbf 8 0 3.75 1.00 1 0 72 3.06
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference4.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference5.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary1.dbf 3 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary10.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary11.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary12.dbf 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary13.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary2.dbf 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary3.dbf 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary4.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary5.dbf 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary6.dbf 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary7.dbf 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary8.dbf 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary9.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_TOOLS /ds2/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf 1 0 10.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data1.dbf 34 0 0.29 1.00 8 0 2 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data10.dbf 118 0 0.00 1.00 99 0 21 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data11.dbf 18,000 4 0.08 1.00 2,125 0 5,790 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data12.dbf 11,257 2 0.13 1.00 2,099 0 5,728 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data13.dbf 645 0 0.05 1.00 580 0 438 0.02
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data14.dbf 2 0 0.00 1.00 12 0 5 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data15.dbf 2 0 0.00 1.00 4 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data16.dbf 215 0 0.14 1.00 84 0 38 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data17.dbf 10 0 0.00 1.00 4 0 40 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data18.dbf 35 0 0.00 1.00 5 0 5 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data19.dbf 148 0 0.00 1.07 70 0 83 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data2.dbf 573 0 0.05 1.00 431 0 276 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data20.dbf 4 0 0.00 1.00 4 0 2 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data21.dbf 3,264 1 0.02 1.00 1,786 0 1,298 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data22.dbf 175 0 0.11 1.16 76 0 35 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data23.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data24.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data25.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data26.dbf 5 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data27.dbf 7 0 0.00 1.00 34 0 31,235 0.11
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data28.dbf 24 0 0.00 1.00 2 0 21 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data29.dbf 6 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data3.dbf 35 0 0.00 1.00 3 0 2 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data30.dbf 70 0 0.00 1.00 27 0 30 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data31.dbf 8 0 0.00 1.00 26 0 11 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data32.dbf 6 0 0.00 1.00 35 0 5 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data33.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data34.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data35.dbf 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data36.dbf 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data37.dbf 12 0 0.83 1.00 8 0 23 0.43
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data38.dbf 7 0 0.00 1.00 1 0 16 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data39.dbf 4,534 1 0.04 1.00 1,759 0 1,347 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data4.dbf 81 0 0.00 1.00 26 0 14 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data40.dbf 6 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data41.dbf 11 0 0.00 1.00 1 0 11 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data42.dbf 13 0 0.77 1.00 1 0 21 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data43.dbf 6,297 1 0.03 1.01 1,815 0 1,234 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data44.dbf 36,411 7 0.04 1.00 5,015 1 13,501 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data45.dbf 36,404 7 0.05 1.00 4,981 1 14,113 0.03
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data46.dbf 170 0 0.29 1.00 234 0 114 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data47.dbf 27,152 5 0.07 1.00 2,857 1 6,148 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data48.dbf 36,770 7 0.05 1.00 5,004 1 13,659 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data49.dbf 36,441 7 0.05 1.00 4,968 1 12,920 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data5.dbf 35 0 0.00 1.00 5 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data50.dbf 34,949 7 0.06 1.00 4,538 1 10,585 0.03
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data51.dbf 36,536 7 0.06 1.00 4,961 1 13,613 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data52.dbf 12 0 0.00 1.00 1 0 10 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data53.dbf 36,505 7 0.05 1.00 4,946 1 13,849 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data54.dbf 36,478 7 0.05 1.00 4,899 1 12,968 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data55.dbf 36,187 7 0.05 1.00 4,897 1 13,571 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data56.dbf 36,368 7 0.05 1.00 4,873 1 13,703 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data6.dbf 33 0 0.00 1.00 5 0 1 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data7.dbf 211 0 0.14 1.00 162 0 45 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data8.dbf 3 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data9.dbf 86 0 0.00 1.00 26 0 583 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx1.dbf 4,979 1 0.04 1.00 7,604 2 39,044 0.10
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx10.dbf 5,287 1 0.04 1.00 7,617 2 38,891 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx11.dbf 4,929 1 0.03 1.00 7,833 2 40,646 0.09
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx12.dbf 4,882 1 0.02 1.00 7,796 2 39,264 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx13.dbf 4,918 1 0.04 1.00 7,583 2 40,856 0.64
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx14.dbf 4,921 1 0.02 1.00 7,622 2 39,509 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx15.dbf 5,305 1 0.04 1.00 7,609 2 41,924 0.08
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx16.dbf 5,340 1 0.02 1.00 7,589 2 38,180 0.06
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx17.dbf 5,263 1 0.04 1.00 7,734 2 38,616 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx18.dbf 4,916 1 0.04 1.00 7,739 2 40,399 0.06
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx19.dbf 4,868 1 0.04 1.00 7,618 2 41,462 0.09
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx2.dbf 5,341 1 0.04 1.00 7,736 2 41,163 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx20.dbf 4,803 1 0.03 1.00 7,601 2 41,646 0.06
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx21.dbf 5,137 1 0.03 1.00 7,696 2 41,859 0.09
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx22.dbf 86 0 0.12 1.00 272 0 102 0.20
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx23.dbf 474 0 0.13 1.00 210 0 113 0.09
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx24.dbf 6,611 1 0.04 1.00 7,609 2 40,245 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx25.dbf 43,524 9 0.11 1.00 8,853 2 2,389 0.09
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx26.dbf 43,551 9 0.11 1.00 9,047 2 2,276 0.14
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx27.dbf 13,853 3 0.05 1.00 7,508 2 39,639 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx28.dbf 42,834 9 0.11 1.00 20,271 4 59,027 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx3.dbf 14,534 3 0.15 1.00 1 0 150 0.53
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx4.dbf 4,884 1 0.02 1.00 7,713 2 40,505 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx5.dbf 5,047 1 0.03 1.00 7,704 2 39,808 0.06
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx6.dbf 5,291 1 0.09 1.00 21 0 170 0.29
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx7.dbf 4,974 1 0.04 1.00 7,643 2 41,090 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx8.dbf 5,001 1 0.02 1.00 7,698 2 39,385 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx9.dbf 5,247 1 0.05 1.00 7,606 2 37,535 0.09
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo.dbf 1 0 10.00 1.00 12,941 3 114,822 0.06
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo2.dbf 6 0 0.00 1.00 11,248 2 58,012 0.03
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo3.dbf 7 0 0.00 1.00 10,064 2 64,743 0.03
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo4.dbf 7 0 0.00 1.00 12,002 2 62,921 0.03
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo5.dbf 6 0 0.00 1.00 11,251 2 50,565 0.02
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo6.dbf 6 0 0.00 1.00 27,763 6 214,446 0.03
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo7.dbf 7 0 0.00 1.00 34,168 7 184,270 0.02
B2B_DT /ds2/oracle/VIS/db/apps_st/data/b2b_dt.dbf 7 0 2.86 1.00 1 0 0 0.00
B2B_IDX /ds2/oracle/VIS/db/apps_st/data/b2b_idx.dbf 6 0 0.00 1.00 1 0 0 0.00
B2B_LOB /ds2/oracle/VIS/db/apps_st/data/b2b_lob.dbf 6 0 0.00 1.00 1 0 0 0.00
B2B_RT /ds2/oracle/VIS/db/apps_st/data/b2b_rt.dbf 7 0 0.00 1.00 1 0 0 0.00
BAM /ds2/oracle/VIS/db/apps_st/data/bam.dbf 6 0 0.00 1.00 1 0 0 0.00
CTXSYS /ds2/oracle/VIS/db/apps_st/data/ctx1.dbf 1 0 10.00 1.00 1 0 0 0.00
CWMLITE /ds2/oracle/VIS/db/apps_st/data/cwmlite01.dbf 2 0 0.00 1.00 1 0 0 0.00
CWMLITE /ds2/oracle/VIS/db/apps_st/data/cwmlite02.dbf 6 0 0.00 1.00 1 0 0 0.00
DCM /ds2/oracle/VIS/db/apps_st/data/dcm.dbf 7 0 0.00 1.00 1 0 0 0.00
DCM /ds2/oracle/VIS/db/apps_st/data/dcm1.dbf 6 0 0.00 1.00 1 0 0 0.00
DISCO_PTM5_CACHE /ds2/oracle/VIS/db/apps_st/data/discopltc1.dbf 7 0 0.00 1.00 1 0 0 0.00
DISCO_PTM5_META /ds2/oracle/VIS/db/apps_st/data/discopltm1.dbf 6 0 0.00 1.00 1 0 0 0.00
DSGATEWAY_TAB /ds2/oracle/VIS/db/apps_st/data/oss_sys01.dbf 7 0 0.00 1.00 1 0 0 0.00
GEOR_TBS /ds2/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf 7 0 1.43 1.00 1 0 0 0.00
GEOR_TBS /ds2/oracle/VIS/db/apps_st/data/geor_tbs02.dbf 6 0 0.00 1.00 1 0 0 0.00
HTMLDB /ds2/oracle/VIS/db/apps_st/data/htmldb.dbf 5 0 0.00 1.00 1 0 0 0.00
IAS_META /ds2/oracle/VIS/db/apps_st/data/ias_meta01.dbf 8 0 2.50 1.00 1 0 0 0.00
MTR /ds2/oracle/VIS/db/apps_st/data/opmtr01.dbf 6 0 0.00 1.00 1 0 0 0.00
NOETIX /ds2/oracle/VIS/db/apps_st/data/noetix.dbf 6 0 0.00 1.00 1 0 0 0.00
NON_APPS_TS_DATA /ds2/oracle/VIS/db/apps_st/data/non_apps_data1.dbf 1 0 10.00 1.00 1 0 0 0.00
OCATS /ds2/oracle/VIS/db/apps_st/data/oca.dbf 6 0 0.00 1.00 1 0 0 0.00
ODM_DATA /ds2/oracle/VIS/db/apps_st/data/odm.dbf 2 0 0.00 1.00 1 0 0 0.00
OLTS_ATTRSTORE /ds2/oracle/VIS/db/apps_st/data/attrs1_oid.dbf 6 0 0.00 1.00 1 0 0 0.00
OLTS_BATTRSTORE /ds2/oracle/VIS/db/apps_st/data/battrs1_oid.dbf 6 0 0.00 1.00 1 0 0 0.00
OLTS_CT_STORE /ds2/oracle/VIS/db/apps_st/data/gcats1_oid.dbf 6 0 0.00 1.00 1 0 0 0.00
OLTS_DEFAULT /ds2/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf 6 0 0.00 1.00 1 0 0 0.00
OLTS_SVRMGSTORE /ds2/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf 6 0 0.00 1.00 1 0 0 0.00
OPMOR /ds2/oracle/VIS/db/apps_st/data/opmor01.dbf 6 0 0.00 1.00 1 0 0 0.00
ORABPEL /ds2/oracle/VIS/db/apps_st/data/orabpel.dbf 6 0 0.00 1.00 1 0 0 0.00
OWAPUB /ds2/oracle/VIS/db/apps_st/data/owa1.dbf 1 0 0.00 1.00 1 0 0 0.00
PORTAL /ds2/oracle/VIS/db/apps_st/data/portal.dbf 6 0 0.00 1.00 1 0 0 0.00
PORTAL_DOC /ds2/oracle/VIS/db/apps_st/data/ptldoc.dbf 6 0 0.00 1.00 1 0 0 0.00
PORTAL_IDX /ds2/oracle/VIS/db/apps_st/data/ptlidx.dbf 6 0 0.00 1.00 1 0 0 0.00
PORTAL_LOG /ds2/oracle/VIS/db/apps_st/data/ptllog.dbf 6 0 0.00 1.00 1 0 0 0.00
RE /ds2/oracle/VIS/db/apps_st/data/opre01.dbf 6 0 0.00 1.00 1 0 0 0.00
SYNCSERVER /ds2/oracle/VIS/db/apps_st/data/mobile01.dbf 2 0 0.00 1.00 1 0 0 0.00
SYSAUX /ds2/oracle/VIS/db/apps_st/data/sysaux01.dbf 159 0 1.38 1.00 197 0 0 0.00
SYSAUX /ds2/oracle/VIS/db/apps_st/data/sysaux02.dbf 7 0 0.00 1.00 2 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys1.dbf 19 0 5.26 1.00 125 0 43 5.12
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys10.dbf 7 0 0.00 1.00 30 0 151 0.20
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys2.dbf 11 0 1.82 1.00 46 0 29 0.69
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys3.dbf 4 0 2.50 1.00 30 0 7 4.29
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys4.dbf 3 0 3.33 1.00 34 0 10 7.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys5.dbf 7 0 1.43 1.00 16 0 11 6.36
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys6.dbf 9 0 3.33 1.00 34 0 35 3.14
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys7.dbf 9 0 5.56 1.00 30 0 12 3.33
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys8.dbf 8 0 3.75 1.00 34 0 12 6.67
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys9.dbf 6 0 0.00 1.00 1 0 0 0.00
TEMP1 /ds2/oracle/VIS/db/apps_st/data/temp1_01.dbf 109 0 0.55 15.00 140 0 0  
TEMP2 /ds2/oracle/VIS/db/apps_st/data/temp2_02.dbf 0 0     18 0 0  
UDDISYS_TS /ds2/oracle/VIS/db/apps_st/data/uddisys01.dbf 6 0 0.00 1.00 1 0 0 0.00
WCRSYS_TS /ds2/oracle/VIS/db/apps_st/data/wcrsys01.dbf 7 0 0.00 1.00 1 0 0 0.00
XDB /ds2/oracle/VIS/db/apps_st/data/xdb01.dbf 6 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 1,005,329 100 3,240,799,379 703,387 1,702,011 0 0 1,844,158


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 33 325 1466 147995 37748700 147995 1000000
E 0 33 347 2532 1000000 37748700 17478519 1000000

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 800 0.10 98,950 1.53 4,855,163
D 1,600 0.20 197,900 1.37 4,342,458
D 2,400 0.30 296,850 1.31 4,146,505
D 3,200 0.39 395,800 1.25 3,979,723
D 4,000 0.49 494,750 1.19 3,789,683
D 4,800 0.59 593,700 1.14 3,633,921
D 5,600 0.69 692,650 1.10 3,499,201
D 6,400 0.79 791,600 1.07 3,385,206
D 7,200 0.89 890,550 1.03 3,284,270
D 8,000 0.98 989,500 1.00 3,187,613
D 8,128 1.00 1,005,332 1.00 3,174,173
D 8,800 1.08 1,088,450 0.97 3,072,611
D 9,600 1.18 1,187,400 0.93 2,948,790
D 10,400 1.28 1,286,350 0.91 2,904,108
D 11,200 1.38 1,385,300 0.90 2,844,605
D 12,000 1.48 1,484,250 0.88 2,799,582
D 12,800 1.57 1,583,200 0.88 2,781,724
D 13,600 1.67 1,682,150 0.87 2,756,638
D 14,400 1.77 1,781,100 0.86 2,729,059
D 15,200 1.87 1,880,050 0.85 2,708,366
D 16,000 1.97 1,979,000 0.85 2,684,718

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
99.98 293,122 71

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  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 6,144 5,239 500.69 0.20 0.04 100.00 0.00 629,140
E 6,144 5,242 484.92 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 10,854,892 10,854,892 0 0
64K 128K 5 5 0 0
128K 256K 47 47 0 0
256K 512K 5 5 0 0
512K 1024K 399 399 0 0
1M 2M 249,073 249,073 0 0
2M 4M 4 4 0 0
4M 8M 13 13 0 0
8M 16M 27 21 6 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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
768 0.13 717,592.19 2,783.00 100.00 0
1,536 0.25 717,592.19 172.95 100.00 0
3,072 0.50 717,592.19 172.95 100.00 0
4,608 0.75 717,592.19 172.95 100.00 0
6,144 1.00 717,592.19 172.95 100.00 0
7,373 1.20 717,592.19 0.00 100.00 0
8,602 1.40 717,592.19 0.00 100.00 0
9,830 1.60 717,592.19 0.00 100.00 0
11,059 1.80 717,592.19 0.00 100.00 0
12,288 2.00 717,592.19 0.00 100.00 0
18,432 3.00 717,592.19 0.00 100.00 0
24,576 4.00 717,592.19 0.00 100.00 0
36,864 6.00 717,592.19 0.00 100.00 0
49,152 8.00 717,592.19 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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
352 0.17 223 10,695 5,731,674 1.00 2,493 3.08 324,334,367
560 0.28 347 19,121 5,733,358 1.00 809 1.00 324,336,123
768 0.38 347 19,121 5,733,358 1.00 809 1.00 324,336,123
976 0.48 347 19,121 5,733,358 1.00 809 1.00 324,336,123
1,184 0.59 347 19,121 5,733,358 1.00 809 1.00 324,336,123
1,392 0.69 347 19,121 5,733,358 1.00 809 1.00 324,336,123
1,600 0.79 347 19,121 5,733,358 1.00 809 1.00 324,336,123
1,808 0.90 347 19,121 5,733,358 1.00 809 1.00 324,336,123
2,016 1.00 347 19,121 5,733,358 1.00 809 1.00 324,336,123
2,224 1.10 347 19,121 5,733,358 1.00 809 1.00 324,336,123
2,432 1.21 347 19,121 5,733,358 1.00 809 1.00 324,336,123
2,640 1.31 347 19,121 5,733,358 1.00 809 1.00 324,336,123
2,848 1.41 347 19,121 5,733,358 1.00 809 1.00 324,336,123
3,056 1.52 347 19,121 5,733,358 1.00 809 1.00 324,336,123
3,264 1.62 347 19,121 5,733,358 1.00 809 1.00 324,336,123
3,472 1.72 347 19,121 5,733,358 1.00 809 1.00 324,336,123
3,680 1.83 347 19,121 5,733,358 1.00 809 1.00 324,336,123
3,888 1.93 347 19,121 5,733,358 1.00 809 1.00 324,336,123
4,096 2.03 347 19,121 5,733,358 1.00 809 1.00 324,336,123

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
2,560 0.25 85,180 4,674,499
5,120 0.50 84,768 4,079,355
7,680 0.75 84,397 3,535,314
10,240 1.00 84,145 3,174,101
12,800 1.25 84,036 3,013,491
15,360 1.50 83,968 2,915,412
17,920 1.75 83,951 2,890,019
20,480 2.00 83,951 2,890,019

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)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 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
32 0.67 8 179 19 1.00 809 1.00 522
48 1.00 8 179 19 1.00 809 1.00 522
64 1.33 8 179 19 1.00 809 1.00 522
80 1.67 8 179 19 1.00 809 1.00 522
96 2.00 8 179 19 1.00 809 1.00 522
112 2.33 8 179 19 1.00 809 1.00 522

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 1,094,200 110 0
undo block 689,537 19 0
undo header 60,223 6 0
1st level bmb 133 0 0
file header block 10 0 2

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
UL-User-defined 76,388 75,196 1,192 51,077 2,966 58.07
TX-Transaction (index contention) 100,517 100,516 0 100,441 49 0.49
TX-Transaction (row lock contention) 4,246 4,208 38 4,188 2 0.56
SQ-Sequence Cache 15,467 15,467 0 5,704 1 0.18
CU-Cursor 501 501 0 5 0 30.00
HW-Segment High Water Mark 1,995 1,995 0 57 0 0.35
TX-Transaction (allocate ITL entry) 15 15 0 15 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

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
18 883.92 584,925 1,921 17 420.416666666666666666666666666666666667/482.45 0/0 0/0/0/43/196152/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

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
26-Mar 23:05 145 246 0 3 475 0/0 0/0/0/0/0/0
26-Mar 22:55 44 211 0 2 466 0/0 0/0/0/0/0/0
26-Mar 22:45 107,400 98,647 33 16 456 0/0 0/0/0/2/17408/0
26-Mar 22:35 71,358 118,613 292 13 462 0/0 0/0/0/3/15568/0
26-Mar 22:25 87,797 24,699 1,921 16 461 0/0 0/0/0/2/9728/0
26-Mar 22:15 96,903 27,264 1,319 15 436 0/0 0/0/0/1/5120/0
26-Mar 22:05 94,892 27,249 1,476 16 447 0/0 0/0/0/1/9344/0
26-Mar 21:55 241,341 183,246 813 17 420 0/0 0/0/0/23/94360/0
26-Mar 21:45 184,042 104,750 265 17 482 0/0 0/0/0/11/44624/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 3,844 0.00   0 0  
AWR Alerted Metric Element list 30,923 0.00   0 0  
Consistent RBA 216,730 0.02 0.16 0 0  
FOB s.o list latch 9,114 0.05 0.00 0 0  
In memory undo latch 725,516,359 1.54 0.01 17 361,013 0.00
JOX SGA heap latch 30 0.00   0 0  
JS queue state obj latch 29,820 0.00   0 0  
JS slv state obj latch 157 0.00   0 0  
KMG MMAN ready and startup request latch 1,657 0.00   0 0  
KTF sga latch 11 0.00   0 1,593 0.00
KWQMN job cache list latch 46 0.00   0 0  
KWQP Prop Status 604 0.00   0 0  
MQL Tracking Latch 0     0 99 0.00
Memory Management Latch 0     0 1,657 0.00
OS process 936 0.00   0 0  
OS process allocation 2,282 0.00   0 0  
OS process: request allocation 405 0.00   0 0  
PL/SQL warning settings 6,337,966 0.00   0 0  
SGA IO buffer pool latch 6,251 0.00   0 10,739 0.07
SQL memory manager latch 1 0.00   0 1,650 0.00
SQL memory manager workarea list latch 15,089,162 0.03 0.00 0 0  
Shared B-Tree 3,167 0.00   0 0  
active checkpoint queue latch 320,976 0.49 0.00 0 0  
active service list 10,087 0.03 0.00 0 1,889 0.00
begin backup scn array 15 0.00   0 0  
bq:time manger info latch 180 0.00   0 0  
bufq statistics 5 0.00   0 0  
cache buffer handles 235,198,750 4.34 0.00 2 0  
cache buffers chains 6,437,685,594 4.67 0.04 763 10,486,890 20.96
cache buffers lru chain 3,988,369 0.72 0.01 0 25,282,752 0.98
cache table scan latch 0     0 35 0.00
channel handle pool latch 639 0.00   0 0  
channel operations parent latch 27,923 0.08 0.00 0 0  
checkpoint queue latch 5,964,547 0.01 0.03 0 1,687,827 0.02
client/application info 1,960 0.05 0.00 0 0  
commit callback allocation 86 0.00   0 0  
compile environment latch 376,389 0.00   0 0  
dml lock allocation 2,932,934 0.29 0.00 0 0  
dummy allocation 536 0.19 0.00 0 0  
enqueue hash chains 4,853,780 0.23 0.01 0 3,406 0.23
enqueue sob latch 1 0.00   0 0  
enqueues 832,055 0.21 0.02 0 0  
event group latch 203 0.00   0 0  
file cache latch 1,915 0.00   0 0  
global KZLD latch for mem in SGA 148 0.00   0 0  
global ctx hash table latch 923 0.00   0 0  
hash table column usage latch 555 0.00   0 56,229 0.00
hash table modification latch 89 0.00   0 0  
job workq parent latch 0     0 130 0.00
job_queue_processes parameter latch 146 0.00   0 0  
kks stats 1,055 0.00   0 0  
ksuosstats global area 333 0.00   0 0  
ktm global data 255 0.00   0 0  
kwqbsn:qsga 2,982 0.00   0 0  
lgwr LWN SCN 218,242 0.35 0.00 0 0  
library cache 438,627,563 1.24 0.00 2 0  
library cache lock 215,736,861 1.75 0.00 0 0  
library cache lock allocation 12,948 0.07 0.00 0 0  
library cache pin 191,046,229 1.34 0.00 1 0  
library cache pin allocation 4,663 0.00   0 0  
list of block allocation 321,362 0.01 0.00 0 0  
loader state object freelist 362 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 462 0.00   0 0  
messages 1,599,927 0.20 0.00 0 0  
mostly latch-free SCN 232,295 5.85 0.02 0 0  
multiblock read objects 82 0.00   0 0  
ncodef allocation latch 372 0.00   0 0  
object queue header heap 965,345 0.00   0 8,041 0.00
object queue header operation 10,215,559 0.04 0.01 0 0  
object stats modification 397 0.25 0.00 0 0  
parallel query alloc buffer 660 0.00   0 0  
parameter list 690 0.00   0 0  
parameter table allocation management 280 1.07 0.00 0 0  
post/wait queue 306,384 0.19 0.01 0 151,433 0.02
process allocation 405 0.49 1.00 0 203 0.00
process group creation 405 0.00   0 0  
qmn state object latch 1 0.00   0 0  
qmn task queue latch 5,239 2.42 0.10 0 0  
redo allocation 1,522,678 2.05 0.02 0 60,868,885 1.41
redo copy 0     0 60,918,531 0.01
redo writing 1,073,882 0.21 0.00 0 0  
resmgr group change latch 807 0.00   0 0  
resmgr:actses active list 659 0.15 1.00 0 0  
resmgr:actses change group 414 0.00   0 0  
resmgr:free threads list 534 0.19 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 45,760,081 1.78 0.00 0 0  
rules engine aggregate statistics 2 0.00   0 0  
rules engine rule set statistics 104 0.00   0 0  
sequence cache 29,276,966 1.95 0.00 0 0  
session allocation 22,368,675 3.23 0.00 0 0  
session idle bit 46,860,503 0.05 0.00 0 0  
session state list latch 1,139 0.61 0.43 0 0  
session switching 371 0.00   0 0  
session timer 1,890 0.00   0 0  
shared pool 859,043 0.07 0.02 0 0  
shared pool sim alloc 12 0.00   0 0  
shared pool simulator 222,146 0.00   0 0  
simulator hash latch 217,507,767 0.02 0.00 0 0  
simulator lru latch 217,226,934 4.15 0.00 4 101,205 0.42
slave class create 2 0.00   0 0  
sort extent pool 2,072 0.10 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temporary table state object allocation 228 0.00   0 0  
threshold alerts latch 1,155 0.00   0 0  
transaction allocation 118,681 0.00 0.00 0 0  
transaction branch allocation 372 0.00   0 0  
undo global data 819,459,561 0.35 0.00 1 423 0.71
user lock 632 1.42 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 6,437,685,594 300,352,784 13,355,634 288,387,728 0 0 0
In memory undo latch 725,516,359 11,159,968 121,687 11,058,870 0 0 0
cache buffer handles 235,198,750 10,197,580 7,508 10,191,348 0 0 0
simulator lru latch 217,226,934 9,012,024 20,318 8,995,615 0 0 0
library cache 438,627,563 5,418,308 10,457 5,409,957 0 0 0
library cache lock 215,736,861 3,779,823 1,638 3,778,449 0 0 0
undo global data 819,459,561 2,845,932 5,952 2,841,356 0 0 0
library cache pin 191,046,229 2,555,840 5,048 2,551,755 0 0 0
row cache objects 45,760,081 813,704 470 813,335 0 0 0
session allocation 22,368,675 721,890 1,501 720,681 0 0 0
sequence cache 29,276,966 569,983 588 569,521 0 0 0
simulator hash latch 217,507,767 39,471 91 39,401 0 0 0
redo allocation 1,522,678 31,253 677 30,687 0 0 0
cache buffers lru chain 3,988,369 28,659 262 28,402 0 0 0
session idle bit 46,860,503 21,115 44 21,079 0 0 0
mostly latch-free SCN 232,295 13,584 226 13,386 0 0 0
enqueue hash chains 4,853,780 11,180 86 11,100 0 0 0
dml lock allocation 2,932,934 8,454 26 8,432 0 0 0
SQL memory manager workarea list latch 15,089,162 4,001 8 3,994 0 0 0
object queue header operation 10,215,559 3,729 46 3,687 0 0 0
messages 1,599,927 3,237 8 3,229 0 0 0
redo writing 1,073,882 2,289 2 2,287 0 0 0
enqueues 832,055 1,774 31 1,743 0 0 0
checkpoint queue latch 5,964,547 878 26 854 0 0 0
lgwr LWN SCN 218,242 756 1 755 0 0 0
shared pool 859,043 624 12 614 0 0 0
post/wait queue 306,384 594 4 590 0 0 0
qmn task queue latch 5,239 127 13 114 0 0 0
Consistent RBA 216,730 38 6 32 0 0 0
session state list latch 1,139 7 3 4 0 0 0
process allocation 405 2 2 0 0 0 0
resmgr:actses active list 659 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 58,317 25,889
In memory undo latch kturbk 0 35,801 61,163
In memory undo latch kticmt: child 0 13,156 89
In memory undo latch ktichg: child 0 9,852 32,809
In memory undo latch ktiTxnPoolFree 0 4,280 61
In memory undo latch ktbgfc 0 257 1,675
In memory undo latch ktiBRacquire 0 20 0
In memory undo latch ktuswr 0 1 0
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 5 7
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 2 1
SQL memory manager workarea list latch qesmmIRefreshBound 0 1 0
active service list ksws_event: ksws event 0 2 2
cache buffer handles kcbzgs 0 5,172 4,932
cache buffer handles kcbzfs 0 2,336 2,575
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 17,572,549 17,444,899
cache buffers chains kcbchg: kslbegin: call CR func 0 11,027,200 15,564,913
cache buffers chains kcbgtcr: fast path 0 2,827,900 212,266
cache buffers chains kcbgtcr: kslbegin excl 0 1,122,238 395,097
cache buffers chains kcbrls: kslbegin 0 314,123 469,038
cache buffers chains kcbget: pin buffer 0 305,345 156,573
cache buffers chains kcbgcur: kslbegin 0 106,484 53,956
cache buffers chains kcbzgb: scan from tail. nowait 0 99,157 0
cache buffers chains kcbzwb 0 96,632 59,318
cache buffers chains kcbcge 0 72,523 126,011
cache buffers chains kcbnlc 0 8,310 10,789
cache buffers chains kcb_is_private 0 2,522 13,099
cache buffers chains kcb_pre_apply: kcbhq61 0 2,303 16,093
cache buffers chains kcbget: exchange rls 0 2,250 3,519
cache buffers chains kcbget: exchange 0 2,248 4,301
cache buffers chains kcb_post_apply: kcbhq62 0 1,850 3,138
cache buffers chains kcb_post_apply: kcbhq63 0 1,264 3,489
cache buffers chains kcbesc: escalate 0 228 119
cache buffers chains kcbbxsv 0 189 176
cache buffers chains kcbso1: set no access 0 138 126
cache buffers chains kcbnew: new latch again 0 98 1
cache buffers chains kcbgtcr: kslbegin shared 0 56 38
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 17 0
cache buffers chains kcbbic1 0 15 4
cache buffers chains kcbzib: finish free bufs 0 12 12
cache buffers chains kcbgtcr 0 7 22
cache buffers chains kcbbic2 0 2 1
cache buffers chains kcbzib: exchange rls 0 1 0
cache buffers lru chain kcbzgws 0 126 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 65 0
cache buffers lru chain kcbbxsv: move to being written 0 64 195
cache buffers lru chain kcbzgb: posted for free bufs 0 3 29
cache buffers lru chain kcbbic2 0 2 37
cache buffers lru chain kcbzswcu 0 2 1
channel operations parent latch ksrchdelete() 0 1 0
checkpoint queue latch kcbkubc 0 12 8
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 11 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 3 25
dml lock allocation ktaiam 0 21 22
dml lock allocation ktaidm 0 5 4
enqueue hash chains ksqrcl 0 41 21
enqueue hash chains ksqgtl3 0 34 28
enqueue hash chains ksqcmi: get hash chain latch after wait 0 10 37
enqueue hash chains ksqcnl 0 1 0
enqueues ksqdel 0 25 28
enqueues ksqgel: create enqueue 0 3 0
enqueues ksqies 0 3 3
event range base latch No latch 0 13 13
lgwr LWN SCN kcs023 0 69 0
library cache kglpnp: child 0 4,334 5,249
library cache kglpndl: child: after processing 0 2,982 240
library cache kglpndl: child: before processing 0 1,371 2,974
library cache kglobpn: child: 0 708 917
library cache kglLockCursor 0 634 1,025
library cache kglScanDependency 0 76 0
library cache kgldte: child 0 0 10 24
library cache kglhdgn: child: 0 3 10
library cache kgldti: 2child 0 2 0
library cache kglati 0 1 0
library cache kglpin 0 1 0
library cache lock kgllkdl: child: cleanup 0 905 940
library cache lock kgllkal: child: multiinstance 0 733 698
library cache lock kgllkdl: child: no lock handle 0 335 18
library cache pin kglpnp: child 0 2,713 2,840
library cache pin kglpndl 0 2,207 1,973
library cache pin kglpnal: child: alloc space 0 128 235
messages ksarcv 0 3 1
messages ksarcv: after wait 0 3 4
messages ksaamb: after wakeup 0 2 5
mostly latch-free SCN kcslcu3 0 157 227
mostly latch-free SCN kcs01 0 3 6
mostly latch-free SCN kcsnew_scn_rba 0 3 0
mostly latch-free SCN kcs024 0 1 0
object queue header operation kcbo_switch_mq_bg 0 21 7
object queue header operation kcbw_link_q 0 16 9
object queue header operation kcbw_unlink_q 0 10 12
object queue header operation kcbo_switch_cq 0 5 6
object queue header operation kcbo_swap_buf 0 3 0
object queue header operation kcbo_switch_q_bg 0 2 1
object queue header operation kcbo_swap_buf_bg 0 1 23
post/wait queue ksliwat:remove 0 3 4
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 2 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 547 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 84 546
redo allocation kcrfw_redo_write: before write 0 24 90
redo allocation kcrfw_redo_gen: redo allocation 2 0 18 0
redo allocation kcrfw_redo_write: more space 0 4 41
redo writing kcrfw_post: rba scn pair 0 1 0
redo writing kcrfwcr 0 1 2
resmgr:actses active list kgskchclass 0 1 1
row cache objects kqreqd: reget 0 279 1
row cache objects kqrpre: find obj 0 163 433
row cache objects kqreqd 0 28 36
sequence cache kdnssd 0 339 18
sequence cache kdnnxt: cached seq 0 187 22
sequence cache kdnss 0 62 548
session allocation ksuprc 0 975 1,019
session allocation ksudlc 0 485 455
session allocation ksuxds: not user session 0 25 16
session allocation ksuxds: KSUSFCLC not set 0 9 3
session allocation ksucri 0 7 7
session idle bit ksupuc: set busy 0 32 12
session idle bit ksupuc: clear busy 0 21 40
session idle bit ksuxds 0 1 2
session state list latch kpseqd 0 3 0
shared pool kghalo 0 5 5
shared pool kghfre 0 4 1
shared pool kghupr1 0 3 4
simulator hash latch kcbsacc: lookup dba 0 85 90
simulator hash latch kcbs_get_or_extract_simbufseq 0 6 1
simulator lru latch kcbs_simulate: simulate set 0 19,983 20,172
simulator lru latch kcbs_simbufseq 0 329 145
simulator lru latch kcbs_lookup_setid 0 5 0
undo global data kturimugur: child 0 4,797 2,460
undo global data ktudba: KSLBEGIN 0 1,141 3,471
undo global data ktudnx:child 0 10 21
undo global data ktucof: at start 0 2 0
undo global data ktufrbs: child 0 1 2
undo global data ktusmupst: KSLBEGIN 0 1 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 303,508,064 9.30
HR APPS_TS_TX_IDX PAY_PAYROLL_ACTIONS_PK   INDEX 294,207,552 9.01
HR APPS_TS_TX_IDX PAY_RUN_RESULTS_N50   INDEX 188,607,584 5.78
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 175,561,712 5.38
HR APPS_TS_TX_DATA PAY_PAYROLL_ACTIONS   TABLE 146,625,120 4.49

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
HR APPS_TS_TX_DATA PAY_ACTION_INFORMATION   TABLE 208,468 29.53
HR APPS_TS_TX_DATA PAY_LATEST_BALANCES   TABLE 45,944 6.51
HR APPS_TS_TX_DATA PAY_RUN_BALANCES   TABLE 38,138 5.40
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N5   INDEX 37,992 5.38
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N2   INDEX 26,307 3.73

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 19,927 17.95
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 12,921 11.64
HR APPS_TS_TX_DATA PAY_PAYROLL_ACTIONS   TABLE 7,814 7.04
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 7,709 6.94
HR APPS_TS_TX_IDX PAY_COSTS_FK2   INDEX 7,564 6.81

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N2   INDEX 15 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 218,594 20.22
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 90,115 8.34
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_PK   INDEX 88,679 8.20
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 65,014 6.01
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 63,455 5.87

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 91 0.00 0   2 10
dc_global_oids 15,156 0.00 0   0 77
dc_histogram_data 1,187 0.00 0   0 396
dc_histogram_defs 8,074 0.19 0   0 37,184
dc_object_grants 38 0.00 0   0 158
dc_object_ids 91,382 0.00 0   0 6,585
dc_objects 2,092 0.05 0   0 7,672
dc_profiles 166 0.00 0   0 1
dc_rollback_segments 5,503 0.00 0   2 81
dc_segments 16,012 0.01 0   80 7,105
dc_sequences 9,756 0.00 0   9,756 33
dc_tablespace_quotas 61 0.00 0   0 5
dc_tablespaces 7,571,333 0.00 0   0 83
dc_usernames 1,769 0.00 0   0 46
dc_users 7,521,324 0.00 0   0 77
kqlsubheap_object 32 0.00 0   0 4
outstanding_alerts 510 0.00 0   2 54


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 3,624 0.00 41,353,913 -0.00 0 0
INDEX 8 0.00 43 0.00 0 0
JAVA DATA 2 0.00 0   0 0
PIPE 1,479 0.00 1,480 0.00 0 0
SQL AREA 11 45.45 337,290,715 -0.01 447 0
TABLE/PROCEDURE 4,602 0.00 51,175,074 -0.01 0 0
TRIGGER 276 0.00 5,407,833 -0.00 0 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  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 372.28   2.22 2.98 26 31 168 168
  Freeable 83.94 0.00 1.08 1.79 10   78 78
  SQL 26.39 14.01 0.16 0.24 2 17 162 160
  PL/SQL 14.46 5.76 0.09 0.07 1 1 168 168
  JAVA 3.71 3.70 1.24 0.36 2 3 3 3
E Other 359.06   2.12 2.96 24 31 169 169
  Freeable 82.44 0.00 1.03 1.60 10   80 80
  SQL 25.42 13.46 0.16 0.25 2 17 163 159
  PL/SQL 14.37 5.34 0.09 0.08 1 1 169 169
  JAVA 3.71 3.70 0.93 0.69 2 3 4 3

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 8,522,825,728  
Fixed Size 2,090,528  
Redo Buffers 31,461,376  
Variable Size 2,181,040,608  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 38.45 38.45 0.00
java joxlod exec hp 9.25 9.25 0.00
large PX msg pool 0.49 0.49 0.00
large free memory 15.51 15.51 0.00
shared ASH buffers 22.50 22.50 0.00
shared CCursor   21.38  
shared KGLS heap 41.16 41.16 0.00
shared KQR M PO 25.06 25.07 0.03
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 1,562.40 1,539.85 -1.44
shared library cache 35.34 35.74 1.15
shared private strands 22.17 22.17 0.00
shared sql area 48.13 67.77 40.82
streams KGH: NO ACCESS 15.98 15.98 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 8,128.00 8,128.00 0.00
  fixed_sga 1.99 1.99 0.00
  log_buffer 30.00 30.00 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 274,742 0 0
QMON Coordinator 129,134 0 0

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue Schema and Name Incoming per second Outgoing per second Spilled per second Diff Pct Spilled
APPLSYS.WF_CONTROL 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber Name Incoming per second Outgoing per second Spilled per second
WFBESCL_20532 0 0 0
WFBESCL_20533 0 0 0
WFBESCL_20534 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
SYS.ALERT_QUE_R 2 0 0 0 0
APPLSYS.WF_DEFERRED_R 0 0 0 0 0
APPLSYS.WF_NOTIFICATION_OUT_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_system_trig_enabled TRUE   
_trace_files_public TRUE   
aq_tm_processes 1   
background_dump_dest /ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/bdump   
compatible 10.2.0.3   
core_dump_dest /ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_file_multiblock_read_count 8   
db_files 512   
db_name VIS   
dml_locks 10000   
filesystemio_options asynch   
ifile /ds2/oracle/VIS/db/tech_st/10.2.0/dbs/VIS_r12db_ifile.ora   
job_queue_processes 2   
log_buffer 30507008   
log_checkpoint_interval 1000000   
log_checkpoint_timeout 3600   
log_checkpoints_to_alert TRUE   
max_dump_file_size 20480   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 600   
optimizer_secure_view_merging FALSE   
parallel_max_servers 16   
parallel_min_servers 0   
pga_aggregate_target 6442450944   
plsql_code_type INTERPRETED   
plsql_native_library_dir /ds2/oracle/VIS/db/tech_st/10.2.0/plsql/nativelib   
plsql_native_library_subdir_count 149   
plsql_optimize_level 2   
processes 800   
session_cached_cursors 500   
sessions 1600   
sga_target 10737418240   
shared_pool_size 2097152000   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 36000   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/udump   
utl_file_dir /usr/tmp, /ds2/oracle/VIS/db/tech_st/10.2.0/appsutil/outbound/VIS_r12db, /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report