WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS336435505VIS126-Feb-14 10:0211.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
app0AIX-Based Systems (64-bit) 48 12  61.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:15526-Feb-14 10:27:4091 9.4
End Snap:15626-Feb-14 10:50:4397 11.6
Elapsed:  23.04 (mins)  
DB Time:  529.93 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 27,968M 27,968MStd Block Size: 8K
Shared Pool Size: 2,240M 2,240MLog Buffer: 119,512K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 23.0 0.1 0.00 0.00
DB CPU(s): 5.3 0.0 0.00 0.00
Redo size: 17,462,196.4 100,589.3  
Logical reads: 2,057,327.0 11,851.0  
Block changes: 107,067.9 616.8  
Physical reads: 372.1 2.1  
Physical writes: 1,361.7 7.8  
User calls: 16,781.0 96.7  
Parses: 37.1 0.2  
Hard parses: 0.7 0.0  
W/A MB processed: 20.0 0.1  
Logons: 0.2 0.0  
Executes: 168,140.4 968.6  
Rollbacks: 0.4 0.0  
Transactions: 173.6   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.83Redo NoWait %: 100.00
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 100.55Soft Parse %: 98.16
Execute to Parse %: 99.98Latch Hit %: 95.66
Parse CPU to Parse Elapsd %: 19.10% Non-Parse CPU: 98.16

Shared Pool Statistics

BeginEnd
Memory Usage %: 29.29 32.37
% SQL with executions>1: 57.77 91.45
% Memory for SQL w/exec>1: 63.15 89.77

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 7,382 23.22 
buffer busy waits4,362,2711,49004.69Concurrency
enq: TX - index contention1,104,31685412.69Concurrency
enq: UL - contention40,163763192.40Application
latch: cache buffers chains1,200,05221300.67Concurrency

