WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS337144293VIS103-Aug-12 16:0811.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
db1.oasb.ciscoLinux x86 64-bit 32 16 2 125.91

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:306-Aug-12 15:58:04232 24.3
End Snap:406-Aug-12 16:25:27240 23.0
Elapsed:  27.37 (mins)  
DB Time:  535.43 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 24,576M 24,576MStd Block Size: 8K
Shared Pool Size: 5,056M 5,056MLog Buffer: 316,116K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 19.6 0.1 0.00 0.00
DB CPU(s): 17.9 0.1 0.00 0.00
Redo size: 13,555,015.4 93,268.9  
Logical reads: 1,781,665.2 12,259.2  
Block changes: 82,796.2 569.7  
Physical reads: 88.4 0.6  
Physical writes: 1,037.8 7.1  
User calls: 14,087.2 96.9  
Parses: 25.8 0.2  
Hard parses: 0.0 0.0  
W/A MB processed: 12.3 0.1  
Logons: 0.2 0.0  
Executes: 141,507.1 973.7  
Rollbacks: 1.0 0.0  
Transactions: 145.3   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.89Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 101.41Soft Parse %: 99.90
Execute to Parse %: 99.98Latch Hit %: 97.38
Parse CPU to Parse Elapsd %: 85.44% Non-Parse CPU: 98.38

Shared Pool Statistics

BeginEnd
Memory Usage %: 78.25 78.33
% SQL with executions>1: 83.19 94.84
% Memory for SQL w/exec>1: 79.97 93.30

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 29,321 91.27 
enq: UL - contention34,2991,014303.16Application
db file sequential read138,23836631.14User I/O
library cache: mutex X760,81229400.91Concurrency
buffer busy waits3,238,09527700.86Concurrency

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

