WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS300141512VIS124-Aug-12 11:0811.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
app0AIX-Based Systems (64-bit) 32 16  62.31

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6124-Aug-12 13:06:2260 9.7
End Snap:6224-Aug-12 13:40:2760 9.7
Elapsed:  34.07 (mins)  
DB Time:  625.22 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 27,904M 27,904MStd Block Size: 8K
Shared Pool Size: 2,304M 2,304MLog Buffer: 119,528K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 18.4 0.2 0.00 0.00
DB CPU(s): 4.5 0.0 0.00 0.00
Redo size: 10,413,553.6 89,980.0  
Logical reads: 1,351,908.6 11,681.4  
Block changes: 68,885.6 595.2  
Physical reads: 65.5 0.6  
Physical writes: 776.6 6.7  
User calls: 11,335.2 97.9  
Parses: 22,520.2 194.6  
Hard parses: 0.0 0.0  
W/A MB processed: 13.3 0.1  
Logons: 0.1 0.0  
Executes: 112,952.1 976.0  
Rollbacks: 0.0 0.0  
Transactions: 115.7   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.83Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 101.28Soft Parse %: 100.00
Execute to Parse %: 80.06Latch Hit %: 96.56
Parse CPU to Parse Elapsd %: 17.42% Non-Parse CPU: 98.78

Shared Pool Statistics

BeginEnd
Memory Usage %: 30.66 30.77
% SQL with executions>1: 81.89 90.03
% Memory for SQL w/exec>1: 74.55 86.50

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 9,183 24.48 
buffer busy waits4,477,7251,11602.97Concurrency
enq: UL - contention41,064854212.28Application
enq: TX - index contention954,57559411.58Concurrency
log file sync81,7729010.24Commit