Host CPU (CPUs: 48 Cores: 12 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
0.25 1.16 45.4 1.7 0.1 52.9
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
11.2 23.7 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 62,464.0 62,464.0
SGA use (MB): 30,720.0 30,720.0
PGA use (MB): 240.3 253.4
% Host Mem used for SGA+PGA: 49.56 49.59

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time30,941.0297.31
PL/SQL execution elapsed time10,907.1134.30
DB CPU7,382.0723.22
parse time elapsed766.572.41
repeated bind elapsed time14.080.04
inbound PL/SQL rpc elapsed time9.220.03
sequence load elapsed time7.430.02
hard parse elapsed time5.960.02
connection management call elapsed time1.070.00
PL/SQL compilation elapsed time0.840.00
hard parse (sharing criteria) elapsed time0.040.00
hard parse (bind mismatch) elapsed time0.020.00
failed parse elapsed time0.000.00
DB time31,795.56 
background elapsed time331.84 
background cpu time21.04 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME65,058 
AVG_IDLE_TIME72,973 
AVG_IOWAIT_TIME59 
AVG_SYS_TIME2,230 
AVG_USER_TIME62,668 
BUSY_TIME3,125,750 
IDLE_TIME3,505,853 
IOWAIT_TIME3,699 
SYS_TIME110,439 
USER_TIME3,011,173 
LOAD01
OS_CPU_WAIT_TIME2,931,100 
VM_IN_BYTES100,851,744 
VM_OUT_BYTES893,636,592 
PHYSICAL_MEMORY_BYTES65,498,251,264 
NUM_CPUS48 
NUM_CPU_CORES12 
NUM_LCPUS48 
NUM_VCPUS12 
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
26-Feb 10:27:400.25     
26-Feb 10:50:431.1647.1345.411.6752.870.06

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  7,382 23.22
Concurrency9,679,94902,82608.89
Application47,0020801172.52
Commit78,549010910.34
User I/O205,19809200.29
Other610,2531003800.12
Network21,775,42601200.04
Configuration24,8320600.02
System I/O5,0450100.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,362,27101,490018.174.69
enq: TX - index contention1,104,316085414.602.69
enq: UL - contention40,1630763190.172.40
latch: cache buffers chains1,200,052021305.000.67
cursor: pin S wait on X4,2960111260.020.35
log file sync78,549010910.330.34
library cache: mutex X2,869,320091011.950.29
db file scattered read79,50003900.330.12
db file sequential read83,16303700.350.12
enq: TX - row lock contention6,52703760.030.12
kksfbc child completion8106928350.000.09
latch: In memory undo latch109,38402300.460.07
library cache load lock3,94402250.020.07
cursor: pin S15,83501810.070.06
read by other session19,86301410.080.04
SQL*Net message to client21,774,280012090.710.04
buffer deadlock604,578100902.520.03
enq: SQ - contention22,4490500.090.02
library cache lock3750240.000.00
cursor: mutex S1,5510210.010.00
enq: DV - contention4390130.000.00
Disk file operations I/O17,3290100.070.00
enq: HW - contention1,7480100.010.00
control file sequential read5,0450100.020.00
cursor: mutex X8,5370000.040.00
enq: TX - allocate ITL entry6350000.000.00
utl_file I/O5,3140000.020.00
enq: TX - contention2840010.000.00
library cache pin600020.000.00
latch: cache buffer handles4050000.000.00
latch: enqueue hash chains2750000.000.00
SQL*Net break/reset to client3120000.000.00
enq: FB - contention1290000.000.00
latch free1840000.000.00
db file parallel read50030.000.00
latch: undo global data550000.000.00
SQL*Net more data to client1,1440000.000.00
L1 validation11000100.000.00
wait list latch free90010.000.00
direct path read110010.000.00
latch: redo allocation1340000.000.00
asynch descriptor resize2,946100000.010.00
direct path write130000.000.00
SQL*Net message from client21,774,280077,188490.71 
Streams AQ: waiting for messages in the queue883945,52662580.00 
PL/SQL lock timer2471001,23550010.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
db file parallel write191,342015810.8047.49
log file parallel write241,098011101.0033.51
db file async I/O submit191,3420800.802.32
os thread startup12021460.000.53
LGWR wait for redo copy15,9020100.070.20
control file sequential read1,0760000.000.15
control file parallel write6440010.000.14
Disk file operations I/O1,3150000.010.02
db file sequential read1100000.000.02
latch: redo allocation3300000.000.00
latch free760000.000.00
latch: cache buffers chains10030.000.00
latch: cache buffers lru chain60000.000.00
rdbms ipc message214,399422,1961040.89 
Space Manager: slave idle wait2,4147210,19542230.01 
Streams AQ: qmn slave idle wait40002,76569120.00 
DIAG idle wait2,7591002,76110010.01 
Streams AQ: qmn coordinator idle wait447451,38230930.00 
smon timer14011,38298690.00 
pmon timer972381,37814170.00 
SQL*Net message from client9950110.00 
class slave wait120020.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/O18.6K100.0       
L1 validation1    100.0   
LGWR wait for redo copy15.9K99.4.2.2.2.0.0.0 
SQL*Net break/reset to client31298.11.9      
SQL*Net message to client21.7M100.0       
SQL*Net more data from client2100.0       
SQL*Net more data to client1136100.0       
asynch descriptor resize3205100.0       
buffer busy waits4361K90.46.52.7.4.0.0.0 
buffer deadlock604.5K99.9.0.0.0.0   
control file parallel write64488.45.43.71.4.9.2  
control file sequential read612198.7.6.3.2.1.0  
cursor: mutex S152390.5 .1 9.1.3  
cursor: mutex X832899.7   .3   
cursor: pin S15.6K89.1.0.0.010.8.1  
cursor: pin S wait on X42937.88.48.311.546.911.65.5 
db file async I/O submit191.3K100.0       
db file parallel read540.040.0 20.0    
db file parallel write191.3K86.65.84.32.3.8.1.0 
db file scattered read79.5K96.42.0.9.4.2.1.0 
db file sequential read83K95.52.21.2.7.4.1.0 
direct path read1190.9 9.1     
direct path write13100.0       
enq: DV - contention43977.46.26.65.7.2 3.9 
enq: FB - contention129100.0       
enq: HW - contention174885.513.1.9.2.2.1  
enq: SQ - contention22.4K98.71.0.2.1.0   
enq: TX - allocate ITL entry63592.04.91.4.9.8   
enq: TX - contention28492.37.4 .4    
enq: TX - index contention1104.3K74.517.67.4.4.0.0.0 
enq: TX - row lock contention652784.04.93.83.6.51.61.6.1
enq: UL - contention40.2K12.711.010.69.013.424.418.9.1
kksfbc child completion81030.4     69.6 
latch free26099.6.4      
latch: In memory undo latch109.4K99.6.4.0.0.0   
latch: active service list4100.0       
latch: cache buffer handles40599.8.2      
latch: cache buffers chains1199.6K99.9.1.0.0.0.0  
latch: cache buffers lru chain785.714.3      
latch: enqueue hash chains275100.0       
latch: messages1100.0       
latch: object queue header operation9100.0       
latch: redo allocation464100.0       
latch: row cache objects7100.0       
latch: shared pool1100.0       
latch: undo global data5594.5 5.5     
library cache load lock394438.65.67.714.827.85.6  
library cache lock37555.23.53.54.033.1.8  
library cache pin6023.323.340.013.3    
library cache: mutex X2861.9K99.7.1.0.0.2.0  
log file parallel write241.1K94.23.21.8.8.0.0.0 
log file sync78.5K72.910.38.56.61.4.3.2 
os thread startup12      100.0 
read by other session19.9K90.45.92.11.3.2.1.0 
reliable message1100.0       
utl_file I/O531399.9 .0.0.0   
wait list latch free988.911.1      
DIAG idle wait2759      100.0 
PL/SQL lock timer247       100.0
SQL*Net message from client21.7M99.1.5.3.0.0.0.1.0
Space Manager: slave idle wait2414.0 .3.2.0.58.290.7
Streams AQ: qmn coordinator idle wait44746.12.93.62.0.7  44.7
Streams AQ: qmn slave idle wait394       100.0
Streams AQ: waiting for messages in the queue881      3.696.4
class slave wait1250.025.08.38.38.3   
pmon timer9734.8.2.21.31.22.144.345.8
rdbms ipc message214.4K69.28.85.55.03.02.03.72.7
smon timer1361.51.52.22.211.85.132.443.4

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
LGWR wait for redo copy1100.0.0      
buffer busy waits16100.0.0.0  .0  
cursor: pin S wait on X23694.51.51.5 .71.8  
db file parallel write70100.0.0.0     
db file scattered read22100.0.0      
db file sequential read31100.0.0      
enq: DV - contention1796.13.9      
enq: TX - index contention14100.0.0      
enq: TX - row lock contention10898.3.2.8.1.2.3.1 
enq: UL - contention760181.018.8.1    .1
kksfbc child completion56430.469.6      
log file parallel write32100.0.0.0.0    
log file sync14399.8.2.0     
os thread startup12  16.783.3    
read by other session9100.0.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: UL - contention2399.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)
VIS31,7917,3805132,844,472
SYS$USERS622135
SYS$BACKGROUND00014

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 2033819196799472826002177534512
SYS$USERS 183102000890
SYS$BACKGROUND 1425018220000

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
22,345.78249,8130.0970.2824.700.114f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
22,259.57249,7330.0970.0124.700.125sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
2,847.7214819.248.967.990.01dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1,337.703,990,0780.004.2124.210.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,249.138,3330.153.934.890.017y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
1,093.52249,6240.003.4425.070.035cmrsbj37nx9g PYUSLV SELECT DISTINCT PET.ELEMENT_TY...
1,065.211,499,2250.003.354.740.00fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
1,049.392,736,7660.003.3024.310.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,031.603,740,9000.003.2424.060.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,022.74999,9710.003.226.020.01bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
997.42249,9420.003.1427.340.274ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
709.551,496,0050.002.2324.780.1101pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
633.3228,701,0660.001.9924.900.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
571.163,123,5140.001.8022.960.516v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
512.8210,833,7610.001.6123.130.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
419.781,121,2700.001.3224.730.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
396.19249,1820.001.2523.331.2447g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
359.1113,773,2810.001.1325.070.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
355.14249,8730.001.1225.710.917d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
345.988,3760.041.090.950.0173rvua18a9ytx PYUSLV declare ret number ; BEGIN hr_...
344.774,217,2230.001.0825.070.016500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
320.33249,7860.001.0125.950.4736z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
319.76249,0760.001.0125.670.809jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...

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
5,518.34249,8130.0274.7522,345.7824.700.114f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
5,497.25249,7330.0274.4722,259.5724.700.125sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
323.893,990,0780.004.391,337.7024.210.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
274.10249,6240.003.711,093.5225.070.035cmrsbj37nx9g PYUSLV SELECT DISTINCT PET.ELEMENT_TY...
272.65249,9420.003.69997.4227.340.274ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
255.132,736,7660.003.461,049.3924.310.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
248.183,740,9000.003.361,031.6024.060.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
227.421481.543.082,847.727.990.01dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
175.801,496,0050.002.38709.5524.780.1101pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
157.6928,701,0660.002.14633.3224.900.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
131.163,123,5140.001.78571.1622.960.516v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
118.6010,833,7610.001.61512.8223.130.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
103.821,121,2700.001.41419.7824.730.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
92.45249,1820.001.25396.1923.331.2447g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
91.32249,8730.001.24355.1425.710.917d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
90.0413,773,2810.001.22359.1125.070.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
86.444,217,2230.001.17344.7725.070.016500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
83.12249,7860.001.13320.3325.950.4736z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
82.09249,0760.001.11319.7625.670.809jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...

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
25.60249,7330.0027.8522,259.5724.700.125sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
25.60249,8130.0027.8522,345.7824.700.114f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
25.09249,9210.0027.29204.2823.1612.28g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
4.91249,1820.005.34396.1923.331.2447g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
3.22249,8730.003.50355.1425.710.917d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
2.913,123,5140.003.16571.1622.960.516v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
2.69249,9420.002.93997.4227.340.274ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
2.66249,1430.002.89246.1824.881.082tr0101sa3jh2 PYUSLV BEGIN FFP1893_01010001.FORMULA...
2.54249,0760.002.77319.7625.670.809jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
1.86247,9730.002.02240.1127.760.77fnnyy0vvz6xkw PYUSLV SELECT PPT.CATEGORY CATEGORY, ...
1.50249,7860.001.64320.3325.950.4736z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
1.49249,9260.001.62230.3026.160.657vku4w123mkap PYUSLV SELECT /*+ ORDERED INDEX (ac2 ...
1.42249,6640.001.5442.1325.313.37d4y3b0qsr13x1 PYUSLV SELECT DISTINCT 'Y', 'FF ROUTE...
1.163,105,0440.001.27231.2924.370.50bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...

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,997,811,460249,8137,997.2370.2322,345.7824.7.14f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
1,996,025,432249,7337,992.6470.1722,259.5724.7.15sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
223,777,2113,990,07856.087.871,337.7024.20g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
188,197,5982,736,76668.776.621,049.3924.30dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
180,917,3491,496,005120.936.36709.5524.8.101pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
156,759,6113,740,90041.905.511,031.6024.107rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
151,151,0771481,021,291.065.312,847.7280dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
119,802,45810,833,76111.064.21512.8223.1002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
111,070,5121,121,27099.063.90419.7824.708v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
108,793,86413,773,2817.903.82359.1125.10grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
87,722,224249,786351.193.08320.3325.9.536z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
87,534,060249,942350.223.08997.4227.3.34ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
84,022,98728,701,0662.932.95633.3224.904gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
83,097,166249,926332.492.92230.3026.2.67vku4w123mkap PYUSLV SELECT /*+ ORDERED INDEX (ac2 ...
75,494,823249,873302.132.65355.1425.7.97d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
73,005,61914,596,0535.002.57275.0325.10cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
71,984,379249,624288.372.531,093.5225.105cmrsbj37nx9g PYUSLV SELECT DISTINCT PET.ELEMENT_TY...
71,406,258999,11871.472.51236.6526.80f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...
67,320,3174,217,22315.962.37344.7725.106500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
61,534,5553,123,51419.702.16571.1623.56v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
55,542,827249,182222.901.95396.1923.31.247g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
54,392,94013,750,1293.961.91238.622509wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
46,712,5703,105,04415.041.64231.2924.4.5bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
44,813,276999,97144.811.581,022.7460bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
44,197,2948,3335,303.891.551,249.134.907y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio...
43,683,67414,792,8722.951.54216.6125077d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
41,807,5321,499,22527.891.471,065.214.70fkrq6dbyub3fv PYUSLV INSERT INTO PAY_ACTION_INTERLO...
32,807,778249,253131.621.15222.7121.8.1brhrt8s5mn8kq PYUSLV SELECT PTS.TIME_IN_STATE, PTS....
31,650,154249,143127.041.11246.1824.91.12tr0101sa3jh2 PYUSLV BEGIN FFP1893_01010001.FORMULA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
172,721249,7330.6933.5722,259.5724.700.125sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
172,658249,8130.6933.5622,345.7824.700.114f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
142,682249,9210.5727.73204.2823.1612.28g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
28,471249,8730.115.53355.1425.710.917d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
18,526249,1820.073.60396.1923.331.2447g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
18,096249,1430.073.52246.1824.881.082tr0101sa3jh2 PYUSLV BEGIN FFP1893_01010001.FORMULA...
11,394249,6640.052.2142.1325.313.37d4y3b0qsr13x1 PYUSLV SELECT DISTINCT 'Y', 'FF ROUTE...
11,013249,9420.042.14997.4227.340.274ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
9,1833,105,0440.001.78231.2924.370.50bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
9,163247,9730.041.78240.1127.760.77fnnyy0vvz6xkw PYUSLV SELECT PPT.CATEGORY CATEGORY, ...
8,867249,7860.041.72320.3325.950.4736z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
8,826249,9260.041.72230.3026.160.657vku4w123mkap PYUSLV SELECT /*+ ORDERED INDEX (ac2 ...
8,4103,123,5140.001.63571.1622.960.516v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
8,230249,0760.031.60319.7625.670.809jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
6,5681,496,0050.001.28709.5524.780.1101pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...

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
54,89954,899249,7330.220.0033.795sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
54,89454,894249,8130.220.0033.794f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
46,43746,437249,9210.190.0028.58g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
9,2819,281249,8730.040.005.717d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
5,4675,467249,1430.020.003.372tr0101sa3jh2 PYUSLV BEGIN FFP1893_01010001.FORMULA...
3,7373,737249,9420.010.002.304ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
3,5993,5993,123,5140.000.002.226v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
3,3783,378249,6640.010.002.08d4y3b0qsr13x1 PYUSLV SELECT DISTINCT 'Y', 'FF ROUTE...
3,1043,104247,9730.010.001.91fnnyy0vvz6xkw PYUSLV SELECT PPT.CATEGORY CATEGORY, ...
2,9852,985249,0760.010.001.849jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
2,7762,776249,7860.010.001.7136z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
2,7362,736249,9260.010.001.687vku4w123mkap PYUSLV SELECT /*+ ORDERED INDEX (ac2 ...
2,5492,5493,105,0440.000.001.57bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
1,7991,7991,496,0050.000.001.1101pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...

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,701,06643,795,0261.53633.3224.904gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
14,792,87214,707,0180.99216.6125077d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
14,596,05314,742,0491.01275.0325.10cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
13,773,28113,736,5401.00359.1125.10grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
13,750,12913,719,5221.00238.622509wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
10,833,76110,913,9531.01512.8223.1002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
4,217,22300.00344.7725.106500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
3,990,0783,957,6510.991,337.7024.20g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,740,9003,705,9610.991,031.6024.107rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,123,5143,122,1491.00571.1623.56v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
3,105,04400.00231.2924.4.5bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
2,736,7662,706,1800.991,049.3924.30dz7tyjxnar7gt 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
6636631.29b2gnxm5z6r51n   lock table sys.col_usage$ in e...
4638,0390.902450j0nxcnga5 ICM@app0 (TNS V1-V3) declare sql_dummy1 boolean;beg...
4043,1620.79bb8xj89g0aq9q RUNGEN select parameter_value into :b...
3843840.759gut0j2v6npp7 PYUSLV select 'X' into :b0 from Fnd_C...
3034560.59aw7fu9a9bdyus PYUSLV SELECT * FROM PER_SECURITY_PRO...
2622690.51fj83qgv5su7sr e:FND:cp:STANDARD select SEQUENCE , WIDTH , LENG...
2524100.496u1kf5ctzu70k e:FND:cp:STANDARD select EXECUTABLE_APPLICATION_...
25117,0990.490wmwsjy9kd92f ICM@app0 (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
2493,1580.48cm5vu20fhtnq1   select /*+ connect_by_filterin...
2462480.480k8522rmdzg4k   select privilege# from sysauth...

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
01pkua627ktjkSELECT 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
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0wmwsjy9kd92fSELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
2450j0nxcnga5declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
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;
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
5cmrsbj37nx9gSELECT DISTINCT PET.ELEMENT_TYPE_ID, PEC.CLASSIFICATION_NAME, NVL(PETL.REPORTING_NAME, PETL.ELEMENT_NAME), PET.ELEMENT_INFORMATION10, PET.ELEMENT_INFORMATION12, PET.PROCESSING_PRIORITY FROM PAY_ACTION_INTERLOCKS PAI, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA, PAY_ALL_PAYROLLS_F PPF, PAY_RUN_RESULTS PRR, PAY_ELEMENT_TYPES_F PET, PAY_ELEMENT_CLASSIFICATIONS PEC, PAY_ELEMENT_TYPES_F_TL PETL WHERE PAA.ASSIGNMENT_ID = :B5 AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND :B4 = 'N' AND PAI.LOCKING_ACTION_ID = :B3 AND PAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID AND PAA.ACTION_SEQUENCE <= :B2 AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID AND PET.ELEMENT_INFORMATION10 IS NOT NULL AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE AND PPA.PAYROLL_ID = PPF.PAYROLL_ID AND PPF.PAYROLL_ID >= 0 AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND PETL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PETL.LANGUAGE = :B1 AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID AND PEC.CLASSIFICATION_NAME IN ('Earnings', 'Alien/Expat Earnings', 'Supplemental Earnings', 'Imputed Earnings', 'Taxable Benefits', 'Pre-Tax Deductions', 'Involuntary Deductions', 'Voluntary Deductions', 'Non-payroll Payments' ) AND PET.ELEMENT_NAME NOT LIKE '%Calculator' AND PET.ELEMENT_NAME NOT LIKE '%Special Inputs' AND PET.ELEMENT_NAME NOT LIKE '%Special Features' AND PET.ELEMENT_NAME NOT LIKE '%Special Features 2' AND PET.ELEMENT_NAME NOT LIKE '%Verifier' AND PET.ELEMENT_NAME NOT LIKE '%Priority' ORDER BY PEC.CLASSIFICATION_NAME
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
6u1kf5ctzu70kselect EXECUTABLE_APPLICATION_ID into :b0 from FND_CONCURRENT_PROGRAMS where (APPLICATION_ID=:b1 and CONCURRENT_PROGRAM_ID=:b2)
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 )
73rvua18a9ytxdeclare ret number ; BEGIN hr_nonrun_asact . get_next_pop_chunk ( :pactid , :atype , :l_lckhandle , :lub , :lul , :chunk_method , :threads , :slave_no , :curr_chunk , :max_chunks , :stperson:stperson_ind , :endperson:endperson_ind , :chunk:chunk_ind , :rand_chunk:rand_chunk_ind ) ; END ;
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 ;
7rks7t2gukcwnSELECT /*+ 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 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)
7vku4w123mkapSELECT /*+ 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;
8v2cvg5zhw9uaSELECT 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)
9gut0j2v6npp7select 'X' into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 for update of Status_Code
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
aw7fu9a9bdyusSELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bb8xj89g0aq9qselect parameter_value into :b0 from pay_action_parameters where ((parameter_name=:b1 or parameter_name=REPLACE(:b1, ' ', '_')) or parameter_name=REPLACE(: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
bm8gwn43tn8hdSELECT 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.JURISDICTION_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
brhrt8s5mn8kqSELECT 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 = :B3 AND PTS.JURISDICTION_CODE LIKE :B2 AND PST.JURISDICTION_CODE = PTS.JURISDICTION_CODE AND PST.ASSIGNMENT_ID = PTS.ASSIGNMENT_ID AND :B1 BETWEEN PST.EFFECTIVE_START_DATE AND PST.EFFECTIVE_END_DATE AND :B1 BETWEEN PTS.EFFECTIVE_START_DATE AND PTS.EFFECTIVE_END_DATE
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
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
d4y3b0qsr13x1SELECT DISTINCT 'Y', 'FF ROUTE:USER_TIME' FROM PAY_ELEMENT_ENTRIES_F PEE_CURRENT, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_TYPES_F PET, PAY_ELEMENT_CLASSIFICATIONS PEC, HR_LOOKUPS HL WHERE PEE_CURRENT.ASSIGNMENT_ID = :B3 AND PEE_CURRENT.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID AND PEE_CURRENT.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND (( EXISTS (SELECT 1 FROM PAY_ELEMENT_ENTRIES_F PEE WHERE PEE.ELEMENT_ENTRY_ID = :B4 AND PEE.ASSIGNMENT_ID = PEE_CURRENT.ASSIGNMENT_ID AND :B2 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE AND :B2 BETWEEN PEE_CURRENT.EFFECTIVE_START_DATE AND PEE_CURRENT.EFFECTIVE_END_DATE AND PEE.ELEMENT_TYPE_ID <> PEE_CURRENT.ELEMENT_TYPE_ID AND NVL(PEE.CREATOR_TYPE, 'Z') NOT IN ('P', 'R', 'EE', 'RR', 'PR', 'NR') AND NVL(PEE_CURRENT.CREATOR_TYPE, 'Z') NOT IN ('P', 'R', 'EE', 'RR', 'PR', 'NR') ) ) OR ( EXISTS (SELECT 1 FROM PAY_ELEMENT_ENTRIES_F PEE , PAY_ELEMENT_ENTRIES_F PEE_RETRO , PAY_ASSIGNMENT_ACTIONS PAA , PAY_PAYROLL_ACTIONS PPA , PAY_RUN_RESULTS PRR WHERE PEE.ELEMENT_ENTRY_ID = :B4 AND PEE.ASSIGNMENT_ID = PEE_CURRENT.ASSIGNMENT_ID AND PEE.CREATOR_TYPE IN ('P', 'R', 'EE', 'RR', 'PR', 'NR') AND PEE.ELEMENT_ENTRY_ID = PRR.SOURCE_ID AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND NVL(PPA.DATE_EARNED, PPA.EFFECTIVE_DATE) > :B2 AND NVL(PPA.DATE_EARNED, PPA.EFFECTIVE_DATE) BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE AND PEE.ELEMENT_TYPE_ID = PEE_RETRO.ELEMENT_TYPE_ID AND PEE.ASSIGNMENT_ID = PEE_RETRO.ASSIGNMENT_ID AND :B2 BETWEEN PEE_RETRO.EFFECTIVE_START_DATE AND PEE_RETRO.EFFECTIVE_END_DATE AND PEE.ELEMENT_ENTRY_ID <> PEE_CURRENT.ELEMENT_ENTRY_ID ) )) AND :B2 BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE AND NVL(PET.BUSINESS_GROUP_ID, :B1 ) = :B1 AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID AND PEC.CLASSIFICATION_NAME IN ('Earnings', 'Supplemental Earnings') AND PEC.BUSINESS_GROUP_ID IS NULL AND PET.ELEMENT_INFORMATION9 = 'T' AND HL.LOOKUP_CODE = PET.ELEMENT_INFORMATION1 AND HL.LOOKUP_TYPE IN ('US_EARNINGS', 'CA_REGULAR_EARNINGS', 'CA_SUPPLEMENTAL_EARNINGS') AND HL.LOOKUP_CODE = DECODE(PEC.LEGISLATION_CODE, 'US', 'REG', PET.ELEMENT_INFORMATION1)
dab1prc9qyv3v begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end;
dz7tyjxnar7gtSELECT /*+ 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 RR.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')
fj83qgv5su7srselect SEQUENCE , WIDTH , LENGTH , SRW_DRIVER , HEADER_FLAG into :b0, :b1, :b2, :b3, :b4 from FND_PRINTER_STYLES where PRINTER_STYLE_NAME=:b5
fkrq6dbyub3fvINSERT INTO PAY_ACTION_INTERLOCKS ( LOCKING_ACTION_ID, LOCKED_ACTION_ID) VALUES (:B2 , :B1 )
fnnyy0vvz6xkwSELECT PPT.CATEGORY CATEGORY, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_METHOD, PEA.PRENOTE_DATE PRENOTE_DATE, PPT.VALIDATION_DAYS VALID_DAYS, PPM.PERCENTAGE PERCENTAGE, PPM.AMOUNT AMOUNT, OPM.ORG_PAYMENT_METHOD_ID ORG_METHOD, HR_PRE_PAY.SET_CASH_RULE(PPT.CATEGORY, OPM.PMETH_INFORMATION1) CASH_RULE, OPM.CURRENCY_CODE PAYMENT_CURRENCY, PPT.PRE_VALIDATION_REQUIRED VALIDATION_REQUIRED, PPT.VALIDATION_VALUE VALIDATION_VALUE, OPM.EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID FROM PAY_EXTERNAL_ACCOUNTS PEA, PAY_PAYMENT_TYPES PPT, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PERSONAL_PAYMENT_METHODS_F PPM WHERE PPM.ASSIGNMENT_ID = :B3 AND PPM.RUN_TYPE_ID IS NULL AND PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND OPM.DEFINED_BALANCE_ID = :B2 AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN PPM.EFFECTIVE_START_DATE AND PPM.EFFECTIVE_END_DATE AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE ORDER BY PPM.PERSON_ID, PPM.PRIORITY
g2daxnc5b7ravSELECT /*+ 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 RR.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
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.action_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.element_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 p ay_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 count20.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count1,3050.940.01
Batched IO buffer defrag count00.000.00
Batched IO double miss count5370.390.00
Batched IO same unit count1920.140.00
Batched IO single block count460.030.00
Batched IO vector block count1,0540.760.00
Batched IO vector read count400.030.00
Block Cleanout Optim referenced95,07868.760.40
CCursor + sql area evicted00.000.00
CPU used by this session721,618521.903.01
CPU used when call started721,576521.873.01
CR blocks created9,260,4896,697.5238.58
Cached Commit SCN referenced7,082,4045,122.2529.51
Commit SCN cached855,680618.863.56
DB time3,811,1092,756.3315.88
DBWR checkpoint buffers written1,882,6131,361.577.84
DBWR transaction table writes1880.140.00
DBWR undo block writes1,201,370868.875.01
DFO trees parallelized00.000.00
Effective IO time8,7776.350.04
HSC Heap Segment Block Changes17,818,01812,886.6374.23
Heap Segment Array Inserts2,084,4091,507.528.68
Heap Segment Array Updates107,02577.400.45
IMU CR rollbacks1,424,8041,030.475.94
IMU Flushes150,887109.130.63
IMU Redo allocation size1,267,276,060916,539.365,279.63
IMU commits85,88462.110.36
IMU contention83,33960.270.35
IMU ktichg flush2400.170.00
IMU recursive-transaction flush3,4432.490.01
IMU undo allocation size2,806,326,8642,029,635.9311,691.52
Number of read IOs issued110.010.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations downgraded 75 to 99 pct00.000.00
Requests to/from client21,774,25215,747.9290.71
RowCR - row contention169,195122.370.70
RowCR attempts12,164,6358,797.9050.68
RowCR hits11,986,6138,669.1549.94
SQL*Net roundtrips to/from client21,774,25815,747.9290.71
active txn count during cleanout99,289,37571,809.63413.65
application wait time80,07557.910.33
background timeouts8,7386.320.04
branch node splits1,0250.740.00
buffer is not pinned count1,500,626,9271,085,307.056,251.80
buffer is pinned count701,461,967507,322.382,922.38
bytes received via SQL*Net from client5,809,336,3534,201,519.7724,202.44
bytes sent via SQL*Net to client3,283,604,1752,374,819.9513,679.92
calls to get snapshot scn: kcmgss220,798,118159,689.09919.87
calls to kcmgas11,280,7438,158.6447.00
calls to kcmgcs13,453,0229,729.7156.05
cell physical IO interconnect bytes44,882,226,17632,460,430.81186,985.12
change write time30,13621.800.13
cleanout - number of ktugct calls13,044,1949,434.0354.34
cleanouts and rollbacks - consistent read gets8,694,1426,287.9136.22
cleanouts only - consistent read gets394,491285.311.64
cluster key scan block gets7,9585.760.03
cluster key scans4,2263.060.02
commit batch/immediate performed39,65928.680.17
commit batch/immediate requested39,65928.680.17
commit cleanout failures: block lost4640.340.00
commit cleanout failures: buffer being written10.000.00
commit cleanout failures: callback failure516,176373.322.15
commit cleanout failures: cannot pin95,00368.710.40
commit cleanouts5,744,6214,154.7223.93
commit cleanouts successfully completed5,132,9773,712.3521.38
commit immediate performed39,65928.680.17
commit immediate requested39,65928.680.17
commit txn count during cleanout2,698,4991,951.6511.24
concurrency wait time282,758204.501.18
consistent changes445,849,512322,454.311,857.47
consistent gets2,651,630,5891,917,754.0611,047.03
consistent gets - examination1,749,778,4411,265,502.337,289.80
consistent gets direct220.020.00
consistent gets from cache2,651,630,5671,917,754.0411,047.03
consistent gets from cache (fastpath)833,594,589602,885.413,472.86
cursor authentications8440.610.00
data blocks consistent reads - undo records applied445,217,642321,997.321,854.83
db block changes148,040,139107,067.92616.75
db block gets192,984,064139,572.98804.00
db block gets direct1540.110.00
db block gets from cache192,983,910139,572.86804.00
db block gets from cache (fastpath)40,831,37229,530.71170.11
deferred (CURRENT) block cleanout applications351,506254.221.46
doubling up with imu segment3000.220.00
enqueue conversions560.040.00
enqueue releases2,777,6432,008.8911.57
enqueue requests2,778,4732,009.4911.58
enqueue timeouts8290.600.00
enqueue waits1,176,690851.024.90
exchange deadlocks604,657437.312.52
execute count232,483,487168,140.37968.56
failed probes on index block reclamation3340.240.00
file io wait time241,447,622174,623.551,005.90
free buffer inspected287,743208.111.20
free buffer requested12,333,3938,919.9551.38
heap block compress197,200142.620.82
hot buffers moved to head of LRU3,5562.570.01
immediate (CR) block cleanout applications9,088,7426,573.3037.86
immediate (CURRENT) block cleanout applications1,133,643819.894.72
in call idle wait time4,882,1833,530.9720.34
index crx upgrade (positioned)1,8011.300.01
index fetch by key316,032,915228,566.301,316.63
index scans kdiixs1434,650,520314,354.801,810.81
leaf node 90-10 splits38,13127.580.16
leaf node splits250,016180.821.04
lob reads110.010.00
lob writes430.030.00
lob writes unaligned430.030.00
logical read bytes from cache23,298,480,660,48016,850,294,292.2197,064,465.26
logons cumulative2620.190.00
max cf enq hold time140.010.00
messages received432,504312.801.80
messages sent432,504312.801.80
min active SCN optimization applied on CR89,523,28164,746.44372.97
no buffer to keep pinned count420.030.00
no work - consistent read gets834,149,387603,286.663,475.17
non-idle wait count39,932,29028,880.46166.36
non-idle wait time416,505301.231.74
opened cursors cumulative220,128,899159,205.09917.09
parse count (describe)00.000.00
parse count (failures)50.000.00
parse count (hard)9470.680.00
parse count (total)51,34537.130.21
parse time cpu13,6009.840.06
parse time elapsed71,18951.490.30
physical read IO requests162,456117.490.68
physical read bytes4,215,046,1443,048,472.0917,560.42
physical read total IO requests168,920122.170.70
physical read total bytes4,318,142,4643,123,035.0317,989.94
physical read total multi block requests520.040.00
physical reads514,532372.132.14
physical reads cache514,510372.112.14
physical reads cache prefetch352,227254.741.47
physical reads direct220.020.00
physical reads direct (lob)220.020.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup345,443249.841.44
physical write IO requests191,367138.400.80
physical write bytes15,423,627,26411,154,918.7464,256.81
physical write total IO requests764,992553.273.19
physical write total bytes40,564,083,71229,337,395.78168,995.19
physical write total multi block requests130,78594.590.54
physical writes1,882,7671,361.687.84
physical writes direct1540.110.00
physical writes direct (lob)140.010.00
physical writes from cache1,882,6131,361.577.84
physical writes non checkpoint1,787,2481,292.607.45
pinned buffers inspected1190.090.00
process last non-idle time1,3801.000.01
queries parallelized00.000.00
recursive aborts on index block reclamation140.010.00
recursive calls406,752,598294,178.021,694.58
recursive cpu usage643,743465.582.68
redo blocks checksummed by FG (exclusive)11,723,8988,479.1448.84
redo blocks written49,040,63035,467.94204.31
redo entries76,693,50255,467.48319.51
redo ordering marks922,445667.153.84
redo size24,144,542,36817,462,196.37100,589.27
redo size for direct writes1,3000.940.01
redo subscn max counts1,972,0281,426.248.22
redo synch long waits1730.130.00
redo synch time10,9807.940.05
redo synch time (usec)109,761,66179,383.56457.28
redo synch writes87,79963.500.37
redo wastage142,431,192103,011.33593.39
redo write time11,1908.090.05
redo writes241,098174.371.00
rollback changes - undo records applied167,827121.380.70
rollbacks only - consistent read gets397,300287.341.66
root node splits30.000.00
rows fetched via callback208,019,836150,447.38866.64
session connect time00.000.00
session cursor cache hits7,670,9065,547.8731.96
session logical reads2,844,614,6532,057,327.0311,851.03
shared hash latch upgrades - no wait42,432,66130,688.82176.78
shared hash latch upgrades - wait2,497,7441,806.4610.41
sorts (memory)19,569,20014,153.1581.53
sorts (rows)45,110,15032,625.27187.93
sql area evicted00.000.00
sql area purged50.000.00
switch current to new buffer699,981506.252.92
table fetch by rowid767,563,767555,129.563,197.77
table fetch continued row1,4801.070.01
table scan blocks gotten83,118,39260,114.19346.28
table scan rows gotten2,672,140,8651,932,587.8211,132.48
table scans (cache partitions)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)9,083,6576,569.6337.84
total cf enq hold time1380.100.00
total number of cf enq holders460.030.00
total number of times SMON posted1380.100.00
transaction rollbacks39,64828.670.17
undo change vector size8,972,408,0246,489,166.3137,380.21
user I/O wait time9,1886.650.04
user calls23,202,67416,781.0096.67
user commits239,432173.171.00
user rollbacks5990.430.00
workarea executions - optimal13,990,90610,118.7258.29
write clones created in foreground360.030.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory108,726,224131,389,368
opened cursors current8591,130
logons current9197
session uga memory max424,578,1601,576,491,232
session pga memory220,937,632235,705,184
session pga memory max270,757,504284,201,824
session cursor cache count5,80037,578

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.000M23.4G413.4717.3186241.1K0.13
DBWR0M0.000M14.4G138.3610.63510 
Buffer Cache Reads3.9G117.302.905230M0.000M162.1K0.14
Others97M4.67.07015330M1.41.02169771080.07
Direct Writes0M0.000M1M0.01.0007230 
Direct Reads0M0.010M0M0.000M0 
TOTAL:4G121.982.9753937.8G553.2427.9762410.3K0.13

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.000M23.4G413.4717.3186  
Data File3.9G117.612.9095714.4G138.4010.64380.143.31
Control File96M4.43.06943030M1.40.0216970.04 
TOTAL:4G122.042.9790037.8G553.2727.98410.143.31

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.000M23.4G413.4717.31860 
LGWR (Log File) 0M0.000M23.4G413.4717.31860 
DBWR 0M0.000M14.4G138.3610.63510 
DBWR (Data File) 0M0.000M14.4G138.3610.63510 
Buffer Cache Reads 3.9G117.272.905230M0.000M162K0.14
Buffer Cache Reads (Data File) 3.9G117.272.905230M0.000M162K0.14
Others 98M4.67.07087730M1.41.02169764600.04
Others (Control File) 96M4.42.06943030M1.40.02169761170.04
Others (Data File) 2M0.25.0014460M0.010M3430.00
TOTAL: 4G121.952.9761137.8G553.2327.9754168.5K0.14

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 123,581890.483.2175,47355725,6830.34
APPS_UNDOTS1 4700.851.0093,90468479,0710.02
APPS_TS_TX_IDX 35,066250.453.2421,432163,569,9220.35
SYSTEM 2,98320.451.0910701,8800.22
SYSAUX 62400.321.56386000.00
APPS_TS_SEED 30900.451.844201,6771.00
APPS_TS_ARCHIVE 1200.831.422101180.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/oracle/product/11.2.0/dbf/archive1.dbf 1200.831.422101180.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference1.dbf 600.001.672000.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference10.dbf 700.001.2930590.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference11.dbf 700.001.4340250.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference12.dbf 100.001.001000.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference13.dbf 400.001.0010450.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference15.dbf 9800.611.98205540.99
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference16.dbf 1400.711.9300600.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference17.dbf 1600.631.69201852.22
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference18.dbf 2100.481.3830891.24
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference19.dbf 1800.562.563080.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference2.dbf 900.001.670020.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference20.dbf 2400.421.4630850.47
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference21.dbf 1100.911.3620940.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference22.dbf 1100.914.2720249.17
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference23.dbf 1001.001.9000400.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference24.dbf 300.001.0000340.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference25.dbf 600.001.1700450.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference3.dbf 1000.001.6030521.35
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference4.dbf 700.001.4320732.47
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference5.dbf 200.003.0000230.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference6.dbf 300.001.002040.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference7.dbf 600.002.3340610.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference8.dbf 700.002.1420720.00
APPS_TS_SEED/oracle/product/11.2.0/dbf/reference9.dbf 800.001.0010432.33
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data11.dbf 1,48810.503.027401180.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data12.dbf 1,37810.433.05681060.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data13.dbf 2,34820.343.261,27813,8760.04
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data19.dbf 66600.413.0750010.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data2.dbf 2,28320.623.181,23313,6610.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data21.dbf 2,73520.393.191,387156,6940.18
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data22.dbf 1,87210.463.1496914920.04
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data24.dbf 67100.343.0542010.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data27.dbf 66600.363.0727010.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data28.dbf 97410.353.0790315370.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data29.dbf 31000.323.3029000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data30.dbf 32300.373.1631000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data31.dbf 30800.393.3129000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data32.dbf 2,36420.353.212,48028,2420.05
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data33.dbf 31800.473.2231000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data34.dbf 31100.353.2932000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data35.dbf 31200.583.2825000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data36.dbf 30800.423.3131000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data37.dbf 31800.473.24310180.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data46.dbf 1800.562.3914010.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data47.dbf 1,69210.483.211,04214,5860.34
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data48.dbf 1,66110.423.251,05613,6790.07
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data49.dbf 1,69510.353.271,07513,6850.12
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data50.dbf 1,78810.393.331,11014,0360.07
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data51.dbf 2,44620.383.212,705265,8980.09
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data52.dbf 1,01510.473.15628000.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data53.dbf 2,43220.433.222,39426,0450.12
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data54.dbf 2,48520.373.192,570219,9190.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data55.dbf 2,69820.623.242,137213,6700.02
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data56.dbf 2,69520.433.241,937114,0430.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data57.dbf 2,30020.393.291,461110,7320.07
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data58.dbf 2,34520.633.291,39719,4870.19
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data59.dbf 2,27420.463.291,428110,6800.07
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data6.dbf 500.002.6000490.00
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data60.dbf 1,74110.433.291,285111,3200.11
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data61.dbf 1,66910.413.2876818,1300.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data62.dbf 1,57810.463.3175717,2680.01
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data63.dbf 1,60310.523.3269712,7500.02
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data64.dbf 1,74610.483.2876012,4100.45
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data65.dbf 1,84110.423.2872112,7480.10
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data66.dbf 1,88010.453.2274112,9220.17
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data67.dbf 1,59510.433.2776213,7230.82
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data68.dbf 1,71210.363.3587015,0140.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data69.dbf 2,02610.393.3195114,4990.29
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data70.dbf 1,95810.363.4191315,8760.11
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data71.dbf 2,01510.603.411,08812,3700.15
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data72.dbf 1,98010.493.241,11811,0450.42
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data73.dbf 1,96210.393.2194911,0980.67
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data74.dbf 2,17020.563.221,09311,6910.02
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data75.dbf 1,96210.463.151,23311,5570.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data76.dbf 2,06010.393.131,61411,2950.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data77.dbf 2,38720.603.082,01411,7350.05
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data78.dbf 2,25020.513.091,73211,9810.25
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data79.dbf 2,39820.383.141,64712,0000.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data80.dbf 2,42920.473.131,59912,2670.05
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data81.dbf 2,51420.403.191,71111,8840.06
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data82.dbf 2,74820.763.181,61812,5650.48
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data83.dbf 2,70820.433.141,52012,8430.08
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data84.dbf 2,42120.403.151,45316,1650.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data85.dbf 2,82720.813.111,59018,1530.05
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data86.dbf 2,78320.473.141,58018,5280.03
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data87.dbf 2,50120.363.151,42719,2210.05
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data88.dbf 2,53120.723.161,435111,2520.09
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data89.dbf 2,62620.453.151,617155,0940.32
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data90.dbf 2,97820.833.161,882177,6600.45
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data91.dbf 2,86220.473.201,8101102,9190.99
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data92.dbf 2,83820.373.201,905179,6770.51
APPS_TS_TX_DATA/oracle/product/11.2.0/dbf/tx_data93.dbf 2,78020.603.191,630145,9660.17
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx1.dbf 33000.483.4159016,0310.31
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx10.dbf 28500.393.3753017,6310.26
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx11.dbf 30200.733.4967030,2550.62
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx12.dbf 33200.573.4471026,6430.40
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx13.dbf 33900.473.4186030,4120.66
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx14.dbf 61200.363.2681030,9200.58
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx15.dbf 60300.413.1969034,8830.65
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx16.dbf 58800.363.2271034,8790.73
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx17.dbf 59100.663.23270082,1080.81
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx18.dbf 58700.373.20240020,2920.31
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx19.dbf 92310.333.10147022,0560.33
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx2.dbf 95410.443.09146015,0400.22
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx20.dbf 88110.373.17136012,3660.18
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx21.dbf 59000.393.29124012,0570.14
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx22.dbf 57800.333.3115909,9190.22
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx23.dbf 58200.363.289908,6290.20
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx24.dbf 56700.373.3110005,5000.29
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx25.dbf 21000.623.4410505,1810.34
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx26.dbf 20700.343.412305,1890.33
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx27.dbf 23900.423.364405,2610.21
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx28.dbf 22500.403.534406,0440.22
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx29.dbf 25200.363.564606,3480.24
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx3.dbf 52900.423.605006,6920.31
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx30.dbf 28700.423.544205,5920.25
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx31.dbf 24400.493.445505,7960.26
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx32.dbf 21800.413.504407,7660.34
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx33.dbf 38800.493.5415205,2380.21
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx34.dbf 48700.413.60345096,2950.23
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx35.dbf 57200.373.50774193,1970.24
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx36.dbf 51500.353.586380102,3780.15
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx37.dbf 79410.353.516120131,7110.18
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx38.dbf 92810.393.3214705,8210.24
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx39.dbf 72610.433.406380142,8100.19
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx4.dbf 59800.523.3891018,4800.50
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx40.dbf 43900.593.47788192,4050.20
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx41.dbf 47700.483.489631103,1910.26
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx42.dbf 51400.583.48961189,3630.21
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx43.dbf 54500.463.361,1671202,3520.38
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx44.dbf 47500.613.521,1071172,6390.41
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx45.dbf 45800.393.507581146,9650.69
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx46.dbf 83810.433.668681103,8380.66
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx47.dbf 97710.523.69699170,0030.17
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx48.dbf 80110.493.436921173,9530.28
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx49.dbf 60900.463.386941132,5630.32
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx5.dbf 73710.473.3112508,8780.18
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx50.dbf 48800.613.45783196,3510.24
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx51.dbf 60200.383.65907122,6550.11
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx52.dbf 62100.453.68355016,2190.31
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx53.dbf 78110.423.51333049,7020.23
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx54.dbf 2,08720.261.00378065,2840.23
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx55.dbf 58700.493.41363070,5180.26
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx56.dbf 55200.383.40372065,5060.24
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx57.dbf 29900.403.37418072,1360.31
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx58.dbf 21800.783.32395050,8060.27
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx59.dbf 19900.403.30292037,8710.26
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx6.dbf 23700.463.035940229,1650.65
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx60.dbf 19700.663.273640136,2810.37
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx61.dbf 21700.883.161890135,7130.15
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx62.dbf 20100.403.2330034,6400.11
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx63.dbf 26301.063.058203,1260.26
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx64.dbf 29300.583.1411204,2470.11
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx65.dbf 28700.453.2215406,5180.16
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx66.dbf 31000.583.22159012,8540.43
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx67.dbf 28400.563.2959011,3840.38
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx68.dbf 31400.413.2562015,7580.39
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx69.dbf 29100.583.2865011,4330.37
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx7.dbf 27200.403.273808,1490.35
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx70.dbf 26500.383.38112017,2560.32
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx71.dbf 29400.823.373508,1340.40
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx72.dbf 29800.503.393707,8300.44
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx8.dbf 35800.423.3945011,7030.29
APPS_TS_TX_IDX/oracle/product/11.2.0/dbf/tx_idx9.dbf 31800.603.6049013,1130.31
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo.dbf 300.001.0013,4741049,3000.03
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo2.dbf 300.001.005,621434,1820.03
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo3.dbf 300.001.005,491425,6920.02
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo4.dbf 100.001.005,788426,7960.02
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo5.dbf 402.501.006,786543,2450.03
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo6.dbf 1901.051.0014,6841167,9790.03
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo7.dbf 1001.001.0014,1081073,8730.03
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo8.dbf 200.001.0014,1021065,3450.02
APPS_UNDOTS1/oracle/product/11.2.0/dbf/undo9.dbf 200.001.0013,8501092,6590.03
SYSAUX/oracle/product/11.2.0/dbf/sysaux01.dbf 31000.261.01132000.00
SYSAUX/oracle/product/11.2.0/dbf/sysaux02.dbf 6000.502.8060000.00
SYSAUX/oracle/product/11.2.0/dbf/sysaux03.dbf 4800.422.0644000.00
SYSAUX/oracle/product/11.2.0/dbf/sysaux04.dbf 2000.502.2528000.00
SYSAUX/oracle/product/11.2.0/dbf/sysaux05.dbf 12800.231.7377000.00
SYSAUX/oracle/product/11.2.0/dbf/sysaux06.dbf 5800.522.2245000.00
SYSTEM/oracle/product/11.2.0/dbf/sys1.dbf 19300.622.41120670.00
SYSTEM/oracle/product/11.2.0/dbf/sys10.dbf 19000.421.01401470.34
SYSTEM/oracle/product/11.2.0/dbf/sys11.dbf 37000.411.002203970.55
SYSTEM/oracle/product/11.2.0/dbf/sys2.dbf 22900.481.0080730.00
SYSTEM/oracle/product/11.2.0/dbf/sys3.dbf 21400.421.000000.00
SYSTEM/oracle/product/11.2.0/dbf/sys4.dbf 22400.491.004000.00
SYSTEM/oracle/product/11.2.0/dbf/sys5.dbf 54200.391.001009080.17
SYSTEM/oracle/product/11.2.0/dbf/sys6.dbf 24700.401.02310320.00
SYSTEM/oracle/product/11.2.0/dbf/sys7.dbf 24400.531.0190710.00
SYSTEM/oracle/product/11.2.0/dbf/sys8.dbf 22100.501.0010130.00
SYSTEM/oracle/product/11.2.0/dbf/sys9.dbf 30900.421.00601720.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,447,9301002,831,204,990514,6211,882,613004,780,230

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,882,4750

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
B01338820589953280099532800    
E043328018865848159953280099532800    

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.359721215.00
D5,5040.206791.238911180.00
D8,2560.301,0181.138151146.00
D11,0080.391,3571.037441116.00
D13,7600.491,6961.017271108.00
D16,5120.592,0361.007241107.00
D19,2640.692,3751.007221106.00
D22,0160.792,7141.007221106.00
D24,7680.893,0531.007221106.00
D27,5200.983,3931.007221106.00
D27,9681.003,4481.007221106.00
D30,2721.083,7321.007221106.00
D33,0241.184,0711.007221106.00
D35,7761.284,4111.007221106.00
D38,5281.384,7501.007221106.00
D41,2801.485,0891.007221106.00
D44,0321.575,4281.007221106.00
D46,7841.675,7681.007221106.00
D49,5361.776,1071.007221106.00
D52,2881.876,4461.007221106.00
D55,0401.976,7851.007221106.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,6100

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,061240.270.000.000.000.001,048,570
E10,2409,053253.400.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,858,80513,858,80500
64K128K313100
128K256K484800
256K512K4400
512K1024K505000
1M2M101000
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.1334,262.590.00100.00051,747,217
2,5600.2534,262.590.00100.00051,747,217
5,1200.5034,262.590.00100.00051,747,217
7,6800.7534,262.590.00100.00051,747,217
10,2401.0034,262.590.00100.00051,747,217
12,2881.2034,262.590.00100.00051,747,217
14,3361.4034,262.590.00100.00051,747,217
16,3841.6034,262.590.00100.00051,747,217
18,4321.8034,262.590.00100.00051,747,217
20,4802.0034,262.590.00100.00051,747,217
30,7203.0034,262.590.00100.00051,747,217
40,9604.0034,262.590.00100.00051,747,217
61,4406.0034,262.590.00100.00051,747,217
81,9208.0034,262.590.00100.00051,747,217

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)
7040.31865,630785,7881.007721.00102,535
9600.431117,330785,7881.007721.00102,535
1,2160.541117,330785,7881.007721.00102,535
1,4720.661117,330785,7881.007721.00102,535
1,6000.711117,330785,7881.007721.00102,535
1,6640.741117,330785,7881.007721.00102,535
1,7280.771117,330785,7881.007721.00102,535
1,7920.801117,330785,7881.007721.00102,535
1,8560.831117,330785,7881.007721.00102,535
1,9200.861117,330785,7881.007721.00102,535
1,9840.891117,330785,7881.007721.00102,535
2,0480.911117,330785,7881.007721.00102,535
2,1120.941117,330785,7881.007721.00102,535
2,1760.971117,330785,7881.007721.00102,535
2,2401.001117,330785,7881.007721.00102,535
2,3041.031117,330785,7881.007721.00102,535
2,3681.061117,330785,7881.007721.00102,535
2,4321.091117,330785,7881.007721.00102,535
2,4961.111117,330785,7881.007721.00102,535
2,5601.141117,330785,7881.007721.00102,535
2,6241.171117,330785,7881.007721.00102,535
2,6881.201117,330785,7881.007721.00102,535
2,7521.231117,330785,7881.007721.00102,535
2,8161.261117,330785,7881.007721.00102,535
3,0081.341117,330785,7881.007721.00102,535
3,2641.461117,330785,7881.007721.00102,535
3,5201.571117,330785,7881.007721.00102,535
3,7761.691117,330785,7881.007721.00102,535
4,0321.801117,330785,7881.007721.00102,535
4,2881.911117,330785,7881.007721.00102,535
4,5442.031117,330785,7881.007721.00102,535

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.1331,976971,190
7,6800.2531,941891,263
11,5200.3831,878743,826
15,3600.5031,871726,353
19,2000.6331,872723,609
23,0400.7531,869722,021
26,8800.8831,869722,021
30,7201.0031,868722,021
34,5601.1331,869722,021
38,4001.2531,869722,021
42,2401.3831,869722,021
46,0801.5031,869722,021
49,9201.6331,869722,021
53,7601.7531,869722,021
57,6001.8831,869722,021
61,4402.0031,869722,021

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,295,6831,4930
undo block400,49290
undo header78,54130
segment header26601
1st level bmb1,55600
3rd level bmb4002
2nd level bmb26700
system undo header4400

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 1,113,7341,113,71001,104,2998600.78
UL-User-defined 51,08050,43964140,16376319.01
TX-Transaction (row lock contention) 6,8086,6521566,527375.72
SQ-Sequence Cache 32,58732,587022,44950.23
DV-Diana Versioning 1,0801,080043912.57
HW-Segment High Water Mark 7,0256,994311,74810.49
TX-Transaction (allocate ITL entry) 716716063500.42
TX-Transaction 555,480555,509028400.59
FB-Format Block 25,91425,919012900.16

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,200.98440,8679456860.3/62.10/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
26-Feb 10:45375,325130,36482052620/00/0/0/0/0/0
26-Feb 10:35825,655310,50394568600/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 
AQ dequeue txn counter latch2,4520.040.0000 
ASM db client latch9210.00 00 
ASM map operation hash table10.00 00 
ASM network state latch7230.00 00 
AWR Alerted Metric Element list15,8980.00 00 
Change Notification Hash table latch4610.00 00 
Consistent RBA242,1820.040.0000 
DML lock allocation1,913,6750.010.0000 
Event Group Locks5240.00 00 
FOB s.o list latch36,6420.220.0000 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch28,520,9330.470.8523241,6030.05
JS Sh mem access10.00 00 
JS broadcast autostart latch10.00 00 
JS queue access latch10.00 00 
JS queue state obj latch20.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 latch4610.00 00 
KTF sga latch80.00 04230.00
KWQMN job cache list latch230.00 00 
KWQP Prop Status1750.00 00 
KWQS pqsubs latch280.00 00 
KWQS pqueue ctx latch310.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0270.00
Memory Management Latch10.00 04610.00
Memory Queue30.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 Latch140.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
NLS data objects30.00 00 
OS process1,0910.00 00 
OS process allocation3,3120.790.0000 
OS process: request allocation5183.860.0000 
PL/SQL warning settings3,765,3840.160.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch7060.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 04600.00
SQL memory manager workarea list latch5,552,3380.070.0000 
Shared B-Tree9660.210.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 latch194,1030.210.0000 
active service list1,7340.350.6701,4350.00
begin backup scn array250.00 00 
bq:time manger info latch500.00 00 
buffer pool10.00 00 
bufq statistics20.00 00 
business card10.00 00 
cache buffer handles160,772,4549.250.0000 
cache buffers chains4,255,056,9774.510.0121312,166,1262.13
cache buffers lru chain3,995,4580.080.00023,025,6500.27
cache table scan latch1590.00 01590.00
call allocation507,4560.880.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch6060.990.0000 
channel operations parent latch8,9590.080.0000 
checkpoint queue latch3,877,6750.010.0002,161,9060.01
client/application info4,0150.00 00 
compile environment latch2620.380.0000 
corrupted undo seg latch543,1290.020.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch7230.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch7230.00 00 
dml lock allocation7250.00 00 
done queue latch10.00 00 
dummy allocation5191.730.0000 
enqueue freelist latch10.00 02,466,5670.09
enqueue hash chains6,776,83618.270.0006298.90
enqueues2,7000.040.0000 
fifth spare latch10.00 00 
file cache latch4,0890.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.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 SGA2490.00 00 
global ctx hash table latch4630.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch1,1820.00 0187,1200.00
hash table modification latch1000.00 00 
heartbeat check10.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 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch1,2380.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock250.00 00 
ksuosstats global area1410.00 00 
ksv allocation latch7650.00 00 
ksv class latch370.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch5181.160.0000 
ktm global data4380.00 00 
kwqbsn:qsga8540.350.0000 
lgwr LWN SCN245,3041.500.0000 
list of block allocation348,4560.050.0000 
loader state object freelist5360.370.0000 
lob segment dispenser latch10.00 00 
lob segment hash table latch50.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 latch1320.00 00 
messages1,123,8810.180.0000 
mostly latch-free SCN347,11629.680.0000 
msg queue latch10.00 00 
multiblock read objects185,0020.170.0000 
name-service namespace bucket10.00 00 
ncodef allocation latch7230.00 00 
object queue header heap1,562,7460.00 01,8430.00
object queue header operation10,797,8590.030.0000 
object stats modification2,6430.490.0000 
parallel query alloc buffer5290.00 00 
parallel query stats10.00 00 
parameter list8890.220.0000 
parameter table management5,3780.870.0900 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue130,1430.050.00090,1960.08
process allocation5303.770.0002456.94
process group creation5180.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch1,5032.660.0000 
query server freelists10.00 00 
queued dump request50.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation2,000,49312.250.00076,467,7883.74
redo copy10.00 076,694,4970.03
redo writing1,247,0490.030.0000 
resmgr group change latch7290.00 00 
resmgr:active threads5190.00 00 
resmgr:actses change group2630.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list5180.190.0000 
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 objects17,982,9555.910.0000 
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache30,420,8691.280.0000 
session allocation251,9160.000.000251,4270.00
session idle bit46,655,7970.030.0000 
session queue latch10.00 00 
session state list latch1,5101.590.6700 
session switching9800.200.0000 
session timer9720.00 00 
shared pool5,073,9600.120.0000 
shared pool sim alloc1220.00 00 
shared pool simulator2,7850.00 00 
sim partition latch10.00 00 
simulator hash latch131,883,3690.040.0000 
simulator lru latch1,479,3860.290.000130,114,7972.80
sort extent pool3,6530.710.0000 
space background state object latch140.00 00 
space background task latch5,9525.610.2009940.20
state object free list20.00 00 
statistics aggregation3360.00 00 
tablespace key chain10.00 00 
temporary table state object allocation4641.080.0000 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch2920.00 00 
trace latch490.00 00 
transaction allocation18,7680.00 00 
undo global data129,762,3050.170.00024,4190.52
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,255,056,977192,043,8371,352,054191,460,141
cache buffer handles160,772,45414,873,70840714,873,303
enqueue hash chains6,776,8361,237,9612751,237,686
row cache objects17,982,9551,062,67971,062,672
sequence cache30,420,869390,371130390,244
redo allocation2,000,493245,072466244,608
undo global data129,762,305215,11756215,062
In memory undo latch28,520,933133,754114,32724,478
mostly latch-free SCN347,116103,02618103,008
simulator hash latch131,883,36959,1231159,114
session idle bit46,655,79713,7591213,748
shared pool5,073,9605,98915,988
simulator lru latch1,479,3864,22974,222
object queue header operation10,797,8593,23393,224
cache buffers lru chain3,995,4583,22573,218
messages1,123,8812,03612,035
active checkpoint queue latch194,1034091408
space background task latch5,95233468266
parameter table management5,37847443
session state list latch1,51024169
active service list1,734642

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchkticmt: child045,9651,855
In memory undo latchktiFlush: child045,90916,801
In memory undo latchktichg: child022,44224,018
In memory undo latchktiFlushMe01,228140
In memory undo latchktbgfc075189
In memory undo latchkturbk03272,673
In memory undo latchktiFlushTopTxn0156
In memory undo latchktiTxnPoolFree050
In memory undo latchktigetmypoollatch_2050
PC and Classifier lists for WLMNo latch020
active checkpoint queue latchkcbbacq: scan active checkpoints011
active service listkswslogon: session logout044
cache buffer handleskcbzgs0297275
cache buffer handleskcbzfs0110132
cache buffers chainskcbchg1: mod cr pin0403,364183,293
cache buffers chainskcbgtcr: fast path (cr pin)0314,687169,765
cache buffers chainskcbgtcr: fast path0303,174148,200
cache buffers chainskcbgtcr: kslbegin excl0108,49499,502
cache buffers chainskcbgtcr_2083,27970,140
cache buffers chainskcbgkcbcr074,363114,757
cache buffers chainskcbgcur_2070,69027,476
cache buffers chainskcbzwb053,04042,442
cache buffers chainskcbget: fast exchange037,3685,502
cache buffers chainskcbget: pin buffer025,6919,690
cache buffers chainskcbrls: fast release022,20747,168
cache buffers chainskcbrls_2017,972320,122
cache buffers chainskcb_trim_hash_chain013,39638,847
cache buffers chainskcbcge04,701142,810
cache buffers chainskcbget: fast path02,7474,569
cache buffers chainskcb_is_private02,1119,153
cache buffers chainskcbchg1: clear MS bit01,54135,015
cache buffers chainskcbgcur_401,216683
cache buffers chainskcbnlc01,1525,800
cache buffers chainskcbgcur: fast path (shr)0969811
cache buffers chainskcbget: exchange06611,722
cache buffers chainskcbesc: escalate0591238
cache buffers chainskcbget: upgrade latch0504957
cache buffers chainskcbget: release excl04591,042
cache buffers chainskcbrls_104204,940
cache buffers chainskcbchg1: mod cur pin034446,032
cache buffers chainskcb_post_apply: kcbhq6202431,501
cache buffers chainskcb_commit02355,981
cache buffers chainskcbzpbuf02196,624
cache buffers chainskcb_pre_apply: kcbhq6101657,369
cache buffers chainskcbzgb: scan from tail. nowait01380
cache buffers chainskcbgtcr: kslbegin shared012983
cache buffers chainskcbso1: set no access0821,584
cache buffers chainskcbget_105246
cache buffers chainskcbchg1: aux pin05194
cache buffers chainskcbget: release shr050349
cache buffers chainskcbnew: new latch again0453
cache buffers chainskcb_post_apply: kcbhq630201,729
cache buffers chainskcbzar_fpin_1013195
cache buffers chainskcbzib: finish processing buffer0120
cache buffers chainskcbrls011227
cache buffers chainskcbzibmlt: prewarm reads: nowait get060
cache buffers chainskcbgtcr_1052
cache buffers chainskcbzhngcbk1_1040
cache buffers chainskcbzibmlt: finish free bufs020
cache buffers chainskcbbic2011
cache buffers chainskcbget: release upgrade010
cache buffers lru chainkcbzgws040
cache buffers lru chainkcbbic2026
cache buffers lru chainkcbbxsv: move to being written010
enqueue hash chainsksqrcl024560
enqueue hash chainsksqcmi: get hash chain latch after wait018207
enqueue hash chainsksqgtl30119
enqueue hash chainsksqcmi: kslgpl010
lgwr LWN SCNkcs023020
messagesksaamb: after wakeup010
mostly latch-free SCNkcslcu301618
object queue header operationkcbo_switch_q_bg065
object queue header operationkcbo_check_flist010
object queue header operationkcbo_sw_buf010
object queue header operationkcbo_switch_mq_bg013
object queue header operationkcbo_unlink_q010
parameter table managementkspcpy040
redo allocationkcrfw_redo_gen: redo allocation 103530
redo allocationkcrfw_redo_gen: redo allocation 3064134
redo allocationkcrfw_redo_gen: redo allocation 20330
redo allocationkcrfw_post: more space010328
redo allocationkcrfw_redo_write: before write064
row cache objectskqreqd: reget072
sequence cachekdnssd01100
sequence cachekdnnxt: cached seq0111
sequence cachekdnss08129
sequence cachekdnwor010
session idle bitksupuc: set busy0104
session idle bitksupuc: clear busy0410
session state list latchkpseqd0130
session state list latchkpscad0310
shared poolkghfre011
simulator hash latchkcbsacc: lookup dba01111
simulator lru latchkcbs_simulate: simulate set060
simulator lru latchkcbs_simbufseq017
space background task latchktsj_grab_task06668
undo global dataktudba: KSLBEGIN05354
undo global dataktudnx:child020
undo global dataktusmupst: KSLBEGIN011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpnal1 90895,1180
Library Cachekglpin1 4667,2320
Library Cachekglpndl1 95657,9260
Library Cachekgllkc1 57428,6150
Library Cachekgllkdl1 85198,2180
Cursor Pinkkslce [KKSCHLPIN2]76,4020
Library Cachekglobpn1 7151,7830
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]7,8890
Cursor Pinkksfbc [KKSCHLFSP2]7,3780
Cursor PinkksLockDelete [KKSCHLPIN6]7,3570
Library Cachekglllal3 1115,5980
Cursor Pinkksfbc [KKSCHLPIN1]3,9980
Library Cachekgllldl2 1122,3360
Library Cachekglhdgn2 1061,6410
Library Cachekglget1 11,1090
hash tablekkshGetNextChild [KKSHBKLOC1]8210
Library Cachekglget2 26970
Cursor ParentkkscsPruneChild [KKSPRTLOC35]6840
hash tablekkshindel [KKSHBKLOC6]4270
hash tablekkscsSearchChildList [KKSHBKLOC2]3680
Library Cachekglhdgn1 623150
Library Cachekglllal1 1091950
Library Cachekglini1 321080
Library Cachekgllkal3 82990
Library Cachekglobld1 75870
Library Cachekglhdgc1 102620
Library CachekglUpgradeLock 119590
Library Cachekglpnal4 93590
Library Cachekgldtin1 42540
Library Cachekglnti1 46540
hash tablekkshListChanged [KKSHBKLOC9]430
Library Cachekglati1 45390
Cursor Pinkksxsccmp [KKSCHLPIN5]350
Library Cachekglrdtin1 44230
Library Cachekglhbh1 6390
Library Cachekgllkal5 8430
Cursor ParentkxsBindCapture [KKSPRTLOC22]10

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 INDEX247,257,0248.69
HRAPPS_TS_TX_IDXPAY_PAYROLL_ACTIONS_PK INDEX176,981,0566.22
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N50 INDEX130,241,3924.58
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE121,161,2484.26
HRAPPS_TS_TX_DATAPAY_PAYROLL_ACTIONS TABLE85,684,6723.01

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE91,29817.74
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N5 INDEX22,7474.42
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N2 INDEX17,6523.43
HRAPPS_TS_TX_IDXPAY_ELEMENT_ENTRIES_F_N51 INDEX12,0072.33
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE11,5052.24

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 TABLE28,62717.62
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N5 INDEX7,5454.64
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N2 INDEX5,8303.59
HRAPPS_TS_TX_IDXPAY_ELEMENT_ENTRIES_F_N51 INDEX4,1952.58
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE3,3842.08

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE28,62717.62
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N5 INDEX7,5454.64
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N2 INDEX5,8303.59
HRAPPS_TS_TX_IDXPAY_ELEMENT_ENTRIES_F_N51 INDEX4,1952.58
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE3,3842.08

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 TABLE96,2345.11
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N5 INDEX47,0342.50
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N2 INDEX31,6371.68
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS_TN53 INDEX29,8981.59
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE26,5181.41

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 TABLE13,2356.92
HRAPPS_TS_TX_IDXPAY_RUN_BALANCES_N1 INDEX4,3832.29
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N5 INDEX3,7851.98
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N2 INDEX3,2791.71
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE2,9151.52

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_336435505_147TABLE PARTITION14090.91

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 TABLE224,885,24849.82
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N2 INDEX53,348,94411.82
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX43,140,6889.56
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE40,574,3208.99
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX12,057,1042.67

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 INDEX270,36424.47
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS_TPK INDEX152,89913.84
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX123,91111.22
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX95,7458.67
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N50 INDEX64,6925.86

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HRAPPS_TS_TX_IDXPAY_RUN_BALANCES_N1 INDEX16823.60
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS_TN53 INDEX10314.47
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N2 INDEX10214.33
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION_N5 INDEX527.30
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX527.30

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 INDEX813,12819.12
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX686,53716.14
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_PK INDEX399,2959.39
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS_TPK INDEX365,3778.59
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX239,3125.63

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control50.000 21
dc_global_oids6980.290 032
dc_histogram_data4,4994.650 0594
dc_histogram_defs25,58411.010 06,548
dc_object_grants9054.750 0121
dc_objects150,6130.860 44,026
dc_profiles2490.000 01
dc_rollback_segments9100.110 5953
dc_segments21,2674.630 1423,038
dc_sequences10,1290.080 10,12919
dc_tablespaces2,956,3470.000 055
dc_users2,817,6580.000 080
global database name1,1730.000 01
outstanding_alerts1230.810 253
sch_lj_objs1100.000 02


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS4980.000 00
APP CONTEXT8550.2311,2550.0300
BODY15,8790.5341,159,4490.0300
CLUSTER150.00150.0000
DBLINK5000.000 00
DIRECTORY9520.009520.0000
EDITION2520.005010.0000
INDEX2161.902161.9000
OBJECT ID1100.000 00
QUEUE4030.001,6530.0000
RULESET0 20.0000
SCHEMA1,3320.230 00
SQL AREA29,8346.55293,265,912-0.7575
SQL AREA BUILD1,75544.560 00
SQL AREA STATS84599.1784599.1700
TABLE/PROCEDURE17,8434.6751,360,2240.0510
TRIGGER9620.735,750,1280.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,968.0027,968.0027,968.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,240.002,240.002,240.002,240.000STA/
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
BOther145.83 1.601.9012129191
PL/SQL45.4240.970.500.35119191
Freeable42.380.000.812.2512 5252
SQL6.681.200.090.08037572
EOther158.36 1.631.8112129797
PL/SQL47.7143.150.490.38119797
Freeable42.310.001.843.1812 2323
SQL5.061.040.060.06038176

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers29,326,573,568 
Fixed Size2,237,328 
Redo Buffers122,380,288 
Variable Size2,617,248,880 

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 buffers96.0096.000.00
sharedCheckpoint queue24.0224.020.00
sharedKGLH030.1748.0759.33
sharedKGLS 25.52 
sharedSQLA26.0247.9184.11
shareddb_block_hash_buckets178.00178.000.00
shareddbwriter coalesce buffer24.0224.020.00
shareddirty object counts array24.0024.000.00
sharedfree memory1,583.881,514.89-4.36
sharedprivate strands28.5728.570.00
streamsfree memory127.36127.360.00
 buffer_cache27,968.0027,968.000.00
 fixed_sga2.132.130.00
 log_buffer116.71116.710.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0226 10:15:400.020.000.00
QMON Coordinator0226 10:15:300.010.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(423242) 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

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
APPLSYS.FND_CP_GSM_IPC_AQ(423198) 00  0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(423447) 220100.000.000.010.000.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
APPLSYS.FND_CP_GSM_IPC_AQ(423198) 0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(423447) 0.020.000.00 

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
FNDCPGSMIPC_CARTRIDGE_1597896(386)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_SERVICE_1597896(387)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
OPP1597896(1010)/APPLSYS.FND_CP_GSM_OPP_AQ 000   

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

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_publicFALSE  
aq_tm_processes1  
audit_sys_operationsFALSE  
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/app/oracle/VIS/db/tech_st/11.2.0/admin/VIS_rwsp7lp01  
dml_locks10000  
job_queue_processes2  
lock_sgaTRUE  
log_buffer63012864  
log_checkpoint_timeout0  
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_servers12  
parallel_min_servers0  
parallel_threads_per_cpu2  
pga_aggregate_target10737418240  
plsql_code_typeINTERPRETED  
processes600  
query_rewrite_enabledtrue  
sec_case_sensitive_logonFALSE  
session_cached_cursors1000  
sessions1296  
sga_target32212254720  
shared_pool_reserved_size419430400  
shared_pool_size2348810240  
timed_statisticsTRUE  
trace_enabledFALSE  
transactions2200  
undo_managementAUTO  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /app/oracle/VIS/db/tech_st/11.2.0/appsutil/outbound/VIS_app0, /usr/tmp  
workarea_size_policyAUTO  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/oasb_data/cntrl01.dbf  
/oasb_data/cntrl02.dbf  
/oasb_data/cntrl03.dbf  
utl_file_dir/app/oracle/VIS/db/tech_st/11.2.0/appsutil/outbound/VIS_app0  
/usr/tmp  
/usr/tmp  
/usr/tmp  
/usr/tmp  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report