WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 210556022 VIS 1 10.2.0.3.0 NO vega7242.cup.hp.com

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 78 23-Aug-08 08:59:51 76 26.9
End Snap: 79 23-Aug-08 09:06:57 75 26.8
Elapsed:   7.10 (mins)    
DB Time:   19.45 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 23,472M 23,472M Std Block Size: 8K
Shared Pool Size: 1,024M 1,024M Log Buffer: 14,312K

Load Profile

  Per Second Per Transaction
Redo size: 1,835,293.25 51,861.16
Logical reads: 268,499.93 7,587.19
Block changes: 11,802.45 333.51
Physical reads: 96.59 2.73
Physical writes: 182.58 5.16
User calls: 2,236.37 63.19
Parses: 1,783.64 50.40
Hard parses: 1.97 0.06
Sorts: 1,668.83 47.16
Logons: 0.25 0.01
Executes: 21,327.55 602.67
Transactions: 35.39  

% Blocks changed per Read: 4.40 Recursive Call %: 95.27
Rollback per transaction %: 0.90 Rows per Sort: 2.27

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.92 Redo NoWait %: 100.00
Buffer Hit %: 99.96 In-memory Sort %: 100.00
Library Hit %: 99.33 Soft Parse %: 99.89
Execute to Parse %: 91.64 Latch Hit %: 96.90
Parse CPU to Parse Elapsd %: 23.33 % Non-Parse CPU: 99.14

Shared Pool Statistics

  Begin End
