WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS300141512VIS120-Sep-11 16:0911.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
app0AIX-Based Systems (64-bit) 48 24  47.25

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6020-Sep-11 17:50:0178 10.7
End Snap:6120-Sep-11 18:20:1378 10.7
Elapsed:  30.19 (mins)  
DB Time:  779.64 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 28,736M 28,736MStd Block Size: 8K
Shared Pool Size: 2,304M 2,304MLog Buffer: 115,724K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 25.8 0.2 0.00 0.00
DB CPU(s): 6.6 0.1 0.00 0.00
Redo size: 11,805,464.4 90,107.1  
Logical reads: 1,630,392.2 12,444.2  
Block changes: 77,737.7 593.4  
Physical reads: 62.3 0.5  
Physical writes: 840.7 6.4  
User calls: 12,812.0 97.8  
Parses: 25,419.9 194.0  
Hard parses: 0.1 0.0  
W/A MB processed: 14.9 0.1  
Logons: 0.1 0.0  
Executes: 127,498.3 973.2  
Rollbacks: 0.0 0.0  
Transactions: 131.0   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.86Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 101.12Soft Parse %: 100.00
Execute to Parse %: 80.06Latch Hit %: 95.48
Parse CPU to Parse Elapsd %: 18.12% Non-Parse CPU: 98.87

Shared Pool Statistics

BeginEnd
Memory Usage %: 30.60 31.13
% SQL with executions>1: 89.97 86.77
% Memory for SQL w/exec>1: 88.43 82.86

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 12,025 25.71 
enq: UL - contention38,578743191.59Application
buffer busy waits3,961,38057801.24Concurrency
enq: TX - index contention609,53036110.77Concurrency
latch: cache buffers chains2,208,17824600.53Concurrency

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