Load Average BeginLoad Average End%User%System%WIO%Idle
0.23 11.59 56.5 2.4 0.5 40.6
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
55.9 94.1 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 128,930.1 128,930.1
SGA use (MB): 30,720.0 30,720.0
PGA use (MB): 1,139.1 1,150.0
% Host Mem used for SGA+PGA: 24.71 24.72

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time31,003.8996.51
DB CPU29,321.3191.27
PL/SQL execution elapsed time11,682.6236.37
parse time elapsed665.932.07
repeated bind elapsed time13.020.04
inbound PL/SQL rpc elapsed time9.580.03
sequence load elapsed time4.350.01
hard parse elapsed time1.300.00
connection management call elapsed time0.570.00
PL/SQL compilation elapsed time0.120.00
hard parse (sharing criteria) elapsed time0.020.00
hard parse (bind mismatch) elapsed time0.000.00
DB time32,125.52 
background elapsed time368.99 
background cpu time53.06 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME3,121,551 
IDLE_TIME2,136,052 
IOWAIT_TIME24,819 
NICE_TIME1 
SYS_TIME126,440 
USER_TIME2,972,712 
LOAD012
PHYSICAL_MEMORY_BYTES135,192,977,408 
NUM_CPUS32 
NUM_CPU_CORES16 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX41,944,304 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
06-Aug 15:58:040.23     
06-Aug 16:25:2711.5959.3756.542.4040.630.47

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  29,321 91.27
Application40,36001,032263.21
Concurrency4,594,707082202.56
User I/O168,900045431.41
Commit85,28708010.25
Other443,305952900.09
Configuration46,99502000.06
Network22,434,85702000.06
System I/O26,1070400.01

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 - contention34,29901,014300.143.16
db file sequential read138,238036630.581.14
library cache: mutex X760,812029403.190.91
buffer busy waits3,238,0950277013.570.86
enq: TX - index contention454,520016201.900.50
read by other session13,43408760.060.27
log file sync85,28708010.360.25
cursor: pin S7,90405570.030.17
cursor: pin S wait on X730233160.000.07
enq: TX - row lock contention3,73901850.020.06
enq: HW - contention33,37801710.140.05
rdbms ipc reply7861319270.000.04
SQL*Net message to client21,708,784013090.940.04
enq: TX - contention9,2090710.040.02
SQL*Net more data from client723,0670703.030.02
latch: cache buffers chains90,4260700.380.02
buffer deadlock419,261100601.760.02
control file sequential read26,1070400.110.01
latch: In memory undo latch38,6500300.160.01
enq: SQ - contention13,4310200.060.01
cursor: mutex S2950260.000.01
latch: redo allocation3,6660100.020.00
db file scattered read1510140.000.00
latch free1,8520000.010.00
latch: cache buffer handles2,8410000.010.00
enq: FB - contention1,6420000.010.00
cursor: mutex X3,1550000.010.00
latch: row cache objects7720000.000.00
latch: undo global data6130000.000.00
latch: enqueue hash chains1,3120000.010.00
utl_file I/O4,6540000.020.00
SQL*Net break/reset to client2,3220000.010.00
direct path read temp1290010.000.00
Disk file operations I/O12,2110000.050.00
direct path write temp520010.000.00
wait list latch free380010.000.00
enq: TX - allocate ITL entry1860000.000.00
SQL*Net more data to client3,0060000.010.00
L1 validation21000110.000.00
enq: DV - contention130020.000.00
direct path write260010.000.00
direct path read40040.000.00
latch: cache buffers lru chain210010.000.00
CSS initialization50020.000.00
db file parallel read100110.000.00
CSS operation: action50010.000.00
asynch descriptor resize2,738100000.010.00
latch: object queue header operation140000.000.00
CSS operation: query300000.000.00
library cache lock20010.000.00
SQL*Net message from client21,708,7840212,6301090.94 
Streams AQ: waiting for messages in the queue3,72610033,14188940.02 
pipe get1,9661008,20241720.01 
PL/SQL lock timer8181008,183100030.00 
jobq slave wait3,627991,8155010.02 
KSV master wait640080.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 write255,867014611.0739.53
db file parallel write115,883011310.4930.58
os thread startup6002310.000.51
LGWR wait for redo copy23,0550200.100.44
control file sequential read1,3050110.010.34
ASM file metadata operation7400110.000.30
control file parallel write8340110.000.20
latch free1320020.000.06
direct path read270060.000.05
latch: redo allocation3340000.000.03
db file async I/O submit115,6710000.480.01
library cache: mutex X90030.000.01
db file sequential read30070.000.01
Disk file operations I/O1,0330000.000.00
latch: cache buffers lru chain260000.000.00
latch: object queue header operation190000.000.00
direct path write10010.000.00
asynch descriptor resize279100000.000.00
rdbms ipc message209,248426,0751250.88 
Space Manager: slave idle wait3,0887112,20339520.01 
class slave wait26803,284122540.00 
DIAG idle wait3,1691003,19010070.01 
smon timer9701,710176240.00 
JOX Jit Process Sleep1101001,650150040.00 
Streams AQ: qmn coordinator idle wait767321,64321430.00 
Streams AQ: qmn slave idle wait24601,64366810.00 
wait for unread message on broadcast channel1,6411001,64310010.01 
ASM background timer36001,64245610.00 
pmon timer1,148331,63714260.00 
SQL*Net message from client8710110.00 
KSV master wait900020.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ASM file metadata operation77289.81.62.22.61.41.31.2 
CSS initialization5  100.0     
CSS operation: action5100.0       
CSS operation: query30100.0       
Disk file operations I/O13.2K100.0       
L1 validation2    100.0   
LGWR wait for redo copy23.1K98.8.4.3.3.1.0  
SQL*Net break/reset to client230999.4.4.1.1    
SQL*Net message to client21.4M100.0.0      
SQL*Net more data from client719.3K99.9.0.0.0.0.0.0 
SQL*Net more data to client3004100.0       
asynch descriptor resize3016100.0       
buffer busy waits3237.1K99.3.6.1.0.0.0.0 
buffer deadlock419.4K99.9.1.0.0.0.0.0 
control file parallel write83593.51.31.02.41.0.5.4 
control file sequential read27.4K99.4.1.1.2.1.0.0 
cursor: mutex S29547.1.7.3.350.5.7.3 
cursor: mutex X313599.1.1  .8   
cursor: pin S785541.8.2.1.155.41.8.6 
cursor: pin S wait on X71 1.41.4 12.7 84.5 
db file async I/O submit115.2K100.0       
db file parallel read1    100.0   
db file parallel write115.5K67.330.9.8.3.7.0.0 
db file scattered read15115.92.614.665.6.7.7  
db file sequential read138.3K44.39.724.717.62.4.8.4 
direct path read3119.422.69.725.812.99.7  
direct path read temp129100.0       
direct path write2788.93.7 7.4    
direct path write temp5282.715.41.9     
enq: DV - contention1361.57.723.1 7.7   
enq: FB - contention164299.1.7.1.1  .1 
enq: HW - contention33.4K75.922.8.9.2.1.0.0 
enq: SQ - contention13.4K99.3.4.1.1 .0.0 
enq: TX - allocate ITL entry18698.41.1  .5   
enq: TX - contention921886.712.9.3.0.0.1.0 
enq: TX - index contention454.5K95.83.8.2.1.1.0.0 
enq: TX - row lock contention373975.54.49.55.8.62.61.6 
enq: UL - contention34.3K18.85.44.24.17.315.444.7.0
latch free198495.73.6.3.1.1.1.2 
latch: In memory undo latch38.6K99.6.2.1.0.0.0.0 
latch: cache buffer handles284198.01.4.5.1.0 .0 
latch: cache buffers chains90.4K99.0.6.2.1.0.0.0 
latch: cache buffers lru chain4797.9   2.1   
latch: call allocation3100.0       
latch: checkpoint queue latch7100.0       
latch: enqueue hash chains131298.21.8.1     
latch: object queue header operation33100.0       
latch: redo allocation399896.52.6.6.3.1.0  
latch: row cache objects77394.64.01.2.1.1   
latch: shared pool3100.0       
latch: undo global data61395.43.4.5.3.3   
library cache lock2100.0       
library cache: mutex X759K96.7.1.1.12.8.2.0 
log file parallel write255.9K90.96.02.3.7.1.0.0 
log file sync85.3K77.714.06.21.6.4.1.0 
os thread startup60    51.721.726.7 
rdbms ipc reply7       100.0
read by other session13.4K14.18.523.914.837.31.1.2 
utl_file I/O4653100.0       
wait list latch free3852.647.4      
ASM background timer360    .6.86.192.5
DIAG idle wait3170      97.52.5
JOX Jit Process Sleep110       100.0
KSV master wait15471.41.96.58.43.23.94.5 
PL/SQL lock timer818       100.0
SQL*Net message from client21.2M99.3.4.2.0.0.0.0.0
Space Manager: slave idle wait3061.2.2.8.11.1.313.883.5
Streams AQ: qmn coordinator idle wait76767.9      32.1
Streams AQ: qmn slave idle wait246       100.0
Streams AQ: waiting for messages in the queue3735      1.099.0
class slave wait26832.12.64.19.04.93.412.331.7
jobq slave wait3627    .0 100.0 
pipe get1970      8.391.7
pmon timer11494.4.1.2.51.41.744.147.6
rdbms ipc message209.3K64.88.75.16.54.82.24.53.4
smon timer962.1 3.11.04.24.237.547.9
wait for unread message on broadcast channel1641      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
ASM file metadata operation998.8.9.3     
SQL*Net more data from client1100.0.0      
buffer busy waits40100.0.0.0  .0  
buffer deadlock20100.0.0.0     
control file parallel write399.6.4      
control file sequential read8100.0.0.0     
cursor: mutex S199.7.3      
cursor: pin S4999.4.4.2.0    
cursor: pin S wait on X6015.5  1.483.1   
db file parallel write4100.0.0      
db file sequential read56599.6.3.1.0.0   
enq: FB - contention299.9.1      
enq: HW - contention8100.0.0.0     
enq: SQ - contention4100.0.0.0     
enq: TX - contention4100.0.0.0     
enq: TX - index contention12100.0.0.0     
enq: TX - row lock contention6098.4.7.4 .3.2  
enq: UL - contention15.3K55.333.411.3    .0
latch free499.8.2      
latch: In memory undo latch4100.0.0.0     
latch: cache buffer handles1100.0.0      
latch: cache buffers chains5100.0.0      
library cache: mutex X211100.0.0.0.0    
log file parallel write10100.0.0.0     
log file sync30100.0.0.0.0    
os thread startup1673.313.311.71.7    
rdbms ipc reply7      100.0 
read by other session3199.8.2      

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 - contention1100.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)
VIS31,36629,306122,925,676
SYS$USERS75915133617
SYS$BACKGROUND00120

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
VIS 350871024594706822002243481720
SYS$USERS 1338123531000400
SYS$BACKGROUND 106407220000

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
23,181.60249,7530.0972.1698.590.004f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
23,101.80249,8130.0971.9198.870.005sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,487.8413211.274.6334.450.00dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
1,302.573,995,6150.004.0598.810.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,108.98249,6920.003.4595.020.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
1,016.642,746,5000.003.1698.660.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,004.403,745,4310.003.1398.660.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
911.4728,879,1460.002.8498.690.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
645.111,499,1400.002.0199.360.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
587.593,123,5330.001.8393.070.146v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
468.0510,975,9480.001.46100.660.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
446.73249,7450.001.3991.340.0147g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
415.48249,5180.001.2994.470.109jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
390.0813,839,1170.001.21100.310.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
377.002217.141.173.2793.336gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
376.692018.831.173.1993.403am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
376.581376.581.173.1693.43gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
360.12249,8800.001.1292.650.187d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
339.551,124,1080.001.0699.100.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
336.9414,838,1490.001.05100.060.00cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...

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
22,854.67249,7530.0977.9523,181.6098.590.004f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
22,840.66249,8130.0977.9023,101.8098.870.005sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
1,287.053,995,6150.004.391,302.5798.810.00g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
1,053.78249,6920.003.591,108.9895.020.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
1,003.022,746,5000.003.421,016.6498.660.00dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
990.933,745,4310.003.381,004.4098.660.007rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
899.5528,879,1460.003.07911.4798.690.004gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
641.001,499,1400.002.19645.1199.360.0001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
546.863,123,5330.001.87587.5993.070.146v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
512.541323.881.751,487.8434.450.00dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
471.1310,975,9480.001.61468.05100.660.0002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
408.02249,7450.001.39446.7391.340.0147g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
392.52249,5180.001.34415.4894.470.109jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
391.3013,839,1170.001.33390.08100.310.00grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
337.1214,838,1490.001.15336.94100.060.00cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
336.481,124,1080.001.15339.5599.100.008v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
333.65249,8800.001.14360.1292.650.187d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
300.4313,844,6490.001.02298.73100.570.009wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...

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
351.842215.9977.44377.003.2793.336gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
351.842017.5977.44376.693.1993.403am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
351.841351.8477.44376.583.1693.43gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
0.97249,7530.000.2123,181.6098.590.004f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
0.97249,8130.000.2123,101.8098.870.005sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
0.833,123,5330.000.18587.5993.070.146v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
0.66249,8800.000.15360.1292.650.187d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
0.41249,5180.000.09415.4894.470.109jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro...
0.25249,6920.000.061,108.9895.020.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
0.25249,8880.000.06189.6395.260.13g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...

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,099,713,390249,7538,407.1671.7523,181.6098.604f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
2,098,506,165249,8138,400.3171.7123,101.8098.905sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
227,416,2623,995,61556.927.771,302.5798.80g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
196,522,7591,499,140131.096.72645.1199.4001pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca...
195,139,6982,746,50071.056.671,016.6498.70dz7tyjxnar7gt PYUSLV SELECT /*+ ORDERED */ fnd_numb...
159,621,4313,745,43142.625.451,004.4098.707rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
123,286,73413,839,1178.914.21390.08100.30grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
119,695,98510,975,94810.914.09468.05100.7002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
115,683,218132876,388.023.951,487.8434.40dab1prc9qyv3v PYUSLV begin hr_nonrun_asact.asact(:...
111,164,9861,124,10898.893.80339.5599.108v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca...
88,456,00214,838,1495.963.02336.94100.10cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
87,765,280999,12287.843.00233.0589.90f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ...
86,573,197249,692346.722.961,108.989504ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
84,852,45928,879,1462.942.90911.4798.704gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
80,025,090249,880320.252.73360.1292.7.27d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
66,078,3391,996,83633.092.26171.2699.205ts0t88sz97xs PYUSLV SELECT PDB.DEFINED_BALANCE_ID ...
64,722,6433,123,53320.722.21587.5993.1.16v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
58,007,292249,745232.271.98446.7391.3047g6xx472xzud PYUSLV BEGIN FFP51704_01010001.FORMUL...
55,039,73213,844,6493.981.88298.73100.609wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
47,079,8263,121,38215.081.61200.47100.50bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
45,713,6434,240,17910.781.56257.7699.906500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
45,371,9766,492,8166.991.55165.10100.805p88n2zhuqfd9 PYUSLV SELECT PPA.EFFECTIVE_DATE, PPA...
44,342,83514,839,9732.991.52266.0899.7077d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
34,126,829249,835136.601.17247.3593.602tr0101sa3jh2 PYUSLV BEGIN FFP1893_01010001.FORMULA...
32,498,680249,287130.371.11253.7999.30brhrt8s5mn8kq PYUSLV SELECT PTS.TIME_IN_STATE, PTS....

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
132,688206,634.4091.44376.693.1993.403am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
132,688226,031.2791.44377.003.2793.336gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
132,6881132,688.0091.44376.583.1693.43gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
146249,7530.000.1023,181.6098.590.004f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
146249,8130.000.1023,101.8098.870.005sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
132249,8800.000.09360.1292.650.187d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
1263,123,5330.000.09587.5993.070.146v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
54154.000.041.7197.502.935zaw8dzwggxxa PYUSLV select paa.rowid from (select...
39249,8880.000.03189.6395.260.13g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
23249,6920.000.021,108.9895.020.024ds53shhfcynn 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
132,717132,717206,635.850.0095.513am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
132,717132,717226,032.590.0095.516gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
132,717132,7171132,717.000.0095.51gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
146146249,7530.000.000.114f5mjr4hnaz3u PYUSLV declare begin pay_archive.proc...
146146249,8130.000.000.115sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio...
132132249,8800.000.000.097d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r...
1261263,123,5330.000.000.096v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
3939249,8880.000.000.03g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(ACT ...
2323249,6920.000.000.024ds53shhfcynn PYUSLV declare begin hr_pre_pay.do_pr...
13134,240,1790.000.000.016500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...

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,879,14644,106,2151.53911.4798.704gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_NO...
14,839,97314,845,1421.00266.0899.7077d28bpwm9svg PYUSLV SELECT PBV.RUN_BALANCE_STATUS,...
14,838,14914,833,1871.00336.94100.10cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, 'N...
13,844,64913,840,2571.00298.73100.609wupzu1crbdbb PYUSLV SELECT RO.TEXT, RO.OPTIMIZER_H...
13,839,11713,831,6021.00390.08100.30grg3zu94xp62h PYUSLV SELECT PDB.BALANCE_TYPE_ID, PD...
10,975,94810,968,8511.00468.05100.7002k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID...
6,492,8166,494,0731.00165.10100.805p88n2zhuqfd9 PYUSLV SELECT PPA.EFFECTIVE_DATE, PPA...
4,240,17900.00257.7699.906500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, PA...
3,995,6153,988,9921.001,302.5798.80g2daxnc5b7rav PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,745,4313,738,0201.001,004.4098.707rks7t2gukcwn PYUSLV SELECT /*+ ORDERED */ fnd_numb...
3,123,5333,122,9651.00587.5993.1.16v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA...
3,121,38200.00200.47100.50bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ...
2,746,5002,740,2171.001,016.6498.70dz7tyjxnar7gt 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
4026,9960.952450j0nxcnga5 ICM@db1.oasb.cisco (TNS V1-V3) declare sql_dummy1 boolean;beg...
3522,7900.83bb8xj89g0aq9q RUNGEN select parameter_value into :b...
3323320.789gut0j2v6npp7 PYUSLV select 'X' into :b0 from Fnd_C...
28314,7650.670wmwsjy9kd92f ICM@db1.oasb.cisco (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
2778,9450.658w57t3xaxs89k ICM@db1.oasb.cisco (TNS V1-V3) SELECT NAME, VERSION FROM FND_...
27511,8700.657qs7fx89194u1 ICM@db1.oasb.cisco (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
2714,5840.6455dc767ajydh3 e::cp:30 SELECT PROFILE_OPTION_VALUE FR...
2657580.639w141c6p8f5gu e::cp:30 declare alt_dummy1 boolean;beg...
2653780.63gvrx5h0ynb5f7 e::cp:30 begin :release := fnd_release....
2462460.581v717nvrhgbn9 sqlplus@db1.oasb.cisco (TNS V1-V3) SELECT USER FROM SYS.DUAL

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01pkua627ktjkSELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y')
02k10jzw8c495SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
0wmwsjy9kd92fSELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
1v717nvrhgbn9SELECT USER FROM SYS.DUAL
2450j0nxcnga5declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
2tr0101sa3jh2BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T5, :I5, :T4, :I4, :T6, :I6, :N5, :T8, :I8, :N4, :N3, :T3, :I3, :T7, :I7, :FFERLN, :FFERCD, :FFERMT); END;
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
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
55dc767ajydh3SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
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;
5ts0t88sz97xsSELECT PDB.DEFINED_BALANCE_ID FROM PAY_DEFINED_BALANCES PDB, PAY_BALANCE_DIMENSIONS PBD WHERE PDB.BALANCE_TYPE_ID = :B3 AND PBD.DATABASE_ITEM_SUFFIX = :B2 AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID AND ((PBD.LEGISLATION_CODE = :B1 AND PBD.BUSINESS_GROUP_ID IS NULL) OR (PBD.LEGISLATION_CODE IS NULL AND PBD.BUSINESS_GROUP_ID IS NOT NULL))
5zaw8dzwggxxa select paa.rowid from (select /*+ ORDERED */paa1.assignment_action_id, hou.name, ppf.last_name, ppf.first_name from pay_payroll_actions ppa1, pay_assignment_actions paa1, per_assignments_f paf, hr_organization_units hou, per_people_f ppf where paa1.object_type is null and paa1.payroll_action_id = ppa1.payroll_action_id and paa1.payroll_action_id = :pactid and paa1.assignment_id = paf.assignment_id and ppa1.effective_date between paf.effective_start_date and paf.effective_end_date and paf.person_id = ppf.person_id and ppa1.effective_date between ppf.effective_start_date and ppf.effective_end_date and paf.organization_id = hou.organization_id union all select paa1.assignment_action_id, hou.name, null, null from hr_organization_units hou, pay_assignment_actions paa1 where paa1.object_type = 'HOU' and paa1.object_id = hou.organization_id and paa1.payroll_action_id = :pactid ) un, pay_assignment_actions paa where paa.payroll_action_id = :pactid and paa.assignment_action_id = un.assignment_action_id order by un.name, un.last_name, un.first_name for update of paa.assignment_id
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
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6v07302134wyfINSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
77d28bpwm9svgSELECT PBV.RUN_BALANCE_STATUS, PBV.BALANCE_LOAD_DATE FROM PAY_BALANCE_VALIDATION PBV WHERE PBV.DEFINED_BALANCE_ID = :B2 AND PBV.BUSINESS_GROUP_ID = :B1
7d66dw0vz7yaabegin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7qs7fx89194u1SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
7rks7t2gukcwnSELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') /* Within Jurisdiction */ and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
8v2cvg5zhw9uaSELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
8w57t3xaxs89kSELECT NAME, VERSION FROM FND_CACHE_VERSIONS
9gut0j2v6npp7select 'X' into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 for update of Status_Code
9jv68n0ctas75begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
9w141c6p8f5gudeclare alt_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, alt_dummy1);end;
9wupzu1crbdbbSELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1
bb8xj89g0aq9qselect parameter_value into :b0 from pay_action_parameters where ((parameter_name=:b1 or parameter_name=REPLACE(:b1, ' ', '_')) or parameter_name=REPLACE(:b1, '_', ' '))
bm8gwn43tn8hdSELECT PLB.LATEST_BALANCE_ID, PLB.ASSIGNMENT_ACTION_ID, PLB.VALUE, PLB.EXPIRY_DATE, ACT.ACTION_SEQUENCE CURRENT_ACTION_SEQ, OWN_ACT.ACTION_SEQUENCE OWNER_ACTION_SEQ, PACT.EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE, PLB.EXPIRED_ASSIGNMENT_ACTION_ID, PLB.EXPIRED_VALUE, PLB.EXPIRED_DATE, PLB.PREV_ASSIGNMENT_ACTION_ID, PLB.PREV_BALANCE_VALUE, PLB.PREV_EXPIRY_DATE, PLB.TAX_UNIT_ID, PLB.JURISDICTION_CODE, PLB.ORIGINAL_ENTRY_ID, PLB.SOURCE_ID, PLB.SOURCE_TEXT, PLB.SOURCE_TEXT2, PLB.SOURCE_NUMBER, PLB.TAX_GROUP, PLB.PAYROLL_ID, PLB.LOCAL_UNIT_ID, PLB.ORGANIZATION_ID, PLB.SOURCE_NUMBER2 FROM PAY_LATEST_BALANCES PLB , PER_ALL_ASSIGNMENTS_F ASSIGN , PAY_ASSIGNMENT_ACTIONS ACT , PAY_PAYROLL_ACTIONS PACT , PAY_ASSIGNMENT_ACTIONS OWN_ACT WHERE PLB.DEFINED_BALANCE_ID = :B15 AND ACT.ASSIGNMENT_ACTION_ID = :B14 AND ASSIGN.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND EXISTS (SELECT '' FROM PAY_OBJECT_GROUPS POG WHERE POG.SOURCE_ID (+) = ACT.ASSIGNMENT_ID AND POG.SOURCE_TYPE (+) = 'PAF' AND NVL(PLB.PROCESS_GROUP_ID, NVL(POG.PARENT_OBJECT_GROUP_ID, -1)) = NVL(POG.PARENT_OBJECT_GROUP_ID, -1) ) AND PLB.PERSON_ID = ASSIGN.PERSON_ID AND NVL(PLB.ASSIGNMENT_ID, ACT.ASSIGNMENT_ID) = ACT.ASSIGNMENT_ID AND PACT.PAYROLL_ACTION_ID = ACT.PAYROLL_ACTION_ID AND PACT.EFFECTIVE_DATE BETWEEN ASSIGN.EFFECTIVE_START_DATE AND ASSIGN.EFFECTIVE_END_DATE AND OWN_ACT.ASSIGNMENT_ACTION_ID = PLB.ASSIGNMENT_ACTION_ID AND NVL(PLB.TAX_UNIT_ID, NVL(:B13 , -1)) = NVL(:B13 , -1) AND NVL(SUBSTR(NVL(PLB.JURISDICTION_CODE, NVL(:B12 , -1)), 1, :B11 ), -1) = NVL( SUBSTR(NVL(:B12 , -1), 1, :B11 ), -1) AND NVL(PLB.ORIGINAL_ENTRY_ID, NVL(:B10 , -1)) = NVL(:B10 , -1) AND NVL(PLB.SOURCE_ID, NVL(:B9 , -1)) = NVL(:B9 , -1) AND NVL(PLB.SOURCE_TEXT, NVL(:B8 , -1)) = NVL(:B8 , -1) AND NVL(PLB.SOURCE_TEXT2, NVL(:B7 , -1)) = NVL(:B7 , -1) AND NVL(PLB.SOURCE_NUMBER, NVL(:B6 , -1)) = NVL(:B6 , -1) AND NVL(PLB.TAX_GROUP, NVL(:B5 , -1)) = NVL(:B5 , -1) AND NVL(PLB.PAYROLL_ID, NVL(:B4 , -1)) = NVL(:B4 , -1) AND NVL(PLB.LOCAL_UNIT_ID, NVL(:B3 , -1)) = NVL(:B3 , -1) AND NVL(PLB.ORGANIZATION_ID, NVL(:B2 , -1)) = NVL(:B2 , -1) AND NVL(PLB.SOURCE_NUMBER2, NVL(:B1 , -1)) = NVL(:B1 , -1) ORDER BY PLB.LATEST_BALANCE_ID
brhrt8s5mn8kqSELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, DECODE(PST.SIT_EXEMPT, 'Y', 'Exempt', PTS.MEANING), PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS, PAY_US_EMP_STATE_TAX_RULES_F PST WHERE PTS.ASSIGNMENT_ID = :B3 AND PTS.JURISDICTION_CODE LIKE :B2 AND PST.JURISDICTION_CODE = PTS.JURISDICTION_CODE AND PST.ASSIGNMENT_ID = PTS.ASSIGNMENT_ID AND :B1 BETWEEN PST.EFFECTIVE_START_DATE AND PST.EFFECTIVE_END_DATE AND :B1 BETWEEN PTS.EFFECTIVE_START_DATE AND PTS.EFFECTIVE_END_DATE
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;
dz7tyjxnar7gtSELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and exists (select null from pay_taxability_rules TR , pay_element_types_f ET , pay_balance_types BT where ET.element_type_id = RR.element_type_id and PACT.date_earned between ET.effective_start_date and ET.effective_end_date and BT.balance_type_id = :U1 and TR.classification_id = ET.classification_id + 0 and TR.tax_category = ET.element_information1 and TR.tax_type = BT.tax_type and TR.jurisdiction_code = '00-000-0000' and nvl(TR.status, 'VALID') <> 'D' )
f78ff26qcfjanupdate PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S')
g2daxnc5b7ravSELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date
g4jp561h1bs98 select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id , to_char(null ) , PEPD.time_definition_id , nvl(ET.time_definition_type, 'N') , to_char(decode(ET.processing_type, 'R', to_date(null , :b1), EE.date_earned), :b1) , decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ) , decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ) , EE.label_identifier , decode(ACT.action_status, 'B', decode(EE.creator_type, 'EE', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b10, :b11:b12, EE.creator_id, ACT.action_sequence), 'RR', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b14, :b11:b16, EE.creator_id, ACT.action_sequence), 1), 1) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'AE', to_char(EE.source_start_date, :b1), 'AD', to_char(EE.source_start_date, :b1), null ) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'AE', to_char(EE.source_end_date, :b1), 'AD', to_char(EE.source_end_date, :b1), null ) from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where (((((((((((((((ACT.assignment_action_id=:b29 and EE.assignment_id=:b30) and ((:b31='N' and to_date(:b32, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b31='Y' and EE.effective_start_date<=to_date(:b32, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , decode(nvl(ET.time_definition_type, 'N'), 'N', to_date(:b32, :b1), pay_core_utils.get_time_period_start(ACT.payroll_action_id)), pay_interpreter_pkg.prorate_start_date(:b29, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b32, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.element_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b31='N' or ET.proration_group_id is null ) or (:b31='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b32, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ((((ET.processing_type='N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b32, :b1)) and not exists (select '' from p ay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
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
gvrx5h0ynb5f7begin :release := fnd_release.major_version;end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count320.020.00
Batched IO (full) vector count00.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count1600.100.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count320.020.00
Batched IO same unit count640.040.00
Batched IO single block count320.020.00
Batched IO vector block count640.040.00
Batched IO vector read count320.020.00
Block Cleanout Optim referenced274,511167.131.15
CCursor + sql area evicted00.000.00
CPU used by this session2,880,5761,753.8212.07
CPU used when call started2,879,0581,752.8912.06
CR blocks created9,433,2745,743.3839.52
Cached Commit SCN referenced39,24223.890.16
Commit SCN cached870,154529.793.65
DB time6,958,4084,236.5829.15
DBWR checkpoint buffers written1,699,9121,034.987.12
DBWR checkpoints10.000.00
DBWR revisited being-written buffer30.000.00
DBWR thread checkpoint buffers written304,634185.471.28
DBWR transaction table writes5930.360.00
DBWR undo block writes1,113,836678.154.67
DFO trees parallelized00.000.00
Effective IO time15,8239.630.07
HSC Heap Segment Block Changes17,818,24910,848.5274.65
Heap Segment Array Inserts2,087,1291,270.738.74
Heap Segment Array Updates106,43464.800.45
IMU CR rollbacks1,602,213975.506.71
IMU Flushes148,32290.300.62
IMU Redo allocation size1,805,167,2241,099,063.807,562.40
IMU commits90,76855.260.38
IMU contention63,65138.750.27
IMU ktichg flush2020.120.00
IMU recursive-transaction flush5,3823.280.02
IMU undo allocation size3,401,900,7362,071,224.1414,251.60
LOB table id lookup cache misses00.000.00
Number of read IOs issued40.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations downgraded 50 to 75 pct00.000.00
Requests to/from client21,708,78213,217.2490.94
RowCR - row contention121,95174.250.51
RowCR attempts10,327,5656,287.8743.27
RowCR hits10,190,5406,204.4442.69
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client21,708,78913,217.2590.94
active txn count during cleanout55,877,54834,020.67234.09
application wait time103,23762.860.43
background checkpoints completed10.000.00
background checkpoints started10.000.00
background timeouts9,0725.520.04
branch node splits8950.540.00
buffer is not pinned count1,677,216,0631,021,161.607,026.37
buffer is pinned count892,811,445543,582.183,740.26
bytes received via SQL*Net from client5,782,199,4023,520,452.8124,223.40
bytes sent via SQL*Net to client3,273,180,1091,992,853.4613,712.35
calls to get snapshot scn: kcmgss220,738,948134,395.41924.74
calls to kcmgas11,682,6667,112.9148.94
calls to kcmgcs11,749,6487,153.6949.22
cell physical IO interconnect bytes38,744,126,46423,589,098.09162,311.02
change write time31,98919.480.13
cleanout - number of ktugct calls11,348,2006,909.2747.54
cleanouts and rollbacks - consistent read gets8,997,4675,478.0537.69
cleanouts only - consistent read gets219,471133.620.92
cluster key scan block gets4,5872.790.02
cluster key scans2,2041.340.01
commit batch/immediate performed40,23124.490.17
commit batch/immediate requested40,23124.490.17
commit cleanout failures: block lost4040.250.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure651,351396.572.73
commit cleanout failures: cannot pin65,19139.690.27
commit cleanouts5,647,2723,438.3023.66
commit cleanouts successfully completed4,930,3263,001.8020.65
commit immediate performed40,23124.490.17
commit immediate requested40,23124.490.17
commit txn count during cleanout2,757,5441,678.9111.55
concurrency wait time82,43850.190.35
consistent changes508,416,485309,545.922,129.91
consistent gets2,752,984,8981,676,136.1511,533.10
consistent gets - examination1,925,702,2671,172,450.748,067.36
consistent gets direct40.000.00
consistent gets from cache2,752,984,8941,676,136.1411,533.10
consistent gets from cache (fastpath)770,410,241469,059.043,227.48
cursor authentications1270.080.00
data blocks consistent reads - undo records applied508,065,120309,332.002,128.44
db block changes135,989,36382,796.20569.70
db block gets173,327,072105,529.01726.12
db block gets direct310.020.00
db block gets from cache173,327,041105,528.99726.12
db block gets from cache (fastpath)32,222,11519,618.22134.99
deferred (CURRENT) block cleanout applications306,324186.501.28
dirty buffers inspected10.000.00
doubling up with imu segment00.000.00
enqueue conversions3880.240.00
enqueue releases2,252,2781,371.289.44
enqueue requests2,254,6631,372.749.45
enqueue timeouts2,3851.450.01
enqueue waits550,426335.122.31
exchange deadlocks419,651255.501.76
execute count232,419,525141,507.05973.68
failed probes on index block reclamation2240.140.00
file io service time00.000.00
file io wait time138,609,206,17584,391,273.19580,676.43
free buffer inspected1,700,3361,035.247.12
free buffer requested11,859,4077,220.5249.68
heap block compress249,692152.021.05
hot buffers moved to head of LRU909,277553.613.81
immediate (CR) block cleanout applications9,217,0465,611.7438.61
immediate (CURRENT) block cleanout applications854,139520.043.58
in call idle wait time10,774,4096,559.9345.14
index crx upgrade (positioned)5,1763.150.02
index fast full scans (full)10.000.00
index fetch by key403,166,046245,464.911,688.99
index scans kdiixs1337,211,999205,309.231,412.68
java call heap collected bytes00.000.00
java call heap collected count00.000.00
java call heap gc count00.000.00
java call heap live object count00.000.00
java call heap live object count max00.000.00
java call heap live size00.000.00
java call heap live size max00.000.00
java call heap object count00.000.00
java call heap object count max00.000.00
java call heap total size00.000.00
java call heap total size max00.000.00
java call heap used size00.000.00
java call heap used size max00.000.00
java session heap live size00.000.00
java session heap live size max00.000.00
java session heap used size00.000.00
java session heap used size max00.000.00
leaf node 90-10 splits42,27025.740.18
leaf node splits229,017139.440.96
lob reads30.000.00
lob writes870.050.00
lob writes unaligned870.050.00
logical read bytes from cache23,969,092,894,72014,593,419,315.01100,413,873.70
logons cumulative3210.200.00
max cf enq hold time1500.090.00
messages received371,995226.491.56
messages sent371,995226.491.56
min active SCN optimization applied on CR25,411,51515,471.63106.46
no buffer to keep pinned count2,2401.360.01
no work - consistent read gets777,297,755473,252.463,256.34
non-idle wait count32,899,51620,030.65137.83
non-idle wait time272,712166.041.14
opened cursors cumulative220,124,525134,021.32922.17
parse count (describe)40.000.00
parse count (failures)00.000.00
parse count (hard)440.030.00
parse count (total)42,30025.750.18
parse time cpu47,44128.880.20
parse time elapsed55,52333.800.23
physical read IO requests138,96284.610.58
physical read bytes1,188,790,272723,786.884,980.21
physical read total IO requests166,716101.500.70
physical read total bytes1,640,710,144998,935.226,873.44
physical read total multi block requests2350.140.00
physical reads145,11688.350.61
physical reads cache140,07085.280.59
physical reads cache prefetch2,0151.230.01
physical reads direct5,0463.070.02
physical reads direct (lob)40.000.00
physical reads direct temporary tablespace4,2782.600.02
physical reads prefetch warmup00.000.00
physical write IO requests385,652234.801.62
physical write bytes13,963,788,2888,501,757.6058,498.59
physical write total IO requests806,649491.123.38
physical write total bytes37,103,416,32022,590,162.87155,437.58
physical write total multi block requests112,59568.550.47
physical writes1,704,5641,037.817.14
physical writes direct4,6512.830.02
physical writes direct (lob)310.020.00
physical writes direct temporary tablespace4,2782.600.02
physical writes from cache1,699,9131,034.987.12
physical writes non checkpoint1,404,855855.345.89
pinned buffers inspected4290.260.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use5,4423.310.02
prefetched blocks aged out before use1,4540.890.01
process last non-idle time84,55051.480.35
queries parallelized00.000.00
recursive aborts on index block reclamation10.000.00
recursive calls408,645,014248,800.741,711.94
recursive cpu usage2,608,4351,588.1310.93
redo blocks checksummed by FG (exclusive)11,646,8097,091.0848.79
redo blocks written45,167,89827,500.17189.22
redo entries69,661,27742,412.80291.83
redo ordering marks911,398554.903.82
redo size22,263,556,99213,555,015.3793,268.86
redo size for direct writes1,5600.950.01
redo subscn max counts1,724,2551,049.807.22
redo synch long waits6380.390.00
redo synch time8,0344.890.03
redo synch time (usec)80,587,14149,064.93337.60
redo synch writes93,26556.780.39
redo wastage105,360,13664,147.80441.39
redo write time15,6489.530.07
redo writes255,867155.781.07
rollback changes - undo records applied173,467105.610.73
rollbacks only - consistent read gets359,260218.731.51
rows fetched via callback305,404,205185,943.271,279.43
session connect time00.000.00
session cursor cache hits5,837,9283,554.3824.46
session logical reads2,926,311,9701,781,665.1612,259.22
shared hash latch upgrades - no wait27,049,82916,469.10113.32
shared hash latch upgrades - wait1,231,198749.615.16
sorts (disk)00.000.00
sorts (memory)14,820,4079,023.3062.09
sorts (rows)28,157,22917,143.34117.96
sql area evicted00.000.00
sql area purged00.000.00
summed dirty queue length10.000.00
switch current to new buffer704,815429.122.95
table fetch by rowid962,398,816585,949.984,031.78
table fetch continued row9,1055.540.04
table scan blocks gotten86,098,32352,420.38360.69
table scan rows gotten460,739,922280,518.371,930.18
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)10,516,5466,402.9344.06
temp space allocated (bytes)00.000.00
total cf enq hold time8600.520.00
total number of cf enq holders700.040.00
total number of times SMON posted990.060.00
transaction rollbacks40,23124.490.17
transaction tables consistent read rollbacks20.000.00
transaction tables consistent reads - undo records applied280.020.00
undo change vector size8,233,000,7685,012,606.5734,490.56
user I/O wait time45,43527.660.19
user calls23,137,68614,087.2296.93
user commits237,034144.320.99
user rollbacks1,6691.020.01
workarea executions - onepass80.000.00
workarea executions - optimal9,903,6706,029.7841.49
write clones created in foreground2130.130.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current232240
session uga memory max18,767,131,87220,010,377,240
session pga memory13,348,280,54413,427,122,368
session pga memory max14,064,397,79214,166,504,896
session cursor cache count434,035461,206
session uga memory22,141,951,493,56822,257,931,707,704
opened cursors current5,6405,526
workarea memory allocated4,4524,452

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.000M21.5G255.8113.4280255.9K0.19
DBWR0M0.000M13G234.448.084820 
Buffer Cache Reads1.1G84.06.6666830M0.000M138.1K2.30
Others432M16.90.26302013M0.53.00791428.6K0.10
Direct Reads40M0.55.0243532M0.18.0012170 
Direct Writes0M0.000M33M0.11.0200910 
TOTAL:1.5G101.51.95405734.6G491.0721.5420422.5K0.87

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.000M21.5G255.8113.4280  
Data File1.1G84.74.65998613G234.718.084822.323.90
Control File428M16.69.26058413M0.51.0079140.05 
Temp File33M0.08.02009133M0.08.020091 0.04
TOTAL:1.5G101.51.94066234.6G491.1221.54081.951.63

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.000M21.5G255.8113.42800 
LGWR (Log File) 0M0.000M21.5G255.8113.42800 
DBWR 0M0.000M13G234.448.084820 
DBWR (Data File) 0M0.000M13G234.448.084820 
Buffer Cache Reads 1.1G84.06.6666830M0.000M138.1K2.30
Buffer Cache Reads (Data File) 1.1G84.06.6666830M0.000M138.1K2.30
Others 431M16.90.26241113M0.53.00791427.8K0.08
Others (Control File) 428M16.69.26058413M0.51.00791427.4K0.05
Others (Data File) 3M0.21.0018260M0.020M3422.86
Direct Reads 40M0.55.0243532M0.18.0012170 
Direct Reads (Data File) 40M0.55.0243532M0.18.0012170 
Direct Writes 0M0.000M33M0.11.0200910 
Direct Writes (Data File) 0M0.000M33M0.11.0200910 
TOTAL: 1.5G101.51.95344834.6G491.0721.5420165.8K1.93

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_UNDOTS1 2300.001.00221,366135386,7590.03
APPS_TS_TX_IDX 40,017243.381.0088,066542,576,0400.11
APPS_TS_TX_DATA 40,828252.861.0575,21246380,8730.15
APPS_TS_INTERFACE 18,820112.411.0037000.00
APPS_TS_SUMMARY 10,03262.651.0016000.00
APPS_TS_SEED 7,48153.271.012504748.65
APPS_TS_ARCHIVE 4,31231.501.00520460.65
SYSAUX 2,50220.391.00450000.00
HTMLDB 2,82320.311.001000.00
SYSTEM 2,00610.301.0018805530.13
IAS_META 1,48710.221.001000.00
XDB 1,36512.151.001000.00
APPS_TS_QUEUES 1,08310.411.0013000.00
B2B_DT 97610.301.001000.00
SYNCSERVER 81000.171.001000.00
B2B_RT 61301.261.001000.00
NON_APPS_TS_DATA 48701.011.001000.00
APPS_TS_DISCO 39901.801.003000.00
APPS_CALCLIP 33902.921.004000.00
APPS_TS_NOLOGGING 31801.701.004000.00
TEMP1 13800.0031.00138000.00
B2B_IDX 23100.611.001000.00
ODM_DATA 22300.451.001000.00
GEOR_TBS 18802.181.002000.00
UDDISYS_TS 18700.211.001000.00
ORABPEL 18601.341.001000.00
B2B_LOB 17300.291.001000.00
OLTS_CT_STORE 11700.941.001000.00
CTXSYS 10900.281.001000.00
DSGATEWAY_TAB 9000.221.001000.00
APPS_TS_MEDIA 8102.591.007000.00
OPMOR 6000.171.001000.00
RE 5700.181.001000.00
APPS_TS_DISCO_OLAP 4600.221.001000.00
BAM 4003.251.001000.00
DCM 3500.001.002000.00
OLTS_SVRMGSTORE 3600.281.001000.00
OCATS 3000.331.001000.00
APPS_TS_TOOLS 2900.001.001000.00
MTR 2900.001.001000.00
WCRSYS_TS 2900.001.001000.00
DISCO_PTM5_CACHE 2301.741.001000.00
DISCO_PTM5_META 2300.431.001000.00
OLTS_DEFAULT 2300.001.001000.00
PORTAL 1300.771.001000.00
APPS_OMO 1202.501.001000.00
OLTS_BATTRSTORE 702.861.001000.00
OLTS_ATTRSTORE 500.001.001000.00
CWMLITE 300.001.002000.00
PORTAL_DOC 300.001.001000.00
PORTAL_IDX 300.001.001000.00
PORTAL_LOG 300.001.001000.00
NOETIX 200.001.001000.00
OWAPUB 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_CALCLIP+DATA/vis/datafile/apps_calclip.424.788475687 11502.961.001000.00
APPS_CALCLIP+DATA/vis/datafile/apps_calclip.425.788475703 14103.051.001000.00
APPS_CALCLIP+DATA/vis/datafile/apps_calclip.479.788476341 7302.601.001000.00
APPS_CALCLIP+DATA/vis/datafile/apps_calclip.508.788476523 1003.001.001000.00
APPS_OMO+DATA/vis/datafile/apps_omo.494.788476449 1202.501.001000.00
APPS_TS_ARCHIVE+DATA/vis/datafile/apps_ts_archive.278.788473483 4,31231.501.00520460.65
APPS_TS_DISCO+DATA/vis/datafile/apps_ts_disco.269.788473347 100.001.001000.00
APPS_TS_DISCO+DATA/vis/datafile/apps_ts_disco.470.788476279 200.001.001000.00
APPS_TS_DISCO+DATA/vis/datafile/apps_ts_disco.478.788476335 39601.821.001000.00
APPS_TS_DISCO_OLAP+DATA/vis/datafile/apps_ts_disco_olap.456.788476171 4600.221.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.262.788473221 502.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.362.788474751 3902.821.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.363.788474767 1102.731.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.364.788474781 801.251.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.365.788474797 300.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.366.788474811 200.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.367.788474827 200.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.368.788474841 402.501.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.369.788474857 200.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.454.788476141 8,10152.131.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.471.788476285 300.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.519.788476557 1,11912.581.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.520.788476561 1,12812.461.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.521.788476563 1,14113.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.522.788476567 1,10013.031.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.528.788476585 1,13212.541.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.529.788476589 1,12112.491.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.530.788476591 1,06712.911.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.531.788476595 1,04812.051.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.532.788476597 1,13812.861.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.534.788476603 18201.151.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.536.788476611 17203.081.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.546.788476627 20002.801.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.561.788476643 500.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.568.788476651 205.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.569.788476651 303.331.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.570.788476653 300.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.571.788476655 502.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.572.788476655 600.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.573.788476657 400.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.574.788476657 601.671.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.575.788476659 502.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.576.788476659 3302.121.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.577.788476661 502.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.578.788476661 400.001.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.579.788476663 801.251.001000.00
APPS_TS_INTERFACE+DATA/vis/datafile/apps_ts_interface.580.788476663 303.331.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.462.788476221 4302.791.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.467.788476257 701.431.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.488.788476405 502.001.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.497.788476469 1004.001.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.539.788476619 702.861.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.540.788476621 200.001.001000.00
APPS_TS_MEDIA+DATA/vis/datafile/apps_ts_media.558.788476641 701.431.001000.00
APPS_TS_NOLOGGING+DATA/vis/datafile/apps_ts_nologging.277.788473467 29901.711.001000.00
APPS_TS_NOLOGGING+DATA/vis/datafile/apps_ts_nologging.378.788474993 402.501.001000.00
APPS_TS_NOLOGGING+DATA/vis/datafile/apps_ts_nologging.379.788475007 1001.001.001000.00
APPS_TS_NOLOGGING+DATA/vis/datafile/apps_ts_nologging.380.788475023 502.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.263.788473245 801.251.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.296.788473755 1701.181.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.297.788473769 1400.711.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.370.788474871 2100.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.371.788474887 1001.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.372.788474903 900.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.373.788474917 700.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.374.788474933 900.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.375.788474947 6100.491.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.376.788474963 1201.671.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.377.788474977 900.001.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.450.788476081 89910.381.001000.00
APPS_TS_QUEUES+DATA/vis/datafile/apps_ts_queues.493.788476441 700.001.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.266.788473301 10604.531.00104312.33
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.267.788473317 3005.331.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.268.788473331 2405.421.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.274.788473423 2,32813.361.01106310.48
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.275.788473437 4,49433.021.01103687.91
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.383.788475069 2304.781.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.384.788475083 2303.911.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.385.788475099 2105.241.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.386.788475113 2405.001.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.387.788475129 2103.811.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.388.788475143 2704.441.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.389.788475159 2603.851.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.390.788475173 2305.651.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.391.788475189 2603.461.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.392.788475205 2404.581.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.393.788475219 2504.801.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.394.788475235 2203.641.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.395.788475249 2503.601.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.396.788475265 2204.091.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.397.788475279 2605.001.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.398.788475295 2806.071.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.399.788475309 2705.561.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.400.788475325 3403.821.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.401.788475341 2404.581.001000.00
APPS_TS_SEED+DATA/vis/datafile/apps_ts_seed.402.788475355 2804.291.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.271.788473377 35102.791.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.272.788473391 16102.921.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.273.788473407 29302.871.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.276.788473453 27902.761.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.279.788473497 22702.731.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.280.788473513 30302.971.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.281.788473527 22102.531.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.282.788473543 13902.521.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.283.788473557 2,83822.701.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.284.788473573 51802.741.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.285.788473589 2,24612.441.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.286.788473603 57502.781.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.287.788473619 1,84112.621.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.381.788475039 2502.801.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.382.788475053 1302.311.001000.00
APPS_TS_SUMMARY+DATA/vis/datafile/apps_ts_summary.423.788475673 200.001.001000.00
APPS_TS_TOOLS+DATA/vis/datafile/apps_ts_tools.535.788476607 2900.001.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.290.788473663 3,02622.181.01896111,0950.12
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.291.788473679 3,03921.361.01843111,5020.21
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.292.788473693 3,03821.231.01878110,6210.12
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.293.788473709 3,05421.521.01872110,0980.22
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.302.788473845 5,25331.631.011000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.303.788473861 52503.601.081,73014,6050.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.304.788473875 4003.502.101,67913,9720.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.305.788473891 3705.412.221,76113,9560.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.306.788473905 2903.792.031,68815,4390.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.307.788473921 3603.891.831,70813,6970.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.308.788473935 4201.901.691,73313,6510.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.309.788473951 3603.611.831,72214,8440.04
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.310.788473965 3004.332.001,72215,3240.01
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.311.788473981 3306.361.911,78114,4960.01
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.312.788473995 3503.141.831,70914,0690.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.313.788474011 3206.251.941,73614,0410.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.314.788474027 2903.452.031,72415,8960.01
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.315.788474041 3408.241.881,66814,3550.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.316.788474057 2602.691.581,71613,4740.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.317.788474071 3604.441.421,69713,9420.04
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.318.788474087 2903.791.481,70816,1200.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.319.788474101 3405.881.441,685143,1270.05
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.320.788474117 3604.171.421,75414,9010.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.321.788474131 2704.071.561,73215,5860.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.322.788474147 3003.671.501,71816,0290.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.323.788474163 2804.291.541,70815,4680.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.324.788474177 4004.751.381,76815,3260.04
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.325.788474193 3703.511.411,71614,2220.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.326.788474207 1802.781.831,70015,8290.04
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.327.788474223 2703.701.561,70415,9600.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.328.788474237 2703.331.561,74715,3130.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.403.788475371 300.001.001,75213,5440.01
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.404.788475385 300.001.001,67115,2410.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.406.788475415 402.501.001,74313,9330.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.408.788475445 603.331.001,69514,1340.04
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.410.788475475 400.001.001,68913,7290.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.412.788475507 300.001.001,65915,5160.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.414.788475537 300.001.001,65115,3080.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.416.788475567 200.001.001,58415,4320.07
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.418.788475597 300.001.001,67914,2540.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.420.788475627 200.001.001,66115,1510.02
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.427.788475733 12304.391.55908111,5440.13
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.430.788475779 10804.721.70931112,7130.17
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.431.788475793 9505.471.79950111,4330.34
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.432.788475809 11904.451.73920111,6630.25
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.433.788475823 10803.981.68940111,6670.19
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.434.788475839 3,75224.231.0349504,7760.82
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.435.788475853 2,06713.431.03929111,6050.21
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.436.788475869 7,15643.941.019801,0051.40
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.437.788475883 1,05012.861.009201,0160.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.440.788475929 1,81813.411.0046103,9180.10
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.441.788475945 13102.671.002002670.04
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.448.788476049 6904.352.09938112,5600.17
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.451.788476095 3603.331.006808950.01
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.452.788476111 9104.511.8288819,7720.12
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.457.788476185 7104.232.03829110,0160.39
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.459.788476199 8904.491.8147003,4950.54
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.463.788476229 1,48714.321.072103037.36
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.490.788476419 32605.741.292802,0531.24
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.495.788476455 3702.971.00106210.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.502.788476505 6606.061.0030763.95
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.503.788476509 4205.001.00101445.97
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.504.788476511 1204.171.0010933.33
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.505.788476515 6504.151.00101834.97
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.506.788476517 1605.001.00401217.52
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.507.788476521 3004.001.00401217.60
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.509.788476527 2703.701.00505,0250.01
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.510.788476529 6506.311.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.511.788476533 902.221.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.512.788476535 806.251.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.513.788476539 903.331.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.514.788476543 10402.881.00200550.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.515.788476545 9203.261.00220360.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.516.788476549 11603.881.006303101.90
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.517.788476551 2,25312.901.0017060.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.518.788476555 15802.971.0017050.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.524.788476573 705.711.0040762.89
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.525.788476577 1704.121.00301247.50
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.526.788476579 303.331.00103219.38
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.527.788476583 904.441.0020705.29
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.542.788476623 601.671.005000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.544.788476625 402.501.006030.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.547.788476629 100.001.006020.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.548.788476629 402.501.006000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.549.788476631 603.331.005000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.550.788476631 601.671.006000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.551.788476633 402.501.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.552.788476633 1802.221.007050.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.554.788476635 200.001.00901360.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.555.788476637 300.001.004010.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.556.788476637 15103.251.00802860.03
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.562.788476645 300.001.001000.00
APPS_TS_TX_DATA+DATA/vis/datafile/apps_ts_tx_data.565.788476647 300.001.001000.00
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.264.788473271 8703.331.001,618154,3370.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.294.788473725 43602.451.006,17646,7610.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.295.788473739 43102.201.006,36247,2970.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.301.788473829 34704.011.006,819418,9060.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.329.788474253 1,44611.661.002201200.00
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.330.788474267 16003.001.001,587144,5780.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.331.788474283 9404.471.001,638162,9250.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.332.788474299 9902.931.001,595161,4870.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.333.788474313 10002.901.001,649164,5400.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.334.788474329 14702.451.001,624163,9890.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.335.788474343 8002.751.001,640162,9830.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.336.788474359 23901.841.001,600160,0090.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.337.788474373 21902.601.001,634161,2370.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.338.788474389 7402.571.001,651161,0840.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.339.788474403 8003.251.001,681162,8020.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.340.788474419 7402.571.001,658159,1030.08
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.341.788474435 8302.531.001,643156,9360.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.342.788474449 8202.561.001,690157,6160.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.343.788474465 7402.701.001,606155,2750.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.344.788474479 7402.571.001,596156,2580.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.345.788474495 8002.881.001,552154,7350.07
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.346.788474509 7202.641.001,563154,8600.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.347.788474525 7303.421.001,639155,8020.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.348.788474539 7803.971.001,566157,2080.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.349.788474555 6903.191.001,577156,2120.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.350.788474569 6802.651.001,556153,3640.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.351.788474585 8603.721.001,529152,9430.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.352.788474601 8703.101.001,487152,3160.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.353.788474615 10003.101.001,504157,5300.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.354.788474631 9903.431.001,524158,8020.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.355.788474645 6904.351.001,555160,9440.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.356.788474661 7303.291.001,552158,0650.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.357.788474675 7403.241.001,544159,0710.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.358.788474691 7902.661.001,504158,2160.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.359.788474705 8203.661.001,551159,9630.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.360.788474721 8002.751.001,608162,7990.12
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.361.788474735 9203.701.001,595162,1690.13
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.405.788475401 5402.221.001,527157,7780.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.407.788475431 5701.581.001,522157,4340.08
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.409.788475461 5201.921.001,477154,2020.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.411.788475491 5101.961.001,495158,3700.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.413.788475521 5002.201.001,485159,9440.08
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.415.788475551 5102.161.001,510159,1250.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.417.788475581 5001.801.001,499157,3360.11
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.419.788475613 5301.511.001,472154,9810.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.421.788475643 4902.241.001,478158,5130.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.422.788475657 5001.801.001,505160,5950.10
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.439.788475913 85912.561.001408014.73
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.442.788475959 8,50053.391.005907014.31
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.443.788475975 5,97743.421.008604644.29
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.444.788475989 41502.141.00804019.13
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.449.788476065 1,15413.791.0018408,0490.28
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.455.788476155 8603.491.0015507,1460.27
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.460.788476207 91114.341.001201637.73
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.461.788476215 5,24633.761.005602091.44
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.472.788476293 34701.701.00101361.99
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.480.788476349 20103.931.003201103.09
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.481.788476357 3,30523.891.001602916.15
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.482.788476363 76303.361.00501626.73
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.483.788476371 17203.081.004202055.27
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.484.788476377 1,09913.691.003402907.21
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.485.788476385 2,57123.991.00170300.00
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.486.788476391 16103.171.00209310.00
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.487.788476399 19103.821.0080594.92
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.489.788476413 806.251.004701299.46
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.491.788476427 15803.351.003024811.25
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.492.788476435 15103.251.00502411.87
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.496.788476463 8803.641.00209310.00
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.498.788476477 1403.571.00502120.00
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.499.788476483 61502.931.00250235.22
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.500.788476491 19803.231.00420112.73
APPS_TS_TX_IDX+DATA/vis/datafile/apps_ts_tx_idx.501.788476497 52303.331.00341024,2530.20
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.257.788473095 300.001.0016,1361042,7190.03
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.258.788473121 300.001.0021,2811338,1190.03
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.259.788473145 300.001.0028,2061733,6780.02
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.260.788473171 200.001.0027,1341740,8390.02
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.261.788473195 100.001.0027,8691743,5420.03
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.289.788473649 200.001.0033,8812137,1930.02
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.298.788473785 300.001.0031,3751936,7790.03
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.299.788473799 300.001.0021,0651367,9030.02
APPS_UNDOTS1+DATA/vis/datafile/apps_undots1.300.788473815 300.001.0014,419945,9870.02
B2B_DT+DATA/vis/datafile/b2b_dt.553.788476635 97610.301.001000.00
B2B_IDX+DATA/vis/datafile/b2b_idx.582.788476667 23100.611.001000.00
B2B_LOB+DATA/vis/datafile/b2b_lob.586.788476671 17300.291.001000.00
B2B_RT+DATA/vis/datafile/b2b_rt.563.788476645 61301.261.001000.00
BAM+DATA/vis/datafile/bam.589.788476673 4003.251.001000.00
CTXSYS+DATA/vis/datafile/ctxsys.265.788473287 10900.281.001000.00
CWMLITE+DATA/vis/datafile/cwmlite.581.788476665 100.001.001000.00
CWMLITE+DATA/vis/datafile/cwmlite.599.788476685 200.001.001000.00
DCM+DATA/vis/datafile/dcm.541.788476621 3200.001.001000.00
DCM+DATA/vis/datafile/dcm.566.788476649 300.001.001000.00
DISCO_PTM5_CACHE+DATA/vis/datafile/disco_ptm5_cache.545.788476625 2301.741.001000.00
DISCO_PTM5_META+DATA/vis/datafile/disco_ptm5_meta.594.788476679 2300.431.001000.00
DSGATEWAY_TAB+DATA/vis/datafile/dsgateway_tab.591.788476675 9000.221.001000.00
GEOR_TBS+DATA/vis/datafile/geor_tbs.428.788475747 17702.151.001000.00
GEOR_TBS+DATA/vis/datafile/geor_tbs.533.788476601 1102.731.001000.00
HTMLDB+DATA/vis/datafile/htmldb.523.788476569 2,82320.311.001000.00
IAS_META+DATA/vis/datafile/ias_meta.537.788476613 1,48710.221.001000.00
MTR+DATA/vis/datafile/mtr.593.788476679 2900.001.001000.00
NOETIX+DATA/vis/datafile/noetix.557.788476639 200.001.001000.00
NON_APPS_TS_DATA+DATA/vis/datafile/non_apps_ts_data.538.788476617 48701.011.001000.00
OCATS+DATA/vis/datafile/ocats.596.788476681 3000.331.001000.00
ODM_DATA+DATA/vis/datafile/odm_data.466.788476249 22300.451.001000.00
OLTS_ATTRSTORE+DATA/vis/datafile/olts_attrstore.583.788476667 500.001.001000.00
OLTS_BATTRSTORE+DATA/vis/datafile/olts_battrstore.584.788476669 702.861.001000.00
OLTS_CT_STORE+DATA/vis/datafile/olts_ct_store.590.788476675 11700.941.001000.00
OLTS_DEFAULT+DATA/vis/datafile/olts_default.597.788476683 2300.001.001000.00
OLTS_SVRMGSTORE+DATA/vis/datafile/olts_svrmgstore.598.788476683 3600.281.001000.00
OPMOR+DATA/vis/datafile/opmor.592.788476677 6000.171.001000.00
ORABPEL+DATA/vis/datafile/orabpel.585.788476669 18601.341.001000.00
OWAPUB+DATA/vis/datafile/owapub.464.788476235 100.001.001000.00
PORTAL+DATA/vis/datafile/portal.469.788476271 1300.771.001000.00
PORTAL_DOC+DATA/vis/datafile/portal_doc.564.788476647 300.001.001000.00
PORTAL_IDX+DATA/vis/datafile/portal_idx.559.788476641 300.001.001000.00
PORTAL_LOG+DATA/vis/datafile/portal_log.560.788476643 300.001.001000.00
RE+DATA/vis/datafile/re.588.788476673 5700.181.001000.00
SYNCSERVER+DATA/vis/datafile/syncserver.465.788476243 81000.171.001000.00
SYSAUX+DATA/vis/datafile/sysaux.468.788476263 1,61210.371.00253000.00
SYSAUX+DATA/vis/datafile/sysaux.473.788476299 83310.371.00123000.00
SYSAUX+DATA/vis/datafile/sysaux.474.788476307 2402.501.0018000.00
SYSAUX+DATA/vis/datafile/sysaux.475.788476313 300.001.0025000.00
SYSAUX+DATA/vis/datafile/sysaux.476.788476321 1400.001.0012000.00
SYSAUX+DATA/vis/datafile/sysaux.477.788476327 1601.251.0019000.00
SYSTEM+DATA/vis/datafile/system.270.788473361 8100.491.0042010.00
SYSTEM+DATA/vis/datafile/system.288.788473633 28900.241.001205340.02
SYSTEM+DATA/vis/datafile/system.426.788475717 4000.251.001000.00
SYSTEM+DATA/vis/datafile/system.429.788475763 55800.301.0057063.33
SYSTEM+DATA/vis/datafile/system.438.788475899 9600.421.005020.00
SYSTEM+DATA/vis/datafile/system.445.788476005 59100.291.0018061.67
SYSTEM+DATA/vis/datafile/system.446.788476019 22300.181.0025000.00
SYSTEM+DATA/vis/datafile/system.447.788476035 1300.771.0010010.00
SYSTEM+DATA/vis/datafile/system.453.788476125 9300.221.00100110.00
SYSTEM+DATA/vis/datafile/system.458.788476193 2201.361.0080210.00
TEMP1+DATA/vis/tempfile/temp1.601.788536329 7600.0031.007600 
TEMP1+DATA/vis/tempfile/temp1.602.788536329 4300.0031.004300 
TEMP1+DATA/vis/tempfile/temp1.604.788536329 1900.0031.001900 
UDDISYS_TS+DATA/vis/datafile/uddisys_ts.567.788476649 18700.211.001000.00
WCRSYS_TS+DATA/vis/datafile/wcrsys_ts.595.788476681 2900.001.001000.00
XDB+DATA/vis/datafile/xdb.543.788476623 1,36512.151.001000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D3,029,7601002,896,834,280140,0691,699,913003,345,107

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,394,819304,634

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
B01846720233397383033973830    
E037822510656734803397383033973830    

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,4320.103001.852,63213540.00
D4,8640.206001.662,36313055.00
D7,2960.308991.422,01812431.00
D9,7280.401,1991.271,80212042.00
D12,1600.491,4991.161,65511776.00
D14,5920.591,7991.111,58111642.00
D17,0240.692,0991.081,53011550.00
D19,4560.792,3991.011,43211372.00
D21,8880.892,6981.001,42211355.00
D24,3200.992,9981.001,42211354.00
D24,5761.003,0301.001,42211354.00
D26,7521.093,2981.001,42211354.00
D29,1841.193,5981.001,42211354.00
D31,6161.293,8981.001,42211354.00
D34,0481.394,1971.001,42211354.00
D36,4801.484,4971.001,42211354.00
D38,9121.584,7971.001,42211354.00
D41,3441.685,0971.001,42211354.00
D43,7761.785,3971.001,42211354.00
D46,2081.885,6971.001,42211354.00
D48,6401.985,9961.001,41911349.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.6420,262279

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B10,2408,4091,139.144.350.38100.000.001,048,570
E10,2408,3981,150.034.350.38100.000.001,048,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K9,764,7999,764,79900
64K128K8800
128K256K383800
256K512K4400
512K1024K45245200
1M2M252500
2M4M7700
4M8M252500
8M16M232300
16M32M2020
32M64M8260

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
1,2800.1363,483.670.00100.0002,285,719
2,5600.2563,483.670.00100.0002,285,719
5,1200.5063,483.670.00100.0002,285,719
7,6800.7563,483.670.00100.0002,285,719
10,2401.0063,483.670.00100.0002,285,719
12,2881.2063,483.670.00100.0002,285,719
14,3361.4063,483.670.00100.0002,285,719
16,3841.6063,483.670.00100.0002,285,719
18,4321.8063,483.670.00100.0002,285,719
20,4802.0063,483.670.00100.0002,285,719
30,7203.0063,483.670.00100.0002,285,719
40,9604.0063,483.670.00100.0002,285,719
61,4406.0063,483.670.00100.0002,285,719
81,9208.0063,483.670.00100.0002,285,719

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)
4,0320.8029215,6895,100,7801.001,7191.00271,113
4,4160.8729215,6895,100,7801.001,7191.00271,113
4,4800.8929215,6895,100,7801.001,7191.00271,113
4,5440.9029215,6895,100,7801.001,7191.00271,113
4,6080.9129215,6895,100,7801.001,7191.00271,113
4,6720.9229215,6895,100,7801.001,7191.00271,113
4,7360.9429215,6895,100,7801.001,7191.00271,113
4,8000.9529215,6895,100,7801.001,7191.00271,113
4,8640.9629215,6895,100,7801.001,7191.00271,113
4,9280.9729215,6895,100,7801.001,7191.00271,113
4,9920.9929215,6895,100,7801.001,7191.00271,113
5,0561.0029215,6895,100,7801.001,7191.00271,115
5,1201.0129215,6895,100,7801.001,7191.00271,115
5,1841.0329215,6895,100,7801.001,7191.00271,115
5,2481.0429215,6895,100,7801.001,7191.00271,115
5,3121.0529215,6895,100,7801.001,7191.00271,115
5,3761.0629215,6895,100,7801.001,7191.00271,115
5,4401.0829215,6895,100,7801.001,7191.00271,115
5,5041.0929215,6895,100,7801.001,7191.00271,115
5,5681.1029215,6895,100,7801.001,7191.00271,115
5,6321.1129215,6895,100,7801.001,7191.00271,115
6,0801.2029215,6895,100,7801.001,7191.00271,115
6,5921.3029215,6895,100,7801.001,7191.00271,115
7,1041.4129215,6895,100,7801.001,7191.00271,115
7,6161.5129215,6895,100,7801.001,7191.00271,115
8,1281.6129215,6895,100,7801.001,7191.00271,115
8,6401.7129215,6895,100,7801.001,7191.00271,115
9,1521.8129215,6895,100,7801.001,7191.00271,115
9,6641.9129215,6895,100,7801.001,7191.00271,115
10,1762.0129215,6895,100,7801.001,7191.00271,115

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
7,6800.2578,1732,631,391
11,5200.3877,6872,362,992
15,3600.5076,6691,802,026
19,2000.6376,2741,581,109
23,0400.7576,1831,530,216
26,8800.8875,9851,422,031
30,7201.0075,9851,421,605
34,5601.1375,9851,421,605
38,4001.2575,9851,421,605
42,2401.3875,9851,421,605
46,0801.5075,9851,421,605
49,9201.6375,9851,421,605
53,7601.7575,9771,418,620
57,6001.8875,9771,418,620
61,4402.0075,9771,418,620

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

Java Pool Size(M)JP 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
4481.00524122,5621.001,7191.00257,202
5121.14524122,5621.001,7191.00257,202
5761.29524122,5621.001,7191.00257,202
6401.43524122,5621.001,7191.00257,202
7041.57524122,5621.001,7191.00257,202
7681.71524122,5621.001,7191.00257,202
8321.86524122,5621.001,7191.00257,202
8962.00524122,5621.001,7191.00257,202
9602.14524122,5621.001,7191.00257,202
1,0242.29524122,5621.001,7191.00257,202

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block2,925,2903520
undo block319,22680
undo header67,53820
2nd level bmb37224
3rd level bmb23115
1st level bmb23,66710
segment header8,04200
extent map3800

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,80850,3491,45934,2991,01429.57
TX-Transaction (index contention) 455,875455,8770454,5191680.37
HW-Segment High Water Mark 92,51092,504733,378180.54
TX-Transaction (row lock contention) 4,6643,7499153,739184.82
TX-Transaction 570,788570,78809,21870.74
SQ-Sequence Cache 23,57223,572013,43130.21
FB-Format Block 22,93422,93501,64200.18
TX-Transaction (allocate ITL entry) 190190018600.16
DV-Diana Versioning 66066001302.31

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
181,113.00445,9891,1773924.6/34.70/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
06-Aug 16:21278,747111,0111,10737330/00/0/0/0/0/0
06-Aug 16:11545,141220,5381,17739350/00/0/0/0/0/0
06-Aug 16:01289,114114,44057639250/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
AQ dequeue txn counter latch7,8940.200.0000 
ASM Keyed state latch5500.730.0000 
ASM allocation690.00 00 
ASM db client latch1,0940.00 00 
ASM map headers420.00 00 
ASM map load waiting list420.00 00 
ASM map operation freelist6,8835.450.0000 
ASM map operation hash table2,081,4590.000.0000 
ASM network background latch7900.00 00 
ASM network state latch1,0650.00 00 
AWR Alerted Metric Element list21,1180.00 00 
Change Notification Hash table latch5470.00 00 
Consistent RBA256,7990.030.0000 
DML lock allocation1,931,6670.010.0000 
Event Group Locks6010.00 00 
FOB s.o list latch26,4760.040.0000 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch27,321,0260.260.573241,4980.05
JS Sh mem access50.00 00 
JS broadcast autostart latch250.00 00 
JS queue access latch10.00 00 
JS queue state obj latch9,9000.00 00 
JS slv state obj latch890.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch5300.00 00 
KFMD SGA50.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 latch5470.00 00 
KTF sga latch110.00 05230.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status2080.00 00 
KWQS pqsubs latch380.00 00 
KWQS pqueue ctx latch460.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch4,2010.290.0000 
MQL Tracking Latch0  0320.00
Memory Management Latch10.00 05470.00
Memory Queue60.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 Latch180.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process1,3930.00 00 
OS process allocation4,0580.070.0000 
OS process: request allocation5500.550.0000 
PL/SQL warning settings3,764,5830.700.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch8,4700.00 00 
SGA IO buffer pool latch980.00 0980.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 05460.00
SQL memory manager workarea list latch13,001,7980.040.0000 
Shared B-Tree1,2140.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 latch118,1500.150.0000 
active service list4,2150.020.0001,5570.00
begin backup scn array300.00 00 
bq:time manger info latch590.00 00 
buffer pool10.00 00 
bufq statistics50.00 00 
business card10.00 00 
cache buffer handles148,349,3605.020.0000 
cache buffers chains4,228,977,7942.770.00711,226,8781.48
cache buffers lru chain3,271,5870.080.02022,542,4080.30
cache table scan latch1510.00 01510.00
call allocation543,6581.080.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch5610.530.0000 
channel operations parent latch12,3730.020.0000 
checkpoint queue latch5,041,0660.010.0301,923,9190.00
client/application info3,7550.00 00 
compile environment latch3210.00 00 
corrupted undo seg latch560,6320.000.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch9250.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch9250.00 00 
dml lock allocation9250.00 00 
done queue latch10.00 00 
dummy allocation6350.160.0000 
enqueue freelist latch10.00 01,406,2260.05
enqueue hash chains5,111,3416.510.0003320.00
enqueues14,7270.00 00 
fifth spare latch10.00 00 
file cache latch28,2290.020.0000 
flashback copy10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA2180.460.0000 
global ctx hash table latch6100.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch530.00 087,5970.00
hash table modification latch800.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch430.00 0420.00
job_queue_processes free list latch840.00 00 
job_queue_processes parameter latch3850.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch7,9740.250.0000 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock330.00 00 
ksuosstats global area1500.00 00 
ksv allocation latch9810.00 00 
ksv class latch9770.510.0000 
ksv instance latch100.00 00 
ksv msg queue latch430.00 0420.00
ksz_so allocation latch5500.550.0000 
ktm global data3970.00 00 
kwqbsn:qsga1,0150.00 00 
lgwr LWN SCN258,9170.580.0000 
list of block allocation405,3650.030.0000 
loader state object freelist5660.00 00 
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 latch510.00 00 
messages1,009,5040.140.0000 
mostly latch-free SCN302,2609.430.0000 
msg queue latch10.00 00 
multiblock read objects3842.340.0000 
name-service namespace bucket10.00 00 
ncodef allocation latch9250.00 00 
object queue header heap1,079,5670.000.500135,5130.00
object queue header operation9,375,3690.020.0200 
object stats modification197,2880.000.0000 
parallel query alloc buffer4410.00 00 
parallel query stats10.00 00 
parameter list8320.00 00 
parameter table management5,1780.190.0000 
peshm10.00 00 
pesom_free_list4410.00 00 
pesom_hash_node4410.00 00 
post/wait queue146,5780.150.00098,0990.16
process allocation6100.490.0002770.72
process group creation5500.180.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch1,5650.00 00 
query server freelists10.00 00 
queued dump request60.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation1,747,37518.540.01169,325,8114.23
redo copy10.00 069,662,5230.04
redo writing1,050,7720.010.0000 
resmgr group change latch6920.140.0000 
resmgr:active threads6350.00 00 
resmgr:actses change group2630.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list6340.160.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 objects40,434,8922.670.0000 
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache30,411,4821.760.0000 
session allocation281,3440.000.000280,7490.00
session idle bit46,555,5160.060.0000 
session queue latch10.00 00 
session state list latch1,5260.460.7100 
session switching1,1970.00 00 
session timer1,1480.00 00 
shared pool748,3390.020.0200 
shared pool sim alloc30.00 00 
shared pool simulator640.00 00 
sim partition latch10.00 00 
simulator hash latch192,546,2680.000.0000 
simulator lru latch1,342,4290.250.020191,107,4752.53
sort extent pool3,5280.340.0000 
space background state object latch160.00 00 
space background task latch7,5339.860.0801,1910.08
state object free list20.00 00 
statistics aggregation2520.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
temporary table state object allocation4040.990.0000 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch4090.00 00 
transaction allocation101,4010.000.0000 
undo global data83,903,8890.130.010820.00
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains4,228,977,794117,154,84593,031117,025,897
cache buffer handles148,349,3607,440,2422,9467,437,402
row cache objects40,434,8921,080,7068081,079,933
sequence cache30,411,482534,6681,814532,958
enqueue hash chains5,111,341332,5481,322331,236
redo allocation1,747,375323,9974,195319,998
undo global data83,903,889110,213636109,600
In memory undo latch27,321,02671,59240,90332,955
mostly latch-free SCN302,26028,508428,504
session idle bit46,555,51625,81511525,703
call allocation543,6585,85335,850
SQL memory manager workarea list latch13,001,7985,633155,619
simulator hash latch192,546,2684,11194,103
simulator lru latch1,342,4293,320663,254
cache buffers lru chain3,271,5872,588482,541
object queue header operation9,375,3691,742351,709
space background task latch7,53374362681
ASM map operation freelist6,8833751374
checkpoint queue latch5,041,0662998292
shared pool748,3391333130
session state list latch1,526752
object queue header heap1,079,567211

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation freelistkffmTranslate2011
In memory undo latchktiFlush: child025,20410,637
In memory undo latchkticmt: child013,775105
In memory undo latchktichg: child01,89514,018
In memory undo latchktiFlushMe0859481
In memory undo latchkturbk02016,413
In memory undo latchktiFlushTopTxn0136
In memory undo latchktbgfc07115
In memory undo latchktiTxnPoolFree034
PC and Classifier lists for WLMNo latch010
SQL memory manager workarea list latchqesmmIUnRegisterWorkArea086
SQL memory manager workarea list latchqesmmIRegisterWorkArea:2079
cache buffer handleskcbzgs02,2092,190
cache buffer handleskcbzfs0737756
cache buffers chainskcbchg1: mod cr pin035,4904,009
cache buffers chainskcbgtcr: fast path018,60132,947
cache buffers chainskcbgtcr: fast path (cr pin)015,73820,856
cache buffers chainskcbgcur_209,6411,124
cache buffers chainskcbgtcr_206,2663,876
cache buffers chainskcbgtcr: kslbegin excl05,0292,346
cache buffers chainskcbzwb03,0731,010
cache buffers chainskcbrls_202,8337,027
cache buffers chainskcbgcur: fast path (shr)02,5842,021
cache buffers chainskcbget: fast exchange02,5391,178
cache buffers chainskcbrls: fast release02,1257,942
cache buffers chainskcbgkcbcr02,10115,318
cache buffers chainskcbget: pin buffer0939866
cache buffers chainskcbget: release excl068897
cache buffers chainskcbchg1: clear MS bit06411,026
cache buffers chainskcbcge05962,342
cache buffers chainskcb_trim_hash_chain0573438
cache buffers chainskcbget: fast path05381,991
cache buffers chainskcbget: exchange0372148
cache buffers chainskcbzgb: scan from tail. nowait02830
cache buffers chainskcbchg1: mod cur pin0263676
cache buffers chainskcbnlc0199514
cache buffers chainskcbgcur_40186956
cache buffers chainskcbchg1: aux pin0153113
cache buffers chainskcb_commit0101352
cache buffers chainskcbget: release shr05655
cache buffers chainskcbget: upgrade latch056219
cache buffers chainskcbzpbuf056238
cache buffers chainskcb_pre_apply: kcbhq61047181
cache buffers chainskcbso1: set no access045145
cache buffers chainskcbesc: escalate0403
cache buffers chainskcb_post_apply: kcbhq6203360
cache buffers chainskcbrls_102186
cache buffers chainskcbgtcr: kslbegin shared01819
cache buffers chainskcb_is_private0151,479
cache buffers chainskcbnew: new latch again090
cache buffers chainskcbget_1073
cache buffers chainskcbzar_fpin_105593
cache buffers chainskcb_post_apply: kcbhq630310
cache buffers chainskcbgtcr_1030
cache buffers chainskcbrls026
cache buffers lru chainkcbzgws0380
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_1040
cache buffers lru chainkcbbxsv: move to being written020
cache buffers lru chainkcbbic20126
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_2010
cache buffers lru chainkcbo_link_q010
cache buffers lru chainkcbzgb0120
call allocationksudlc : rec call014
call allocationksuprc010
call allocationksuxds010
checkpoint queue latchkcbbwthc: thread checkpoint buffers040
checkpoint queue latchkcbklbc_cql020
checkpoint queue latchkcbkubc_4016
checkpoint queue latchkcbswcu: Switch buffers012
enqueue hash chainsksqrcl0591277
enqueue hash chainsksqcmi: get hash chain latch after wait0543863
enqueue hash chainsksqgtl30184182
enqueue hash chainsksqcmi: kslgpl030
enqueue hash chainsksqcmi: if deadlock detected010
lgwr LWN SCNkcs023010
mostly latch-free SCNkcslcu3034
object queue header heapkcbo_link_q:alloc010
object queue header operationkcbo_unlink_q0140
object queue header operationkcbo_link_q098
object queue header operationkcbo_link_q:reget070
object queue header operationkcbo_switch_cq032
object queue header operationkcbo_switch_mq_bg016
object queue header operationkcbo_switch_q_bg019
redo allocationkcrfw_redo_gen: redo allocation 102,5100
redo allocationkcrfw_redo_gen: redo allocation 301,3083,857
redo allocationkcrfw_redo_gen: redo allocation 203040
redo allocationkcrfw_post: more space040202
redo allocationkcrfw_redo_write: before write033136
row cache objectskqreqd: reget03621
row cache objectskqrpre: find obj0301788
row cache objectskqreqd014219
row cache objectskqrso020
row cache objectskqrcmt: while loop010
sequence cachekdnssd071225
sequence cachekdnnxt: cached seq064330
sequence cachekdnss04591,757
session idle bitksupuc: clear busy07461
session idle bitksupuc: set busy04154
session state list latchkpseqd030
session state list latchkpscad021
shared poolkghalo031
simulator hash latchkcbsacc: lookup dba097
simulator lru latchkcbs_simulate: simulate set0640
simulator lru latchkcbs_simbufseq0266
space background task latchktsj_grab_task06162
undo global dataktudba: KSLBEGIN0612621
undo global dataktudnx:child0114
undo global dataktusmupst: KSLBEGIN0911
undo global datakturax020
undo global dataktubnd_4010
undo global dataktufrbs_2010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpnal1 90536,1210
Library Cachekglpin1 4160,3220
Library Cachekglpndl1 9591,8780
Library Cachekgllkc1 5710,7910
Library Cachekgllkdl1 8510,4960
Cursor Pinkksfbc [KKSCHLFSP2]9,7740
Cursor PinkksLockDelete [KKSCHLPIN6]4,5770
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]3,1970
Cursor Pinkksfbc [KKSCHLPIN1]3,1290
Cursor Pinkkslce [KKSCHLPIN2]3,0470
Library Cachekglobpn1 712,0980
Cursor ParentkkscsPruneChild [KKSPRTLOC35]2730
Library Cachekglget1 12620
hash tablekkshGetNextChild [KKSHBKLOC1]2320
Cursor Pinkksxsccmp [KKSCHLPIN5]2190
hash tablekkscsSearchChildList [KKSHBKLOC2]1580
Library Cachekglhdgn2 1061320
Library Cachekglget2 21190
Library Cachekglhdgn1 6230
Library CachekglGetHandleReference 12410

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 INDEX314,040,73610.73
HRAPPS_TS_TX_IDXPAY_PAYROLL_ACTIONS_PK INDEX167,464,3365.72
HRAPPS_TS_TX_DATAPAY_ASSIGNMENT_ACTIONS TABLE143,293,4724.90
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N50 INDEX119,871,0244.10
HRAPPS_TS_TX_DATAPAY_PAYROLL_ACTIONS TABLE75,992,5922.60

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HRAPPS_TS_TX_IDXPAY_RUN_RESULT_VALUES_PK INDEX2,1131.46
HRAPPS_TS_TX_DATAPER_PERIODS_OF_SERVICE TABLE3010.21
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX2130.15
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX930.06
HRAPPS_TS_TX_DATAPAY_COSTS TABLE680.05

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
HRAPPS_TS_TX_IDXPAY_RUN_RESULT_VALUES_PK INDEX2,1131.52
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX2130.15
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX930.07
HRAPPS_TS_TX_DATAPAY_COSTS TABLE680.05
HRAPPS_TS_TX_DATAPAY_RUN_RESULT_VALUES TABLE440.03

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
HRAPPS_TS_TX_IDXPAY_RUN_RESULT_VALUES_PK INDEX2,1131.52
HRAPPS_TS_TX_IDXPAY_COSTS_FK1 INDEX2130.15
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX930.07
HRAPPS_TS_TX_DATAPAY_COSTS TABLE680.05
HRAPPS_TS_TX_DATAPAY_RUN_RESULT_VALUES TABLE440.03

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 TABLE108,2496.35
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX36,8852.16
HRAPPS_TS_TX_IDXPAY_RUN_BALANCES_N1 INDEX35,3852.08
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N51 INDEX29,4111.73
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX26,7401.57

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 TABLE52,27713.56
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX20,4555.30
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N4 INDEX8,7782.28
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX8,3052.15
HRAPPS_TS_TX_IDXPAY_RUN_BALANCES_N1 INDEX8,0352.08

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXSYS_LOB0002121871C00038$$ LOB260.56
SYSSYSAUXSYS_LOB0002121863C00004$$ LOB50.11

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 TABLE316,481,28069.13
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N2 INDEX57,359,76012.53
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N51 INDEX12,502,5762.73
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX7,297,1841.59
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N51 INDEX7,000,6721.53

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX110,65724.57
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX35,1407.80
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX34,1997.59
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N50 INDEX31,9567.10
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX31,2196.93

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 INDEX4725.41
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N51 INDEX4021.62
HRAPPS_TS_TX_IDXPAY_RUN_BALANCES_N1 INDEX3820.54
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_N5 INDEX158.11
HRAPPS_TS_TX_IDXPAY_RUN_RESULTS_N51 INDEX158.11

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_PK INDEX484,22016.83
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_PK INDEX400,07713.90
HRAPPS_TS_TX_IDXPAY_ACTION_INTERLOCKS_FK2 INDEX202,4717.04
HRAPPS_TS_TX_IDXPAY_ACTION_INFORMATION_PK INDEX201,0356.99
HRAPPS_TS_TX_IDXPAY_ASSIGNMENT_ACTIONS_N4 INDEX174,2936.06

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control320.000 21
dc_files3990.000 0342
dc_global_oids6,4850.000 0117
dc_histogram_data2,4230.000 02,006
dc_histogram_defs4,3750.000 09,757
dc_object_grants5650.000 0325
dc_objects29,6480.000 07,634
dc_profiles2450.000 01
dc_rollback_segments8,3600.000 0398
dc_segments50,7210.000 1773,818
dc_sequences10,1260.000 10,12636
dc_tablespaces6,777,9840.000 056
dc_users6,607,4680.000 0155
global database name1,4790.000 01
kqlsubheap_object40.000 04
outstanding_alerts1710.000 054


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS4360.000 00
APP CONTEXT9820.0010,3240.0000
BODY14,238-0.0141,135,469-0.0200
CLUSTER30.0030.0000
DBLINK4380.000 00
DIRECTORY8320.008320.0000
EDITION3600.006050.0000
HINTSET OBJECT200.002015.0000
PIPE4890.004890.0000
QUEUE5080.007,1280.0400
SCHEMA2460.000 00
SQL AREA22,4600.05290,313,923-1.8830
SQL AREA BUILD3938.460 00
SQL AREA STATS3591.433591.4300
SUBSCRIPTION50.0050.0000
TABLE/PROCEDURE63,1360.0051,346,995-0.0700
TRIGGER1,0860.005,750,099-0.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 cache24,576.0024,576.0024,576.0025,280.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target10,240.0010,240.0010,240.0010,240.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target30,720.0030,720.0030,720.0030,720.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool448.00448.0064.00448.000GRO/IMM
large pool64.0064.000.0064.000GRO/IMM
shared pool5,056.005,056.004,096.005,056.000GRO/IMM
streams pool128.00128.000.00128.000GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther772.89 3.335.247878232232
PL/SQL159.84119.320.690.3522232232
Freeable102.940.000.721.159 143143
JAVA79.4177.763.050.28452626
SQL24.105.580.110.2325213208
EOther786.31 3.285.247878240240
PL/SQL159.30118.630.660.3722240240
Freeable100.940.000.701.109 145145
JAVA79.4177.753.050.28452626
SQL24.125.160.110.2325220215

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers25,769,803,776 
Fixed Size2,244,192 
Redo Buffers323,702,784 
Variable Size5,972,689,312 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javaJOXLE12.4512.450.00
javafree memory435.25435.250.00
largePX msg pool7.817.810.00
largefree memory55.8155.810.00
sharedASH buffers254.00254.000.00
sharedFileOpenBlock57.6057.600.00
sharedKGLH0102.21103.421.18
sharedKTI-UNDO295.54295.540.00
sharedSQLA122.72124.231.23
sharedbuffer handles68.3668.360.00
shareddb_block_hash_buckets178.00178.000.00
shareddbktb: trace buffer312.50312.500.00
sharedenqueue57.6057.600.00
sharedevent statistics per sess499.27499.270.00
sharedfree memory1,099.861,095.56-0.39
sharedksdhng: els blkrs cache54.9354.930.00
sharedksunfy : SSO free list465.39465.390.00
sharedprivate strands571.48571.480.00
sharedprocs: ksunfy81.4881.480.00
sharedtransaction108.47108.470.00
sharedwrite state object70.5370.530.00
streamsKTG hash buckets1.891.890.00
streamsfree memory126.09126.090.00
 buffer_cache24,576.0024,576.000.00
 fixed_sga2.142.140.00
 log_buffer308.71308.710.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0803 16:51:520.010.000.00
QMON Coordinator0803 16:51:420.000.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(368864) 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Subscriber/QueueEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
WFBESCL_21102(29013)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21103(29014)/APPLSYS.WF_CONTROL 00.0000.0000.00 
WFBESCL_21104(29015)/APPLSYS.WF_CONTROL 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
APPLSYS.FND_CP_GSM_IPC_AQ(2101363) 00  0.000.00  
APPLSYS.WF_CONTROL(368864) 00  0.000.00  
APPLSYS.WF_DEFERRED(288434) 00  0.000.00  
APPLSYS.WF_NOTIFICATION_OUT(923225) 00  0.000.00  
SYS.ALERT_QUE(1614907) 00  0.000.00  
SYS.AQ$_ALERT_QT_E(1614906) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(2117110) 22220.000.000.000.020.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
APPLSYS.FND_CP_GSM_IPC_AQ(2101363) 0.000.00  
APPLSYS.WF_CONTROL(368864) 0.000.00  
APPLSYS.WF_DEFERRED(288434) 0.000.00  
APPLSYS.WF_NOTIFICATION_OUT(923225) 0.000.00  
SYS.ALERT_QUE(1614907) 0.000.00  
SYS.AQ$_ALERT_QT_E(1614906) 0.000.00  
SYSMAN.MGMT_TASK_Q(2117110) 0.010.010.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
FNDCPGSMIPC_SERVICE_1594274(1305)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594275(1307)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594276(1309)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594277(1311)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594278(1313)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594279(1315)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594280(1317)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594281(1319)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594282(1321)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594283(1323)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594284(1325)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594285(1327)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
FNDCPGSMIPC_SERVICE_1594286(1329)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
WFBESCL_21102(29013)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21103(29014)/APPLSYS.WF_CONTROL 0000.000.000.00
WFBESCL_21104(29015)/APPLSYS.WF_CONTROL 0000.000.000.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED 0000.000.000.00
WF_NOTIFICATION_OUT(1)/APPLSYS.WF_NOTIFICATION_OUT 0000.000.000.00
HAE_SUB(65)/SYS.ALERT_QUE 000   
LA4001_ORACLEADS_COM_1830(2)/SYS.ALERT_QUE 0000.000.000.00
LA4001_ORACLE_1830_LA4001(24)/SYS.ALERT_QUE 0000.000.000.00
LA4003_ORACLEADS_COM_1830(4)/SYS.ALERT_QUE 0000.000.000.00
RWS60015PERF_US_ORAC_3938(64)/SYS.ALERT_QUE 0000.000.000.00
RWS60015PERF__3938_VIS(85)/SYS.ALERT_QUE 0000.000.000.00
RWSDL01_US_OR_3938_EX122WLS(105)/SYS.ALERT_QUE 0000.000.000.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
O7_DICTIONARY_ACCESSIBILITYFALSE  
_ash_size536870912  
_b_tree_bitmap_plansFALSE  
_fast_full_scan_enabledFALSE  
_like_with_bind_as_equalityTRUE  
_optimizer_autostats_jobFALSE  
_sort_elimination_cost_ratio5  
_system_trig_enabledTRUE  
_trace_files_publicFALSE  
aq_tm_processes1  
audit_sys_operationsFALSE  
compatible11.2.0  
control_files+DATA/vis/controlfile/cntrl01.dbf  
cursor_sharingEXACT  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_files512  
db_nameVIS  
diagnostic_dest/oracle/db/tech_st/11.2.0/admin/VIS_db1  
dml_locks10000  
ifile/oracle/db/tech_st/11.2.0/dbs/VIS_db1_ifile.ora  
job_queue_processes2  
log_archive_dest_1LOCATION=/oracle/db/archive  
log_archive_format%t_%s_%r.dbf  
log_buffer268427264  
log_checkpoint_interval0  
log_checkpoint_timeout0  
log_checkpoints_to_alertTRUE  
max_dump_file_size20480  
nls_compbinary  
nls_date_formatDD-MON-RR  
nls_length_semanticsBYTE  
nls_numeric_characters.,  
nls_sortbinary  
nls_territoryamerica  
olap_page_pool_size4194304  
open_cursors6000  
optimizer_secure_view_mergingFALSE  
os_authent_prefix    
parallel_max_servers34  
parallel_min_servers0  
pga_aggregate_target10737418240  
plsql_code_typeINTERPRETED  
processes20000  
sec_case_sensitive_logonFALSE  
session_cached_cursors5000  
sessions40000  
sga_target32212254720  
shared_pool_reserved_size419430400  
shared_pool_size4294967296  
sql92_securityFALSE  
undo_managementAUTO  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /usr/tmp, /oracle/db/tech_st/11.2.0/appsutil/outbound/VIS_db1, /usr/tmp  
workarea_size_policyAUTO  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report