Memory Usage %: 41.84 46.74
% SQL with executions>1: 52.67 92.13
% Memory for SQL w/exec>1: 61.35 92.18

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   951   81.5  
enq: UL - contention 459 56 123 4.8 Application
read by other session 10,655 45 4 3.9 User I/O
db file sequential read 6,415 30 5 2.6 User I/O
cursor: pin S wait on X 2,851 27 9 2.3 Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 1,130.04 96.86
DB CPU 951.04 81.51
PL/SQL execution elapsed time 349.33 29.94
parse time elapsed 47.50 4.07
hard parse elapsed time 8.44 0.72
PL/SQL compilation elapsed time 2.19 0.19
repeated bind elapsed time 0.69 0.06
inbound PL/SQL rpc elapsed time 0.61 0.05
connection management call elapsed time 0.24 0.02
sequence load elapsed time 0.15 0.01
hard parse (sharing criteria) elapsed time 0.02 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 1,166.73  
background elapsed time 26.38  
background cpu time 4.45  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 20,833 0.00 97 5 1.38
Application 941 1.70 57 60 0.06
Concurrency 229,057 1.08 51 0 15.20
System I/O 15,581 0.00 10 1 1.03
Commit 7,347 0.00 8 1 0.49
Other 7,037 74.46 4 1 0.47
Configuration 923 0.00 1 2 0.06
Network 923,509 0.00 1 0 61.29

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
enq: UL - contention 459 3.49 56 123 0.03
read by other session 10,655 0.00 45 4 0.71
db file sequential read 6,415 0.00 30 5 0.43
cursor: pin S wait on X 2,851 86.53 27 9 0.19
db file scattered read 3,752 0.00 22 6 0.25
library cache load lock 759 0.00 16 21 0.05
log file parallel write 13,677 0.00 9 1 0.91
log file sync 7,347 0.00 8 1 0.49
enq: TX - index contention 2,927 0.00 4 2 0.19
kksfbc child completion 80 77.50 3 39 0.01
buffer busy waits 79,044 0.00 2 0 5.25
latch: cache buffers chains 139,979 0.00 1 0 9.29
enq: HW - contention 631 0.00 1 2 0.04
SQL*Net message to client 892,536 0.00 1 0 59.23
os thread startup 9 0.00 0 39 0.00
control file parallel write 197 0.00 0 2 0.01
enq: TX - contention 342 0.00 0 1 0.02
latch: In memory undo latch 2,607 0.00 0 0 0.17
enq: TX - row lock contention 232 0.00 0 1 0.02
SQL*Net break/reset to client 250 0.00 0 1 0.02
buffer deadlock 5,216 99.27 0 0 0.35
SQL*Net more data from client 29,234 0.00 0 0 1.94
latch free 183 0.00 0 1 0.01
row cache lock 528 0.00 0 0 0.04
wait list latch free 7 0.00 0 11 0.00
enq: TX - allocate ITL entry 12 0.00 0 4 0.00
SQL*Net more data to client 1,739 0.00 0 0 0.12
enq: SQ - contention 280 0.00 0 0 0.02
cursor: mutex S 103 0.00 0 0 0.01
cursor: pin S 760 0.00 0 0 0.05
latch: library cache pin 40 0.00 0 0 0.00
LGWR wait for redo copy 225 0.00 0 0 0.01
control file sequential read 1,707 0.00 0 0 0.11
latch: cache buffers lru chain 6 0.00 0 1 0.00
latch: library cache 104 0.00 0 0 0.01
latch: undo global data 127 0.00 0 0 0.01
enq: FB - contention 35 0.00 0 0 0.00
latch: library cache lock 29 0.00 0 0 0.00
cursor: mutex X 65 0.00 0 0 0.00
latch: session allocation 11 0.00 0 0 0.00
latch: cache buffer handles 39 0.00 0 0 0.00
latch: redo allocation 3 0.00 0 0 0.00
latch: row cache objects 12 0.00 0 0 0.00
latch: object queue header operation 3 0.00 0 0 0.00
direct path write 11 0.00 0 0 0.00
SQL*Net message from client 892,538 0.00 15,561 17 59.23
Streams AQ: waiting for messages in the queue 221 99.10 1,650 7466 0.01
pipe get 300 99.00 1,248 4160 0.02
Streams AQ: waiting for time management or cleanup tasks 2 100.00 490 244816 0.00
PL/SQL lock timer 7 100.00 410 58600 0.00
Streams AQ: qmn coordinator idle wait 187 36.36 409 2189 0.01
Streams AQ: qmn slave idle wait 119 0.00 409 3440 0.01
jobq slave wait 92 100.00 270 2931 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 13,677 0.00 9 1 0.91
os thread startup 9 0.00 0 39 0.00
control file parallel write 197 0.00 0 2 0.01
events in waitclass Other 233 0.00 0 0 0.02
db file sequential read 6 0.00 0 5 0.00
control file sequential read 84 0.00 0 0 0.01
rdbms ipc message 23,522 5.65 3,287 140 1.56
Streams AQ: waiting for time management or cleanup tasks 2 100.00 490 244816 0.00
pmon timer 171 100.00 413 2417 0.01
Streams AQ: qmn coordinator idle wait 187 36.36 409 2189 0.01
Streams AQ: qmn slave idle wait 119 0.00 409 3440 0.01
smon timer 150 0.00 390 2599 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 109,465
IDLE_TIME 229,968
IOWAIT_TIME 5,613
NICE_TIME 0
SYS_TIME 6,048
USER_TIME 102,656
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 418,716
NUM_CPUS 8
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 1,159.70 947.40 39,633 114,264,179
SYS$USERS 7.00 3.60 1,730 62,536
SYS$BACKGROUND 0.00 0.00 6 1,303

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
VIS 19696 9400 229048 5092 0 0 923217 95
SYS$USERS 1143 292 0 0 0 0 32 0
SYS$BACKGROUND 6 3 9 35 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
687 648 9,965 0.07 58.86 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
682 643 9,926 0.07 58.41 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
76 19 40 1.90 6.52 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
56 55 278,573 0.00 4.77 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
52 50 9,948 0.01 4.43 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
31 28 9,998 0.00 2.68 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
29 29 149,471 0.00 2.52 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
27 26 169,955 0.00 2.31 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
25 20 109,979 0.00 2.14 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
25 16 9,870 0.00 2.10 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
24 23 583,708 0.00 2.08 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
20 18 577,042 0.00 1.67 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
19 17 579,790 0.00 1.63 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
18 11 9,987 0.00 1.55 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC...
17 14 9,999 0.00 1.46 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
17 13 9,900 0.00 1.43 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
14 14 424,939 0.00 1.22 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
12 11 9,969 0.00 1.02 36z3h9rgkd8aa PYUSLV begin ...
12 12 9,698 0.00 1.02 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
648 687 9,965 0.07 58.86 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
643 682 9,926 0.06 58.41 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
55 56 278,573 0.00 4.77 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
50 52 9,948 0.00 4.43 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
29 29 149,471 0.00 2.52 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
28 31 9,998 0.00 2.68 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
26 27 169,955 0.00 2.31 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
23 24 583,708 0.00 2.08 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
20 25 109,979 0.00 2.14 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
19 76 40 0.49 6.52 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
18 20 577,042 0.00 1.67 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
17 19 579,790 0.00 1.63 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
16 25 9,870 0.00 2.10 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
14 14 424,939 0.00 1.22 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
14 17 9,999 0.00 1.46 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
13 17 9,900 0.00 1.43 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
12 12 9,698 0.00 1.02 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ...
11 18 9,987 0.00 1.55 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC...
11 12 9,969 0.00 1.02 36z3h9rgkd8aa PYUSLV begin ...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
75,183,470 9,926 7,574.40 65.76 643.39 681.54 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
74,487,350 9,965 7,474.90 65.15 648.38 686.79 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
15,855,193 278,573 56.92 13.87 55.29 55.70 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
7,903,925 149,471 52.88 6.91 29.12 29.43 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
6,410,469 583,708 10.98 5.61 22.54 24.25 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
5,167,888 9,948 519.49 4.52 49.58 51.66 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
4,905,325 577,042 8.50 4.29 17.57 19.53 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
4,889,074 579,790 8.43 4.28 17.40 18.97 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
4,715,479 424,939 11.10 4.12 14.18 14.18 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
4,635,895 40 115,897.38 4.06 19.41 76.08 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
3,626,938 9,998 362.77 3.17 28.48 31.32 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
3,509,878 584,994 6.00 3.07 10.23 10.34 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '...
2,682,774 9,999 268.30 2.35 13.87 17.05 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
2,253,863 9,996 225.48 1.97 5.06 5.25 cj64zg9gg7780 PYUSLV SELECT ACTION_INFORMATION_ID ,...
2,171,603 109,979 19.75 1.90 19.92 24.97 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
1,981,048 9,900 200.11 1.73 13.34 16.68 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
1,955,828 39,947 48.96 1.71 11.18 11.26 f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...
1,846,018 9,926 185.98 1.61 8.44 9.29 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS...
1,773,871 579,479 3.06 1.55 11.28 11.33 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
1,762,630 124,885 14.11 1.54 6.73 7.06 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
1,749,333 573,688 3.05 1.53 8.07 8.56 77d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
1,651,401 169,955 9.72 1.44 26.43 27.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
1,631,697 9,969 163.68 1.43 10.62 11.93 36z3h9rgkd8aa PYUSLV begin ...
1,599,978 9,870 162.11 1.40 15.73 24.53 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
1,498,674 124,656 12.02 1.31 7.22 7.22 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
1,214,961 19,013 63.90 1.06 5.16 5.45 9665ycstch5r4 PYUSLV select /*+ ORDERED USE_NL(AA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
12,865 9,926 1.30 31.28 643.39 681.54 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
12,860 9,965 1.29 31.27 648.38 686.79 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
7,042 1 7,042.00 17.12 5.33 10.72 1knpzqdv410rs PYUSLV select paa.rowid from...
5,584 9,987 0.56 13.58 10.99 18.07 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC...
4,229 109,979 0.04 10.28 19.92 24.97 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
1,151 9,999 0.12 2.80 13.87 17.05 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
1,058 9,900 0.11 2.57 13.34 16.68 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
952 9,870 0.10 2.31 15.73 24.53 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
718 9,948 0.07 1.75 49.58 51.66 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
618 39 15.85 1.50 0.13 9.32 95v6drnuprjn2 PYUSLV select /*+ LEADING(FF) USE_N...
612 344 1.78 1.49 1.00 1.81 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
459 9,999 0.05 1.12 1.57 2.21 fabtaarmf6f4a PYUSLV SELECT /*+ ORDERED */ DISTINCT...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
584,994 584,983 1.00 0.00 0.00 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '...
583,708 1,168,946 2.00 0.00 0.00 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
579,790 583,957 1.01 0.00 0.00 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
579,479 911,229 1.57 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
577,042 581,355 1.01 0.00 0.00 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
573,688 583,303 1.02 0.00 0.00 77d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
424,939 429,445 1.01 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
278,573 276,332 0.99 0.00 0.00 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
169,955 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
149,471 149,031 1.00 0.00 0.00 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
124,885 0 0.00 0.00 0.00 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
124,656 124,989 1.00 0.00 0.00 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
109,979 109,979 1.00 0.00 0.00 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
277,824 278,573 36.58 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
148,929 149,471 19.61 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
79,805 79,809 10.51 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
44,629 44,899 5.88 8a01qnnc9as1r PYUSLV SELECT NVL(SUM(prb.balance_val...
29,516 29,977 3.89 264qzrka8fsps PYUSLV SELECT NVL(SUM(prb.balance_val...
19,726 19,824 2.60 83kbt99vg4svq PYUSLV begin ...
9,990 9,948 1.32 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
9,966 9,997 1.31 97mt0g20bcfc3 PYUSLV begin ...
9,907 9,926 1.30 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
9,850 9,978 1.30 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim...
9,848 9,965 1.30 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
9,717 9,969 1.28 36z3h9rgkd8aa PYUSLV begin ...
9,265 9,952 1.22 d7shgtk3p7s4u PYUSLV SELECT /*+ ordered index(BAL...
8,901 8,901 1.17 cr74qtm56vcq6 NACHA BEGIN PAY_US_NACHA_TAPE.RUN_FO...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
02k10jzw8c495 SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
165d2bgc2b9hr SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment within a Government Reporting Entity for YTD based on run balances */ pay_run_balances prb, pay_defined_balances pdb, pay_payroll_actions ppa, pay_assignment_actions paa where paa.assignment_action_id = :ASSIGNMENT_ACTION_ID and prb.tax_unit_id = :TAX_UNIT_ID and ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id and paa.assignment_id = prb.assignment_id and prb.action_sequence <= paa.action_sequence and prb.effective_date >= trunc(ppa.effective_date, 'Y')
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
264qzrka8fsps SELECT NVL(SUM(prb.balance_value), 0) FROM /* US Assignment for Run based on run balances */ pay_run_balances prb, pay_defined_balances pdb where prb.assignment_action_id = :ASSIGNMENT_ACTION_ID and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id
2z261p0p82p32 BEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I12, :T3, :I3, :T8, :I14, :N6, :I10, :T7, :I13, :N4, :I8, :D1, :N12, :I18, :N10, :I16, :N7, :I11, :N11, :I17, :T6, :I6, :N1, :T2, :I2, :N5, :I9, :N9, :I15, :FFERLN, :FFERCD, :FFERMT); END;
36z3h9rgkd8aa begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3n5uwzsh3y8gr SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S ', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2
3rg5fyfgd5uwc begin pay_US_rules.get_time_def_for_entry( :element_entry_id, :assignment_id, :assignment_action_id, :business_group_id, :time_def_id); end;
4ds53shhfcynn declare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3u declare begin pay_archive.process_employee(:asg_action); end;
4gz4b2bh1fs14 SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
5sfm6rppc4y8x BEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
5w5up6vdp2qyp SELECT RP.SEQUENCE_NO, RPV.VALUE FROM FF_ROUTE_PARAMETER_VALUES RPV , FF_ROUTE_PARAMETERS RP WHERE RPV.USER_ENTITY_ID = :B2 AND RP.ROUTE_ID = :B1 AND RPV.ROUTE_PARAMETER_ID = RP.ROUTE_PARAMETER_ID ORDER BY RP.SEQUENCE_NO
6500rnmy4f88w SELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE
6v07302134wyf INSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
77d28bpwm9svg SELECT PBV.RUN_BALANCE_STATUS, PBV.BALANCE_LOAD_DATE FROM PAY_BALANCE_VALIDATION PBV WHERE PBV.DEFINED_BALANCE_ID = :B2 AND PBV.BUSINESS_GROUP_ID = :B1
7d66dw0vz7yaa begin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7mmdd7sypzu9x BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N5, :T4, :I4, :N4, :N3, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
83kbt99vg4svq begin hr_nonrun_asact.reinterlock (:assactid, :pactype); end;
8a01qnnc9as1r SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment in JD Government Reporting Entity for YTD based on run balances */ pay_balance_types pbt, 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 pbt.balance_type_id = :U1 and pdb.balance_type_id = pbt.balance_type_id 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') and substr(prb.jurisdiction_code, 1, pbt.jurisdiction_level) = substr(:JURISDICTION_CODE, 1, pbt.jurisdiction_level)
95v6drnuprjn2 select /*+ LEADING(FF) USE_NL(FDI) +*/ DEFBAL.defined_balance_id , DEFBAL.balance_type_id , FDI.context_level_sum from pay_defined_balances DEFBAL , ff_database_items DBI , ff_user_entities UE , ff_fdi_usages_f FDI , ff_formulas_f FF where (((((((((((FF.formula_id=:b0 and to_date(:b1, :b2) between FF.effective_start_date and FF.effective_end_date) and FDI.formula_id=FF.formula_id) and to_date(:b1, :b2) between FDI.effective_start_date and FDI.effective_end_date) and FDI.usage='D') and FDI.item_name=DBI.user_name) and DBI.user_entity_id=UE.user_entity_id) and (((UE.legislation_code is null and UE.business_group_id is null ) or (UE.business_group_id is null and UE.legislation_code=:b5)) or UE.business_group_id=:b6)) and not exists (select context_id from ff_route_context_usages IFRCU where IFRCU.route_id=UE.route_id minus select context_id from ff_ftype_context_usages where formula_type_id=FF.formula_type_id)) and UE.creator_type='B') and UE.creator_id=DEFBAL.defined_balance_id) and (((DEFBAL.legislation_code is null and DEFBAL.business_group_id is null ) or (DEFBAL.business_group_id is null and DEFBAL.legislation_code=:b5)) or DEFBAL.business_group_id=:b6)) order by DEFBAL.balance_type_id
9665ycstch5r4 select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , nvl(EE.creator_type, 'X') , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned))), 'YYYY/MM/DD') , EL2.transfer_to_gl_flag , decode(:b3, null , null , hr_cost.get_context_value(:b3, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b5, null , null , hr_cost.get_context_value(:b5, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b7, null , null , hr_cost. get_context_value(:b7, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b9, null , null , hr_cost.get_context_value(:b9, RR.run_result_id, RR.element_type_id, PA.date_earned)) from pay_assignment_actions AA , pay_payroll_actions PA , per_all_assignments_f PERA , pay_run_results RR , pay_element_entries_f EE , pay_element_types_f ET , pay_element_classifications EC , fnd_currencies FC , pay_input_values_f IV , pay_run_result_values RRV , pay_link_input_values_f LIV , pay_element_links_f EL , pay_element_links_f EL2 where ((((((((((((((((((((((((((((((AA.assignment_action_id=:b11 and AA.payroll_action_id=PA.payroll_action_id) and RR.assignment_action_id=:b11) and RR.status like 'P%') and RR.element_type_id=ET.element_type_id) and RRV.run_result_id=RR.run_result_id) and IV.input_value_id=RRV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between IV.effective_start_date and IV.effective_end_date) and IV.element_type_id=ET.element_type_id) and RRV.result_value is not null ) and (decode(:b13, 'Y', 1, fnd_number.canonical_to_number(RRV.result_value))+decode(LIV.DEFAULT_VALUE, 'M', 0, 0))<>0) and RRV.input_value_id=LIV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between LIV.effective_start_date and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_i d=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_type<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) order by 17, 8, 14
97mt0g20bcfc3 begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9jv68n0ctas75 begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
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
cj64zg9gg7780 SELECT 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
cn5un9cxnah8w SELECT NVL(PBD.PERIOD_TYPE, 'NULL'), PBD.START_DATE_CODE FROM PAY_BALANCE_DIMENSIONS PBD, PAY_DEFINED_BALANCES PDB WHERE PDB.DEFINED_BALANCE_ID = :B1 AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
cr74qtm56vcq6 BEGIN PAY_US_NACHA_TAPE.RUN_FORMULA; END;
cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
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;
f78ff26qcfjan update PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S')
fabtaarmf6f4a SELECT /*+ ORDERED */ DISTINCT 'Y' , 'FF ROUTE:USER_TIME' FROM PAY_ELEMENT_ENTRIES_F EE, PAY_ELEMENT_LINKS_F EL, PAY_ELEMENT_TYPES_F ET, PAY_ELEMENT_CLASSIFICATIONS EC, HR_LOOKUPS HL2 WHERE :B2 BETWEEN EE.EFFECTIVE_START_DATE AND EE.EFFECTIVE_END_DATE AND EE.ASSIGNMENT_ID = :B3 AND EL.ELEMENT_LINK_ID = EE.ELEMENT_LINK_ID AND :B2 BETWEEN EL.EFFECTIVE_START_DATE AND EL.EFFECTIVE_END_DATE AND ET.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID AND :B2 BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE AND NVL(ET.BUSINESS_GROUP_ID, :B1 ) = :B1 AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID AND EC.CLASSIFICATION_NAME IN ('Earnings', 'Supplemental Earnings') AND EC.BUSINESS_GROUP_ID IS NULL AND ET.ELEMENT_INFORMATION9 = 'T' AND HL2.LOOKUP_CODE = ET.ELEMENT_INFORMATION1 AND HL2.LOOKUP_TYPE IN ('US_EARNINGS', 'CA_REGULAR_EARNINGS', 'CA_SUPPLEMENTAL_EARNINGS') AND HL2.LOOKUP_CODE = DECODE(EC.LEGISLATION_CODE, 'US', 'REG', ET.ELEMENT_INFORMATION1)
fdv98jawj03hg SELECT FUE.USER_ENTITY_NAME , NVL(FUE.BUSINESS_GROUP_ID, -1) , NVL(FUE.LEGISLATION_CODE, ' ') FROM FF_USER_ENTITIES FUE , FF_USER_ENTITIES FUE_B WHERE FUE.CREATOR_ID = :B2 AND FUE_B.CREATOR_TYPE = 'B' AND FUE.CREATOR_ID = FUE_B.CREATOR_ID AND FUE.CREATOR_TYPE = 'RB' AND FUE.USER_ENTITY_NAME = FUE_B.USER_ENTITY_NAME||'_'||TO_CHAR(:B1 )
fnnymj5r1f0n8 SELECT PBG.LEGISLATION_CODE FROM PER_BUSINESS_GROUPS PBG WHERE PBG.BUSINESS_GROUP_ID = :B1
g3835fnqtvy06 SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_balance_types pbt , 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_dimension_id = :U2 and pbt.balance_type_id = :U1 and pdb.balance_type_id = pbt.balance_type_id and substr(prb.jurisdiction_code, 1, pbt.jurisdiction_level) = substr(:JURISDICTION_CODE, 1, pbt.jurisdiction_level)
g4jp561h1bs98 select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id , to_char(null ) , PEPD.time_definition_id , nvl(ET.time_definition_type, 'N') , to_char(decode(ET.processing_type, 'R', to_date(null , :b1), EE.date_earned), :b1) , decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ) , decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ) , EE.label_identifier , decode(ACT.action_status, 'B', decode(EE.creator_type, 'EE', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b10, :b11:b12, EE.creator_id, ACT.act ion_sequence), 'RR', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b14, :b11:b16, EE.creator_id, ACT.action_sequence), 1), 1) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'AE', to_char(EE.source_start_date, :b1), 'AD', to_char(EE.source_start_date, :b1), null ) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'AE', to_char(EE.source_end_date, :b1), 'AD', to_char(EE.source_end_date, :b1), null ) from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where (((((((((((((((ACT.assignment_action_id=:b29 and EE.assignment_id=:b30) and ((:b31='N' and to_date(:b32, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b31='Y' and EE.effective_start_date<=to_date(:b32, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , decode(nvl(ET.time_definition_type, 'N'), 'N', to_date(:b32, :b1), pay_core_utils.get_time_period_start(ACT.payroll_action_id)), pay_interpreter_pkg.prorate_start_date(:b29, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b32, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.elem ent_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b31='N' or ET.proration_group_id is null ) or (:b31='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b32, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ((((ET.processing_type='N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b32, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
g6tx1p7d69dxg SELECT ENT.USER_ENTITY_ID, ENT.CREATOR_TYPE, ENT.NOTFOUND_ALLOWED_FLAG, RO.ROUTE_ID, RO.TEXT, RO.OPTIMIZER_HINT FROM FF_USER_ENTITIES ENT , FF_ROUTES RO WHERE ENT.USER_ENTITY_NAME = :B3 AND ( (ENT.LEGISLATION_CODE IS NULL AND ENT.BUSINESS_GROUP_ID IS NULL) OR (ENT.BUSINESS_GROUP_ID IS NULL AND :B2 = ENT.LEGISLATION_CODE ) OR ENT.BUSINESS_GROUP_ID + 0 = :B1 ) AND ENT.ROUTE_ID = RO.ROUTE_ID
gq04p7vgjcmkg SELECT PPT.CATEGORY CATEGORY, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_METHOD, PEA.PRENOTE_DATE PRENOTE_DATE, PPT.VALIDATION_DAYS VALID_DAYS, PPM.PERCENTAGE PERCENTAGE, PPM.AMOUNT AMOUNT, OPM.ORG_PAYMENT_METHOD_ID ORG_METHOD, HR_PRE_PAY.SET_CASH_RULE(PPT.CATEGORY, OPM.PMETH_INFORMATION1) CASH_RULE, OPM.CURRENCY_CODE PAYMENT_CURRENCY, PPT.PRE_VALIDATION_REQUIRED VALIDATION_REQUIRED, PPT.VALIDATION_VALUE VALIDATION_VALUE, OPM.EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID FROM PAY_EXTERNAL_ACCOUNTS PEA, PAY_PAYMENT_TYPES PPT, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_ASSIGNMENT_ACTIONS ACT WHERE ACT.ASSIGNMENT_ACTION_ID=:B4 AND PPM.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PPM.RUN_TYPE_ID = :B3 AND PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND OPM.DEFINED_BALANCE_ID = :B2 AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN PPM.EFFECTIVE_START_DATE AND PPM.EFFECTIVE_END_DATE AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE ORDER BY PPM.PERSON_ID, PPM.PRIORITY
gxa19cf01sb0c SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, PTS.MEANING, PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS WHERE PTS.ASSIGNMENT_ID = :B2 AND PTS.JURISDICTION_CODE LIKE :B1

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 97,223 228.34 6.45
CPU used when call started 97,133 228.13 6.45
CR blocks created 563,784 1,324.10 37.42
Cached Commit SCN referenced 962,532 2,260.60 63.88
Commit SCN cached 5,407 12.70 0.36
DB time 481,245 1,130.25 31.94
DBWR checkpoint buffers written 77,725 182.54 5.16
DBWR checkpoints 0 0.00 0.00
DBWR thread checkpoint buffers written 77,702 182.49 5.16
DBWR transaction table writes 437 1.03 0.03
DBWR undo block writes 40,354 94.78 2.68
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 12,309,599 28,910.23 816.94
IMU Flushes 8,190 19.23 0.54
IMU Redo allocation size 150,377,136 353,174.56 9,979.90
IMU commits 7,066 16.60 0.47
IMU contention 3,447 8.10 0.23
IMU ktichg flush 77 0.18 0.01
IMU recursive-transaction flush 238 0.56 0.02
IMU undo allocation size 225,607,696 529,860.46 14,972.64
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded 50 to 75 pct 0 0.00 0.00
SQL*Net roundtrips to/from client 892,276 2,095.59 59.22
active txn count during cleanout 2,232,975 5,244.35 148.19
application wait time 5,688 13.36 0.38
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 1,355 3.18 0.09
branch node splits 51 0.12 0.00
buffer is not pinned count 52,665,963 123,690.87 3,495.22
buffer is pinned count 38,352,765 90,075.00 2,545.31
bytes received via SQL*Net from client 235,003,338 551,926.99 15,596.19
bytes sent via SQL*Net to client 135,518,950 318,278.74 8,993.82
calls to get snapshot scn: kcmgss 9,790,883 22,994.79 649.78
calls to kcmgas 633,143 1,486.99 42.02
calls to kcmgcs 13,150 30.88 0.87
change write time 1,125 2.64 0.07
cleanout - number of ktugct calls 582,113 1,367.15 38.63
cleanouts and rollbacks - consistent read gets 540,204 1,268.72 35.85
cleanouts only - consistent read gets 10,615 24.93 0.70
cluster key scan block gets 8,480 19.92 0.56
cluster key scans 4,193 9.85 0.28
commit batch/immediate performed 548 1.29 0.04
commit batch/immediate requested 548 1.29 0.04
commit cleanout failures: block lost 154 0.36 0.01
commit cleanout failures: buffer being written 37 0.09 0.00
commit cleanout failures: callback failure 11,391 26.75 0.76
commit cleanout failures: cannot pin 2,313 5.43 0.15
commit cleanouts 174,352 409.48 11.57
commit cleanouts successfully completed 160,457 376.85 10.65
commit immediate performed 548 1.29 0.04
commit immediate requested 548 1.29 0.04
commit txn count during cleanout 49,169 115.48 3.26
concurrency wait time 5,127 12.04 0.34
consistent changes 32,567,333 76,487.38 2,161.36
consistent gets 108,481,740 254,779.36 7,199.48
consistent gets - examination 76,197,128 178,955.98 5,056.88
consistent gets from cache 108,481,740 254,779.36 7,199.48
cursor authentications 665 1.56 0.04
data blocks consistent reads - undo records applied 32,527,923 76,394.82 2,158.74
db block changes 5,025,329 11,802.45 333.51
db block gets 5,842,040 13,720.57 387.71
db block gets direct 17 0.04 0.00
db block gets from cache 5,842,023 13,720.53 387.71
deferred (CURRENT) block cleanout applications 23,733 55.74 1.58
enqueue conversions 3,136 7.37 0.21
enqueue releases 104,638 245.75 6.94
enqueue requests 104,806 246.15 6.96
enqueue timeouts 168 0.39 0.01
enqueue waits 3,921 9.21 0.26
exchange deadlocks 5,216 12.25 0.35
execute count 9,080,995 21,327.55 602.67
failed probes on index block reclamation 14 0.03 0.00
free buffer inspected 40,920 96.10 2.72
free buffer requested 684,144 1,606.78 45.40
heap block compress 21,552 50.62 1.43
immediate (CR) block cleanout applications 550,819 1,293.65 36.56
immediate (CURRENT) block cleanout applications 29,920 70.27 1.99
index crx upgrade (found) 38,785 91.09 2.57
index crx upgrade (positioned) 661,941 1,554.63 43.93
index fetch by key 15,355,411 36,063.60 1,019.07
index scans kdiixs1 11,713,920 27,511.22 777.40
leaf node 90-10 splits 1,450 3.41 0.10
leaf node splits 8,194 19.24 0.54
lob reads 0 0.00 0.00
lob writes 33 0.08 0.00
lob writes unaligned 33 0.08 0.00
logons cumulative 106 0.25 0.01
messages received 24,377 57.25 1.62
messages sent 24,377 57.25 1.62
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 29,884,551 70,186.62 1,983.31
opened cursors cumulative 703,766 1,652.86 46.71
parse count (failures) 0 0.00 0.00
parse count (hard) 840 1.97 0.06
parse count (total) 759,451 1,783.64 50.40
parse time cpu 822 1.93 0.05
parse time elapsed 3,524 8.28 0.23
physical read IO requests 9,751 22.90 0.65
physical read bytes 336,896,000 791,231.30 22,358.38
physical read total IO requests 11,717 27.52 0.78
physical read total bytes 366,985,216 861,898.59 24,355.27
physical read total multi block requests 3,737 8.78 0.25
physical reads 41,125 96.59 2.73
physical reads cache 41,125 96.59 2.73
physical reads cache prefetch 31,374 73.68 2.08
physical reads direct 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 30,921 72.62 2.05
physical write IO requests 18,565 43.60 1.23
physical write bytes 636,862,464 1,495,730.17 42,265.89
physical write total IO requests 34,719 81.54 2.30
physical write total bytes 1,459,752,960 3,428,364.32 96,877.69
physical write total multi block requests 25,610 60.15 1.70
physical writes 77,742 182.58 5.16
physical writes direct 17 0.04 0.00
physical writes direct (lob) 17 0.04 0.00
physical writes from cache 77,725 182.54 5.16
physical writes non checkpoint 63,543 149.24 4.22
pinned buffers inspected 6 0.01 0.00
process last non-idle time 427 1.00 0.03
queries parallelized 0 0.00 0.00
recursive calls 19,168,874 45,019.87 1,272.16
recursive cpu usage 83,554 196.23 5.55
redo blocks written 1,588,296 3,730.26 105.41
redo entries 2,534,553 5,952.63 168.21
redo ordering marks 35,576 83.55 2.36
redo size 781,444,008 1,835,293.25 51,861.16
redo subscn max counts 65,731 154.38 4.36
redo synch time 854 2.01 0.06
redo synch writes 6,402 15.04 0.42
redo wastage 5,012,596 11,772.54 332.66
redo write time 995 2.34 0.07
redo writer latching time 0 0.00 0.00
redo writes 13,677 32.12 0.91
rollback changes - undo records applied 2,440 5.73 0.16
rollbacks only - consistent read gets 25,936 60.91 1.72
rows fetched via callback 11,225,751 26,364.71 745.01
session connect time 0 0.00 0.00
session cursor cache hits 748,549 1,758.04 49.68
session logical reads 114,323,780 268,499.93 7,587.19
session pga memory 13,101,376 30,769.79 869.48
session pga memory max 6,958,048 16,341.62 461.78
session uga memory 38,657,051,400 90,789,646.94 2,565,506.46
session uga memory max 337,343,664 792,282.68 22,388.08
shared hash latch upgrades - no wait 751,525 1,765.03 49.88
shared hash latch upgrades - wait 51,144 120.12 3.39
sorts (memory) 710,567 1,668.83 47.16
sorts (rows) 1,616,390 3,796.24 107.27
sql area evicted 0 0.00 0.00
sql area purged 0 0.00 0.00
switch current to new buffer 13,399 31.47 0.89
table fetch by rowid 41,122,526 96,580.04 2,729.13
table fetch continued row 308 0.72 0.02
table scan blocks gotten 985,577 2,314.72 65.41
table scan rows gotten 43,585,551 102,364.68 2,892.59
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 533,523 1,253.03 35.41
total number of times SMON posted 150 0.35 0.01
transaction rollbacks 548 1.29 0.04
undo change vector size 279,587,580 656,637.19 18,555.06
user I/O wait time 9,656 22.68 0.64
user calls 952,217 2,236.37 63.19
user commits 14,933 35.07 0.99
user rollbacks 135 0.32 0.01
workarea executions - optimal 454,758 1,068.04 30.18
write clones created in background 1 0.00 0.00
write clones created in foreground 338 0.79 0.02

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 7,680 13,423
opened cursors current 2,042 2,013
logons current 76 75

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_TS_TX_DATA 3,848 9 5.69 5.43 6,349 15 25,214 0.85
APPS_TS_TX_IDX 2,987 7 6.38 5.40 7,184 17 38,032 0.52
APPS_UNDOTS1 0 0 0.00 0.00 4,359 10 24,783 0.03
SYSTEM 2,362 6 3.41 1.00 265 1 66 1.06
SYSAUX 495 1 3.45 2.10 289 1 0 0.00
APPS_TS_SEED 267 1 6.52 3.68 52 0 1,584 4.59
APPS_TS_ARCHIVE 4 0 5.00 1.00 65 0 13 0.77
APPS_TS_INTERFACE 0 0 0.00 0.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_TS_ARCHIVE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/archive1.dbf 4 0 5.00 1.00 65 0 13 0.77
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 0 0     1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 0 0     1 0 0 0.00
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference1.dbf 38 0 7.63 4.21 3 0 216 6.16
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference2.dbf 31 0 6.45 3.19 6 0 178 5.00
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference3.dbf 22 0 6.36 3.55 4 0 180 4.11
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference4.dbf 38 0 5.79 3.71 9 0 315 2.76
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference5.dbf 138 0 6.45 3.65 30 0 695 4.95
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data1.dbf 1 0 0.00 1.00 0 0 10 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data10.dbf 1 0 0.00 1.00 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data11.dbf 65 0 5.85 5.49 109 0 265 1.13
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data12.dbf 62 0 5.32 5.15 136 0 350 0.89
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data13.dbf 53 0 5.09 5.79 100 0 120 2.83
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data17.dbf 21 0 6.67 5.43 5 0 8 8.75
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data19.dbf 28 0 5.71 5.64 5 0 94 3.72
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data2.dbf 58 0 4.83 5.62 95 0 124 3.06
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data21.dbf 61 0 5.41 5.77 125 0 156 2.88
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data22.dbf 56 0 5.71 5.64 111 0 166 1.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data23.dbf 12 0 3.33 2.75 0 0 42 1.67
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data24.dbf 5 0 6.00 6.00 0 0 23 5.22
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data25.dbf 13 0 4.62 4.00 0 0 21 4.76
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data26.dbf 9 0 5.56 6.67 0 0 25 5.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data27.dbf 41 0 4.39 3.80 61 0 306 2.22
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data28.dbf 49 0 5.31 3.84 62 0 804 1.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data29.dbf 8 0 6.25 5.88 2 0 7 4.29
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data3.dbf 9 0 5.56 6.56 0 0 4 2.50
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data30.dbf 8 0 5.00 6.13 0 0 4 2.50
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data31.dbf 10 0 4.00 4.90 0 0 26 5.38
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data32.dbf 99 0 5.76 5.51 147 0 1,654 0.38
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data33.dbf 6 0 8.33 5.33 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data34.dbf 6 0 5.00 5.50 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data35.dbf 5 0 4.00 6.40 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data36.dbf 5 0 8.00 6.40 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data37.dbf 27 0 6.30 5.33 23 0 1,402 0.30
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data38.dbf 4 0 5.00 4.25 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data39.dbf 91 0 5.05 5.25 165 0 1,979 0.58
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data4.dbf 3 0 0.00 5.33 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data40.dbf 3 0 3.33 5.33 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data41.dbf 26 0 5.77 6.15 23 0 1 10.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data42.dbf 29 0 5.86 5.52 25 0 1 20.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data43.dbf 76 0 6.45 5.67 197 0 402 0.77
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data44.dbf 74 0 7.57 5.59 193 0 226 1.95
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data45.dbf 82 0 6.59 5.44 126 0 224 1.61
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data46.dbf 81 0 5.80 5.57 152 0 210 2.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data47.dbf 85 0 5.41 5.28 124 0 160 2.44
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data48.dbf 74 0 5.00 5.66 137 0 229 0.66
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data49.dbf 84 0 5.48 5.45 100 0 143 2.66
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data5.dbf 2 0 10.00 8.00 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data50.dbf 85 0 4.71 5.45 121 0 238 0.63
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data51.dbf 86 0 4.88 5.59 123 0 279 1.61
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data52.dbf 28 0 4.29 5.71 9 0 2 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data53.dbf 91 0 6.26 5.51 144 0 425 1.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data54.dbf 92 0 5.76 5.51 155 0 474 0.49
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data55.dbf 97 0 6.19 5.28 148 0 497 1.81
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data56.dbf 88 0 6.14 5.82 173 0 586 1.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data57.dbf 87 0 5.17 5.55 149 0 331 1.30
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data58.dbf 88 0 5.45 5.41 168 0 319 1.41
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data59.dbf 85 0 6.24 5.55 171 0 422 1.16
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data6.dbf 1 0 10.00 1.00 0 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data60.dbf 84 0 5.48 5.19 151 0 271 1.07
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data61.dbf 83 0 4.82 5.49 149 0 262 1.72
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data62.dbf 98 0 6.63 5.17 152 0 592 0.84
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data63.dbf 92 0 6.41 5.40 155 0 869 0.38
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data64.dbf 82 0 6.10 5.54 139 0 871 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data65.dbf 91 0 6.04 5.16 134 0 1,094 0.29
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data66.dbf 87 0 5.75 5.48 143 0 470 1.02
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data67.dbf 84 0 6.67 5.15 189 0 246 1.50
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data68.dbf 90 0 6.11 5.36 156 0 458 1.16
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data69.dbf 94 0 5.43 5.56 192 0 565 1.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data7.dbf 2 0 5.00 7.50 6 0 54 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data70.dbf 86 0 4.77 5.38 161 0 437 0.76
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data71.dbf 85 0 5.29 5.47 142 0 553 1.12
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data72.dbf 84 0 5.83 5.40 124 0 275 2.36
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data73.dbf 78 0 5.77 5.77 133 0 438 0.50
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data74.dbf 80 0 5.25 5.80 144 0 865 0.45
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data75.dbf 74 0 6.49 5.68 162 0 1,182 0.45
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data76.dbf 72 0 5.56 5.40 108 0 1,411 0.16
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data77.dbf 72 0 5.28 5.56 120 0 1,316 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data78.dbf 69 0 5.65 5.23 105 0 212 1.98
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data9.dbf 1 0 10.00 1.00 0 0 14 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx1.dbf 46 0 6.74 5.83 126 0 771 0.29
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx10.dbf 52 0 5.58 4.81 104 0 725 0.44
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx11.dbf 44 0 6.59 5.84 109 0 425 0.47
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx12.dbf 47 0 5.74 5.34 122 0 465 0.90
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx13.dbf 50 0 7.00 5.98 146 0 870 0.45
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx14.dbf 43 0 5.81 6.12 112 0 966 0.26
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx15.dbf 46 0 6.09 5.39 146 0 783 0.27
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx16.dbf 49 0 6.53 5.76 142 0 1,071 0.36
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx17.dbf 46 0 6.96 6.46 133 0 1,157 0.36
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx18.dbf 45 0 7.11 5.49 139 0 1,263 0.34
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx19.dbf 43 0 7.67 5.51 152 0 1,361 0.21
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx2.dbf 43 0 6.74 6.02 184 0 1,060 0.13
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx20.dbf 35 0 8.57 6.34 156 0 436 0.25
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx21.dbf 38 0 5.53 6.18 129 0 712 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx22.dbf 39 0 6.41 5.85 106 0 1,226 0.20
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx23.dbf 73 0 6.71 5.03 185 0 470 1.21
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx24.dbf 48 0 5.63 4.54 138 0 660 0.71
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx25.dbf 51 0 6.27 5.12 156 0 924 0.64
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx26.dbf 41 0 7.32 6.27 143 0 721 0.43
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx27.dbf 350 1 5.43 3.11 368 1 1,049 3.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx28.dbf 68 0 6.76 4.69 102 0 820 0.93
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx29.dbf 67 0 6.72 5.33 117 0 1,069 0.55
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx3.dbf 64 0 6.72 5.73 112 0 801 0.47
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx30.dbf 66 0 7.88 5.73 102 0 350 1.03
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx31.dbf 61 0 5.74 5.11 103 0 225 0.36
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx32.dbf 66 0 5.76 5.36 101 0 417 1.41
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx33.dbf 62 0 6.94 5.50 147 0 541 0.72
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx34.dbf 76 0 8.03 5.20 170 0 553 0.72
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx35.dbf 69 0 6.52 6.26 165 0 506 0.65
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx36.dbf 65 0 7.08 6.68 153 0 333 0.69
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx37.dbf 55 0 5.64 6.27 135 0 322 0.71
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx38.dbf 53 0 6.79 6.06 148 0 437 0.39
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx39.dbf 72 0 6.81 4.79 195 0 443 1.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx4.dbf 54 0 5.00 6.26 160 0 373 0.62
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx40.dbf 60 0 6.33 5.20 101 0 361 0.25
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx41.dbf 58 0 5.69 5.62 147 0 541 0.63
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx42.dbf 60 0 5.83 6.10 190 0 1,481 0.22
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx43.dbf 65 0 6.77 5.86 214 1 1,947 0.29
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx44.dbf 61 0 5.25 5.85 218 1 1,785 0.11
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx45.dbf 60 0 6.83 6.35 189 0 1,317 0.28
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx46.dbf 57 0 6.67 6.23 165 0 1,375 0.28
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx47.dbf 57 0 6.67 6.11 143 0 1,170 0.33
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx48.dbf 62 0 7.42 5.76 152 0 894 0.48
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx49.dbf 51 0 6.08 6.22 154 0 398 0.60
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx5.dbf 53 0 6.42 6.08 96 0 477 1.07
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx6.dbf 53 0 5.47 5.98 164 0 474 0.61
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx7.dbf 55 0 7.09 5.58 152 0 465 1.05
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx8.dbf 54 0 4.81 5.31 83 0 451 0.51
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx9.dbf 54 0 7.04 5.85 110 0 591 0.74
APPS_UNDOTS1 /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/undo.dbf 0 0     2,560 6 14,871 0.03
APPS_UNDOTS1 /oracle/visdata/undo1.dbf 0 0     1,799 4 9,912 0.02
SYSAUX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sysaux01.dbf 495 1 3.45 2.10 289 1 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys1.dbf 183 0 3.50 1.00 4 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys10.dbf 239 1 3.85 1.00 4 0 8 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys2.dbf 223 1 3.41 1.00 17 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys3.dbf 258 1 3.18 1.00 64 0 45 0.22
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys4.dbf 234 1 2.74 1.00 42 0 7 5.71
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys5.dbf 210 0 3.86 1.00 29 0 3 6.67
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys6.dbf 223 1 3.41 1.00 13 0 2 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys7.dbf 313 1 3.51 1.00 10 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys8.dbf 223 1 3.18 1.00 76 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys9.dbf 256 1 3.48 1.00 6 0 1 0.00

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,903,193 100 112,938,401 41,238 77,725 0 0 89,692


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 21 472 2804 100000 45298440   100000
E 0 27 4332 99947 100000 45298440   100000

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 2,336 0.10 288,934 1.00 565,348
D 4,672 0.20 577,868 1.00 565,348
D 7,008 0.30 866,802 1.00 565,348
D 9,344 0.40 1,155,736 1.00 565,348
D 11,680 0.50 1,444,670 1.00 565,348
D 14,016 0.60 1,733,604 1.00 565,348
D 16,352 0.70 2,022,538 1.00 565,348
D 18,688 0.80 2,311,472 1.00 565,348
D 21,024 0.90 2,600,406 1.00 565,348
D 23,360 0.99 2,889,340 1.00 565,348
D 23,488 1.00 2,905,172 1.00 565,348
D 25,696 1.09 3,178,274 1.00 565,348
D 28,032 1.19 3,467,208 1.00 565,348
D 30,368 1.29 3,756,142 1.00 565,348
D 32,704 1.39 4,045,076 1.00 565,348
D 35,040 1.49 4,334,010 1.00 565,348
D 37,376 1.59 4,622,944 1.00 565,348
D 39,712 1.69 4,911,878 1.00 565,348
D 42,048 1.79 5,200,812 1.00 565,348
D 44,384 1.89 5,489,746 1.00 565,348
D 46,720 1.99 5,778,680 1.00 565,348

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 12,554 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 Mem Global Mem Bound(K)
B 4,096 3,582 225.63 0.00 0.00 0.00 0.00 419,430
E 4,096 3,580 221.14 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 437,816 437,816 0 0
64K 128K 5 5 0 0
256K 512K 22 22 0 0
512K 1024K 1,173 1,173 0 0
1M 2M 9,989 9,989 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
512 0.13 15,344.07 0.00 100.00 0
1,024 0.25 15,344.07 0.00 100.00 0
2,048 0.50 15,344.07 0.00 100.00 0
3,072 0.75 15,344.07 0.00 100.00 0
4,096 1.00 15,344.07 0.00 100.00 0
4,915 1.20 15,344.07 0.00 100.00 0
5,734 1.40 15,344.07 0.00 100.00 0
6,554 1.60 15,344.07 0.00 100.00 0
7,373 1.80 15,344.07 0.00 100.00 0
8,192 2.00 15,344.07 0.00 100.00 0
12,288 3.00 15,344.07 0.00 100.00 0
16,384 4.00 15,344.07 0.00 100.00 0
24,576 6.00 15,344.07 0.00 100.00 0
32,768 8.00 15,344.07 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
352 0.34 126 10,546 261,894 1.00 94 1.01 7,820,450
464 0.45 152 13,270 261,895 1.00 93 1.00 7,820,563
576 0.56 152 13,270 261,895 1.00 93 1.00 7,820,563
688 0.67 152 13,270 261,895 1.00 93 1.00 7,820,563
800 0.78 152 13,270 261,895 1.00 93 1.00 7,820,563
912 0.89 152 13,270 261,895 1.00 93 1.00 7,820,563
1,024 1.00 152 13,270 261,895 1.00 93 1.00 7,820,563
1,136 1.11 152 13,270 261,895 1.00 93 1.00 7,820,563
1,248 1.22 152 13,270 261,895 1.00 93 1.00 7,820,563
1,360 1.33 152 13,270 261,895 1.00 93 1.00 7,820,563
1,472 1.44 152 13,270 261,895 1.00 93 1.00 7,820,563
1,584 1.55 152 13,270 261,895 1.00 93 1.00 7,820,563
1,696 1.66 152 13,270 261,895 1.00 93 1.00 7,820,563
1,808 1.77 152 13,270 261,895 1.00 93 1.00 7,820,563
1,920 1.88 152 13,270 261,895 1.00 93 1.00 7,820,563
2,032 1.98 152 13,270 261,895 1.00 93 1.00 7,820,563
2,144 2.09 152 13,270 261,895 1.00 93 1.00 7,820,563

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
6,144 0.25 2,085 565,295
12,288 0.50 2,085 565,295
18,432 0.75 2,085 565,295
24,576 1.00 2,085 565,295
30,720 1.25 2,085 565,295
36,864 1.50 2,085 565,295
43,008 1.75 2,085 565,295
49,152 2.00 2,085 565,295

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
16 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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 64,103 48 1
undo block 21,846 0 0
segment header 285 0 1
1st level bmb 450 0 1
undo header 2,938 0 0
2nd level bmb 52 0 4
extent map 14 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
UL-User-defined 3,323 3,254 69 397 58 145.74
TX-Transaction (index contention) 2,347 2,347 0 2,347 4 1.82
HW-Segment High Water Mark 3,097 3,097 0 560 1 2.48
TX-Transaction 25,362 25,368 0 202 0 1.24
TX-Transaction (row lock contention) 288 189 99 189 0 1.22
SQ-Sequence Cache 587 587 0 193 0 0.26
TX-Transaction (allocate ITL entry) 11 11 0 11 0 4.55
FB-Format Block 881 881 0 22 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 18.39 21,289 254 30   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
23-Aug 09:01 18,394 21,289 254 30 611 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 282 0.00   0 0  
AWR Alerted Metric Element list 4,197 0.00   0 0  
Consistent RBA 13,677 0.00   0 0  
FOB s.o list latch 5,789 0.07 0.00 0 0  
In memory undo latch 32,760,870 2.01 0.00 0 15,918 0.03
JS queue state obj latch 2,550 0.00   0 0  
JS slv state obj latch 29 0.00   0 0  
KMG MMAN ready and startup request latch 141 0.00   0 0  
KTF sga latch 1 0.00   0 115 0.00
KWQMN job cache list latch 3 0.00   0 0  
KWQP Prop Status 54 0.00   0 0  
MQL Tracking Latch 0     0 8 0.00
Memory Management Latch 0     0 141 0.00
OS process 348 0.00   0 0  
OS process allocation 372 0.00   0 0  
OS process: request allocation 195 0.00   0 0  
PL/SQL warning settings 253,531 0.00   0 0  
SGA IO buffer pool latch 1,183 0.00   0 1,230 0.00
SQL memory manager latch 1 0.00   0 141 0.00
SQL memory manager workarea list latch 652,140 0.05 0.00 0 0  
Shared B-Tree 278 0.00   0 0  
active checkpoint queue latch 10,823 0.00   0 0  
active service list 1,197 0.00   0 171 0.00
begin backup scn array 17 0.00   0 0  
bq:time manger info latch 15 0.00   0 0  
bufq statistics 3 0.00   0 0  
cache buffer handles 5,183,354 2.49 0.00 0 0  
cache buffers chains 230,479,362 3.93 0.02 1 537,054 7.64
cache buffers lru chain 235,250 0.41 0.01 0 1,238,921 1.90
cache table scan latch 0     0 73 0.00
channel handle pool latch 351 0.28 0.00 0 0  
channel operations parent latch 3,660 0.19 0.00 0 0  
checkpoint queue latch 273,354 0.01 0.00 0 80,872 0.02
client/application info 1,409 0.00   0 0  
commit callback allocation 2 0.00   0 0  
compile environment latch 17,982 0.00   0 0  
dml lock allocation 120,815 0.23 0.00 0 0  
dummy allocation 213 0.47 0.00 0 0  
enqueue hash chains 217,688 0.28 0.00 0 68 0.00
enqueues 55,118 0.58 0.00 0 0  
event group latch 97 0.00   0 0  
file cache latch 1,221 0.00   0 0  
first spare latch 327 0.00   0 0  
global KZLD latch for mem in SGA 87 0.00   0 0  
global ctx hash table latch 214 0.00   0 0  
hash table column usage latch 2 50.00 0.00 0 60,365 0.00
hash table modification latch 60 0.00   0 0  
job workq parent latch 0     0 18 0.00
job_queue_processes parameter latch 14 0.00   0 0  
kks stats 1,478 0.00   0 0  
ksuosstats global area 31 0.00   0 0  
ktm global data 150 0.00   0 0  
kwqbsn:qsga 259 0.00   0 0  
kwqbsn:qxl 1 0.00   0 0  
lgwr LWN SCN 13,745 0.07 0.00 0 0  
library cache 18,962,776 1.85 0.00 0 0  
library cache load lock 4,493 0.98 0.09 0 23 0.00
library cache lock 10,657,568 1.92 0.00 0 0  
library cache lock allocation 9,803 0.05 0.00 0 0  
library cache pin 7,545,425 2.58 0.00 0 0  
library cache pin allocation 3,112 0.00   0 0  
list of block allocation 7,280 0.01 0.00 0 0  
loader state object freelist 178 1.69 0.00 0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 310 0.00   0 0  
messages 77,056 0.02 0.00 0 0  
mostly latch-free SCN 14,046 1.92 0.00 0 0  
multiblock read objects 7,968 0.06 0.00 0 0  
ncodef allocation latch 9 0.00   0 0  
object queue header heap 44,873 0.00   0 344 0.00
object queue header operation 443,283 0.04 0.02 0 0  
object stats modification 660 0.15 0.00 0 0  
parallel query alloc buffer 56 0.00   0 0  
parameter list 291 0.00   0 0  
parameter table allocation management 115 0.87 0.00 0 0  
post/wait queue 14,988 0.04 0.00 0 7,352 0.00
process allocation 195 0.00   0 97 0.00
process group creation 195 0.00   0 0  
qmn task queue latch 452 0.00   0 0  
redo allocation 79,435 0.95 0.00 0 2,533,087 0.85
redo copy 0     0 2,534,521 0.02
redo writing 57,499 0.01 0.00 0 0  
resmgr group change latch 576 0.00   0 0  
resmgr:actses active list 300 1.33 0.00 0 0  
resmgr:actses change group 269 0.00   0 0  
resmgr:free threads list 213 0.47 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 2,451,362 3.36 0.00 0 0  
rules engine aggregate statistics 1 0.00   0 0  
rules engine rule set statistics 102 0.00   0 0  
sequence cache 1,171,974 3.13 0.00 0 0  
session allocation 1,207,142 3.14 0.00 0 0  
session idle bit 1,922,216 0.06 0.00 0 0  
session state list latch 562 1.42 0.00 0 0  
session switching 9 0.00   0 0  
session timer 171 0.00   0 0  
shared pool 293,175 0.44 0.00 0 0  
shared pool sim alloc 105 0.00   0 0  
shared pool simulator 134,632 0.01 0.00 0 0  
simulator hash latch 7,638,954 0.01 0.00 0 0  
simulator lru latch 7,621,081 4.22 0.00 0 6,693 0.00
sort extent pool 1,086 1.20 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temporary table state object allocation 154 1.95 0.00 0 0  
threshold alerts latch 243 0.00   0 0  
trace latch 7 0.00   0 0  
transaction allocation 1,510 0.00   0 0  
transaction branch allocation 9 0.00   0 0  
undo global data 36,549,185 0.81 0.00 0 0  
user lock 366 0.82 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 230,479,362 9,055,769 139,979 8,921,891 0 0 0
In memory undo latch 32,760,870 657,467 2,607 655,272 0 0 0
library cache 18,962,776 351,230 104 351,145 0 0 0
simulator lru latch 7,621,081 321,241 173 321,086 0 0 0
undo global data 36,549,185 296,618 127 296,512 0 0 0
library cache lock 10,657,568 204,913 29 204,890 0 0 0
library cache pin 7,545,425 194,387 40 194,351 0 0 0
cache buffer handles 5,183,354 129,245 39 129,214 0 0 0
row cache objects 2,451,362 82,257 12 82,247 0 0 0
session allocation 1,207,142 37,943 11 37,933 0 0 0
sequence cache 1,171,974 36,628 5 36,623 0 0 0
session idle bit 1,922,216 1,083 1 1,082 0 0 0
cache buffers lru chain 235,250 967 6 963 0 0 0
redo allocation 79,435 751 3 749 0 0 0
enqueues 55,118 322 1 321 0 0 0
dml lock allocation 120,815 281 1 280 0 0 0
object queue header operation 443,283 196 3 193 0 0 0
library cache load lock 4,493 44 4 40 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 1,678 347
In memory undo latch kturbk 0 405 1,102
In memory undo latch kticmt: child 0 353 2
In memory undo latch ktichg: child 0 96 1,109
In memory undo latch ktiTxnPoolFree 0 71 0
In memory undo latch ktbgfc 0 3 47
In memory undo latch ktiBRacquire 0 1 0
cache buffer handles kcbzgs 0 28 22
cache buffer handles kcbzfs 0 11 17
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 184,552 209,367
cache buffers chains kcbgtcr: fast path 0 58,064 1,571
cache buffers chains kcbchg: kslbegin: call CR func 0 55,431 110,761
cache buffers chains kcbgtcr: kslbegin excl 0 27,587 11,364
cache buffers chains kcbzgb: scan from tail. nowait 0 5,119 0
cache buffers chains kcbgcur: kslbegin 0 3,261 1,487
cache buffers chains kcbrls: kslbegin 0 1,237 3,631
cache buffers chains kcbget: pin buffer 0 1,157 461
cache buffers chains kcbzwb 0 957 1,368
cache buffers chains kcbcge 0 393 940
cache buffers chains kcbnlc 0 47 225
cache buffers chains kcb_is_private 0 26 248
cache buffers chains kcb_pre_apply: kcbhq61 0 19 376
cache buffers chains kcbget: exchange rls 0 17 15
cache buffers chains kcbget: exchange 0 12 18
cache buffers chains kcbgtcr: kslbegin shared 0 12 8
cache buffers chains kcb_post_apply: kcbhq63 0 7 48
cache buffers chains kcb_post_apply: kcbhq62 0 4 25
cache buffers chains kcbbxsv 0 2 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 2 0
cache buffers chains kcbzib: multi-block read: nowait 0 2 0
cache buffers chains kcbesc: escalate 0 1 0
cache buffers chains kcbnew: new latch again 0 1 0
cache buffers lru chain kcbzgws 0 4 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 2 0
channel handle pool latch ksrchconnect() 0 1 1
dml lock allocation ktaiam 0 1 0
enqueues ksqdel 0 1 1
library cache kglpnp: child 0 39 44
library cache kglpndl: child: after processing 0 23 4
library cache kglLockCursor 0 14 18
library cache kglpndl: child: before processing 0 13 31
library cache kglobpn: child: 0 5 6
library cache kgldti: 2child 0 2 0
library cache kglhdgc: child: 0 1 1
library cache load lock kglllal: llatch 0 3 1
library cache load lock kglllal: llatch: in loop 0 1 3
library cache lock kgllkal: child: multiinstance 0 19 9
library cache lock kgllkdl: child: cleanup 0 10 20
library cache lock kgllkdl: child: no lock handle 0 7 1
library cache pin kglpnp: child 0 24 20
library cache pin kglpndl 0 16 20
object queue header operation kcbw_link_q 0 20 1
object queue header operation kcbo_swap_buf 0 1 4
object queue header operation kcbo_switch_cq 0 1 7
object queue header operation kcbo_switch_mq_bg 0 1 6
redo allocation kcrfw_redo_gen: redo allocation 1 0 3 0
row cache objects kqrpre: find obj 0 6 11
row cache objects kqreqd 0 3 0
row cache objects kqreqd: reget 0 3 1
sequence cache kdnssd 0 5 0
session allocation ksuprc 0 6 5
session allocation ksuxds: KSUSFCLC not set 0 3 1
session allocation ksudlc 0 2 4
session idle bit ksupuc: clear busy 0 1 1
session idle bit ksupuc: set busy 0 1 1
simulator lru latch kcbs_simulate: simulate set 0 173 168
undo global data kturimugur: child 0 104 77
undo global data ktudba: KSLBEGIN 0 19 49
undo global data ktudnx:child 0 4 1

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 11,876,624 10.39
HR APPS_TS_TX_IDX PAY_PAYROLL_ACTIONS_PK   INDEX 6,653,136 5.82
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 5,205,536 4.55
HR APPS_TS_TX_DATA PAY_PAYROLL_ACTIONS   TABLE 3,778,576 3.31
HR APPS_TS_TX_IDX FF_USER_ENTITIES_N51   INDEX 3,725,728 3.26

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
HR APPS_TS_TX_DATA PAY_ACTION_INFORMATION   TABLE 5,868 14.27
HR APPS_TS_TX_DATA PER_ALL_ASSIGNMENTS_F   TABLE 3,120 7.59
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N51   INDEX 2,797 6.80
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N4   INDEX 2,780 6.76
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N5   INDEX 794 1.93

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
HR APPS_TS_TX_DATA PAY_PAYROLL_ACTIONS   TABLE 268 10.72
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N1   INDEX 214 8.56
HR APPS_TS_TX_IDX PAY_COSTS_FK2   INDEX 197 7.88
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N4   INDEX 176 7.04
HR APPS_TS_TX_IDX PAY_COSTS_FK1   INDEX 162 6.48

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
HR APPS_TS_TX_IDX PAY_RUN_BALANCES_N1   INDEX 7 63.64
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N5   INDEX 3 27.27
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N2   INDEX 1 9.09

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 8,924 17.30
HR APPS_TS_TX_DATA PAY_POPULATION_RANGES   TABLE 3,799 7.36
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N4   INDEX 2,798 5.42
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_PK   INDEX 2,574 4.99
HR APPS_TS_TX_IDX PAY_COSTS_FK1   INDEX 2,226 4.31

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 12 0.00 0   2 1
dc_global_oids 535 0.00 0   0 79
dc_histogram_data 14,212 3.45 0   0 2,130
dc_histogram_defs 10,894 18.83 0   0 6,378
dc_object_grants 443 4.06 0   0 204
dc_object_ids 98,326 0.66 0   0 3,492
dc_objects 3,390 17.94 0   0 8,075
dc_profiles 96 0.00 0   0 1
dc_rollback_segments 167 0.00 0   0 34
dc_segments 17,463 4.16 0   813 8,333
dc_sequences 394 2.03 0   394 28
dc_table_scns 2 0.00 0   0 1
dc_tablespace_quotas 809 0.25 0   0 4
dc_tablespaces 334,549 0.00 0   0 56
dc_usernames 2,774 0.00 0   0 56
dc_users 342,234 0.00 0   0 84
outstanding_alerts 111 2.70 0   1 110


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 2,721 2.72 1,621,067 0.01 0 0
CLUSTER 8 0.00 9 0.00 0 0
INDEX 10 100.00 10 100.00 0 0
PIPE 63 0.00 63 0.00 0 0
SQL AREA 1,650 95.45 15,036,701 0.83 0 0
TABLE/PROCEDURE 7,540 8.93 2,031,890 0.06 0 0
TRIGGER 234 2.99 216,934 0.00 0 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 145.30   1.91 2.43 22 31 76 76
  Freeable 64.75 0.00 1.16 2.13 10   56 56
  SQL 10.49 5.26 0.15 0.20 1 3 71 68
  PL/SQL 5.13 2.02 0.07 0.04 0 0 76 76
E Other 147.53   1.97 2.47 22 31 75 75
  Freeable 58.94 0.00 1.18 2.06 10   50 50
  SQL 9.72 4.66 0.14 0.19 1 3 70 68
  PL/SQL 4.99 2.09 0.07 0.04 0 0 75 75

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 24,612,175,872  
Fixed Size 2,119,344  
Redo Buffers 14,655,488  
Variable Size 1,140,853,072  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 16.00 16.00 0.00
large free memory 15.94 15.94 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor   11.28  
shared Heap0: KGL 11.80 13.43 13.83
shared KGLS heap 44.69 49.05 9.75
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 595.60 545.35 -8.44
shared library cache 15.93 20.13 26.39
shared sql area 32.19 55.44 72.23
streams free memory 31.99 31.99 -0.00
  buffer_cache 23,472.00 23,472.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 4,881 0 0
QMON Coordinator 4,550 0 0

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber Name Incoming per second Outgoing per second Spilled per second
WFBESCL_20626 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_system_trig_enabled TRUE   
_trace_files_public TRUE   
aq_tm_processes 1   
background_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_vega7242/bdump   
compatible 10.2.0   
control_files /oracle/visdata/cntrl01.dbf, /oracle/visdata/cntrl02.dbf, /oracle/visdata/cntrl03.dbf   
core_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_vega7242/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_file_multiblock_read_count 8   
db_files 512   
db_name VIS   
dml_locks 10000   
hash_area_size 524288   
ifile /oracle/db/tech_st/10.2.0/dbs/VIS_vega7242_ifile.ora   
job_queue_processes 2   
log_buffer 14211072   
log_checkpoint_interval 100000   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size 20480   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 600   
optimizer_secure_view_merging FALSE   
parallel_max_servers 8   
parallel_min_servers 0   
pga_aggregate_target 4294967296   
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 200   
session_cached_cursors 500   
sessions 400   
sga_target 25769803776   
shared_pool_reserved_size 104857600   
shared_pool_size 1073741824   
sort_area_size 262144   
timed_statistics TRUE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_vega7242/udump   
utl_file_dir /usr/tmp, /usr/tmp, /oracle/db/tech_st/10.2.0/appsutil/outbound/VIS_vega7242, /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report