Host CPU (CPUs: 32 Cores: 16 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
0.02 2.45 54.3 4.6 1.0 41.0
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
14.1 23.8 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 63,808.0 63,808.0
SGA use (MB): 30,720.0 30,720.0
PGA use (MB): 197.8 198.1
% Host Mem used for SGA+PGA: 48.45 48.45

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time36,767.0998.01
PL/SQL execution elapsed time13,587.4536.22
DB CPU9,183.2924.48
parse time elapsed745.161.99
repeated bind elapsed time18.000.05
sequence load elapsed time11.730.03
inbound PL/SQL rpc elapsed time9.430.03
hard parse elapsed time2.180.01
connection management call elapsed time0.920.00
PL/SQL compilation elapsed time0.040.00
hard parse (sharing criteria) elapsed time0.010.00
hard parse (bind mismatch) elapsed time0.000.00
DB time37,513.02 
background elapsed time235.09 
background cpu time21.59 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
NUM_LCPUS0 
NUM_VCPUS0 
AVG_BUSY_TIME120,537 
AVG_IDLE_TIME83,811 
AVG_IOWAIT_TIME2,004 
AVG_SYS_TIME9,427 
AVG_USER_TIME111,052 
BUSY_TIME3,859,532 
IDLE_TIME2,684,110 
IOWAIT_TIME65,410 
SYS_TIME303,709 
USER_TIME3,555,823 
LOAD02
OS_CPU_WAIT_TIME3,700,500 
PHYSICAL_MEMORY_BYTES66,907,537,408 
NUM_CPUS32 
NUM_CPU_CORES16 
GLOBAL_RECEIVE_SIZE_MAX1,048,576 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
24-Aug 13:06:220.02     
24-Aug 13:40:272.4558.9854.344.6441.021.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  9,183 24.48
Concurrency6,329,24201,81804.85
Application45,9840890192.37
Commit81,77209010.24
User I/O152,81703600.09
Network21,748,89201700.05
Configuration27,1720900.03
Other1,890,300100800.02
System I/O1,5230000.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
buffer busy waits4,477,72501,116018.932.97
enq: UL - contention41,0640854210.172.28
enq: TX - index contention954,575059414.031.58
log file sync81,77209010.350.24
cursor: pin S wait on X4105413180.000.14
latch: cache buffers chains826,17404803.490.13
enq: TX - row lock contention4,49603680.020.10
db file sequential read131,03203200.550.09
SQL*Net message to client21,747,656017091.920.05
enq: SQ - contention26,8100800.110.02
buffer deadlock651,040100702.750.02
latch: In memory undo latch64,2590600.270.02
read by other session4,1330200.020.00
asynch descriptor resize1,238,326100105.230.00
Disk file operations I/O15,3580100.060.00
undo segment extension109011260.000.00
library cache: mutex X3,9660000.020.00
db file scattered read1560010.000.00
control file sequential read1,5230000.010.00
SQL*Net break/reset to client4240000.000.00
cursor: pin S2,2200000.010.00
enq: HW - contention2220000.000.00
utl_file I/O2,1200000.010.00
kksfbc child completion11000500.000.00
enq: TX - allocate ITL entry1300000.000.00
SQL*Net more data to client1,2340000.010.00
latch: cache buffer handles4750000.000.00
enq: TX - contention130010.000.00
latch: redo allocation2170000.000.00
latch free1210000.000.00
cursor: mutex S277100000.000.00
direct path write180000.000.00
latch: enqueue hash chains650000.000.00
latch: undo global data190000.000.00
enq: DV - contention210000.000.00
SQL*Net message from client21,747,656081,147491.92 
pipe get8171002,03924960.00 
PL/SQL lock timer6421001,92930050.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write263,52109701.1141.39
db file parallel write139,71305900.5925.06
control file sequential read2,5270210.011.06
control file parallel write1,0310210.000.65
reliable message3430010.000.21
LGWR wait for redo copy31,5110000.130.19
os thread startup700640.000.19
rdbms ipc reply3430010.000.13
Disk file operations I/O1,3340000.010.02
db file sequential read70010.000.00
latch: redo allocation1590000.000.00
direct path write120000.000.00
rdbms ipc message250,104428,1391131.06 
DIAG idle wait4,0751004,08210020.02 
Streams AQ: qmn slave idle wait71804,07656760.00 
pmon timer930722,04521990.00 
Space Manager: slave idle wait4081002,04150020.00 
Streams AQ: qmn coordinator idle wait720412,03828300.00 
smon timer15331,9951330200.00 
SQL*Net message from client8570110.00 
class slave wait70010.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
Disk file operations I/O16.7K100.0       
LGWR wait for redo copy31.5K99.9.1.0.0    
SQL*Net break/reset to client42495.02.4.71.2.2.5  
SQL*Net message to client21.7M100.0       
SQL*Net more data from client2100.0       
SQL*Net more data to client1234100.0       
asynch descriptor resize1237.7K100.0       
buffer busy waits4475.9K94.24.9.8.1.0.0.0 
buffer deadlock651K100.0.0.0.0.0   
control file parallel write103179.85.55.84.33.21.4  
control file sequential read405090.32.53.02.51.1.4.1 
cursor: mutex S271100.0       
cursor: pin S222099.6.4      
cursor: pin S wait on X41     2.422.075.6
db file parallel write139.7K99.0.9.0.0.0.0.0 
db file scattered read15625.075.0      
db file sequential read130.8K99.3.4.1.1.0.0.0 
direct path write30100.0       
enq: DV - contention21100.0       
enq: FB - contention1100.0       
enq: HW - contention22295.04.1.9     
enq: SQ - contention26.8K98.31.5.2.0    
enq: TX - allocate ITL entry13096.93.1      
enq: TX - contention1346.238.515.4     
enq: TX - index contention954.6K80.517.61.9.1.0.0.0 
enq: TX - row lock contention449679.32.82.212.01.21.01.2.3
enq: UL - contention41.1K10.110.511.310.710.429.017.9.1
kksfbc child completion1      100.0 
latch free13298.51.5      
latch: In memory undo latch64.3K99.6.2.1.0    
latch: cache buffer handles475100.0       
latch: cache buffers chains825.7K99.5.4.1.0.0.0  
latch: cache buffers lru chain2100.0       
latch: enqueue hash chains65100.0       
latch: object queue header operation7100.0       
latch: redo allocation376100.0       
latch: row cache objects5100.0       
latch: undo global data19100.0       
library cache: mutex X397699.2.3.5     
log file parallel write263.5K95.31.91.81.0.0.0.0 
log file sync81.7K78.69.46.05.0.8.1.1 
os thread startup7      100.0 
rdbms ipc reply34379.0.916.04.1    
read by other session413198.31.2.3 .1   
reliable message34376.13.5.320.1    
undo segment extension1040.0    10.050.0 
utl_file I/O2119100.0       
DIAG idle wait4075      100.0.0
PL/SQL lock timer642       100.0
SQL*Net message from client21.7M98.9.5.3.0.0.0.2.0
Space Manager: slave idle wait409       100.0
Streams AQ: qmn coordinator idle wait72344.82.12.43.54.71.0.341.4
Streams AQ: qmn slave idle wait72117.1      82.9
class slave wait785.7   14.3   
pipe get818      .199.9
pmon timer9303.3.2.1.2.2.515.480.0
rdbms ipc message250.1K67.78.55.25.23.82.24.43.1
smon timer15      13.386.7

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
buffer busy waits16100.0.0   .0  
control file sequential read499.9.1      
cursor: pin S wait on X402.4 7.37.37.3 75.6 
db file parallel write4100.0.0      
db file sequential read3100.0.0.0     
enq: TX - index contention4100.0.0      
enq: TX - row lock contention5898.6.9.1.0.1.0.1.2
enq: UL - contention736582.017.8.1    .1
kksfbc child completion1 100.0      
log file parallel write8100.0.0.0.0    
log file sync7199.9.0.0.0    
os thread startup7 71.428.6     
undo segment extension550.010.010.010.010.010.0  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
enq: TX - row lock contention799.8.2      
enq: UL - contention2999.9 .1     

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
VIS37,5049,1811332,763,638
SYS$USERS930184
SYS$BACKGROUND0017

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
VIS 1518803563292351818002174886917
SYS$USERS 94007000250
SYS$BACKGROUND 135301900000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
26,958.65249,0890.1171.8624.230.065sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
26,906.65249,2620.1171.7324.230.064f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
2,558.0113818.546.8212.600.13dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1,432.463,712,6850.003.8226.070.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,403.64249,9350.013.7411.290.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
1,217.082,722,4550.003.2426.730.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,160.943,721,5420.003.0927.960.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
963.421,497,1530.002.5711.950.15fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
921.9428,170,5090.002.4623.860.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
909.851,483,7570.002.4325.800.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
714.953,372,6750.001.9146.510.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
695.598,3330.081.8512.460.047y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
661.95999,8040.001.7614.610.28bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
547.751,110,2310.001.4627.030.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
524.1810,588,4870.001.4029.510.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
518.03247,9470.001.382.940.2047g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
492.29249,8800.001.314.791.347d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
462.814,190,4030.001.2323.890.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
455.2013,369,8040.001.2124.030.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
426.91248,1130.001.142.830.009jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
396.55249,5510.001.063.510.0036z3h9rgkd8aa PYUSLV begin hrassact.update_action_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
6,530.80249,0890.0371.1226,958.6524.230.065sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
6,518.31249,2620.0370.9826,906.6524.230.064f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
373.403,712,6850.004.071,432.4626.070.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
332.493,372,6750.003.62714.9546.510.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
325.282,722,4550.003.541,217.0826.730.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
324.623,721,5420.003.531,160.9427.960.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
322.421382.343.512,558.0112.600.13dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
234.751,483,7570.002.56909.8525.800.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
219.9828,170,5090.002.40921.9423.860.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
158.52249,9350.001.731,403.6411.290.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
154.7110,588,4870.001.68524.1829.510.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
148.051,110,2310.001.61547.7527.030.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
115.101,497,1530.001.25963.4211.950.15fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
110.554,190,4030.001.20462.8123.890.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
109.3813,369,8040.001.19455.2024.030.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
96.69999,8040.001.05661.9514.610.28bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
17.45249,2620.0049.0426,906.6524.230.064f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
17.39249,0890.0048.8626,958.6524.230.065sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
14.72247,7420.0041.3738.68124.3738.067dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PAI...
6.59249,8800.0018.51492.294.791.347d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
3.371380.029.462,558.0112.600.13dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1.85999,8040.005.19661.9514.610.28bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
1.491,497,1530.004.19963.4211.950.15fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
1.27249,8660.003.57236.751.660.54g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
1.05247,9470.002.96518.032.940.2047g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
0.81498,2830.002.29160.751.200.51fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
1,953,222,327249,0897,841.4670.6726,958.6524.230.065sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,951,037,586249,2627,827.2670.5926,906.6524.230.064f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
209,081,1803,712,68556.327.561,432.4626.070.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
187,147,3152,722,45568.746.771,217.0826.730.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
184,092,2551,483,757124.076.66909.8525.800.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
155,287,3723,721,54241.735.621,160.9427.960.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
127,718,558138925,496.804.622,558.0112.600.13dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
117,031,73413,369,8048.754.23455.2024.030.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
113,083,8081,110,231101.864.09547.7527.030.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
112,962,93910,588,48710.674.09524.1829.510.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
85,140,09014,454,5055.893.08372.6624.070.00cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
83,870,375249,935335.573.031,403.6411.290.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
81,551,85928,170,5092.892.95921.9423.860.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
75,025,374249,551300.642.71396.553.510.0036z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
73,776,153249,880295.252.67492.294.791.347d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
71,982,109249,896288.052.60302.053.890.007vku4w123mkap PYUSLV SELECT /*+ ORDERED INDEX (ac2 ...
67,324,6604,190,40316.072.44462.8123.890.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
65,839,805249,883263.482.38265.3820.200.002dqtvtdcud8mb PYUSLV SELECT ACTION_INFORMATION_ID, ...
64,034,2843,372,67518.992.32714.9546.510.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
55,531,783998,21255.632.01286.092.250.00f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...
54,413,454247,947219.461.97518.032.940.2047g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
52,642,26413,434,8533.921.90311.8523.630.009wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
45,833,2593,098,24814.791.66254.0026.830.08bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
44,517,9346,437,2746.921.61192.6128.080.005p88n2zhuqfd9 PYUSLV SELECT PPA.EFFECTIVE_DATE, PPA...
42,596,06714,467,4912.941.54275.8923.860.0077d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
37,986,0621,497,15325.371.37963.4211.950.15fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
33,925,587249,226136.121.23263.2220.120.007yathjvssqxz9 PYUSLV SELECT PTS.TIME_IN_STATE, PTS....
31,213,887249,054125.331.13309.722.230.002tr0101sa3jh2 PYUSLV BEGIN FFP1893_01010001.FORMULA...
29,108,141999,80429.111.05661.9514.610.28bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
28,510,234498,28357.221.03160.751.200.51fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...
28,058,519248,113113.091.02426.912.830.009jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
27,944,187496,40956.291.01163.6726.660.003n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...
27,642,2648,3333,317.201.00695.5912.460.047y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
72,650249,0890.2954.2326,958.6524.230.065sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
72,601249,2620.2954.1926,906.6524.230.064f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
64,924247,7420.2648.4638.68124.3738.067dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PAI...
28,182249,8800.1121.04492.294.791.347d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
7,53413854.595.622,558.0112.600.13dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
4,587249,8660.023.42236.751.660.54g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
3,911999,8040.002.92661.9514.610.28bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
3,6541,497,1530.002.73963.4211.950.15fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
3,500247,9470.012.61518.032.940.2047g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
2,409498,2830.001.80160.751.200.51fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
72,73872,738249,2620.290.0055.154f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
72,60272,602249,0890.290.0055.055sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
64,92564,925247,7420.260.0049.227dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PAI...
28,17328,173249,8800.110.0021.367d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
7,5687,56813854.840.005.74dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
4,5864,586249,8660.020.003.48g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
3,9113,911999,8040.000.002.97bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
3,6563,6561,497,1530.000.002.77fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
3,5003,500247,9470.010.002.6547g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
2,4122,412498,2830.000.001.83fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
28,170,50942,928,1901.52921.9423.860.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
14,467,49114,447,2241.00275.8923.860.0077d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
14,454,50514,335,8790.99372.6624.070.00cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
13,434,85313,372,5531.00311.8523.630.009wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
13,369,80413,128,9240.98455.2024.030.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
10,588,48710,364,2500.98524.1829.510.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
6,437,2746,385,5560.99192.6128.080.005p88n2zhuqfd9 PYUSLV SELECT PPA.EFFECTIVE_DATE, PPA...
4,190,40300.00462.8123.890.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
3,721,5423,676,9370.991,160.9427.960.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,712,6853,673,9940.991,432.4626.070.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,372,6753,370,8731.00714.9546.510.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
3,098,24800.00254.0026.830.08bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
2,722,4552,678,3690.981,217.0826.730.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
27,033,92828,170,50958.724gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
3,725,4513,712,6858.09g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,722,1233,721,5428.087rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
2,727,2132,722,4555.92dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,478,7441,483,7573.2101pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
1,115,6311,110,2312.428v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
739,839746,4161.61fqgs7vbu8htby PYUSLV SELECT fnd_number.number_to_ca...
499,214497,6831.0883kbt99vg4svq PYUSLV begin hr_nonrun_asact.reinter...
494,840495,2141.07165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
494,797496,4091.073n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01pkua627ktjk SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y')
02k10jzw8c495SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
165d2bgc2b9hrSELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment within a Government Reporting Entity for YTD based on run balances */ pay_run_balances prb, pay_defined_balances pdb, pay_payroll_actions ppa, pay_assignment_actions paa where paa.assignment_action_id = :ASSIGNMENT_ACTION_ID and prb.tax_unit_id = :TAX_UNIT_ID and ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id and paa.assignment_id = prb.assignment_id and prb.action_sequence <= paa.action_sequence and prb.effective_date >= trunc(ppa.effective_date, 'Y')
2dqtvtdcud8mbSELECT ACTION_INFORMATION_ID, EFFECTIVE_DATE, OBJECT_VERSION_NUMBER FROM PAY_ACTION_INFORMATION WHERE ACTION_CONTEXT_ID = :B2 AND ACTION_CONTEXT_TYPE = 'AAP' AND ASSIGNMENT_ID = :B1 AND ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS'
2tr0101sa3jh2BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T5, :I5, :T4, :I4, :T6, :I6, :N5, :T8, :I8, :N4, :N3, :T3, :I3, :T7, :I7, :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
47g6xx472xzudBEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I13, :D2, :I8, :T3, :I3, :T8, :I15, :N6, :I11, :T7, :I14, :N4, :I9, :D1, :N12, :I19, :N10, :I17, :N7, :I12, :N11, :I18, :T6, :I6, :N1, :T2, :I2, :N5, :I10, :N9, :I16, :FFERLN, :FFERCD, :FFERMT); END;
4ds53shhfcynndeclare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3udeclare begin pay_archive.process_employee(:asg_action); end;
4gz4b2bh1fs14SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
5p88n2zhuqfd9SELECT PPA.EFFECTIVE_DATE, PPA.BUSINESS_GROUP_ID, PPA.PAYROLL_ID, PPA.ACTION_TYPE FROM PAY_PAYROLL_ACTIONS PPA, PAY_ASSIGNMENT_ACTIONS PAA WHERE PAA.ASSIGNMENT_ACTION_ID = :B1 AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
5sfm6rppc4y8xBEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
6500rnmy4f88wSELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE
6v07302134wyfINSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
77d28bpwm9svgSELECT PBV.RUN_BALANCE_STATUS, PBV.BALANCE_LOAD_DATE FROM PAY_BALANCE_VALIDATION PBV WHERE PBV.DEFINED_BALANCE_ID = :B2 AND PBV.BUSINESS_GROUP_ID = :B1
7d66dw0vz7yaabegin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7dm9q8dwzhxnpSELECT PAI.EFFECTIVE_DATE, PAI.ACTION_CONTEXT_ID FROM PAY_ACTION_INFORMATION PAI WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAI.ASSIGNMENT_ID = :B4 AND PAI.ACTION_INFORMATION_CATEGORY = :B3 AND PAI.ACTION_CONTEXT_ID <> :B2 AND PAI.EFFECTIVE_DATE <= :B1 ORDER BY PAI.EFFECTIVE_DATE DESC , PAI.ACTION_CONTEXT_ID DESC
7rks7t2gukcwn SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decod e(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') /* Within Jurisdiction */ and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
7vku4w123mkap SELECT /*+ ORDERED INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N51) (pa2 PAY_PAYROLL_ACTIONS_PK) */ AC2.ROWID, AC2.ASSIGNMENT_ACTION_ID, AC2.SOURCE_ACTION_ID, AC2.OBJECT_TYPE FROM PAY_PAYROLL_ACTIONS PAC, PER_ALL_ASSIGNMENTS_F ASG, PER_ALL_ASSIGNMENTS_F AS2, PAY_ASSIGNMENT_ACTIONS ACT, PAY_ASSIGNMENT_ACTIONS AC2, PAY_PAYROLL_ACTIONS PA2, PAY_ACTION_CLASSIFICATIONS ACL WHERE PAC.PAYROLL_ACTION_ID = :B4 AND ACT.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID AND ACT.ASSIGNMENT_ID = :B3 AND ACT.SOURCE_ACTION_ID IS NULL AND ASG.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PAC.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE AND AS2.PERSON_ID = ASG.PERSON_ID AND DECODE(:B2 , 'G', PAC.EFFECTIVE_DATE, AS2.EFFECTIVE_END_DATE) >= PAC.EFFECTIVE_DATE AND AC2.ASSIGNMENT_ID = AS2.ASSIGNMENT_ID AND PA2.PAYROLL_ACTION_ID = AC2.PAYROLL_ACTION_ID AND AS2.EFFECTIVE_START_DATE = (SELECT MAX(PAF3.EFFECTIVE_START_DATE) FROM PER_ALL_ASSIGNMENTS_F PAF3 WHERE PAF3.ASSIGNMENT_ID = AC2.ASSIGNMENT_ID ) AND ACL.CLASSIFICATION_NAME = 'SEQUENCED' AND PA2.ACTION_TYPE = ACL.ACTION_TYPE AND AC2.ACTION_SEQUENCE > :B1 AND (AC2.SOURCE_ACTION_ID IS NULL OR (AC2.OBJECT_ID IS NOT NULL AND AC2.OBJECT_TYPE = 'POG') ) ORDER BY PA2.EFFECTIVE_DATE, AC2.ACTION_SEQUENCE FOR UPDATE OF AC2.ASSIGNMENT_ACTION_ID
7y9t68kb4mc6qBEGIN pay_us_action_arch.action_action_creation(:pactid, :stperson, :endperson, :chunk); END;
7yathjvssqxz9SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, DECODE(PST.SIT_EXEMPT, 'Y', 'Exempt', 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, PAY_US_EMP_STATE_TAX_RULES_F PST WHERE PTS.ASSIGNMENT_ID = :B2 AND PTS.JURISDICTION_CODE LIKE :B1 AND PST.ASSIGNMENT_ID = PTS.ASSIGNMENT_ID
83kbt99vg4svq begin hr_nonrun_asact.reinterlock (:assactid, :pactype); end;
8v2cvg5zhw9ua SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
9jv68n0ctas75begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
9wupzu1crbdbbSELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1
bkzygbymgqf34INSERT INTO PAY_ASSIGNMENT_ACTIONS ( ASSIGNMENT_ACTION_ID, ASSIGNMENT_ID, PAYROLL_ACTION_ID, ACTION_STATUS, CHUNK_NUMBER, ACTION_SEQUENCE, PRE_PAYMENT_ID, OBJECT_VERSION_NUMBER, TAX_UNIT_ID, SOURCE_ACTION_ID, OBJECT_ID, OBJECT_TYPE, START_DATE, END_DATE) SELECT :B12 , :B11 , :B10 , :B9 , :B8 , PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL, :B7 , 1, :B6 , :B5 , :B4 , :B3 , :B2 , :B1 FROM DUAL
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
cn5un9cxnah8wSELECT 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
dab1prc9qyv3v begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end;
dz7tyjxnar7gt SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT. action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and R R.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and exists (select null from pay_taxability_rules TR , pay_element_types_f ET , pay_balance_types BT where ET.element_type_id = RR.element_type_id and PACT.date_earned between ET.effective_start_date and ET.effective_end_date and BT.balance_type_id = :U1 and TR.classification_id = ET.classification_id + 0 and TR.tax_category = ET.element_information1 and TR.tax_type = BT.tax_type and TR.jurisdiction_code = '00-000-0000' and nvl(TR.status, 'VALID') <> 'D' )
f78ff26qcfjanupdate PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S')
fbpf0hy40v80s select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , decode(RR.source_type, 'E', nvl(EE.creator_type, 'X'), 'I', decode(EE.creator_type, null , 'X', 'N')) , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_cost_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_d ate and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_id=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_type<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E ') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) and (:b19=0 or (:b19 <>0 and exists (select null from pay_ele_classification_rules ECR where ((ECR.element_set_id=:b19 and ET.classification_id=ECR.classification_id) and not exists (select null from pay_element_type_rules ETR where ((ETR.element_set_id=:b19 and ETR.element_type_id=ET.element_type_id) and ETR.include_or_exclude='E'))) union select null from pay_element_type_rules ETR where ((ETR.element_set_id=:b19 and ETR.element_type_id=ET.element_type_id) and ETR.include_or_exclude='I'))))) order by 17, 8, 14
fkrq6dbyub3fvINSERT INTO PAY_ACTION_INTERLOCKS ( LOCKING_ACTION_ID, LOCKED_ACTION_ID) VALUES (:B2 , :B1 )
fqgs7vbu8htbySELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment For Run */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_payroll_actions PACT where ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA')
g2daxnc5b7rav SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.ac tion_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assig nment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date
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
grg3zu94xp62hSELECT PDB.BALANCE_TYPE_ID, PDR.ROUTE_ID, PDR.BALANCE_TYPE_COLUMN, PDR.RETRIEVAL_COLUMN, NVL(PDR.DECODE_REQUIRED, 'N'), NVL(JURISDICTION_LEVEL, 0) FROM PAY_DEFINED_BALANCES PDB, PAY_DIMENSION_ROUTES PDR, PAY_BALANCE_TYPES PBT WHERE PDB.DEFINED_BALANCE_ID = :B2 AND PDB.BALANCE_DIMENSION_ID = PDR.BALANCE_DIMENSION_ID AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID AND PDR.PRIORITY = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced123,77460.540.52
CCursor + sql area evicted00.000.00
CPU used by this session724,971354.613.06
CPU used when call started724,908354.583.06
CR blocks created10,300,2115,038.2843.53
Cached Commit SCN referenced5,544,7192,712.1623.43
Commit SCN cached361,757176.951.53
DB time4,123,8242,017.1417.43
DBWR checkpoint buffers written1,587,239776.396.71
DBWR checkpoints00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR transaction table writes2360.120.00
DBWR undo block writes982,187480.434.15
HSC Heap Segment Block Changes18,100,7168,853.8576.50
Heap Segment Array Inserts2,090,0131,022.328.83
Heap Segment Array Updates106,95952.320.45
IMU CR rollbacks1,654,484809.286.99
IMU Flushes148,46572.620.63
IMU Redo allocation size1,266,404,748619,453.605,352.49
IMU commits88,35043.220.37
IMU contention84,79841.480.36
IMU ktichg flush2170.110.00
IMU recursive-transaction flush2,2871.120.01
IMU undo allocation size2,721,051,0081,330,984.3111,500.59
Number of read IOs issued00.000.00
RowCR - row contention126,80962.030.54
RowCR attempts14,638,5147,160.3361.87
RowCR hits14,506,6397,095.8361.31
SMON posted for undo segment shrink100.000.00
SQL*Net roundtrips to/from client21,747,63210,637.7191.92
active txn count during cleanout74,257,98936,322.81313.85
application wait time89,01043.540.38
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts10,2104.990.04
branch node splits5310.260.00
buffer is not pinned count1,590,591,252778,027.316,722.67
buffer is pinned count747,175,582365,476.053,157.96
bytes received via SQL*Net from client5,806,441,6082,840,182.9424,541.07
bytes sent via SQL*Net to client3,285,859,5121,607,256.6913,887.77
calls to get snapshot scn: kcmgss219,020,743107,132.56925.70
calls to kcmgas12,186,2765,960.8451.51
calls to kcmgcs20,914,08710,229.9988.39
cell physical IO interconnect bytes36,358,699,00817,784,619.87153,670.94
change write time39,72619.430.17
cleanout - number of ktugct calls12,852,4116,286.6754.32
cleanouts only - consistent read gets9,958,0864,870.9342.09
cluster key scan block gets1,1470.560.00
cluster key scans8770.430.00
commit batch/immediate performed44,63621.830.19
commit batch/immediate requested44,63621.830.19
commit cleanout failures: block lost4240.210.00
commit cleanout failures: buffer being written10.000.00
commit cleanout failures: callback failure292,649143.151.24
commit cleanout failures: cannot pin80,94139.590.34
commit cleanouts6,563,7753,210.6327.74
commit cleanouts successfully completed6,189,7603,027.6826.16
commit immediate performed44,63621.830.19
commit immediate requested44,63621.830.19
commit txn count during cleanout1,359,812665.145.75
concurrency wait time181,80188.930.77
consistent changes437,712,292214,104.111,850.00
consistent gets2,585,949,1571,264,900.1210,929.58
consistent gets - examination1,802,597,377881,728.727,618.72
consistent gets direct00.000.00
consistent gets from cache2,585,949,1571,264,900.1210,929.58
consistent gets from cache (fastpath)582,309,394284,832.832,461.15
cursor authentications1460.070.00
data blocks consistent reads - undo records applied437,351,367213,927.561,848.48
db block changes140,828,94568,885.56595.22
db block gets177,879,31087,008.50751.81
db block gets direct1930.090.00
db block gets from cache177,879,11787,008.41751.81
db block gets from cache (fastpath)42,843,58220,956.66181.08
deferred (CURRENT) block cleanout applications387,148189.371.64
dirty buffers inspected00.000.00
enqueue conversions1,1230.550.00
enqueue releases2,594,6201,269.1410.97
enqueue requests2,595,4091,269.5310.97
enqueue timeouts7900.390.00
enqueue waits1,027,332502.514.34
exchange deadlocks651,229318.542.75
execute count230,918,066112,952.06975.98
failed probes on index block reclamation6520.320.00
file io service time00.000.00
file io wait time96,539,61547,221.72408.03
free buffer inspected2,182,1471,067.389.22
free buffer requested12,210,9725,972.9251.61
heap block compress356,936174.591.51
hot buffers moved to head of LRU539,727264.002.28
immediate (CR) block cleanout applications9,958,1634,870.9742.09
immediate (CURRENT) block cleanout applications1,252,782612.795.29
index crx upgrade (positioned)00.000.00
index fetch by key366,162,504179,105.991,547.59
index scans kdiixs1374,894,082183,376.991,584.50
leaf node 90-10 splits33,09416.190.14
leaf node splits128,85663.030.54
lob reads00.000.00
lob writes1290.060.00
lob writes unaligned1290.060.00
logons cumulative2210.110.00
max cf enq hold time250.010.00
messages received403,729197.481.71
messages sent403,729197.481.71
min active SCN optimization applied on CR72,838,40635,628.43307.85
no buffer to keep pinned count730.040.00
no work - consistent read gets705,995,093345,332.882,983.91
non-idle wait count37,367,92918,278.28157.94
non-idle wait time303,047148.231.28
opened cursors cumulative218,837,895107,043.13924.92
parse count (describe)70.000.00
parse count (failures)00.000.00
parse count (hard)320.020.00
parse count (total)46,040,07122,520.20194.59
parse time cpu11,1885.470.05
parse time elapsed64,20731.410.27
physical read IO requests131,89564.520.56
physical read bytes1,097,433,088536,802.224,638.33
physical read total IO requests136,28266.660.58
physical read total bytes1,166,729,216570,697.974,931.21
physical read total multi block requests1040.050.00
physical reads133,96465.530.57
physical reads cache132,91265.010.56
physical reads cache prefetch2,0691.010.01
physical reads direct1,0520.510.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests139,99368.480.59
physical write bytes13,006,184,4486,361,890.0754,970.96
physical write total IO requests607,043296.932.57
physical write total bytes35,191,969,79217,213,921.90148,739.73
physical write total multi block requests114,29555.910.48
physical writes1,587,669776.606.71
physical writes direct4300.210.00
physical writes direct (lob)370.020.00
physical writes from cache1,587,239776.396.71
physical writes non checkpoint997,769488.054.22
pinned buffers inspected1,3770.670.01
pinned cursors current00.000.00
prefetch warmup blocks aged out before use14,0436.870.06
prefetched blocks aged out before use190.010.00
process last non-idle time00.000.00
recursive aborts on index block reclamation340.020.00
recursive calls403,936,411197,582.851,707.25
recursive cpu usage713,249348.883.01
redo blocks checksummed by FG (exclusive)8,095,0123,959.6234.21
redo blocks written43,232,63621,146.96182.72
redo entries73,618,18636,009.85311.15
redo ordering marks762,526372.983.22
redo size21,289,364,84810,413,553.6089,980.03
redo size for direct writes2,2361.090.01
redo subscn max counts1,368,929669.605.79
redo synch time9,0434.420.04
redo synch writes94,61246.280.40
redo wastage116,123,86456,801.23490.80
redo write time11,1415.450.05
redo writes263,521128.901.11
rollback changes - undo records applied190,73693.300.81
root node splits00.000.00
rows fetched via callback261,124,951127,727.561,103.65
session connect time00.000.00
session cursor cache hits6,390,0883,125.6727.01
session logical reads2,763,828,4671,351,908.6211,681.39
shared hash latch upgrades - no wait44,267,73921,653.28187.10
shared hash latch upgrades - wait2,447,0771,196.9710.34
sorts (memory)19,554,1469,564.7882.65
sorts (rows)43,729,40521,389.95184.82
sql area evicted00.000.00
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer656,652321.202.78
table fetch by rowid838,788,513410,287.923,545.16
table fetch continued row3,8421.880.02
table scan blocks gotten19,484,6449,530.7982.35
table scan rows gotten846,284,346413,954.453,576.84
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)8,828,0344,318.1837.31
total cf enq hold time5030.250.00
total number of cf enq holders860.040.00
total number of times SMON posted100.000.00
transaction rollbacks44,63621.830.19
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size7,586,272,3443,710,775.5132,063.57
user I/O wait time3,5581.740.02
user calls23,173,65111,335.2497.94
user commits236,601115.731.00
workarea executions - optimal13,737,1866,719.4558.06
write clones created in foreground170.010.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current582582
logons current6060
session uga memory max1,735,890,3202,664,618,320
session pga memory143,851,552143,917,088
session pga memory max196,476,960196,542,496
session cursor cache count46,54672,101
session uga memory84,076,28894,854,016

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR0M0.000M20.6G226.9410.32530 
DBWR0M0.000M12.1G68.346.065860 
Buffer Cache Reads1G63.88.5072410M0.000M130.7K0.02
Others67M2.15.03277248M1.53.02347854180.56
Direct Reads8M0.51.0039131M0.06.0004890 
Direct Writes0M0.000M3M0.06.0014670 
TOTAL:1.1G66.54.54392732.8G296.9316.4166136.1K0.04

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Log File0M0.000M20.6G226.9410.3253  
Data File1G64.66.51164412.1G68.486.065370.030.86
Control File63M1.99.03081649M1.52.0239680.47 
TOTAL:1.1G66.65.54246032.8G296.9416.41460.040.86

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR 0M0.000M20.6G226.9410.32530 
LGWR (Log File) 0M0.000M20.6G226.9410.32530 
DBWR 0M0.000M12.1G68.346.065860 
DBWR (Data File) 0M0.000M12.1G68.346.065860 
Buffer Cache Reads 1G63.88.5072410M0.000M130.7K0.02
Buffer Cache Reads (Data File) 1G63.88.5072410M0.000M130.7K0.02
Others 67M2.15.03277248M1.53.02347843990.44
Others (Control File) 64M1.99.03130548M1.52.02347840620.47
Others (Data File) 3M0.16.0014670M0.010M3370.00
Direct Reads 8M0.51.0039131M0.06.0004890 
Direct Reads (Data File) 8M0.51.0039131M0.06.0004890 
Direct Writes 0M0.000M3M0.06.0014670 
Direct Writes (Data File) 0M0.000M3M0.06.0014670 
TOTAL: 1.1G66.55.54392732.8G296.9316.4166135.1K0.03

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_TX_DATA 82,560400.241.0322,41111400,4560.07
APPS_TS_TX_IDX 48,700240.261.0041,367203,948,4310.27
APPS_UNDOTS1 800.001.0075,64137415,7450.03
SYSAUX 22700.351.00375000.00
SYSTEM 9100.441.006907900.10
APPS_TS_ARCHIVE 600.001.00730250.80
APPS_TS_SEED 3500.291.0040942.87
APPS_TS_SUMMARY 1200.001.0012000.00
CWMLITE 1400.001.002000.00
DCM 1200.001.002000.00
GEOR_TBS 1200.001.002000.00
B2B_LOB 700.001.001000.00
B2B_RT 700.001.001000.00
BAM 700.001.001000.00
CTXSYS 700.001.001000.00
OLTS_ATTRSTORE 700.001.001000.00
OLTS_BATTRSTORE 700.001.001000.00
OLTS_CT_STORE 700.001.001000.00
OLTS_DEFAULT 700.001.001000.00
OLTS_SVRMGSTORE 700.001.001000.00
OPMOR 700.001.001000.00
B2B_DT 600.001.001000.00
B2B_IDX 600.001.001000.00
DISCO_PTM5_CACHE 600.001.001000.00
DISCO_PTM5_META 600.001.001000.00
DSGATEWAY_TAB 600.001.001000.00
HTMLDB 600.001.001000.00
IAS_META 600.001.001000.00
MTR 600.001.001000.00
NOETIX 600.001.001000.00
NON_APPS_TS_DATA 600.001.001000.00
OCATS 600.001.001000.00
ODM_DATA 600.001.001000.00
ORABPEL 600.001.001000.00
OWAPUB 600.001.001000.00
PORTAL 600.001.001000.00
PORTAL_DOC 600.001.001000.00
PORTAL_IDX 600.001.001000.00
PORTAL_LOG 600.001.001000.00
RE 600.001.001000.00
SYNCSERVER 600.001.001000.00
UDDISYS_TS 600.001.001000.00
WCRSYS_TS 600.001.001000.00
XDB 600.001.001000.00
APPS_TS_TOOLS 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_ARCHIVE/oasb_data/archive1.dbf 600.001.00730250.80
APPS_TS_SEED/oasb_data/reference1.dbf 200.001.001010.00
APPS_TS_SEED/oasb_data/reference10.dbf 100.001.000000.00
APPS_TS_SEED/oasb_data/reference11.dbf 100.001.000000.00
APPS_TS_SEED/oasb_data/reference12.dbf 100.001.000000.00
APPS_TS_SEED/oasb_data/reference13.dbf 300.001.000020.00
APPS_TS_SEED/oasb_data/reference15.dbf 100.001.000010.00
APPS_TS_SEED/oasb_data/reference19.dbf 200.001.000060.00
APPS_TS_SEED/oasb_data/reference2.dbf 300.001.000060.00
APPS_TS_SEED/oasb_data/reference20.dbf 200.001.000060.00
APPS_TS_SEED/oasb_data/reference22.dbf 100.001.000070.00
APPS_TS_SEED/oasb_data/reference24.dbf 100.001.000020.00
APPS_TS_SEED/oasb_data/reference25.dbf 100.001.000080.00
APPS_TS_SEED/oasb_data/reference3.dbf 100.001.000040.00
APPS_TS_SEED/oasb_data/reference5.dbf 100.001.000000.00
APPS_TS_SEED/oasb_data/reference7.dbf 00  2000.00
APPS_TS_SEED/oasb_data/reference8.dbf 00  1000.00
APPS_TS_SEED/oasb_data/reference9.dbf 1400.711.0000515.29
APPS_TS_SUMMARY/oasb_data/summary12.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary13.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary14.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary15.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary2.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary3.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary4.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary5.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary6.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary7.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary8.dbf 100.001.001000.00
APPS_TS_SUMMARY/oasb_data/summary9.dbf 100.001.001000.00
APPS_TS_TOOLS/oasb_data/apps_ts_tools01.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data1.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data10.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data11.dbf 1,25110.241.0116902,0171.05
APPS_TS_TX_DATA/oasb_data/tx_data12.dbf 1,25310.251.0116901,9680.06
APPS_TS_TX_DATA/oasb_data/tx_data13.dbf 1,28710.251.0142806,2330.04
APPS_TS_TX_DATA/oasb_data/tx_data14.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data15.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data16.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data17.dbf 98300.201.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data18.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data19.dbf 1,00400.221.002010.00
APPS_TS_TX_DATA/oasb_data/tx_data2.dbf 1,22310.241.0116501,6930.04
APPS_TS_TX_DATA/oasb_data/tx_data20.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data21.dbf 1,26610.261.0143906,3190.02
APPS_TS_TX_DATA/oasb_data/tx_data22.dbf 98400.231.0113705080.06
APPS_TS_TX_DATA/oasb_data/tx_data23.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data24.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data25.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data26.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data27.dbf 97500.251.001020.00
APPS_TS_TX_DATA/oasb_data/tx_data28.dbf 99800.211.001010.00
APPS_TS_TX_DATA/oasb_data/tx_data29.dbf 59400.241.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data3.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data30.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data31.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data32.dbf 2400.832.296407290.01
APPS_TS_TX_DATA/oasb_data/tx_data33.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data34.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data35.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data36.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data37.dbf 98900.221.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data38.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data39.dbf 1,19110.241.0217001,9370.05
APPS_TS_TX_DATA/oasb_data/tx_data4.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data40.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data41.dbf 1,00900.221.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data42.dbf 99000.201.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data43.dbf 1,26610.221.0316902,0060.07
APPS_TS_TX_DATA/oasb_data/tx_data44.dbf 1,23410.221.0316201,6950.04
APPS_TS_TX_DATA/oasb_data/tx_data45.dbf 1,22710.221.0416101,8950.56
APPS_TS_TX_DATA/oasb_data/tx_data46.dbf 1,24410.231.0416901,9060.07
APPS_TS_TX_DATA/oasb_data/tx_data47.dbf 1,32310.251.0345208,7630.04
APPS_TS_TX_DATA/oasb_data/tx_data48.dbf 1,33810.221.0347208,7190.03
APPS_TS_TX_DATA/oasb_data/tx_data49.dbf 1,33810.241.0348108,3020.15
APPS_TS_TX_DATA/oasb_data/tx_data5.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data50.dbf 1,25410.221.0417105,9900.02
APPS_TS_TX_DATA/oasb_data/tx_data51.dbf 1,32710.231.0343607,2930.03
APPS_TS_TX_DATA/oasb_data/tx_data52.dbf 1,01800.231.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data53.dbf 1,34910.231.0343808,8740.02
APPS_TS_TX_DATA/oasb_data/tx_data54.dbf 1,32910.251.0344607,9760.02
APPS_TS_TX_DATA/oasb_data/tx_data55.dbf 1,30810.261.0343208,5690.04
APPS_TS_TX_DATA/oasb_data/tx_data56.dbf 1,29610.241.0342808,2530.15
APPS_TS_TX_DATA/oasb_data/tx_data57.dbf 1,29110.241.0343908,4750.05
APPS_TS_TX_DATA/oasb_data/tx_data58.dbf 1,30910.241.03455031,5920.08
APPS_TS_TX_DATA/oasb_data/tx_data59.dbf 1,28910.231.0343808,0810.03
APPS_TS_TX_DATA/oasb_data/tx_data6.dbf 400.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data60.dbf 1,30310.221.0343408,6190.02
APPS_TS_TX_DATA/oasb_data/tx_data61.dbf 1,28410.251.0344209,1560.03
APPS_TS_TX_DATA/oasb_data/tx_data62.dbf 1,29910.241.0345208,2770.14
APPS_TS_TX_DATA/oasb_data/tx_data63.dbf 1,32010.231.0443608,3420.03
APPS_TS_TX_DATA/oasb_data/tx_data64.dbf 1,34910.231.0344908,8370.04
APPS_TS_TX_DATA/oasb_data/tx_data65.dbf 1,32610.231.0345008,4340.02
APPS_TS_TX_DATA/oasb_data/tx_data66.dbf 1,35110.221.0343508,4770.02
APPS_TS_TX_DATA/oasb_data/tx_data67.dbf 1,33510.241.0344508,2790.02
APPS_TS_TX_DATA/oasb_data/tx_data68.dbf 1,32410.251.0344508,5140.04
APPS_TS_TX_DATA/oasb_data/tx_data69.dbf 1,30310.241.0345107,9510.03
APPS_TS_TX_DATA/oasb_data/tx_data7.dbf 400.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data70.dbf 1,31310.231.0345207,9690.02
APPS_TS_TX_DATA/oasb_data/tx_data71.dbf 1,32010.261.0344208,0480.27
APPS_TS_TX_DATA/oasb_data/tx_data72.dbf 1,29710.251.0344508,3300.02
APPS_TS_TX_DATA/oasb_data/tx_data73.dbf 1,29510.241.0344707,8770.03
APPS_TS_TX_DATA/oasb_data/tx_data74.dbf 1,31710.231.0345106,6780.03
APPS_TS_TX_DATA/oasb_data/tx_data75.dbf 1,31810.231.0343007,0920.18
APPS_TS_TX_DATA/oasb_data/tx_data76.dbf 1,31510.241.0343007,9770.03
APPS_TS_TX_DATA/oasb_data/tx_data77.dbf 1,29610.241.0344105,2750.23
APPS_TS_TX_DATA/oasb_data/tx_data78.dbf 1,28410.251.0443205,8280.06
APPS_TS_TX_DATA/oasb_data/tx_data79.dbf 1,28310.231.0443805,5160.05
APPS_TS_TX_DATA/oasb_data/tx_data8.dbf 500.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data80.dbf 1,30110.241.0343505,7560.21
APPS_TS_TX_DATA/oasb_data/tx_data81.dbf 1,31310.251.0343105,5840.21
APPS_TS_TX_DATA/oasb_data/tx_data82.dbf 1,31310.251.0345807,4030.04
APPS_TS_TX_DATA/oasb_data/tx_data83.dbf 1,34610.231.0243506,8790.04
APPS_TS_TX_DATA/oasb_data/tx_data84.dbf 1,33910.251.0244107,1610.02
APPS_TS_TX_DATA/oasb_data/tx_data85.dbf 1,28410.241.0243707,5410.04
APPS_TS_TX_DATA/oasb_data/tx_data86.dbf 1,33910.241.0143507,4520.18
APPS_TS_TX_DATA/oasb_data/tx_data87.dbf 1,32510.231.0143606,7580.03
APPS_TS_TX_DATA/oasb_data/tx_data88.dbf 1,34410.251.0144006,9660.05
APPS_TS_TX_DATA/oasb_data/tx_data89.dbf 1,33610.231.0141407,0420.05
APPS_TS_TX_DATA/oasb_data/tx_data9.dbf 600.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data90.dbf 1,31610.241.0141606,7030.18
APPS_TS_TX_DATA/oasb_data/tx_data91.dbf 1,30510.251.0141106,5030.04
APPS_TS_TX_DATA/oasb_data/tx_data92.dbf 1,31410.241.0142406,5720.03
APPS_TS_TX_DATA/oasb_data/tx_data93.dbf 1,32610.231.0142506,8630.02
APPS_TS_TX_IDX/oasb_data/tx_idx1.dbf 70000.261.00634064,6290.28
APPS_TS_TX_IDX/oasb_data/tx_idx10.dbf 70200.241.00641063,7300.30
APPS_TS_TX_IDX/oasb_data/tx_idx11.dbf 69900.261.00629067,6930.28
APPS_TS_TX_IDX/oasb_data/tx_idx12.dbf 65600.241.00628065,7180.24
APPS_TS_TX_IDX/oasb_data/tx_idx13.dbf 67500.271.00621066,4330.32
APPS_TS_TX_IDX/oasb_data/tx_idx14.dbf 58200.241.007701840.05
APPS_TS_TX_IDX/oasb_data/tx_idx15.dbf 68900.281.00635065,4960.32
APPS_TS_TX_IDX/oasb_data/tx_idx16.dbf 63000.241.00652064,5180.27
APPS_TS_TX_IDX/oasb_data/tx_idx17.dbf 69900.271.00625065,5160.28
APPS_TS_TX_IDX/oasb_data/tx_idx18.dbf 69400.261.00649060,9630.26
APPS_TS_TX_IDX/oasb_data/tx_idx19.dbf 70500.261.00668065,9700.32
APPS_TS_TX_IDX/oasb_data/tx_idx2.dbf 66500.261.00645061,1080.26
APPS_TS_TX_IDX/oasb_data/tx_idx20.dbf 67100.251.00645065,9050.28
APPS_TS_TX_IDX/oasb_data/tx_idx21.dbf 67400.251.00656062,7000.25
APPS_TS_TX_IDX/oasb_data/tx_idx22.dbf 65700.241.00659062,8020.28
APPS_TS_TX_IDX/oasb_data/tx_idx23.dbf 63900.271.00634057,1720.22
APPS_TS_TX_IDX/oasb_data/tx_idx24.dbf 65500.241.00641059,0620.25
APPS_TS_TX_IDX/oasb_data/tx_idx25.dbf 67900.271.00638066,9890.30
APPS_TS_TX_IDX/oasb_data/tx_idx26.dbf 68500.281.00638061,2400.28
APPS_TS_TX_IDX/oasb_data/tx_idx27.dbf 64300.251.00626061,1510.25
APPS_TS_TX_IDX/oasb_data/tx_idx28.dbf 64600.261.00619065,2780.28
APPS_TS_TX_IDX/oasb_data/tx_idx29.dbf 66200.271.00637063,6300.25
APPS_TS_TX_IDX/oasb_data/tx_idx3.dbf 65300.291.00618062,1070.28
APPS_TS_TX_IDX/oasb_data/tx_idx30.dbf 64300.261.00612054,9020.24
APPS_TS_TX_IDX/oasb_data/tx_idx31.dbf 59700.251.0018204920.06
APPS_TS_TX_IDX/oasb_data/tx_idx32.dbf 57400.241.00810770.00
APPS_TS_TX_IDX/oasb_data/tx_idx33.dbf 56900.231.0010201840.05
APPS_TS_TX_IDX/oasb_data/tx_idx34.dbf 66300.271.00631063,7760.27
APPS_TS_TX_IDX/oasb_data/tx_idx35.dbf 68100.311.00632062,0420.24
APPS_TS_TX_IDX/oasb_data/tx_idx36.dbf 69800.261.00622059,4170.25
APPS_TS_TX_IDX/oasb_data/tx_idx37.dbf 68900.281.00633064,8630.27
APPS_TS_TX_IDX/oasb_data/tx_idx38.dbf 66400.331.00634064,2900.28
APPS_TS_TX_IDX/oasb_data/tx_idx39.dbf 70900.311.00625065,3410.27
APPS_TS_TX_IDX/oasb_data/tx_idx4.dbf 61400.291.008405370.60
APPS_TS_TX_IDX/oasb_data/tx_idx40.dbf 71600.271.00646064,5520.26
APPS_TS_TX_IDX/oasb_data/tx_idx41.dbf 68100.261.00627064,2790.27
APPS_TS_TX_IDX/oasb_data/tx_idx42.dbf 72400.281.00658071,1500.28
APPS_TS_TX_IDX/oasb_data/tx_idx43.dbf 71200.241.00666066,1530.26
APPS_TS_TX_IDX/oasb_data/tx_idx44.dbf 70700.231.00632059,9370.26
APPS_TS_TX_IDX/oasb_data/tx_idx45.dbf 67000.251.00662060,7380.27
APPS_TS_TX_IDX/oasb_data/tx_idx46.dbf 71600.241.00658067,0480.31
APPS_TS_TX_IDX/oasb_data/tx_idx47.dbf 70900.251.00628061,6680.27
APPS_TS_TX_IDX/oasb_data/tx_idx48.dbf 72400.251.00654059,7800.27
APPS_TS_TX_IDX/oasb_data/tx_idx49.dbf 67600.251.00619057,6880.23
APPS_TS_TX_IDX/oasb_data/tx_idx5.dbf 60800.231.007501450.07
APPS_TS_TX_IDX/oasb_data/tx_idx50.dbf 69300.261.00638062,8070.27
APPS_TS_TX_IDX/oasb_data/tx_idx51.dbf 71300.271.00666065,6230.29
APPS_TS_TX_IDX/oasb_data/tx_idx52.dbf 68800.281.00633061,0370.26
APPS_TS_TX_IDX/oasb_data/tx_idx53.dbf 71200.251.00647060,3170.27
APPS_TS_TX_IDX/oasb_data/tx_idx54.dbf 73100.251.00660063,2890.33
APPS_TS_TX_IDX/oasb_data/tx_idx55.dbf 74700.251.00655060,1970.31
APPS_TS_TX_IDX/oasb_data/tx_idx56.dbf 71600.271.00666058,8500.23
APPS_TS_TX_IDX/oasb_data/tx_idx57.dbf 73300.251.00684064,3060.26
APPS_TS_TX_IDX/oasb_data/tx_idx58.dbf 73800.261.00664060,6990.24
APPS_TS_TX_IDX/oasb_data/tx_idx59.dbf 73000.261.00681059,2050.23
APPS_TS_TX_IDX/oasb_data/tx_idx6.dbf 68200.441.00636058,2430.24
APPS_TS_TX_IDX/oasb_data/tx_idx60.dbf 72400.261.00655059,7850.25
APPS_TS_TX_IDX/oasb_data/tx_idx61.dbf 70400.241.00662061,4870.26
APPS_TS_TX_IDX/oasb_data/tx_idx62.dbf 70300.241.00658061,1040.28
APPS_TS_TX_IDX/oasb_data/tx_idx63.dbf 68800.231.00655059,8990.33
APPS_TS_TX_IDX/oasb_data/tx_idx64.dbf 70100.261.00665062,3350.30
APPS_TS_TX_IDX/oasb_data/tx_idx65.dbf 69900.271.00646060,6000.25
APPS_TS_TX_IDX/oasb_data/tx_idx66.dbf 70000.261.00669060,2090.25
APPS_TS_TX_IDX/oasb_data/tx_idx67.dbf 65200.251.00639064,3270.28
APPS_TS_TX_IDX/oasb_data/tx_idx68.dbf 66300.231.00644061,8450.32
APPS_TS_TX_IDX/oasb_data/tx_idx69.dbf 68300.251.00643062,5890.27
APPS_TS_TX_IDX/oasb_data/tx_idx7.dbf 56400.251.00810790.00
APPS_TS_TX_IDX/oasb_data/tx_idx70.dbf 65800.261.00632064,4580.28
APPS_TS_TX_IDX/oasb_data/tx_idx71.dbf 69800.241.00624065,2590.30
APPS_TS_TX_IDX/oasb_data/tx_idx72.dbf 72000.251.00639060,7330.29
APPS_TS_TX_IDX/oasb_data/tx_idx8.dbf 58400.241.00750450.00
APPS_TS_TX_IDX/oasb_data/tx_idx9.dbf 57200.241.00720510.00
APPS_UNDOTS1/oasb_data/undo.dbf 100.001.008,303461,9140.03
APPS_UNDOTS1/oasb_data/undo2.dbf 100.001.008,284453,6990.03
APPS_UNDOTS1/oasb_data/undo3.dbf 100.001.008,214441,3540.03
APPS_UNDOTS1/oasb_data/undo4.dbf 100.001.008,011437,9640.03
APPS_UNDOTS1/oasb_data/undo5.dbf 100.001.008,803440,3320.03
APPS_UNDOTS1/oasb_data/undo6.dbf 100.001.008,774444,0460.03
APPS_UNDOTS1/oasb_data/undo7.dbf 100.001.008,819437,2800.03
APPS_UNDOTS1/oasb_data/undo8.dbf 100.001.008,151459,4770.03
APPS_UNDOTS1/oasb_data/undo9.dbf 00  8,282439,6790.04
B2B_DT/oasb_data/b2b_dt.dbf 600.001.001000.00
B2B_IDX/oasb_data/b2b_idx.dbf 600.001.001000.00
B2B_LOB/oasb_data/b2b_lob.dbf 700.001.001000.00
B2B_RT/oasb_data/b2b_rt.dbf 700.001.001000.00
BAM/oasb_data/bam.dbf 700.001.001000.00
CTXSYS/oasb_data/ctx1.dbf 700.001.001000.00
CWMLITE/oasb_data/cwmlite01.dbf 700.001.001000.00
CWMLITE/oasb_data/cwmlite02.dbf 700.001.001000.00
DCM/oasb_data/dcm.dbf 600.001.001000.00
DCM/oasb_data/dcm1.dbf 600.001.001000.00
DISCO_PTM5_CACHE/oasb_data/discopltc1.dbf 600.001.001000.00
DISCO_PTM5_META/oasb_data/discopltm1.dbf 600.001.001000.00
DSGATEWAY_TAB/oasb_data/oss_sys01.dbf 600.001.001000.00
GEOR_TBS/oasb_data/apps_ts_spatial.dbf 600.001.001000.00
GEOR_TBS/oasb_data/geor_tbs02.dbf 600.001.001000.00
HTMLDB/oasb_data/htmldb.dbf 600.001.001000.00
IAS_META/oasb_data/ias_meta01.dbf 600.001.001000.00
MTR/oasb_data/opmtr01.dbf 600.001.001000.00
NOETIX/oasb_data/noetix.dbf 600.001.001000.00
NON_APPS_TS_DATA/oasb_data/non_apps_data1.dbf 600.001.001000.00
OCATS/oasb_data/oca.dbf 600.001.001000.00
ODM_DATA/oasb_data/odm.dbf 600.001.001000.00
OLTS_ATTRSTORE/oasb_data/attrs1_oid.dbf 700.001.001000.00
OLTS_BATTRSTORE/oasb_data/battrs1_oid.dbf 700.001.001000.00
OLTS_CT_STORE/oasb_data/gcats1_oid.dbf 700.001.001000.00
OLTS_DEFAULT/oasb_data/gdefault1_oid.dbf 700.001.001000.00
OLTS_SVRMGSTORE/oasb_data/svrmg1_oid.dbf 700.001.001000.00
OPMOR/oasb_data/opmor01.dbf 700.001.001000.00
ORABPEL/oasb_data/orabpel.dbf 600.001.001000.00
OWAPUB/oasb_data/owa1.dbf 600.001.001000.00
PORTAL/oasb_data/portal.dbf 600.001.001000.00
PORTAL_DOC/oasb_data/ptldoc.dbf 600.001.001000.00
PORTAL_IDX/oasb_data/ptlidx.dbf 600.001.001000.00
PORTAL_LOG/oasb_data/ptllog.dbf 600.001.001000.00
RE/oasb_data/opre01.dbf 600.001.001000.00
SYNCSERVER/oasb_data/mobile01.dbf 600.001.001000.00
SYSAUX/oasb_data/sysaux01.dbf 14900.341.00252000.00
SYSAUX/oasb_data/sysaux02.dbf 7800.381.00123000.00
SYSTEM/oasb_data/sys1.dbf 2900.691.001607540.11
SYSTEM/oasb_data/sys10.dbf 800.001.007050.00
SYSTEM/oasb_data/sys2.dbf 400.001.003030.00
SYSTEM/oasb_data/sys3.dbf 100.001.007000.00
SYSTEM/oasb_data/sys4.dbf 500.001.002010.00
SYSTEM/oasb_data/sys5.dbf 1200.831.001070.00
SYSTEM/oasb_data/sys6.dbf 100.001.003000.00
SYSTEM/oasb_data/sys7.dbf 900.001.008080.00
SYSTEM/oasb_data/sys8.dbf 800.001.0016020.00
SYSTEM/oasb_data/sys9.dbf 1400.711.0060100.00
UDDISYS_TS/oasb_data/uddisys01.dbf 600.001.001000.00
WCRSYS_TS/oasb_data/wcrsys01.dbf 600.001.001000.00
XDB/oasb_data/xdb01.dbf 600.001.001000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D3,439,6041002,744,575,055132,9251,587,239004,767,017

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,587,1590

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B01138711950338060608292739533806060   
E02831549184625821154563548292739515456354   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D2,7520.103391.632,2451366.00
D5,5040.206781.401,9321285.00
D8,2560.301,0181.271,7521238.00
D11,0080.391,3571.171,6081201.00
D13,7600.491,6961.141,5751192.00
D16,5120.592,0351.111,5341182.00
D19,2640.692,3751.061,4581162.00
D22,0160.792,7141.041,4301155.00
D24,7680.893,0531.021,4011147.00
D27,5200.993,3921.001,3821142.00
D27,9041.003,4401.001,3791141.00
D30,2721.083,7310.971,3391131.00
D33,0241.184,0710.961,3271128.00
D35,7761.284,4100.961,3271128.00
D38,5281.384,7490.961,3271128.00
D41,2801.485,0880.961,3271128.00
D44,0321.585,4280.961,3271128.00
D46,7841.685,7670.961,3271128.00
D49,5361.786,1060.961,3271128.00
D52,2881.876,4450.961,3271128.00
D55,0401.976,7850.961,3271128.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.0027,0940

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B10,2409,099197.780.000.000.000.001,048,570
E10,2409,100198.090.000.000.000.001,048,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K13,555,56413,555,56400
64K128K6600
128K256K606000
256K512K4400
512K1024K373700
1M2M111100
2M4M6600
4M8M171700
8M16M333300

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
1,2800.13125,830.380.00100.0000
2,5600.25125,830.380.00100.0000
5,1200.50125,830.380.00100.0000
7,6800.75125,830.380.00100.0000
10,2401.00125,830.380.00100.0000
12,2881.20125,830.380.00100.0000
14,3361.40125,830.380.00100.0000
16,3841.60125,830.380.00100.0000
18,4321.80125,830.380.00100.0000
20,4802.00125,830.380.00100.0000
30,7203.00125,830.380.00100.0000
40,9604.00125,830.380.00100.0000
61,4406.00125,830.380.00100.0000
81,9208.00125,830.380.00100.0000

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
3200.141177,1202,092,1661.001,7091.00236,052
5760.241177,1202,092,1661.001,7091.00236,052
8320.351177,1202,092,1661.001,7091.00236,052
1,0880.461177,1202,092,1661.001,7091.00236,052
1,3440.571177,1202,092,1661.001,7091.00236,052
1,6000.681177,1202,092,1661.001,7091.00236,052
1,8560.781177,1202,092,1661.001,7091.00236,052
2,1120.891177,1202,092,1661.001,7091.00236,052
2,3681.001177,1202,092,1661.001,7091.00236,052
2,6241.111177,1202,092,1661.001,7091.00236,052
2,8801.221177,1202,092,1661.001,7091.00236,052
3,1361.321177,1202,092,1661.001,7091.00236,052
3,3921.431177,1202,092,1661.001,7091.00236,052
3,6481.541177,1202,092,1661.001,7091.00236,052
3,9041.651177,1202,092,1661.001,7091.00236,052
4,1601.761177,1202,092,1661.001,7091.00236,052
4,4161.861177,1202,092,1661.001,7091.00236,052
4,6721.971177,1202,092,1661.001,7091.00236,052

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,8400.1389,6572,311,344
7,6800.2589,5761,988,754
11,5200.3889,4961,655,824
15,3600.5089,4871,621,635
19,2000.6389,4511,501,285
23,0400.7589,4531,471,921
26,8800.8889,4441,442,281
30,7201.0089,4241,378,590
34,5601.1389,4261,365,907
38,4001.2589,4261,365,907
42,2401.3889,4261,365,907
46,0801.5089,4261,365,907
49,9201.6389,4261,365,907
53,7601.7589,4261,365,907
57,6001.8889,4261,365,907
61,4402.0089,4261,365,907

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
640.500000
1281.000000
1921.500000
2562.000000
3202.500000
3843.000000
4483.500000
5124.000000
5764.500000
6405.000000
7045.500000
7686.000000
8326.500000
8967.000000
9607.500000
1,0248.000000
1,0888.500000
1,1529.000000
1,2169.500000
1,28010.000000

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

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block4,347,3531,1080
undo block342,809110
undo header72,92320
1st level bmb97900
segment header3000

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
UL-User-defined 50,95350,37557841,06485420.79
TX-Transaction (index contention) 957,630957,6210954,5625990.63
TX-Transaction (row lock contention) 4,7494,5372124,496368.03
SQ-Sequence Cache 37,20037,200026,81080.31
HW-Segment High Water Mark 2,1402,140022200.30
TX-Transaction (allocate ITL entry) 135135013000.27
TX-Transaction 566,272566,29601301.15
DV-Diana Versioning 1,3501,35002100.10
FB-Format Block 1331330100.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
21,118.21566,5521,7393889.2/97.50/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
24-Aug 13:39168,294131,4251,73934980/00/0/0/0/0/0
24-Aug 13:29257,557107,6461,54936920/00/0/0/0/0/0
24-Aug 13:19426,219202,16794637890/00/0/0/0/0/0
24-Aug 13:09266,141125,3141,54938910/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM db client latch2,0470.00 00 
ASM map operation hash table10.00 00 
ASM network state latch2480.00 00 
AWR Alerted Metric Element list23,9000.00 00 
Change Notification Hash table latch6820.00 00 
Consistent RBA264,7120.020.0000 
DML lock allocation1,904,0520.040.0000 
Event Group Locks2221.350.0000 
FOB s.o list latch33,3520.270.0000 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch23,877,7520.380.746240,9320.04
JS Sh mem access10.00 00 
JS queue access latch10.00 00 
JS slv state obj latch10.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch6810.00 00 
KTF sga latch120.00 06000.00
KWQP Prop Status2580.00 00 
KWQS pqueue ctx latch20.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0390.00
Memory Management Latch10.00 06810.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch110.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process7060.00 00 
OS process allocation1,1514.000.0000 
OS process: request allocation4429.500.0000 
PL/SQL warning settings4,013,2950.170.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch4,5890.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 06790.00
SQL memory manager workarea list latch4,065,9210.060.0000 
Shared B-Tree1,3360.070.0000 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch142,4380.140.0000 
active service list1,5740.061.0001,2250.00
begin backup scn array430.00 00 
bq:time manger info latch730.00 00 
buffer pool10.00 00 
bufq statistics10.00 00 
business card10.00 00 
cache buffer handles270,859,9348.760.0000 
cache buffers chains4,969,122,5333.340.014811,559,9272.36
cache buffers lru chain2,902,9590.090.00023,803,9280.29
cache table scan latch1560.00 01560.00
call allocation503,0932.630.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch44413.960.0800 
channel operations parent latch16,0730.230.0000 
checkpoint queue latch5,547,3720.020.0001,741,0150.00
client/application info3,7850.080.0000 
compile environment latch2210.00 00 
corrupted undo seg latch616,8440.020.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch2480.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch2480.00 00 
dml lock allocation2480.00 00 
done queue latch10.00 00 
dummy allocation4430.00 00 
enqueue hash chains6,249,41919.620.0004186.46
enqueues2,080,06613.270.0000 
fifth spare latch10.00 00 
file cache latch2,3550.00 00 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA2130.00 00 
global ctx hash table latch3950.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch3240.00 072,6980.00
hash table modification latch210.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch30.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats300.00 00 
kokc descriptor allocation latch40.00 00 
ksfv messages10.00 00 
kss move lock150.00 00 
ksuosstats global area1390.00 00 
ksv allocation latch2760.00 00 
ksv class latch290.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch44214.030.0000 
ktm global data330.00 00 
kwqbsn:qsga1,2580.640.0000 
lgwr LWN SCN269,7161.440.0000 
list of block allocation475,3220.040.0000 
loader state object freelist6381.100.0000 
lob segment dispenser latch10.00 00 
lob segment hash table latch90.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch1,0300.00 00 
messages1,106,9830.120.0000 
mostly latch-free SCN324,77714.440.0000 
msg queue latch10.00 00 
multiblock read objects3220.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch2480.00 00 
object queue header heap1,141,8870.00 01,7350.00
object queue header operation9,369,5290.040.0000 
object stats modification1020.00 00 
parallel query alloc buffer2650.00 00 
parallel query stats10.00 00 
parameter list7060.00 00 
parameter table management4720.210.0000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue132,8360.020.00089,8520.04
process allocation44911.360.00016930.77
process group creation4421.130.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch2,3545.860.0000 
query server freelists10.00 00 
queued dump request70.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation1,923,49322.770.00073,164,9565.15
redo copy10.00 073,619,5150.05
redo writing1,133,5260.030.0000 
resmgr group change latch1,0620.090.0000 
resmgr:active threads6550.460.6700 
resmgr:actses change group6460.00 00 
resmgr:actses change state2130.00 00 
resmgr:free threads list4420.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config10.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects12,925,2976.100.0000 
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second spare latch10.00 00 
sequence cache31,175,4702.920.0000 
session allocation768,2470.080.000256,0820.00
session idle bit46,602,9000.040.0000 
session queue latch10.00 00 
session state list latch1,2960.850.3600 
session switching1,3540.00 00 
session timer8080.00 00 
shared pool732,1120.020.0000 
shared pool sim alloc40.00 00 
shared pool simulator680.00 00 
sim partition latch10.00 00 
simulator hash latch140,795,4260.000.0000 
simulator lru latch1,116,9000.230.000139,538,6422.65
sort extent pool2,8250.780.0000 
space background state object latch60.00 00 
space background task latch1,5090.200.3301,3620.00
state object free list20.00 00 
statistics aggregation3360.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
temporary table state object allocation4240.940.0000 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch4810.00 00 
transaction allocation102,5790.000.0000 
undo global data98,356,7690.200.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains4,969,122,533166,143,560874,213165,400,127
cache buffer handles270,859,93423,735,62648223,735,147
enqueue hash chains6,249,4191,226,314651,226,249
sequence cache31,175,470909,95750909,908
row cache objects12,925,297788,0425788,037
redo allocation1,923,493437,988379437,612
enqueues2,080,066275,99447275,947
undo global data98,356,769192,65019192,631
In memory undo latch23,877,75291,89768,07927,660
session idle bit46,602,90016,7742016,755
object queue header operation9,369,5293,38873,381
simulator lru latch1,116,9002,62142,617
cache buffers lru chain2,902,9592,56822,566
channel handle pool latch44462557
session state list latch1,2961147
resmgr:active threads655321
space background task latch1,509312
active service list1,574110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child036,77713,814
In memory undo latchkticmt: child025,359465
In memory undo latchktichg: child05,91821,878
In memory undo latchktiFlushMe01,207145
In memory undo latchkturbk02432,776
In memory undo latchktiFlushTopTxn0103
In memory undo latchktbgfc07235
In memory undo latchktigetmypoollatch_2050
In memory undo latchktiTxnPoolFree013
active service listkswslogon: session logout011
cache buffer handleskcbzgs0308359
cache buffer handleskcbzfs0173121
cache buffers chainskcbchg1: kslbegin: bufs not pinned0419,199347,809
cache buffers chainskcbgtcr: fast path0219,36168,518
cache buffers chainskcbgtcr: fast path (cr pin)0123,07150,858
cache buffers chainskcbget: pin buffer055,27422,848
cache buffers chainskcbgcur_2049,51217,319
cache buffers chainskcbgtcr_2049,41436,202
cache buffers chainskcbchg1: kslbegin: call CR func033,232211,679
cache buffers chainskcbgtcr: kslbegin excl026,61621,812
cache buffers chainskcbzwb025,82715,590
cache buffers chainskcbgkcbcr020,79824,630
cache buffers chainskcbrls_207,545133,931
cache buffers chainskcbrls_105,54246,544
cache buffers chainskcbgcur: fast path (shr)0949894
cache buffers chainskcbget: exchange rls0739714
cache buffers chainskcbget: exchange06321,213
cache buffers chainskcbnlc05683,410
cache buffers chainskcbcge047218,555
cache buffers chainskcb_is_private04483,538
cache buffers chainskcbesc: escalate023291
cache buffers chainskcbzgb: scan from tail. nowait01750
cache buffers chainskcbzpbuf01664,340
cache buffers chainskcb_pre_apply: kcbhq610766,243
cache buffers chainskcb_post_apply: kcbhq62072867
cache buffers chainskcbso1: set no access0691,154
cache buffers chainskcb_commit0674,218
cache buffers chainskcbget_103631
cache buffers chainskcbgtcr: kslbegin shared02822
cache buffers chainskcbgcur_5018125
cache buffers chainskcb_post_apply: kcbhq63012251
cache buffers chainskcbnew: new latch again091
cache buffers chainskcbgcur_6012
cache buffers chainskcbzib: finish processing buffer010
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_1010
cache buffers lru chainkcbzgws010
channel handle pool latchksrchconnect()089
enqueue hash chainsksqrcl05912
enqueue hash chainsksqcmi: get hash chain latch after wait0653
enqueuesksqdel04747
object queue header operationkcbo_switch_q_bg054
object queue header operationkcbo_unlink_q022
object queue header operationkcbo_switch_mq_bg012
redo allocationkcrfw_redo_gen: redo allocation 102010
redo allocationkcrfw_redo_gen: redo allocation 30136218
redo allocationkcrfw_post: more space019158
redo allocationkcrfw_redo_gen: redo allocation 20190
redo allocationkcrfw_redo_write: before write033
resmgr:active threadskgskchclass030
row cache objectskqreqd: reget050
sequence cachekdnssd0441
sequence cachekdnnxt: cached seq061
session idle bitksupuc: clear busy01217
session idle bitksupuc: set busy0116
session state list latchkpseqd030
session state list latchkpscad013
simulator lru latchkcbs_simulate: simulate set040
space background task latchktsj_grab_task011
undo global dataktudba: KSLBEGIN01919

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]5,854301
Library Cachekglpin1 45,376-0
Library Cachekglpndl1 954,578-0
Cursor Pinkksfbc [KKSCHLFSP2]3,9760
Cursor PinkksLockDelete [KKSCHLPIN6]1,9280
Library CachekglIsOwnerVersionable 1211,098-0
Cursor Pinkksfbc [KKSCHLPIN1]9900
Library Cachekgllkdl1 85517-0
Library Cachekgllkc1 574160
Library Cachekglpnal1 90381-0
hash tablekkshGetNextChild [KKSHBKLOC1]2270
Cursor ParentkkscsPruneChild [KKSPRTLOC35]1490
hash tablekkscsSearchChildList [KKSHBKLOC2]1490
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]1000
Library Cachekglobpn1 71330
Cursor Pinkksxsccmp [KKSCHLPIN5]230
Library Cachekglhdgn2 106170
Library Cachekglget2 210

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX312,578,43211.31
HRAPPS_TS_TX_IDXPAY_PAYROLL_ACTIONS_PK INDEX175,559,8726.35
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE140,846,0805.10
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N50 INDEX128,691,5044.66
HRAPPS_TS_TX_DATAPAY_PAYROLL_ACTIONS TABLE85,101,5683.08

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE64,78348.36
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX7,7205.76
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX3,6022.69
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE2,8322.11
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX1,9981.49

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE64,39648.82
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX7,7155.85
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX3,6022.73
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE2,8322.15
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX1,9981.51

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE64,39648.82
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX7,7155.85
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX3,6022.73
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE2,8322.15
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX1,9981.51

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE91,9065.79
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N51 INDEX41,0452.59
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX40,7192.56
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE38,2142.41
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX28,6711.81

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE7,3135.22
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX5,3953.85
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX4,3363.10
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N51 INDEX3,7162.65
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N3 INDEX3,3302.38

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE217,004,46448.84
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX62,837,28014.14
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX43,783,5049.85
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE39,819,5208.96
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX11,088,5922.50

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX256,78226.75
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX108,36311.29
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX100,11810.43
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX97,51610.16
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N50 INDEX93,1039.70

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX6145.19
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX4029.63
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX2518.52
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N50 INDEX53.70
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX10.74

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX931,22521.49
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX827,03419.08
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_PK INDEX335,6067.74
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N50 INDEX311,8757.20
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX286,0256.60

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control50.000 21
dc_global_oids210.000 038
dc_histogram_data5140.000 0471
dc_histogram_defs2,0500.000 05,787
dc_object_grants590.000 0187
dc_objects26,0350.000 03,940
dc_profiles2130.000 01
dc_rollback_segments9060.000 038
dc_segments2,3730.000 1302,839
dc_sequences10,3810.000 10,38120
dc_tablespaces2,213,8730.000 055
dc_users2,041,9880.000 0135
global database name1,5800.000 01
outstanding_alerts2140.470 253


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
APP CONTEXT8,8860.008,8860.0000
BODY13,447-0.0141,444,8420.0100
DBLINK4280.000 00
DIRECTORY4240.004240.0000
EDITION2180.004310.0000
INDEX150.00150.0000
PIPE1,2240.001,2240.0000
QUEUE5920.005940.0000
RULESET20.0020.0000
SCHEMA4260.000 00
SQL AREA21,6330.11289,138,231-1.7300
TABLE/PROCEDURE127,5480.0051,871,9860.0100
TRIGGER1,7990.006,000,0980.0000


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache27,904.0027,904.0027,904.0028,096.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target10,240.0010,240.0010,240.0010,240.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target30,720.0030,720.0030,720.0030,720.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool64.0064.0064.0064.000STA/
large pool64.0064.000.0064.000GRO/IMM
shared pool2,304.002,304.002,240.002,304.000GRO/IMM
streams pool128.00128.000.00128.000GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther121.24 2.021.9511116060
 Freeable48.380.001.793.5611 2727
 PL/SQL26.0024.310.430.36116060
 SQL2.200.090.050.02034642
