WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS220594996VIS110.2.0.3.0NOdb1.oasb.cisco

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:105502-Aug-10 12:28:18195 27.7
End Snap:105702-Aug-10 13:29:43189 28.0
Elapsed:  61.41 (mins)  
DB Time:  533.93 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 22,320M 22,320MStd Block Size: 8K
Shared Pool Size: 2,048M 2,048MLog Buffer: 63,464K

Load Profile

Per SecondPer Transaction
Redo size: 4,981,314.17 51,552.00
Logical reads: 983,240.51 10,175.63
Block changes: 33,807.79 349.88
Physical reads: 55.97 0.58
Physical writes: 411.22 4.26
User calls: 6,308.35 65.29
Parses: 5,001.76 51.76
Hard parses: 0.21 0.00
Sorts: 5,368.66 55.56
Logons: 0.08 0.00
Executes: 57,638.15 596.50
Transactions: 96.63 

% Blocks changed per Read: 3.44Recursive Call %: 95.09
Rollback per transaction %: 1.05Rows per Sort: 2.18

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.90Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 100.15Soft Parse %: 100.00
Execute to Parse %: 91.32Latch Hit %: 95.48
Parse CPU to Parse Elapsd %: 81.91% Non-Parse CPU: 99.07

Shared Pool Statistics

