WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
RDB2063071887rdb102-Apr-13 12:0411.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
mercury3AIX-Based Systems (64-bit) 8 4  61.75

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1816826-Apr-13 08:00:5089 4.0
End Snap:1816926-Apr-13 08:20:5890 4.4
Elapsed:  20.14 (mins)  
DB Time:  672.73 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,304M 18,304MStd Block Size: 8K
Shared Pool Size: 10,880M 10,880MLog Buffer: 96,128K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 33.4 0.2 0.06 0.01
DB CPU(s): 2.0 0.0 0.00 0.00
Redo size: 384,806.5 2,696.8  
Logical reads: 45,638.1 319.8  
Block changes: 1,896.2 13.3  
Physical reads: 6,243.4 43.8  
Physical writes: 67.0 0.5  
User calls: 5,943.4 41.7  
Parses: 395.6 2.8  
Hard parses: 186.5 1.3  
W/A MB processed: 0.9 0.0  
Logons: 18.8 0.1  
Executes: 585.1 4.1  
Rollbacks: 0.0 0.0  
Transactions: 142.7   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 86.32In-memory Sort %: 100.00
Library Hit %: 77.05Soft Parse %: 52.85
Execute to Parse %: 32.39Latch Hit %: 99.69
Parse CPU to Parse Elapsd %: 14.88% Non-Parse CPU: 93.16

Shared Pool Statistics

BeginEnd
Memory Usage %: 42.31 42.57
% SQL with executions>1: 52.36 72.13
% Memory for SQL w/exec>1: 29.93 33.91

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
log file sync173,76217,76510244.01Commit
db file scattered read176,0205,5993213.87User I/O
db file sequential read158,3393,545228.78User I/O
DB CPU 2,386 5.91 
db file parallel read4,565172380.43User I/O