EOther121.69 2.031.9511116060
 Freeable48.380.001.733.5011 2828
 PL/SQL25.9224.140.430.35116060
 SQL2.140.080.050.02034642

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers29,259,464,704 
Fixed Size2,222,616 
Redo Buffers122,396,672 
Variable Size2,684,356,072 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory64.0064.000.00
largePX msg pool7.817.810.00
largefree memory56.1956.190.00
sharedASH buffers50.0050.000.00
sharedFileOpenBlock52.4852.480.00
sharedKGLS24.5024.500.00
sharedSQLA52.9453.961.94
shareddb_block_hash_buckets178.00178.000.00
sharedevent statistics per sess24.6724.670.00
sharedfree memory1,597.491,595.13-0.15
sharedprivate strands28.5728.570.00
streamsfree memory127.99127.990.00
 buffer_cache27,904.0027,904.000.00
 fixed_sga2.122.120.00
 log_buffer116.73116.730.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator0824 11:59:200.030.000.00
QMON Slaves0824 11:59:300.030.000.00

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 Capture Rate

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

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
APPLSYS.WF_CONTROL(414798) 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
SYS.ALERT_QUE_R 20.0000.000.000.000.000.000.000

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
000000

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_b_tree_bitmap_plansFALSE  
_fast_full_scan_enabledFALSE  
_gby_hash_aggregation_enabledFALSE  
_like_with_bind_as_equalityTRUE  
_optim_peek_user_bindsFALSE  
_optimizer_autostats_jobFALSE  
_sort_elimination_cost_ratio5  
_swrf_mmon_dbfusFALSE  
_swrf_mmon_flushFALSE  
_system_trig_enabledTRUE  
_trace_files_publicTRUE  
aq_tm_processes1  
compatible11.2.0  
control_files/oasb_data/cntrl01.dbf, /oasb_data/cntrl02.dbf, /oasb_data/cntrl03.dbf  
cursor_sharingEXACT  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_files512  
db_nameVIS  
diagnostic_dest/oracle/VIS/db/tech_st/11.2.0/admin/VIS_app0  
dml_locks10000  
job_queue_processes2  
lock_sgaTRUE  
log_buffer63012864  
log_checkpoint_timeout1200  
log_checkpoints_to_alertTRUE  
max_dump_file_size20480  
nls_compbinary  
nls_date_formatDD-MON-RR  
nls_languageamerican  
nls_length_semanticsBYTE  
nls_numeric_characters.,  
nls_sortbinary  
nls_territoryamerica  
olap_page_pool_size4194304  
open_cursors800  
optimizer_secure_view_mergingFALSE  
parallel_max_servers32  
parallel_min_servers0  
parallel_threads_per_cpu4  
pga_aggregate_target10737418240  
plsql_code_typeINTERPRETED  
processes1000  
query_rewrite_enabledtrue  
sec_case_sensitive_logonFALSE  
session_cached_cursors1000  
sessions2016  
sga_target32212254720  
shared_pool_reserved_size419430400  
shared_pool_size2348810240  
timed_statisticsTRUE  
transactions2200  
undo_managementAUTO  
undo_retention36000  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /oracle/VIS/db/tech_st/11.2.0/appsutil/outbound/VIS_app0, /usr/tmp  
workarea_size_policyAUTO  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report