BeginEnd
Memory Usage %: 28.72 30.49
% SQL with executions>1: 89.93 94.69
% Memory for SQL w/exec>1: 84.33 91.24

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  29,308  91.5 
db file sequential read 196,660 792 4 2.5User I/O
enq: UL - contention 49,567 743 15 2.3Application
latch: cache buffers chains 5,402,524 502 0 1.6Concurrency
enq: TX - index contention 318,697 296 1 .9Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 31,617.63 98.69
DB CPU 29,307.66 91.48
PL/SQL execution elapsed time 10,442.76 32.60
parse time elapsed 373.19 1.16
repeated bind elapsed time 14.92 0.05
inbound PL/SQL rpc elapsed time 11.67 0.04
hard parse elapsed time 4.59 0.01
sequence load elapsed time 4.28 0.01
PL/SQL compilation elapsed time 0.82 0.00
connection management call elapsed time 0.53 0.00
Java execution elapsed time 0.08 0.00
hard parse (sharing criteria) elapsed time 0.02 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 32,036.04  
background elapsed time 364.77  
background cpu time 61.90  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 9,373,176 0.00 1,110 0 26.32
User I/O 217,549 0.00 867 4 0.61
Application 57,518 0.21 748 13 0.16
System I/O 429,542 0.00 304 1 1.21
Commit 158,597 0.00 134 1 0.45
Other 427,998 78.97 130 0 1.20
Network 22,543,346 0.00 16 0 63.31
Configuration 28,018 8.43 5 0 0.08

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 196,660 0.00 792 4 0.55
enq: UL - contention 49,567 0.24 743 15 0.14
latch: cache buffers chains 5,402,524 0.00 502 0 15.17
enq: TX - index contention 318,697 0.00 296 1 0.90
buffer busy waits 3,423,718 0.00 242 0 9.62
log file parallel write 289,668 0.00 162 1 0.81
db file parallel write 134,482 0.00 140 1 0.38
log file sync 158,597 0.00 134 1 0.45
wait list latch free 8,748 0.00 95 11 0.02
read by other session 19,599 0.00 66 3 0.06
library cache load lock 1,016 0.00 29 29 0.00
library cache pin 2,917 0.00 23 8 0.01
kksfbc child completion 470 87.87 21 44 0.00
SQL*Net message to client 21,817,490 0.00 13 0 61.27
latch: In memory undo latch 147,470 0.00 10 0 0.41
db file scattered read 1,272 0.00 9 7 0.00
buffer deadlock 344,344 98.04 6 0 0.97
latch: library cache 56,787 0.00 5 0 0.16
enq: TX - row lock contention 6,367 0.00 4 1 0.02
SQL*Net more data from client 722,984 0.00 3 0 2.03
enq: HW - contention 7,169 0.00 3 0 0.02
latch free 28,521 0.00 3 0 0.08
LGWR wait for redo copy 21,148 0.00 3 0 0.06
enq: SQ - contention 18,168 0.00 2 0 0.05
latch: library cache pin 18,224 0.00 2 0 0.05
control file sequential read 3,865 0.00 1 0 0.01
enq: TX - contention 3,174 0.00 1 0 0.01
latch: undo global data 11,858 0.00 1 0 0.03
control file parallel write 1,527 0.00 1 1 0.00
os thread startup 44 0.00 1 19 0.00
latch: cache buffer handles 5,803 0.00 1 0 0.02
rdbms ipc reply 576 0.00 0 1 0.00
SQL*Net break/reset to client 1,584 0.00 0 0 0.00
latch: redo allocation 1,108 0.00 0 0 0.00
row cache lock 69 0.00 0 2 0.00
latch: library cache lock 1,414 0.00 0 0 0.00
latch: session allocation 1,074 0.00 0 0 0.00
enq: FB - contention 791 0.00 0 0 0.00
enq: TX - allocate ITL entry 311 0.00 0 0 0.00
SQL*Net more data to client 2,872 0.00 0 0 0.01
latch: enqueue hash chains 303 0.00 0 0 0.00
latch: cache buffers lru chain 65 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 20 0.00
L1 validation 1 100.00 0 11 0.00
cursor: mutex X 150 0.00 0 0 0.00
latch: object queue header operation 11 0.00 0 1 0.00
undo segment extension 2,370 99.62 0 0 0.01
latch: shared pool 50 0.00 0 0 0.00
direct path write 17 0.00 0 0 0.00
cursor: mutex S 85 0.00 0 0 0.00
latch: row cache objects 11 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
latch: checkpoint queue latch 1 0.00 0 0 0.00
direct path read 1 0.00 0 0 0.00
SQL*Net message from client 21,817,498 0.00 278,225 13 61.27
Streams AQ: waiting for messages in the queue 8,382 100.00 72,782 8683 0.02
pipe get 4,419 100.00 17,998 4073 0.01
PL/SQL lock timer 1,700 100.00 16,607 9769 0.00
Streams AQ: qmn slave idle wait 749 0.40 4,138 5525 0.00
Streams AQ: qmn coordinator idle wait 1,722 34.44 3,601 2091 0.00
jobq slave wait 444 98.20 1,295 2916 0.00
class slave wait 3 0.00 0 6 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 289,668 0.00 162 1 0.81
db file parallel write 134,482 0.00 140 1 0.38
events in waitclass Other 21,971 0.00 3 0 0.06
control file parallel write 1,527 0.00 1 1 0.00
os thread startup 44 0.00 1 19 0.00
control file sequential read 450 0.00 0 1 0.00
buffer busy waits 3 0.00 0 0 0.00
latch: cache buffers chains 1 0.00 0 0 0.00
rdbms ipc message 196,423 7.16 38,848 198 0.55
Streams AQ: qmn coordinator idle wait 1,722 34.44 3,601 2091 0.00
pmon timer 1,408 89.20 3,599 2556 0.00
smon timer 400 1.25 3,516 8791 0.00
Streams AQ: qmn slave idle wait 190 0.00 973 5119 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 3,232,668
IDLE_TIME 5,610,984
IOWAIT_TIME 86,298
NICE_TIME 38
SYS_TIME 118,909
USER_TIME 3,088,628
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 19,999,976
NUM_CPUS 24
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
VIS 32,031.80 29,305.40 205,869 3,622,961,663
SYS$USERS 4.20 2.20 167 94,993
SYS$BACKGROUND 0.00 0.00 204 78,542

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
VIS 216835 86423 9373128 110910 0 0 22542694 1599
SYS$USERS 296 128 0 0 0 0 37 0
SYS$BACKGROUND 421 159 48 85 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 IdSQL ModuleSQL Text
21,985 21,335 249,735 0.09 68.63 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
21,895 21,242 249,945 0.09 68.34 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
2,103 1,190 120 17.53 6.56 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
1,206 1,206 3,748,121 0.00 3.77 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,198 1,131 249,889 0.00 3.74 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
1,191 745 12,500 0.10 3.72 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
1,040 1,040 3,747,690 0.00 3.25 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
982 917 249,912 0.00 3.07 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
863 863 2,747,222 0.00 2.69 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
776 765 1,499,452 0.00 2.42 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
746 673 2,749,825 0.00 2.33 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
697 698 28,279,158 0.00 2.18 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
525 501 249,849 0.00 1.64 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
517 514 249,584 0.00 1.61 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
462 462 1,124,675 0.00 1.44 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
421 421 10,730,963 0.00 1.31 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
375 375 4,247,241 0.00 1.17 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
374 373 249,769 0.00 1.17 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
370 370 13,607,927 0.00 1.15 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
351 351 249,080 0.00 1.09 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
324 201 249,507 0.00 1.01 6pb42jb41fb6w PYUSLV insert into pay_costs (cost_id...

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 IdSQL ModuleSQL Text
21,335 21,985 249,735 0.09 68.63 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
21,242 21,895 249,945 0.08 68.34 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,206 1,206 3,748,121 0.00 3.77 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,190 2,103 120 9.92 6.56 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
1,131 1,198 249,889 0.00 3.74 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
1,040 1,040 3,747,690 0.00 3.25 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
917 982 249,912 0.00 3.07 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
863 863 2,747,222 0.00 2.69 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
765 776 1,499,452 0.00 2.42 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
745 1,191 12,500 0.06 3.72 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
698 697 28,279,158 0.00 2.18 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
673 746 2,749,825 0.00 2.33 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
514 517 249,584 0.00 1.61 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
501 525 249,849 0.00 1.64 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
462 462 1,124,675 0.00 1.44 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
421 421 10,730,963 0.00 1.31 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
375 375 4,247,241 0.00 1.17 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
373 374 249,769 0.00 1.17 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
370 370 13,607,927 0.00 1.15 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
351 351 249,080 0.00 1.09 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
201 324 249,507 0.00 1.01 6pb42jb41fb6w PYUSLV insert into pay_costs (cost_id...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
2,454,197,964 249,945 9,818.95 67.74 21241.84 21895.00 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
2,453,032,311 249,735 9,822.54 67.70 21334.63 21984.76 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
250,759,569 3,748,121 66.90 6.92 1206.09 1206.48 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
231,770,753 1,499,452 154.57 6.40 765.47 775.78 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
215,899,026 120 1,799,158.55 5.96 1190.47 2103.06 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
197,199,628 3,747,690 52.62 5.44 1039.87 1039.65 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
182,173,262 2,747,222 66.31 5.03 863.27 862.77 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
157,224,125 4,247,241 37.02 4.34 374.65 374.79 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
135,849,141 1,124,675 120.79 3.75 461.71 461.79 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
130,876,649 1,999,219 65.46 3.61 215.79 216.00 5ts0t88sz97xs PYUSLV SELECT PDB.DEFINED_BALANCE_ID ...
130,832,165 249,889 523.56 3.61 1130.99 1198.15 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
122,068,287 13,607,927 8.97 3.37 370.24 370.02 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
117,074,997 10,730,963 10.91 3.23 421.17 421.18 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
86,030,779 249,769 344.44 2.37 373.05 373.54 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
85,032,367 249,849 340.34 2.35 500.52 524.50 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
83,990,832 28,279,158 2.97 2.32 698.41 696.84 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
70,534,458 249,986 282.15 1.95 163.44 164.93 cj64zg9gg7780 PYUSLV SELECT ACTION_INFORMATION_ID ,...
60,901,349 12,500 4,872.11 1.68 745.22 1191.24 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
60,880,731 249,584 243.93 1.68 514.25 517.09 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
55,149,954 249,898 220.69 1.52 213.84 217.71 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS...
54,121,212 13,599,943 3.98 1.49 275.65 275.95 9wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_...
51,581,626 2,749,825 18.76 1.42 672.76 745.92 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
50,907,028 249,474 204.06 1.41 288.89 320.09 2yjb88xutjfga PYUSLV update pay_assignment_actions ...
50,205,679 249,820 200.97 1.39 260.06 282.23 5m04808f1ytsw PYUSLV SELECT NVL(PRT.SHORTNAME, PRA...
48,924,887 249,565 196.04 1.35 262.95 287.88 4pszqmyjx91xc PYUSLV select tax_unit_id into :b0:b1...
48,760,906 249,840 195.17 1.35 267.57 290.79 gmn54j007428y PYUSLV select tax_unit_id into :b0:b1...
48,363,025 249,080 194.17 1.33 350.56 350.73 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
47,224,983 249,912 188.97 1.30 916.71 982.45 699jt64x8hadf PYUSLV UPDATE PAY_ASSIGNMENT_ACTIONS ...
47,220,110 3,123,565 15.12 1.30 197.55 201.71 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
181,215 249,945 0.73 87.87 21241.84 21895.00 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
180,882 249,735 0.72 87.71 21334.63 21984.76 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
71,484 2,749,825 0.03 34.66 672.76 745.92 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
71,117 249,954 0.28 34.48 225.85 314.29 7dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PA...
19,576 499,761 0.04 9.49 150.09 176.57 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
10,626 249,507 0.04 5.15 201.36 323.99 6pb42jb41fb6w PYUSLV insert into pay_costs (cost_id...
3,636 1,499,452 0.00 1.76 765.47 775.78 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
2,357 249,889 0.01 1.14 1130.99 1198.15 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
2,053 3,123,565 0.00 1.00 197.55 201.71 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
1,271 1 1,271.00 0.62 15.84 18.10 1knpzqdv410rs PYUSLV select paa.rowid from...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
28,279,158 43,657,856 1.54 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
14,600,550 998,723 0.07 0.00 0.00 77d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
13,607,927 13,610,951 1.00 0.00 0.00 grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, P...
13,599,943 13,601,478 1.00 0.00 0.00 9wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_...
10,730,963 10,729,092 1.00 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
4,247,241 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
3,748,121 3,745,263 1.00 0.00 0.00 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,747,690 3,744,005 1.00 0.00 0.00 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,123,565 0 0.00 0.00 0.00 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
2,999,312 2,999,534 1.00 0.00 0.00 4g3k68kv7vbqr PYUSLV SELECT DISTINCT PUS.STATE_ABBR...
2,749,825 2,749,796 1.00 0.00 0.00 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
2,747,222 2,742,526 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 CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
3,740,998 3,747,690 20.30 7rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,740,232 3,748,121 20.29 g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
2,738,666 2,747,222 14.86 dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,497,140 1,499,452 8.12 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
1,122,517 1,124,675 6.09 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
749,588 749,841 4.07 fqgs7vbu8htby PYUSLV SELECT fnd_number.number_to_ca...
499,568 499,761 2.71 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
498,939 499,785 2.71 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
495,867 499,667 2.69 83kbt99vg4svq PYUSLV begin ...
249,789 249,735 1.36 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
249,723 249,945 1.35 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
249,546 249,935 1.35 97mt0g20bcfc3 PYUSLV begin ...
249,386 249,899 1.35 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim...
249,064 249,488 1.35 36z3h9rgkd8aa PYUSLV begin ...
248,561 249,749 1.35 d7shgtk3p7s4u PYUSLV SELECT /*+ ordered index(BAL...
248,146 249,889 1.35 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
222,268 222,268 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 IdSQL 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')
02k10jzw8c495SELECT 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
165d2bgc2b9hrSELECT 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')
1knpzqdv410rs select paa.rowid from (select paa1.assignment_action_id, hou.name, ppf.last_name, ppf.first_name from hr_organization_units hou, per_people_f ppf, per_assignments_f paf, pay_assignment_actions paa1, pay_payroll_actions ppa1 where paa1.object_type is null and paa1.payroll_action_id = ppa1.payroll_action_id and paa1.payroll_action_id = :pactid and paa1.assignment_id = paf.assignment_id and ppa1.effective_date between paf.effective_start_date and paf.effective_end_date and paf.person_id = ppf.person_id and ppa1.effective_date between ppf.effective_start_date and ppf.effective_end_date and paf.organization_id = hou.organization_id union all select paa1.assignment_action_id, hou.name, null, null from hr_organization_units hou, pay_assignment_actions paa1 where paa1.object_type = 'HOU' and paa1.object_id = hou.organization_id and paa1.payroll_action_id = :pactid ) un, pay_assignment_actions paa where paa.payroll_action_id = :pactid and pa a.assignment_action_id = un.assignment_action_id order by un.name, un.last_name, un.first_name for update of paa.assignment_id
2yjb88xutjfgaupdate pay_assignment_actions set action_status='C' where assignment_action_id=:b0
2z261p0p82p32BEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I12, :T3, :I3, :T8, :I14, :N6, :I10, :T7, :I13, :N4, :I8, :D1, :N12, :I18, :N10, :I16, :N7, :I11, :N11, :I17, :T6, :I6, :N1, :T2, :I2, :N5, :I9, :N9, :I15, :FFERLN, :FFERCD, :FFERMT); END;
36z3h9rgkd8aa begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3n5uwzsh3y8gr SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S ', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2
3rg5fyfgd5uwcbegin pay_US_rules.get_time_def_for_entry( :element_entry_id, :assignment_id, :assignment_action_id, :business_group_id, :time_def_id); end;
4ds53shhfcynndeclare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3udeclare begin pay_archive.process_employee(:asg_action); end;
4g3k68kv7vbqrSELECT DISTINCT PUS.STATE_ABBREV FROM PAY_US_STATES PUS WHERE PUS.STATE_CODE = SUBSTR(:B1 , 1, 2)
4gz4b2bh1fs14SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
4pszqmyjx91xcselect tax_unit_id into :b0:b1 from pay_assignment_actions where assignment_action_id=:b2
5m04808f1ytswSELECT NVL(PRT.SHORTNAME, PRA.LEGISLATIVE_PARAMETERS), 'FF ROUTE:RUNTYPE' FROM PAY_PAYROLL_ACTIONS PRA, PAY_ASSIGNMENT_ACTIONS PAA, PAY_RUN_TYPES_F PRT WHERE PRA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PAA.ASSIGNMENT_ACTION_ID = :B1 AND NVL(PAA.RUN_TYPE_ID, -1) = PRT.RUN_TYPE_ID (+)
5sfm6rppc4y8xBEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
5ts0t88sz97xsSELECT 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))
6500rnmy4f88wSELECT 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
699jt64x8hadfUPDATE PAY_ASSIGNMENT_ACTIONS SET SERIAL_NUMBER = :B2 WHERE ASSIGNMENT_ACTION_ID = :B1
6pb42jb41fb6winsert into pay_costs (cost_id, assignment_action_id, input_value_id, run_result_id, cost_allocation_keyflex_id, balance_or_cost, costed_value, debit_or_credit, distributed_input_value_id, distributed_run_result_id, source_id, transfer_to_gl_flag) values (pay_costs_s.nextval , :b1, :b2, :b3, :b4, :b5, fnd_number.canonical_to_number(:b6), :b7, :b8:b9, :b10:b11, :b12:b13, :b14:b15)
6v07302134wyfINSERT 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 )
77d28bpwm9svgSELECT 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
7d66dw0vz7yaabegin 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 ;
7dm9q8dwzhxnpSELECT PAI.EFFECTIVE_DATE, PAI.ACTION_CONTEXT_ID FROM PAY_ACTION_INFORMATION PAI WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAI.ASSIGNMENT_ID = :B4 AND PAI.ACTION_INFORMATION_CATEGORY = :B3 AND PAI.ACTION_CONTEXT_ID <> :B2 AND PAI.EFFECTIVE_DATE <= :B1 ORDER BY PAI.EFFECTIVE_DATE DESC , PAI.ACTION_CONTEXT_ID DESC
7mmdd7sypzu9xBEGIN 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)
7y9t68kb4mc6qBEGIN 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;
9jv68n0ctas75begin 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 ;
9wupzu1crbdbbSELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1
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
cj64zg9gg7780SELECT 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 FROM PAY_ACTION_INFORMATION WHERE ACTION_INFORMATION_ID = :B1 FOR UPDATE NOWAIT
cr74qtm56vcq6BEGIN 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' )
fqgs7vbu8htbySELECT 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
gmn54j007428yselect tax_unit_id into :b0:b1 from pay_assignment_actions paa where paa.assignment_action_id=:b2
grg3zu94xp62hSELECT 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
gxa19cf01sb0cSELECT 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

StatisticTotalper Secondper Trans
CPU used by this session 2,958,748 802.94 8.31
CPU used when call started 2,958,659 802.92 8.31
CR blocks created 14,833,470 4,025.48 41.66
Cached Commit SCN referenced 4,816 1.31 0.01
Commit SCN cached 3 0.00 0.00
DB time 11,457,333 3,109.27 32.18
DBWR checkpoint buffers written 1,501,588 407.50 4.22
DBWR checkpoints 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 303 0.08 0.00
DBWR undo block writes 937,408 254.39 2.63
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 333,032,465 90,377.81 935.33
IMU Flushes 198,480 53.86 0.56
IMU Redo allocation size 2,475,297,324 671,742.16 6,951.91
IMU commits 159,205 43.20 0.45
IMU contention 114,416 31.05 0.32
IMU ktichg flush 192 0.05 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 3,432 0.93 0.01
IMU undo allocation size 4,331,001,952 1,175,340.27 12,163.69
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded 25 to 50 pct 0 0.00 0.00
Parallel operations downgraded 50 to 75 pct 0 0.00 0.00
Parallel operations not downgraded 0 0.00 0.00
SMON posted for undo segment shrink 11 0.00 0.00
SQL*Net roundtrips to/from client 21,816,877 5,920.63 61.27
active txn count during cleanout 98,971,185 26,858.64 277.96
application wait time 74,750 20.29 0.21
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 14,240 3.86 0.04
branch node splits 410 0.11 0.00
buffer is not pinned count 1,671,573,546 453,628.91 4,694.64
buffer is pinned count 688,043,410 186,720.10 1,932.38
bytes received via SQL*Net from client 5,738,143,081 1,557,207.94 16,115.66
bytes sent via SQL*Net to client 3,213,833,349 872,164.87 9,026.10
calls to get snapshot scn: kcmgss 214,386,982 58,179.99 602.11
calls to kcmgas 16,226,102 4,403.41 45.57
calls to kcmgcs 628,579 170.58 1.77
change write time 28,803 7.82 0.08
cleanout - number of ktugct calls 15,267,587 4,143.29 42.88
cleanouts and rollbacks - consistent read gets 13,912,719 3,775.61 39.07
cleanouts only - consistent read gets 127,319 34.55 0.36
cluster key scan block gets 22,078 5.99 0.06
cluster key scans 6,900 1.87 0.02
commit batch/immediate performed 26,828 7.28 0.08
commit batch/immediate requested 26,828 7.28 0.08
commit cleanout failures: block lost 389 0.11 0.00
commit cleanout failures: buffer being written 5 0.00 0.00
commit cleanout failures: callback failure 288,612 78.32 0.81
commit cleanout failures: cannot pin 97,139 26.36 0.27
commit cleanouts 5,966,425 1,619.16 16.76
commit cleanouts successfully completed 5,580,280 1,514.37 15.67
commit immediate performed 26,828 7.28 0.08
commit immediate requested 26,828 7.28 0.08
commit txn count during cleanout 1,392,749 377.96 3.91
concurrency wait time 110,995 30.12 0.31
consistent changes 1,036,011,117 281,151.01 2,909.65
consistent gets 3,472,246,409 942,292.59 9,751.86
consistent gets - examination 2,175,632,699 590,419.66 6,110.30
consistent gets direct 15 0.00 0.00
consistent gets from cache 3,472,246,394 942,292.58 9,751.86
cursor authentications 1,253 0.34 0.00
data blocks consistent reads - undo records applied 1,034,977,593 280,870.54 2,906.75
db block changes 124,578,073 33,807.79 349.88
db block gets 150,888,684 40,947.93 423.77
db block gets direct 107 0.03 0.00
db block gets from cache 150,888,577 40,947.90 423.77
deferred (CURRENT) block cleanout applications 600,426 162.94 1.69
dirty buffers inspected 7,897 2.14 0.02
enqueue conversions 77,461 21.02 0.22
enqueue releases 2,495,665 677.27 7.01
enqueue requests 2,497,180 677.68 7.01
enqueue timeouts 1,515 0.41 0.00
enqueue waits 346,078 93.92 0.97
exchange deadlocks 344,435 93.47 0.97
execute count 212,390,369 57,638.15 596.50
failed probes on index block reclamation 348 0.09 0.00
free buffer inspected 4,311,045 1,169.92 12.11
free buffer requested 16,388,594 4,447.51 46.03
heap block compress 530,818 144.05 1.49
hot buffers moved to head of LRU 945,171 256.50 2.65
immediate (CR) block cleanout applications 14,040,156 3,810.19 39.43
immediate (CURRENT) block cleanout applications 867,506 235.42 2.44
index crx upgrade (found) 1,567,670 425.43 4.40
index crx upgrade (positioned) 32,373,248 8,785.40 90.92
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 415,633,818 112,794.03 1,167.31
index scans kdiixs1 404,602,801 109,800.45 1,136.33
leaf node 90-10 splits 31,843 8.64 0.09
leaf node splits 119,093 32.32 0.33
lob reads 12 0.00 0.00
lob writes 188 0.05 0.00
lob writes unaligned 188 0.05 0.00
logons cumulative 297 0.08 0.00
messages received 424,750 115.27 1.19
messages sent 424,750 115.27 1.19
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,235,836,724 335,379.36 3,470.87
opened cursors cumulative 16,931,131 4,594.74 47.55
parse count (failures) 0 0.00 0.00
parse count (hard) 773 0.21 0.00
parse count (total) 18,430,957 5,001.76 51.76
parse time cpu 27,125 7.36 0.08
parse time elapsed 33,117 8.99 0.09
physical read IO requests 197,516 53.60 0.55
physical read bytes 1,689,460,736 458,483.11 4,744.88
physical read total IO requests 201,805 54.77 0.57
physical read total bytes 1,756,258,304 476,610.52 4,932.48
physical read total multi block requests 1,270 0.34 0.00
physical reads 206,233 55.97 0.58
physical reads cache 206,218 55.96 0.58
physical reads cache prefetch 8,717 2.37 0.02
physical reads direct 15 0.00 0.00
physical reads direct (lob) 1 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 8,658 2.35 0.02
physical write IO requests 140,348 38.09 0.39
physical write bytes 12,413,394,944 3,368,726.94 34,863.21
physical write total IO requests 613,273 166.43 1.72
physical write total bytes 31,591,013,888 8,573,117.99 88,723.85
physical write total multi block requests 575,344 156.14 1.62
physical writes 1,515,307 411.22 4.26
physical writes direct 107 0.03 0.00
physical writes direct (lob) 14 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 1,515,200 411.19 4.26
physical writes non checkpoint 1,302,741 353.54 3.66
pinned buffers inspected 3,333 0.90 0.01
prefetch warmup blocks aged out before use 23,901 6.49 0.07
prefetch warmup blocks flushed out before use 5 0.00 0.00
prefetched blocks aged out before use 2 0.00 0.00
process last non-idle time 3,601 0.98 0.01
queries parallelized 0 0.00 0.00
recursive aborts on index block reclamation 9 0.00 0.00
recursive calls 449,994,707 122,118.83 1,263.82
recursive cpu usage 2,596,948 704.76 7.29
redo blocks written 37,309,599 10,125.02 104.78
redo buffer allocation retries 0 0.00 0.00
redo entries 64,654,933 17,545.95 181.58
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 639,523 173.55 1.80
redo size 18,355,604,744 4,981,314.17 51,552.00
redo subscn max counts 1,174,818 318.82 3.30
redo synch time 13,695 3.72 0.04
redo synch writes 123,628 33.55 0.35
redo wastage 118,545,532 32,170.69 332.94
redo write time 17,368 4.71 0.05
redo writer latching time 250 0.07 0.00
redo writes 289,668 78.61 0.81
rollback changes - undo records applied 115,292 31.29 0.32
rollbacks only - consistent read gets 1,107,026 300.42 3.11
rows fetched via callback 262,841,042 71,329.37 738.19
session connect time 0 0.00 0.00
session cursor cache hits 18,394,352 4,991.83 51.66
session logical reads 3,623,135,093 983,240.51 10,175.63
session pga memory 4,143,416 1,124.43 11.64
session uga memory 55,839,038,648 15,153,507.52 156,824.80
session uga memory max 889,936,440 241,509.50 2,499.40
shared hash latch upgrades - no wait 34,447,087 9,348.19 96.75
shared hash latch upgrades - wait 1,695,277 460.06 4.76
sorts (memory) 19,782,950 5,368.66 55.56
sorts (rows) 43,047,581 11,682.18 120.90
sql area purged 0 0.00 0.00
summed dirty queue length 32,862 8.92 0.09
switch current to new buffer 329,283 89.36 0.92
table fetch by rowid 1,002,121,391 271,954.07 2,814.47
table fetch continued row 818 0.22 0.00
table scan blocks gotten 81,914,587 22,229.85 230.06
table scan rows gotten 303,023,563 82,234.04 851.05
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 6,520,017 1,769.39 18.31
total number of times SMON posted 395 0.11 0.00
transaction rollbacks 26,828 7.28 0.08
undo change vector size 6,377,643,576 1,730,754.54 17,911.71
user I/O wait time 86,709 23.53 0.24
user calls 23,245,591 6,308.35 65.29
user commits 352,304 95.61 0.99
user rollbacks 3,756 1.02 0.01
workarea executions - optimal 12,258,769 3,326.76 34.43
write clones created in foreground 51 0.01 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 17,706 27,419
opened cursors current 5,394 5,300
logons current 195 189

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_TX_DATA 183,601 50 4.09 1.02 27,031 7 517,322 0.14
APPS_UNDOTS1 0 0 0.00 0.00 68,108 18 1,168,714 0.02
APPS_TS_TX_IDX 12,964 4 3.47 1.38 44,379 12 1,754,790 0.13
SYSTEM 613 0 4.67 1.00 239 0 634 1.03
SYSAUX 251 0 2.55 1.31 530 0 0 0.00
APPS_TS_ARCHIVE 22 0 5.00 2.41 56 0 41 6.10
APPS_TS_SEED 52 0 7.69 1.00 0 0 1,592 4.93
IAS_META 6 0 10.00 1.00 0 0 0 0.00
TEMP2 0 0 0.00   3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_ARCHIVE /slot/ems2858/oracle/VIS/db/apps_st/data/archive1.db 22 0 5.00 2.41 56 0 41 6.10
APPS_TS_SEED /slot/ems2858/oracle/VIS/db/apps_st/data/reference1. 46 0 6.96 1.00 0 0 1,319 4.30
APPS_TS_SEED /slot/ems2858/oracle/VIS/db/apps_st/data/reference2. 4 0 12.50 1.00 0 0 183 5.63
APPS_TS_SEED /slot/ems2858/oracle/VIS/db/apps_st/data/reference3. 2 0 15.00 1.00 0 0 90 12.78
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data1.db 0 0     4 0 1 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data10.d 0 0     20 0 536 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data11.d 7,985 2 5.24 1.00 653 0 18,327 0.06
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data12.d 1,910 1 5.66 1.01 585 0 17,911 0.03
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data13.d 0 0     76 0 1,330 0.02
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data14.d 0 0     1 0 22 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data15.d 0 0     3 0 0 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data16.d 0 0     29 0 356 0.03
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data17.d 0 0     3 0 0 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data18.d 0 0     5 0 3 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data19.d 119 0 2.02 1.00 13 0 817 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data2.db 0 0     92 0 1,380 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data20.d 0 0     5 0 3 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data21.d 189 0 6.93 1.07 405 0 4,237 0.01
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data22.d 119 0 2.02 1.10 12 0 71 9.01
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data27.d 0 0     8 0 18,526 0.03
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data28.d 15 0 9.33 1.00 1 0 45 9.78
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data29.d 0 0     4 0 5 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data3.db 0 0     4 0 7 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data30.d 0 0     7 0 14 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data31.d 0 0     4 0 11 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data32.d 0 0     4 0 28 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data39.d 587 0 4.36 1.02 438 0 3,650 0.01
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data4.db 0 0     8 0 50 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data41.d 12 0 6.67 1.00 0 0 9 3.33
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data43.d 1,000 0 3.51 1.03 455 0 3,773 0.12
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data44.d 15,626 4 5.04 1.02 2,094 1 43,973 0.24
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data45.d 15,563 4 4.12 1.02 2,179 1 45,251 0.15
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data46.d 78 0 2.05 1.00 79 0 1,196 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data47.d 15,705 4 3.80 1.02 2,079 1 25,477 0.22
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data48.d 15,707 4 3.78 1.02 2,392 1 44,823 0.14
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data49.d 15,610 4 3.87 1.02 2,324 1 42,671 0.11
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data5.db 0 0     3 0 2 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data50.d 15,556 4 3.79 1.02 2,115 1 42,739 0.15
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data51.d 15,642 4 3.93 1.02 2,295 1 42,739 0.12
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data52.d 2 0 0.00 1.00 0 0 0 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data53.d 15,587 4 3.89 1.02 2,004 1 37,858 0.13
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data54.d 15,547 4 3.96 1.02 2,030 1 38,852 0.16
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data55.d 15,427 4 3.93 1.02 2,184 1 38,295 0.14
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data56.d 15,597 4 4.14 1.02 2,333 1 40,676 0.13
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data6.db 0 0     5 0 0 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data7.db 18 0 6.67 2.50 68 0 533 0.00
APPS_TS_TX_DATA /slot/ems2858/oracle/VIS/db/apps_st/data/tx_data9.db 0 0     8 0 1,125 0.03
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx1.dbf 1 0 10.00 1.00 15 0 10 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx10.db 2 0 5.00 1.00 42 0 129 0.16
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx11.db 29 0 4.83 1.00 72 0 490 1.06
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx12.db 1 0 30.00 1.00 39 0 62 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx13.db 4 0 7.50 1.00 26 0 113 0.09
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx14.db 0 0     18 0 3 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx15.db 3 0 6.67 1.00 17 0 45 3.78
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx16.db 0 0     31 0 1 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx17.db 2 0 5.00 1.00 20 0 7 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx18.db 19 0 9.47 1.00 90 0 305 0.20
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx19.db 34 0 7.35 1.00 95 0 321 0.06
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx2.dbf 2 0 0.00 1.00 17 0 77 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx20.db 17 0 7.65 1.00 63 0 315 0.03
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx21.db 0 0     73 0 250 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx22.db 50 0 6.20 1.00 151 0 371 0.22
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx23.db 36 0 8.89 1.00 125 0 338 0.06
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx24.db 160 0 7.69 1.00 334 0 752 0.21
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx25.db 2,686 1 3.03 1.36 9,056 2 427,963 0.14
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx26.db 2,675 1 3.10 1.37 9,231 3 428,316 0.10
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx27.db 560 0 5.80 1.04 1,524 0 5,766 0.17
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx28.db 2,582 1 3.01 1.39 9,261 3 429,758 0.17
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx29.db 2,761 1 3.16 1.36 9,195 2 428,542 0.10
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx3.dbf 765 0 4.86 2.22 3,207 1 26,686 0.08
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx4.dbf 0 0     18 0 3 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx5.dbf 20 0 5.50 1.55 102 0 209 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx6.dbf 520 0 4.06 1.00 1,395 0 3,694 0.05
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx7.dbf 0 0     15 0 2 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx8.dbf 9 0 4.44 1.00 47 0 1 0.00
APPS_TS_TX_IDX /slot/ems2858/oracle/VIS/db/apps_st/data/tx_idx9.dbf 26 0 5.00 1.00 100 0 261 0.11
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo.dbf 0 0     8,884 2 227,054 0.03
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo2.dbf 0 0     10,618 3 165,148 0.02
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo3.dbf 0 0     8,989 2 142,720 0.02
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo4.dbf 0 0     8,546 2 149,764 0.02
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo5.dbf 0 0     8,037 2 136,639 0.02
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo6.dbf 0 0     11,066 3 171,231 0.02
APPS_UNDOTS1 /slot/ems2858/oracle/VIS/db/apps_st/data/undo7.dbf 0 0     11,968 3 176,158 0.02
IAS_META /slot/ems2858/oracle/VIS/db/apps_st/data/ias_meta01. 6 0 10.00 1.00 0 0 0 0.00
SYSAUX /slot/ems2858/oracle/VIS/db/apps_st/data/sysaux01.db 232 0 2.76 1.34 502 0 0 0.00
SYSAUX /slot/ems2858/oracle/VIS/db/apps_st/data/sysaux02.db 19 0 0.00 1.00 28 0 0 0.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys1.dbf 134 0 5.22 1.00 89 0 0 0.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys10.dbf 7 0 8.57 1.00 12 0 566 0.04
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys2.dbf 81 0 4.32 1.00 8 0 25 10.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys3.dbf 60 0 4.17 1.00 9 0 24 9.58
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys4.dbf 60 0 4.33 1.00 17 0 1 0.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys5.dbf 43 0 4.88 1.00 10 0 0 0.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys6.dbf 107 0 4.86 1.00 50 0 18 8.33
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys7.dbf 89 0 3.71 1.00 24 0 0 0.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys8.dbf 29 0 5.52 1.10 20 0 0 0.00
SYSTEM /slot/ems2858/oracle/VIS/db/apps_st/data/sys9.dbf 3 0 6.67 1.00 0 0 0 0.00
TEMP2 /slot/ems2858/oracle/VIS/db/apps_st/data/temp2_01.db 0 0     3 0 0  

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,760,705 100 3,607,583,837 206,213 1,515,200 0 0 3,443,253


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 39 260 1331 3188056 113246190 3188056  
E 0 39 247 1335 10207 113246190 10207  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,224 0.10 275,081 1.67 3,332,922
D 4,448 0.20 550,162 1.45 2,893,964
D 6,672 0.30 825,243 1.34 2,679,150
D 8,896 0.40 1,100,324 1.20 2,392,200
D 11,120 0.50 1,375,405 1.07 2,141,055
D 13,344 0.60 1,650,486 1.05 2,092,186
D 15,568 0.70 1,925,567 1.03 2,043,700
D 17,792 0.80 2,200,648 1.01 2,008,073
D 20,016 0.90 2,475,729 1.00 1,993,262
D 22,240 1.00 2,750,810 1.00 1,993,093
D 22,336 1.00 2,762,684 1.00 1,993,093
D 24,464 1.10 3,025,891 1.00 1,993,040
D 26,688 1.19 3,300,972 1.00 1,993,013
D 28,912 1.29 3,576,053 1.00 1,993,013
D 31,136 1.39 3,851,134 1.00 1,993,013
D 33,360 1.49 4,126,215 1.00 1,993,013
D 35,584 1.59 4,401,296 1.00 1,993,013
D 37,808 1.69 4,676,377 1.00 1,993,013
D 40,032 1.79 4,951,458 1.00 1,993,013
D 42,256 1.89 5,226,539 1.00 1,993,013
D 44,480 1.99 5,501,620 1.00 1,990,366

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 24,508 0

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 MemGlobal Mem Bound(K)
B 6,144 5,276 466.80 0.00 0.00 0.00 0.00 629,140
E 6,144 5,274 431.99 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 12,196,955 12,196,955 0 0
64K 128K 58 58 0 0
128K 256K 2 2 0 0
256K 512K 4 4 0 0
512K 1024K 237 237 0 0
1M 2M 79 79 0 0
2M 4M 4 4 0 0
4M 8M 7 7 0 0
8M 16M 27 27 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
768 0.13 72,799.01 1,905.30 97.00 0
1,536 0.25 72,799.01 0.00 100.00 0
3,072 0.50 72,799.01 0.00 100.00 0
4,608 0.75 72,799.01 0.00 100.00 0
6,144 1.00 72,799.01 0.00 100.00 0
7,373 1.20 72,799.01 0.00 100.00 0
8,602 1.40 72,799.01 0.00 100.00 0
9,830 1.60 72,799.01 0.00 100.00 0
11,059 1.80 72,799.01 0.00 100.00 0
12,288 2.00 72,799.01 0.00 100.00 0
18,432 3.00 72,799.01 0.00 100.00 0
24,576 4.00 72,799.01 0.00 100.00 0
36,864 6.00 72,799.01 0.00 100.00 0
49,152 8.00 72,799.01 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
400 0.19 216 10,481 3,179,525 1.00 621 1.04 189,866,063
608 0.29 334 17,574 3,179,546 1.00 600 1.00 189,867,599
816 0.40 334 17,574 3,179,546 1.00 600 1.00 189,867,599
1,024 0.50 334 17,574 3,179,546 1.00 600 1.00 189,867,599
1,232 0.60 334 17,574 3,179,546 1.00 600 1.00 189,867,599
1,440 0.70 334 17,574 3,179,546 1.00 600 1.00 189,867,599
1,648 0.80 334 17,574 3,179,546 1.00 600 1.00 189,867,599
1,856 0.90 334 17,574 3,179,546 1.00 600 1.00 189,867,599
2,064 1.00 334 17,574 3,179,546 1.00 600 1.00 189,867,599
2,272 1.10 334 17,574 3,179,546 1.00 600 1.00 189,867,599
2,480 1.20 334 17,574 3,179,546 1.00 600 1.00 189,867,599
2,688 1.30 334 17,574 3,179,546 1.00 600 1.00 189,867,599
2,896 1.40 334 17,574 3,179,546 1.00 600 1.00 189,867,599
3,104 1.50 334 17,574 3,179,546 1.00 600 1.00 189,867,599
3,312 1.60 334 17,574 3,179,546 1.00 600 1.00 189,867,599
3,520 1.71 334 17,574 3,179,546 1.00 600 1.00 189,867,599
3,728 1.81 334 17,574 3,179,546 1.00 600 1.00 189,867,599
3,936 1.91 334 17,574 3,179,546 1.00 600 1.00 189,867,599
4,144 2.01 334 17,574 3,179,546 1.00 600 1.00 189,867,599

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
6,144 0.25 49,146 2,893,939
12,288 0.50 46,157 2,141,156
18,432 0.75 45,628 2,008,019
24,576 1.00 45,569 1,993,071
30,720 1.25 45,569 1,993,071
36,864 1.50 45,569 1,993,071
43,008 1.75 45,569 1,993,071
49,152 2.00 45,560 1,990,480

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
32 0.33 5 206 4 1.00 600 1.00 138
48 0.50 5 206 4 1.00 600 1.00 138
64 0.67 5 206 4 1.00 600 1.00 138
80 0.83 5 206 4 1.00 600 1.00 138
96 1.00 5 206 4 1.00 600 1.00 138
112 1.17 5 206 4 1.00 600 1.00 138
128 1.33 5 206 4 1.00 600 1.00 138
144 1.50 5 206 4 1.00 600 1.00 138
160 1.67 5 206 4 1.00 600 1.00 138
176 1.83 5 206 4 1.00 600 1.00 138
192 2.00 5 206 4 1.00 600 1.00 138
208 2.17 5 206 4 1.00 600 1.00 138

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 2,270,839 299 0
undo block 1,086,433 20 0
undo header 82,291 3 0
1st level bmb 1,916 0 0
segment header 1,526 0 0
2nd level bmb 58 0 4
extent map 37 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
UL-User-defined 76,802 75,500 1,302 43,000 761 17.70
TX-Transaction (index contention) 277,091 277,091 0 276,268 301 1.09
TX-Transaction (row lock contention) 5,206 4,996 210 4,990 5 0.92
HW-Segment High Water Mark 24,165 24,164 1 6,724 3 0.43
SQ-Sequence Cache 21,974 21,974 0 12,199 2 0.14
TX-Transaction 584,486 584,496 0 2,116 1 0.55
TX-Transaction (allocate ITL entry) 280 280 0 278 0 0.29
FB-Format Block 5,421 5,421 0 501 0 0.08
CU-Cursor 772 772 0 1 0 20.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
18 937.26 582,852 1,533 29   0/0 0/0/0/32/441472/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
02-Aug 13:29 41 107 0 1 151 0/0 0/0/0/0/0/0
02-Aug 13:19 48 273 0 1 136 0/0 0/0/0/0/0/0
02-Aug 13:09 143,601 153,384 642 28 121 0/0 0/0/0/0/0/0
02-Aug 12:59 141,835 89,645 1,533 28 119 0/0 0/0/0/1/33920/0
02-Aug 12:49 180,656 53,810 933 28 116 0/0 0/0/0/10/104448/0
02-Aug 12:39 470,961 285,126 324 29 117 0/0 0/0/0/21/303104/0
02-Aug 12:29 115 507 0 3 207 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 3,045 0.00   0 0  
AWR Alerted Metric Element list 32,894 0.00   0 0  
Consistent RBA 290,632 0.23 0.00 0 0  
FOB s.o list latch 8,338 0.10 0.00 0 0  
In memory undo latch 1,035,301,053 2.74 0.01 10 359,547 0.00
JOX SGA heap latch 15 0.00   0 0  
JS queue state obj latch 22,110 0.00   0 0  
JS slv state obj latch 123 0.00   0 0  
KMG MMAN ready and startup request latch 1,228 0.00   0 0  
KTF sga latch 10 0.00   0 1,156 0.00
KWQP Prop Status 443 0.00   0 0  
MQL Tracking Latch 0     0 73 0.00
Memory Management Latch 0     0 1,228 0.00
OS process 1,032 0.00   0 0  
OS process allocation 1,910 0.05 0.00 0 0  
OS process: request allocation 506 0.20 0.00 0 0  
PL/SQL warning settings 7,340,908 0.00   0 0  
SGA IO buffer pool latch 1,276 0.00   0 1,276 0.08
SQL memory manager latch 2 0.00   0 1,228 0.00
SQL memory manager workarea list latch 1,112,480 0.02 0.00 0 0  
Shared B-Tree 2,331 0.00   0 0  
Undo Hint Latch 0     0 6 0.00
active checkpoint queue latch 138,184 0.14 0.00 0 0  
active service list 7,837 0.06 0.20 0 1,357 0.00
begin backup scn array 26 0.00   0 0  
bq:time manger info latch 134 0.00   0 0  
bufq statistics 10 0.00   0 0  
cache buffer handles 232,388,049 4.45 0.00 1 0  
cache buffers chains 7,467,862,754 6.05 0.01 502 14,151,751 18.97
cache buffers lru chain 3,707,869 0.15 0.01 0 30,833,482 0.62
cache table scan latch 7 0.00   0 7 0.00
channel handle pool latch 892 0.22 0.00 0 0  
channel operations parent latch 23,623 0.09 0.00 0 0  
checkpoint queue latch 3,518,795 0.01 0.00 0 1,512,109 0.00
client/application info 2,933 0.00   0 0  
compile environment latch 379,733 0.00   0 0  
dml lock allocation 2,914,708 0.46 0.00 0 0  
dummy allocation 600 0.33 0.00 0 0  
enqueue hash chains 5,484,979 0.64 0.01 0 1,192 0.92
enqueues 1,250,752 0.93 0.01 0 0  
event group latch 250 0.00   0 0  
file cache latch 6,976 0.01 0.00 0 0  
first spare latch 11,273 1.26 0.00 0 0  
global KZLD latch for mem in SGA 205 0.00   0 0  
global ctx hash table latch 855 0.00   0 0  
hash table column usage latch 536 0.19 0.00 0 66,345 0.01
hash table modification latch 83 0.00   0 0  
job workq parent latch 0     0 93 0.00
job_queue_processes parameter latch 105 0.00   0 0  
kks stats 1,197 0.00   0 0  
ksuosstats global area 250 0.40 1.00 0 0  
ktm global data 422 0.00   0 0  
kwqbsn:qsga 2,188 0.00   0 0  
lgwr LWN SCN 291,698 0.37 0.00 0 0  
library cache 1,680,446,175 4.98 0.00 5 0  
library cache load lock 2,351 1.79 0.00 0 15 0.00
library cache lock 307,828,192 1.61 0.00 0 0  
library cache lock allocation 21,814 0.01 0.00 0 0  
library cache pin 962,097,756 1.63 0.00 2 69 0.00
library cache pin allocation 10,941 0.01 0.00 0 0  
list of block allocation 345,075 0.01 0.00 0 0  
loader state object freelist 466 0.86 0.00 0 0  
logminer context allocation 2 0.00   0 0  
message pool operations parent latch 770 0.39 0.00 0 0  
messages 1,108,300 0.05 0.00 0 0  
mostly latch-free SCN 326,417 9.40 0.00 0 0  
multiblock read objects 2,962 0.00   0 0  
ncodef allocation latch 188 0.00   0 0  
object queue header heap 554,302 0.00   0 34,412 0.00
object queue header operation 8,580,874 0.02 0.01 0 0  
object stats modification 642 0.31 0.00 0 0  
parallel query alloc buffer 472 0.00   0 0  
parameter list 661 0.00   0 0  
parameter table allocation management 327 0.31 0.00 0 0  
post/wait queue 327,617 0.03 0.01 0 158,576 0.02
process allocation 506 2.17 0.91 0 248 0.81
process group creation 506 0.00   0 0  
qmn state object latch 3 0.00   0 0  
qmn task queue latch 3,578 12.16 0.00 0 0  
redo allocation 1,856,047 3.41 0.02 0 64,565,739 2.06
redo copy 0     0 64,655,994 0.04
redo writing 1,187,871 0.01 0.00 0 0  
resmgr group change latch 1,251 0.00   0 0  
resmgr:actses active list 797 1.51 0.33 0 0  
resmgr:actses change group 627 0.00   0 0  
resmgr:free threads list 591 0.51 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 4,275,651 2.03 0.00 0 0  
rules engine rule set statistics 200 0.00   0 0  
sequence cache 29,284,497 2.59 0.00 0 0  
session allocation 22,765,061 4.41 0.00 0 0  
session idle bit 46,867,365 0.05 0.01 0 0  
session state list latch 1,427 1.68 0.25 0 0  
session switching 188 0.00   0 0  
session timer 1,357 0.00   0 0  
shared pool 6,881,195 0.07 0.01 0 0  
shared pool sim alloc 47 6.38 0.00 0 0  
shared pool simulator 3,217,468 0.00 0.00 0 0  
simulator hash latch 317,039,017 0.01 0.00 0 0  
simulator lru latch 316,810,433 4.49 0.00 2 76,778 0.05
slave class 6 0.00   0 0  
slave class create 21 4.76 1.00 0 0  
sort extent pool 2,947 0.58 0.00 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 384 0.78 0.00 0 0  
threshold alerts latch 996 0.00   0 0  
transaction allocation 74,708 0.00   0 0  
transaction branch allocation 188 0.00   0 0  
undo global data 1,214,213,268 0.61 0.00 1 40,063 0.03
user lock 852 1.29 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 7,467,862,754 451,674,269 5,402,465 446,742,615 0 0 0
library cache 1,680,446,175 83,693,871 56,787 83,646,746 0 0 0
In memory undo latch 1,035,301,053 28,382,058 147,470 28,258,911 0 0 0
library cache pin 962,097,756 15,707,657 18,224 15,692,561 0 0 0
simulator lru latch 316,810,433 14,215,988 27,013 14,193,333 0 0 0
cache buffer handles 232,388,049 10,347,710 5,803 10,342,769 0 0 0
undo global data 1,214,213,268 7,438,974 11,858 7,429,960 0 0 0
library cache lock 307,828,192 4,959,134 1,414 4,957,898 0 0 0
session allocation 22,765,061 1,004,705 1,074 1,003,765 0 0 0
sequence cache 29,284,497 757,528 1,093 756,683 0 0 0
row cache objects 4,275,651 86,806 11 86,795 0 0 0
redo allocation 1,856,047 63,271 1,108 62,403 0 0 0
simulator hash latch 317,039,017 41,608 102 41,527 0 0 0
enqueue hash chains 5,484,979 35,044 303 34,750 0 0 0
session idle bit 46,867,365 23,924 164 23,807 0 0 0
dml lock allocation 2,914,708 13,358 15 13,345 0 0 0
enqueues 1,250,752 11,615 109 11,508 0 0 0
cache buffers lru chain 3,707,869 5,461 65 5,399 0 0 0
shared pool 6,881,195 4,817 50 4,780 0 0 0
object queue header operation 8,580,874 1,716 11 1,706 0 0 0
messages 1,108,300 533 1 532 0 0 0
qmn task queue latch 3,578 435 1 434 0 0 0
checkpoint queue latch 3,518,795 235 1 234 0 0 0
post/wait queue 327,617 87 1 86 0 0 0
session state list latch 1,427 24 6 18 0 0 0
resmgr:actses active list 797 12 4 8 0 0 0
process allocation 506 11 10 1 0 0 0
active service list 7,837 5 1 4 0 0 0
ksuosstats global area 250 1 1 0 0 0 0
slave class create 21 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 70,471 35,814
In memory undo latch kturbk 0 58,312 73,542
In memory undo latch ktichg: child 0 11,239 35,995
In memory undo latch kticmt: child 0 6,209 152
In memory undo latch ktiTxnPoolFree 0 967 50
In memory undo latch ktbgfc 0 263 1,917
In memory undo latch ktiBRacquire 0 9 0
active service list ksws_event: ksws event 0 3 0
cache buffer handles kcbzgs 0 3,861 3,638
cache buffer handles kcbzfs 0 1,942 2,165
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 10,231,772 10,823,174
cache buffers chains kcbchg: kslbegin: call CR func 0 4,084,082 8,160,320
cache buffers chains kcbgtcr: fast path 0 3,985,569 131,822
cache buffers chains kcbgtcr: kslbegin excl 0 508,151 155,211
cache buffers chains kcbget: pin buffer 0 387,326 120,077
cache buffers chains kcbzwb 0 126,423 44,583
cache buffers chains kcbrls: kslbegin 0 111,968 205,643
cache buffers chains kcbgcur: kslbegin 0 92,001 28,016
cache buffers chains kcbzgb: scan from tail. nowait 0 33,051 0
cache buffers chains kcbcge 0 26,475 56,393
cache buffers chains kcbnlc 0 3,001 5,269
cache buffers chains kcb_is_private 0 1,637 7,161
cache buffers chains kcb_post_apply: kcbhq62 0 1,112 1,253
cache buffers chains kcbget: exchange rls 0 958 953
cache buffers chains kcb_pre_apply: kcbhq61 0 883 10,690
cache buffers chains kcbget: exchange 0 627 1,911
cache buffers chains kcbesc: escalate 0 310 110
cache buffers chains kcb_post_apply: kcbhq63 0 157 848
cache buffers chains kcbso1: set no access 0 89 64
cache buffers chains kcbnew: new latch again 0 24 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 9 0
cache buffers chains kcbgtcr: kslbegin shared 0 4 4
cache buffers lru chain kcbzgws 0 47 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 16 0
cache buffers lru chain kcbbic2 0 1 41
cache buffers lru chain kcbbxsv: move to being written 0 1 12
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 1 0
dml lock allocation ktaiam 0 11 7
dml lock allocation ktaidm 0 4 8
enqueue hash chains ksqrcl 0 129 44
enqueue hash chains ksqcmi: get hash chain latch after wait 0 85 189
enqueue hash chains ksqgtl3 0 84 69
enqueue hash chains ksqcnl 0 3 1
enqueue hash chains ksqcmi: if deadlock detected 0 1 0
enqueue hash chains ksqcmi: kslgpl 0 1 0
enqueues ksqdel 0 70 60
enqueues ksqgel: create enqueue 0 37 45
enqueues ksqies 0 2 4
event range base latch No latch 0 1 1
ksuosstats global area ksugetosstat 0 1 1
library cache kglpndl: child: after processing 0 15,143 1,605
library cache kglpnc: child 0 11,253 17,952
library cache kglpndl: child: before processing 0 11,077 19,292
library cache kglpin: child: heap processing 0 8,064 3,952
library cache kglpnp: child 0 5,961 7,818
library cache kglhdgc: child: 0 3,132 4,507
library cache kglobpn: child: 0 974 1,227
library cache kglScanDependency 0 32 0
library cache kgldte: child 0 0 25 14
library cache kglpin 0 18 7
library cache kglic 0 4 0
library cache kgldti: 2child 0 2 1
library cache kglhdgn: child: 0 2 4
library cache kglLockCursor 0 1 3
library cache lock kgllkdl: child: no lock handle 0 1,099 405
library cache lock kgllkdl: child: cleanup 0 727 795
library cache lock kgllkal: child: multiinstance 0 687 619
library cache pin kglpndl 0 7,886 7,399
library cache pin kglpnc: child 0 5,811 6,131
library cache pin kglpnp: child 0 2,998 2,987
library cache pin kglpnal: child: alloc space 0 1,529 1,707
messages ksaamb: after wakeup 0 1 0
object queue header operation kcbo_switch_cq 0 6 3
object queue header operation kcbw_link_q 0 4 4
object queue header operation kcbw_unlink_q 0 3 2
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 10 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 882 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 177 864
redo allocation kcrfw_redo_gen: redo allocation 2 0 35 0
redo allocation kcrfw_redo_write: more space 0 9 129
redo allocation kcrfw_redo_write: before write 0 5 115
resmgr:actses active list kgskchclass 0 4 4
row cache objects kqreqd: reget 0 5 1
row cache objects kqreqd 0 3 2
row cache objects kqrpre: find obj 0 3 8
sequence cache kdnnxt: cached seq 0 520 20
sequence cache kdnssd 0 383 18
sequence cache kdnss 0 190 1,055
session allocation ksuprc 0 681 610
session allocation ksudlc 0 380 460
session allocation ksuxds: not user session 0 8 1
session allocation ksucri 0 5 3
session idle bit ksupuc: set busy 0 88 46
session idle bit ksupuc: clear busy 0 82 126
session idle bit ksuxds 0 2 0
session state list latch kpscad 0 3 3
session state list latch kpseqd 0 3 0
shared pool kghupr1 0 34 42
shared pool kghalo 0 11 2
shared pool kghfre 0 5 5
simulator hash latch kcbsacc: lookup dba 0 100 99
simulator hash latch kcbs_lookup_setid: lookup dba 0 2 0
simulator lru latch kcbs_simulate: simulate set 0 26,979 26,763
simulator lru latch kcbs_simbufseq 0 34 250
slave class create ksvcreate 0 1 0
undo global data kturimugur: child 0 9,315 4,075
undo global data ktudba: KSLBEGIN 0 2,503 7,767
undo global data ktusmupst: KSLBEGIN 0 17 0
undo global data ktusmasp: ktugd_tuux 0 15 2
undo global data ktudnx:child 0 6 14
undo global data ktubnd:child 0 1 0
undo global data ktufrbs: child 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 301,389,584 8.32
HR APPS_TS_TX_IDX PAY_PAYROLL_ACTIONS_PK   INDEX 283,154,944 7.82
HR APPS_TS_TX_IDX PAY_RUN_RESULTS_N50   INDEX 180,052,368 4.97
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 171,493,680 4.73
HR APPS_TS_TX_DATA PAY_PAYROLL_ACTIONS   TABLE 141,451,136 3.90

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HR APPS_TS_TX_DATA PAY_ACTION_INFORMATION   TABLE 142,337 69.02
HR APPS_TS_TX_DATA PAY_RUN_BALANCES   TABLE 20,331 9.86
HR APPS_TS_TX_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 3,939 1.91
HR APPS_TS_TX_DATA PAY_RUN_RESULT_VALUES   TABLE 3,918 1.90
HR APPS_TS_TX_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 3,798 1.84

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 42,963 14.89
HR APPS_TS_TX_IDX PAY_COSTS_FK2   INDEX 35,394 12.27
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 28,205 9.77
HR APPS_TS_TX_IDX PAY_COSTS_FK1   INDEX 25,284 8.76
HR APPS_TS_TX_IDX PAY_COSTS_PK   INDEX 20,101 6.97

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N51   INDEX 256 91.43
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N2   INDEX 19 6.79
HR APPS_TS_TX_IDX PAY_COSTS_FK1   INDEX 3 1.07
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_FK2   INDEX 2 0.71

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 439,453 19.57
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 209,403 9.33
HR APPS_TS_TX_DATA PAY_POPULATION_RANGES   TABLE 178,055 7.93
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 156,910 6.99
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 149,767 6.67

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 70 0.00 0   4 10
dc_global_oids 11,260 0.01 0   0 74
dc_histogram_data 1,697 0.00 0   0 241
dc_histogram_defs 11,162 0.79 0   0 36,558
dc_object_grants 495 0.00 0   0 152
dc_object_ids 111,744 0.02 0   0 6,492
dc_objects 3,143 3.31 0   0 7,352
dc_profiles 218 0.00 0   0 1
dc_rollback_segments 10,592 0.00 0   0 81
dc_segments 26,319 0.08 0   4,928 6,894
dc_sequences 9,763 0.02 0   9,763 32
dc_tablespace_quotas 4,909 0.02 0   0 5
dc_tablespaces 656,337 0.00 0   0 83
dc_usernames 2,619 0.00 0   0 43
dc_users 568,723 0.00 0   0 75
kqlsubheap_object 38 0.00 0   0 3
outstanding_alerts 435 0.00 0   0 55


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 6,372 0.31 41,339,345 -0.05 0 0
CLUSTER 14 0.00 19 0.00 0 0
INDEX 2 0.00 26 0.00 0 0
JAVA DATA 1 0.00 0   0 0
PIPE 1,101 0.00 1,101 0.00 0 0
SQL AREA 296 82.77 382,835,053 -0.18 345 0
TABLE/PROCEDURE 8,338 0.89 51,208,555 -0.01 0 0
TRIGGER 642 0.00 5,403,029 -0.06 0 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 353.87   1.81 1.65 22 31 195 195
  Freeable 75.13 0.00 1.02 1.85 10   74 74
  SQL 22.04 12.03 0.12 0.16 2 3 187 183
  PL/SQL 14.22 5.93 0.07 0.04 0 0 195 195
  JAVA 1.65 1.65 1.65 0.00 2 3 1 1
E Other 327.07   1.73 1.63 22 31 189 189
  Freeable 68.94 0.00 1.00 1.87 10   69 69
  SQL 20.38 10.68 0.11 0.15 2 3 182 179
  PL/SQL 14.02 5.83 0.07 0.04 0 0 189 189
  JAVA 1.65 1.65 1.65 0.00 2 3 1 1

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 23,404,216,320  
Fixed Size 2,119,248  
Redo Buffers 64,987,136  
Variable Size 2,298,481,072  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 87.66 87.66 0.00
java joxlod exec hp 8.04 8.04 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor   21.01  
shared KGLS heap 39.94 40.27 0.82
shared KQR M PO 24.54 24.61 0.26
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 1,459.76 1,423.47 -2.49
shared library cache 38.73 40.34 4.16
shared private strands 22.17 22.17 0.00
shared sql area 40.40 67.82 67.86
streams free memory 31.99 31.99 0.00
  buffer_cache 22,320.00 22,320.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 61.98 61.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 58,625 0 0
QMON Slaves -185,682 -756,709 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 NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
APPLSYS.WF_CONTROL 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber NameIncoming per secondOutgoing per secondSpilled per second
WFBESCL_20553 0 0 0
WFBESCL_20554 0 0 0
WFBESCL_20555 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
APPLSYS.WF_DEFERRED_R 0 0 0 0 0
SYS.ALERT_QUE_R 0 0 0 0 0
APPLSYS.WF_NOTIFICATION_OUT_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_gby_hash_aggregation_enabled FALSE   
_kks_use_mutex_pin FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_system_trig_enabled TRUE   
_trace_files_public TRUE   
background_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_db1/bdump   
compatible 10.2.0.3   
control_files /raw_links/cntrl01.dbf, /raw_links/cntrl02.dbf, /raw_links/cntrl03.dbf   
core_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_db1/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_files 512   
db_name VIS   
dml_locks 10000   
ifile /oracle/db/tech_st/10.2.0/dbs/VIS_db1_ifile.ora   
job_queue_processes 2   
log_buffer 63016960   
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_index_caching 0   
optimizer_index_cost_adj 50   
optimizer_secure_view_merging FALSE   
parallel_max_servers 24   
parallel_min_servers 0   
pga_aggregate_target 6442450944   
plsql_code_type INTERPRETED   
plsql_native_library_dir /oracle/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 25769803776   
shared_pool_reserved_size 104857600   
shared_pool_size 2147483648   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 36000   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_db1/udump   
utl_file_dir /usr/tmp, /usr/tmp, /oracle/db/tech_st/10.2.0/appsutil/outbound/VIS_db1, /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report