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: 1072 09-Sep-09 21:23:10 61 26.8
End Snap: 1074 09-Sep-09 22:16:21 63 28.9
Elapsed:   53.18 (mins)    
DB Time:   492.08 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 7,456M 7,328M Std Block Size: 8K
Shared Pool Size: 2,624M 2,752M Log Buffer: 63,492K

Load Profile

  Per Second Per Transaction
Redo size: 5,617,856.82 50,971.90
Logical reads: 1,099,860.22 9,979.24
Block changes: 38,605.92 350.28
Physical reads: 256.56 2.33
Physical writes: 431.92 3.92
User calls: 7,276.06 66.02
Parses: 5,768.76 52.34
Hard parses: 0.27 0.00
Sorts: 5,422.75 49.20
Logons: 0.07 0.00
Executes: 66,541.62 603.75
Transactions: 110.21  

% Blocks changed per Read: 3.51 Recursive Call %: 95.09
Rollback per transaction %: 0.01 Rows per Sort: 1.80

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 100.75 Soft Parse %: 100.00
Execute to Parse %: 91.33 Latch Hit %: 97.62
Parse CPU to Parse Elapsd %: 71.43 % Non-Parse CPU: 99.15

Shared Pool Statistics

  Begin End
Memory Usage %: 80.46 78.22
% SQL with executions>1: 76.90 85.38
% Memory for SQL w/exec>1: 73.37 83.76

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   26,287   89.0  
enq: UL - contention 53,478 1,825 34 6.2 Application
log file sync 154,006 843 5 2.9 Commit
db file sequential read 805,403 263 0 .9 User I/O
cursor: pin S wait on X 8,298 71 9 .2 Concurrency

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 28,389.53 96.15
DB CPU 26,286.78 89.03
PL/SQL execution elapsed time 10,745.98 36.40
parse time elapsed 355.51 1.20
repeated bind elapsed time 14.57 0.05
inbound PL/SQL rpc elapsed time 10.77 0.04
hard parse elapsed time 8.09 0.03
sequence load elapsed time 3.16 0.01
PL/SQL compilation elapsed time 3.01 0.01
connection management call elapsed time 0.37 0.00
Java execution elapsed time 0.22 0.00
hard parse (sharing criteria) elapsed time 0.04 0.00
hard parse (bind mismatch) elapsed time 0.03 0.00
DB time 29,524.95  
background elapsed time 1,157.92  
background cpu time 110.77  

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 58,919 0.13 1,827 31 0.17
Commit 154,006 0.00 843 5 0.44
Concurrency 3,813,736 0.18 308 0 10.84
User I/O 821,416 0.00 291 0 2.34
Other 190,488 78.99 20 0 0.54
Configuration 9,953 0.06 16 2 0.03
Network 22,515,831 0.00 15 0 64.02
System I/O 300,746 0.00 11 0 0.86

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 53,478 0.14 1,825 34 0.15
log file sync 154,006 0.00 843 5 0.44
db file sequential read 805,403 0.00 263 0 2.29
cursor: pin S wait on X 8,298 81.54 71 9 0.02
enq: TX - index contention 136,530 0.00 69 1 0.39
buffer busy waits 1,881,693 0.00 66 0 5.35
library cache load lock 1,527 0.00 61 40 0.00
latch: cache buffers chains 1,712,470 0.00 34 0 4.87
read by other session 12,150 0.00 23 2 0.03
enq: TX - allocate ITL entry 22 22.73 14 653 0.00
SQL*Net message to client 21,791,008 0.00 12 0 61.96
wait list latch free 925 0.00 10 10 0.00
control file parallel write 1,529 0.00 8 5 0.00
kksfbc child completion 229 68.56 8 34 0.00
db file scattered read 2,430 0.00 6 3 0.01
latch: In memory undo latch 62,010 0.00 4 0 0.18
SQL*Net more data from client 722,714 0.00 3 0 2.06
enq: TX - row lock contention 5,213 0.00 3 1 0.01
log file parallel write 188,561 0.00 2 0 0.54
buffer deadlock 153,467 97.94 1 0 0.44
enq: SQ - contention 9,880 0.00 1 0 0.03
db file parallel write 109,977 0.00 1 0 0.31
os thread startup 39 0.00 1 18 0.00
latch: library cache 7,587 0.00 1 0 0.02
latch free 8,432 0.00 1 0 0.02
log file switch completion 26 0.00 0 18 0.00
latch: undo global data 5,068 0.00 0 0 0.01
latch: library cache pin 2,592 0.00 0 0 0.01
latch: cache buffer handles 2,694 0.00 0 0 0.01
LGWR wait for redo copy 6,122 0.00 0 0 0.02
latch: shared pool 120 0.00 0 0 0.00
latch: redo allocation 350 0.00 0 0 0.00
latch: session allocation 504 0.00 0 0 0.00
rdbms ipc reply 57 0.00 0 1 0.00
control file sequential read 671 0.00 0 0 0.00
latch: library cache lock 528 0.00 0 0 0.00
SQL*Net more data to client 2,109 0.00 0 0 0.01
cursor: pin S 12,474 0.00 0 0 0.04
SQL*Net break/reset to client 228 0.00 0 0 0.00
log file single write 4 0.00 0 2 0.00
latch: cache buffers lru chain 29 0.00 0 0 0.00
latch: object queue header operation 49 0.00 0 0 0.00
latch: enqueue hash chains 78 0.00 0 0 0.00
latch: row cache objects 78 0.00 0 0 0.00
log file sequential read 4 0.00 0 1 0.00
latch: redo writing 8 0.00 0 0 0.00
enq: HW - contention 15 0.00 0 0 0.00
direct path read 998 0.00 0 0 0.00
cursor: mutex S 137 0.00 0 0 0.00
latch: checkpoint queue latch 6 0.00 0 0 0.00
cursor: mutex X 126 0.00 0 0 0.00
latch: messages 4 0.00 0 0 0.00
direct path write temp 109 0.00 0 0 0.00
direct path read temp 109 0.00 0 0 0.00
direct path write 217 0.00 0 0 0.00
row cache lock 1 0.00 0 0 0.00
undo segment extension 2 50.00 0 0 0.00
SQL*Net message from client 21,791,006 0.00 76,635 4 61.96
Streams AQ: qmn slave idle wait 2,087 0.00 9,333 4472 0.01
Streams AQ: waiting for time management or cleanup tasks 1 100.00 3,180 3179906 0.00
Streams AQ: qmn coordinator idle wait 1,385 35.09 3,111 2246 0.00
PL/SQL lock timer 800 98.50 3,078 3848 0.00
PX Idle Wait 1,215 100.25 2,374 1954 0.00
jobq slave wait 388 98.45 1,131 2915 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 1,529 0.00 8 5 0.00
db file scattered read 2,364 0.00 6 2 0.01
db file sequential read 1,848 0.00 3 2 0.01
log file parallel write 188,561 0.00 2 0 0.54
db file parallel write 109,977 0.00 1 0 0.31
os thread startup 39 0.00 1 18 0.00
events in waitclass Other 6,324 0.00 0 0 0.02
control file sequential read 483 0.00 0 0 0.00
log file single write 4 0.00 0 2 0.00
log file sequential read 4 0.00 0 1 0.00
latch: redo writing 8 0.00 0 0 0.00
direct path read 996 0.00 0 0 0.00
latch: cache buffers chains 1 0.00 0 0 0.00
direct path write 211 0.00 0 0 0.00
buffer busy waits 2 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
rdbms ipc message 146,012 7.44 28,807 197 0.42
Streams AQ: qmn slave idle wait 2,087 0.00 9,333 4472 0.01
Streams AQ: waiting for time management or cleanup tasks 1 100.00 3,180 3179906 0.00
pmon timer 1,142 96.50 3,113 2726 0.00
Streams AQ: qmn coordinator idle wait 1,385 35.09 3,111 2246 0.00
smon timer 219 2.28 3,108 14191 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,953,378
IDLE_TIME 2,151,217
IOWAIT_TIME 98,896
NICE_TIME 2
SYS_TIME 250,735
USER_TIME 2,665,295
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 4,289,780
NUM_CPUS 16
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 29,522.40 26,285.50 804,253 3,509,420,915
SYS$USERS 2.50 1.20 405 33,611
SYS$BACKGROUND 0.00 0.00 14,043 86,139

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 814683 27919 3813693 30730 0 0 22515420 1517
SYS$USERS 614 71 0 0 0 0 5 0
SYS$BACKGROUND 6122 1153 43 72 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,788 19,581 249,865 0.08 67.02 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
19,690 19,485 249,793 0.08 66.69 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
2,305 1,031 70 32.93 7.81 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
1,282 1,259 249,890 0.01 4.34 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
1,116 1,116 3,746,056 0.00 3.78 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
934 935 3,747,952 0.00 3.16 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
835 833 1,499,555 0.00 2.83 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
797 797 2,748,910 0.00 2.70 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
627 624 28,445,065 0.00 2.12 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
486 463 2,749,600 0.00 1.65 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
473 473 1,124,563 0.00 1.60 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
468 424 12,500 0.04 1.59 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
409 48 12,514 0.03 1.39 73rvua18a9ytx PYUSLV declare ret number ; BEGIN hr_...
396 388 249,786 0.00 1.34 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
373 373 10,734,982 0.00 1.26 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
372 372 13,603,339 0.00 1.26 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
371 370 4,247,635 0.00 1.25 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
350 332 249,955 0.00 1.18 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
349 345 249,987 0.00 1.18 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
343 334 249,483 0.00 1.16 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
312 304 249,967 0.00 1.06 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...

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,581 19,788 249,865 0.08 67.02 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
19,485 19,690 249,793 0.08 66.69 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,259 1,282 249,890 0.01 4.34 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
1,116 1,116 3,746,056 0.00 3.78 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,031 2,305 70 14.74 7.81 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
935 934 3,747,952 0.00 3.16 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
833 835 1,499,555 0.00 2.83 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
797 797 2,748,910 0.00 2.70 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
624 627 28,445,065 0.00 2.12 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
473 473 1,124,563 0.00 1.60 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
463 486 2,749,600 0.00 1.65 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
424 468 12,500 0.03 1.59 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
388 396 249,786 0.00 1.34 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
373 373 10,734,982 0.00 1.26 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
372 372 13,603,339 0.00 1.26 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
370 371 4,247,635 0.00 1.25 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
345 349 249,987 0.00 1.18 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
334 343 249,483 0.00 1.16 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
332 350 249,955 0.00 1.18 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
304 312 249,967 0.00 1.06 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
48 409 12,514 0.00 1.39 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,498,535,252 249,865 9,999.54 71.19 19581.40 19788.06 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
2,497,969,832 249,793 10,000.16 71.18 19484.81 19689.64 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
259,877,018 1,499,555 173.30 7.40 832.90 834.64 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
250,768,830 3,746,056 66.94 7.15 1116.37 1115.70 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
213,452,316 70 3,049,318.80 6.08 1031.47 2305.33 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
197,832,560 3,747,952 52.78 5.64 935.07 934.16 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
182,948,514 2,748,910 66.55 5.21 797.39 796.65 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
157,342,625 4,247,635 37.04 4.48 370.42 370.51 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
147,743,366 1,124,563 131.38 4.21 472.72 472.76 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
138,853,722 249,890 555.66 3.96 1259.13 1282.17 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
131,111,068 1,998,843 65.59 3.74 242.62 242.62 5ts0t88sz97xs PYUSLV SELECT PDB.DEFINED_BALANCE_ID ...
122,167,359 13,603,339 8.98 3.48 371.57 372.19 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
117,740,270 10,734,982 10.97 3.35 372.83 372.73 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
84,954,852 28,445,065 2.99 2.42 624.30 627.12 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
83,549,913 249,987 334.22 2.38 344.66 348.86 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
65,396,762 249,952 261.64 1.86 175.52 175.56 02dvcwb36048p PYUSLV UPDATE PAY_ACTION_INFORMATION ...
61,987,278 249,967 247.98 1.77 303.58 311.74 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
56,532,281 2,749,600 20.56 1.61 463.11 486.17 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
55,106,037 249,697 220.69 1.57 233.65 235.06 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS...
54,338,788 13,553,028 4.01 1.55 241.68 241.83 9wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_...
49,112,285 249,483 196.86 1.40 334.10 343.25 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
47,194,320 3,119,588 15.13 1.34 187.59 188.59 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
41,004,423 499,548 82.08 1.17 128.57 131.33 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
37,450,015 3,121,823 12.00 1.07 197.70 197.66 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
36,650,991 249,786 146.73 1.04 388.46 395.98 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
36,347,032 12,500 2,907.76 1.04 424.05 468.01 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...

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
482,914 249,793 1.93 58.99 19484.81 19689.64 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
482,837 249,865 1.93 58.98 19581.40 19788.06 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
91,388 2,749,600 0.03 11.16 463.11 486.17 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
73,630 249,812 0.29 8.99 206.77 212.93 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC...
51,503 499,548 0.10 6.29 128.57 131.33 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
39,847 249,987 0.16 4.87 344.66 348.86 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
37,064 3,119,588 0.01 4.53 187.59 188.59 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
36,685 249,697 0.15 4.48 233.65 235.06 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS...
34,901 249,875 0.14 4.26 108.39 109.41 fkzcr3njd0yss PYUSLV select /*+ ORDERED INDEX(P...
22,252 1,499,555 0.01 2.72 832.90 834.64 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
21,638 27,768 0.78 2.64 12.56 12.67 33ngu6crv1c9k PYUSLV SELECT GROSS_PAY , NET_PAY FR...
19,948 498,775 0.04 2.44 118.80 120.24 b0j6srzdfp5jf PYUSLV select /*+ ORDERED USE_NL(AA...
15,281 70 218.30 1.87 1031.47 2305.33 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
12,147 249,483 0.05 1.48 334.10 343.25 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
10,136 4,247,635 0.00 1.24 370.42 370.51 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...

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,445,065 43,899,963 1.54 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
14,554,931 997,472 0.07 0.00 0.00 77d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
13,603,339 13,604,298 1.00 0.00 0.00 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
13,553,028 13,573,666 1.00 0.00 0.00 9wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_...
10,734,982 10,706,960 1.00 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
4,247,635 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
3,747,952 3,744,191 1.00 0.00 0.00 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,746,056 3,736,754 1.00 0.00 0.00 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,121,823 3,122,096 1.00 0.00 0.00 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
3,119,588 0 0.00 0.00 0.00 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
2,749,600 2,749,498 1.00 0.00 0.00 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
2,748,910 2,746,007 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,733,446 3,746,056 20.28 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,725,207 3,747,952 20.24 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
2,732,735 2,748,910 14.85 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,492,506 1,499,555 8.11 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
1,118,216 1,124,563 6.07 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
747,711 749,847 4.06 fqgs7vbu8htby PYUSLV SELECT fnd_number.number_to_ca...
498,485 499,548 2.71 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
496,370 499,686 2.70 83kbt99vg4svq PYUSLV begin ...
496,081 499,676 2.69 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
249,576 249,865 1.36 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
249,542 249,793 1.36 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
249,440 249,890 1.36 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
249,155 249,834 1.35 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim...
249,098 249,911 1.35 97mt0g20bcfc3 PYUSLV begin ...
248,744 249,765 1.35 36z3h9rgkd8aa PYUSLV begin ...
248,335 249,588 1.35 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')
02dvcwb36048p UPDATE PAY_ACTION_INFORMATION SET ACTION_INFORMATION_ID = :B1 , OBJECT_VERSION_NUMBER = :B32 , ACTION_INFORMATION1 = :B31 , ACTION_INFORMATION2 = :B30 , ACTION_INFORMATION3 = :B29 , ACTION_INFORMATION4 = :B28 , ACTION_INFORMATION5 = :B27 , ACTION_INFORMATION6 = :B26 , ACTION_INFORMATION7 = :B25 , ACTION_INFORMATION8 = :B24 , ACTION_INFORMATION9 = :B23 , ACTION_INFORMATION10 = :B22 , ACTION_INFORMATION11 = :B21 , ACTION_INFORMATION12 = :B20 , ACTION_INFORMATION13 = :B19 , ACTION_INFORMATION14 = :B18 , ACTION_INFORMATION15 = :B17 , ACTION_INFORMATION16 = :B16 , ACTION_INFORMATION17 = :B15 , ACTION_INFORMATION18 = :B14 , ACTION_INFORMATION19 = :B13 , ACTION_INFORMATION20 = :B12 , ACTION_INFORMATION21 = :B11 , ACTION_INFORMATION22 = :B10 , ACTION_INFORMATION23 = :B9 , ACTION_INFORMATION24 = :B8 , ACTION_INFORMATION25 = :B7 , ACTION_INFORMATION26 = :B6 , ACTION_INFORMATION27 = :B5 , ACTION_INFORMATION28 = :B4 , ACTION_INFORMATION29 = :B3 , ACTION_INFORMATION30 = :B2 WHERE ACTION_INFORMATION_ID = :B1
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;
33ngu6crv1c9k SELECT GROSS_PAY , NET_PAY FROM PAY_AC_EMP_SUM_ACTION_INFO_V WHERE ACTION_CONTEXT_ID = :b1 AND ACTION_INFORMATION_CATEGORY = 'AC SUMMARY CURRENT'
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;
5ts0t88sz97xs SELECT PDB.DEFINED_BALANCE_ID FROM PAY_DEFINED_BALANCES PDB, PAY_BALANCE_DIMENSIONS PBD WHERE PDB.BALANCE_TYPE_ID = :B3 AND PBD.DATABASE_ITEM_SUFFIX = :B2 AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID AND ((PBD.LEGISLATION_CODE = :B1 AND PBD.BUSINESS_GROUP_ID IS NULL) OR (PBD.LEGISLATION_CODE IS NULL AND PBD.BUSINESS_GROUP_ID IS NOT NULL))
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
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 ;
77d28bpwm9svg SELECT PBV.RUN_BALANCE_STATUS, PBV.BALANCE_LOAD_DATE FROM PAY_BALANCE_VALIDATION PBV WHERE PBV.DEFINED_BALANCE_ID = :B2 AND PBV.BUSINESS_GROUP_ID = :B1
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
bm8gwn43tn8hd SELECT PLB.LATEST_BALANCE_ID, PLB.ASSIGNMENT_ACTION_ID, PLB.VALUE, PLB.EXPIRY_DATE, ACT.ACTION_SEQUENCE CURRENT_ACTION_SEQ, OWN_ACT.ACTION_SEQUENCE OWNER_ACTION_SEQ, PACT.EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE, PLB.EXPIRED_ASSIGNMENT_ACTION_ID, PLB.EXPIRED_VALUE, PLB.EXPIRED_DATE, PLB.PREV_ASSIGNMENT_ACTION_ID, PLB.PREV_BALANCE_VALUE, PLB.PREV_EXPIRY_DATE, PLB.TAX_UNIT_ID, PLB.JURISDICTION_CODE, PLB.ORIGINAL_ENTRY_ID, PLB.SOURCE_ID, PLB.SOURCE_TEXT, PLB.SOURCE_TEXT2, PLB.SOURCE_NUMBER, PLB.TAX_GROUP, PLB.PAYROLL_ID, PLB.LOCAL_UNIT_ID, PLB.ORGANIZATION_ID, PLB.SOURCE_NUMBER2 FROM PAY_LATEST_BALANCES PLB , PER_ALL_ASSIGNMENTS_F ASSIGN , PAY_ASSIGNMENT_ACTIONS ACT , PAY_PAYROLL_ACTIONS PACT , PAY_ASSIGNMENT_ACTIONS OWN_ACT WHERE PLB.DEFINED_BALANCE_ID = :B15 AND ACT.ASSIGNMENT_ACTION_ID = :B14 AND ASSIGN.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND EXISTS (SELECT '' FROM PAY_OBJECT_GROUPS POG WHERE POG.SOURCE_ID (+) = ACT.ASSIGNMENT_ID AND POG.SOURCE_TYPE (+) = 'PAF' AND NVL(PLB.PROCESS_GROUP_ID, NVL(POG.PARENT_OBJECT_GROUP_ID, -1)) = NVL(POG.PARENT_OBJECT_GROUP_ID, -1) ) AND PLB.PERSON_ID = ASSIGN.PERSON_ID AND NVL(PLB.ASSIGNMENT_ID, ACT.ASSIGNMENT_ID) = ACT.ASSIGNMENT_ID AND PACT.PAYROLL_ACTION_ID = ACT.PAYROLL_ACTION_ID AND PACT.EFFECTIVE_DATE BETWEEN ASSIGN.EFFECTIVE_START_DATE AND ASSIGN.EFFECTIVE_END_DATE AND OWN_ACT.ASSIGNMENT_ACTION_ID = PLB.ASSIGNMENT_ACTION_ID AND NVL(PLB.TAX_UNIT_ID, NVL(:B13 , -1)) = NVL(:B13 , -1) AND NVL(SUBSTR(NVL(PLB.JUR ISDICTION_CODE, NVL(:B12 , -1)), 1, :B11 ), -1) = NVL( SUBSTR(NVL(:B12 , -1), 1, :B11 ), -1) AND NVL(PLB.ORIGINAL_ENTRY_ID, NVL(:B10 , -1)) = NVL(:B10 , -1) AND NVL(PLB.SOURCE_ID, NVL(:B9 , -1)) = NVL(:B9 , -1) AND NVL(PLB.SOURCE_TEXT, NVL(:B8 , -1)) = NVL(:B8 , -1) AND NVL(PLB.SOURCE_TEXT2, NVL(:B7 , -1)) = NVL(:B7 , -1) AND NVL(PLB.SOURCE_NUMBER, NVL(:B6 , -1)) = NVL(:B6 , -1) AND NVL(PLB.TAX_GROUP, NVL(:B5 , -1)) = NVL(:B5 , -1) AND NVL(PLB.PAYROLL_ID, NVL(:B4 , -1)) = NVL(:B4 , -1) AND NVL(PLB.LOCAL_UNIT_ID, NVL(:B3 , -1)) = NVL(:B3 , -1) AND NVL(PLB.ORGANIZATION_ID, NVL(:B2 , -1)) = NVL(:B2 , -1) AND NVL(PLB.SOURCE_NUMBER2, NVL(:B1 , -1)) = NVL(:B1 , -1) ORDER BY PLB.LATEST_BALANCE_ID
cr74qtm56vcq6 BEGIN PAY_US_NACHA_TAPE.RUN_FORMULA; END;
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' )
fkzcr3njd0yss select /*+ ORDERED INDEX(PLB PAY_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PLB DEFBAL ACT PACT) +*/ PLB.defined_balance_id , DEFBAL.balance_dimension_id , to_char(PLB.value) , to_char(PLB.expiry_date, :b0) , PLB.latest_balance_id , PLB.rowid , to_char(PLB.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , to_char(PLB.expired_assignment_action_id) , to_char(PLB.expired_value) , to_char(PLB.expired_date, :b0) , to_char(PLB.prev_assignment_action_id) , to_char(PLB.prev_balance_value) , to_char(PLB.prev_expiry_date, :b0) , PLB.person_id , PLB.assignment_id , PLB.tax_unit_id , PLB.jurisdiction_code , PLB.source_id , PLB.source_text , PLB.source_number , PLB.source_text2 , PLB.tax_group , to_char(PLB.original_entry_id) , to_char(PLB.payroll_id) , PLB.local_unit_id , PLB.organization_id , PLB.source_number2 from pay_latest_balances PLB , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT where ((((((PLB.assignment_id=:b4 or PLB.assignment_id is null ) and (PLB.process_group_id=:b5 or PLB.process_group_id is null )) and PLB.person_id=:b6) and ACT.assignment_action_id=PLB.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PLB.defined_balance_id) order by 7, 2, 1, 4 desc
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
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,671,847 837.33 7.60
CPU used when call started 2,671,748 837.30 7.60
CR blocks created 13,065,905 4,094.74 37.15
Cached Commit SCN referenced 3,097 0.97 0.01
Commit SCN cached 3 0.00 0.00
DB time 3,454,847 1,082.72 9.82
DBWR checkpoint buffers written 1,036,170 324.73 2.95
DBWR checkpoints 2 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 transaction table writes 190 0.06 0.00
DBWR undo block writes 774,535 242.73 2.20
DFO trees parallelized 0 0.00 0.00
DML statements parallelized 0 0.00 0.00
IMU CR rollbacks 263,717,890 82,646.95 749.87
IMU Flushes 192,239 60.25 0.55
IMU Redo allocation size 3,116,931,476 976,819.83 8,862.88
IMU commits 155,686 48.79 0.44
IMU contention 90,913 28.49 0.26
IMU ktichg flush 119 0.04 0.00
IMU pool not allocated 3,875 1.21 0.01
IMU recursive-transaction flush 7,127 2.23 0.02
IMU undo allocation size 5,021,508,232 1,573,698.00 14,278.47
IMU- failed to get a private strand 3,875 1.21 0.01
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded 1 to 25 pct 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 downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations downgraded to serial 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,790,634 6,829.00 61.96
active txn count during cleanout 60,348,001 18,912.55 171.60
application wait time 182,748 57.27 0.52
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 11,253 3.53 0.03
branch node splits 351 0.11 0.00
buffer is not pinned count 1,747,499,287 547,651.42 4,968.95
buffer is pinned count 732,283,690 229,491.48 2,082.22
bytes received via SQL*Net from client 5,737,201,121 1,797,990.07 16,313.51
bytes sent via SQL*Net to client 3,207,848,599 1,005,312.49 9,121.39
calls to get snapshot scn: kcmgss 214,265,682 67,149.04 609.26
calls to kcmgas 14,513,353 4,548.36 41.27
calls to kcmgcs 613,771 192.35 1.75
change write time 27,543 8.63 0.08
cleanout - number of ktugct calls 13,239,825 4,149.25 37.65
cleanouts and rollbacks - consistent read gets 12,373,848 3,877.86 35.18
cleanouts only - consistent read gets 92,793 29.08 0.26
cluster key scan block gets 14,289 4.48 0.04
cluster key scans 1,520 0.48 0.00
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 19,704 6.18 0.06
commit batch/immediate requested 19,704 6.18 0.06
commit cleanout failures: block lost 238 0.07 0.00
commit cleanout failures: buffer being written 66 0.02 0.00
commit cleanout failures: callback failure 174,593 54.72 0.50
commit cleanout failures: cannot pin 59,458 18.63 0.17
commit cleanouts 5,725,381 1,794.29 16.28
commit cleanouts successfully completed 5,491,026 1,720.84 15.61
commit immediate performed 19,704 6.18 0.06
commit immediate requested 19,704 6.18 0.06
commit txn count during cleanout 966,935 303.03 2.75
concurrency wait time 30,802 9.65 0.09
consistent changes 773,446,985 242,391.71 2,199.27
consistent gets 3,354,564,913 1,051,292.13 9,538.58
consistent gets - examination 1,975,172,133 619,002.16 5,616.33
consistent gets direct 4 0.00 0.00
consistent gets from cache 3,354,564,909 1,051,292.13 9,538.58
current blocks converted for CR 0 0.00 0.00
cursor authentications 796 0.25 0.00
data blocks consistent reads - undo records applied 772,730,409 242,167.14 2,197.23
db block changes 123,187,503 38,605.92 350.28
db block gets 154,975,775 48,568.09 440.67
db block gets direct 92 0.03 0.00
db block gets from cache 154,975,683 48,568.06 440.67
deferred (CURRENT) block cleanout applications 557,620 174.75 1.59
dirty buffers inspected 206,866 64.83 0.59
enqueue conversions 75,726 23.73 0.22
enqueue releases 2,240,825 702.26 6.37
enqueue requests 2,241,357 702.42 6.37
enqueue timeouts 530 0.17 0.00
enqueue waits 168,370 52.77 0.48
exchange deadlocks 153,538 48.12 0.44
execute count 212,327,458 66,541.62 603.75
failed probes on index block reclamation 156 0.05 0.00
free buffer inspected 3,615,659 1,133.12 10.28
free buffer requested 15,032,443 4,711.04 42.74
global undo segment hints helped 0 0.00 0.00
heap block compress 644,495 201.98 1.83
hot buffers moved to head of LRU 384,565 120.52 1.09
immediate (CR) block cleanout applications 12,466,669 3,906.95 35.45
immediate (CURRENT) block cleanout applications 930,879 291.73 2.65
index crx upgrade (found) 1,415,220 443.52 4.02
index crx upgrade (positioned) 32,592,255 10,214.14 92.67
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 429,962,311 134,746.53 1,222.58
index scans kdiixs1 418,683,060 131,211.71 1,190.51
leaf node 90-10 splits 39,020 12.23 0.11
leaf node splits 102,939 32.26 0.29
lob reads 14 0.00 0.00
lob writes 114 0.04 0.00
lob writes unaligned 114 0.04 0.00
logons cumulative 217 0.07 0.00
messages received 299,557 93.88 0.85
messages sent 299,557 93.88 0.85
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,320,333,968 413,781.44 3,754.32
opened cursors cumulative 16,907,363 5,298.62 48.08
parse count (failures) 0 0.00 0.00
parse count (hard) 852 0.27 0.00
parse count (total) 18,407,510 5,768.76 52.34
parse time cpu 22,261 6.98 0.06
parse time elapsed 31,163 9.77 0.09
physical read IO requests 808,469 253.37 2.30
physical read bytes 6,706,339,840 2,101,709.91 19,069.22
physical read total IO requests 809,566 253.71 2.30
physical read total bytes 6,720,792,576 2,106,239.27 19,110.32
physical read total multi block requests 2,539 0.80 0.01
physical reads 818,645 256.56 2.33
physical reads cache 816,010 255.73 2.32
physical reads cache prefetch 8,650 2.71 0.02
physical reads direct 2,635 0.83 0.01
physical reads direct (lob) 2 0.00 0.00
physical reads direct temporary tablespace 1,635 0.51 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 295,639 92.65 0.84
physical write bytes 11,290,419,200 3,538,321.42 32,103.88
physical write total IO requests 572,238 179.33 1.63
physical write total bytes 29,925,641,728 9,378,441.78 85,092.42
physical write total multi block requests 414,063 129.76 1.18
physical writes 1,378,225 431.92 3.92
physical writes direct 1,938 0.61 0.01
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 1,635 0.51 0.00
physical writes from cache 1,376,287 431.32 3.91
physical writes non checkpoint 1,029,883 322.76 2.93
pinned buffers inspected 1,664 0.52 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 3,059 0.96 0.01
queries parallelized 0 0.00 0.00
recursive aborts on index block reclamation 17 0.01 0.00
recursive calls 449,575,869 140,893.26 1,278.35
recursive cpu usage 2,389,029 748.70 6.79
redo blocks written 36,347,987 11,391.15 103.35
redo buffer allocation retries 11 0.00 0.00
redo entries 62,435,437 19,566.74 177.53
redo log space requests 26 0.01 0.00
redo log space wait time 52 0.02 0.00
redo ordering marks 696,738 218.35 1.98
redo size 17,926,002,464 5,617,856.82 50,971.90
redo subscn max counts 1,095,981 343.47 3.12
redo synch time 87,052 27.28 0.25
redo synch writes 113,098 35.44 0.32
redo wastage 72,066,388 22,584.99 204.92
redo write time 72,910 22.85 0.21
redo writer latching time 13 0.00 0.00
redo writes 188,561 59.09 0.54
rollback changes - undo records applied 83,740 26.24 0.24
rollbacks only - consistent read gets 800,981 251.02 2.28
rows fetched via callback 272,532,076 85,409.24 774.93
session connect time 0 0.00 0.00
session cursor cache hits 18,382,985 5,761.07 52.27
session logical reads 3,509,540,688 1,099,860.22 9,979.24
session pga memory 6,609,672 2,071.42 18.79
session pga memory max 14,473,992 4,536.03 41.16
session uga memory 47,256,669,160 14,809,838.47 134,372.53
session uga memory max 620,854,504 194,570.52 1,765.38
shared hash latch upgrades - no wait 34,470,736 10,802.84 98.02
shared hash latch upgrades - wait 1,495,817 468.78 4.25
sorts (disk) 0 0.00 0.00
sorts (memory) 17,303,439 5,422.75 49.20
sorts (rows) 31,132,481 9,756.65 88.52
sql area evicted 0 0.00 0.00
sql area purged 0 0.00 0.00
summed dirty queue length 582,743 182.63 1.66
switch current to new buffer 255,597 80.10 0.73
table fetch by rowid 1,048,335,338 328,539.39 2,980.90
table fetch continued row 2,866 0.90 0.01
table scan blocks gotten 82,034,346 25,708.87 233.26
table scan rows gotten 309,076,596 96,861.98 878.85
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) 6,519,465 2,043.14 18.54
total number of times SMON posted 214 0.07 0.00
transaction rollbacks 19,704 6.18 0.06
transaction tables consistent read rollbacks 1 0.00 0.00
transaction tables consistent reads - undo records applied 34 0.01 0.00
undo change vector size 6,277,994,556 1,967,470.14 17,851.24
user I/O wait time 29,136 9.13 0.08
user calls 23,217,167 7,276.06 66.02
user commits 351,666 110.21 1.00
user rollbacks 18 0.01 0.00
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 6 0.00 0.00
workarea executions - optimal 10,673,438 3,344.96 30.35
write clones created in background 0 0.00 0.00
write clones created in foreground 291 0.09 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 74,050 81,359
opened cursors current 1,635 1,818
workarea memory allocated 237 268
logons current 61 63

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 2 2.26

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 518,904 163 0.26 1.00 41,822 13 212,802 0.08
APPS_TS_TX_IDX 279,728 88 0.39 1.00 69,332 22 803,617 0.08
APPS_UNDOTS1 40 0 0.00 1.00 183,101 57 875,289 0.01
SYSTEM 6,546 2 2.95 2.27 303 0 188 0.05
APPS_TS_SEED 1,672 1 2.33 1.05 6 0 1,473 2.82
SYSAUX 919 0 3.94 1.01 686 0 0 0.00
TEMP1 84 0 0.71 15.00 124 0 0 0.00
APPS_TS_INTERFACE 157 0 1.66 1.00 29 0 0 0.00
APPS_TS_ARCHIVE 42 0 5.00 1.00 93 0 35 0.57
TEMP2 25 0 0.00 15.00 68 0 0 0.00
APPS_TS_SUMMARY 67 0 2.39 1.00 13 0 0 0.00
APPS_TS_MEDIA 36 0 1.67 1.00 7 0 0 0.00
APPS_CALCLIP 20 0 2.00 1.00 4 0 0 0.00
APPS_TS_QUEUES 19 0 0.00 1.00 4 0 0 0.00
DCM 13 0 1.54 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
B2B_DT 7 0 4.29 1.00 1 0 0 0.00
B2B_RT 7 0 1.43 1.00 1 0 0 0.00
DISCO_PTM5_CACHE 7 0 1.43 1.00 1 0 0 0.00
DSGATEWAY_TAB 7 0 1.43 1.00 1 0 0 0.00
WCRSYS_TS 7 0 1.43 1.00 1 0 0 0.00
APPS_OMO 6 0 1.67 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 1.67 1.00 1 0 0 0.00
B2B_LOB 6 0 1.67 1.00 1 0 0 0.00
BAM 6 0 1.67 1.00 1 0 0 0.00
DISCO_PTM5_META 6 0 1.67 1.00 1 0 0 0.00
IAS_META 6 0 1.67 1.00 1 0 0 0.00
MTR 6 0 1.67 1.00 1 0 0 0.00
NOETIX 6 0 0.00 1.00 1 0 0 0.00
OCATS 6 0 1.67 1.00 1 0 0 0.00
OLTS_ATTRSTORE 6 0 1.67 1.00 1 0 0 0.00
OLTS_BATTRSTORE 6 0 1.67 1.00 1 0 0 0.00
OLTS_CT_STORE 6 0 1.67 1.00 1 0 0 0.00
OLTS_DEFAULT 6 0 1.67 1.00 1 0 0 0.00
OLTS_SVRMGSTORE 6 0 1.67 1.00 1 0 0 0.00
OPMOR 6 0 1.67 1.00 1 0 0 0.00
ORABPEL 6 0 1.67 1.00 1 0 0 0.00
PORTAL 6 0 1.67 1.00 1 0 0 0.00
PORTAL_DOC 6 0 1.67 1.00 1 0 0 0.00
PORTAL_IDX 6 0 1.67 1.00 1 0 0 0.00
PORTAL_LOG 6 0 1.67 1.00 1 0 0 0.00
RE 6 0 1.67 1.00 1 0 0 0.00
UDDISYS_TS 6 0 1.67 1.00 1 0 0 0.00
XDB 6 0 0.00 1.00 1 0 0 0.00
HTMLDB 5 0 2.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 0.00 1.00 1 0 0 0.00
CTXSYS 1 0 0.00 1.00 1 0 0 0.00
NON_APPS_TS_DATA 1 0 0.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 2.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip1.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip2.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip3.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_OMO /ds2/oracle/VIS/db/apps_st/data/omo1.dbf 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_ARCHIVE /ds2/oracle/VIS/db/apps_st/data/archive1.dbf 42 0 5.00 1.00 93 0 35 0.57
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 2.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface11. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface12. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface13. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface14. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface15. 6 0 1.67 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 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface18. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface19. 6 0 1.67 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 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface21. 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface22. 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface23. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface24. 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface25. 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface26. 7 0 1.43 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface3.d 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface4.d 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface5.d 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface6.d 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface7.d 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface8.d 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface9.d 7 0 1.43 1.00 2 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 2.50 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media3.dbf 4 0 2.50 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 1.43 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media7.dbf 5 0 2.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 1,048 0 2.41 1.03 2 0 1,245 2.88
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference2.dbf 547 0 2.14 1.10 1 0 136 1.18
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference3.dbf 63 0 2.38 1.00 1 0 92 4.46
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference4.dbf 13 0 3.08 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 17 0 3.53 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary11.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary12.dbf 8 0 2.50 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary13.dbf 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary2.dbf 4 0 2.50 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary3.dbf 4 0 2.50 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary4.dbf 2 0 5.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 2.50 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 2.50 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary9.dbf 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_TOOLS /ds2/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf 1 0 0.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.00 1.00 4 0 2 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data10.dbf 117 0 0.09 1.00 24 0 157 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data11.dbf 21,260 7 0.07 1.00 1,638 1 6,134 0.10
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data12.dbf 14,485 5 0.04 1.00 1,697 1 6,770 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data13.dbf 678 0 0.06 1.00 156 0 389 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data14.dbf 3 0 3.33 1.00 4 0 13 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 212 0 0.00 1.00 35 0 147 0.20
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data17.dbf 12 0 0.00 1.00 9 0 101 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data18.dbf 35 0 0.00 1.00 4 0 1 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data19.dbf 161 0 0.50 1.08 17 0 224 1.70
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data2.dbf 587 0 0.07 1.00 93 0 414 0.10
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data20.dbf 4 0 2.50 1.00 4 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data21.dbf 3,927 1 0.04 1.00 716 0 1,539 0.04
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data22.dbf 185 0 1.19 1.17 15 0 277 1.16
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data23.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data24.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data25.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data26.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data27.dbf 7 0 2.86 1.00 10 0 8,382 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data28.dbf 26 0 3.08 1.00 1 0 64 7.50
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data29.dbf 6 0 1.67 1.00 5 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data3.dbf 35 0 0.00 1.00 7 0 3 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data30.dbf 70 0 0.29 1.00 11 0 53 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data31.dbf 7 0 1.43 1.00 5 0 26 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data32.dbf 9 0 1.11 1.00 8 0 54 2.41
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data33.dbf 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data34.dbf 6 0 1.67 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 1.67 1.00 4 0 140 0.86
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data38.dbf 7 0 2.86 1.00 1 0 42 0.48
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data39.dbf 5,928 2 0.04 1.00 787 0 1,942 0.16
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data4.dbf 83 0 0.00 1.00 13 0 48 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data40.dbf 9 0 1.11 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data41.dbf 24 0 2.92 1.38 1 0 105 1.14
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data42.dbf 17 0 1.76 1.59 1 0 143 1.75
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data43.dbf 9,220 3 0.04 1.01 839 0 2,288 0.26
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data44.dbf 43,165 14 0.18 1.00 3,408 1 18,019 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data45.dbf 43,213 14 0.24 1.00 3,505 1 17,133 0.09
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data46.dbf 169 0 0.53 1.07 85 0 314 0.45
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data47.dbf 31,029 10 0.15 1.00 2,066 1 7,641 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data48.dbf 43,430 14 0.28 1.00 3,324 1 17,490 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data49.dbf 43,155 14 0.17 1.00 3,412 1 17,739 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data5.dbf 35 0 0.00 1.00 8 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data50.dbf 41,647 13 0.30 1.00 3,217 1 14,649 0.11
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data51.dbf 43,271 14 0.39 1.00 3,408 1 19,420 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data52.dbf 12 0 2.50 1.00 1 0 25 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data53.dbf 43,078 14 0.37 1.00 3,261 1 18,130 0.02
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data54.dbf 43,126 14 0.37 1.00 3,381 1 16,906 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data55.dbf 43,014 13 0.36 1.00 3,261 1 17,270 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data56.dbf 43,008 13 0.24 1.00 3,274 1 18,358 0.05
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data6.dbf 33 0 0.30 1.00 5 0 1 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data7.dbf 220 0 0.73 1.00 70 0 181 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 88 0 0.23 1.00 13 0 68 0.15
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx1.dbf 5,642 2 0.78 1.00 2,353 1 33,948 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx10.dbf 6,035 2 0.90 1.00 2,361 1 36,076 0.10
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx11.dbf 5,596 2 0.10 1.00 2,408 1 35,627 0.04
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx12.dbf 5,684 2 0.39 1.00 2,374 1 36,279 0.06
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx13.dbf 5,543 2 0.68 1.00 2,379 1 34,889 0.03
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx14.dbf 5,605 2 0.75 1.00 2,341 1 34,531 0.04
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx15.dbf 5,962 2 0.12 1.00 2,365 1 32,262 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx16.dbf 6,073 2 0.85 1.00 2,347 1 35,276 0.06
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx17.dbf 6,001 2 0.27 1.00 2,375 1 35,314 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx18.dbf 5,632 2 0.47 1.00 2,425 1 36,081 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx19.dbf 5,547 2 0.82 1.00 2,314 1 36,809 0.08
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx2.dbf 5,950 2 0.24 1.00 2,349 1 33,018 0.44
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx20.dbf 5,671 2 0.44 1.00 2,310 1 36,567 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx21.dbf 5,727 2 0.81 1.00 2,299 1 36,932 0.10
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx22.dbf 111 0 1.44 1.00 76 0 572 1.24
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx23.dbf 471 0 0.36 1.00 87 0 147 1.36
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx24.dbf 6,711 2 0.07 1.00 2,340 1 36,063 0.13
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx25.dbf 42,764 13 0.33 1.00 5,318 2 1,336 0.18
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx26.dbf 42,973 13 0.24 1.00 5,364 2 1,204 0.15
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx27.dbf 13,654 4 0.32 1.00 2,359 1 37,096 0.04
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx28.dbf 43,858 14 0.39 1.00 8,812 3 59,157 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx3.dbf 15,632 5 0.03 1.00 1 0 251 1.51
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx4.dbf 5,554 2 0.66 1.00 2,371 1 34,475 0.04
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx5.dbf 5,666 2 0.67 1.00 2,368 1 34,215 0.04
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx6.dbf 4,425 1 0.03 1.00 17 0 471 1.42
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx7.dbf 5,581 2 0.76 1.00 2,401 1 35,105 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx8.dbf 5,716 2 0.70 1.00 2,426 1 34,411 0.07
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx9.dbf 5,944 2 0.34 1.00 2,392 1 35,505 0.03
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo.dbf 2 0 0.00 1.00 26,020 8 231,614 0.01
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo2.dbf 6 0 0.00 1.00 27,057 8 96,930 0.01
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo3.dbf 7 0 0.00 1.00 26,346 8 100,682 0.02
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo4.dbf 7 0 0.00 1.00 27,309 9 94,225 0.01
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo5.dbf 6 0 0.00 1.00 24,847 8 106,555 0.01
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo6.dbf 6 0 0.00 1.00 20,862 7 102,221 0.01
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo7.dbf 6 0 0.00 1.00 30,660 10 143,062 0.01
B2B_DT /ds2/oracle/VIS/db/apps_st/data/b2b_dt.dbf 7 0 4.29 1.00 1 0 0 0.00
B2B_IDX /ds2/oracle/VIS/db/apps_st/data/b2b_idx.dbf 6 0 1.67 1.00 1 0 0 0.00
B2B_LOB /ds2/oracle/VIS/db/apps_st/data/b2b_lob.dbf 6 0 1.67 1.00 1 0 0 0.00
B2B_RT /ds2/oracle/VIS/db/apps_st/data/b2b_rt.dbf 7 0 1.43 1.00 1 0 0 0.00
BAM /ds2/oracle/VIS/db/apps_st/data/bam.dbf 6 0 1.67 1.00 1 0 0 0.00
CTXSYS /ds2/oracle/VIS/db/apps_st/data/ctx1.dbf 1 0 0.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 1.43 1.00 1 0 0 0.00
DCM /ds2/oracle/VIS/db/apps_st/data/dcm1.dbf 6 0 1.67 1.00 1 0 0 0.00
DISCO_PTM5_CACHE /ds2/oracle/VIS/db/apps_st/data/discopltc1.dbf 7 0 1.43 1.00 1 0 0 0.00
DISCO_PTM5_META /ds2/oracle/VIS/db/apps_st/data/discopltm1.dbf 6 0 1.67 1.00 1 0 0 0.00
DSGATEWAY_TAB /ds2/oracle/VIS/db/apps_st/data/oss_sys01.dbf 7 0 1.43 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 2.00 1.00 1 0 0 0.00
IAS_META /ds2/oracle/VIS/db/apps_st/data/ias_meta01.dbf 6 0 1.67 1.00 1 0 0 0.00
MTR /ds2/oracle/VIS/db/apps_st/data/opmtr01.dbf 6 0 1.67 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 0.00 1.00 1 0 0 0.00
OCATS /ds2/oracle/VIS/db/apps_st/data/oca.dbf 6 0 1.67 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 1.67 1.00 1 0 0 0.00
OLTS_BATTRSTORE /ds2/oracle/VIS/db/apps_st/data/battrs1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_CT_STORE /ds2/oracle/VIS/db/apps_st/data/gcats1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_DEFAULT /ds2/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_SVRMGSTORE /ds2/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OPMOR /ds2/oracle/VIS/db/apps_st/data/opmor01.dbf 6 0 1.67 1.00 1 0 0 0.00
ORABPEL /ds2/oracle/VIS/db/apps_st/data/orabpel.dbf 6 0 1.67 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 1.67 1.00 1 0 0 0.00
PORTAL_DOC /ds2/oracle/VIS/db/apps_st/data/ptldoc.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL_IDX /ds2/oracle/VIS/db/apps_st/data/ptlidx.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL_LOG /ds2/oracle/VIS/db/apps_st/data/ptllog.dbf 6 0 1.67 1.00 1 0 0 0.00
RE /ds2/oracle/VIS/db/apps_st/data/opre01.dbf 6 0 1.67 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 783 0 4.36 1.01 563 0 0 0.00
SYSAUX /ds2/oracle/VIS/db/apps_st/data/sysaux02.dbf 136 0 1.54 1.00 123 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys1.dbf 1,241 0 2.96 2.11 105 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys10.dbf 32 0 4.38 1.00 15 0 180 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys2.dbf 796 0 2.71 2.37 22 0 1 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys3.dbf 828 0 2.98 2.37 15 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys4.dbf 682 0 2.46 2.50 15 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys5.dbf 577 0 2.65 2.78 14 0 1 10.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys6.dbf 1,122 0 2.91 2.31 33 0 6 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys7.dbf 1,004 0 3.32 2.10 43 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys8.dbf 191 0 3.93 1.59 40 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys9.dbf 73 0 4.38 1.00 1 0 0 0.00
TEMP1 /ds2/oracle/VIS/db/apps_st/data/temp1_01.dbf 84 0 0.71 15.00 124 0 0  
TEMP2 /ds2/oracle/VIS/db/apps_st/data/temp2_02.dbf 25 0 0.00 15.00 68 0 0  
UDDISYS_TS /ds2/oracle/VIS/db/apps_st/data/uddisys01.dbf 6 0 1.67 1.00 1 0 0 0.00
WCRSYS_TS /ds2/oracle/VIS/db/apps_st/data/wcrsys01.dbf 7 0 1.43 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 906,379 100 3,493,119,126 816,023 1,376,287 0 0 1,893,781


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 30 1012 8797 104785 37748700 104785  
E 0 335 169000 4209190 8866769 37748700 8866769  

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 720 0.10 89,055 1.20 47,285,626
D 1,440 0.20 178,110 1.15 45,495,484
D 2,160 0.29 267,165 1.12 44,369,305
D 2,880 0.39 356,220 1.10 43,421,558
D 3,600 0.49 445,275 1.08 42,518,410
D 4,320 0.59 534,330 1.06 41,722,010
D 5,040 0.69 623,385 1.04 41,039,738
D 5,760 0.79 712,440 1.02 40,483,983
D 6,480 0.88 801,495 1.01 40,019,050
D 7,200 0.98 890,550 1.00 39,604,431
D 7,328 1.00 906,382 1.00 39,529,374
D 7,920 1.08 979,605 0.99 39,189,207
D 8,640 1.18 1,068,660 0.98 38,755,122
D 9,360 1.28 1,157,715 0.97 38,325,860
D 10,080 1.38 1,246,770 0.96 37,967,549
D 10,800 1.47 1,335,825 0.95 37,679,637
D 11,520 1.57 1,424,880 0.95 37,432,444
D 12,240 1.67 1,513,935 0.94 37,190,666
D 12,960 1.77 1,602,990 0.93 36,921,880
D 13,680 1.87 1,692,045 0.93 36,648,661
D 14,400 1.97 1,781,100 0.92 36,389,356

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
99.67 21,561 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,399 316.83 0.23 0.07 100.00 0.00 629,140
E 6,144 5,394 286.72 0.26 0.09 100.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,610,683 10,610,683 0 0
64K 128K 12 12 0 0
128K 256K 32 32 0 0
256K 512K 10 10 0 0
512K 1024K 311 311 0 0
1M 2M 191 191 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 911,965.53 6,396.03 99.00 0
1,536 0.25 911,965.53 1,872.29 100.00 0
3,072 0.50 911,965.53 1,872.29 100.00 0
4,608 0.75 911,965.53 1,872.29 100.00 0
6,144 1.00 911,965.53 1,872.29 100.00 0
7,373 1.20 911,965.53 0.00 100.00 0
8,602 1.40 911,965.53 0.00 100.00 0
9,830 1.60 911,965.53 0.00 100.00 0
11,059 1.80 911,965.53 0.00 100.00 0
12,288 2.00 911,965.53 0.00 100.00 0
18,432 3.00 911,965.53 0.00 100.00 0
24,576 4.00 911,965.53 0.00 100.00 0
36,864 6.00 911,965.53 0.00 100.00 0
49,152 8.00 911,965.53 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
448 0.16 318 14,934 14,787,322 1.00 30,846 9.84 927,939,301
736 0.27 598 25,816 14,804,646 1.00 13,522 4.31 927,951,165
1,024 0.37 880 36,452 14,810,121 1.00 8,047 2.57 927,954,982
1,312 0.48 1,163 50,764 14,811,348 1.00 6,820 2.17 927,956,796
1,600 0.58 1,446 63,567 14,811,616 1.00 6,552 2.09 927,958,952
1,888 0.69 1,728 76,357 14,812,008 1.00 6,160 1.96 927,961,834
2,176 0.79 2,011 87,327 14,812,823 1.00 5,345 1.70 927,967,273
2,464 0.90 2,295 101,381 14,813,888 1.00 4,280 1.36 927,979,189
2,752 1.00 2,578 113,959 14,815,032 1.00 3,136 1.00 927,998,916
3,040 1.10 2,863 129,318 14,816,292 1.00 1,876 0.60 928,021,658
3,328 1.21 3,146 143,592 14,817,619 1.00 549 0.18 928,043,899
3,616 1.31 3,429 156,022 14,818,744 1.00 1 0.00 928,066,234
3,904 1.42 3,712 168,793 14,819,441 1.00 1 0.00 928,086,629
4,192 1.52 3,995 181,114 14,819,801 1.00 1 0.00 928,102,782
4,480 1.63 4,277 192,525 14,820,248 1.00 1 0.00 928,112,782
4,768 1.73 4,559 201,861 14,821,134 1.00 1 0.00 928,117,370
5,056 1.84 4,770 210,179 14,821,597 1.00 1 0.00 928,121,317
5,344 1.94 4,996 217,870 14,821,652 1.00 1 0.00 928,123,463
5,632 2.05 5,632 249,180 14,821,687 1.00 1 0.00 928,125,498

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 233,510 46,707,861
5,120 0.50 225,537 44,936,947
7,680 0.75 223,278 41,213,284
10,240 1.00 221,462 39,529,334
12,800 1.25 220,200 37,857,243
15,360 1.50 219,535 36,975,739
17,920 1.75 218,760 35,944,023
20,480 2.00 218,760 35,944,023

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
16 0.25 0 166 13 1.00 3,136 1.00 215
32 0.50 0 166 13 1.00 3,136 1.00 215
48 0.75 0 166 13 1.00 3,136 1.00 215
64 1.00 0 166 13 1.00 3,136 1.00 215
80 1.25 0 166 13 1.00 3,136 1.00 215
96 1.50 0 166 13 1.00 3,136 1.00 215
112 1.75 0 166 13 1.00 3,136 1.00 215
128 2.00 0 166 13 1.00 3,136 1.00 215

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,017,739 82 0
undo block 825,895 11 0
undo header 49,405 1 0
segment header 96 0 1
2nd level bmb 14 0 9
1st level bmb 241 0 0

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 75,627 75,186 441 46,933 1,868 39.80
TX-Transaction (index contention) 111,162 111,162 0 110,948 72 0.65
TX-Transaction (allocate ITL entry) 14 12 2 14 15 1,051.43
TX-Transaction (row lock contention) 4,408 4,321 87 4,313 3 0.63
SQ-Sequence Cache 15,925 15,925 0 6,150 1 0.13
HW-Segment High Water Mark 1,017 1,017 0 12 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 756.69 432,013 1,497 20 209.3/225.516666666666666666666666666666666667 0/0 0/0/0/0/0/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
09-Sep 22:09 59,991 67,019 253 18 226 0/0 0/0/0/0/0/0
09-Sep 21:59 114,676 32,557 1,497 17 220 0/0 0/0/0/0/0/0
09-Sep 21:49 113,667 32,431 1,407 17 209 0/0 0/0/0/0/0/0
09-Sep 21:39 218,196 169,305 806 19 211 0/0 0/0/0/0/0/0
09-Sep 21:29 250,162 130,701 205 20 210 0/0 0/0/0/0/0/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 2,179 0.00   0 0  
AWR Alerted Metric Element list 20,243 0.00   0 0  
Consistent RBA 188,739 0.03 0.24 0 0  
FOB s.o list latch 12,379 0.29 0.00 0 0  
In memory undo latch 776,657,970 1.71 0.00 4 353,074 0.00
JOX SGA heap latch 15 0.00   0 0  
JS queue state obj latch 19,140 0.00   0 0  
JS slv state obj latch 109 0.00   0 0  
KMG MMAN ready and startup request latch 1,063 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 8 0.00   0 1,029 0.00
KWQMN job cache list latch 29 0.00   0 0  
KWQP Prop Status 394 0.00   0 0  
MQL Tracking Latch 0     0 63 0.00
Memory Management Latch 20 0.00   0 1,063 0.00
OS process 795 0.00   0 0  
OS process allocation 1,581 0.00   0 0  
OS process: request allocation 362 0.00   0 0  
PL/SQL warning settings 6,342,171 0.00   0 0  
SGA IO buffer pool latch 12,552 0.02 0.00 0 12,552 0.01
SQL memory manager latch 2 0.00   0 1,060 0.00
SQL memory manager workarea list latch 5,547,516 0.02 0.00 0 0  
Shared B-Tree 1,978 0.00   0 0  
active checkpoint queue latch 112,808 0.07 0.00 0 0  
active service list 6,698 0.04 0.00 0 1,131 0.00
begin backup scn array 7 0.00   0 0  
bq:time manger info latch 115 0.00   0 0  
buffer pool 9 0.00   0 0  
bufq statistics 2 0.00   0 0  
cache buffer handles 235,221,923 2.95 0.00 0 0  
cache buffers chains 6,915,792,624 2.95 0.01 34 12,361,801 7.44
cache buffers lru chain 3,287,762 0.19 0.00 0 27,416,350 0.47
cache table scan latch 0     0 2,430 0.00
channel handle pool latch 608 0.00   0 0  
channel operations parent latch 17,586 0.07 0.00 0 0  
checkpoint queue latch 3,003,990 0.01 0.03 0 1,551,717 0.01
client/application info 1,918 0.00   0 0  
commit callback allocation 54 0.00   0 0  
compile environment latch 351,869 0.00   0 0  
dml lock allocation 2,826,248 0.22 0.00 0 0  
dummy allocation 460 0.00   0 0  
enqueue hash chains 4,768,088 0.59 0.00 0 2,069 0.14
enqueues 799,050 1.16 0.00 0 0  
event group latch 175 0.00   0 0  
file cache latch 1,032 0.00   0 0  
global KZLD latch for mem in SGA 135 0.00   0 0  
global ctx hash table latch 283 0.00   0 0  
hash table column usage latch 547 1.10 0.00 0 60,439 0.00
hash table modification latch 91 1.10 0.00 0 0  
job workq parent latch 0     0 83 0.00
job_queue_processes parameter latch 91 0.00   0 0  
kks stats 1,759 0.00   0 0  
ksuosstats global area 217 0.00   0 0  
ktm global data 231 0.00   0 0  
kwqbsn:qsga 1,930 0.00   0 0  
lgwr LWN SCN 189,140 0.07 0.03 0 0  
library cache 434,707,155 0.95 0.00 1 0  
library cache load lock 4,208 3.02 0.03 0 111 0.00
library cache lock 212,709,958 1.62 0.00 0 0  
library cache lock allocation 13,622 0.02 0.00 0 0  
library cache pin 190,853,803 0.73 0.00 0 0  
library cache pin allocation 4,443 0.02 0.00 0 0  
list of block allocation 360,057 0.01 0.04 0 0  
loader state object freelist 390 0.51 0.00 0 0  
logminer context allocation 2 0.00   0 0  
longop free list parent 1,132 0.00   0 1 0.00
message pool operations parent latch 484 0.41 0.00 0 0  
messages 802,309 0.03 0.01 0 0  
mostly latch-free SCN 197,501 3.02 0.04 0 0  
multiblock read objects 8,114 0.00   0 0  
ncodef allocation latch 81 0.00   0 0  
object queue header heap 454,045 0.00   0 3,798 0.00
object queue header operation 9,020,252 0.02 0.03 0 14,929 0.01
object stats modification 410 0.24 0.00 0 0  
parallel query alloc buffer 424 0.00   0 0  
parameter list 528 0.00   0 0  
parameter table allocation management 245 0.41 0.00 0 0  
post/wait queue 310,444 0.07 0.00 0 154,011 0.01
process allocation 362 0.00   0 175 0.00
process group creation 362 0.00   0 0  
process queue 14 0.00   0 0  
qmn task queue latch 4,579 17.17 0.06 0 0  
query server freelists 14 7.14 0.00 0 0  
query server process 0     0 14 0.00
redo allocation 1,398,757 0.92 0.03 0 62,406,718 0.98
redo copy 0     0 62,436,240 0.01
redo writing 781,107 0.01 0.09 0 0  
resmgr group change latch 777 0.00   0 0  
resmgr:actses active list 583 1.20 0.00 0 0  
resmgr:actses change group 397 0.00   0 0  
resmgr:free threads list 456 0.22 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 17,199,210 2.42 0.00 0 0  
rules engine aggregate statistics 1 0.00   0 0  
rules engine rule set statistics 202 0.00   0 0  
sequence cache 29,277,491 1.51 0.00 0 0  
session allocation 22,349,841 3.27 0.00 0 0  
session idle bit 46,782,783 0.05 0.01 0 0  
session state list latch 1,013 0.89 0.00 0 0  
session switching 81 0.00   0 0  
session timer 1,131 0.00   0 0  
shared pool 2,140,711 0.15 0.04 0 0  
shared pool sim alloc 17 5.88 0.00 0 0  
shared pool simulator 867,045 0.00 0.00 0 0  
simulator hash latch 246,858,999 0.00 0.00 0 0  
simulator lru latch 246,542,951 2.22 0.00 1 108,781 0.11
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 1,802 1.11 0.25 0 0  
state object free list 4 0.00   0 0  
statistics aggregation 168 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 238 0.84 0.00 0 0  
threshold alerts latch 723 0.00   0 0  
trace latch 7 0.00   0 0  
transaction allocation 118,847 0.00 0.00 0 0  
transaction branch allocation 81 0.00   0 0  
undo global data 883,010,229 0.54 0.00 0 0  
user lock 560 0.18 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,915,792,624 204,330,344 1,712,442 202,777,826 0 0 0
In memory undo latch 776,657,970 13,282,274 62,010 13,228,443 0 0 0
cache buffer handles 235,221,923 6,944,306 2,695 6,941,999 0 0 0
simulator lru latch 246,542,951 5,483,699 7,197 5,477,924 0 0 0
undo global data 883,010,229 4,725,377 5,068 4,721,612 0 0 0
library cache 434,707,155 4,147,925 7,587 4,142,157 0 0 0
library cache lock 212,709,958 3,442,979 528 3,442,551 0 0 0
library cache pin 190,853,803 1,393,276 2,592 1,391,291 0 0 0
session allocation 22,349,841 730,190 505 729,780 0 0 0
sequence cache 29,277,491 442,524 757 441,996 0 0 0
row cache objects 17,199,210 416,459 78 416,396 0 0 0
enqueue hash chains 4,768,088 27,998 78 27,923 0 0 0
session idle bit 46,782,783 23,543 136 23,451 0 0 0
redo allocation 1,398,757 12,846 350 12,595 0 0 0
simulator hash latch 246,858,999 10,042 19 10,026 0 0 0
enqueues 799,050 9,253 31 9,223 0 0 0
dml lock allocation 2,826,248 6,183 2 6,181 0 0 0
cache buffers lru chain 3,287,762 6,161 29 6,135 0 0 0
mostly latch-free SCN 197,501 5,961 214 5,788 0 0 0
shared pool 2,140,711 3,131 120 3,059 0 0 0
object queue header operation 9,020,252 1,759 49 1,726 0 0 0
SQL memory manager workarea list latch 5,547,516 1,097 5 1,093 0 0 0
qmn task queue latch 4,579 786 47 739 0 0 0
messages 802,309 269 4 265 0 0 0
checkpoint queue latch 3,003,990 237 6 232 0 0 0
lgwr LWN SCN 189,140 133 4 129 0 0 0
library cache load lock 4,208 127 4 123 0 0 0
redo writing 781,107 88 8 80 0 0 0
Consistent RBA 188,739 49 12 40 0 0 0
list of block allocation 360,057 23 1 22 0 0 0
sort extent pool 1,802 20 5 16 0 0 0
slave class create 8 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 35,399 10,938
In memory undo latch kturbk 0 20,140 26,560
In memory undo latch ktichg: child 0 4,007 23,661
In memory undo latch kticmt: child 0 1,867 29
In memory undo latch ktiTxnPoolFree 0 498 9
In memory undo latch ktbgfc 0 89 811
In memory undo latch ktiBRacquire 0 9 0
SQL memory manager workarea list latch qesmmIRefreshBound 0 2 0
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 2 4
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 1
active service list ksws_event: ksws event 0 1 1
cache buffer handles kcbzgs 0 1,736 1,638
cache buffer handles kcbzfs 0 959 1,057
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 3,622,745 3,859,540
cache buffers chains kcbchg: kslbegin: call CR func 0 1,586,553 2,822,439
cache buffers chains kcbgtcr: fast path 0 1,154,435 49,138
cache buffers chains kcbgtcr: kslbegin excl 0 222,539 72,463
cache buffers chains kcbget: pin buffer 0 194,493 64,287
cache buffers chains kcbrls: kslbegin 0 61,639 106,050
cache buffers chains kcbzwb 0 58,245 22,683
cache buffers chains kcbgcur: kslbegin 0 35,329 12,354
cache buffers chains kcbcge 0 13,459 27,559
cache buffers chains kcbzgb: scan from tail. nowait 0 4,548 0
cache buffers chains kcbnlc 0 1,567 1,906
cache buffers chains kcb_post_apply: kcbhq62 0 644 648
cache buffers chains kcb_is_private 0 569 2,900
cache buffers chains kcb_pre_apply: kcbhq61 0 540 5,547
cache buffers chains kcbget: exchange rls 0 437 169
cache buffers chains kcbget: exchange 0 345 312
cache buffers chains kcbesc: escalate 0 142 40
cache buffers chains kcb_post_apply: kcbhq63 0 135 412
cache buffers chains kcbnew: new latch again 0 37 0
cache buffers chains kcbso1: set no access 0 9 24
cache buffers chains kcbgtcr 0 8 15
cache buffers chains kcbzib: finish free bufs 0 6 6
cache buffers chains kcbbxsv 0 5 0
cache buffers chains kcbgtcr: kslbegin shared 0 5 8
cache buffers lru chain kcbzgws 0 16 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 9 0
cache buffers lru chain kcbbxsv: move to being written 0 4 8
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 3 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 2 2
checkpoint queue latch kcbkubc 0 1 1
dml lock allocation ktaiam 0 1 2
dml lock allocation ktaidm 0 1 0
enqueue hash chains ksqrcl 0 48 18
enqueue hash chains ksqgtl3 0 16 12
enqueue hash chains ksqcmi: get hash chain latch after wait 0 10 47
enqueue hash chains ksqcmi: kslgpl 0 4 1
enqueues ksqdel 0 25 25
enqueues ksqgel: create enqueue 0 6 6
event range base latch No latch 0 47 47
lgwr LWN SCN kcs023 0 87 0
library cache kglpnp: child 0 3,393 4,186
library cache kglpndl: child: after processing 0 2,456 102
library cache kglpndl: child: before processing 0 825 2,226
library cache kglobpn: child: 0 437 616
library cache kglLockCursor 0 293 441
library cache kglScanDependency 0 8 0
library cache kgldte: child 0 0 4 8
library cache kglhdgc: child: 0 1 1
library cache kglhdgn: child: 0 1 4
library cache load lock kglllal: llatch 0 2 1
library cache load lock kglllal: llatch: in loop 0 2 3
library cache lock kgllkal: child: multiinstance 0 288 309
library cache lock kgllkdl: child: cleanup 0 240 219
library cache lock kgllkdl: child: no lock handle 0 169 1
library cache pin kglpnp: child 0 1,340 1,476
library cache pin kglpndl 0 1,181 993
library cache pin kglpnal: child: alloc space 0 71 123
list of block allocation ktlbbl 0 1 0
messages ksaamb: after wakeup 0 3 1
messages ksarcv 0 1 0
mostly latch-free SCN kcslcu3 0 127 218
mostly latch-free SCN kcs01 0 6 12
mostly latch-free SCN kcsnew_scn_rba 0 6 0
mostly latch-free SCN kcs024 0 4 0
object queue header operation kcbo_switch_mq_bg 0 37 8
object queue header operation kcbo_switch_q_bg 0 7 2
object queue header operation kcbo_switch_cq 0 3 11
object queue header operation kcbo_swap_buf_bg 0 2 4
object queue header operation kcbw_link_q 0 2 8
object queue header operation kcbw_unlink_q 0 1 19
redo allocation kcrfw_redo_gen: redo allocation 1 0 288 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 36 314
redo allocation kcrfw_redo_write: before write 0 13 23
redo allocation kcrfw_redo_write: more space 0 11 13
redo allocation kcrfw_redo_gen: redo allocation 2 0 2 0
redo writing kcrfwcr 0 5 5
redo writing kcrfw_post: rba scn pair 0 2 0
redo writing kcrfw_cal_target_rba 0 1 4
row cache objects kqreqd: reget 0 49 4
row cache objects kqrpre: find obj 0 24 63
row cache objects kqreqd 0 5 11
sequence cache kdnssd 0 445 13
sequence cache kdnnxt: cached seq 0 237 8
sequence cache kdnss 0 75 736
session allocation ksuprc 0 293 288
session allocation ksudlc 0 206 212
session allocation ksuxds: not user session 0 6 3
session idle bit ksupuc: clear busy 0 82 111
session idle bit ksupuc: set busy 0 65 36
shared pool kghupr1 0 113 107
shared pool kghalo 0 4 5
shared pool kghfre 0 3 7
simulator hash latch kcbsacc: lookup dba 0 17 19
simulator hash latch kcbs_get_or_extract_simbufseq 0 2 0
simulator lru latch kcbs_simulate: simulate set 0 6,855 7,172
simulator lru latch kcbs_simbufseq 0 319 25
simulator lru latch kcbs_shrink_pool 0 16 0
simulator lru latch kcbs_free_granule_sim_buffers 0 4 0
simulator lru latch kcbs_resize_pool : interpolation 0 3 0
slave class create ksvcreate 0 1 0
sort extent pool ktstaddextent1 0 2 0
sort extent pool ktstcrtobj 0 2 0
sort extent pool ktstallobj1 0 1 5
undo global data kturimugur: child 0 4,261 1,607
undo global data ktudba: KSLBEGIN 0 799 3,456
undo global data ktudnx:child 0 7 5
undo global data ktubnd:child 0 1 2

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,655,744 8.65
HR APPS_TS_TX_IDX PAY_PAYROLL_ACTIONS_PK   INDEX 293,247,712 8.36
HR APPS_TS_TX_IDX PAY_RUN_RESULTS_N50   INDEX 188,849,888 5.38
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 175,951,104 5.01
HR APPS_TS_TX_DATA PAY_PAYROLL_ACTIONS   TABLE 146,338,400 4.17

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 236,550 28.90
HR APPS_TS_TX_DATA PAY_LATEST_BALANCES   TABLE 45,991 5.62
HR APPS_TS_TX_DATA PAY_RUN_BALANCES   TABLE 39,143 4.78
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N5   INDEX 38,082 4.65
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N2   INDEX 26,870 3.28

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,772 16.14
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 15,014 12.25
HR APPS_TS_TX_IDX PAY_COSTS_FK1   INDEX 8,558 6.98
HR APPS_TS_TX_IDX PAY_COSTS_FK2   INDEX 8,189 6.68
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_FK2   INDEX 8,165 6.66

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 11 91.67
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 1 8.33

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 184,614 18.41
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_PK   INDEX 85,319 8.51
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 82,492 8.22
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 79,265 7.90
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 65,595 6.54

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 63 0.00 0   4 1
dc_global_oids 225 1.78 0   0 50
dc_histogram_data 2,870 1.88 0   0 4,805
dc_histogram_defs 9,831 1.36 0   0 850,277
dc_object_grants 130 1.54 0   0 84
dc_object_ids 84,055 0.07 0   0 80,663
dc_objects 3,371 11.87 0   0 94,612
dc_profiles 146 0.00 0   0 1
dc_rollback_segments 2,540 0.00 0   0 81
dc_segments 18,768 0.14 0   56 93,678
dc_sequences 9,766 0.09 0   9,766 22
dc_tablespace_quotas 47 2.13 0   0 2
dc_tablespaces 2,831,892 0.00 0   0 57
dc_usernames 2,794 0.00 0   0 176
dc_users 2,757,774 0.00 0   0 203
kqlsubheap_object 47 2.13 0   0 56
outstanding_alerts 322 0.00 0   1 55


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 3,052 2.36 41,324,790 -0.02 0 0
CLUSTER 9 0.00 14 0.00 0 0
INDEX 6 0.00 46 0.00 0 0
JAVA DATA 1 0.00 0   0 0
SQL AREA 1,184 73.31 333,106,647 -0.96 572 0
TABLE/PROCEDURE 7,325 5.46 51,163,341 -0.00 3 0
TRIGGER 229 2.18 5,405,596 0.00 1 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 233.75   3.16 7.94 50 50 74 74
  Freeable 62.94 0.00 1.21 1.89 10   52 52
  SQL 16.58 7.47 0.25 0.53 3 81 67 53
  PL/SQL 3.67 1.42 0.05 0.06 0 0 74 60
E Other 218.60   3.53 8.39 50 50 62 62
  Freeable 46.94 0.00 1.68 2.48 10   28 28
  SQL 17.46 8.12 0.31 0.59 3 25 56 54
  PL/SQL 3.76 1.43 0.06 0.06 0 0 62 62

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 7,818,182,656 7,683,964,928
Fixed Size 2,090,464  
Redo Buffers 65,015,808  
Variable Size 2,852,129,312 2,986,347,040

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 56.09 56.09 0.00
java joxlod exec hp 7.65 7.65 0.00
large PX msg pool 0.39 0.39 0.00
large free memory 15.61 15.61 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 125.29 128.93 2.91
shared Heap0: KGL 79.80 80.91 1.39
shared KGLS heap 651.74 652.06 0.05
shared KQR L PO 92.01 92.40 0.42
shared KQR M PO 500.61 500.72 0.02
shared PCursor 97.53 99.34 1.86
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 512.77 599.34 16.88
shared library cache 224.60 226.79 0.97
shared obj stat memo 28.81 28.81 0.01
shared sql area   49.97  
streams KGH: NO ACCESS 15.98 15.98 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 7,456.00 7,328.00 -1.72
  fixed_sga 1.99 1.99 0.00
  log_buffer 62.00 62.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 91,106 0 0
QMON Coordinator 82,302 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
SYS.ALERT_QUE_R 1 0 0 5 24

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 63045632   
log_checkpoint_timeout 1200   
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 14   
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