Load Average BeginLoad Average End%User%System%WIO%Idle
0.00 10.21 52.1 3.5 0.4 44.4
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
13.9 24.9 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 48,384.0 48,384.0
SGA use (MB): 31,552.0 31,552.0
PGA use (MB): 246.5 247.5
% Host Mem used for SGA+PGA: 65.72 65.72

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time45,763.2797.83
PL/SQL execution elapsed time16,760.3335.83
DB CPU12,025.1925.71
parse time elapsed880.491.88
repeated bind elapsed time23.390.05
sequence load elapsed time14.170.03
inbound PL/SQL rpc elapsed time11.800.03
hard parse elapsed time1.640.00
connection management call elapsed time1.180.00
hard parse (sharing criteria) elapsed time0.160.00
PL/SQL compilation elapsed time0.150.00
hard parse (bind mismatch) elapsed time0.000.00
DB time46,778.61 
background elapsed time325.32 
background cpu time26.90 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
NUM_LCPUS0 
NUM_VCPUS0 
AVG_BUSY_TIME100,728 
AVG_IDLE_TIME80,307 
AVG_IOWAIT_TIME614 
AVG_SYS_TIME6,258 
AVG_USER_TIME94,409 
BUSY_TIME4,837,680 
IDLE_TIME3,857,676 
IOWAIT_TIME31,710 
SYS_TIME303,069 
USER_TIME4,534,611 
LOAD010
OS_CPU_WAIT_TIME4,540,000 
PHYSICAL_MEMORY_BYTES50,734,301,184 
NUM_CPUS48 
NUM_CPU_CORES24 
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
20-Sep 17:50:010.00     
20-Sep 18:20:1310.2155.6452.153.4944.360.36

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  12,025 25.71
Concurrency6,929,12201,22902.63
Application44,4670749171.60
Commit80,703010910.23
User I/O130,73206710.14
Network21,783,87701900.04
Configuration34,94901400.03
Other1,684,774101800.02
System I/O1,5270000.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
enq: UL - contention38,5780743190.161.59
buffer busy waits3,961,3800578016.691.24
enq: TX - index contention609,530036112.570.77
latch: cache buffers chains2,208,178024609.300.53
log file sync80,703010910.340.23
db file sequential read107,66305410.450.12
latch: In memory undo latch120,91302500.510.05
SQL*Net message to client21,782,775019091.780.04
cursor: pin S wait on X527014270.000.03
read by other session4,18101020.020.02
enq: SQ - contention29,4000900.120.02
enq: TX - row lock contention4,5150610.020.01
enq: HW - contention5,4710410.020.01
library cache load lock5200480.000.01
asynch descriptor resize1,225,120101305.160.01
buffer deadlock456,828100201.920.00
Disk file operations I/O16,4210200.070.00
kksfbc child completion48772390.000.00
db file scattered read1690130.000.00
library cache: mutex X22,6720100.100.00
enq: TX - contention4920110.000.00
cursor: pin S4,6800000.020.00
undo segment extension19950150.000.00
wait list latch free270090.000.00
control file sequential read1,5270000.010.00
library cache lock530020.000.00
latch: cache buffer handles1,2930000.010.00
utl_file I/O2,2600000.010.00
SQL*Net break/reset to client1,3740000.010.00
cursor: mutex S635100000.000.00
enq: FB - contention890000.000.00
latch: enqueue hash chains6420000.000.00
latch free1150000.000.00
SQL*Net more data to client1,1000000.000.00
enq: TX - allocate ITL entry590000.000.00
direct path write380000.000.00
enq: DV - contention620000.000.00
latch: row cache objects340000.000.00
latch: redo allocation300000.000.00
SQL*Net message from client21,782,775096,290491.78 
PL/SQL lock timer5961001,78930020.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write267,790013401.1341.15
db file parallel write130,40307810.5523.88
os thread startup80911060.002.72
control file sequential read2,1510210.010.55
control file parallel write8790110.000.32
reliable message7500110.000.20
rdbms ipc reply7500000.000.09
LGWR wait for redo copy21,5220000.090.09
db file scattered read630040.000.07
ADR block file read130070.000.03
db file sequential read280020.000.02
Disk file operations I/O9980000.000.02
ADR block file write50030.000.01
latch: redo allocation500000.000.00
rdbms ipc message253,610428,6451131.07 
Streams AQ: qmn slave idle wait93405,43958230.00 
DIAG idle wait3,6101003,61310010.02 
smon timer14361,8201300070.00 
Streams AQ: qmn coordinator idle wait647401,81328020.00 
Space Manager: slave idle wait363991,81049870.00 
pmon timer933641,80919390.00 
SQL*Net message from client9130110.00 
class slave wait80020.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read1353.8 23.17.77.7 7.7 
ADR block file write5  100.0     
ADR file lock6100.0       
Disk file operations I/O17.4K100.0       
LGWR wait for redo copy21.5K100.0.0.0     
SQL*Net break/reset to client137399.9 .1     
SQL*Net message to client21.6M100.0       
SQL*Net more data from client2100.0       
SQL*Net more data to client1099100.0       
asynch descriptor resize1212K100.0       
buffer busy waits3960.5K96.42.6.9.0.0.0.0 
buffer deadlock456.9K100.0.0.0.0    
control file parallel write87979.28.35.65.01.3.7  
control file sequential read367490.13.53.02.8.5.1  
cursor: mutex S62899.5.5      
cursor: pin S468099.1.4.4   .0 
cursor: pin S wait on X527    48.827.124.1 
db file parallel write130.4K97.02.4.3.2.0.0.0 
db file scattered read23241.41.711.637.18.2   
db file sequential read107.1K95.6.51.32.3.2.0.0 
direct path write38100.0       
enq: DV - contention62100.0       
enq: FB - contention89100.0       
enq: HW - contention547158.737.13.8.4    
enq: SQ - contention29.4K99.5.3.1.1  .0 
enq: TX - allocate ITL entry5996.63.4      
enq: TX - contention50630.667.81.6     
enq: TX - index contention609.5K82.212.55.2.1.0.0.0 
enq: TX - row lock contention451583.13.11.810.6.7.2.5 
enq: UL - contention38.6K15.98.18.610.414.921.021.0.1
kksfbc child completion4822.9     77.1 
latch free11898.3 1.7     
latch: In memory undo latch120.9K99.7.3.0.0.0   
latch: cache buffer handles129099.8.1 .1    
latch: cache buffers chains2207.2K99.9.1.0.0.0.0.0 
latch: cache buffers lru chain3100.0       
latch: enqueue hash chains642100.0       
latch: redo allocation80100.0       
latch: row cache objects34100.0       
latch: undo global data27100.0       
library cache load lock52046.51.56.515.61.028.8  
library cache lock5386.8 9.4   3.8 
library cache: mutex X22.7K99.7.1.1.1.0   
log file parallel write267.8K92.33.62.61.4.1.0.0 
log file sync80.7K73.111.47.96.21.0.2.2 
os thread startup8      37.562.5
rdbms ipc reply75190.34.84.8.1    
read by other session417948.96.615.628.1.5.1.1 
reliable message75088.02.44.45.2    
undo segment extension1936.8   21.121.121.1 
utl_file I/O2259100.0       
wait list latch free27    100.0   
DIAG idle wait3612      100.0 
PL/SQL lock timer596       100.0
SQL*Net message from client21.7M99.3.2.2.1.0.0.2.0
Space Manager: slave idle wait363       100.0
Streams AQ: qmn coordinator idle wait64450.02.02.22.81.6.8.240.5
Streams AQ: qmn slave idle wait92215.8      84.2
class slave wait862.512.5 25.0    
pmon timer933.4.3 .11.21.529.467.1
rdbms ipc message253.6K66.310.55.35.03.92.03.73.2
smon timer14       100.0

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
ADR block file read192.37.7      
buffer busy waits24100.0.0.0.0 .0  
cursor: pin S2100.0.0      
cursor: pin S wait on X12775.919.74.4     
db file parallel write13100.0.0      
db file sequential read16100.0.0 .0    
enq: SQ - contention5100.0.0      
enq: TX - index contention11100.0.0.0.0    
enq: TX - row lock contention2399.5.5.0     
enq: UL - contention811078.920.6.5.0 .0.0.0
kksfbc child completion3722.977.1      
latch: cache buffers chains2100.0.0      
library cache lock296.23.8      
log file parallel write23100.0.0.0.0    
log file sync15799.8.1.1.0    
os thread startup8     37.562.5 
read by other session599.9.1      
undo segment extension478.921.1      

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 - contention19100.0.0.0     

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)
SYS$USERS46,77912,0251102,953,520
SYS$BACKGROUND00318
VIS0000

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
SYS$USERS 1307556769291221229002178387919
SYS$BACKGROUND 108902990000

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
35,502.41248,6190.1475.8924.360.084f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
35,490.65248,3970.1475.8724.440.085sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,967.983,711,0070.004.2126.540.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,647.342,712,9970.003.5227.500.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,620.143,724,2580.003.4628.190.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,540.081,490,1620.003.2929.830.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
1,475.37247,8350.013.1516.950.054ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
1,205.221488.142.5823.930.21dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1,098.0328,192,2980.002.3523.130.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
998.181,113,0690.002.1331.320.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
958.663,373,2190.002.0544.230.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
756.7410,629,1270.001.6229.130.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
598.19249,6280.001.286.291.987d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
571.4713,340,8470.001.2223.330.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
565.07243,5230.001.213.940.5147g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
557.74248,3290.001.196.850.0036z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
533.744,224,7580.001.1423.390.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
518.05245,1430.001.114.300.009jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
478.34997,0270.001.024.500.00f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...

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
8,673.42248,3970.0372.1335,490.6524.440.085sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
8,648.39248,6190.0371.9235,502.4124.360.084f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
522.293,711,0070.004.341,967.9826.540.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
459.381,490,1620.003.821,540.0829.830.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
456.773,724,2580.003.801,620.1428.190.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
453.082,712,9970.003.771,647.3427.500.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
423.973,373,2190.003.53958.6644.230.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
312.641,113,0690.002.60998.1831.320.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
288.361481.952.401,205.2223.930.21dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
253.9828,192,2980.002.111,098.0323.130.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
250.05247,8350.002.081,475.3716.950.054ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
220.4410,629,1270.001.83756.7429.130.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
133.3313,340,8470.001.11571.4723.330.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
124.824,224,7580.001.04533.7423.390.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...

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
29.89248,6190.0044.3635,502.4124.360.084f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
29.75248,3970.0044.1435,490.6524.440.085sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
25.32246,5760.0037.5756.3489.2644.947dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PAI...
11.84249,6280.0017.57598.196.291.987d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
3.48497,4570.005.17169.401.432.05fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...
2.90243,5230.004.31565.073.940.5147g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
2.561480.023.791,205.2223.930.21dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
2.36249,4850.003.51270.902.180.87g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
2.16999,9680.003.20151.7551.181.42bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
0.80247,8350.001.191,475.3716.950.054ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...

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
2,056,816,929248,3978,280.3669.6435,490.6524.440.085sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
2,044,298,435248,6198,222.6269.2235,502.4124.360.084f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
251,082,3741,490,162168.498.501,540.0829.830.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
209,186,6353,711,00756.377.081,967.9826.540.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
187,379,4552,712,99769.076.341,647.3427.500.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
163,402,8411,113,069146.805.53998.1831.320.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
155,562,8773,724,25841.775.271,620.1428.190.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
116,763,83113,340,8478.753.95571.4723.330.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
112,656,59310,629,12710.603.81756.7429.130.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
97,286,611248,329391.773.29557.746.850.0036z3h9rgkd8aa PYUSLV begin hrassact.update_action_...
95,768,403997,02796.053.24478.344.500.00f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...
94,776,565249,864379.313.21433.697.390.007vku4w123mkap PYUSLV SELECT /*+ ORDERED INDEX (ac2 ...
88,280,551148596,490.212.991,205.2223.930.21dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
84,552,00014,452,8835.852.86466.3423.440.00cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
82,661,558247,835333.532.801,475.3716.950.054ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
81,153,52228,192,2982.882.751,098.0323.130.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
75,355,805249,628301.872.55598.196.291.987d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
67,697,7054,224,75816.022.29533.7423.390.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
65,592,7043,373,21919.452.22958.6644.230.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
65,397,607249,649261.962.21321.0618.760.002dqtvtdcud8mb PYUSLV SELECT ACTION_INFORMATION_ID, ...
52,839,08413,371,2013.951.79398.8624.010.009wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
52,673,009243,523216.301.78565.073.940.5147g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
45,541,9983,091,88714.731.54371.1026.620.00bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
44,520,3976,434,1736.921.51262.4833.660.005p88n2zhuqfd9 PYUSLV SELECT PPA.EFFECTIVE_DATE, PPA...
42,765,93014,431,3772.961.45365.1223.540.0277d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
36,105,061247,089146.121.22271.0527.250.0070c0w7j9vx2nt PYUSLV SELECT /*+ ORDERED use_nl(PAA,...
34,466,333248,858138.501.17337.1320.030.137yathjvssqxz9 PYUSLV SELECT PTS.TIME_IN_STATE, PTS....
30,823,736246,559125.021.04379.653.160.002tr0101sa3jh2 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
55,773248,3970.2249.4235,490.6524.440.085sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
55,401248,6190.2249.0935,502.4124.360.084f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
54,931246,5760.2248.6856.3489.2644.947dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PAI...
28,127249,6280.1124.92598.196.291.987d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
4,586249,4850.024.06270.902.180.87g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
3,476243,5230.013.08565.073.940.5147g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
2,443497,4570.002.16169.401.432.05fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...
1,4001489.461.241,205.2223.930.21dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1,295999,9680.001.15151.7551.181.42bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
700247,8350.000.621,475.3716.950.054ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...

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
55,77555,775248,6190.220.0051.904f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
55,60855,608248,3970.220.0051.745sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
54,91954,919246,5760.220.0051.107dm9q8dwzhxnp PYUSLV SELECT PAI.EFFECTIVE_DATE, PAI...
28,13928,139249,6280.110.0026.187d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
4,5874,587249,4850.020.004.27g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
3,4813,481243,5230.010.003.2447g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
2,4442,444497,4570.000.002.27fbpf0hy40v80s PYUSLV select /*+ ORDERED USE_NL(AA P...
1,4001,4001489.460.001.30dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1,2951,295999,9680.000.001.20bkzygbymgqf34 PYUSLV INSERT INTO PAY_ASSIGNMENT_ACT...
700700247,8350.000.000.654ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...

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,192,29842,804,1901.521,098.0323.130.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
14,452,88314,336,8470.99466.3423.440.00cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
14,431,37714,379,3931.00365.1223.540.0277d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
13,371,20113,305,4531.00398.8624.010.009wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
13,340,84713,107,4020.98571.4723.330.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
10,629,12710,395,1800.98756.7429.130.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
6,434,1736,396,6970.99262.4833.660.005p88n2zhuqfd9 PYUSLV SELECT PPA.EFFECTIVE_DATE, PPA...
4,224,75800.00533.7423.390.006500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
3,724,2583,681,2020.991,620.1428.190.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,711,0073,675,9160.991,967.9826.540.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,373,2193,371,3581.00958.6644.230.036v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
3,091,88700.00371.1026.620.00bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
2,712,9972,667,8890.981,647.3427.500.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
27,178,34128,192,29859.024gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
3,727,7753,711,0078.10g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,723,5913,724,2588.097rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
2,717,4672,712,9975.90dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,482,8011,490,1623.2201pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
1,110,5301,113,0692.418v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
742,823744,2061.61fqgs7vbu8htby PYUSLV SELECT fnd_number.number_to_ca...
494,883482,0661.0783kbt99vg4svq PYUSLV begin hr_nonrun_asact.reinter...
492,438492,1621.07165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val...
491,692493,4261.073n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01pkua627ktjk SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y')
02k10jzw8c495SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
165d2bgc2b9hrSELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment within a Government Reporting Entity for YTD based on run balances */ pay_run_balances prb, pay_defined_balances pdb, pay_payroll_actions ppa, pay_assignment_actions paa where paa.assignment_action_id = :ASSIGNMENT_ACTION_ID and prb.tax_unit_id = :TAX_UNIT_ID and ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id and paa.assignment_id = prb.assignment_id and prb.action_sequence <= paa.action_sequence and prb.effective_date >= trunc(ppa.effective_date, 'Y')
2dqtvtdcud8mbSELECT ACTION_INFORMATION_ID, EFFECTIVE_DATE, OBJECT_VERSION_NUMBER FROM PAY_ACTION_INFORMATION WHERE ACTION_CONTEXT_ID = :B2 AND ACTION_CONTEXT_TYPE = 'AAP' AND ASSIGNMENT_ID = :B1 AND ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS'
2tr0101sa3jh2BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T5, :I5, :T4, :I4, :T6, :I6, :N5, :T8, :I8, :N4, :N3, :T3, :I3, :T7, :I7, :FFERLN, :FFERCD, :FFERMT); END;
36z3h9rgkd8aa begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3n5uwzsh3y8gr SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S ', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2
47g6xx472xzudBEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I13, :D2, :I8, :T3, :I3, :T8, :I15, :N6, :I11, :T7, :I14, :N4, :I9, :D1, :N12, :I19, :N10, :I17, :N7, :I12, :N11, :I18, :T6, :I6, :N1, :T2, :I2, :N5, :I10, :N9, :I16, :FFERLN, :FFERCD, :FFERMT); END;
4ds53shhfcynndeclare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3udeclare begin pay_archive.process_employee(:asg_action); end;
4gz4b2bh1fs14SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
5p88n2zhuqfd9SELECT PPA.EFFECTIVE_DATE, PPA.BUSINESS_GROUP_ID, PPA.PAYROLL_ID, PPA.ACTION_TYPE FROM PAY_PAYROLL_ACTIONS PPA, PAY_ASSIGNMENT_ACTIONS PAA WHERE PAA.ASSIGNMENT_ACTION_ID = :B1 AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
5sfm6rppc4y8xBEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
6500rnmy4f88wSELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE
6v07302134wyfINSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
70c0w7j9vx2nt SELECT /*+ ORDERED use_nl(PAA, PPA, PPF) */ DISTINCT PEC.CLASSIFICATION_NAME, PET.PROCESSING_PRIORITY, DECODE(PEC.CLASSIFICATION_NAME, 'Tax Deductions', NVL(PETL.REPORTING_NAME, PETL.ELEMENT_NAME) || ' Withheld', NVL(PETL.REPORTING_NAME, PETL.ELEMENT_NAME)) REPORTING_NAME, DECODE(PEC.CLASSIFICATION_NAME, 'Tax Deductions', NULL, PRR.ELEMENT_TYPE_ID) ELEMENT_TYPE_ID, NVL(DECODE(PEC.CLASSIFICATION_NAME, 'Tax Deductions', PRR.JURISDICTION_CODE), '00-000-0000'), PET.ELEMENT_INFORMATION10, PET.ELEMENT_INFORMATION12 FROM PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA, PAY_PAYROLLS_F PPF, PAY_RUN_RESULTS PRR, PAY_ELEMENT_TYPES_F PET , PAY_ELEMENT_CLASSIFICATIONS PEC, PAY_ELEMENT_TYPES_F_TL PETL WHERE PPA.ACTION_TYPE IN ('R', 'Q', 'B') AND PPA.EFFECTIVE_DATE > :B4 AND PPA.EFFECTIVE_DATE <= :B3 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 PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PAA.ASSIGNMENT_ID = :B2 AND PAA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_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 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', 'Tax Deductions' ) 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 1, 3, 4
77d28bpwm9svgSELECT PBV.RUN_BALANCE_STATUS, PBV.BALANCE_LOAD_DATE FROM PAY_BALANCE_VALIDATION PBV WHERE PBV.DEFINED_BALANCE_ID = :B2 AND PBV.BUSINESS_GROUP_ID = :B1
7d66dw0vz7yaabegin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7dm9q8dwzhxnpSELECT PAI.EFFECTIVE_DATE, PAI.ACTION_CONTEXT_ID FROM PAY_ACTION_INFORMATION PAI WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAI.ASSIGNMENT_ID = :B4 AND PAI.ACTION_INFORMATION_CATEGORY = :B3 AND PAI.ACTION_CONTEXT_ID <> :B2 AND PAI.EFFECTIVE_DATE <= :B1 ORDER BY PAI.EFFECTIVE_DATE DESC , PAI.ACTION_CONTEXT_ID DESC
7rks7t2gukcwn SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decod e(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') /* Within Jurisdiction */ and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
7vku4w123mkap SELECT /*+ ORDERED INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N51) (pa2 PAY_PAYROLL_ACTIONS_PK) */ AC2.ROWID, AC2.ASSIGNMENT_ACTION_ID, AC2.SOURCE_ACTION_ID, AC2.OBJECT_TYPE FROM PAY_PAYROLL_ACTIONS PAC, PER_ALL_ASSIGNMENTS_F ASG, PER_ALL_ASSIGNMENTS_F AS2, PAY_ASSIGNMENT_ACTIONS ACT, PAY_ASSIGNMENT_ACTIONS AC2, PAY_PAYROLL_ACTIONS PA2, PAY_ACTION_CLASSIFICATIONS ACL WHERE PAC.PAYROLL_ACTION_ID = :B4 AND ACT.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID AND ACT.ASSIGNMENT_ID = :B3 AND ACT.SOURCE_ACTION_ID IS NULL AND ASG.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PAC.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE AND AS2.PERSON_ID = ASG.PERSON_ID AND DECODE(:B2 , 'G', PAC.EFFECTIVE_DATE, AS2.EFFECTIVE_END_DATE) >= PAC.EFFECTIVE_DATE AND AC2.ASSIGNMENT_ID = AS2.ASSIGNMENT_ID AND PA2.PAYROLL_ACTION_ID = AC2.PAYROLL_ACTION_ID AND AS2.EFFECTIVE_START_DATE = (SELECT MAX(PAF3.EFFECTIVE_START_DATE) FROM PER_ALL_ASSIGNMENTS_F PAF3 WHERE PAF3.ASSIGNMENT_ID = AC2.ASSIGNMENT_ID ) AND ACL.CLASSIFICATION_NAME = 'SEQUENCED' AND PA2.ACTION_TYPE = ACL.ACTION_TYPE AND AC2.ACTION_SEQUENCE > :B1 AND (AC2.SOURCE_ACTION_ID IS NULL OR (AC2.OBJECT_ID IS NOT NULL AND AC2.OBJECT_TYPE = 'POG') ) ORDER BY PA2.EFFECTIVE_DATE, AC2.ACTION_SEQUENCE FOR UPDATE OF AC2.ASSIGNMENT_ACTION_ID
7yathjvssqxz9SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, DECODE(PST.SIT_EXEMPT, 'Y', 'Exempt', PTS.MEANING), PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS, PAY_US_EMP_STATE_TAX_RULES_F PST WHERE PTS.ASSIGNMENT_ID = :B2 AND PTS.JURISDICTION_CODE LIKE :B1 AND PST.ASSIGNMENT_ID = PTS.ASSIGNMENT_ID
83kbt99vg4svq begin hr_nonrun_asact.reinterlock (:assactid, :pactype); end;
8v2cvg5zhw9ua SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
9jv68n0ctas75begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
9wupzu1crbdbbSELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1
bkzygbymgqf34INSERT INTO PAY_ASSIGNMENT_ACTIONS ( ASSIGNMENT_ACTION_ID, ASSIGNMENT_ID, PAYROLL_ACTION_ID, ACTION_STATUS, CHUNK_NUMBER, ACTION_SEQUENCE, PRE_PAYMENT_ID, OBJECT_VERSION_NUMBER, TAX_UNIT_ID, SOURCE_ACTION_ID, OBJECT_ID, OBJECT_TYPE, START_DATE, END_DATE) SELECT :B12 , :B11 , :B10 , :B9 , :B8 , PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL, :B7 , 1, :B6 , :B5 , :B4 , :B3 , :B2 , :B1 FROM DUAL
bm8gwn43tn8hd SELECT PLB.LATEST_BALANCE_ID, PLB.ASSIGNMENT_ACTION_ID, PLB.VALUE, PLB.EXPIRY_DATE, ACT.ACTION_SEQUENCE CURRENT_ACTION_SEQ, OWN_ACT.ACTION_SEQUENCE OWNER_ACTION_SEQ, PACT.EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE, PLB.EXPIRED_ASSIGNMENT_ACTION_ID, PLB.EXPIRED_VALUE, PLB.EXPIRED_DATE, PLB.PREV_ASSIGNMENT_ACTION_ID, PLB.PREV_BALANCE_VALUE, PLB.PREV_EXPIRY_DATE, PLB.TAX_UNIT_ID, PLB.JURISDICTION_CODE, PLB.ORIGINAL_ENTRY_ID, PLB.SOURCE_ID, PLB.SOURCE_TEXT, PLB.SOURCE_TEXT2, PLB.SOURCE_NUMBER, PLB.TAX_GROUP, PLB.PAYROLL_ID, PLB.LOCAL_UNIT_ID, PLB.ORGANIZATION_ID, PLB.SOURCE_NUMBER2 FROM PAY_LATEST_BALANCES PLB , PER_ALL_ASSIGNMENTS_F ASSIGN , PAY_ASSIGNMENT_ACTIONS ACT , PAY_PAYROLL_ACTIONS PACT , PAY_ASSIGNMENT_ACTIONS OWN_ACT WHERE PLB.DEFINED_BALANCE_ID = :B15 AND ACT.ASSIGNMENT_ACTION_ID = :B14 AND ASSIGN.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND EXISTS (SELECT '' FROM PAY_OBJECT_GROUPS POG WHERE POG.SOURCE_ID (+) = ACT.ASSIGNMENT_ID AND POG.SOURCE_TYPE (+) = 'PAF' AND NVL(PLB.PROCESS_GROUP_ID, NVL(POG.PARENT_OBJECT_GROUP_ID, -1)) = NVL(POG.PARENT_OBJECT_GROUP_ID, -1) ) AND PLB.PERSON_ID = ASSIGN.PERSON_ID AND NVL(PLB.ASSIGNMENT_ID, ACT.ASSIGNMENT_ID) = ACT.ASSIGNMENT_ID AND PACT.PAYROLL_ACTION_ID = ACT.PAYROLL_ACTION_ID AND PACT.EFFECTIVE_DATE BETWEEN ASSIGN.EFFECTIVE_START_DATE AND ASSIGN.EFFECTIVE_END_DATE AND OWN_ACT.ASSIGNMENT_ACTION_ID = PLB.ASSIGNMENT_ACTION_ID AND NVL(PLB.TAX_UNIT_ID, NVL(:B13 , -1)) = NVL(:B13 , -1) AND NVL(SUBSTR(NVL(PLB.JUR ISDICTION_CODE, NVL(:B12 , -1)), 1, :B11 ), -1) = NVL( SUBSTR(NVL(:B12 , -1), 1, :B11 ), -1) AND NVL(PLB.ORIGINAL_ENTRY_ID, NVL(:B10 , -1)) = NVL(:B10 , -1) AND NVL(PLB.SOURCE_ID, NVL(:B9 , -1)) = NVL(:B9 , -1) AND NVL(PLB.SOURCE_TEXT, NVL(:B8 , -1)) = NVL(:B8 , -1) AND NVL(PLB.SOURCE_TEXT2, NVL(:B7 , -1)) = NVL(:B7 , -1) AND NVL(PLB.SOURCE_NUMBER, NVL(:B6 , -1)) = NVL(:B6 , -1) AND NVL(PLB.TAX_GROUP, NVL(:B5 , -1)) = NVL(:B5 , -1) AND NVL(PLB.PAYROLL_ID, NVL(:B4 , -1)) = NVL(:B4 , -1) AND NVL(PLB.LOCAL_UNIT_ID, NVL(:B3 , -1)) = NVL(:B3 , -1) AND NVL(PLB.ORGANIZATION_ID, NVL(:B2 , -1)) = NVL(:B2 , -1) AND NVL(PLB.SOURCE_NUMBER2, NVL(:B1 , -1)) = NVL(:B1 , -1) ORDER BY PLB.LATEST_BALANCE_ID
cn5un9cxnah8wSELECT NVL(PBD.PERIOD_TYPE, 'NULL'), PBD.START_DATE_CODE FROM PAY_BALANCE_DIMENSIONS PBD, PAY_DEFINED_BALANCES PDB WHERE PDB.DEFINED_BALANCE_ID = :B1 AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
dab1prc9qyv3v begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end;
dz7tyjxnar7gt SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT. action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and R R.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and exists (select null from pay_taxability_rules TR , pay_element_types_f ET , pay_balance_types BT where ET.element_type_id = RR.element_type_id and PACT.date_earned between ET.effective_start_date and ET.effective_end_date and BT.balance_type_id = :U1 and TR.classification_id = ET.classification_id + 0 and TR.tax_category = ET.element_information1 and TR.tax_type = BT.tax_type and TR.jurisdiction_code = '00-000-0000' and nvl(TR.status, 'VALID') <> 'D' )
f78ff26qcfjanupdate PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S')
fbpf0hy40v80s select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , decode(RR.source_type, 'E', nvl(EE.creator_type, 'X'), 'I', decode(EE.creator_type, null , 'X', 'N')) , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_cost_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned))), 'YYYY/MM/DD') , EL2.transfer_to_gl_flag , decode(:b3, null , null , hr_cost.get_context_value(:b3, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b5, null , null , hr_cost.get_context_value(:b5, RR.run_result _id, RR.element_type_id, PA.date_earned)) , decode(:b7, null , null , hr_cost.get_context_value(:b7, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b9, null , null , hr_cost.get_context_value(:b9, RR.run_result_id, RR.element_type_id, PA.date_earned)) from pay_assignment_actions AA , pay_payroll_actions PA , per_all_assignments_f PERA , pay_run_results RR , pay_element_entries_f EE , pay_element_types_f ET , pay_element_classifications EC , fnd_currencies FC , pay_input_values_f IV , pay_run_result_values RRV , pay_link_input_values_f LIV , pay_element_links_f EL , pay_element_links_f EL2 where (((((((((((((((((((((((((((((((AA.assignment_action_id=:b11 and AA.payroll_action_id=PA.payroll_action_id) and RR.assignment_action_id=:b11) and RR.status like 'P%') and RR.element_type_id=ET.element_type_id) and RRV.run_result_id=RR.run_result_id) and IV.input_value_id=RRV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between IV.effective_start_date and IV.effective_end_date) and IV.element_type_id=ET.element_type_id) and RRV.result_value is not null ) and (decode(:b13, 'Y', 1, fnd_number.canonical_to_number(RRV.result_value))+decode(LIV.DEFAULT_VALUE, 'M', 0, 0))<>0) and RRV.input_value_id=LIV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between LIV.effective_start_d ate and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_id=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_type<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E ') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) and (:b19=0 or (:b19 <>0 and exists (select null from pay_ele_classification_rules ECR where ((ECR.element_set_id=:b19 and ET.classification_id=ECR.classification_id) and not exists (select null from pay_element_type_rules ETR where ((ETR.element_set_id=:b19 and ETR.element_type_id=ET.element_type_id) and ETR.include_or_exclude='E'))) union select null from pay_element_type_rules ETR where ((ETR.element_set_id=:b19 and ETR.element_type_id=ET.element_type_id) and ETR.include_or_exclude='I'))))) order by 17, 8, 14
fqgs7vbu8htbySELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment For Run */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_payroll_actions PACT where ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA')
g2daxnc5b7rav SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.ac tion_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assig nment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date
g4jp561h1bs98 select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id , to_char(null ) , PEPD.time_definition_id , nvl(ET.time_definition_type, 'N') , to_char(decode(ET.processing_type, 'R', to_date(null , :b1), EE.date_earned), :b1) , decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ) , decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ) , EE.label_identifier , decode(ACT.action_status, 'B', decode(EE.creator_type, 'EE', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b10, :b11:b12, EE.creator_id, ACT.act ion_sequence), 'RR', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b14, :b11:b16, EE.creator_id, ACT.action_sequence), 1), 1) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'AE', to_char(EE.source_start_date, :b1), 'AD', to_char(EE.source_start_date, :b1), null ) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'AE', to_char(EE.source_end_date, :b1), 'AD', to_char(EE.source_end_date, :b1), null ) from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where (((((((((((((((ACT.assignment_action_id=:b29 and EE.assignment_id=:b30) and ((:b31='N' and to_date(:b32, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b31='Y' and EE.effective_start_date<=to_date(:b32, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , decode(nvl(ET.time_definition_type, 'N'), 'N', to_date(:b32, :b1), pay_core_utils.get_time_period_start(ACT.payroll_action_id)), pay_interpreter_pkg.prorate_start_date(:b29, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b32, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.elem ent_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b31='N' or ET.proration_group_id is null ) or (:b31='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b32, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ((((ET.processing_type='N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b32, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
grg3zu94xp62hSELECT PDB.BALANCE_TYPE_ID, PDR.ROUTE_ID, PDR.BALANCE_TYPE_COLUMN, PDR.RETRIEVAL_COLUMN, NVL(PDR.DECODE_REQUIRED, 'N'), NVL(JURISDICTION_LEVEL, 0) FROM PAY_DEFINED_BALANCES PDB, PAY_DIMENSION_ROUTES PDR, PAY_BALANCE_TYPES PBT WHERE PDB.DEFINED_BALANCE_ID = :B2 AND PDB.BALANCE_DIMENSION_ID = PDR.BALANCE_DIMENSION_ID AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID AND PDR.PRIORITY = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced101,83156.210.43
CCursor + sql area evicted00.000.00
CPU used by this session963,608531.924.06
CPU used when call started963,521531.884.06
CR blocks created10,980,5566,061.4146.26
Cached Commit SCN referenced7,061,8623,898.2429.75
Commit SCN cached255,424141.001.08
DB time4,820,3542,660.9020.31
DBWR checkpoint buffers written1,522,731840.576.42
DBWR checkpoints00.000.00
DBWR transaction table writes2850.160.00
DBWR undo block writes971,144536.084.09
HSC Heap Segment Block Changes18,119,72910,002.3376.34
Heap Segment Array Inserts2,089,2271,153.288.80
Heap Segment Array Updates107,51259.350.45
IMU CR rollbacks1,840,4541,015.967.75
IMU Flushes149,77982.680.63
IMU Redo allocation size1,338,419,792738,825.755,639.20
IMU commits88,25048.720.37
IMU contention83,37246.020.35
IMU ktichg flush2290.130.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush2,6441.460.01
IMU undo allocation size2,830,393,2561,562,415.2011,925.38
IMU- failed to get a private strand00.000.00
Number of read IOs issued00.000.00
RowCR - row contention149,82282.700.63
RowCR attempts14,770,8158,153.6962.23
RowCR hits14,613,5368,066.8761.57
SMON posted for undo segment shrink90.000.00
SQL*Net roundtrips to/from client21,782,73912,024.3791.78
active txn count during cleanout67,682,08537,361.42285.17
application wait time74,90241.350.32
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts10,2515.660.04
branch node splits5590.310.00
buffer is not pinned count1,590,882,289878,188.456,702.91
buffer is pinned count714,174,164394,233.763,009.05
bytes received via SQL*Net from client5,809,295,1213,206,809.1524,476.47
bytes sent via SQL*Net to client3,288,196,9221,815,128.9913,854.26
calls to get snapshot scn: kcmgss219,083,403120,936.99923.07
calls to kcmgas12,556,3166,931.2652.90
calls to kcmgcs20,822,43611,494.2787.73
cell physical IO interconnect bytes35,783,868,41619,753,177.34150,769.22
change write time44,81024.740.19
cleanout - number of ktugct calls12,944,8347,145.7254.54
cleanouts only - consistent read gets10,354,8995,716.0443.63
cluster key scan block gets3,7762.080.02
cluster key scans3,1821.760.01
commit batch/immediate performed46,93125.910.20
commit batch/immediate requested46,93125.910.20
commit cleanout failures: block lost4520.250.00
commit cleanout failures: callback failure278,249153.601.17
commit cleanout failures: cannot pin79,68143.980.34
commit cleanouts6,674,1083,684.2028.12
commit cleanouts successfully completed6,315,7263,486.3726.61
commit immediate performed46,93125.910.20
commit immediate requested46,93125.910.20
commit txn count during cleanout1,027,165567.014.33
concurrency wait time123,80968.340.52
consistent changes625,807,277345,454.052,636.73
consistent gets2,777,030,5801,532,958.2811,700.54
consistent gets - examination1,982,904,5411,094,590.018,354.63
consistent gets direct00.000.00
consistent gets from cache2,777,030,5801,532,958.2811,700.54
consistent gets from cache (fastpath)587,500,132324,307.992,475.33
cursor authentications2150.120.00
data blocks consistent reads - undo records applied625,255,999345,149.732,634.41
db block changes140,825,69977,737.68593.35
db block gets176,506,46497,433.95743.68
db block gets direct2430.130.00
db block gets from cache176,506,22197,433.81743.68
db block gets from cache (fastpath)40,214,18622,198.77169.44
deferred (CURRENT) block cleanout applications389,860215.211.64
dirty buffers inspected00.000.00
doubling up with imu segment00.000.00
enqueue conversions2,3791.310.01
enqueue releases2,266,1771,250.969.55
enqueue requests2,267,6001,251.759.55
enqueue timeouts1,4230.790.01
enqueue waits688,210379.902.90
exchange deadlocks457,095252.321.93
execute count230,969,488127,498.27973.15
failed probes on index block reclamation9650.530.00
file io service time00.000.00
file io wait time140,086,44177,329.60590.23
free buffer inspected2,133,6061,177.788.99
free buffer requested12,762,4397,045.0453.77
heap block compress351,893194.251.48
hot buffers moved to head of LRU510,961282.062.15
immediate (CR) block cleanout applications10,354,9745,716.0943.63
immediate (CURRENT) block cleanout applications1,200,429662.655.06
index crx upgrade (positioned)00.000.00
index fetch by key366,304,670202,205.111,543.36
index scans kdiixs1374,929,762206,966.281,579.70
leaf node 90-10 splits35,18219.420.15
leaf node splits132,37673.070.56
lob reads00.000.00
lob writes1830.100.00
lob writes unaligned1830.100.00
logons cumulative2360.130.00
max cf enq hold time230.010.00
messages received399,173220.351.68
messages sent399,173220.351.68
min active SCN optimization applied on CR28,979,97615,997.34122.10
no buffer to keep pinned count750.040.00
no work - consistent read gets716,308,112395,411.733,018.04
non-idle wait count36,748,61720,285.73154.83
non-idle wait time242,079133.631.02
opened cursors cumulative218,857,868120,812.49922.12
parse count (describe)280.020.00
parse count (failures)00.000.00
parse count (hard)2070.110.00
parse count (total)46,049,42325,419.90194.02
parse time cpu13,6307.520.06
parse time elapsed75,20441.510.32
physical read IO requests107,46959.320.45
physical read bytes924,442,624510,304.783,894.98
physical read total IO requests111,48461.540.47
physical read total bytes987,627,520545,183.694,161.20
physical read total multi block requests1370.080.00
physical reads112,84762.290.48
physical reads cache112,84762.290.48
physical reads cache prefetch5,3782.970.02
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests130,45972.020.55
physical write bytes12,476,203,0086,887,032.1052,566.35
physical write total IO requests764,025421.753.22
physical write total bytes34,796,240,89619,207,993.65146,608.02
physical write total multi block requests109,16660.260.46
physical writes1,522,974840.706.42
physical writes direct2430.130.00
physical writes direct (lob)490.030.00
physical writes from cache1,522,731840.576.42
physical writes non checkpoint981,693541.914.14
pinned buffers inspected1,1380.630.00
pinned cursors current00.000.00
prefetch warmup blocks aged out before use6,5803.630.03
prefetched blocks aged out before use00.000.00
process last non-idle time00.000.00
recursive aborts on index block reclamation130.010.00
recursive calls404,151,639223,097.151,702.82
recursive cpu usage943,670520.923.98
redo blocks checksummed by FG (exclusive)8,369,1594,619.8935.26
redo blocks written43,509,44024,017.80183.32
redo buffer allocation retries00.000.00
redo entries73,525,73840,587.20309.79
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks716,567395.553.02
redo size21,386,188,95611,805,464.3690,107.06
redo size for direct writes2,9121.610.01
redo subscn max counts1,378,322760.855.81
redo synch time10,9716.060.05
redo synch writes97,58553.870.41
redo wastage156,984,62486,657.63661.43
redo write time15,1678.370.06
redo writes267,790147.821.13
rollback changes - undo records applied200,496110.680.84
root node splits00.000.00
rows fetched via callback261,241,008144,208.561,100.69
session connect time00.000.00
session cursor cache hits6,863,1073,788.5328.92
session logical reads2,953,537,0491,630,392.2312,444.22
shared hash latch upgrades - no wait43,082,05823,781.88181.52
shared hash latch upgrades - wait3,732,8152,060.5615.73
sorts (memory)19,569,13910,802.4382.45
sorts (rows)43,762,84424,157.68184.39
sql area evicted00.000.00
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer512,865283.112.16
table fetch by rowid822,557,775454,062.973,465.71
table fetch continued row6,0913.360.03
table scan blocks gotten19,503,43810,766.1682.17
table scan rows gotten847,477,595467,819.053,570.70
table scans (short tables)8,833,1484,876.0237.22
total cf enq hold time3880.210.00
total number of cf enq holders690.040.00
total number of times SMON posted90.000.00
transaction rollbacks46,93125.910.20
undo change vector size7,628,363,3244,210,959.3032,140.81
user I/O wait time6,7313.720.03
user calls23,209,65812,812.0497.79
user commits237,342131.021.00
user rollbacks00.000.00
workarea executions - optimal13,739,2097,584.2357.89
write clones created in background10.000.00
write clones created in foreground250.010.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current835835
logons current7878
session uga memory max1,528,532,6722,547,470,896
session pga memory191,080,592190,621,840
session pga memory max243,312,784243,509,392
session cursor cache count43,50772,643
session uga memory103,979,192115,742,904

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR0M0.000M20.7G348.2811.72690 
DBWR0M0.000M11.6G71.986.566750 
Buffer Cache Reads878M59.03.4846670M0.000M107.2K0.20
Others61M2.21.03367241M1.48.02263248900.44
Direct Writes0M0.000M1M0.00.0005520 
TOTAL:939M61.24.51834032.4G421.7518.3169112.1K0.21

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Log File0M0.000M20.7G348.2811.7269  
Data File880M59.40.48577111.6G72.026.571720.203.69
Control File58M2.03.03201641M1.45.0226320.33 
TOTAL:938M61.43.51778832.4G421.7518.32130.203.69

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR 0M0.000M20.7G348.2811.72690 
LGWR (Log File) 0M0.000M20.7G348.2811.72690 
DBWR 0M0.000M11.6G71.986.566750 
DBWR (Data File) 0M0.000M11.6G71.986.566750 
Buffer Cache Reads 877M59.01.4841150M0.000M107.2K0.20
Buffer Cache Reads (Data File) 877M59.01.4841150M0.000M107.2K0.20
Others 61M2.21.03367241M1.48.02263240100.37
Others (Control File) 58M2.03.03201641M1.45.02263236730.33
Others (Data File) 3M0.19.0016560M0.030M3370.77
Direct Writes 0M0.000M1M0.00.0005520 
Direct Writes (Data File) 0M0.000M1M0.00.0005520 
TOTAL: 938M61.23.51778832.4G421.7518.3169111.2K0.21

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 70,268390.501.0321,17712489,3680.07
APPS_UNDOTS1 000.000.0075,13741499,6080.02
APPS_TS_TX_IDX 35,653200.481.0033,645193,247,1120.17
SYSAUX 1,03110.641.05401000.00
SYSTEM 51302.517.364904990.24
APPS_TS_SEED 9504.421.00101,6212.97
APPS_TS_ARCHIVE 205.001.004803570.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_ARCHIVE/oasb_data/archive1.dbf 205.001.004803570.00
APPS_TS_SEED/oasb_data/reference1.dbf 504.001.00101083.43
APPS_TS_SEED/oasb_data/reference10.dbf 701.431.00001213.97
APPS_TS_SEED/oasb_data/reference11.dbf 303.331.0000726.39
APPS_TS_SEED/oasb_data/reference12.dbf 205.001.0000419.76
APPS_TS_SEED/oasb_data/reference13.dbf 303.331.0000700.00
APPS_TS_SEED/oasb_data/reference14.dbf 1010.001.0000298.28
APPS_TS_SEED/oasb_data/reference15.dbf 1010.001.0000230.00
APPS_TS_SEED/oasb_data/reference16.dbf 100.001.0000250.00
APPS_TS_SEED/oasb_data/reference17.dbf 100.001.0000110.00
APPS_TS_SEED/oasb_data/reference18.dbf 100.001.0000260.00
APPS_TS_SEED/oasb_data/reference19.dbf 303.331.0000470.85
APPS_TS_SEED/oasb_data/reference2.dbf 1010.001.0000152.00
APPS_TS_SEED/oasb_data/reference20.dbf 402.501.0000994.65
APPS_TS_SEED/oasb_data/reference21.dbf 701.431.00001450.14
APPS_TS_SEED/oasb_data/reference22.dbf 205.001.0000455.56
APPS_TS_SEED/oasb_data/reference23.dbf 100.001.0000260.00
APPS_TS_SEED/oasb_data/reference3.dbf 100.001.0000260.00
APPS_TS_SEED/oasb_data/reference4.dbf 400.001.0000770.00
APPS_TS_SEED/oasb_data/reference6.dbf 1010.001.0000240.00
APPS_TS_SEED/oasb_data/reference8.dbf 1010.001.0000249.58
APPS_TS_SEED/oasb_data/reference9.dbf 4506.001.00005673.25
APPS_TS_TX_DATA/oasb_data/tx_data11.dbf 1,09110.531.0116401,9910.03
APPS_TS_TX_DATA/oasb_data/tx_data12.dbf 1,07710.451.0116501,9570.14
APPS_TS_TX_DATA/oasb_data/tx_data13.dbf 1,09810.451.0140807,8950.15
APPS_TS_TX_DATA/oasb_data/tx_data17.dbf 82500.441.000000.00
APPS_TS_TX_DATA/oasb_data/tx_data19.dbf 83500.431.002010.00
APPS_TS_TX_DATA/oasb_data/tx_data2.dbf 1,06410.521.0116501,5640.03
APPS_TS_TX_DATA/oasb_data/tx_data21.dbf 1,10110.531.0142507,9990.02
APPS_TS_TX_DATA/oasb_data/tx_data22.dbf 83900.381.0115105190.02
APPS_TS_TX_DATA/oasb_data/tx_data27.dbf 82700.461.000010.00
APPS_TS_TX_DATA/oasb_data/tx_data28.dbf 82200.461.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data29.dbf 53200.511.000000.00
APPS_TS_TX_DATA/oasb_data/tx_data32.dbf 2202.272.415101,5390.06
APPS_TS_TX_DATA/oasb_data/tx_data37.dbf 82500.501.000000.00
APPS_TS_TX_DATA/oasb_data/tx_data39.dbf 1,01910.501.0316201,8920.01
APPS_TS_TX_DATA/oasb_data/tx_data41.dbf 86500.451.000010.00
APPS_TS_TX_DATA/oasb_data/tx_data42.dbf 84300.371.000000.00
APPS_TS_TX_DATA/oasb_data/tx_data43.dbf 1,11310.571.0416202,1670.26
APPS_TS_TX_DATA/oasb_data/tx_data44.dbf 1,08310.581.0316501,6560.16
APPS_TS_TX_DATA/oasb_data/tx_data45.dbf 1,07110.401.0414801,8650.27
APPS_TS_TX_DATA/oasb_data/tx_data46.dbf 1,06010.511.0415401,9200.02
APPS_TS_TX_DATA/oasb_data/tx_data47.dbf 1,10510.431.0441608,6090.02
APPS_TS_TX_DATA/oasb_data/tx_data48.dbf 1,11410.601.0443308,9510.05
APPS_TS_TX_DATA/oasb_data/tx_data49.dbf 1,10710.521.0441909,1570.05
APPS_TS_TX_DATA/oasb_data/tx_data50.dbf 1,08510.491.0417506,1390.03
APPS_TS_TX_DATA/oasb_data/tx_data51.dbf 1,09710.531.0440709,9800.23
APPS_TS_TX_DATA/oasb_data/tx_data52.dbf 83700.451.001025.00
APPS_TS_TX_DATA/oasb_data/tx_data53.dbf 1,12210.501.04400010,7860.12
APPS_TS_TX_DATA/oasb_data/tx_data54.dbf 1,12710.481.0441309,2500.13
APPS_TS_TX_DATA/oasb_data/tx_data55.dbf 1,11410.511.04413010,0890.02
APPS_TS_TX_DATA/oasb_data/tx_data56.dbf 1,12110.521.04411010,6780.02
APPS_TS_TX_DATA/oasb_data/tx_data57.dbf 1,10710.481.0441109,9210.12
APPS_TS_TX_DATA/oasb_data/tx_data58.dbf 1,13810.591.04418057,7950.13
APPS_TS_TX_DATA/oasb_data/tx_data59.dbf 1,09410.591.04430011,8170.03
APPS_TS_TX_DATA/oasb_data/tx_data60.dbf 1,10210.601.04423011,4310.02
APPS_TS_TX_DATA/oasb_data/tx_data61.dbf 1,09410.381.04434011,4330.02
APPS_TS_TX_DATA/oasb_data/tx_data62.dbf 1,11610.531.04422010,6620.02
APPS_TS_TX_DATA/oasb_data/tx_data63.dbf 1,13510.561.04432011,0940.02
APPS_TS_TX_DATA/oasb_data/tx_data64.dbf 1,14010.461.04419011,2110.11
APPS_TS_TX_DATA/oasb_data/tx_data65.dbf 1,11210.581.04416011,1340.11
APPS_TS_TX_DATA/oasb_data/tx_data66.dbf 1,10810.591.0443508,2040.02
APPS_TS_TX_DATA/oasb_data/tx_data67.dbf 1,14110.441.0441908,9890.03
APPS_TS_TX_DATA/oasb_data/tx_data68.dbf 1,12410.531.0441209,1270.01
APPS_TS_TX_DATA/oasb_data/tx_data69.dbf 1,10010.461.0441209,3820.04
APPS_TS_TX_DATA/oasb_data/tx_data70.dbf 1,13310.531.0442908,2630.02
APPS_TS_TX_DATA/oasb_data/tx_data71.dbf 1,13510.431.0443807,9260.02
APPS_TS_TX_DATA/oasb_data/tx_data72.dbf 1,12910.551.0440609,1990.02
APPS_TS_TX_DATA/oasb_data/tx_data73.dbf 1,09910.601.0441908,3730.02
APPS_TS_TX_DATA/oasb_data/tx_data74.dbf 1,11410.431.0441709,5330.02
APPS_TS_TX_DATA/oasb_data/tx_data75.dbf 1,12110.561.0439909,3080.03
APPS_TS_TX_DATA/oasb_data/tx_data76.dbf 1,13010.401.0441309,9520.03
APPS_TS_TX_DATA/oasb_data/tx_data77.dbf 1,11610.571.0440108,1460.02
APPS_TS_TX_DATA/oasb_data/tx_data78.dbf 1,10110.561.0440707,4530.16
APPS_TS_TX_DATA/oasb_data/tx_data79.dbf 1,06610.461.0440807,9460.02
APPS_TS_TX_DATA/oasb_data/tx_data80.dbf 1,12210.631.0441707,5430.03
APPS_TS_TX_DATA/oasb_data/tx_data81.dbf 1,12410.481.0441907,0720.04
APPS_TS_TX_DATA/oasb_data/tx_data82.dbf 1,11510.541.0343907,6980.02
APPS_TS_TX_DATA/oasb_data/tx_data83.dbf 1,12910.431.0341407,1690.02
APPS_TS_TX_DATA/oasb_data/tx_data84.dbf 1,13510.491.0341706,7660.32
APPS_TS_TX_DATA/oasb_data/tx_data85.dbf 1,11910.541.0341807,6250.02
APPS_TS_TX_DATA/oasb_data/tx_data86.dbf 1,15410.421.0240907,1660.15
APPS_TS_TX_DATA/oasb_data/tx_data87.dbf 1,14310.491.0141508,1200.13
APPS_TS_TX_DATA/oasb_data/tx_data88.dbf 1,15410.551.0141008,0200.04
APPS_TS_TX_DATA/oasb_data/tx_data89.dbf 1,12110.391.0140907,8570.02
APPS_TS_TX_DATA/oasb_data/tx_data90.dbf 1,11310.491.0140506,9800.03
APPS_TS_TX_DATA/oasb_data/tx_data91.dbf 1,11510.481.0138907,4610.16
APPS_TS_TX_DATA/oasb_data/tx_data92.dbf 1,11510.501.0138907,2360.05
APPS_TS_TX_DATA/oasb_data/tx_data93.dbf 1,11310.481.0139607,7480.02
APPS_TS_TX_IDX/oasb_data/tx_idx1.dbf 49100.511.00516052,3380.17
APPS_TS_TX_IDX/oasb_data/tx_idx10.dbf 49700.501.00512049,6020.20
APPS_TS_TX_IDX/oasb_data/tx_idx11.dbf 51800.461.00516052,8470.22
APPS_TS_TX_IDX/oasb_data/tx_idx12.dbf 47100.491.00506047,8400.16
APPS_TS_TX_IDX/oasb_data/tx_idx13.dbf 49400.401.00521051,1630.15
APPS_TS_TX_IDX/oasb_data/tx_idx14.dbf 49000.451.007302300.09
APPS_TS_TX_IDX/oasb_data/tx_idx15.dbf 48600.491.00515050,9910.16
APPS_TS_TX_IDX/oasb_data/tx_idx16.dbf 46200.451.00511048,3410.15
APPS_TS_TX_IDX/oasb_data/tx_idx17.dbf 49100.471.00502050,5390.18
APPS_TS_TX_IDX/oasb_data/tx_idx18.dbf 49600.521.00516050,2150.15
APPS_TS_TX_IDX/oasb_data/tx_idx19.dbf 48500.391.00512052,3860.16
APPS_TS_TX_IDX/oasb_data/tx_idx2.dbf 46000.461.00489048,2700.17
APPS_TS_TX_IDX/oasb_data/tx_idx20.dbf 46800.411.00511049,9530.15
APPS_TS_TX_IDX/oasb_data/tx_idx21.dbf 45800.461.00518053,0440.17
APPS_TS_TX_IDX/oasb_data/tx_idx22.dbf 47200.531.00515052,2800.17
APPS_TS_TX_IDX/oasb_data/tx_idx23.dbf 43900.431.00515049,7330.16
APPS_TS_TX_IDX/oasb_data/tx_idx24.dbf 45800.501.00524047,4570.12
APPS_TS_TX_IDX/oasb_data/tx_idx25.dbf 45700.421.00526054,5060.19
APPS_TS_TX_IDX/oasb_data/tx_idx26.dbf 46500.431.00520047,6980.12
APPS_TS_TX_IDX/oasb_data/tx_idx27.dbf 47000.491.00524053,0450.20
APPS_TS_TX_IDX/oasb_data/tx_idx28.dbf 47400.441.00515053,9350.20
APPS_TS_TX_IDX/oasb_data/tx_idx29.dbf 47500.611.00526050,1900.14
APPS_TS_TX_IDX/oasb_data/tx_idx3.dbf 45800.551.00503054,2270.18
APPS_TS_TX_IDX/oasb_data/tx_idx30.dbf 43300.391.00493053,1960.15
APPS_TS_TX_IDX/oasb_data/tx_idx31.dbf 51500.701.0015507540.93
APPS_TS_TX_IDX/oasb_data/tx_idx32.dbf 49100.511.007501120.98
APPS_TS_TX_IDX/oasb_data/tx_idx33.dbf 49500.481.008201950.97
APPS_TS_TX_IDX/oasb_data/tx_idx34.dbf 47000.451.00513056,5530.16
APPS_TS_TX_IDX/oasb_data/tx_idx35.dbf 49300.471.00528057,7370.17
APPS_TS_TX_IDX/oasb_data/tx_idx36.dbf 47900.461.00507054,6330.16
APPS_TS_TX_IDX/oasb_data/tx_idx37.dbf 49500.511.00523049,1300.15
APPS_TS_TX_IDX/oasb_data/tx_idx38.dbf 48000.501.00544051,1820.16
APPS_TS_TX_IDX/oasb_data/tx_idx39.dbf 50800.491.00521052,2090.15
APPS_TS_TX_IDX/oasb_data/tx_idx4.dbf 52100.501.006803630.30
APPS_TS_TX_IDX/oasb_data/tx_idx40.dbf 52300.381.00530055,6020.17
APPS_TS_TX_IDX/oasb_data/tx_idx41.dbf 50500.501.00522055,9440.17
APPS_TS_TX_IDX/oasb_data/tx_idx42.dbf 52000.381.00537051,4160.17
APPS_TS_TX_IDX/oasb_data/tx_idx43.dbf 51900.521.00528052,5640.17
APPS_TS_TX_IDX/oasb_data/tx_idx44.dbf 51900.521.00513057,8370.19
APPS_TS_TX_IDX/oasb_data/tx_idx45.dbf 50400.441.00548050,0230.15
APPS_TS_TX_IDX/oasb_data/tx_idx46.dbf 53100.471.00531050,3190.16
APPS_TS_TX_IDX/oasb_data/tx_idx47.dbf 51700.621.00534049,2490.15
APPS_TS_TX_IDX/oasb_data/tx_idx48.dbf 51500.451.00550051,5570.15
APPS_TS_TX_IDX/oasb_data/tx_idx49.dbf 50200.541.00522049,5990.15
APPS_TS_TX_IDX/oasb_data/tx_idx5.dbf 50800.411.007502980.07
APPS_TS_TX_IDX/oasb_data/tx_idx50.dbf 51200.551.00523050,6980.15
APPS_TS_TX_IDX/oasb_data/tx_idx51.dbf 53000.601.00531050,2570.16
APPS_TS_TX_IDX/oasb_data/tx_idx52.dbf 51400.471.00539052,0470.17
APPS_TS_TX_IDX/oasb_data/tx_idx53.dbf 54000.591.00529052,8970.17
APPS_TS_TX_IDX/oasb_data/tx_idx54.dbf 52800.441.00537050,0660.16
APPS_TS_TX_IDX/oasb_data/tx_idx55.dbf 53300.391.00536053,4940.16
APPS_TS_TX_IDX/oasb_data/tx_idx56.dbf 51400.561.00533055,1600.14
APPS_TS_TX_IDX/oasb_data/tx_idx57.dbf 52600.361.00545050,9780.16
APPS_TS_TX_IDX/oasb_data/tx_idx58.dbf 53400.491.00536050,8240.14
APPS_TS_TX_IDX/oasb_data/tx_idx59.dbf 53800.501.00532049,5550.14
APPS_TS_TX_IDX/oasb_data/tx_idx6.dbf 51100.431.00529053,0920.17
APPS_TS_TX_IDX/oasb_data/tx_idx60.dbf 53500.501.00525050,4040.18
APPS_TS_TX_IDX/oasb_data/tx_idx61.dbf 51600.541.00518052,2350.20
APPS_TS_TX_IDX/oasb_data/tx_idx62.dbf 50900.391.00534053,1790.17
APPS_TS_TX_IDX/oasb_data/tx_idx63.dbf 49500.571.00510050,9880.18
APPS_TS_TX_IDX/oasb_data/tx_idx64.dbf 51500.371.00532050,6600.16
APPS_TS_TX_IDX/oasb_data/tx_idx65.dbf 50100.481.00519048,9640.16
APPS_TS_TX_IDX/oasb_data/tx_idx66.dbf 48600.621.00527050,6620.19
APPS_TS_TX_IDX/oasb_data/tx_idx67.dbf 45000.441.00520049,2690.15
APPS_TS_TX_IDX/oasb_data/tx_idx68.dbf 48100.501.00519047,1660.18
APPS_TS_TX_IDX/oasb_data/tx_idx69.dbf 48900.531.00520050,0820.18
APPS_TS_TX_IDX/oasb_data/tx_idx7.dbf 47700.381.007501460.07
APPS_TS_TX_IDX/oasb_data/tx_idx70.dbf 46700.511.00521050,5170.16
APPS_TS_TX_IDX/oasb_data/tx_idx71.dbf 48900.471.00523050,5960.15
APPS_TS_TX_IDX/oasb_data/tx_idx72.dbf 50800.431.00517051,6620.24
APPS_TS_TX_IDX/oasb_data/tx_idx8.dbf 50000.461.006401030.00
APPS_TS_TX_IDX/oasb_data/tx_idx9.dbf 47700.401.006601090.09
APPS_UNDOTS1/oasb_data/undo.dbf 00  8,457573,0930.02
APPS_UNDOTS1/oasb_data/undo2.dbf 00  8,457566,9690.02
APPS_UNDOTS1/oasb_data/undo3.dbf 00  8,436549,1920.02
APPS_UNDOTS1/oasb_data/undo4.dbf 00  8,543550,6810.01
APPS_UNDOTS1/oasb_data/undo5.dbf 00  8,376553,5140.02
APPS_UNDOTS1/oasb_data/undo6.dbf 00  8,071448,3120.02
APPS_UNDOTS1/oasb_data/undo7.dbf 00  7,991437,8250.02
APPS_UNDOTS1/oasb_data/undo8.dbf 00  8,375561,7470.02
APPS_UNDOTS1/oasb_data/undo9.dbf 00  8,431558,2750.02
SYSAUX/oasb_data/sysaux01.dbf 71600.611.06263000.00
SYSAUX/oasb_data/sysaux02.dbf 31500.701.02138000.00
SYSTEM/oasb_data/sys1.dbf 5301.706.8311071.43
SYSTEM/oasb_data/sys10.dbf 4903.478.785010.00
SYSTEM/oasb_data/sys2.dbf 9501.475.021000.00
SYSTEM/oasb_data/sys3.dbf 4102.939.635000.00
SYSTEM/oasb_data/sys4.dbf 3802.8910.74404860.21
SYSTEM/oasb_data/sys5.dbf 3601.947.560025.00
SYSTEM/oasb_data/sys6.dbf 2804.2910.210000.00
SYSTEM/oasb_data/sys7.dbf 2603.469.545000.00
SYSTEM/oasb_data/sys8.dbf 8602.335.4413000.00
SYSTEM/oasb_data/sys9.dbf 6102.957.035030.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,542,1611002,929,134,255112,9031,522,731004,240,342

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,522,6780

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
B0205317831227939953280022793   
E03582234885596756191402559953280019140255   

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,8160.103471.681,1161890.00
D5,6320.206941.489831731.00
D8,4480.291,0411.328781606.00
D11,2640.391,3881.197951508.00
D14,0800.491,7361.177771486.00
D16,8960.592,0831.127451449.00
D19,7120.692,4301.067071403.00
D22,5280.782,7771.036871379.00
D25,3440.883,1241.006661355.00
D28,1600.983,4711.006661355.00
D28,7361.003,5421.006661355.00
D30,9761.083,8181.006661355.00
D33,7921.184,1651.006651353.00
D36,6081.274,5131.006651353.00
D39,4241.374,8601.006651353.00
D42,2401.475,2071.006651353.00
D45,0561.575,5541.006651353.00
D47,8721.675,9011.006651353.00
D50,6881.766,2481.006651353.00
D53,5041.866,5951.006651353.00
D56,3201.966,9421.006651353.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.0026,9670

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)
B6,1445,373246.490.000.000.000.00629,140
E6,1445,377247.460.000.000.000.00629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K13,508,74913,508,74900
64K128K8800
128K256K464600
256K512K4400
512K1024K343400
1M2M141400
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
7680.13109,332.140.00100.0000
1,5360.25109,332.140.00100.0000
3,0720.50109,332.140.00100.0000
4,6080.75109,332.140.00100.0000
6,1441.00109,332.140.00100.0000
7,3731.20109,332.140.00100.0000
8,6021.40109,332.140.00100.0000
9,8301.60109,332.140.00100.0000
11,0591.80109,332.140.00100.0000
12,2882.00109,332.140.00100.0000
18,4323.00109,332.140.00100.0000
24,5764.00109,332.140.00100.0000
36,8646.00109,332.140.00100.0000
49,1528.00109,332.140.00100.0000

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
3200.141006,1293,127,5851.002,0101.00239,277
5760.241006,1293,127,5851.002,0101.00239,277
8320.351006,1293,127,5851.002,0101.00239,277
1,0880.461006,1293,127,5851.002,0101.00239,277
1,3440.571006,1293,127,5851.002,0101.00239,277
1,6000.681006,1293,127,5851.002,0101.00239,277
1,8560.781006,1293,127,5851.002,0101.00239,277
2,1120.891006,1293,127,5851.002,0101.00239,277
2,3681.001006,1293,127,5851.002,0101.00239,277
2,6241.111006,1293,127,5851.002,0101.00239,277
2,8801.221006,1293,127,5851.002,0101.00239,277
3,1361.321006,1293,127,5851.002,0101.00239,277
3,3921.431006,1293,127,5851.002,0101.00239,277
3,6481.541006,1293,127,5851.002,0101.00239,277
3,9041.651006,1293,127,5851.002,0101.00239,277
4,1601.761006,1293,127,5851.002,0101.00239,277
4,4161.861006,1293,127,5851.002,0101.00239,277
4,6721.971006,1293,127,5851.002,0101.00239,277

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,9440.13107,8721,116,358
7,8880.25107,711983,093
11,8320.38107,485795,123
15,7760.50107,464776,866
19,7200.63107,378706,702
23,6640.75107,356686,912
27,6080.88107,337666,323
31,5521.00107,335666,323
35,4961.13107,337664,990
39,4401.25107,337664,990
43,3841.38107,337664,990
47,3281.50107,337664,990
51,2721.63107,337664,990
55,2161.75107,337664,990
59,1601.88107,337664,990
63,1042.00107,337664,990

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 block3,732,4765770
undo block416,95870
undo header82,41820
1st level bmb4,22600
segment header1,32600
2nd level bmb3600
extent map200

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
UL-User-defined 51,23750,50273538,57874319.25
TX-Transaction (index contention) 612,755612,7430609,5113660.60
SQ-Sequence Cache 39,79039,789029,39990.31
TX-Transaction (row lock contention) 5,2844,5976874,51561.41
HW-Segment High Water Mark 10,88910,88805,47150.82
TX-Transaction 559,565559,624050611.18
FB-Format Block 1,6011,60108900.19
TX-Transaction (allocate ITL entry) 595905900.20
DV-Diana Versioning 1,0801,08006200.06

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,005.29488,2971,54653134.8/1400/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
20-Sep 18:17126,501104,0661,435531400/00/0/0/0/0/0
20-Sep 18:07289,65680,312944531350/00/0/0/0/0/0
20-Sep 17:57589,135303,9191,546521370/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM db client latch2,7100.00 00 
ASM map operation hash table10.00 00 
ASM network state latch3440.00 00 
AWR Alerted Metric Element list21,2560.00 00 
Change Notification Hash table latch6030.00 00 
Consistent RBA268,9180.030.0000 
DML lock allocation1,912,7180.000.0000 
Event Group Locks2370.00 00 
FOB s.o list latch34,8240.300.0000 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch28,014,9040.550.8225243,5700.01
JS Sh mem access10.00 00 
JS queue access latch10.00 00 
JS slv state obj latch10.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch6040.00 00 
KTF sga latch100.00 06030.00
KWQP Prop Status2290.00 00 
KWQS pqueue ctx latch20.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0360.00
Memory Management Latch10.00 06040.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch110.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process7610.00 00 
OS process allocation1,1060.00 00 
OS process: request allocation4720.00 00 
PL/SQL warning settings4,013,6051.500.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch3,8150.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 06030.00
SQL memory manager workarea list latch4,061,6710.150.0000 
Shared B-Tree1,1890.00 00 
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 latch134,0260.050.0000 
active service list1,6170.060.0001,0730.00
begin backup scn array560.00 00 
bq:time manger info latch650.00 00 
buffer pool10.00 00 
bufq statistics10.00 00 
business card10.00 00 
cache buffer handles270,763,57613.090.0000 
cache buffers chains5,546,909,3874.350.0124612,184,4303.52
cache buffers lru chain2,551,7390.080.00025,076,7500.45
cache table scan latch2320.00 02320.00
call allocation504,8834.400.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch4740.00 00 
channel operations parent latch20,1670.00 00 
checkpoint queue latch5,438,3640.000.0001,745,1650.00
client/application info4,0510.00 00 
compile environment latch2350.430.0000 
corrupted undo seg latch648,4190.040.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch3440.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch3440.00 00 
dml lock allocation3440.00 00 
done queue latch10.00 00 
dummy allocation4734.020.0000 
enqueue hash chains5,255,16516.610.0002801.43
enqueues1,424,63214.840.0000 
fifth spare latch10.00 00 
file cache latch4,1630.020.0000 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA2270.440.0000 
global ctx hash table latch4290.470.0000 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch1370.00 019,6630.00
hash table modification latch1010.990.0000 
heartbeat check10.00 00 
internal temp table object number allocation latch220.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats2850.00 00 
kokc descriptor allocation latch540.00 00 
ksfv messages10.00 00 
kss move lock170.00 00 
ksuosstats global area1240.00 00 
ksv allocation latch3760.00 00 
ksv class latch330.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch4720.00 00 
ktm global data280.00 00 
kwqbsn:qsga1,1180.360.0000 
lgwr LWN SCN273,1031.160.0000 
list of block allocation472,0250.070.0000 
loader state object freelist6023.490.0000 
lob segment dispenser latch10.00 00 
lob segment hash table latch70.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 latch2,2510.00 00 
messages1,106,6530.050.0000 
mostly latch-free SCN326,50612.720.0000 
msg queue latch10.00 00 
multiblock read objects5200.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch3440.00 00 
object queue header heap1,075,6200.00 01,8530.00
object queue header operation9,042,3180.010.0000 
object stats modification4330.230.0000 
parallel query alloc buffer2410.00 00 
parallel query stats10.00 00 
parameter list1260.00 00 
parameter table management4960.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue131,2780.020.00089,0340.06
process allocation4800.00 02360.00
process group creation4720.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch2,3798.790.0000 
query server freelists10.00 00 
queued dump request60.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation2,110,7599.420.00073,333,9363.24
redo copy10.00 073,526,5030.04
redo writing1,300,5900.010.0000 
resmgr group change latch1,1260.270.0000 
resmgr:active threads6950.00 00 
resmgr:actses change group6890.00 00 
resmgr:actses change state2270.00 00 
resmgr:free threads list4720.640.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 objects12,967,65215.480.0000 
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second spare latch10.00 00 
sequence cache31,178,5324.260.0000 
session allocation779,8090.080.000259,9360.00
session idle bit46,678,6810.120.0000 
session queue latch10.00 00 
session state list latch1,3863.390.5700 
session switching1,5250.00 00 
session timer6210.00 00 
shared pool717,0710.050.0000 
shared pool sim alloc190.00 00 
shared pool simulator7880.00 00 
sim partition latch10.00 00 
simulator hash latch156,181,5430.000.0000 
simulator lru latch1,078,7080.230.000154,958,1153.52
sort extent pool3,0851.820.0000 
space background state object latch40.00 00 
space background task latch1,3410.150.0001,2040.00
state object free list20.00 00 
statistics aggregation3360.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
temporary table state object allocation4522.430.0000 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch3680.00 00 
trace latch20.00 00 
transaction allocation85,1900.000.0000 
undo global data95,331,1310.270.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains5,546,909,387241,263,8272,428,846239,248,755
cache buffer handles270,763,57635,442,9611,31335,441,662
row cache objects12,967,6522,006,906342,006,872
sequence cache31,178,5321,327,445541,327,391
enqueue hash chains5,255,165873,142642872,500
undo global data95,331,131254,46627254,439
enqueues1,424,632211,45115211,436
redo allocation2,110,759198,82680198,746
In memory undo latch28,014,904154,910127,19134,061
session idle bit46,678,68153,8122053,793
simulator lru latch1,078,7082,47622,474
cache buffers lru chain2,551,7391,93531,932
qmn task queue latch2,3792091208
session state list latch1,386472720

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchkticmt: child061,441815
In memory undo latchktiFlush: child043,76014,432
In memory undo latchktichg: child022,02725,951
In memory undo latchktiFlushMe01,167219
In memory undo latchktbgfc0241304
In memory undo latchkturbk03886,969
In memory undo latchktiFlushTopTxn0366
In memory undo latchktiTxnPoolFree031
cache buffer handleskcbzgs0843999
cache buffer handleskcbzfs0469314
cache buffers chainskcbchg1: kslbegin: bufs not pinned01,189,812957,053
cache buffers chainskcbgtcr: fast path0543,299189,679
cache buffers chainskcbgtcr: fast path (cr pin)0401,441188,832
cache buffers chainskcbgtcr_20169,617116,248
cache buffers chainskcbgtcr: kslbegin excl0109,09684,470
cache buffers chainskcbgcur_2085,00727,301
cache buffers chainskcbgkcbcr072,50281,880
cache buffers chainskcbget: pin buffer059,22716,648
cache buffers chainskcbzwb053,65137,181
cache buffers chainskcbchg1: kslbegin: call CR func028,765485,071
cache buffers chainskcbrls_1015,044145,540
cache buffers chainskcbrls_2014,932320,862
cache buffers chainskcb_is_private01,6996,809
cache buffers chainskcbnlc01,5896,921
cache buffers chainskcbcge01,19260,687
cache buffers chainskcbgcur: fast path (shr)0637687
cache buffers chainskcbesc: escalate0518122
cache buffers chainskcbget: exchange0402994
cache buffers chainskcbget: exchange rls0378553
cache buffers chainskcbzgb: scan from tail. nowait03530
cache buffers chainskcb_post_apply: kcbhq6202411,949
cache buffers chainskcbzpbuf02107,594
cache buffers chainskcb_commit01587,314
cache buffers chainskcb_pre_apply: kcbhq61015510,015
cache buffers chainskcbso1: set no access0572,885
cache buffers chainskcbgtcr: kslbegin shared05535
cache buffers chainskcb_post_apply: kcbhq630471,083
cache buffers chainskcbgcur_5044144
cache buffers chainskcbnew: new latch again0311
cache buffers chainskcbget_101219
cache buffers chainskcbbxsv011
cache buffers chainskcbgcur_4012
cache buffers chainskcbzhngcbk1_1010
cache buffers lru chainkcbzgws030
enqueue hash chainsksqrcl0513212
enqueue hash chainsksqcmi: get hash chain latch after wait0123427
enqueue hash chainsksqgtl3063
enqueuesksqdel01413
enqueuesksqgel: create enqueue012
qmn task queue latchkwqmngettsk: get task011
redo allocationkcrfw_redo_gen: redo allocation 10680
redo allocationkcrfw_redo_gen: redo allocation 2050
redo allocationkcrfw_redo_gen: redo allocation 30530
redo allocationkcrfw_post: more space0147
redo allocationkcrfw_redo_write: before write016
row cache objectskqreqd: reget0284
row cache objectskqreqd037
row cache objectskqrpre: find obj0323
sequence cachekdnssd0441
sequence cachekdnnxt: cached seq072
sequence cachekdnss0351
session idle bitksupuc: set busy0113
session idle bitksupuc: clear busy01018
session state list latchkpseqd0270
simulator lru latchkcbs_simulate: simulate set020
undo global dataktudba: KSLBEGIN02625
undo global dataktudnx:child011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 415,7470
Library Cachekglpndl1 958,965-0
Library Cachekgllkdl1 855,629-0
Cursor Pinkksfbc [KKSCHLFSP2]5,5030
Library Cachekglpnal1 905,423-0
Library CachekglIsOwnerVersionable 1213,903-0
Cursor Pinkksfbc [KKSCHLPIN1]3,7650
Cursor PinkksLockDelete [KKSCHLPIN6]2,8300
Cursor Pinkkslce [KKSCHLPIN2]2,13810
Library Cachekgllkc1 571,7220
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]7400
Library Cachekglllal3 1115020
hash tablekkshGetNextChild [KKSHBKLOC1]3530
Cursor ParentkkscsPruneChild [KKSPRTLOC35]3050
Library Cachekglhdgn2 1062470
Library Cachekglobpn1 711720
Library Cachekgllldl2 1121510
hash tablekkscsSearchChildList [KKSHBKLOC2]1360
Library Cachekglllal1 109930
Library Cachekglget2 2620
Library Cachekglhdgn1 62240
Cursor Pinkksxsccmp [KKSCHLPIN5]190
Library Cachekglini1 3214-0
Library Cachekgldtld1 4040
Library Cachekglnti1 462-0
Library Cachekglobld1 7520
Library CachekglUnsetHandleReference 1201-0
Library Cachekglati1 451-0
Library Cachekglhdgc1 1021-0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX311,370,11210.54
HRAPPS_TS_TX_IDXPAY_PAYROLL_ACTIONS_PK INDEX175,518,5445.94
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE140,800,3684.77
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N50 INDEX139,325,9684.72
HRAPPS_TS_TX_DATAPAY_PAYROLL_ACTIONS TABLE85,049,9842.88

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE54,59148.38
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX1,9811.76
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE1,8841.67
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE1,0930.97
HRAPPS_TS_TX_IDXPAY_COSTS_FK3 INDEX3900.35

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 TABLE54,17750.41
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX1,9791.84
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE1,0941.02
HRAPPS_TS_TX_IDXPAY_COSTS_FK3 INDEX3900.36
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX1950.18

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE54,17750.41
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX1,9791.84
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE1,0941.02
HRAPPS_TS_TX_IDXPAY_COSTS_FK3 INDEX3900.36
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX1950.18

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE91,6456.02
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX41,2332.71
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N51 INDEX30,6672.01
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX28,6651.88
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE25,5991.68

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
HRAPPS_TS_TX_DATAPAY_ACTION_INFORMATION TABLE7,0235.38
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX3,9903.06
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N3 INDEX3,1392.41
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX2,9352.25
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE2,7742.13

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE408,940,76864.90
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX63,341,24810.05
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX44,036,1446.99
HRAPPS_TS_TX_DATAPER_ALL_ASSIGNMENTS_F TABLE39,914,8646.33
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N51 INDEX10,612,4161.68

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_RUN_RESULTS_N50 INDEX60,9999.92
HRAPPS_TS_TX_IDXPAY_MESSAGE_LINES_N50 INDEX60,2739.80
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_PK INDEX47,9217.79
HRAPPS_TS_TX_IDXPAY_MESSAGE_LINES_PK INDEX44,4407.23
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX44,2537.20

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX2135.59
HRAPPS_TS_TX_IDXPAY_COSTS_FK2 INDEX2033.90
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX915.25
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX610.17
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX23.39

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_INFORMATION_PK INDEX452,43112.19
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX346,2239.33
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX331,1598.92
HRAPPS_TS_TX_IDXPAY_MESSAGE_LINES_N50 INDEX269,2187.25
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N50 INDEX203,6225.48

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control50.000 21
dc_global_oids6417.190 031
dc_histogram_data1545.190 0465
dc_histogram_defs3,1979.950 05,508
dc_object_grants910.000 098
dc_objects20,8920.920 03,390
dc_profiles2270.000 01
dc_rollback_segments1,1320.000 053
dc_segments6,9071.810 1,5142,127
dc_sequences10,3880.040 10,38820
dc_tablespaces2,225,0010.000 055
dc_users2,044,5970.000 075
global database name1,4390.000 01
outstanding_alerts1620.620 253


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
APP CONTEXT9,5860.009,5860.0000
BODY14,9910.0841,451,4650.0100
CLUSTER1070.00130.0000
DBLINK4560.000 00
DIRECTORY4520.004520.0000
EDITION2340.004610.0000
INDEX640.00480.0000
QUEUE5260.005280.0000
RULESET20.0020.0000
SCHEMA6580.000 00
SQL AREA24,7791.40292,264,938-1.5110
TABLE/PROCEDURE126,9270.0651,886,9550.0200
TRIGGER2,4520.006,000,7080.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 cache28,736.0028,736.0028,736.0028,864.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target6,144.006,144.006,144.006,144.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target31,552.0031,552.0031,552.0031,552.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool64.0064.0064.0064.000STA/
large pool64.0064.000.0064.000GRO/IMM
shared pool2,304.002,304.002,304.002,304.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
BOther157.80 2.021.9011117878
 Freeable48.560.001.623.4111 3030
 PL/SQL37.0334.540.470.35117878
 SQL3.170.080.050.02036258
EOther158.43 2.031.8911117878
 Freeable49.190.001.493.2811 3333
 PL/SQL36.9034.320.470.34117878
 SQL3.000.080.050.02036258

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers30,131,879,936 
Fixed Size2,223,136 
Redo Buffers118,501,376 
Variable Size2,684,355,552 

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 buffers63.0063.000.00
sharedCheckpoint queue24.0224.020.00
sharedFileOpenBlock53.1153.110.00
sharedSQLA38.5243.3912.64
shareddb_block_hash_buckets178.00178.000.00
shareddbwriter coalesce buffer24.0224.020.00
sharedevent statistics per sess24.6724.670.00
sharedfree memory1,599.001,586.86-0.76
sharedprivate strands28.5728.570.00
streamsfree memory127.99127.990.00
 buffer_cache28,736.0028,736.000.00
 fixed_sga2.122.120.00
 log_buffer113.01113.010.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0920 16:07:510.050.000.00
QMON Coordinator0920 16:07:400.020.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report