WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 210556022 VIS 1 10.2.0.3.0 NO db1.oasb.cisco

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 93 20-Jul-10 14:42:34 88 25.9
End Snap: 94 20-Jul-10 14:50:34 89 25.7
Elapsed:   8.00 (mins)    
DB Time:   14.46 (mins)    

Report Summary

Cache Sizes

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

Load Profile

Per Second Per Transaction
Redo size: 1,584,955.07 49,531.81
Logical reads: 294,216.14 9,194.62
Block changes: 10,413.96 325.45
Physical reads: 0.45 0.01
Physical writes: 118.53 3.70
User calls: 2,006.97 62.72
Parses: 1,585.52 49.55
Hard parses: 1.19 0.04
Sorts: 1,668.00 52.13
Logons: 0.28 0.01
Executes: 18,957.59 592.45
Transactions: 32.00  

% Blocks changed per Read: 3.54 Recursive Call %: 95.19
Rollback per transaction %: 0.99 Rows per Sort: 2.28

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 100.00 Soft Parse %: 99.93
Execute to Parse %: 91.64 Latch Hit %: 94.45
Parse CPU to Parse Elapsd %: 62.04 % Non-Parse CPU: 99.02

Shared Pool Statistics

Begin End
Memory Usage %: 21.86 23.08
% SQL with executions>1: 84.19 91.19
% Memory for SQL w/exec>1: 84.42 87.58

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   840   96.9  
log file parallel write 12,837 6 1 .7 System I/O
log file sync 7,268 5 1 .5 Commit
db file parallel write 5,343 5 1 .5 System I/O
library cache pin 830 3 4 .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 851.37 98.14
DB CPU 840.24 96.86
PL/SQL execution elapsed time 251.57 29.00
parse time elapsed 16.15 1.86
hard parse elapsed time 1.70 0.20
repeated bind elapsed time 0.47 0.05
inbound PL/SQL rpc elapsed time 0.39 0.05
connection management call elapsed time 0.25 0.03
PL/SQL compilation elapsed time 0.25 0.03
sequence load elapsed time 0.12 0.01
hard parse (sharing criteria) elapsed time 0.08 0.01
hard parse (bind mismatch) elapsed time 0.01 0.00
DB time 867.52  
background elapsed time 13.50  
background cpu time 2.72  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
System I/O 20,112 0.00 11 1 1.31
Concurrency 159,848 0.00 5 0 10.41
Commit 7,268 0.00 5 1 0.47
Other 14,033 90.38 2 0 0.91
User I/O 359 0.00 1 4 0.02
Application 1,165 0.00 1 1 0.08
Network 934,245 0.00 1 0 60.84
Configuration 1,260 0.00 0 0 0.08

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 12,837 0.00 6 1 0.84
log file sync 7,268 0.00 5 1 0.47
db file parallel write 5,343 0.00 5 1 0.35
library cache pin 830 0.00 3 4 0.05
kksfbc child completion 42 88.10 2 44 0.00
db file sequential read 331 0.00 1 4 0.02
enq: UL - contention 615 0.00 1 2 0.04
buffer busy waits 120,778 0.00 1 0 7.87
enq: TX - index contention 5,805 0.00 1 0 0.38
SQL*Net message to client 902,343 0.00 0 0 58.76
control file sequential read 1,713 0.00 0 0 0.11
enq: TX - contention 517 0.00 0 0 0.03
latch: cache buffers chains 29,483 0.00 0 0 1.92
SQL*Net more data from client 29,360 0.00 0 0 1.91
os thread startup 8 0.00 0 17 0.00
control file parallel write 219 0.00 0 1 0.01
enq: HW - contention 672 0.00 0 0 0.04
enq: TX - row lock contention 332 0.00 0 0 0.02
db file scattered read 24 0.00 0 4 0.00
latch: In memory undo latch 2,864 0.00 0 0 0.19
enq: SQ - contention 581 0.00 0 0 0.04
latch free 21 0.00 0 2 0.00
buffer deadlock 12,803 98.77 0 0 0.83
SQL*Net more data to client 2,542 0.00 0 0 0.17
SQL*Net break/reset to client 218 0.00 0 0 0.01
enq: FB - contention 117 0.00 0 0 0.01
latch: library cache pin 28 0.00 0 0 0.00
LGWR wait for redo copy 492 0.00 0 0 0.03
latch: library cache 31 0.00 0 0 0.00
latch: undo global data 40 0.00 0 0 0.00
direct path write 4 0.00 0 0 0.00
enq: TX - allocate ITL entry 7 0.00 0 0 0.00
latch: redo allocation 1 0.00 0 0 0.00
cursor: mutex X 21 0.00 0 0 0.00
SQL*Net message from client 902,347 0.00 23,358 26 58.76
Streams AQ: waiting for messages in the queue 248 100.00 1,848 7452 0.02
pipe get 336 100.00 1,407 4186 0.02
Streams AQ: qmn slave idle wait 197 0.00 932 4730 0.01
Streams AQ: qmn coordinator idle wait 206 38.35 466 2262 0.01
jobq slave wait 84 97.62 243 2895 0.01
PL/SQL lock timer 19 100.00 186 9768 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 12,837 0.00 6 1 0.84
db file parallel write 5,343 0.00 5 1 0.35
os thread startup 8 0.00 0 17 0.00
control file parallel write 219 0.00 0 1 0.01
control file sequential read 90 0.00 0 0 0.01
events in waitclass Other 493 0.00 0 0 0.03
rdbms ipc message 11,126 16.59 4,674 420 0.72
Streams AQ: qmn slave idle wait 197 0.00 932 4730 0.01
smon timer 212 0.00 470 2215 0.01
pmon timer 185 100.00 469 2534 0.01
Streams AQ: qmn coordinator idle wait 206 38.35 466 2262 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 100,221
IDLE_TIME 1,051,429
IOWAIT_TIME 1,143
NICE_TIME 0
SYS_TIME 3,829
USER_TIME 95,328
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 22,333,300
NUM_CPUS 24
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 864.50 838.90 49 141,168,628
SYS$USERS 3.00 1.40 176 22,479
SYS$BACKGROUND 0.00 0.00 0 1,398

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 15 8 159840 526 0 0 933858 56
SYS$USERS 344 140 0 0 0 0 37 0
SYS$BACKGROUND 0 0 8 13 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
590 590 9,574 0.06 68.05 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
589 586 9,875 0.06 67.87 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
77 77 79,721 0.00 8.91 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
57 57 9,087 0.01 6.59 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
45 45 279,727 0.00 5.14 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
32 32 9,964 0.00 3.72 80wvw6gatjvb2 PYUSLV SELECT PTP_TD.START_DATE FROM ...
30 30 10,000 0.00 3.45 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
22 22 149,919 0.00 2.49 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
20 19 60 0.34 2.33 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
16 16 579,680 0.00 1.86 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
14 14 579,930 0.00 1.56 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
13 13 580,689 0.00 1.55 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
12 12 109,809 0.00 1.34 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
12 12 429,377 0.00 1.33 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
11 10 9,908 0.00 1.31 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
11 10 9,997 0.00 1.22 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
10 10 9,988 0.00 1.18 36z3h9rgkd8aa PYUSLV begin ...
10 10 9,967 0.00 1.14 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
10 10 587,068 0.00 1.13 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...

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
590 590 9,574 0.06 68.05 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
586 589 9,875 0.06 67.87 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
77 77 79,721 0.00 8.91 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
57 57 9,087 0.01 6.59 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
45 45 279,727 0.00 5.14 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
32 32 9,964 0.00 3.72 80wvw6gatjvb2 PYUSLV SELECT PTP_TD.START_DATE FROM ...
30 30 10,000 0.00 3.45 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
22 22 149,919 0.00 2.49 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
19 20 60 0.31 2.33 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
16 16 579,680 0.00 1.86 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
14 14 579,930 0.00 1.56 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
13 13 580,689 0.00 1.55 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
12 12 109,809 0.00 1.34 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
12 12 429,377 0.00 1.33 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
10 11 9,908 0.00 1.31 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
10 11 9,997 0.00 1.22 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
10 10 9,988 0.00 1.18 36z3h9rgkd8aa PYUSLV begin ...
10 10 587,068 0.00 1.13 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
10 10 9,967 0.00 1.14 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...

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
87,921,038 9,875 8,903.40 62.27 586.04 588.79 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
84,462,568 9,574 8,822.08 59.82 590.02 590.33 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
16,095,726 279,727 57.54 11.40 44.57 44.61 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
12,624,163 9,087 1,389.26 8.94 56.89 57.19 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
9,957,067 79,721 124.90 7.05 77.26 77.26 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
8,738,422 9,964 877.00 6.19 32.30 32.30 80wvw6gatjvb2 PYUSLV SELECT PTP_TD.START_DATE FROM ...
6,449,763 149,919 43.02 4.57 21.60 21.61 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
6,413,649 579,680 11.06 4.54 16.18 16.18 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
5,589,203 60 93,153.38 3.96 18.62 20.17 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact...
4,927,545 579,930 8.50 3.49 13.53 13.53 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
4,902,974 580,689 8.44 3.47 13.42 13.42 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
4,729,695 429,377 11.02 3.35 11.51 11.51 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
4,170,682 10,000 417.07 2.95 29.62 29.91 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
4,080,427 167,517 24.36 2.89 8.14 8.14 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
3,505,314 583,551 6.01 2.48 7.44 7.45 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '...
3,027,629 9,997 302.85 2.14 10.46 10.56 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
2,499,036 9,988 250.20 1.77 10.18 10.24 36z3h9rgkd8aa PYUSLV begin ...
2,470,224 9,967 247.84 1.75 9.58 9.92 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA...
2,199,830 109,809 20.03 1.56 11.61 11.61 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
1,783,053 587,068 3.04 1.26 9.81 9.81 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
1,776,966 9,908 179.35 1.26 10.46 11.33 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL...
1,752,102 582,885 3.01 1.24 7.41 7.42 77d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
1,509,121 9,974 151.31 1.07 6.13 6.13 a9pf25b5p69c6 PYUSLV declare cursor dp ( p_act in n...
1,496,618 124,212 12.05 1.06 5.29 5.29 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
1,480,619 39,950 37.06 1.05 6.23 6.23 f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...
1,431,852 9,978 143.50 1.01 6.57 6.57 gj45bp5w5anrf PYUSLV SELECT DISTINCT PEE.ASSIGNMENT...

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
21 6 3.50 9.63 0.01 0.01 19ay9yuhtbvkc SQL*Plus INSERT INTO FND_CONCURRENT_REQ...
8 1 8.00 3.67 0.02 0.02 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
5 1 5.00 2.29 0.01 0.01 cf621qmts91wf   SELECT /*+ ordered use_nl(stat...
4 1 4.00 1.83 0.02 0.04 31a13pnjps7j3   SELECT source, (case w...
1 1 1.00 0.46 0.01 0.01 dgyj6z7xacxjm   SELECT /*+ ordered use_nl(stat...
0 500 0.00 0.00 0.97 0.97 0095dq943c6t3 PYUSLV SELECT /*+ ORDERED ...
0 429,377 0.00 0.00 11.51 11.51 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
0 2 0.00 0.00 0.01 0.01 03s61gtq86zy3 INCTCM update MTL_MATERIAL_TRANSACTIO...
0 15 0.00 0.00 0.00 0.00 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0 1,741 0.00 0.00 0.08 0.08 0h6b2sajwb74n   select privilege#, level from ...

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
587,068 913,661 1.56 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N...
583,551 583,958 1.00 0.00 0.00 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '...
582,885 583,871 1.00 0.00 0.00 77d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
580,689 584,111 1.01 0.00 0.00 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN...
579,930 582,118 1.00 0.00 0.00 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ...
579,680 1,165,788 2.01 0.00 0.00 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA...
429,377 429,682 1.00 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
279,727 279,121 1.00 0.00 0.00 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
167,517 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P...
149,919 149,804 1.00 0.00 0.00 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
124,212 124,752 1.00 0.00 0.00 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR...
109,809 109,808 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
279,998 279,727 36.80 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
150,000 149,919 19.71 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val...
80,000 79,721 10.51 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
45,000 44,908 5.91 8a01qnnc9as1r PYUSLV SELECT NVL(SUM(prb.balance_val...
30,000 29,830 3.94 264qzrka8fsps PYUSLV SELECT NVL(SUM(prb.balance_val...
19,993 19,985 2.63 83kbt99vg4svq PYUSLV begin ...
10,000 10,000 1.31 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....
10,000 9,574 1.31 4f5mjr4hnaz3u PYUSLV declare begin pay_archive...
10,000 9,875 1.31 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
9,997 9,988 1.31 36z3h9rgkd8aa PYUSLV begin ...
9,996 9,935 1.31 97mt0g20bcfc3 PYUSLV begin ...
9,995 9,954 1.31 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim...
9,994 9,999 1.31 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
0095dq943c6t3 SELECT /*+ ORDERED index(pa2 PAY_PAYROLL_ACTIONS_PK) index(pos PER_PERIODS_OF_SERVICE_N3) index(as1 PER_ASSIGNMENTS_F_N4) index(act PAY_ASSIGNMENT_ACTIONS_N51) index(as2 PER_ASSIGNMENTS_F_PK) index(opm PAY_ORG_PAYMENT_METHODS_F_PK) USE_NL(pos pop act pa2 as1 as2) */ ACT.ASSIGNMENT_ACTION_ID, ACT.ASSIGNMENT_ID, ACT.TAX_UNIT_ID, PPP.PRE_PAYMENT_ID, PA1.ASSIGNMENT_SET_ID, AS1.PAYROLL_ID FROM PAY_PAYROLL_ACTIONS PA1, PAY_POPULATION_RANGES POP, PER_PERIODS_OF_SERVICE POS, PER_ALL_ASSIGNMENTS_F AS1, PAY_ASSIGNMENT_ACTIONS ACT, PAY_PAYROLL_ACTIONS PA2, PAY_ACTION_CLASSIFICATIONS PCL, PAY_PRE_PAYMENTS PPP, PER_ALL_ASSIGNMENTS_F AS2, PAY_ORG_PAYMENT_METHODS_F OPM WHERE PA1.PAYROLL_ACTION_ID = :B3 AND PA2.CONSOLIDATION_SET_ID +0 = PA1.CONSOLIDATION_SET_ID AND PA2.EFFECTIVE_DATE BETWEEN PA1.START_DATE AND PA1.EFFECTIVE_DATE AND ACT.PAYROLL_ACTION_ID = PA2.PAYROLL_ACTION_ID AND ACT.ACTION_STATUS = 'C' AND PCL.CLASSIFICATION_NAME = :B4 AND PA2.ACTION_TYPE = PCL.ACTION_TYPE AND AS1.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PA1.EFFECTIVE_DATE BETWEEN AS1.EFFECTIVE_START_DATE AND AS1.EFFECTIVE_END_DATE AND AS2.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PA2.EFFECTIVE_DATE BETWEEN AS2.EFFECTIVE_START_DATE AND AS2.EFFECTIVE_END_DATE AND AS2.PAYROLL_ID + 0 = AS1.PAYROLL_ID + 0 AND POS.PERIOD_OF_SERVICE_ID = AS1.PERIOD_OF_SERVICE_ID AND POP.PAYROLL_ACTION_ID = :B3 AND POP.CHUNK_NUMBER = :B2 AND POS.PER SON_ID = POP.PERSON_ID AND (AS1.PAYROLL_ID = PA1.PAYROLL_ID OR PA1.PAYROLL_ID IS NULL) AND PPP.ASSIGNMENT_ACTION_ID = ACT.ASSIGNMENT_ACTION_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID AND PA1.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND OPM.PAYMENT_TYPE_ID +0 = :B1 AND PPP.ORGANIZATION_ID IS NULL AND (OPM.ORG_PAYMENT_METHOD_ID = PA1.ORG_PAYMENT_METHOD_ID OR PA1.ORG_PAYMENT_METHOD_ID IS NULL) AND NOT EXISTS ( SELECT /*+ ORDERED*/ NULL FROM PAY_ACTION_INTERLOCKS INT, PAY_ASSIGNMENT_ACTIONS AC2 WHERE INT.LOCKED_ACTION_ID = ACT.ASSIGNMENT_ACTION_ID AND AC2.ASSIGNMENT_ACTION_ID = INT.LOCKING_ACTION_ID AND AC2.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID AND NOT EXISTS ( SELECT NULL FROM PAY_ASSIGNMENT_ACTIONS PAA_VOID, PAY_ACTION_INTERLOCKS PAI_VOID, PAY_PAYROLL_ACTIONS PPA_VOID WHERE PAI_VOID.LOCKED_ACTION_ID = AC2.ASSIGNMENT_ACTION_ID AND PAI_VOID.LOCKING_ACTION_ID = PAA_VOID.ASSIGNMENT_ACTION_ID AND PAA_VOID.PAYROLL_ACTION_ID = PPA_VOID.PAYROLL_ACTION_ID AND PPA_VOID.ACTION_TYPE = 'D') ) AND NOT EXISTS ( SELECT /*+ ORDERED*/ NULL FROM PER_ALL_ASSIGNMENTS_F AS3, PAY_ASSIGNMENT_ACTIONS AC3 WHERE :B5 = 'N' AND AC3.PAYROLL_ACTION_ID = PA2.PAYROLL_ACTION_ID AND AC3.ACTION_STATUS NOT IN ('C', 'S') AND AS3.ASSIGNMENT_ID = AC3.ASSIGNMENT_ID AND PA2.EFFECTIVE_DATE BETWEEN AS3.EFFECTIVE_START_DATE AND AS3.EFFECTIVE_END_DATE AND AS3.PERSON_ID = AS2.PERSON_ID) ORDER BY ACT.ASSIGNMENT_ID FOR UPDATE OF AS1.ASSIGNMENT_ID, POS.PERIOD_OF_SERVICE_I D
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
03s61gtq86zy3 update MTL_MATERIAL_TRANSACTIONS_TEMP MMTT set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG='Y', ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG='Y' and NVL(TRANSACTION_STATUS, 1) in (1, 3)) and NVL(LOCK_FLAG, 'N')='N') and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MMTT.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
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')
19ay9yuhtbvkc INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ORG_ID, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT2 5) SELECT :B75 , :B74 , :B73 , DECODE (:B72 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B54 , 'Y', 'Q', DECODE(:B35 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B71 , NULL, 50, :B71 )), DECODE (:B63 , 0, NULL, :B63 ), :B70 , :B69 , NULL, :B68 , 'N', :B67 , :B66 , 'Y', :B54 , 'S', :B65 , SYSDATE, DECODE (:B64 , '', (SYSDATE - :B62 ), GREATEST (:B64 , DECODE (:B63 , 0, (SYSDATE - :B62 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B61 , SYSDATE, :B61 , :B60 , ORACLE_ID, :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B35 , 'Y', 'B', DECODE(:B54 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , DECODE (:B47 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B47 ), 'HH24:MI:SS')), DECODE (:B46 , '', NULL, :B46 ), :B45 , :B44 , :B43 , 'N', :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B36 , :B35 , :B34 , DECODE(:B33 , 'Y', 'Y', FCP.ENABLE_TRACE), :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 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAM S FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
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;
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
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;
80wvw6gatjvb2 SELECT PTP_TD.START_DATE FROM PER_TIME_PERIODS PTP_TD, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA, PER_TIME_PERIODS PTP_PPA WHERE PTP_TD.TIME_DEFINITION_ID = :B2 AND PAA.ASSIGNMENT_ACTION_ID = :B1 AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.PAYROLL_ID = PTP_PPA.PAYROLL_ID AND PPA.DATE_EARNED BETWEEN PTP_PPA.START_DATE AND PTP_PPA.END_DATE AND PTP_TD.START_DATE > PTP_PPA.START_DATE AND PTP_TD.START_DATE <= PTP_PPA.END_DATE
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)
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 ;
a9pf25b5p69c6 declare cursor dp ( p_act in number ) is select distinct paf2 . assignment_id , paa . action_sequence from pay_assignment_actions paa , pay_payroll_actions ppa , per_all_assignments_f paf , per_periods_of_service pos , per_all_assignments_f paf2 where paa . assignment_action_id = p_act and paa . payroll_action_id = ppa . payroll_action_id and paf . assignment_id = paa . assignment_id and ppa . effective_date between paf . effective_start_date and paf . effective_end_date and paf . person_id = pos . person_id and pos . period_of_service_id = paf2 . period_of_service_id ; BEGIN for dprec in dp ( :assactid ) loop begin select 1 into :act_exists from sys . dual where exists ( select null from pay_assignment_actions paa , pay_payroll_actions ppa , pay_action_classifications pcl where paa . assignment_id = dprec . assignment_id and paa . payroll_action_id = ppa . payroll_action_id and ppa . action_type = pcl . action_type and pcl . classification_name = 'SEQUENCED' and paa . action_status not in ( 'C' , 'S' , 'B' ) and paa . action_sequence < dprec . action_sequence ) ; exception when no_data_found then null ; end ; end loop ; END ;
cf621qmts91wf SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time = 0 and a.session_type = 1 and a.event_id in ( select en.event_id from WRH$_EVENT_NAME en where a.dbid = en.dbid and en.wait_class = 'User I/O') GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.iowait_delta) >= :cutoff ORDER BY sum(s.iowait_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.io_wait DESC
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;
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;
dgyj6z7xacxjm SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time <> 0 GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.cpu_time_delta) >= :cutoff ORDER BY sum(s.cpu_time_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.cpu_time DESC
f78ff26qcfjan update PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S')
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)
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
gj45bp5w5anrf SELECT DISTINCT PEE.ASSIGNMENT_ID , PET.PRORATION_GROUP_ID FROM PAY_ELEMENT_ENTRIES_F PEE, PAY_ELEMENT_TYPES_F PET WHERE PEE.ELEMENT_ENTRY_ID = :B2 AND PEE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PEE.EFFECTIVE_START_DATE <= :B1 AND PEE.EFFECTIVE_END_DATE >= PAY_INTERPRETER_PKG.TIME_FN(:B3 , PET.PRORATION_GROUP_ID , :B2 ) AND :B1 BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE

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 87,599 182.54 5.70
CPU used when call started 87,580 182.50 5.70
CR blocks created 567,163 1,181.85 36.93
Cached Commit SCN referenced 951,225 1,982.16 61.94
Commit SCN cached 233 0.49 0.02
DB time 463,798 966.46 30.20
DBWR checkpoint buffers written 56,878 118.52 3.70
DBWR checkpoints 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 49 0.10 0.00
DBWR undo block writes 35,979 74.97 2.34
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 13,551,591 28,238.72 882.49
IMU Flushes 8,246 17.18 0.54
IMU Redo allocation size 122,625,804 255,526.85 7,985.53
IMU commits 7,291 15.19 0.47
IMU contention 4,062 8.46 0.26
IMU ktichg flush 106 0.22 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 178 0.37 0.01
IMU undo allocation size 198,541,648 413,719.80 12,929.26
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded 25 to 50 pct 0 0.00 0.00
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 901,990 1,879.56 58.74
active txn count during cleanout 2,680,352 5,585.30 174.55
application wait time 134 0.28 0.01
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 1,856 3.87 0.12
branch node splits 13 0.03 0.00
buffer is not pinned count 64,809,032 135,048.64 4,220.44
buffer is pinned count 439,602,189 916,040.19 28,627.39
bytes received via SQL*Net from client 236,245,982 492,287.84 15,384.60
bytes sent via SQL*Net to client 140,074,574 291,886.49 9,121.81
calls to get snapshot scn: kcmgss 9,578,734 19,960.10 623.78
calls to kcmgas 629,075 1,310.86 40.97
calls to kcmgcs 18,225 37.98 1.19
change write time 791 1.65 0.05
cleanout - number of ktugct calls 583,517 1,215.93 38.00
cleanouts and rollbacks - consistent read gets 534,948 1,114.72 34.84
cleanouts only - consistent read gets 5,457 11.37 0.36
cluster key scan block gets 4,291 8.94 0.28
cluster key scans 2,224 4.63 0.14
commit batch/immediate performed 766 1.60 0.05
commit batch/immediate requested 766 1.60 0.05
commit cleanout failures: block lost 212 0.44 0.01
commit cleanout failures: callback failure 14,509 30.23 0.94
commit cleanout failures: cannot pin 2,889 6.02 0.19
commit cleanouts 187,243 390.18 12.19
commit cleanouts successfully completed 169,633 353.48 11.05
commit immediate performed 766 1.60 0.05
commit immediate requested 766 1.60 0.05
commit txn count during cleanout 50,078 104.35 3.26
concurrency wait time 540 1.13 0.04
consistent changes 39,122,838 81,523.92 2,547.72
consistent gets 135,298,465 281,934.06 8,810.79
consistent gets - examination 82,001,176 170,873.52 5,340.01
consistent gets direct 4 0.01 0.00
consistent gets from cache 135,298,461 281,934.05 8,810.79
cursor authentications 756 1.58 0.05
data blocks consistent reads - undo records applied 39,085,531 81,446.18 2,545.29
db block changes 4,997,597 10,413.96 325.45
db block gets 5,894,095 12,282.08 383.83
db block gets direct 4 0.01 0.00
db block gets from cache 5,894,091 12,282.07 383.83
deferred (CURRENT) block cleanout applications 28,359 59.09 1.85
enqueue conversions 3,154 6.57 0.21
enqueue releases 105,847 220.56 6.89
enqueue requests 106,060 221.01 6.91
enqueue timeouts 213 0.44 0.01
enqueue waits 7,484 15.60 0.49
exchange deadlocks 12,820 26.71 0.83
execute count 9,097,634 18,957.59 592.45
failed probes on index block reclamation 7 0.01 0.00
free buffer inspected 50,252 104.71 3.27
free buffer requested 630,618 1,314.08 41.07
heap block compress 16,641 34.68 1.08
immediate (CR) block cleanout applications 540,405 1,126.09 35.19
immediate (CURRENT) block cleanout applications 28,576 59.55 1.86
index crx upgrade (found) 43,232 90.09 2.82
index crx upgrade (positioned) 683,632 1,424.55 44.52
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 15,575,060 32,455.21 1,014.27
index scans kdiixs1 14,141,876 29,468.75 920.93
leaf node 90-10 splits 1,293 2.69 0.08
leaf node splits 6,703 13.97 0.44
lob reads 0 0.00 0.00
lob writes 87 0.18 0.01
lob writes unaligned 87 0.18 0.01
logons cumulative 136 0.28 0.01
messages received 18,156 37.83 1.18
messages sent 18,156 37.83 1.18
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 51,103,166 106,488.45 3,327.90
opened cursors cumulative 701,480 1,461.74 45.68
parse count (failures) 0 0.00 0.00
parse count (hard) 570 1.19 0.04
parse count (total) 760,882 1,585.52 49.55
parse time cpu 827 1.72 0.05
parse time elapsed 1,333 2.78 0.09
physical read IO requests 94 0.20 0.01
physical read bytes 1,785,856 3,721.36 116.30
physical read total IO requests 2,066 4.31 0.13
physical read total bytes 31,973,376 66,625.91 2,082.14
physical read total multi block requests 22 0.05 0.00
physical reads 218 0.45 0.01
physical reads cache 214 0.45 0.01
physical reads cache prefetch 124 0.26 0.01
physical reads direct 4 0.01 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 124 0.26 0.01
physical write IO requests 6,127 12.77 0.40
physical write bytes 465,977,344 971,000.56 30,344.97
physical write total IO requests 25,590 53.32 1.67
physical write total bytes 1,268,331,008 2,642,939.92 82,595.14
physical write total multi block requests 22,579 47.05 1.47
physical writes 56,882 118.53 3.70
physical writes direct 4 0.01 0.00
physical writes direct (lob) 4 0.01 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 56,878 118.52 3.70
physical writes non checkpoint 46,761 97.44 3.05
process last non-idle time 481 1.00 0.03
queries parallelized 0 0.00 0.00
recursive calls 19,076,208 39,750.88 1,242.26
recursive cpu usage 77,092 160.64 5.02
redo blocks written 1,545,977 3,221.50 100.68
redo entries 2,553,734 5,321.45 166.30
redo ordering marks 33,068 68.91 2.15
redo size 760,610,428 1,584,955.07 49,531.81
redo subscn max counts 52,877 110.18 3.44
redo synch time 469 0.98 0.03
redo synch writes 6,956 14.49 0.45
redo wastage 4,834,752 10,074.62 314.84
redo write time 717 1.49 0.05
redo writer latching time 3 0.01 0.00
redo writes 12,840 26.76 0.84
rollback changes - undo records applied 3,424 7.13 0.22
rollbacks only - consistent read gets 36,423 75.90 2.37
rows fetched via callback 11,053,815 23,033.87 719.84
session connect time 0 0.00 0.00
session cursor cache hits 742,045 1,546.27 48.32
session logical reads 141,192,560 294,216.14 9,194.62
session pga memory 16,179,384 33,714.50 1,053.62
session pga memory max 13,885,624 28,934.77 904.25
session uga memory 42,953,839,656 89,506,932.06 2,797,202.37
session uga memory max 400,477,832 834,513.10 26,079.57
shared hash latch upgrades - no wait 761,495 1,586.80 49.59
shared hash latch upgrades - wait 50,886 106.04 3.31
sorts (memory) 800,465 1,668.00 52.13
sorts (rows) 1,828,716 3,810.67 119.09
sql area purged 0 0.00 0.00
switch current to new buffer 11,269 23.48 0.73
table fetch by rowid 246,628,157 513,922.15 16,060.70
table fetch continued row 254 0.53 0.02
table scan blocks gotten 9,232,648 19,238.93 601.24
table scan rows gotten 404,223,411 842,318.12 26,323.48
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 391,695 816.21 25.51
total number of times SMON posted 212 0.44 0.01
transaction rollbacks 766 1.60 0.05
undo change vector size 269,233,064 561,026.11 17,532.76
user I/O wait time 148 0.31 0.01
user calls 963,133 2,006.97 62.72
user commits 15,204 31.68 0.99
user rollbacks 152 0.32 0.01
workarea executions - optimal 516,560 1,076.40 33.64

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 19,617 24,430
opened cursors current 2,281 2,287
logons current 88 89

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_UNDOTS1 0 0 0.00 0.00 2,600 5 29,610 0.01
APPS_TS_TX_IDX 6 0 6.67 5.67 1,815 4 62,239 0.02
APPS_TS_TX_DATA 8 0 7.50 5.63 1,291 3 28,778 0.01
SYSAUX 62 0 3.55 2.15 238 0 0 0.00
SYSTEM 14 0 4.29 1.00 166 0 76 0.26
APPS_TS_ARCHIVE 4 0 5.00 1.00 11 0 72 0.00
APPS_TS_SEED 0 0 0.00 0.00 6 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 11 0 72 0.00
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference1.dbf 0 0     2 0 0 0.00
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference2.dbf 0 0     1 0 0 0.00
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference5.dbf 0 0     3 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data11.dbf 1 0 0.00 12.00 35 0 1,186 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data12.dbf 0 0     33 0 829 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data13.dbf 0 0     27 0 751 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data19.dbf 0 0     1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data2.dbf 0 0     30 0 780 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data21.dbf 0 0     28 0 342 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data22.dbf 1 0 10.00 1.00 29 0 373 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data27.dbf 0 0     11 0 369 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data28.dbf 0 0     9 0 1,782 0.01
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data29.dbf 0 0     1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data32.dbf 2 0 5.00 1.00 33 0 1,861 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data37.dbf 0 0     1 0 817 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data39.dbf 0 0     34 0 2,829 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data43.dbf 0 0     35 0 1,552 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data44.dbf 0 0     33 0 407 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data45.dbf 0 0     41 0 607 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data46.dbf 0 0     22 0 441 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data47.dbf 0 0     27 0 773 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data48.dbf 0 0     24 0 454 0.02
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data49.dbf 0 0     30 0 763 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data50.dbf 0 0     24 0 308 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data51.dbf 0 0     30 0 486 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data52.dbf 0 0     1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data53.dbf 0 0     27 0 329 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data54.dbf 0 0     29 0 351 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data55.dbf 0 0     30 0 173 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data56.dbf 0 0     29 0 424 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data57.dbf 0 0     25 0 365 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data58.dbf 0 0     26 0 418 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data59.dbf 0 0     27 0 304 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data60.dbf 0 0     31 0 192 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data61.dbf 0 0     28 0 195 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data62.dbf 0 0     34 0 399 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data63.dbf 1 0 10.00 13.00 25 0 499 0.04
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data64.dbf 0 0     32 0 623 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data65.dbf 0 0     27 0 313 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data66.dbf 0 0     31 0 207 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data67.dbf 0 0     25 0 327 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data68.dbf 1 0 0.00 15.00 32 0 656 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data69.dbf 1 0 10.00 1.00 32 0 568 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data7.dbf 0 0     1 0 160 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data70.dbf 0 0     33 0 800 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data71.dbf 1 0 20.00 1.00 26 0 705 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data72.dbf 0 0     32 0 599 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data73.dbf 0 0     21 0 391 0.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data74.dbf 0 0     29 0 580 0.02
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data75.dbf 0 0     33 0 369 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data76.dbf 0 0     27 0 445 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data77.dbf 0 0     26 0 168 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data78.dbf 0 0     34 0 508 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx1.dbf 0 0     31 0 1,539 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx10.dbf 0 0     30 0 1,412 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx11.dbf 0 0     26 0 1,063 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx12.dbf 0 0     32 0 778 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx13.dbf 0 0     49 0 1,073 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx14.dbf 0 0     40 0 887 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx15.dbf 0 0     35 0 985 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx16.dbf 0 0     35 0 1,313 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx17.dbf 0 0     31 0 1,451 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx18.dbf 0 0     30 0 1,716 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx19.dbf 0 0     31 0 1,405 0.03
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx2.dbf 0 0     39 0 1,856 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx20.dbf 0 0     36 0 1,652 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx21.dbf 0 0     30 0 1,298 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx22.dbf 0 0     33 0 800 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx23.dbf 0 0     40 0 815 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx24.dbf 0 0     48 0 1,059 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx25.dbf 0 0     45 0 1,145 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx26.dbf 0 0     39 0 1,339 0.04
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx27.dbf 2 0 5.00 1.00 62 0 109 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx28.dbf 2 0 5.00 8.00 26 0 13 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx29.dbf 0 0     39 0 1,635 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx3.dbf 0 0     51 0 2,256 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx30.dbf 0 0     52 0 2,297 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx31.dbf 0 0     45 0 2,920 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx32.dbf 1 0 20.00 7.00 42 0 1,510 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx33.dbf 0 0     46 0 1,558 0.03
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx34.dbf 0 0     45 0 1,879 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx35.dbf 0 0     48 0 3,151 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx36.dbf 0 0     37 0 2,134 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx37.dbf 1 0 0.00 9.00 36 0 1,384 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx38.dbf 0 0     33 0 1,239 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx39.dbf 0 0     41 0 1,014 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx4.dbf 0 0     37 0 271 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx40.dbf 0 0     37 0 442 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx41.dbf 0 0     38 0 1,005 0.05
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx42.dbf 0 0     41 0 1,271 0.04
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx43.dbf 0 0     44 0 1,909 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx44.dbf 0 0     42 0 1,973 0.04
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx45.dbf 0 0     32 0 1,544 0.05
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx46.dbf 0 0     34 0 1,327 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx47.dbf 0 0     38 0 966 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx48.dbf 0 0     43 0 1,400 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx49.dbf 0 0     39 0 1,029 0.01
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx5.dbf 0 0     15 0 12 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx6.dbf 0 0     39 0 1,308 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx7.dbf 0 0     34 0 1,080 0.02
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx8.dbf 0 0     9 0 5 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx9.dbf 0 0     10 0 12 0.00
APPS_UNDOTS1 /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/undo.dbf 0 0     760 2 10,192 0.01
APPS_UNDOTS1 /oracle/visdata/undo1.dbf 0 0     1,840 4 19,418 0.00
SYSAUX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sysaux01.dbf 62 0 3.55 2.15 238 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys1.dbf 2 0 5.00 1.00 4 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys10.dbf 1 0 20.00 1.00 4 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys2.dbf 0 0     6 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys3.dbf 2 0 5.00 1.00 26 0 75 0.27
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys4.dbf 1 0 0.00 1.00 11 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys5.dbf 3 0 0.00 1.00 9 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys6.dbf 1 0 10.00 1.00 14 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys7.dbf 0 0     9 0 1 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys8.dbf 3 0 3.33 1.00 77 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys9.dbf 1 0 0.00 1.00 6 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 1,005,332 100 141,066,326 214 56,878 0 0 120,777


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 17 453 1810 5179 45298440 5179  
E 0 27 5884 189215 1549177 45298440 1549177  

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 816 0.10 100,929 1.37 760,504
D 1,632 0.20 201,858 1.23 682,230
D 2,448 0.30 302,787 1.08 600,412
D 3,264 0.40 403,716 1.03 568,527
D 4,080 0.50 504,645 1.00 554,602
D 4,896 0.60 605,574 1.00 554,602
D 5,712 0.70 706,503 1.00 554,602
D 6,528 0.80 807,432 1.00 554,602
D 7,344 0.90 908,361 1.00 554,602
D 8,160 1.00 1,009,290 1.00 554,602
D 8,976 1.10 1,110,219 1.00 554,602
D 9,792 1.20 1,211,148 1.00 554,602
D 10,608 1.30 1,312,077 1.00 554,602
D 11,424 1.40 1,413,006 1.00 554,602
D 12,240 1.50 1,513,935 1.00 554,602
D 13,056 1.60 1,614,864 1.00 554,602
D 13,872 1.70 1,715,793 1.00 554,602
D 14,688 1.80 1,816,722 1.00 554,602
D 15,504 1.90 1,917,651 1.00 554,602
D 16,320 2.00 2,018,580 1.00 554,476

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 1,180 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 6,144 5,413 239.40 0.00 0.00 0.00 0.00 629,140
E 6,144 5,412 239.10 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 515,827 515,827 0 0
64K 128K 7 7 0 0
256K 512K 24 24 0 0
512K 1024K 33 33 0 0
1M 2M 129 129 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
768 0.13 30,952.38 0.00 100.00 0
1,536 0.25 30,952.38 0.00 100.00 0
3,072 0.50 30,952.38 0.00 100.00 0
4,608 0.75 30,952.38 0.00 100.00 0
6,144 1.00 30,952.38 0.00 100.00 0
7,373 1.20 30,952.38 0.00 100.00 0
8,602 1.40 30,952.38 0.00 100.00 0
9,830 1.60 30,952.38 0.00 100.00 0
11,059 1.80 30,952.38 0.00 100.00 0
12,288 2.00 30,952.38 0.00 100.00 0
18,432 3.00 30,952.38 0.00 100.00 0
24,576 4.00 30,952.38 0.00 100.00 0
36,864 6.00 30,952.38 0.00 100.00 0
49,152 8.00 30,952.38 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
352 0.17 220 10,766 443,848 1.00 159 1.14 16,351,432
560 0.28 329 17,283 443,868 1.00 139 1.00 16,353,111
768 0.38 329 17,283 443,868 1.00 139 1.00 16,353,111
976 0.48 329 17,283 443,868 1.00 139 1.00 16,353,111
1,184 0.59 329 17,283 443,868 1.00 139 1.00 16,353,111
1,392 0.69 329 17,283 443,868 1.00 139 1.00 16,353,111
1,600 0.79 329 17,283 443,868 1.00 139 1.00 16,353,111
1,808 0.90 329 17,283 443,868 1.00 139 1.00 16,353,111
2,016 1.00 329 17,283 443,868 1.00 139 1.00 16,353,111
2,224 1.10 329 17,283 443,868 1.00 139 1.00 16,353,111
2,432 1.21 329 17,283 443,868 1.00 139 1.00 16,353,111
2,640 1.31 329 17,283 443,868 1.00 139 1.00 16,353,111
2,848 1.41 329 17,283 443,868 1.00 139 1.00 16,353,111
3,056 1.52 329 17,283 443,868 1.00 139 1.00 16,353,111
3,264 1.62 329 17,283 443,868 1.00 139 1.00 16,353,111
3,472 1.72 329 17,283 443,868 1.00 139 1.00 16,353,111
3,680 1.83 329 17,283 443,868 1.00 139 1.00 16,353,111
3,888 1.93 329 17,283 443,868 1.00 139 1.00 16,353,111
4,096 2.03 329 17,283 443,868 1.00 139 1.00 16,353,111

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
2,560 0.25 4,588 682,189
5,120 0.50 4,289 554,580
7,680 0.75 4,289 554,580
10,240 1.00 4,289 554,580
12,800 1.25 4,289 554,580
15,360 1.50 4,289 554,580
17,920 1.75 4,289 554,469
20,480 2.00 4,289 554,469

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 89,553 1 0
undo block 27,176 0 0
undo header 2,434 0 0
1st level bmb 1,159 0 0
segment header 439 0 0
extent map 12 0 0
2nd level bmb 5 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,435 3,303 132 569 1 2.06
TX-Transaction (index contention) 5,250 5,250 0 5,227 1 0.13
TX-Transaction 24,704 24,701 0 342 0 0.53
HW-Segment High Water Mark 2,829 2,829 0 581 0 0.19
TX-Transaction (row lock contention) 361 280 81 280 0 0.32
SQ-Sequence Cache 799 799 0 403 0 0.07
FB-Format Block 762 762 0 76 0 0.00
TX-Transaction (allocate ITL entry) 6 6 0 6 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 40.61 24,447 177 15 1015.1/1015.1 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
20-Jul 14:49 40,605 24,447 177 15 1,015 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 320 0.00   0 0  
AWR Alerted Metric Element list 4,611 0.00   0 0  
Consistent RBA 12,864 0.13 0.00 0 0  
FOB s.o list latch 2,311 0.04 0.00 0 0  
In memory undo latch 39,201,579 4.71 0.00 0 16,156 0.01
JS queue state obj latch 2,880 0.00   0 0  
JS slv state obj latch 22 0.00   0 0  
KMG MMAN ready and startup request latch 160 0.00   0 0  
KTF sga latch 2 0.00   0 123 0.00
KWQP Prop Status 59 0.00   0 0  
MQL Tracking Latch 0     0 9 0.00
Memory Management Latch 0     0 160 0.00
OS process 423 0.00   0 0  
OS process allocation 443 0.00   0 0  
OS process: request allocation 251 0.00   0 0  
PL/SQL warning settings 306,583 0.00   0 0  
SGA IO buffer pool latch 25 0.00   0 25 0.00
SQL memory manager latch 1 0.00   0 160 0.00
SQL memory manager workarea list latch 114,903 0.10 0.00 0 0  
Shared B-Tree 301 0.00   0 0  
active checkpoint queue latch 5,823 0.41 0.00 0 0  
active service list 1,414 0.00   0 185 0.00
begin backup scn array 4 0.00   0 0  
bq:time manger info latch 17 0.00   0 0  
bufq statistics 3 0.00   0 0  
cache buffer handles 4,931,616 4.05 0.00 0 0  
cache buffers chains 291,348,962 7.43 0.00 0 523,700 9.59
cache buffers lru chain 137,344 0.08 0.00 0 1,189,018 0.62
channel handle pool latch 463 0.00   0 0  
channel operations parent latch 4,533 0.29 0.00 0 0  
checkpoint queue latch 170,610 0.01 0.00 0 62,257 0.00
client/application info 1,812 0.00   0 0  
compile environment latch 19,173 0.00   0 0  
dml lock allocation 121,646 0.43 0.00 0 0  
dummy allocation 271 0.00   0 0  
enqueue hash chains 224,169 0.60 0.00 0 5 0.00
enqueues 58,913 0.83 0.00 0 0  
event group latch 126 0.00   0 0  
file cache latch 1,191 0.00   0 0  
first spare latch 392 0.00   0 0  
global KZLD latch for mem in SGA 117 0.00   0 0  
global ctx hash table latch 283 0.00   0 0  
hash table column usage latch 0     0 58,350 0.00
hash table modification latch 63 0.00   0 0  
job workq parent latch 0     0 20 0.00
job_queue_processes parameter latch 18 0.00   0 0  
kks stats 1,010 0.00   0 0  
ksuosstats global area 34 0.00   0 0  
ktm global data 212 0.00   0 0  
kwqbsn:qsga 285 0.00   0 0  
lgwr LWN SCN 12,909 0.15 0.00 0 0  
library cache 62,951,598 5.06 0.00 0 0  
library cache load lock 94 0.00   0 0  
library cache lock 10,145,306 1.36 0.00 0 0  
library cache lock allocation 11,128 0.01 0.00 0 0  
library cache pin 37,457,325 1.49 0.00 0 1 0.00
library cache pin allocation 5,432 0.00   0 0  
list of block allocation 9,046 0.06 0.00 0 0  
loader state object freelist 236 0.42 0.00 0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 424 0.47 0.00 0 0  
messages 51,851 0.06 0.00 0 0  
mostly latch-free SCN 13,884 6.28 0.00 0 0  
multiblock read objects 48 0.00   0 0  
ncodef allocation latch 8 0.00   0 0  
object queue header heap 23,778 0.00   0 374 0.00
object queue header operation 305,797 0.03 0.00 0 0  
object stats modification 357 0.56 0.00 0 0  
parallel query alloc buffer 60 0.00   0 0  
parameter list 384 0.00   0 0  
parameter table allocation management 147 0.00   0 0  
post/wait queue 15,256 0.05 0.00 0 7,267 0.06
process allocation 251 1.20 1.00 0 126 0.00
process group creation 251 0.00   0 0  
qmn task queue latch 562 21.89 0.01 0 0  
redo allocation 79,886 2.50 0.00 0 2,550,654 1.59
redo copy 0     0 2,553,794 0.03
redo writing 50,578 0.03 0.00 0 0  
resmgr group change latch 748 0.00   0 0  
resmgr:actses active list 388 0.77 0.00 0 0  
resmgr:actses change group 360 0.00   0 0  
resmgr:free threads list 271 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 757,834 3.99 0.00 0 8 0.00
rules engine rule set statistics 100 0.00   0 0  
sequence cache 1,172,650 2.22 0.00 0 0  
session allocation 1,006,946 3.66 0.00 0 0  
session idle bit 1,945,295 0.03 0.00 0 0  
session state list latch 742 0.27 0.50 0 0  
session switching 8 0.00   0 0  
session timer 185 0.00   0 0  
shared pool 240,935 0.05 0.00 0 0  
shared pool sim alloc 31 0.00   0 0  
shared pool simulator 107,317 0.00   0 0  
simulator hash latch 9,235,889 0.01 0.00 0 0  
simulator lru latch 9,226,184 5.63 0.00 0 3,265 0.00
sort extent pool 1,495 0.94 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 212 0.94 0.00 0 0  
threshold alerts latch 244 0.00   0 0  
transaction allocation 1,550 0.00   0 0  
transaction branch allocation 8 0.00   0 0  
undo global data 43,946,600 0.86 0.00 0 41 0.00
user lock 488 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 291,348,962 21,655,003 29,483 21,625,690 0 0 0
library cache 62,951,598 3,187,428 31 3,187,400 0 0 0
In memory undo latch 39,201,579 1,847,933 2,864 1,845,460 0 0 0
library cache pin 37,457,325 557,443 28 557,426 0 0 0
simulator lru latch 9,226,184 519,376 16 519,364 0 0 0
undo global data 43,946,600 379,008 40 378,986 0 0 0
redo allocation 79,886 1,997 1 1,996 0 0 0
qmn task queue latch 562 123 1 122 0 0 0
process allocation 251 3 3 0 0 0 0
session state list latch 742 2 1 1 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 2,079 978
In memory undo latch ktichg: child 0 291 1,118
In memory undo latch kturbk 0 255 706
In memory undo latch kticmt: child 0 199 0
In memory undo latch ktiTxnPoolFree 0 37 0
In memory undo latch ktbgfc 0 3 61
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 154,899 150,569
cache buffers chains kcbgtcr: fast path 0 41,334 1,196
cache buffers chains kcbgtcr: kslbegin excl 0 15,652 6,827
cache buffers chains kcbchg: kslbegin: call CR func 0 13,327 68,179
cache buffers chains kcbgcur: kslbegin 0 2,364 734
cache buffers chains kcbget: pin buffer 0 1,748 501
cache buffers chains kcbrls: kslbegin 0 1,668 3,819
cache buffers chains kcbzgb: scan from tail. nowait 0 1,410 0
cache buffers chains kcbzwb 0 1,127 482
cache buffers chains kcbcge 0 56 683
cache buffers chains kcb_is_private 0 17 255
cache buffers chains kcbnlc 0 12 64
cache buffers chains kcbesc: escalate 0 9 4
cache buffers chains kcbget: exchange 0 9 27
cache buffers chains kcb_post_apply: kcbhq62 0 5 15
cache buffers chains kcbget: exchange rls 0 3 18
cache buffers chains kcb_post_apply: kcbhq63 0 1 11
cache buffers chains kcb_pre_apply: kcbhq61 0 1 242
cache buffers chains kcbnew: new latch again 0 1 0
cache buffers chains kcbso1: set no access 0 1 2
event range base latch No latch 0 1 1
library cache kglpnc: child 0 9 7
library cache kglpndl: child: after processing 0 8 0
library cache kglpin: child: heap processing 0 4 1
library cache kglpndl: child: before processing 0 4 6
library cache kglobpn: child: 0 2 5
library cache kglpnp: child 0 2 8
library cache kglhdgn: child: 0 1 6
library cache kglpin 0 1 0
library cache pin kglpnp: child 0 12 14
library cache pin kglpndl 0 8 8
library cache pin kglpnc: child 0 7 4
library cache pin kglpnal: child: alloc space 0 1 2
process allocation ksucrp 0 3 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 1 0
session state list latch kpseqd 0 1 1
simulator lru latch kcbs_simulate: simulate set 0 16 16
undo global data kturimugur: child 0 35 15
undo global data ktudba: KSLBEGIN 0 5 31

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 12,044,816 8.53
HR APPS_TS_TX_DATA PAY_RUN_BALANCES   TABLE 8,884,480 6.29
HR APPS_TS_TX_DATA PER_TIME_PERIODS   TABLE 8,518,800 6.03
HR APPS_TS_TX_IDX PAY_PAYROLL_ACTIONS_PK   INDEX 6,344,992 4.49
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 5,733,536 4.06

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
APPLSYS APPS_TS_TX_DATA FND_CONCURRENT_REQUESTS   TABLE 30 13.76
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 0556022_88 TABLE PARTITION 13 5.96
SYS SYSAUX WRH$_TABLESPACE_SPACE_USAGE   TABLE 6 2.75
SYS SYSAUX WRH$_PARAMETER 0556022_88 TABLE PARTITION 5 2.29
SYS SYSAUX WRH$_SYSSTAT 0556022_88 TABLE PARTITION 5 2.29

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 924 16.47
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_FK2   INDEX 531 9.47
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N1   INDEX 446 7.95
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N4   INDEX 446 7.95
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_N50   INDEX 440 7.84

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 3 50.00
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N2   INDEX 2 33.33
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_FK2   INDEX 1 16.67

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
HR APPS_TS_TX_IDX PAY_ACTION_INTERLOCKS_PK   INDEX 9,420 10.60
HR APPS_TS_TX_IDX PAY_ASSIGNMENT_ACTIONS_PK   INDEX 7,765 8.74
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_N4   INDEX 7,412 8.34
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_ACTIONS   TABLE 6,993 7.87
HR APPS_TS_TX_IDX PAY_ACTION_INFORMATION_PK   INDEX 6,977 7.85

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 591 0.00 0   0 74
dc_histogram_data 2,547 0.04 0   0 2,369
dc_histogram_defs 9,011 1.30 0   0 36,700
dc_object_grants 470 0.00 0   0 147
dc_object_ids 85,568 0.01 0   0 6,402
dc_objects 2,273 1.28 0   0 6,562
dc_profiles 127 0.00 0   0 1
dc_rollback_segments 248 0.00 0   0 49
dc_segments 15,039 0.01 0   683 6,430
dc_sequences 396 0.51 0   396 30
dc_table_scns 2 0.00 0   0 1
dc_tablespace_quotas 682 0.00 0   0 3
dc_tablespaces 66,364 0.00 0   0 57
dc_usernames 1,526 0.00 0   0 44
dc_users 71,397 0.00 0   0 77
outstanding_alerts 110 0.00 0   0 109


Back to Top

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 2,987 0.07 1,658,827 -0.00 0 0
CLUSTER 2 0.00 2 0.00 0 0
INDEX 28 0.00 74 0.00 0 0
PIPE 72 0.00 72 0.00 0 0
SQL AREA 75 68.00 14,874,487 0.00 471 0
TABLE/PROCEDURE 4,540 0.33 2,071,216 0.00 0 0
TRIGGER 248 0.00 217,110 -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 163.00   1.85 2.30 22 31 88 88
  Freeable 59.81 0.00 1.07 2.16 10   56 56
  SQL 10.98 5.33 0.14 0.20 1 3 81 79
  PL/SQL 5.64 2.27 0.06 0.04 0 0 88 88
E Other 163.91   1.84 2.28 22 31 89 89
  Freeable 58.31 0.00 1.12 2.22 10   52 52
  SQL 11.23 5.56 0.14 0.20 1 3 82 79
  PL/SQL 5.68 2.40 0.06 0.04 0 0 89 89

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 8,522,825,728  
Fixed Size 2,090,496  
Redo Buffers 31,461,376  
Variable Size 2,164,263,424  

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 PX msg pool 0.39 0.39 0.00
large free memory 15.61 15.61 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor   20.50  
shared KGLS heap 41.14 41.16 0.05
shared KQR M PO 24.46 24.52 0.26
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 1,562.76 1,538.36 -1.56
shared library cache 34.27 34.87 1.77
shared private strands 22.17 22.17 0.00
shared sql area 40.42 60.78 50.38
streams free memory 31.99 31.99 0.00
  buffer_cache 8,128.00 8,128.00 0.00
  fixed_sga 1.99 1.99 0.00
  log_buffer 30.00 30.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 11,791 0 0
QMON Coordinator 6,964 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_20635 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 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

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


Back to Top

End of Report