Host CPU (CPUs: 8 Cores: 4 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
14.56 18.07 33.5 24.2 34.1 42.2
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
25.0 43.2 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 63,232.0 63,232.0
SGA use (MB): 30,720.0 30,720.0
PGA use (MB): 341.1 327.1
% Host Mem used for SGA+PGA: 49.12 49.10

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time10,652.9926.39
connection management call elapsed time2,658.356.59
DB CPU2,385.695.91
parse time elapsed1,151.732.85
hard parse elapsed time845.592.09
PL/SQL execution elapsed time15.280.04
hard parse (sharing criteria) elapsed time5.940.01
PL/SQL compilation elapsed time4.230.01
hard parse (bind mismatch) elapsed time2.860.01
sequence load elapsed time0.200.00
failed parse elapsed time0.130.00
repeated bind elapsed time0.040.00
DB time40,363.98 
background elapsed time1,867.19 
background cpu time18.88 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
NUM_LCPUS0 
NUM_VCPUS0 
AVG_BUSY_TIME69,503 
AVG_IDLE_TIME50,825 
AVG_IOWAIT_TIME41,069 
AVG_SYS_TIME29,147 
AVG_USER_TIME40,317 
BUSY_TIME556,305 
IDLE_TIME406,881 
IOWAIT_TIME328,844 
SYS_TIME233,447 
USER_TIME322,858 
LOAD1518
OS_CPU_WAIT_TIME1,289,700 
RSRC_MGR_CPU_WAIT_TIME0 
PHYSICAL_MEMORY_BYTES66,303,557,632 
NUM_CPUS8 
NUM_CPU_CORES4 
GLOBAL_RECEIVE_SIZE_MAX1,048,576 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
26-Apr 08:00:5014.56     
26-Apr 08:20:5818.0757.7633.5224.2442.2434.14

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Commit173,762017,76510244.01
User I/O3,420,98709,460323.44
DB CPU  2,386 5.91
Concurrency59,353025940.64
Other3,067,27008600.21
Network7,385,08106300.16
Application8,1410710.02
Configuration5701200.00
System I/O2,1290100.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
log file sync173,762017,7651021.0144.01
db file scattered read176,02005,599321.0213.87
db file sequential read158,33903,545220.928.78
db file parallel read4,5650172380.030.43
latch: shared pool54,804016730.320.41
Disk file operations I/O34,73109330.200.23
library cache: mutex X1,851067360.010.17
latch free5,819065110.030.16
SQL*Net more data to client293,01505501.700.14
read by other session1,375043310.010.11
BFILE open6,29801120.040.03
latch: row cache objects1,4070970.010.02
SQL*Net message to client7,091,99008041.120.02
BFILE read3,045,79407017.660.02
enq: TX - index contention19907340.000.02
SQL*Net break/reset to client8,1410710.050.02
BFILE internal seek3,045,56407017.660.02
buffer busy waits32406190.000.02
cursor: pin S10502180.000.00
ADR block file read8901120.000.00
enq: HW - contention5001200.000.00
control file sequential read2,1290100.010.00
row cache lock1101570.000.00
latch: enqueue hash chains710180.000.00
enq: TX - contention1601350.000.00
latch: cache buffers chains3660010.000.00
direct path read820060.000.00
latch: object queue header operation620070.000.00
direct path sync800400.000.00
SQL*Net more data from client760030.000.00
latch: cache buffers lru chain940020.000.00
enq: SQ - contention400350.000.00
cursor: pin S wait on X1001400.000.00
BFILE closure6,2970000.040.00
direct path write710020.000.00
latch: In memory undo latch2730000.000.00
enq: CF - contention200430.000.00
latch: undo global data90070.000.00
enq: FB - contention300190.000.00
latch: session allocation150020.000.00
ADR file lock60040.000.00
cursor: mutex S12100020.000.00
latch: messages70020.000.00
wait list latch free100100.000.00
asynch descriptor resize2,903100000.020.00
ADR block file write50010.000.00
buffer deadlock7100010.000.00
enq: TX - allocate ITL entry30010.000.00
SQL*Net message from client7,091,997041,743641.12 
jobq slave wait2,5131001,2585010.01 
wait for unread message on broadcast channel1,228971,2059810.01 
Streams AQ: waiting for messages in the queue2411001,20549990.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 write43,24901,171270.2562.69
SQL*Net more data from client9,09009511050.0550.95
db file parallel write68505017310.0026.82
db file sequential read3,011078260.024.20
os thread startup4304911420.002.63
control file parallel write1,210028230.011.49
db file scattered read336010310.000.55
latch: shared pool6590580.000.29
Disk file operations I/O3220250.000.09
latch free1630170.000.06
control file sequential read3,1150100.020.04
latch: call allocation1850130.000.03
LGWR wait for redo copy6790110.000.03
SQL*Net more data to client9,0860000.050.02
buffer busy waits2001800.000.02
latch: object queue header operation1100140.000.01
latch: cache buffers lru chain320040.000.01
log file sync200450.000.00
SQL*Net message to client67,8310000.390.00
asynch descriptor resize22,027100000.130.00
reliable message210010.000.00
direct path write100170.000.00
latch: redo allocation90020.000.00
latch: messages40030.000.00
latch: enqueue hash chains10090.000.00
rdbms ipc reply210000.000.00
latch: row cache objects10010.000.00
rdbms ipc message22,7282013,2735840.13 
DIAG idle wait2,4071002,40910010.01 
Streams AQ: waiting for time management or cleanup tasks8631,4461808050.00 
smon timer6501,2792130970.00 
shared server idle wait411001,230300030.00 
pmon timer1,143351,20710560.01 
Streams AQ: qmn coordinator idle wait86501,204140050.00 
Streams AQ: qmn slave idle wait4301,204279990.00 
Space Manager: slave idle wait241991,20149830.00 
dispatcher timer201001,200600070.00 
SQL*Net message from client90,440015720.52 
class slave wait50060.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read8914.64.52.215.740.414.67.9 
ADR block file write580.0 20.0     
ADR file lock683.3    16.7  
BFILE closure634199.9.0.0     
BFILE internal seek3114.8K100.0.0.0.0.0.0.0 
BFILE open634368.413.99.04.62.71.1.3 
BFILE read3114.9K100.0.0.0.0.0.0.0 
Disk file operations I/O35.2K96.4.3.4.5.6.71.2.0
LGWR wait for redo copy69787.83.43.43.31.4.4.1 
SQL*Net break/reset to client813185.95.14.02.51.9.3.2 
SQL*Net message to client7134.7K100.0.0.0.0.0.0  
SQL*Net more data from client92291.2.4.81.83.58.384.0 
SQL*Net more data to client307.3K96.71.9.9.3.1.1.0 
asynch descriptor resize25.6K100.0       
buffer busy waits32588.33.11.82.8.3 3.4.3
buffer deadlock771.414.314.3     
control file parallel write1205 .25.620.724.524.624.3 
control file sequential read523598.5.3.1.2.3.3.3 
cursor: mutex S1283.3   16.7   
cursor: pin S10536.27.63.813.39.514.315.2 
cursor: pin S wait on X1      100.0 
db file parallel read4547.9.3.53.919.632.841.9.1
db file parallel write680  .1.11.31.976.520.0
db file scattered read176.8K10.82.22.68.616.721.138.0.0
db file sequential read161.6K16.71.72.612.721.222.922.1.0
direct path read8374.73.63.64.83.62.47.2 
direct path sync8 12.5  12.525.050.0 
direct path write7384.96.84.1  1.42.7 
direct path write temp2100.0       
enq: CF - contention2     50.050.0 
enq: FB - contention333.333.3    33.3 
enq: HW - contention5042.06.08.02.020.0 22.0 
enq: SQ - contention4     75.025.0 
enq: TX - allocate ITL entry366.7 33.3     
enq: TX - contention16 12.5 6.318.825.037.5 
enq: TX - index contention20023.02.51.512.017.023.520.5 
latch free611624.49.712.719.317.69.47.0 
latch: In memory undo latch27789.54.33.61.11.4   
latch: cache buffers chains36985.41.64.14.62.71.4.3 
latch: cache buffers lru chain12677.07.14.01.64.05.6.8 
latch: call allocation18978.83.74.23.24.23.22.6 
latch: enqueue hash chains7229.213.919.49.713.96.96.9 
latch: messages1118.245.527.3 9.1   
latch: object queue header operation7544.012.013.39.312.02.76.7 
latch: redo allocation955.611.122.211.1    
latch: row cache objects142933.711.113.219.113.46.92.7 
latch: session allocation1668.86.312.512.5    
latch: shared pool56.5K66.08.06.67.67.72.81.2 
latch: undo global data933.311.1 22.211.122.2  
library cache: mutex X187845.07.09.510.410.16.710.21.0
log file parallel write43.9K21.916.914.09.29.68.420.0.0
log file sync175.9K1.93.56.58.59.611.658.4.1
os thread startup43      65.134.9
rdbms ipc reply21100.0       
read by other session137615.47.37.320.724.813.410.6.5
reliable message2185.714.3      
row cache lock11      100.0 
wait list latch free1    100.0   
DIAG idle wait2403      99.8.2
SQL*Net message from client7153.6K91.84.01.91.2.6.3.2.0
Space Manager: slave idle wait241       100.0
Streams AQ: qmn coordinator idle wait8646.5  2.3  1.250.0
Streams AQ: qmn slave idle wait43       100.0
Streams AQ: waiting for messages in the queue241       100.0
Streams AQ: waiting for time management or cleanup tasks825.0     37.537.5
class slave wait5 20.060.0  20.0  
dispatcher timer20       100.0
jobq slave wait2465.0     100.0 
pmon timer114616.42.61.51.910.615.017.534.5
rdbms ipc message23.1K49.311.012.15.61.7.55.514.3
shared server idle wait40       100.0
smon timer6       100.0
wait for unread message on broadcast channel1227 .1.1 .1.299.5.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ADR block file read792.16.71.1     
BFILE internal seek5100.0.0.0     
BFILE open2199.7.3.1     
BFILE read13100.0.0.0.0    
Disk file operations I/O42198.8.6.3.1.1.1.0.0
LGWR wait for redo copy199.9.1      
SQL*Net break/reset to client1599.8.1.0     
SQL*Net more data from client775216.015.331.936.7.1   
SQL*Net more data to client114100.0.0.0     
buffer busy waits1296.3.3.3.31.21.2.3 
control file parallel write29375.720.43.7.1.1   
control file sequential read1599.7.3.0     
cursor: pin S1684.88.62.93.8    
cursor: pin S wait on X1   100.0    
db file parallel read190658.133.66.61.0.4.2.0.0
db file parallel write6203.54.68.411.022.829.714.75.3
db file scattered read67.3K62.025.911.01.0.1.0.0.0
db file sequential read35.7K77.918.13.3.4.2.1.0.0
direct path read692.84.82.4     
direct path sync450.025.025.0     
direct path write297.32.7      
enq: CF - contention150.050.0      
enq: FB - contention166.733.3      
enq: HW - contention1178.06.012.04.0    
enq: SQ - contention175.0 25.0     
enq: TX - contention662.525.012.5     
enq: TX - index contention4179.512.54.01.02.5.5  
latch free42893.03.92.1.9    
latch: cache buffers chains199.7 .3     
latch: cache buffers lru chain199.2.8      
latch: call allocation597.42.6      
latch: enqueue hash chains593.16.9      
latch: object queue header operation593.32.72.71.3    
latch: row cache objects3897.31.8.8     
latch: shared pool68198.8.9.2.1    
library cache: mutex X21188.85.61.82.3.2.31.0 
log file parallel write877980.08.06.83.81.3.1.0.0
log file sync102.9K41.514.919.014.68.01.9.1.1
os thread startup35  9.318.614.023.316.318.6
read by other session14888.97.02.0.7.4.5.1.4
row cache lock11 63.636.4     

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
Disk file operations I/O5100.0.0.0     
db file parallel read1100.0.0      
db file parallel write3694.74.11.2     
db file scattered read1100.0.0      
db file sequential read9100.0.0.0.0    
log file parallel write3100.0.0.0     
log file sync9399.9.0.0     
os thread startup881.414.04.7     
read by other session599.6.4      

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)
rdb40,0692,3507,53354,112
SYS$USERS32237111,306
SYS$BACKGROUND001663
rdbXDB0000

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
rdb 341659393115891125700736677162
SYS$USERS 448314898200252681
SYS$BACKGROUND 37139286500000

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
630.891630.891.564.2193.720ajwa3b34ahfu T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
421.341421.341.041.8797.52dqzhzzppdqj3n T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
239.571239.570.592.2096.48b84cvv9nq5qzb T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
217.411217.410.543.5394.0959szkzn03qmfg T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
168.591168.590.423.7194.67b3w3w162w39an soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
112.461112.460.282.5393.16fhpmqm3udsz9c o_zd_plot_10@localhost.localdomain (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
108.69157.250.2758.210.01grjkxqkpnn719 awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) SELECT T.C_RAWSTID T01, T.C_IY...
104.37156.960.2657.290.006tzfvn1y63f3y awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) SELECT P.C_RAWSPID P01, P.C_IY...
90.20190.200.222.4296.639w85pka4an4vu T1107@P550 (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
77.981250.620.190.670.00fdfhbk2n2qfa0 surfacejm_mdss@login02 (TNS V1-V3) select V01000, V12003, V20001_...

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
63.27154.222.65108.6958.210.01grjkxqkpnn719 awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) SELECT T.C_RAWSTID T01, T.C_IY...
59.79153.992.51104.3757.290.006tzfvn1y63f3y awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) SELECT P.C_RAWSPID P01, P.C_IY...
26.58126.581.11630.894.2193.720ajwa3b34ahfu T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
10.37110.370.4334.8329.7736.826ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
9.6051.920.4020.3747.130.001rx96xrf5haf9   SELECT vst.sql_id, vst.sql_fu...
8.601230.070.3677.1611.150.054zqp1yrb6f19x surfacejm_mdss@login02 (TNS V1-V3) select F11001_002, F11002_002,...
7.8817.880.33421.341.8797.52dqzhzzppdqj3n T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
7.6817.680.32217.413.5394.0959szkzn03qmfg T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
7.5917.590.3221.8834.696.87gkt6t52rzff6j awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) BEGIN InsertAWSHfrAWSTP_04('20...
6.2516.250.26168.593.7194.67b3w3w162w39an soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...

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
591.291591.296.19630.894.2193.720ajwa3b34ahfu T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
410.871410.874.30421.341.8797.52dqzhzzppdqj3n T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
231.141231.142.42239.572.2096.48b84cvv9nq5qzb T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
204.571204.572.14217.413.5394.0959szkzn03qmfg T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
159.601159.601.67168.593.7194.67b3w3w162w39an soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
104.761104.761.10112.462.5393.16fhpmqm3udsz9c o_zd_plot_10@localhost.localdomain (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
87.16187.160.9190.202.4296.639w85pka4an4vu T1107@P550 (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
67.33167.330.7073.233.4791.941hhn6z5nw87gh soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
62.74203.140.6665.271.9996.136gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
27.7916,8470.000.2930.894.7689.9748444uwc96fyg awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) INSERT INTO RAWSH_ELE_04 H ( H...

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
10,974,60812587,796.8619.9077.980.670.00fdfhbk2n2qfa0 surfacejm_mdss@login02 (TNS V1-V3) select V01000, V12003, V20001_...
5,703,30915380,220.6010.34108.6958.210.01grjkxqkpnn719 awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) SELECT T.C_RAWSTID T01, T.C_IY...
4,346,18512335,334.847.8877.1611.150.054zqp1yrb6f19x surfacejm_mdss@login02 (TNS V1-V3) select F11001_002, F11002_002,...
4,059,49615270,633.077.36104.3757.290.006tzfvn1y63f3y awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) SELECT P.C_RAWSPID P01, P.C_IY...
963,8151963,815.001.75630.894.2193.720ajwa3b34ahfu T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
719,8981719,898.001.31112.462.5393.16fhpmqm3udsz9c o_zd_plot_10@localhost.localdomain (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
683,0861683,086.001.2421.8834.696.87gkt6t52rzff6j awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) BEGIN InsertAWSHfrAWSTP_04('20...
319,2131319,213.000.58217.413.5394.0959szkzn03qmfg T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
311,3182155,659.000.563.8439.880.08adug403amktzg o_fsudm@localhost.localdomain (TNS V1-V3) select C_LY, C_LM, C_LD, C_LH,...
294,5301294,530.000.53239.572.2096.48b84cvv9nq5qzb T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
958,8151958,815.0012.71630.894.2193.720ajwa3b34ahfu T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
318,6141318,614.004.22217.413.5394.0959szkzn03qmfg T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
262,6571262,657.003.48168.593.7194.67b3w3w162w39an soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
255,6311255,631.003.39421.341.8797.52dqzhzzppdqj3n T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
127,1421127,142.001.68239.572.2096.48b84cvv9nq5qzb T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
84,460184,460.001.1290.202.4296.639w85pka4an4vu T1107@P550 (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
70,823170,823.000.9427.784.9091.80crrd5t7w4yj33 T1203@P550 (TNS V1-V3) SELECT C_REPORT FROM rdb_inser...
60,396160,396.000.8073.233.4791.941hhn6z5nw87gh soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
13,235113,235.000.1828.291.7397.168pxa20m4v9w5z T1107@P550 (TNS V1-V3) select C_CCCC, C02120_001, V01...
7,21020360.500.1065.271.9996.136gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...

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
19,77219,772119,772.000.005.66dqzhzzppdqj3n T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
11,89511,895111,895.000.003.410ajwa3b34ahfu T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
11,64411,644111,644.000.003.34b84cvv9nq5qzb T1201@P550 (TNS V1-V3) SELECT C_BULLETIN FROM rdb_ins...
6,1786,17816,178.000.001.77b3w3w162w39an soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
5,2825,28215,282.000.001.5159szkzn03qmfg T1107@P550 (TNS V1-V3) select V_SQCODE, V_PQCODE, V_N...
4,9244,92414,924.000.001.411hhn6z5nw87gh soilt_ver@cls01 (TNS V1-V3) select V01000, V04001, V04002,...
4,3944,39414,394.000.001.269w85pka4an4vu T1107@P550 (TNS V1-V3) select C_CYMD, C_CHMS, V01000,...
1,8191,8192090.950.000.526gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1,8051,80511,805.000.000.528pxa20m4v9w5z T1107@P550 (TNS V1-V3) select C_CCCC, C02120_001, V01...
1,5221,5221695.130.000.443am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
67,9621,7270.035.055.740.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
22,80168,0252.987.465.490.000k8522rmdzg4k   select privilege# from sysauth...
22,60422,6041.0010.8510.320.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
22,59422,5951.0015.756.0351.55459f3z9u4fb3u   select value$ from props$ wher...
22,59122,5871.008.6817.160.005ur69atw3vfhj   select decode(failover_method,...
16,84716,8371.0030.894.7689.9748444uwc96fyg awshqc_InsAWSHfrAWST@mercury4 (TNS V1-V3) INSERT INTO RAWSH_ELE_04 H ( H...
10,84810,5490.9717.832.7594.969tgj4g8y4rwy8   select type#, blocks, extents,...
5,5675,5671.0012.880.7091.789503wbtqh928b o_snow_jxsd@localhost.localdomain (TNS V1-V3) select username, password, dbq...
4,45600.000.3818.280.003972rvxu3knn3 mrdbp_agme@mercury4 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
4,4534,4531.001.2810.970.00a6u3yjca29nqc mrdbp_agme@mercury4 (TNS V1-V3) declare m_stmt varchar2(512); ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
67,97867,96214.22cm5vu20fhtnq1   select /*+ connect_by_filterin...
22,73222,8014.750k8522rmdzg4k   select privilege# from sysauth...
22,60022,6044.730ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
22,59522,5944.73459f3z9u4fb3u   select value$ from props$ wher...
22,59222,5914.735ur69atw3vfhj   select decode(failover_method,...
10,84810,8482.279tgj4g8y4rwy8   select type#, blocks, extents,...
5,5655,5671.169503wbtqh928b o_snow_jxsd@localhost.localdomain (TNS V1-V3) select username, password, dbq...
4,4574,4560.933972rvxu3knn3 mrdbp_agme@mercury4 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
4,4534,4530.93a6u3yjca29nqc mrdbp_agme@mercury4 (TNS V1-V3) declare m_stmt varchar2(512); ...
4,0014,0050.84aa35g82k7dkd9   select binaryDefVal, length(bi...

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

Version Count Executions SQL IdSQL ModuleSQL Text
18222nszajb0qbyvp   DECLARE job BINARY_INTEGER := ...
17013v30k3ypaq4z6   begin :cmp_min := dbms_backup...
17015t7dh3thzzrfh   begin dbms_rcvman.setDatabase...
13821att0guk2skhm   select lobtsn, lobrdba, lobobj...
1331d1m8g1r0jntpj   begin :vsn_min := dbms_backup...
1301aukf94xzh2p3g   declare policy varchar2(512);...
11411aa6hpj1zuxsd7   select obj#, type#, ctime, mti...
7310sfgqjz5cs52w   select q_name, state, delay, e...
6221a8n1zgb7m90w   select user#, password, datats...
62167n5u0a0q4d7u   select audit$, os_path from di...
6029k43zr1uannr6   select obj#, owner, node from ...
604bd4bznqbq73hk   select bo#, intcol# from icold...
505887gaftwrm2h68   select o.owner#, o.name, o.nam...
475ga6gkpn0fxhxj rge02@hpcdata (TNS V1-V3) select Field_ID, Table_Flag fr...
4121xgpzz5s6b84y rtovc@hpcdata (TNS V1-V3) select Field_ID, Table_Flag fr...
41244dkbqtc3q962 rsara@hpcdata (TNS V1-V3) select Field_ID, Table_Flag fr...
41385tjxbj1qm0xu rge02@hpcdata (TNS V1-V3) select Field_ID, Table_Flag fr...
412brb04q0zvb7hk rtovv@hpcdata (TNS V1-V3) select Field_ID, Table_Flag fr...
412cf1cpx0k64sus   select '"'||name||'" '||decode...
3966g3wrkmxkxzhf2   select cols, audit$, textlengt...
36132xyb5d6xg9srh   select a.default_cpu_cost, a.d...
2641ymvd58a1d7d1 T1107@P550 (TNS V1-V3) SELECT DISTINCT NVL(Ele_Idx_Ta...
2316ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
22206gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
2136w65b7awp0max T1107@P550 (TNS V1-V3) SELECT DISTINCT NVL(Ele_Idx_Ta...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0ajwa3b34ahfuselect V_SQCODE, V_PQCODE, V_NQCODE, V01000, V05001, V06001, V07001, V07002, V02001, V04001, V04002, V04003, V04004, V04005, V04006, V13019, V13202_001, V13202_002, V13202_003, V13202_004, V13202_005, V13202_006, V13202_007, V13202_008, V13202_009, V13202_010, V13202_011, V13202_012, V13202_013, V13202_014, V13202_015, V13202_016, V13202_017, V13202_018, V13202_019, V13202_020, V13202_021, V13202_022, V13202_023, V13202_024, V13202_025, V13202_026, V13202_027, V13202_028, V13202_029, V13202_030, V13202_031, V13202_032, V13202_033, V13202_034, V13202_035, V13202_036, V13202_037, V13202_038, V13202_039, V13202_040, V13202_041, V13202_042, V13202_043, V13202_044, V13202_045, V13202_046, V13202_047, V13202_048, V13202_049, V13202_050, V13202_051, V13202_052, V13202_053, V13202_054, V13202_055, V13202_056, V13202_057, V13202_058, V13202_059, V13202_060 from rdb_insert.RSUAP_ELE_04 where TRUNC(V04001*10000+V04002*100+V04003) <= 20130426 and TRUNC(V04001*10000+V04002*100+V04003) >= 20130424 and (( C_IYMDHM < '201304260731' AND C_IYMDHM >= '201304260721' ) )
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sfgqjz5cs52wselect q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info, sender_name, sender_address, sender_protocol from "SYS"."ALERT_QT" where msgid = :1
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1a8n1zgb7m90wselect user#, password, datats#, tempts#, type#, defrole, resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1, spare4, ext_username, spare2 from user$ where name=:1
1att0guk2skhmselect lobtsn, lobrdba, lobobjid from x$lobstat where lobspcalloc > 0 and lobcurrtime >= :1 order by lobspcalloc desc
1hhn6z5nw87ghselect V01000, V04001, V04002, V04003, V04004, V04005, V04006, V05001, V06001, V07001, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320 from rdb_insert.RAWST_ELE_03 where ((V04003=5 and V04001=2013 and V04002=3)) and (V04004=6 and V04005=0 and V04006=0) and V05001 <= 54 and V05001 >= 15 and V06001 <= 134 and V06001 >= 75
1rx96xrf5haf9 SELECT vst.sql_id, vst.sql_fulltext FROM V$SQLSTATS vst WHERE vst.sql_id IN ( :sqlid1 , :sqlid2 , :sqlid3 , :sqlid4 , :sqlid5 , :sqlid6 , :sqlid7 , :sqlid8 , :sqlid9 , :sqlid10 ) AND vst.plan_hash_value = :phv
1xgpzz5s6b84yselect Field_ID, Table_Flag from rdb_insert.RDB_META_RTOVC where Field_Class NOT LIKE '%M%' and Field_Class LIKE '%D%' order by Table_Flag desc, Seq_Num
1ymvd58a1d7d1SELECT DISTINCT NVL(Ele_Idx_Table_Name, 'NULL'), NVL(Key_Table_Name, 'NULL'), NVL(Meta_Table_Name, 'NULL') FROM rdb_insert.RDB_Date_Control WHERE (Data_ID_Alias='RAWSS') AND (Data_Date>=20130424) AND (Data_Date<=20130426)
2nszajb0qbyvpDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'), wwv_flow_platform.get_preference('SMTP_HOST_PORT')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2xyb5d6xg9srhselect a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2
3972rvxu3knn3delete from sdo_geor_ddl__table$$
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3v30k3ypaq4z6 begin :cmp_min := dbms_backup_restore.protocol_component_number_min; :cmp_max := dbms_backup_restore.protocol_component_number_max; :pkg_vsn := to_char(:vsn_max, 'fm00')||'.'|| to_char(:rel_max, 'fm00')||'.'|| to_char(:upd_max, 'fm00')||'.'|| to_char(:cmp_max, 'fm00'); end;
44dkbqtc3q962select Field_ID, Table_Flag from rdb_insert.RDB_META_RSARA where Field_Class NOT LIKE '%M%' and Field_Class LIKE '%D%' order by Table_Flag desc, Seq_Num
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
48444uwc96fyg INSERT INTO RAWSH_ELE_04 H ( H.C_RAWSHID , H.C_IYMDHM , H.C_ORIGIN , H.V_NCODE , H.V01000 , H.V05001 , H.V06001 , H.V07001 , H.V07002 , H.V04001 , H.V04002 , H.V04003 , H.V04004 , H.V04005 , H.V04006 , H.V11001_002, H.V11002_002, H.V11202_010, H.V11042_010, H.V11202 , H.V11042 , H.V11042_752, H.V11001 , H.V11002 , H.V11043 , H.V11041 , H.V11041_752, H.V13019 , H.V12001 , H.V12211 , H.V12211_752, H.V12212 , H.V12212_752, H.V12016 , H.V12017 , H.V13003 , H.V13007 , H.V13007_752, H.V10004 , H.V10201 , H.V10201_752, H.V10202 , H.V10202_752, H.V10005 , H.F11001_002, H.F11002_002, H.F11202_010, H.F11042_010, H.F11202 , H.F11042 , H.F11042_752, H.F11001 , H.F11002 , H.F11043 , H.F11041 , H.F11041_752, H.F13019 , H.F12001 , H.F12211 , H.F12211_752, H.F12212 , H.F12212_752, H.F12016 , H.F12017 , H.F13003 , H.F13007 , H.F13007_752, H.F10004 , H.F10201 , H.F10201_752, H.F10202 , H.F10202_752, H.F10005 ) VALUES ( :B72 , :B71 , 'T', :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , CASE WHEN (:B29 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B28 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B27 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B26 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B25 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B24 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B23 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B22 ='8') THEN '8' ELSE '9' END, CASE WHEN (:B21 ='8') THEN '8' ELSE '9' END, CASE WHEN (:B20 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B19 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B18 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B17 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B16 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B15 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B14 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B13 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B12 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B11 ='8') THEN '8' ELSE '9' END, CASE WHEN (:B10 ='8') THEN '8' ELSE '9' END, CASE WHEN (:B9 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B8 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B7 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B6 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B5 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B4 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B3 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B2 ='8') THEN '8' ELSE '7' END, CASE WHEN (:B1 ='8') THEN '8' ELSE '9' END)
4zqp1yrb6f19xselect F11001_002, F11002_002, F13019, F12001, F12016, F12017, F13003, F10005, F10004, V01000, V05001, V06001, V07001, V11001_002, V11002_002, V13019, V12001, V12016, V12017, V13003, V10005, V10004 from rdb_insert.RAWSH_ELE_04 where ((V04003=26 and V04001=2013 and V04002=4)) and (V04004=7 and V04005=0 and V04006=0)
59szkzn03qmfg select V_SQCODE, V_PQCODE, V_NQCODE, V01000, V05001, V06001, V07001, V07002, V02001, V04001, V04002, V04003, V04004, V04005, V04006, V10004, V10005, V10060_003, V10060_024, V10201, V10201_752, V10202, V10202_752, V12001, V12211, V12211_752, V12212, V12212_752, V12220_024, V12016, V12017, V12003, V13003, V13007, V13007_752, V13004, V13019, V13024, V13021, V13022, V13023, V13025_752, V13025, V13031, V11001_002, V11002_002, V11202_010, V11042_010, V11202, V11042, V11042_752, V11001, V11002, V11043, V11041, V11041_752, V11044_006, V11045_006, V11044_012, V11045_012, V12061_001, V12213_001, V12213_001_752, V12214_001, V12214_001_752, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12061_002, V12213_002, V12213_002_752, V12214_002, V12214_002_752, V20001_052_001, V20001_052_010, V20001_006, V20001_006_752, V20001, V20010, V20051, V20011, V20013, V20012_001, V20012_002, V20012_003, V20012_004, V20012_005, V20012_006, V20012_007, V20012_008, V20012_011, V20012_012, V20012_013, V20003, V20003_999, V20004, V20005, V20062, V13233 from rdb_insert.RSUAT_ELE_04 where TRUNC(V04001*10000+V04002*100+V04003) <= 20130426 and TRUNC(V04001*10000+V04002*100+V04003) >= 20130424 and (( C_IYMDHM < '201304260801' AND C_IYMDHM >= '201304260751' ) )
5t7dh3thzzrfh begin dbms_rcvman.setDatabase(upper(:dbname:dbname_i), :rlgscn, :rlgtime, :fhdbi:fhdbi_i); end;
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
67n5u0a0q4d7uselect audit$, os_path from dir$ where obj#=:1
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
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;
6tzfvn1y63f3ySELECT P.C_RAWSPID P01, P.C_IYMDHM P02, P.V_NCODE P03, P.V01000 P04, P.V05001 P05, P.V06001 P06, P.V07001 P07, P.V04001 P09, P.V04002 P10, P.V04003 P11, P.V04004 P12, P.V04005 P13, P.V04006 P14, P.V13019 P15, P.F13019 P16 FROM RAWSP_ELE_04 P WHERE (P.V04003=:B3 OR P.V04003=:B3 -1 OR P.V04003=:B3 +1) AND TO_DATE(P.C_IYMDHM, 'YYYYMMDDHH24Mi')>=:B2 AND TO_DATE(P.C_IYMDHM, 'YYYYMMDDHH24Mi')< :B1 AND P.V04005=0 AND P.V04006=0
6w65b7awp0maxSELECT DISTINCT NVL(Ele_Idx_Table_Name, 'NULL'), NVL(Key_Table_Name, 'NULL'), NVL(Meta_Table_Name, 'NULL') FROM rdb_insert.RDB_Date_Control WHERE (Data_ID_Alias='RLOCT') AND (Data_Date>=20130424) AND (Data_Date<=20130426)
85tjxbj1qm0xuselect Field_ID, Table_Flag from rdb_insert.RDB_META_RGEO2 where Field_Class NOT LIKE '%M%' and Field_Class LIKE '%C%' order by Table_Flag desc, Seq_Num
87gaftwrm2h68select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8pxa20m4v9w5zselect C_CCCC, C02120_001, V01000, V05001, V06001, V07001, V04001, V04002, V04003, V04004, V04005, V04006, V04007, V08101, V02120_002, V02120_003, V02120_004, V02120_005, V02120_007, V02120_008, V02120_009, V02120_010, V02120_011 from rdb_insert.RLOCT_ELE_99 where TRUNC(V04001*10000+V04002*100+V04003) <= 20130426 and TRUNC(V04001*10000+V04002*100+V04003) >= 20130424 and (( C_IYMDHM < '201304260820' AND C_IYMDHM >= '201304260815' ) )
9503wbtqh928bselect username, password, dbq_username, dbq_password, dbq_tnsstr, role_type from RDBAPI_USER_INFO where username='linyc'
9k43zr1uannr6select obj#, owner, node from syn$ where name=:1
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9w85pka4an4vu select C_CYMD, C_CHMS, V01000, V05001, V06001, V07001, V56001, V04001, V04002, V04003, V04004, V04005, V04006, V56207_010, V56208_010, V56206_010, V56209_010, V56207_020, V56208_020, V56206_020, V56209_020, V56207_030, V56208_030, V56206_030, V56209_030, V56207_040, V56208_040, V56206_040, V56209_040, V56207_050, V56208_050, V56206_050, V56209_050, V56207_060, V56208_060, V56206_060, V56209_060, V56207_070, V56208_070, V56206_070, V56209_070, V56207_080, V56208_080, V56206_080, V56209_080, V56207_090, V56208_090, V56206_090, V56209_090, V56207_100, V56208_100, V56206_100, V56209_100, V56207_110, V56208_110, V56206_110, V56209_110, V56207_120, V56208_120, V56206_120, V56209_120, V56207_130, V56208_130, V56206_130, V56209_130, V56207_140, V56208_140, V56206_140, V56209_140, V56207_150, V56208_150, V56206_150, V56209_150, V56207_160, V56208_160, V56206_160, V56209_160, V56207_170, V56208_170, V56206_170, V56209_170, V56207_180, V56208_180, V56206_180, V56209_180, V56207_190, V56208_190, V56206_190, V56209_190, V56207_200, V56208_200, V56206_200, V56209_200 from rdb_insert.RASMM_ELE_04 where TRUNC(V04001*10000+V04002*100+V04003) <= 20130426 and TRUNC(V04001*10000+V04002*100+V04003) >= 20130424 and (( C_IYMDHM < '201304260819' AND C_IYMDHM >= '201304260809' ) )
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
aa35g82k7dkd9select binaryDefVal, length(binaryDefVal) from ecol$ where tabobj# = :1 and colnum = :2
aa6hpj1zuxsd7select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname = :4
adug403amktzg select C_LY, C_LM, C_LD, C_LH, C01011, V01000, V04001, V04002, V04003, V_OHM, V05001, V06001, V07001, V02001, V10004, V07004, V10003, V10051, V10060_003, V10063_003, V11001, V11002, V12001, V12003, V13003, V20001, V20003, V20004, V20005, V20010, V20011, V20013, V20012_011, V20012_012, V20012_013, V20011_001, V20012_001, V20013_001, V20011_002, V20012_002, V20013_002, V20011_003, V20012_003, V20013_003, V20011_004, V20012_004, V20013_004, V13019, V13020, V13021, V13022, V13023, V13013, V12013, V10060_024, V12202_024, V12016, V12017, V12014, V12015, V13031, V14032, V14202, V20062, V20063_001, V20063_002, V20063_003, V20063_004, V20063_005, V20063_006, F10004, F07004, F10003, F10051, F10060_003, F10063_003, F11001, F11002, F12001, F12003, F13003, F20001, F20003, F20004, F20005, F20010, F20011, F20013, F20012_011, F20012_012, F20012_013, F20011_001, F20012_001, F20013_001, F20011_002, F20012_002, F20013_002, F20011_003, F20012_003, F20013_003, F20011_004, F20012_004, F20013_004, F13019, F13020, F13021, F13022, F13023, F13013, F12013, F10062, F12202_024, F12016, F12017, F12014, F12015, F13031, F14032, F14202, F20062, F20063_001, F20063_002, F20063_003, F20063_004, F20063_005, F20063_006 from rdb_insert.RSURF_ELE_04 where ((V04003=26 and V04001=2013 and V04002=4)) and V_OHM=600 and V05001 <= 90 and V05001 >= 0 and V06001 <= 180 and V06001 >= 0
aukf94xzh2p3g declare policy varchar2(512); alldest number := dbms_rcvman.FALSE#; rlgscn number; begin if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy(policy => policy, alldest => alldest); if ((policy like '%APPLIED%' OR policy like '%SHIPPED%') AND policy not like '%BACKED UP%') then dbms_rcvman.getSCNForAppliedPolicy( minscn => :applied_scn , rlgscn => rlgscn); else :applied_scn := 0; end if; end;
b3w3w162w39anselect V01000, V04001, V04002, V04003, V04004, V04005, V04006, V05001, V06001, V07001, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320 from rdb_insert.RAWST_ELE_03 where ((V04003=5 and V04001=2013 and V04002=3)) and (V04004=5 and V04005=0 and V04006=0) and V05001 <= 54 and V05001 >= 15 and V06001 <= 134 and V06001 >= 75
b84cvv9nq5qzbSELECT C_BULLETIN FROM rdb_insert.RBULL_REP_04 WHERE C_CD>=1 and TRUNC(C_CY*10000+C_CM*100+C_CD) <= 20130426 and C_CD>=1 and TRUNC(C_CY*10000+C_CM*100+C_CD) >= 20130424 and (C_TT='SM') and C_IYMDHM < '201304260816' AND C_IYMDHM >= '201304260806'
bd4bznqbq73hkselect bo#, intcol# from icoldep$ where obj#=:1
brb04q0zvb7hkselect Field_ID, Table_Flag from rdb_insert.RDB_META_RTOVV where Field_Class NOT LIKE '%M%' and Field_Class LIKE '%D%' order by Table_Flag desc, Seq_Num
cf1cpx0k64sus select '"'||name||'" '||decode(type#, 1, decode(charsetform, 2, 'NVARCHAR2('||decode(bitand(property, 8388608), 8388608, decode(spare3, 0, 1, spare3)||')', 'BYTECOUNT=>'||decode(length, 0, 1, length)||')'), 'VARCHAR2('||decode(bitand(property, 8388608), 8388608, decode(spare3, 0, 1, spare3)||' char)', decode(length, 0, 1, length)||' byte)')), 2, decode(scale, null, decode(precision#, null, 'NUMBER', 'FLOAT('||precision#||')'), 'NUMBER('||decode(precision#, null, '38', precision#)||', '||scale||')'), 8, 'LONG', 9, 'VARCHAR('||(decode(length, 0, 1, length))||')', 12, 'DATE', 23, 'RAW('||length||')', 24, 'LONG RAW', 69, 'ROWID', 96, decode(charsetform, 2, 'NCHAR('||decode(bitand(property, 8388608), 8388608, decode(spare3, 0, 1, spare3)||')', 'BYTECOUNT=>'||decode(length, 0, 1, length)||')'), 'CHAR('||decode(bitand(property, 8388608), 8388608, decode(spare3, 0, 1, spare3)||' char)', decode(length, 0, 1, length)||' byte)')), 97, 'VARCHAR('||(decode(length, 0, 1, length))|| ')', 105, 'MLSLABEL', 106, 'MLSLABEL', 112, decode(charsetform, 2, 'NCLOB', 'CLOB'), 113, 'BLOB', 114, 'BFILE', 115, decode(charsetform, 2, 'NCFILE', 'CFILE'), 178, 'TIME('||scale||')', 179, 'TIME('||scale||') WITH TIME ZONE', 180, 'TIMESTAMP('||scale||')', 181, 'TIMESTAMP('||scale||') WITH TIME ZONE', 231, 'TIMESTAMP('||scale||') WITH LOCAL TIME ZONE', 182, 'INTERVAL YEAR('||NVL(precision#, 0)||') TO MONTH', 183, 'INTERVAL DAY('||NVL(precision#, 0)||') TO SECOND('||scale||')', 208, 'UROWID('| |spare1||')', 100, 'BINARY_FLOAT', 101, 'BINARY_DOUBLE', 'UNDEFINED')||decode(null$, 0, '', ' NOT NULL')||decode(bitand(property, 32), 0, ', ', ' HIDDEN, '), name, type#, intcol#, null$, bitand(property, 32) from col$ where obj#=:1 and (bitand(property, 32) = 0 or bitand(property, 4194304) <> 0) order by col#
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
crrd5t7w4yj33SELECT C_REPORT FROM rdb_insert.RRESA_REP_04 WHERE C04001='2013' and C04002='04' and (C04003 <= '26' and C04003 >= '24') and (C_TT='SUAT') and C_IYMDHM <'201304260820' AND C_IYMDHM >='201304260815'
d1m8g1r0jntpj begin :vsn_min := dbms_backup_restore.protocol_version_number_min; :rel_min := dbms_backup_restore.protocol_release_number_min; :upd_min := dbms_backup_restore.protocol_update_number_min; :cmp_min := 0; :vsn_max := dbms_backup_restore.protocol_version_number_max; :rel_max := dbms_backup_restore.protocol_release_number_max; :upd_max := dbms_backup_restore.protocol_update_number_max; :cmp_max := 0; :pkg_vsn := to_char(:vsn_max, 'fm00')||'.'|| to_char(:rel_max, 'fm00')||'.'|| to_char(:upd_max, 'fm00')||'.'|| to_char(:cmp_max, 'fm00'); end;
dqzhzzppdqj3nSELECT C_BULLETIN FROM rdb_insert.RBULL_REP_04 WHERE C_CD>=1 and TRUNC(C_CY*10000+C_CM*100+C_CD) <= 20130426 and C_CD>=1 and TRUNC(C_CY*10000+C_CM*100+C_CD) >= 20130424 and (C_TT='SX') and C_IYMDHM < '201304260813' AND C_IYMDHM >= '201304260803'
fdfhbk2n2qfa0select V01000, V12003, V20001_052, V20013, V13021, V13023 from rdb_insert.RAWST_ELE_04 where ((V04003=26 and V04001=2013 and V04002=4)) and (V04004=7 and V04005=0 and V04006=0)
fhpmqm3udsz9c select C_CYMD, C_CHMS, V01000, V05001, V06001, V07001, V07002, V02001, V04001, V04002, V04003, V04004, V04005, V04006, V11001_002, V11002_002, V11202_010, V11042_010, V11202, V11042, V11042_752, V11001, V11002, V11043, V11041, V11041_752, V13019, V12001, V12211, V12211_752, V12212, V12212_752, V13003, V13007, V13007_752, V13004, V12003, V10004, V10201, V10201_752, V10202, V10202_752, V12061_002, V12213_002, V12213_002_752, V12214_002, V12214_002_752, V12061_001, V12213_001, V12213_001_752, V12214_001, V12214_001_752, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V13031, V10005, V20001_052, V20001_006, V20001_006_752, V20001, V20010, V20051, V20011, V20013, V20012_001, V20012_002, V20012_003, V20012_004, V20012_005, V20012_006, V20012_007, V20012_008, V20012_011, V20012_012, V20012_013, V20003, V20004, V20005, V13021, V13022, V10060_024, V12220_024, V13023, V12016, V12017, V12013, V13233, V13231, V20270, V20062, V11043_001, V11041_001, V20212, V20218, V20402 from rdb_insert.RAWST_ELE_04 where ((V04003=26 and V04001=2013 and V04002=4)) and TRUNC(V04004*10000+V04005*100+V04006) < 80000 and TRUNC(V04004*10000+V04005*100+V04006) >= 70000 and V05001 <= 60 and V05001 >= 0 and V06001 <= 135 and V06001 >= 70
g3wrkmxkxzhf2select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1
ga6gkpn0fxhxjselect Field_ID, Table_Flag from rdb_insert.RDB_META_RGEO2 where Field_Class NOT LIKE '%M%' and Field_Class LIKE '%D%' order by Table_Flag desc, Seq_Num
gkt6t52rzff6jBEGIN InsertAWSHfrAWSTP_04('20130426082036'); END;
grjkxqkpnn719 SELECT T.C_RAWSTID T01, T.C_IYMDHM T02, T.V_NCODE T03, T.V01000 T04, T.V05001 T05, T.V06001 T06, T.V07001 T07, T.V07002 T08, T.V04001 T09, T.V04002 T10, T.V04003 T11, T.V04004 T12, T.V04005 T13, T.V04006 T14, T.V11001_002 T15, T.V11002_002 T16, T.V11202_010 T17, T.V11042_010 T18, T.V11202 T19, T.V11042 T20, T.V11042_752 T21, T.V11001 T22, T.V11002 T23, T.V11043 T24, T.V11041 T25, T.V11041_752 T26, T.V13019 T27, T.V12001 T28, T.V12211 T29, T.V12211_752 T30, T.V12212 T31, T.V12212_752 T32, T.V12016 T33, T.V12017 T34, T.V13003 T35, T.V13007 T36, T.V13007_752 T37, T.V10004 T38, T.V10201 T39, T.V10201_752 T40, T.V10202 T41, T.V10202_752 T42, T.V10005 T43, T.F11001_002 T44, T.F11002_002 T45, T.F11202_010 T46, T.F11042_010 T47, T.F11202 T48, T.F11042 T49, T.F11042_752 T50, T.F11001 T51, T.F11002 T52, T.F11043 T53, T.F11041 T54, T.F11041_752 T55, T.F13019 T56, T.F12001 T57, T.F12211 T58, T.F12211_752 T59, T.F12212 T60, T.F12212_752 T61, T.F12016 T62, T.F12017 T63, T.F13003 T64, T.F13007 T65, T.F13007_752 T66, T.F10004 T67, T.F10201 T68, T.F10201_752 T69, T.F10202 T70, T.F10202_752 T71, T.F10005 T72 FROM RAWST_ELE_04 T WHERE (T.V04003=:B3 OR T.V04003=:B3 -1 OR T.V04003=:B3 +1) AND TO_DATE(T.C_IYMDHM, 'YYYYMMDDHH24Mi')>=:B2 AND TO_DATE(T.C_IYMDHM, 'YYYYMMDDHH24Mi')< :B1 AND T.V04005=0 AND T.V04006=0

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count14,48911.990.08
Batched IO (full) vector count10.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count55,89846.250.32
Batched IO buffer defrag count2660.220.00
Batched IO double miss count2,9952.480.02
Batched IO same unit count35,13229.070.20
Batched IO single block count9,9618.240.06
Batched IO slow jump count4,0993.390.02
Batched IO vector block count10,8168.950.06
Batched IO vector read count4,5573.770.03
Block Cleanout Optim referenced4,5903.800.03
CCursor + sql area evicted350.030.00
CPU used by this session71,62259.260.42
CPU used when call started71,26658.960.41
CR blocks created10,7808.920.06
Cached Commit SCN referenced7,3266.060.04
Commit SCN cached3,8713.200.02
DB time3,580,8942,962.7320.76
DBWR checkpoint buffers written34,25128.340.20
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer30.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR transaction table writes1190.100.00
DBWR undo block writes22,29318.440.13
HSC Compressed Segment Block Changes00.000.00
HSC Heap Segment Block Changes242,190200.381.40
HSC IDL Compressed Blocks00.000.00
HSC OLTP Non Compressible Blocks00.000.00
HSC OLTP Space Saving00.000.00
HSC OLTP positive compression00.000.00
HSC OLTP recursive compression00.000.00
Heap Segment Array Inserts2030.170.00
Heap Segment Array Updates1400.120.00
IMU CR rollbacks3190.260.00
IMU Flushes51,11442.290.30
IMU Redo allocation size142,529,468117,924.91826.43
IMU commits123,851102.470.72
IMU contention2,3611.950.01
IMU ktichg flush40.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush10.000.00
IMU undo allocation size251,000,592207,670.891,455.37
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued990.080.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
RowCR - row contention820.070.00
RowCR attempts4,6233.820.03
RowCR hits6,1815.110.04
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink30.000.00
SQL*Net roundtrips to/from client7,083,9315,861.0541.07
SQL*Net roundtrips to/from dblink00.000.00
active txn count during cleanout102,57484.870.59
application wait time6680.550.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts4,8594.020.03
branch node splits160.010.00
buffer is not pinned count20,288,44716,786.10117.64
buffer is pinned count14,244,53411,785.5382.59
bytes received via SQL*Net from client359,273,294297,252.712,083.17
bytes received via SQL*Net from dblink00.000.00
bytes sent via SQL*Net to client2,514,589,7342,080,501.4314,580.29
bytes sent via SQL*Net to dblink00.000.00
calls to get snapshot scn: kcmgss1,101,894911.686.39
calls to kcmgas222,777184.321.29
calls to kcmgcs424,245351.012.46
cell physical IO interconnect bytes63,610,818,04852,629,817.21368,833.20
change write time1,1590.960.01
cleanout - number of ktugct calls23,19419.190.13
cleanouts only - consistent read gets3,7033.060.02
cluster key scan block gets24,09619.940.14
cluster key scans16,65213.780.10
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed2,2541.860.01
commit batch/immediate requested2,2541.860.01
commit cleanout failures: block lost40.000.00
commit cleanout failures: buffer being written50.000.00
commit cleanout failures: callback failure3230.270.00
commit cleanout failures: cannot pin1,4671.210.01
commit cleanouts584,993484.013.39
commit cleanouts successfully completed583,194482.523.38
commit immediate performed2,2541.860.01
commit immediate requested2,2541.860.01
commit txn count during cleanout140,562116.300.82
concurrency wait time31,06025.700.18
consistent changes410,900339.972.38
consistent gets51,329,19642,468.35297.62
consistent gets - examination1,752,8821,450.2910.16
consistent gets direct1830.150.00
consistent gets from cache51,329,01142,468.19297.62
consistent gets from cache (fastpath)49,198,36840,705.36285.27
cursor authentications5550.460.00
data blocks consistent reads - undo records applied84,70070.080.49
db block changes2,291,8111,896.1813.29
db block gets3,831,0403,169.7022.21
db block gets direct2470.200.00
db block gets from cache3,830,7933,169.4922.21
db block gets from cache (fastpath)864,628715.375.01
deferred (CURRENT) block cleanout applications242,464200.611.41
dirty buffers inspected12,59710.420.07
enqueue conversions3010.250.00
enqueue deadlocks00.000.00
enqueue releases841,580696.304.88
enqueue requests841,589696.314.88
enqueue timeouts00.000.00
enqueue waits2780.230.00
exchange deadlocks70.010.00
execute count707,115585.054.10
failed probes on index block reclamation40.000.00
file io service time618,476511.713.59
file io wait time38,658,959,64931,985,345.29224,155.39
free buffer inspected7,875,5416,516.0045.66
free buffer requested7,891,6736,529.3545.76
heap block compress34,95328.920.20
hot buffers moved to head of LRU1,906,9201,577.7311.06
immediate (CR) block cleanout applications3,7033.060.02
immediate (CURRENT) block cleanout applications17,54114.510.10
index crx upgrade (positioned)1,8761.550.01
index crx upgrade (prefetch)20.000.00
index fast full scans (full)330.030.00
index fetch by key475,834393.692.76
index scans kdiixs11,041,732861.906.04
leaf node 90-10 splits1790.150.00
leaf node splits4,4593.690.03
lob reads112,84193.360.65
lob writes91,92176.050.53
lob writes unaligned90,22774.650.52
logons cumulative22,69818.780.13
max cf enq hold time1530.130.00
messages received44,20936.580.26
messages sent44,20936.580.26
min active SCN optimization applied on CR3530.290.00
no buffer to keep pinned count7540.620.00
no work - consistent read gets49,007,53440,547.47284.16
non-idle wait count15,856,60513,119.3191.94
non-idle wait time2,944,8952,436.5217.08
opened cursors cumulative329,732272.811.91
parse count (describe)380.030.00
parse count (failures)170.010.00
parse count (hard)225,397186.491.31
parse count (total)478,093395.562.77
parse time cpu16,32313.510.09
parse time elapsed109,67590.740.64
physical read IO requests349,051288.802.02
physical read bytes61,817,053,18451,145,706.17358,432.45
physical read total IO requests354,391293.212.05
physical read total bytes61,903,782,40051,217,463.51358,935.33
physical read total multi block requests61,60650.970.36
physical reads7,546,0276,243.3743.75
physical reads cache7,545,8816,243.2543.75
physical reads cache prefetch7,203,8385,960.2541.77
physical reads direct1460.120.00
physical reads direct (lob)990.080.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests26,61022.020.15
physical write bytes663,248,896548,753.643,845.70
physical write total IO requests125,140103.540.73
physical write total bytes1,707,035,6481,412,353.709,897.87
physical write total multi block requests2,8622.370.02
physical writes80,96366.990.47
physical writes direct2470.200.00
physical writes direct (lob)1090.090.00
physical writes direct temporary tablespace20.000.00
physical writes from cache80,71666.780.47
physical writes non checkpoint63,61452.630.37
pinned buffers inspected970.080.00
pinned cursors current30.000.00
prefetch clients - default10.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use3530.290.00
process last non-idle time1,2041.000.01
recursive aborts on index block reclamation00.000.00
recursive calls2,366,4411,957.9313.72
recursive cpu usage29,64024.520.17
redo blocks checksummed by FG (exclusive)534,944442.603.10
redo blocks written961,531795.545.58
redo buffer allocation retries00.000.00
redo entries624,296516.533.62
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks11,3499.390.07
redo size465,094,820384,806.492,696.75
redo size for direct writes6,1045.050.04
redo subscn max counts37,52731.050.22
redo synch time1,775,1531,468.7110.29
redo synch writes174,555144.421.01
redo wastage11,536,3089,544.8266.89
redo write time116,95496.760.68
redo writes43,39835.910.25
rollback changes - undo records applied2,9042.400.02
root node splits00.000.00
rows fetched via callback196,478162.561.14
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits71,04558.780.41
session logical reads55,160,28645,638.08319.83
shared hash latch upgrades - no wait31,02325.670.18
shared hash latch upgrades - wait10.000.00
sorts (disk)00.000.00
sorts (memory)142,666118.040.83
sorts (rows)1,219,1311,008.677.07
sql area evicted221,505183.271.28
sql area purged190.020.00
summed dirty queue length22,29418.450.13
switch current to new buffer18,63915.420.11
table fetch by rowid14,603,74412,082.7384.68
table fetch continued row9,8458.150.06
table scan blocks gotten32,412,26326,817.00187.94
table scan rows gotten896,383,371741,642.615,197.48
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)73,17860.550.42
temp space allocated (bytes)00.000.00
total cf enq hold time19,30715.970.11
total number of cf enq holders2330.190.00
total number of times SMON posted30.000.00
transaction rollbacks2,2541.860.01
transaction tables consistent read rollbacks2330.190.00
transaction tables consistent reads - undo records applied16,44613.610.10
undo change vector size118,908,24898,381.37689.46
user I/O wait time953,228788.675.53
user calls7,183,4455,943.3841.65
user commits172,465142.691.00
user rollbacks00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal6,5735.440.04
write clones created in background00.000.00
write clones created in foreground6720.560.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory168,912,646,844,744169,003,965,252,456
opened cursors current357398
workarea memory allocated8,580613
logons current8990
session uga memory max5,581,880,239,2405,586,583,028,864
session pga memory118,472,318,048118,520,336,480
session pga memory max135,023,268,048135,074,170,320
session cursor cache count188,088,004188,249,755

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)
Buffer Cache Reads57.5G289.1948.69580M0.000M342.7K26.90
LGWR0M0.000M946M79.59.7826940 
DBWR0M0.000M627M21.84.5187620 
Others83M4.46.06867157M3.05.04716065924.62
Direct Writes0M0.000M2M0.03.0016540 
Direct Reads1M0.08.0008270M0.000M0 
Streams AQ0M0.020M0M0.000M2636.50
TOTAL:57.6G293.7548.76531.6G104.511.35027349.3K26.48

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
Data File57.5G289.4248.7090626M21.94.51793420.5653.52
Log File0M0.000M947M79.60.783521  
Control File82M4.33.06784456M2.99.0463320.26 
Temp File0M0.000M0M0.000M25.50 
TOTAL:57.6G293.7648.77681.6G104.531.3477820.2053.52

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)
Buffer Cache Reads 57.5G289.0548.69820M0.000M338K26.77
Buffer Cache Reads (Data File) 57.5G289.0548.69820M0.000M338K26.77
LGWR 0M0.000M947M79.59.7835210 
LGWR (Log File) 0M0.000M947M79.59.7835210 
DBWR 0M0.000M623M21.77.5154520 
DBWR (Data File) 0M0.000M623M21.77.5154520 
Others 83M4.46.06867157M3.05.04716053870.65
Others (Control File) 82M4.33.06784456M2.99.04633252340.26
Others (Data File) 1M0.13.0008271M0.06.00082715313.95
Direct Writes 0M0.000M2M0.03.0016540 
Direct Writes (Data File) 0M0.000M2M0.03.0016540 
Direct Reads 1M0.08.0008270M0.000M0 
Direct Reads (Data File) 1M0.08.0008270M0.000M0 
Streams AQ 0M0.020M0M0.000M2636.50
Streams AQ (Data File) 0M0.020M0M0.000M2636.50
TOTAL: 57.6G293.6148.76771.6G104.451.34778343.4K26.36

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TBS_RDB_DATA_01 96,4248021.0311.561,46811,50828.48
TBS_RDB_DATA_00 91,7197625.0231.693,9793130.00
TBS_RDB_DATA_02 62,5945239.9054.622,3502815.00
TBS_RDB_INDEX_00 48,4614024.741.009,02271838.31
TBS_RDB_INDEX_01 35,0682921.961.002,801219246.84
TBS_RDB_INDEX_02 4,111331.261.004,327410.00
SYSTEM 5,361428.424.4791000.00
SYSAUX 3,473332.651.36941100.00
TBS_RDB_UNDO_00 1,640127.741.001,7491577.19
TEMP_INITIAL 4025.001.002000.00
TBS_RDB_DEFAULT 1030.001.000000.00
USERS 1010.001.000000.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)
SYSAUX/space/rdb/db_sys/tbs_rdb_sysaux_f01.dbf 3,473332.651.36941100.00
SYSTEM/space/rdb/db_sys/tbs_rdb_system_f01.dbf 4,454428.143.6963000.00
SYSTEM/space/rdb/db_sys/tbs_rdb_system_f02.dbf 266030.158.522000.00
SYSTEM/space/rdb/db_sys/tbs_rdb_system_f03.dbf 70028.431.008000.00
SYSTEM/space/rdb/db_sys/tbs_rdb_system_f04.dbf 571029.819.1318000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f01.dbf 4,309421.3336.412000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f02.dbf 4,291425.7138.8040000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f03.dbf 4,297426.2632.45177000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f04.dbf 4,801423.9630.09157010.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f05.dbf 3,886322.8631.29262010.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f06.dbf 4,659424.8833.44317010.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f07.dbf 3,208326.6529.37163000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f08.dbf 3,688326.9341.2527000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f09.dbf 3,148329.7141.7315000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f10.dbf 4,533424.3726.3295040.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f11.dbf 4,946426.5830.4760000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f12.dbf 3,892330.4531.6276000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f13.dbf 4,214325.6134.484000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f14.dbf 4,268423.4326.394000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f15.dbf 4,092325.9228.524000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f16.dbf 4,886422.3328.503000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f17.dbf 2,091227.2526.40176010.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f18.dbf 1,770125.4025.02107000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f19.dbf 2,367227.7523.1115000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f20.dbf 2,155227.8119.1686000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f21.dbf 1,369130.9828.491,313130.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f22.dbf 4,021327.6244.44445010.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f23.dbf 820119.5639.11379010.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f24.dbf 2,839220.2337.840000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f25.dbf 2,472219.5144.060000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f26.dbf 230042.2657.950000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f27.dbf 264041.7466.300000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f28.dbf 1,847224.7414.8339000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f29.dbf 1,079120.8014.2612000.00
TBS_RDB_DATA_00/space/rdb/tbs_data_00/tbs_rdb_data_00_f30.dbf 1,27715.121.391000.00
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f01.dbf 3,815322.8415.881790926.52
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f02.dbf 3,492321.3516.351501737.92
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f03.dbf 3,233324.9117.131906611.97
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f04.dbf 3,376322.4416.072704117.07
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f05.dbf 3,710323.5713.925104219.29
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f06.dbf 7,568622.279.362860110151.82
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f07.dbf 9,966820.709.02284021161.18
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f08.dbf 10,128819.198.612307414.05
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f09.dbf 7,674620.5811.847408015.50
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f10.dbf 7,698619.0710.5373010210.10
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f11.dbf 7,516618.8011.14220879.66
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f12.dbf 6,549520.4011.725606813.82
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f13.dbf 7,647619.939.3723101528.82
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f14.dbf 4,928422.1912.075608514.59
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f15.dbf 5,191422.4512.114005912.71
TBS_RDB_DATA_01/space/rdb/tbs_data_01/tbs_rdb_data_01_f16.dbf 3,933324.3815.57320669.85
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f01.dbf 4,786437.1734.202370518.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f02.dbf 3,913337.6845.3037010.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f03.dbf 3,781339.0550.3848000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f04.dbf 3,357342.0455.8932000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f05.dbf 6,304530.6831.9167000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f06.dbf 5,834534.5636.9031000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f07.dbf 4,208338.9046.69151000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f08.dbf 4,368438.8746.51100000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f09.dbf 6,737626.9835.0884000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f10.dbf 2,584246.6382.9371000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f11.dbf 3,130348.6780.05115000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f12.dbf 400052.7087.090000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f13.dbf 1,383154.2492.420000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f14.dbf 1,332156.4695.380000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f15.dbf 2,816250.8271.958081110.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f16.dbf 2,009251.2490.66136000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f17.dbf 1,665149.1483.7153000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f18.dbf 1,376149.8893.5337000.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f19.dbf 1,479148.8083.103160120.00
TBS_RDB_DATA_02/space/rdb/tbs_data_02/tbs_rdb_data_02_f20.dbf 1,132153.45103.1927000.00
TBS_RDB_DEFAULT/space/rdb/db_sys01/tbs_rdb_default_f01.dbf 1030.001.000000.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f01.dbf 6,676631.201.002,2502380.26
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f02.dbf 5,665525.111.008661125.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f03.dbf 4,772422.781.00303010.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f04.dbf 4,590420.111.002710372.43
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f05.dbf 6,452523.891.001,06218914.27
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f06.dbf 6,482522.171.00673100.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f07.dbf 3,539320.711.0063000.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f09.dbf 900119.001.007000.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f10.dbf 2,818223.141.00582000.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f11.dbf 1,019115.321.00122000.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f12.dbf 288028.511.002000.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_00/tbs_rdb_index_00_f13.dbf 3,136338.751.002,6802615.00
TBS_RDB_INDEX_00/space/rdb/tbs_index_01/tbs_rdb_index_00_f08.dbf 2,124222.961.00141000.00
TBS_RDB_INDEX_01/space/rdb/tbs_index_01/tbs_rdb_index_01_f01.dbf 6,107522.121.00272000.00
TBS_RDB_INDEX_01/space/rdb/tbs_index_01/tbs_rdb_index_01_f02.dbf 5,664521.481.00205000.00
TBS_RDB_INDEX_01/space/rdb/tbs_index_01/tbs_rdb_index_01_f03.dbf 5,480521.031.00373000.00
TBS_RDB_INDEX_01/space/rdb/tbs_index_01/tbs_rdb_index_01_f04.dbf 6,443525.361.001,41719210.00
TBS_RDB_INDEX_01/space/rdb/tbs_index_01/tbs_rdb_index_01_f05.dbf 5,650520.641.0024907398.57
TBS_RDB_INDEX_01/space/rdb/tbs_index_01/tbs_rdb_index_01_f06.dbf 5,724520.611.00285033.33
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f01.dbf 1,206131.661.001,096100.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f02.dbf 1,143127.171.001,119110.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f03.dbf 1,567135.281.001,854200.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f04.dbf 3046.671.000000.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f05.dbf 36024.441.0034000.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f06.dbf 55017.821.0097000.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f07.dbf 13024.621.002000.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f08.dbf 49016.941.0085000.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f09.dbf 22021.361.0036000.00
TBS_RDB_INDEX_02/space/rdb/tbs_index_02/tbs_rdb_index_02_f10.dbf 17021.761.004000.00
TBS_RDB_UNDO_00/space/rdb/db_sys01/tbs_rdb_undo_00_f01.dbf 874129.921.009111110.91
TBS_RDB_UNDO_00/space/rdb/db_sys01/tbs_rdb_undo_00_f02.dbf 628126.481.004920468.70
TBS_RDB_UNDO_00/space/rdb/db_sys01/tbs_rdb_undo_00_f03.dbf 138019.641.00346000.00
TEMP_INITIAL/space/rdb/db_sys01/tbs_rdb_temp_initial_f01.dbf 4025.001.00200 
USERS/space/rdb/db_sys01/users01.dbf 1010.001.000000.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
D2,249,0438655,256,7497,757,41080,716001,789

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000034,2510

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
B1782520127394373351779366355203517793 6556 
E1802215573285586185809066355201858090 6363 

Back to Advisory Statistics
Back to Top

MTTR Advisory

Size for Est (s)Dirty LimitEst Cache WritesEst Cache Write FctrEst Total WritesEst Total Write FctrEst Total IOsEst Total IO Fctr
192,2301,156,3348.501,167,7667.92  
99171,216137,1201.01148,5531.01  
180338,455136,0401.00147,4731.00  
191361,166136,0261.00147,4591.00  
202383,878136,0071.00147,4401.00  

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
D1,7920.102215.9930,210,3501106754566.00
D3,5840.204425.2826,610,157192202170.00
D5,3760.296634.5923,143,980178191482.00
D7,1680.398843.9319,788,686164629010.00
D8,9600.491,1053.2816,551,022151541992.00
D10,7520.591,3262.6813,523,142139302963.00
D12,5440.691,5462.1510,824,638128395293.00
D14,3360.781,7671.708,566,326119266937.00
D16,1280.881,9881.346,739,193111881458.00
D17,9200.982,2091.055,282,26115992370.00
D18,3041.002,2571.005,039,61315011561.00
D19,7121.082,4300.824,150,30412125285.00
D21,5041.172,6510.663,301,64712097897.00
D23,2961.272,8720.542,700,35812078491.00
D25,0881.373,0930.462,338,71312066820.00
D26,8801.473,3140.412,067,19312058057.00
D28,6721.573,5350.371,845,57012050905.00
D30,4641.663,7560.331,641,62612044323.00
D32,2561.763,9770.291,453,87512038264.00
D34,0481.864,1970.251,272,08812032397.00
D35,8401.964,4180.221,093,85212026645.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.001,0710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B6,1445,363341.146.972.04100.000.00629,140
E6,1445,367327.060.000.000.000.00629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K6,1576,15700
64K128K393900
128K256K2200
256K512K8800
512K1024K29329300
1M2M515100
2M4M4400
4M8M101000
8M16M101000
256M512M2200

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
7680.132,788,116.61162,190.9395.0012,492,095,174
1,5360.252,788,116.61162,190.9395.0012,492,095,174
3,0720.502,788,116.61162,187.2495.0002,492,092,056
4,6080.752,788,116.61162,187.2495.0002,492,092,056
6,1441.002,788,116.6129,043.6499.0002,379,626,996
7,3731.202,788,116.6126,214.8999.0002,377,237,578
8,6021.402,788,116.6126,214.8999.0002,377,237,578
9,8301.602,788,116.6126,214.8999.0002,377,237,578
11,0591.802,788,116.6126,214.8999.0002,377,237,578
12,2882.002,788,116.6126,214.8999.0002,377,237,578
18,4323.002,788,116.6126,214.8999.0002,377,237,578
24,5764.002,788,116.6126,214.8999.0002,377,237,578
36,8646.002,788,116.6126,214.8999.0002,377,237,578
49,1528.002,788,116.6126,214.8999.0002,377,237,578

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)
8,5760.7958050,78742,539,8961.002,445,5991.02784,919
9,7280.891,744118,55342,554,7301.002,430,7651.011,592,780
10,8801.002,896151,19542,583,2441.002,402,2511.001,595,029
12,0321.114,048184,71142,609,2211.002,376,2740.991,597,192
13,1841.215,200218,61442,633,4161.002,352,0790.981,599,275
14,3361.326,351251,23142,655,9551.002,329,5400.971,601,276
15,4881.427,503281,60342,676,8751.002,308,6200.961,603,189
16,6401.538,655310,35842,696,1771.002,289,3180.951,605,010
17,7921.649,807337,91642,713,8831.002,271,6120.951,606,737
18,9441.7410,959365,61342,730,1021.002,255,3930.941,608,375
20,0961.8512,111393,63642,745,0351.002,240,4600.931,609,935
21,2481.9513,262423,53442,758,8771.002,226,6180.931,611,425
22,4002.0614,414454,30042,771,7771.002,213,7180.921,612,854

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
15,3600.50109,065,92035,326,071,892
19,2000.6378,146,48725,262,641,700
23,0400.7551,292,01216,522,087,178
26,8800.8832,116,47810,286,681,210
30,7201.0020,781,9795,039,526,362
34,5601.1320,700,9355,039,526,362
38,4001.2520,611,5816,334,684,637
42,2401.3820,543,0025,039,526,362
46,0801.5020,505,5984,121,828,611
49,9201.6320,466,1183,155,247,455
53,7601.7520,451,5782,505,652,507
57,6001.8820,437,0461,941,729,507
61,4402.0020,430,8181,669,595,084

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)
1281.000000
2562.000000
3843.000000
5124.000000
6405.000000
7686.000000
8967.000000
1,0248.000000
1,1529.000000
1,28010.000000
1,40811.000000
1,53612.000000
1,66413.000000
1,79214.000000
1,92015.000000
2,04816.000000
2,17617.000000
2,30418.000000
2,43219.000000
2,56020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block1,6694930
undo header5108
1st level bmb5200
segment header800
undo block600
2nd level bmb300

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 3,0943,0940199733.87
HW-Segment High Water Mark 1,2371,237050120.30
TX-Transaction 179,512179,560016135.19
SQ-Sequence Cache 161604035.25
CF-Controlfile Transaction 86086002043.00
FB-Format Block 1,4431,44303018.33
TX-Transaction (allocate ITL entry) 86860301.33

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
223.81205,2891,475131440/14400/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
26-Apr 08:158,47478,8951,475131,4400/00/0/0/0/0/0
26-Apr 08:0515,333126,3941,110101,4400/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 latch300.00 00 
AQ deq log cmt cbk chunk latch20.00 00 
AQ deq log statistics latch10.00 00 
AQ dequeue txn counter latch1,0440.00 00 
AQ ht cmt cbk chunk latch40.00 00 
ASM db client latch8260.00 00 
ASM map operation hash table10.00 00 
ASM network state latch540.00 00 
AWR Alerted Metric Element list10,7110.00 00 
Change Notification Hash table latch3930.00 00 
Consistent RBA43,2520.010.0000 
DML lock allocation805,0580.060.0100 
Event Group Locks22,6330.080.0000 
FIB s.o chain latch20.00 00 
FOB s.o list latch69,9280.110.0000 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch1,046,9050.030.820179,2100.01
JS Sh mem access30.00 00 
JS mem alloc latch10.00 00 
JS queue access latch20.00 00 
JS queue state obj latch8,3880.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch4020.00 00 
KTF sga latch80.00 04040.00
KWQMN job cache list latch150.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch70.00 00 
KWQS pqueue ctx latch630.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0240.00
Memory Management Latch10.00 04020.00
Memory Queue10.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 Latch70.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process68,2570.00 00 
OS process allocation45,9071.780.0000 
OS process: request allocation45,3331.450.0400 
PL/SQL warning settings27,9770.030.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch2,8510.00 00 
SGA IO buffer pool latch3220.00 03230.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 03920.00
SQL memory manager workarea list latch34,6670.00 00 
Shared B-Tree2070.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 latch9740.00 00 
active service list116,0920.470.160701,1470.06
archive control1920.00 00 
begin backup scn array1140.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles33,1180.030.0000 
cache buffers chains124,220,6010.020.01027,507,5640.00
cache buffers lru chain557,2860.770.03020,169,4010.69
cache table scan latch174,2540.110.150176,1800.11
call allocation70,2261.120.2410 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch45,3510.570.0500 
channel operations parent latch75,4950.130.0100 
checkpoint queue latch180,4430.000.00075,7470.00
client/application info161,1510.040.0600 
compile environment latch22,6710.040.0000 
corrupted undo seg latch11,0260.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch540.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch540.00 00 
dml lock allocation540.00 00 
done queue latch10.00 00 
dummy allocation45,3670.270.0200 
enqueue hash chains1,679,9740.180.02130.00
enqueues595,5880.460.0410 
fifth spare latch10.00 00 
file cache latch2960.00 00 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA22,6120.00 00 
global ctx hash table latch10.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch4780.00 0362,6630.00
hash table modification latch910.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch350.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch220.00 0210.00
job_queue_processes free list latch420.00 00 
job_queue_processes parameter latch2740.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats1,434,4750.620.63630 
kokc descriptor allocation latch4900.00 00 
ksfv messages10.00 00 
kss move lock110.00 00 
ksuosstats global area840.00 00 
ksv allocation latch750.00 00 
ksv class latch230.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch45,3333.110.0000 
ktm global data140.00 00 
kwqbsn:qsga670.00 00 
lgwr LWN SCN43,3370.020.0000 
list of block allocation15,2550.180.0000 
loader state object freelist4500.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch50.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent1880.00 01880.00
mapped buffers lru chain10.00 00 
message pool operations parent latch1300.00 00 
messages145,6600.270.0300 
mostly latch-free SCN43,4870.300.0000 
msg queue latch10.00 00 
multiblock read objects402,4090.050.0600 
name-service namespace bucket10.00 00 
ncodef allocation latch540.00 00 
object queue header heap42,6270.00 034,0530.00
object queue header operation16,052,9330.010.0410 
object stats modification6,5710.030.5000 
parallel query alloc buffer1570.00 00 
parallel query stats10.00 00 
parameter list204,5530.100.0000 
parameter table management45,3620.000.0000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue192,6370.090.040284,2680.24
process allocation45,3762.820.03021,4665.59
process group creation45,3330.160.0300 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch1750.00 00 
query server freelists10.00 00 
queued dump request40.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation493,3000.040.050621,7050.49
redo copy10.00 0622,9440.22
redo writing135,7240.000.0000 
resmgr group change latch23,3020.000.0000 
resmgr:active threads45,4830.00 00 
resmgr:actses change group22,8740.00 00 
resmgr:actses change state1170.00 00 
resmgr:free threads list45,3660.450.0200 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects12,932,6931.550.0192,8220.39
rules engine aggregate statistics10.00 00 
rules engine rule set statistics1020.00 00 
second spare latch10.00 00 
sequence cache68,3861.100.0000 
session allocation841,5120.850.000280,4990.04
session idle bit14,631,9590.050.0100 
session queue latch10.00 00 
session state list latch5780.00 00 
session switching113,3850.050.0000 
session timer1,1410.00 00 
shared pool14,844,5572.330.161720 
shared pool sim alloc10.00 00 
shared pool simulator2,348,8880.010.1100 
sim partition latch10.00 00 
simulator hash latch4,202,5160.000.0900 
simulator lru latch55,2630.150.0603,987,0810.18
sort extent pool1200.00 00 
space background state object latch20.00 00 
space background task latch8940.00 08040.00
state object free list120.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation40.00 00 
temporary table state object allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch830.00 00 
transaction allocation36,5630.010.0000 
transaction branch allocation1,1410.00 00 
undo global data1,095,8020.080.0100 
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
shared pool14,844,557346,30556,579290,847
row cache objects12,932,693200,5241,416199,116
cache buffers chains124,220,60131,01936830,668
kks stats1,434,4758,8535,5473,354
session allocation841,5127,125167,109
session idle bit14,631,9597,0851036,982
cache buffers lru chain557,2864,2881274,162
enqueue hash chains1,679,9743,106723,034
enqueues595,5882,7291132,616
object queue header operation16,052,9331,683741,610
ksz_so allocation latch45,3331,41041,406
process allocation45,3761,279401,243
undo global data1,095,80286110852
OS process allocation45,9078151814
call allocation70,226790192604
OS process: request allocation45,33365926633
active service list116,09254187455
DML lock allocation805,0584937486
messages145,66040011389
In memory undo latch1,046,90533627463
channel handle pool latch45,35125914245
multiblock read objects402,40921013197
resmgr:free threads list45,3662044200
cache table scan latch174,25419930171
shared pool simulator2,348,88819921178
redo allocation493,3001869177
post/wait queue192,6371797172
dummy allocation45,3671243121
simulator hash latch4,202,51612211111
channel operations parent latch75,495100199
simulator lru latch55,26385580
process group creation45,33374272
client/application info161,15170466
object stats modification6,571211

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam033
DML lock allocationktadmc020
DML lock allocationktaidm024
In memory undo latchktiFlush: child019975
In memory undo latchkticmt: child07538
In memory undo latchktichg: child07153
In memory undo latchktiFlushMe010
OS process allocationkso_delete_process:1011
OS process: request allocationkso_new_process02525
OS process: request allocationksoreqholder_delete011
active service listkswslogon: session logout09286
active service listkswslogon: session login01816
active service listkswsgsnp: get service name ptr0312
active service listkswsasidlist: return list of service name010
active service listkswssvhid2nam: get service name from id010
cache buffers chainskcbgtcr: fast path (cr pin)015351
cache buffers chainskcbgtcr: fast path09529
cache buffers chainskcbgcur: fast path (shr)04718
cache buffers chainskcbgtcr_203226
cache buffers chainskcbchg1: kslbegin: bufs not pinned03113
cache buffers chainskcbgcur_201317
cache buffers chainskcbrls_1013186
cache buffers chainskcbget: pin buffer01113
cache buffers chainskcbzibmlt: multi-block read: nowait080
cache buffers chainskcbgcur_50619
cache buffers chainskcbget: exchange0414
cache buffers chainskcbzwb041
cache buffers chainskcbchg1: kslbegin: call CR func0310
cache buffers chainskcbget: exchange rls032
cache buffers chainskcbgcur_4028
cache buffers chainskcbzgb: scan from tail. nowait020
cache buffers chainskcb_commit011
cache buffers chainskcb_post_apply: kcbhq62012
cache buffers chainskcbgtcr: kslbegin excl014
cache buffers chainskcbnew: new latch again011
cache buffers chainskcbnlc011
cache buffers chainskcbrls_20113
cache buffers lru chainkcbzgws01240
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_1010
cache buffers lru chainkcbibr010
cache buffers lru chainkcbzgm010
cache table scan latchkcbz_find_table_scan_read_buffer0230
cache table scan latchkcbz_free_table_scan_read_buffer0730
call allocationksuxds0166153
call allocationksudlp: top call01411
call allocationksucrp: top call01126
call allocationksudlc : rec call011
channel handle pool latchksrchconnect()0149
channel operations parent latchksrchdelete_sub()011
client/application infokskirefrattrmap054
client/application infoksuinfos_modact034
dummy allocationktcscnfy033
enqueue hash chainsksqgtl304549
enqueue hash chainsksqrcl02723
enqueuesksqgel: create enqueue05885
enqueuesksqdel05528
kks statskksAllocChildStat05,5495,549
ksz_so allocation latchksznfy1034
ksz_so allocation latchksz_parent_so_del1010
messagesksaamb: after wakeup0107
messagesksarcv014
multiblock read objectskcbzibmlt092
multiblock read objectskcbzibmlt: normal mbr free0411
object queue header operationkcbo_unlink_q03827
object queue header operationkcbo_link_q0246
object queue header operationkcbo_switch_mq_bg0510
object queue header operationkcbo_switch_cq0431
object queue header operationkcbo_sw_buf020
object queue header operationkcbo_link_q:reget010
object queue header operationkcbo_switch_q_bg010
object stats modificationksols_rank010
post/wait queueksliwat:remove057
post/wait queueksliwat:add:nowait010
post/wait queuekslpstevent:reget010
process allocationksucrp:10310
process allocationksudlp052
process allocationksuapc0438
process group creationksupgpadd011
process group creationksupgprem011
redo allocationkcrfw_redo_gen: redo allocation 1090
resmgr:free threads listkskthrcreate032
resmgr:free threads listkskthrsod012
row cache objectskqreqd: reget01,22317
row cache objectskqrpre: find obj01601,293
row cache objectskqreqd02097
row cache objectskqrso061
row cache objectskqrcmt: while loop010
session allocationksuxds_int076
session allocationksucri_int : licensing067
session allocationksuxds033
session idle bitksupuc: set busy05926
session idle bitksupuc: clear busy03663
session idle bitksuxds01117
shared poolkghalo034,50931,149
shared poolkghupr1012,48511,891
shared poolkghalp05,2648,604
shared poolkghfre02,8933,038
shared poolkgh_heap_sizes09411,727
shared poolkghasp0301200
shared poolkgh_next_free02151
shared poolkghfrunp: clatch: nowait030
shared poolkghfrunp: clatch: wait037
shared poolkghfrunp: alloc: wait020
shared pool simulatorkglsim_upd_newhp0217
simulator hash latchkcbs_lookup_setid: lookup dba072
simulator hash latchkcbsacc: lookup dba047
simulator lru latchkcbs_simulate: simulate set050
undo global dataktubnd_4040
undo global dataktudba: KSLBEGIN033
undo global dataktudnx:child021
undo global dataktufrbs_2016

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgh1 64894,835-0
Library Cachekglhdgn2 106299,0082
Library Cachekgllkdl1 85117,3010
Cursor Pinkksfbc [KKSCHLFSP2]86,0560
Library Cachekglhdgn1 6220,860-2
Cursor Pinkkslce [KKSCHLPIN2]10,015-10
Library Cachekglpin1 48,2300
Library Cachekglget2 27,854-18
Library Cachekglpndl1 953,0610
Library Cachekglpnal1 901,4790
Library Cachekgllkc1 577988
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]7060
Library Cachekglobpn1 713910
Cursor PinkksLockDelete [KKSCHLPIN6]3080
Library Cachekglrfcl1 79230-1
Library Cachekgldtin1 42260
Cursor Pinkksfbc [KKSCHLPIN1]50
hash tablekkscsSearchChildList [KKSHBKLOC2]20
hash tablekkshGetNextChild [KKSHBKLOC1]20
Library Cachekgluhfs1 5310

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
RDB_QCTBS_RDB_DATA_01RAWSR_ELE_99RAWSR_ELE_99_P07TABLE PARTITION1,741,6803.16
RDB_INSERTTBS_RDB_DATA_02RDB_STATION_GLOBAL TABLE1,696,8163.08
RDB_INSERTTBS_RDB_DATA_00RAWST_ELE_04SYS_SUBP15590TABLE SUBPARTITION1,569,2642.84
RDB_INSERTTBS_RDB_DATA_00RAWST_ELE_04SYS_SUBP15591TABLE SUBPARTITION1,563,8882.84
RDB_INSERTTBS_RDB_DATA_00RAWST_ELE_04SYS_SUBP15594TABLE SUBPARTITION1,557,3922.82

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
RDB_QCTBS_RDB_DATA_01RAWSR_ELE_99RAWSR_ELE_99_P07TABLE PARTITION52,7640.70
RDB_QCTBS_RDB_DATA_01RAWSR_ELE_99RAWSR_ELE_99_P08TABLE PARTITION36,2330.48
RDB_QCTBS_RDB_DATA_01RAWSR_ELE_99RAWSR_ELE_99_P09TABLE PARTITION32,3680.43
RDB_INSERTTBS_RDB_DATA_01RBULL_REP_04RBULL_REP_04_P26TABLE PARTITION12,2360.16
RDB_INSERTTBS_RDB_DATA_02RSUAT_ELE_04SYS_SUBP51834TABLE SUBPARTITION2,5880.03

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
RDB_INSERTTBS_RDB_DATA_01RREAU_REP_04RREAU_REP_04_P26TABLE PARTITION1,7430.50
RDB_INSERTTBS_RDB_DATA_01RBULL_REP_04RBULL_REP_04_P26TABLE PARTITION9330.27
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX8460.24
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_IDX01 INDEX7960.23
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_UK INDEX7920.23

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
RDB_INSERTTBS_RDB_DATA_01RREAU_REP_04RREAU_REP_04_P26TABLE PARTITION1,7430.50
RDB_INSERTTBS_RDB_DATA_01RBULL_REP_04RBULL_REP_04_P26TABLE PARTITION9330.27
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX8460.24
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_IDX01 INDEX7960.23
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_UK INDEX7920.23

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
RDB_INSERTTBS_RDB_DATA_01RREAU_REP_04RREAU_REP_04_P26TABLE PARTITION6,0997.53
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_UK INDEX3,4564.27
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX2,2942.83
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_UK INDEX1,5781.95
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_IDX01RREAU_REP_04_P26INDEX PARTITION1,3441.66

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX1,3525.08
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_UK INDEX1,1794.43
RDB_INSERTTBS_RDB_INDEX_00RAWST_ELE_04_UK INDEX8603.23
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_IDX01RREAU_REP_04_P26INDEX PARTITION7492.81
RDB_INSERTTBS_RDB_DATA_01RREAU_REP_04RREAU_REP_04_P26TABLE PARTITION7482.81

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
DBSNMPTEMP_INITIALMGMT_TEMPT_SQL TABLE10.40

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
DBSNMPTEMP_INITIALMGMT_TEMPT_SQL TABLE308,97650.76
RDB_INSERTTBS_RDB_DATA_01RREAU_REP_04RREAU_REP_04_P26TABLE PARTITION21,8243.59
RDB_INSERTTBS_RDB_INDEX_00RAWST_ELE_04_UK INDEX17,8722.94
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX17,6962.91
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_UK INDEX16,1442.65

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX34515.72
RDB_INSERTTBS_RDB_INDEX_00RAWST_ELE_04_UK INDEX31314.26
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_UK INDEX22610.30
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_IDX01RREAU_REP_04_P26INDEX PARTITION1577.15
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_UK INDEX1074.87

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_UK INDEX1013.16
RDB_INSERTTBS_RDB_INDEX_00R2CWE_ELE_04_IDX01 INDEX810.53
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_UK INDEX79.21
RDB_INSERTTBS_RDB_INDEX_00RFINE_ELE_04_IDX01RFINE_ELE_04_P26INDEX PARTITION79.21
RDB_INSERTTBS_RDB_INDEX_01RREAU_REP_04_UK INDEX67.89

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
RDB_INSERTTBS_RDB_DATA_01RREAU_REP_04RREAU_REP_04_P26TABLE PARTITION6224.60
RDB_INSERTTBS_RDB_INDEX_00RAWST_ELE_04_IDX02SYS_SUBP15594INDEX SUBPARTITION239.13
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_IDX02SYS_SUBP9735INDEX SUBPARTITION145.56
RDB_INSERTTBS_RDB_INDEX_00RAWSP_ELE_04_IDX02SYS_SUBP9739INDEX SUBPARTITION135.16
RDB_INSERTTBS_RDB_INDEX_00RAWST_ELE_04_IDX02SYS_SUBP15592INDEX SUBPARTITION135.16

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control240.000 21
dc_files1,7850.000 0105
dc_global_oids2,1550.370 0110
dc_histogram_data1,682,4450.050 07,802
dc_histogram_defs871,3970.310 1112,305
dc_object_grants1,0340.000 0124
dc_objects1,641,6980.010 67,570
dc_profiles22,6530.000 01
dc_rollback_segments6,9390.000 0467
dc_segments240,2964.310 8710,594
dc_sequences1225.000 122
dc_tablespace_quotas3280.000 014
dc_tablespaces35,3680.000 014
dc_users1,094,9510.000 0157
global database name23,4420.000 01
outstanding_alerts267.690 111
sch_lj_oids10.000 07


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
APP CONTEXT9030.009030.0000
BODY5281.524,0160.4570
CLUSTER2142.80946.3800
DBLINK45,2700.000 00
DIRECTORY6,3030.0212,6060.0200
EDITION22,6570.0045,3080.0000
INDEX277,4610.05276,7450.0500
OBJECT ID2100.000 00
QUEUE3,2540.003,8510.0000
RULESET10.0010.0000
SCHEMA46,1260.000 00
SQL AREA838,83179.051,366,09548.831,05019
SUBSCRIPTION80.0080.0000
TABLE/PROCEDURE531,4900.061,205,2870.231,7880
TRIGGER4,3220.004,3550.1150


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 cache18,304.0018,304.0010,880.0020,096.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target6,144.006,144.006,144.006,144.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target30,720.0030,720.0030,720.0030,720.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool128.00128.00128.00128.000STA/
large pool1,024.001,024.001,024.001,024.000STA/
shared pool10,880.0010,880.009,088.0018,304.000GRO/DEF
streams pool128.00128.00128.00128.000STA/

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
BOther206.50 2.022.772428102102
 Freeable91.560.001.614.4233 5757
 PL/SQL26.3613.840.270.78669999
 SQL16.2412.860.191.019698763
EOther201.32 2.082.8324289797
 Freeable92.880.001.604.4333 5858
 PL/SQL24.9512.420.260.79669595
 SQL4.451.280.050.101698569

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers19,193,135,104 
Fixed Size2,214,592 
Redo Buffers98,435,072 
Variable Size18,119,394,624 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory128.00128.000.00
largefree memory1,016.191,016.190.00
sharedCCUR528.71537.411.65
sharedKGH: NO ACCESS3,399.903,399.900.00
sharedKGLHD213.98216.941.38
sharedPCUR654.59667.802.02
sharedSQLA2,254.072,252.77-0.06
sharedfree memory6,277.206,248.11-0.46
sharedkglsim object batch227.15227.150.00
streamsfree memory126.73126.730.00
 buffer_cache18,304.0018,304.000.00
 fixed_sga2.112.110.00
 log_buffer93.8893.880.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0402 12:15:310.030.960.00
QMON Coordinator0402 12:15:210.010.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 11100.000.000.734.560.000.03
SYSMAN.MGMT_NOTIFY_Q(1918865) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(1918535) 32320.000.000.030.750.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12343) 0.000.000.734.56
SYSMAN.MGMT_NOTIFY_Q(1918865) 0.000.00  
SYSMAN.MGMT_TASK_Q(1918535) 0.030.030.000.02

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE 000   
MDSS_RDB_IBM_3938_RDB(22)/SYS.ALERT_QUE 1100.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
001010

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

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
1,2040.00100.000.000.00

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

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.001,2040.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/space/rdb/ora_dump/adump  
audit_sys_operationsTRUE  
audit_trailOS  
compatible11.2.0.0.0  
control_file_record_keep_time70  
control_files/space/rdb/db_sys/control_files/control_rdb_01.ctl, /space/rdb/control_file_local/control_rdb_02.ctl, /space/rdb/control_file_gpfs/control_rdb_03.ctl  
db_block_size8192  
db_cache_size10737418240  
db_domain    
db_files1000  
db_namerdb  
db_recovery_file_dest/space/rdb/flash_recovery  
db_recovery_file_dest_size53687091200  
diagnostic_dest/space/rdb/ora_dump  
dispatchers(PROTOCOL=TCP) (SERVICE=rdbXDB)  
fast_start_mttr_target180  
job_queue_processes1000  
large_pool_size1073741824  
local_listener    
lock_sgaFALSE  
log_buffer20971520  
memory_target0  
open_cursors300  
pga_aggregate_target6442450944  
processes1000  
query_rewrite_enabledFALSE  
remote_login_passwordfileEXCLUSIVE  
sessions1528  
sga_max_size37580963840  
sga_target32212254720  
shared_pool_size2147483648  
undo_retention86400  
undo_tablespaceTBS_RDB_UNDO_00  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report