WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
JQHX2877231475jqhx103-8月 -13 10:0811.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
localhost.localdomainLinux x86 64-bit 24 12 2 47.16

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:419003-9月 -13 10:00:40766 .4
End Snap:419103-9月 -13 11:00:05856 .5
Elapsed:  59.41 (mins)  
DB Time:  3,489.86 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 3,008M 3,008MStd Block Size: 8K
Shared Pool Size: 4,640M 4,640MLog Buffer: 17,552K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 58.7 8.1 0.23 0.23
DB CPU(s): 1.4 0.2 0.01 0.01
Redo size: 2,108,229.9 291,041.1  
Logical reads: 40,046.2 5,528.4  
Block changes: 1,942.6 268.2  
Physical reads: 529.5 73.1  
Physical writes: 350.8 48.4  
User calls: 260.2 35.9  
Parses: 224.7 31.0  
Hard parses: 27.9 3.8  
W/A MB processed: 6.1 0.8  
Logons: 32.1 4.4  
Executes: 257.1 35.5  
Rollbacks: 1.2 0.2  
Transactions: 7.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.65Redo NoWait %: 84.75
Buffer Hit %: 98.94In-memory Sort %: 100.00
Library Hit %: 93.10Soft Parse %: 87.61
Execute to Parse %: 12.61Latch Hit %: 98.83
Parse CPU to Parse Elapsd %: 51.01% Non-Parse CPU: 93.58

Shared Pool Statistics

BeginEnd
Memory Usage %: 76.59 75.59
% SQL with executions>1: 67.32 69.47
% Memory for SQL w/exec>1: 78.86 83.13

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
enq: SQ - contention4,11896,9842355146.32Configuration
log file switch (checkpoint incomplete)1,90264,3423382930.73Configuration
log file sync21,08714,2786776.82Commit
buffer busy waits243,2767,620313.64Concurrency
log buffer space7,5055,9207892.83Configuration

Host CPU (CPUs: 24 Cores: 12 Sockets: 2)

Load Average BeginLoad Average End%User%System%WIO%Idle
3.53 11.04 3.5 3.2 4.6 93.2
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
5.6 82.0 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 48,288.7 48,288.7
SGA use (MB): 7,808.0 7,808.0
PGA use (MB): 935.6 1,061.1
% Host Mem used for SGA+PGA: 18.11 18.37

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time187,980.1489.77
sequence load elapsed time106,450.8750.84
DB CPU4,966.612.37
connection management call elapsed time3,539.181.69
parse time elapsed630.470.30
hard parse elapsed time312.870.15
failed parse elapsed time137.860.07
hard parse (sharing criteria) elapsed time17.570.01
PL/SQL execution elapsed time4.620.00
PL/SQL compilation elapsed time0.050.00
repeated bind elapsed time0.000.00
DB time209,391.31 
background elapsed time13,315.64 
background cpu time213.94 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME631,438 
IDLE_TIME8,587,676 
IOWAIT_TIME422,212 
NICE_TIME41 
SYS_TIME298,811 
USER_TIME323,893 
LOAD411
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES2,069,504 
VM_OUT_BYTES41,984 
PHYSICAL_MEMORY_BYTES50,634,383,360 
NUM_CPUS24 
NUM_CPU_CORES12 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,586 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
03-9月 10:00:403.53     
03-9月 11:00:0511.046.853.513.2493.154.58

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Configuration15,4860169,7951096481.09
Commit21,087014,2786776.82
Concurrency329,23708,657264.13
DB CPU  4,967 2.37
Application138,23901,398100.67
User I/O842,255081910.39
Other8,297524760.02
Network599,41801000.00
System I/O120000.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
enq: SQ - contention4,118096,984235510.1646.32
log file switch (checkpoint incomplete)1,902064,342338290.0730.73
log file sync21,087014,2786770.826.82
buffer busy waits243,27607,620319.423.64
log buffer space7,50505,9207890.292.83
log file switch completion1,35801,35910010.050.65
enq: TX - row lock contention18401,24767760.010.60
log file switch (private strand flush incomplete)5901,189201470.000.57
library cache: mutex X77,3050955122.990.46
direct path write temp12,6700700550.490.33
db file sequential read440,847087017.070.04
enq: KO - fast object checkpoint3079263590.000.04
SQL*Net break/reset to client138,05207215.350.03
latch: In memory undo latch1190645340.000.03
latch free934037400.040.02
db file scattered read242,35001309.390.01
direct path read3,6000930.140.00
read by other session134,8190805.220.00
SQL*Net message from dblink78081040.000.00
latch: shared pool3,7550820.150.00
cursor: pin S wait on X53407130.020.00
enq: FB - contention1,8030740.070.00
enq: TX - index contention11803230.000.00
SQL*Net more data to client83,6890203.240.00
enq: HW - contention4740130.020.00
kksfbc child completion211001510.000.00
Disk file operations I/O2,0580110.080.00
enq: TX - contention4670120.020.00
library cache lock1280170.000.00
direct path read temp5,9110100.230.00
latch: cache buffers chains3,5310100.140.00
SQL*Net message to client515,53601019.960.00
latch: enqueue hash chains1900130.010.00
latch: redo allocation5030010.020.00
latch: cache buffer handles700400.000.00
cursor: mutex S1000110.000.00
latch: row cache objects3380000.010.00
latch: object queue header operation610010.000.00
cursor: pin S1190000.000.00
latch: redo writing700000.000.00
cursor: mutex X30040.000.00
latch: active service list110010.000.00
asynch descriptor resize4,251100000.160.00
SQL*Net more data from client430000.000.00
latch: messages130000.000.00
latch: undo global data30000.000.00
SQL*Net message from client515,47002,753,895534219.96 
jobq slave wait7,4911003,7505010.29 
single-task message6011730.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file async I/O submit741010,069135880.0375.62
log file parallel write9,9980990990.397.44
log file switch (checkpoint incomplete)300604201360.004.54
buffer busy waits42022854330.001.71
control file parallel write4,5150199440.171.49
Data file init write6,1560192310.241.44
latch free8,76307990.340.59
rdbms ipc reply35836317920.000.47
enq: CF - contention2220441980.010.33
log buffer space3304212760.000.32
Disk file operations I/O862035400.030.26
enq: JD - contention1033334220.000.25
latch: call allocation6,03802130.230.16
db file sequential read1,396019130.050.14
control file sequential read919,018017035.590.13
Log archive I/O7,49201520.290.11
log file switch (private strand flush incomplete)201470420.000.11
db file single write916014150.040.10
log file switch completion50611270.000.04
latch: shared pool1,4150430.050.03
os thread startup13704290.010.03
log file sequential read8,0100300.310.02
log file single write20603140.010.02
asynch descriptor resize112,297100104.350.01
log file sync3013680.000.01
direct path sync2001720.000.00
SQL*Net message to client448,14900017.360.00
db file scattered read200580.000.00
ADR block file read160040.000.00
LGWR wait for redo copy4700000.020.00
ADR block file write50090.000.00
latch: cache buffers lru chain1570000.010.00
latch: active service list400000.000.00
direct path write530000.000.00
latch: In memory undo latch100010.000.00
latch: redo allocation120000.000.00
latch: enqueue hash chains110000.000.00
reliable message130000.000.00
latch: cache buffers chains30000.000.00
rdbms ipc message141,1281255,4383935.47 
DIAG idle wait7,4771007,48510010.29 
Space Manager: slave idle wait1,132975,55749090.04 
SQL*Net message from client560,28604,709821.70 
shared server idle wait1261003,780300020.00 
Streams AQ: qmn coordinator idle wait268503,753140050.01 
Streams AQ: qmn slave idle wait13403,753280090.01 
dispatcher timer621003,720600030.00 
pmon timer5,506203,6736670.21 
smon timer25363,6231449280.00 
class slave wait210000.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 read1675.0 6.312.5  6.3 
ADR block file write5   40.060.0   
ADR file lock6100.0       
ARCH wait for archivelog lock108100.0       
Data file init write6156.360.37.7.0.1.131.4.0
Disk file operations I/O299189.27.1    3.5.2
LGWR wait for redo copy47497.02.3.6     
Log archive I/O75922.288.58.6.1.2.2.3 
SQL*Net break/reset to client141.6K94.4.12.02.5.7.2.1 
SQL*Net message from dblink78      100.0 
SQL*Net message to client981K100.0  .0    
SQL*Net message to dblink72100.0       
SQL*Net more data from client43100.0       
SQL*Net more data to client84K100.0       
asynch descriptor resize118.9K100.0       
buffer busy waits247.6K99.4.2.1.1.0.0.1.2
buffer deadlock20100.0       
control file parallel write4612   .519.435.344.7.1
control file sequential read947.7K100.0  .0.0.0.0.0
cursor: mutex S10    100.0   
cursor: mutex X366.7   33.3   
cursor: pin S12096.7.8.8 1.7   
cursor: pin S wait on X5517.311.41.51.556.316.35.8 
db file async I/O submit748  .1.73.34.715.675.5
db file scattered read242.5K100.0 .0.0.0.0.0.0
db file sequential read442.6K99.6.0.0.0.0.1.2.0
db file single write936 .11.818.546.728.14.8 
direct path read358590.51.8.73.01.1.72.2 
direct path read temp591199.8.0.0.0.0.0.1 
direct path sync2      100.0 
direct path write53100.0       
direct path write temp12.7K .0.13.99.221.765.0 
enq: CF - contention22710.61.8  1.3.985.0.4
enq: FB - contention180397.9.2.1 .3.4.9.2
enq: HW - contention47481.612.43.21.1  1.7 
enq: JD - contention1       100.0
enq: KO - fast object checkpoint3       100.0
enq: SQ - contention4338.6.9.7.8.8.620.175.4
enq: TX - contention46896.4.6.2   2.8 
enq: TX - index contention11815.32.514.46.87.622.930.5 
enq: TX - row lock contention1879.65.94.33.22.78.028.338.0
kksfbc child completion22      100.0 
latch free98512.2.1.252.934.54.45.7 
latch: In memory undo latch12925.61.6 3.13.93.944.217.8
latch: active service list5180.419.6      
latch: cache buffer handles7      100.0 
latch: cache buffers chains354898.9.4.2.3.0.1.1 
latch: cache buffers lru chain16495.13.7.6.6    
latch: call allocation618863.58.35.67.28.36.5.7 
latch: enqueue hash chains22475.07.19.82.23.12.2.4 
latch: messages13100.0       
latch: object queue header operation6385.74.8  6.33.2  
latch: redo allocation54580.48.65.93.51.5.2  
latch: redo writing7298.61.4      
latch: row cache objects34691.06.12.9     
latch: shared pool524380.95.55.74.2.91.01.8 
latch: undo global data3100.0       
library cache load lock1100.0       
library cache lock13016.218.58.526.222.36.91.5 
library cache: mutex X78.9K28.5.7.3.150.411.88.1 
log buffer space7756.2.1.2.51.42.463.931.2
log file parallel write9995  .58.729.534.823.52.9
log file sequential read8120100.0.0    .0 
log file single write210  1.931.042.918.16.2 
log file switch (checkpoint incomplete)1984 .1.1 .1.18.891.0
log file switch (private strand flush incomplete)61    1.6 23.075.4
log file switch completion1381.1    .252.946.9
log file sync21.4K  .22.911.516.137.232.1
os thread startup140    .793.65.7 
rdbms ipc reply35      14.385.7
read by other session134.8K100.0.0.0.0.0.0.0 
reliable message16100.0       
DIAG idle wait7656      100.0 
SQL*Net message from client1095.3K66.15.314.53.2.8.4.89.1
Space Manager: slave idle wait1167 .1    .499.5
Streams AQ: qmn coordinator idle wait27449.6.4     50.0
Streams AQ: qmn slave idle wait137       100.0
class slave wait22100.0       
dispatcher timer64       100.0
jobq slave wait7624.0     100.0 
pmon timer564230.7.4.71.32.13.639.621.6
rdbms ipc message145.3K54.43.32.12.13.03.425.56.1
shared server idle wait129       100.0
single-task message6      100.0 
smon timer2213.6     4.581.8

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 read193.86.3      
Data file init write193568.68.618.04.7.1.0 .0
Disk file operations I/O10996.3 .22.5.8 .1.1
Log archive I/O1999.7.2.0 .0   
SQL*Net break/reset to client17899.9.1.0 .0   
SQL*Net message from dblink78 76.912.82.6 7.7  
buffer busy waits44899.7.0.0.0.0.1.1.1
control file parallel write206255.232.69.51.6.8.2 .1
control file sequential read35100.0.0.0.0.0.0.0.0
cursor: pin S wait on X3294.25.3.5     
db file async I/O submit1378.84.84.42.71.32.42.772.9
db file scattered read73100.0.0.0.0.0 .0.0
db file sequential read93899.8.2.0.0.0.0 .0
db file single write4595.24.4.3.1    
direct path read7997.81.3.7.1.1   
direct path read temp399.9.0.0     
direct path sync2   100.0    
direct path write temp823835.030.630.63.5.3.1  
enq: CF - contention19314.52.618.951.111.9.4 .4
enq: FB - contention1998.9.3.5.1.1 .2 
enq: HW - contention898.3 1.5  .2  
enq: SQ - contention10834.41.22.53.05.38.14.870.6
enq: TX - contention1397.22.6.2     
enq: TX - index contention3669.522.97.6     
enq: TX - row lock contention7033.72.71.62.115.56.49.128.9
kksfbc child completion22 100.0      
latch free56394.34.01.5.1.1   
latch: In memory undo latch7838.03.1.83.112.424.816.31.6
latch: cache buffer handles7 100.0      
latch: cache buffers chains399.9.0 .1    
latch: call allocation4499.3.7      
latch: enqueue hash chains199.6  .4    
latch: shared pool9598.21.2.4.1.1   
library cache lock298.51.5      
library cache: mutex X641791.96.61.3.2    
log buffer space70285.05.88.310.314.525.026.74.4
log file parallel write261473.512.74.51.91.72.72.6.3
log file sequential read1100.0.0      
log file single write1393.85.7.5     
log file switch (checkpoint incomplete)185.2.16.31.6.4.4.690.5
log file switch (private strand flush incomplete)141.6  6.69.86.6 75.4
log file switch completion1363.3.73.05.913.030.245.81.0
log file sync13.9K30.711.46.85.65.18.327.84.3
os thread startup894.32.11.41.4 .7  
rdbms ipc reply35    2.911.485.7 
read by other session31100.0.0.0.0 .0  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
Data file init write1100.0 .0     
Disk file operations I/O299.9 .1     
buffer busy waits24099.9.0.0.0.0.0.0 
control file parallel write599.9.1.0     
control file sequential read5100.0.0      
db file async I/O submit54527.16.37.223.828.96.0.7 
db file scattered read1100.0.0      
db file sequential read10100.0.0.0.0    
enq: CF - contention199.6  .4    
enq: JD - contention1    100.0   
enq: KO - fast object checkpoint3  33.3 33.333.3  
enq: SQ - contention306229.43.43.39.225.523.65.6 
enq: TX - row lock contention5471.110.22.71.19.14.81.1 
latch: In memory undo latch298.41.6      
log buffer space34495.63.41.1     
log file parallel write3299.7.2.1     
log file switch (checkpoint incomplete)17959.51.73.26.728.642.08.3 
log file switch (private strand flush incomplete)4624.6  6.647.521.3  
log file switch completion1499.01.0      
log file sync92895.73.21.2.0    

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS198,6084,8701,885140,929
SYS$BACKGROUND00045
jqhx.localdomain0000
jqhxXDB0000

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 84219581932778786520059901710
SYS$BACKGROUND 93602512112320000

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
129,280.8916,3747.9061.740.020.002rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
128,009.5816,3807.8161.130.010.0079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
26,695.1573,813.5912.750.690.0308n2ck8z2c9wf   INSERT INTO F_PAR_EXC (ID, FSS...
3,633.851,1123.271.740.020.004m7m0t6fjcs5x   update seq$ set increment$=:2,...
727.375145.470.354.6895.89d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
581.96609.700.280.010.00aq8yqxyyb40nn   update sys.job$ set this_date=...
255.441715.030.120.010.00fkx9dq22y7mfc   INSERT INTO T_USER_LOG(ID, YHC...
243.62640.600.120.010.004q7r5qcsmj9sx   INSERT INTO T_USER_LOG(ID, YHC...
208.681118.970.100.010.005z5qgbd591awz   insert into t_id_card(f_id, f_...
208.38541.680.100.010.00fyakfbwrt6wzc   INSERT INTO T_CO_LOG(ID, YHCZ,...

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
183.46726.213.6926,695.150.690.0308n2ck8z2c9wf   INSERT INTO F_PAR_EXC (ID, FSS...
93.87353,7410.001.8993.82100.060.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
48.07116,9520.000.9750.6994.830.000k8522rmdzg4k   select privilege# from sysauth...
40.56116,8840.000.8239.54102.590.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
35.91162.240.7236.7497.740.006n108h5t57a1c   SELECT * FROM (SELECT DISTINCT...
35.88132.760.7235.85100.090.007hynf8h9wgrp5   SELECT DISTINCT * FROM V_US_CO...
34.0556.810.69727.374.6895.89d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
30.5716,3740.000.62129,280.890.020.002rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
29.32116,8870.000.5931.3893.440.00459f3z9u4fb3u   select value$ from props$ wher...
20.69116,8890.000.4222.3092.770.005ur69atw3vfhj   select decode(failover_method,...

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
697.455139.4965.19727.374.6895.89d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
37.92530.723.54154.101.2224.616gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
15.561,3990.011.45172.260.649.03d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...
7.8871.130.7426,695.150.690.0308n2ck8z2c9wf   INSERT INTO F_PAR_EXC (ID, FSS...
5.172560.020.4850.470.3810.24167wxs395avun   INSERT INTO SMS_SEND (ID, YWMC...
3.2713.270.318.8763.2936.881dvscgrr5mvnt   SELECT * FROM (SELECT DISTINCT...
0.7130.240.071.9162.3537.072vy72b63rxzq6   SELECT * FROM (SELECT DISTINCT...
0.5216,3740.000.05129,280.890.020.002rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
0.5216,3800.000.05128,009.580.010.0079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
0.1610.160.020.161.2198.6839ax31acw29z6 Oracle Enterprise Manager.current metric purge WITH MET AS (SELECT DISTINCT M...

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
11,620,26871,660,038.298.1426,695.15.7008n2ck8z2c9wf   INSERT INTO F_PAR_EXC (ID, FSS...
3,283,288353,7419.282.3093.82100.10cm5vu20fhtnq1   select /*+ connect_by_filterin...
704,714116,9526.030.4950.6994.800k8522rmdzg4k   select privilege# from sysauth...
379,6151379,615.000.2733.428.404nvpc4u7w1z7g   UPDATE F_PAR SET DQZT=0, SJC='...
366,3171931,898.020.269.1999.80bngd3h7xxyz19   UPDATE SMS_RECV SET CLZT=1, DQ...
366,3141931,898.000.267.5199.708cacvv4vp0bbm   UPDATE SMS_RECV SET CLZT=1, DQ...
350,659116,8873.000.2531.3893.40459f3z9u4fb3u   select value$ from props$ wher...
250,201383,400.330.1887.513.407u7fwuv8z8fjf   SELECT V.GUID, V.ZHMC, V.SJHM,...
233,776116,8892.000.1622.3092.805ur69atw3vfhj   select decode(failover_method,...
163,57227,2626.000.117.7297.504htx4ts19yknq   select f_ip, to_char(f_invalid...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
242,097734,585.2912.8326,695.150.690.0308n2ck8z2c9wf   INSERT INTO F_PAR_EXC (ID, FSS...
143,285528,657.007.59727.374.6895.89d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
1,73011,730.000.0933.428.400.054nvpc4u7w1z7g   UPDATE F_PAR SET DQZT=0, SJC='...
1,6893563.000.0987.513.410.027u7fwuv8z8fjf   SELECT V.GUID, V.ZHMC, V.SJHM,...
1,4971,3991.070.08172.260.649.03d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...
1,20011,200.000.068.8763.2936.881dvscgrr5mvnt   SELECT * FROM (SELECT DISTINCT...
1,1485321.660.06154.101.2224.616gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
34616,3740.020.02129,280.890.020.002rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
34616,3800.020.02128,009.580.010.0079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
2252560.880.0150.470.3810.24167wxs395avun   INSERT INTO SMS_SEND (ID, YWMC...

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
21,34221,34273,048.860.003.0808n2ck8z2c9wf   INSERT INTO F_PAR_EXC (ID, FSS...
5,8315,83151,166.200.000.84d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
1,5501,55011,550.000.000.224nvpc4u7w1z7g   UPDATE F_PAR SET DQZT=0, SJC='...
1,1071,1075320.890.000.166gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
9759753325.000.000.147u7fwuv8z8fjf   SELECT V.GUID, V.ZHMC, V.SJHM,...
34634616,3740.020.000.052rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
34634616,3800.020.000.0579c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
2252252560.880.000.03167wxs395avun   INSERT INTO SMS_SEND (ID, YWMC...
8080180.000.000.011dvscgrr5mvnt   SELECT * FROM (SELECT DISTINCT...
7070740.950.000.012zfk3ymatx835 oracle@bogon (TNS V1-V3) INSERT INTO "SMS_SEND" "A1" ("...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
353,7414,796,75013.5693.82100.10cm5vu20fhtnq1   select /*+ connect_by_filterin...
116,952353,8013.0350.6994.800k8522rmdzg4k   select privilege# from sysauth...
116,889116,8891.0022.3092.805ur69atw3vfhj   select decode(failover_method,...
116,887116,8891.0031.3893.40459f3z9u4fb3u   select value$ from props$ wher...
116,884116,8841.0039.54102.600ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
27,26227,2621.007.7297.504htx4ts19yknq   select f_ip, to_char(f_invalid...
16,38016,3801.00128,009.580079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
16,37416,3781.00129,280.89002rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
3,2693,2691.000.2688.28.8grwydz59pu6mc   select text from view$ where r...
1,3991,3991.00172.26.69d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
116,955353,74114.60cm5vu20fhtnq1   select /*+ connect_by_filterin...
116,950116,95214.600k8522rmdzg4k   select privilege# from sysauth...
116,889116,88414.590ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
116,889116,88914.595ur69atw3vfhj   select decode(failover_method,...
116,887116,88714.59459f3z9u4fb3u   select value$ from props$ wher...
27,26227,2623.404htx4ts19yknq   select f_ip, to_char(f_invalid...
16,38516,3742.052rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
16,38516,3802.0579c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
1,0591,1120.134m7m0t6fjcs5x   update seq$ set increment$=:2,...
8843,2690.11grwydz59pu6mc   select text from view$ where r...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,895,64310.0670kukc7sj9utm   SELECT * FROM (SELECT DISTINCT...
2,216,31510.05bzahms2z5x2qk   SELECT * FROM (SELECT DISTINCT...
2,193,171200.058qhvuumj0ngbb   SELECT * FROM (SELECT DISTINCT...
2,176,907200.048qhvuumj0ngbb   SELECT * FROM (SELECT DISTINCT...
1,748,93830.04f5qhp77fs8bvv Oracle SQL Developer SELECT s.owner, s.synonym_name...
1,480,10340.035gh60az1a4s7w   SELECT * FROM (SELECT DISTINCT...
1,479,30720.03fk4u2awrujc6v   SELECT * FROM (SELECT DISTINCT...
1,474,26330.034gbrkgg3sr7gq   SELECT * FROM (SELECT DISTINCT...
1,466,91520.035dfm3pju4gjas   SELECT * FROM (SELECT DISTINCT...
1,460,37540.03avh53nb5qwq9a   SELECT * FROM (SELECT DISTINCT...
1,460,35140.03avh53nb5qwq9a   SELECT * FROM (SELECT DISTINCT...
1,450,733200.03bcp1yfzdsfq57   SELECT * FROM (SELECT DISTINCT...
1,450,66160.0338d79tpwkfvvv   SELECT * FROM (SELECT DISTINCT...
1,450,60130.032vy72b63rxzq6   SELECT * FROM (SELECT DISTINCT...
1,442,46530.032vy72b63rxzq6   SELECT * FROM (SELECT DISTINCT...
1,434,445200.03bcp1yfzdsfq57   SELECT * FROM (SELECT DISTINCT...
1,434,34160.0338d79tpwkfvvv   SELECT * FROM (SELECT DISTINCT...
1,080,98110.021dvscgrr5mvnt   SELECT * FROM (SELECT DISTINCT...
1,074,53550.02d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
511a0xc4nq6swjvy   INSERT INTO wri$_adv_addm_fdg ...
3900v3dvmc22qnam   insert into sys.col_usage$ (ob...
371b3zgx1xckrwxu   select host, userid, password,...
28269k5bhm12sz98   SELECT dbin.instance_number, d...
262258vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
262258vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
25123nad9x295gkf   SELECT (m.current_size / 10485...
2217708bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
22116,8840ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
22116,887459f3z9u4fb3u   select value$ from props$ wher...
2227,2624htx4ts19yknq   select f_ip, to_char(f_invalid...
22116,8895ur69atw3vfhj   select decode(failover_method,...
2216,38079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
211c8gnrhxma4tas   SELECT owner#, property FROM s...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08n2ck8z2c9wfINSERT INTO F_PAR_EXC (ID, FSSJ, FFHM, ZDHM, CZHM, DFHM, YWLX, YWMX, YS, SS, KFZT, KFSJ, KFLX, ZGUID, GGUID, KFSM, ECSJ) SELECT ID, FSSJ, FFHM, ZDHM, CZHM, DFHM, YWLX, YWMX, YS, SS, KFZT, KFSJ, KFLX, ZGUID, GGUID, '异常数据', sysdate FROM F_PAR
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
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')
167wxs395avunINSERT INTO SMS_SEND (ID, YWMC, CPMC, FSSJ, FFHM, JSHM, CZHM, DXNR, CLZT) VALUES(SEQ_SMS_SEND.NEXTVAL, :B1 , :B2 , SYSDATE, :B3 , :B4 , :B5 , :B6 , 0)
1dvscgrr5mvnt SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (16932, 16845, 16767, 16805, 16632, 16717, 16847, 16631, 16905, 16676, 16904, 16716, 16718, 16804, 16798, 16622, 16647, 16734, 16778, 16814, 16815, 16779, 16733, 16852, 16854, 16648, 16686, 16780, 16858, 16913, 16935, 16735, 16781, 16855, 16857, 16687, 16782, 16649, 16853, 16856, 16816, 16914, 16721, 16807, 16722, 16808, 16769, 16906, 16849, 16635, 16936, 16766, 16634, 16806, 16771, 16809, 16770, 16810, 16636, 16817, 16861, 16859, 16736, 16915, 16931, 16860, 16862, 16650, 16820, 16863, 16865, 16818, 16651, 16821, 16866, 16916, 16943, 16819, 16864, 16628, 16843, 16844, 16846, 16714, 16629, 16713, 16901, 16715, 16625, 16902, 16626, 16627, 16630, 16842, 16900, 16664, 16700, 16750, 16873, 16875, 16751, 16829, 16876, 16926, 16830, 16697, 16923, 16698, 16699, 16787, 16874, 16924, 16925, 19624, 16723, 16908, 16693, 16694, 16941, 16919, 16869, 16657, 16692, 16747, 16784, 16870, 16719, 16768, 16933, 16633, 16907, 16848, 16720, 16701, 16703, 16788, 16667, 16704, 16789, 16832, 16880, 16884, 16666, 16668, 16752, 16881, 16882, 16790, 16877, 16879, 16883, 16665, 16702, 16831, 16867, 16822, 16737, 16738, 16823, 16934, 16688, 16917, 16872, 16662, 16944, 16696, 16828, 16660, 16921, 16922, 16827, 16661, 16663, 16638, 16677, 16939, 16678, 16724, 16850, 16772, 16725, 16637, 16940, 16726, 16773, 16639, 16811, 16803, 16748, 16785, 16786, 16659, 16695, 16658, 16920, 16749, 16871, 16644, 16645, 16682, 16729, 16731, 16776, 16732, 16683, 16685, 16911, 16942, 16681, 16684, 16912, 16642, 16643, 16646, 16730, 16777, 16813, 16671, 16672, 16706, 16756, 16757, 16834, 16889, 16938, 16707, 16887, 16890, 16927, 16753, 16886, 16705, 16928, 16669, 16670, 16673, 16754, 16755, 16833, 16885, 16888, 16674, 16791, 16792, 16891, 16892, 16893, 16793, 16894, 16794, 16758, 16835, 16799, 16903, 16774, 16909, 16640, 16937, 16641, 16679, 16727, 16655, 16691, 16739, 16825, 16689, 16743, 16746, 16918, 16656, 16740, 16742, 16826, 16868, 16744, 16652, 16653, 16654, 16741, 16824, 16690, 16745, 16783, 16728, 16910, 16851, 16680, 16775, 16812, 16796, 16929, 16797, 16708, 16709, 16710, 16795) ) START WITH JDID IN (16932, 16845, 16767, 16805, 16632, 16717, 16847, 16631, 16905, 16676, 16904, 16716, 16718, 16804, 16798, 16622, 16647, 16734, 16778, 16814, 16815, 16779, 16733, 16852, 16854, 16648, 16686, 16780, 16858, 16913, 16935, 16735, 16781, 16855, 16857, 16687, 16782, 16649, 16853, 16856, 16816, 16914, 16721, 16807, 16722, 16808, 16769, 16906, 16849, 16635, 16936, 16766, 16634, 16806, 16771, 16809, 16770, 16810, 16636, 16817, 16861, 16859, 16736, 16915, 16931, 16860, 16862, 16650, 16820, 16863, 16865, 16818, 16651, 16821, 16866, 16916, 16943, 16819, 16864, 16628, 16843, 16844, 16846, 16714, 16629, 16713, 16901, 16715, 16625, 16902, 16626, 16627, 16630, 16842, 16900, 16664, 16700, 16750, 16873, 16875, 16751, 16829, 16876, 16926, 16830, 16697, 16923, 16698, 16699, 16787, 16874, 16924, 16925, 19624, 16723, 16908, 16693, 16694, 16941, 16919, 16869, 16657, 16692, 16747, 16784, 16870, 16719, 16768, 16933, 16633, 16907, 16848, 16720, 16701, 16703, 16788, 16667, 16704, 16789, 16832, 16880, 16884, 16666, 16668, 16752, 16881, 16882, 16790, 16877, 16879, 16883, 16665, 16702, 16831, 16867, 16822, 16737, 16738, 16823, 16934, 16688, 16917, 16872, 16662, 16944, 16696, 16828, 16660, 16921, 16922, 16827, 16661, 16663, 16638, 16677, 16939, 16678, 16724, 16850, 16772, 16725, 16637, 16940, 16726, 16773, 16639, 16811, 16803, 16748, 16785, 16786, 16659, 16695, 16658, 16920, 16749, 16871, 16644, 16645, 16682, 16729, 16731, 16776, 16732, 16683, 16685, 16911, 16942, 16681, 16684, 16912, 16642, 16643, 16646, 16730, 16777, 16813, 16671, 16672, 16706, 16756, 16757, 16834, 16889, 16938, 16707, 16887, 16890, 16927, 16753, 16886, 16705, 16928, 16669, 16670, 16673, 16754, 16755, 16833, 16885, 16888, 16674, 16791, 16792, 16891, 16892, 16893, 16793, 16894, 16794, 16758, 16835, 16799, 16903, 16774, 16909, 16640, 16937, 16641, 16679, 16727, 16655, 16691, 16739, 16825, 16689, 16743, 16746, 16918, 16656, 16740, 16742, 16826, 16868, 16744, 16652, 16653, 16654, 16741, 16824, 16690, 16745, 16783, 16728, 16910, 16851, 16680, 16775, 16812, 16796, 16929, 16797, 16708, 16709, 16710, 16795) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
23nad9x295gkfSELECT (m.current_size / 1048576) as sizemb, case when cast(m.last_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as changed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT buffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DEFAULT 8K buffer cache', 6, 'DEFAULT 16K buffer cache', 7, 'DEFAULT 32K buffer cache', 8, 'SGA Target', 9, 'PGA Target', 10, 'memory target', 11 , 255) as comp_id FROM WRH$_MEM_DYNAMIC_COMP m , WRM$_SNAPSHOT s WHERE m.dbid = :dbid AND m.instance_number = :inst_num AND m.snap_id = :end_snap_id AND s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id = :begin_snap_id
2rgmdtpdz21yqBEGIN proc_locationinfo(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15); END;
2vy72b63rxzq6SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (16152, 26482, 16153) ) START WITH JDID IN (16152, 26482, 16153) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
2zfk3ymatx835INSERT INTO "SMS_SEND" "A1" ("ID", "YWMC", "CPMC", "FSSJ", "FFHM", "JSHM", "CZHM", "CPID", "JRH", "DXNR", "CLZT", "CLSJ", "TJSJ", "LKID", "C1", "C2", "C3", "C4", "C5") VALUES (:B1, :B2, :B3, :B4, :B5, :B6, :B7, :B8, :B9, :B10, :B11, :B12, :B13, :B14, :B15, :B16, :B17, :B18, :B19)
38d79tpwkfvvvSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (26932, 26977) ) START WITH JDID IN (26932, 26977) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
39ax31acw29z6WITH MET AS (SELECT DISTINCT METRIC_GUID METRIC_GUID FROM MGMT_METRICS WHERE KEYS_FROM_MULT_COLLS = 0 ), CM AS (SELECT TARGET_GUID, METRIC_GUID, MAX(COLLECTION_TIMESTAMP) MAX_TIME FROM MGMT_CURRENT_METRICS GROUP BY TARGET_GUID, METRIC_GUID HAVING MAX(COLLECTION_TIMESTAMP) != MIN(COLLECTION_TIMESTAMP)) SELECT CM.TARGET_GUID TARGET_GUID, CM.METRIC_GUID METRIC_GUID, CM. MAX_TIME MAX_TIME FROM MET, CM WHERE CM.METRIC_GUID = MET.METRIC_GUID
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4gbrkgg3sr7gqSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (16251, 16250, 16252, 16249, 16243, 16244, 16242, 16241, 16247, 16248, 16245, 16246, 16254, 16256, 16253, 16255, 12241, 12242) ) START WITH JDID IN (16251, 16250, 16252, 16249, 16243, 16244, 16242, 16241, 16247, 16248, 16245, 16246, 16254, 16256, 16253, 16255, 12241, 12242) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
4htx4ts19yknqselect f_ip, to_char(f_invaliddate, 'yyyyMMdd') f_invalid, f_balance, f_begtime, f_endtime, f_frequency, f_yyslevel, f_mark, f_detail from t_dwjk_userinfo where f_username=:1 and f_pwd=:2
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4nvpc4u7w1z7gUPDATE F_PAR SET DQZT=0, SJC='1378175140004442813' WHERE KFZT=99 AND DQZT=1 AND ROWNUM<=50
4q7r5qcsmj9sxINSERT INTO T_USER_LOG(ID, YHCZ, ZHMC, SJHM, QC, IP, TJSJ, DLLX, GZHMC, GSJHM, GGUID, GUID, YWMC, CPMC, DLSFCG, CWDM, GQC) VALUES(SEQ_CO_LOG.NEXTVAL, '1', '************', '************', '************', 'x.x.x.x', SYSDATE, 2, '************', '************', '************', '************', '10', '10', 1, 1, '************')
5dfm3pju4gjasSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (13947, 24972, 13946, 13950, 13948, 13949, 13941, 13942, 13944, 19262, 19263, 19261, 24973, 24971, 13943) ) START WITH JDID IN (13947, 24972, 13946, 13950, 13948, 13949, 13941, 13942, 13944, 19262, 19263, 19261, 24973, 24971, 13943) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
5gh60az1a4s7wSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (20121, 24149, 12015, 12016, 12017, 12019, 20123, 12029, 12031, 12032, 12033, 12034, 12035, 12036, 12037, 11712) ) START WITH JDID IN (20121, 24149, 12015, 12016, 12017, 12019, 20123, 12029, 12031, 12032, 12033, 12034, 12035, 12036, 12037, 11712) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
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
5z5qgbd591awzinsert into t_id_card(f_id, f_cardid, f_name, f_image, f_couser, f_addtime, f_pt, f_result) values(seq_id_card.nextval, :1, :2, Empty_blob(), :3, sysdate, :4, :5)
69k5bhm12sz98SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
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;
6n108h5t57a1cSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (20120, 12011, 12012, 12013, 12014, 20490, 20121, 24149, 12015, 12016, 12017, 12019, 20122, 12022, 12023, 12025, 12026, 12027, 20123, 12029, 12031, 12032, 12033, 12034, 12035, 12036, 12037, 22188, 22189, 22190, 21885, 22365, 11983, 11982, 11984, 11985, 11987, 11986, 11988, 11989, 11981, 11712) ) START WITH JDID IN (20120, 12011, 12012, 12013, 12014, 20490, 20121, 24149, 12015, 12016, 12017, 12019, 20122, 12022, 12023, 12025, 12026, 12027, 20123, 12029, 12031, 12032, 12033, 12034, 12035, 12036, 12037, 22188, 22189, 22190, 21885, 22365, 11983, 11982, 11984, 11985, 11987, 11986, 11988, 11989, 11981, 11712) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='9252A7AF-0178-D9E1-5947-122982251' AND GGUID='9252A7AF-0178-D9E1-5947-122982251' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
70kukc7sj9utmSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (16121, 16122, 16123, 16120, 16119) ) START WITH JDID IN (16121, 16122, 16123, 16120, 16119) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
79c9nwfb1cjqqINSERT INTO T_LOCATION_INFO(F_ID, F_DW_TELEPHONE, F_OWNER, F_LONGITUDE, F_LATITUDE, F_HEIGHT, F_LOCATE_MODE, F_RADIUS, F_PROVINCE, F_CITY, F_COUNTRY, F_CONTENT, F_SUCCESS, F_DW_TYPE, F_RESULT, F_ADDTIME) VALUES(SEQ_LOCATION_INFOS.NEXTVAL, :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)
7hynf8h9wgrp5SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
7u7fwuv8z8fjfSELECT V.GUID, V.ZHMC, V.SJHM, V.KFLX, V.XTMC, V.QC, V.JC, V.XYED, V.ZHSF, V.ZHSC, (KK.ZHSC+KK.ZHSF) ZHYE, (BAK.ZHSC+BAK.ZHSF) ZHJY, V.TCMC, V.DXZS, V.DYDXS, V.DYLTDXS, V.DYDXDXS, V.DYYDDXS, V.DWZS, V.DYDWS, V.DYLTDWS, V.DYDXDWS, V.DYYDDWS, DECODE(GNF, NULL, 0, GNF) GNF, DECODE(SS, NULL, 0, SS) SS, DECODE(WZDW, NULL, 0, WZDW) WZDW, DECODE(DXQF, NULL, 0, DXQF) DXQF, DECODE(DXQF, NULL, 0, JHDW) JHDW, DECODE(LTDW, NULL, 0, LTDW) LTDW, DECODE(DXDW, NULL, 0, DXDW) DXDW, DECODE(YDDW, NULL, 0, YDDW) YDDW, DECODE(LTDX, NULL, 0, LTDX) LTDX, DECODE(DXDX, NULL, 0, DXDX) DXDX, DECODE(YDDX, NULL, 0, YDDX) YDDX FROM V_CO_INFO_FEE V LEFT JOIN (SELECT BK.ZHSC, BK.ZHSF, BK.GGUID FROM T_FEE_BAK BK WHERE BK.YFQ='201309') KK ON V.GUID=KK.GGUID LEFT JOIN (SELECT P.GGUID, SUM(P.GNF) GNF FROM F_PRE P WHERE TO_CHAR(FSSJ, 'yyyymm')='201309' GROUP BY P.GGUID) PRE ON V.GUID=PRE.GGUID LEFT JOIN (SELECT BA.ZHSC, BA.ZHSF, BA.GGUID FROM T_FEE_BAK BA WHERE YFQ='201309') BAK ON V.GUID=BAK.GGUID LEFT JOIN (SELECT GGUID, SUM(SS) SS, SUM(WZDW) WZDW, SUM(DXQF) DXQF, SUM(JHDW) JHDW, SUM(LTDW) LTDW, SUM(DXDW) DXDW, SUM(YDDW) YDDW, SUM(LTDX) LTDX, SUM(DXDX) DXDX, SUM(YDDX) YDDX FROM (SELECT PA.GGUID, SUM(PA.SS) SS, DECODE(YWLX, 'WZDW', SUM(PA.SS), 0) WZDW, DECODE(YWLX, 'DXQF', SUM(PA.SS), 0) DXQF, DECODE(YWLX, 'JHDW', SUM(PA.SS), 0) JHDW, DECODE(YWMX, 'U_DW', SUM(PA.SS), 0) LTDW, DECODE(YWMX, 'T_DW', SUM(PA.SS), 0) DXDW, DECODE(YWMX, 'M_DW', SUM(PA.SS), 0) YDDW, DECODE(YWMX, 'U_DX', SUM(PA.SS), 0) LTDX, DECODE(YWMX, 'T_DX', SUM(PA.SS), 0) DXDX, DECODE(YWMX, 'M_DX', SUM(PA.SS), 0) YDDX FROM F_PAR PA WHERE TO_CHAR(FSSJ, 'yyyymm')='201309' GROUP BY PA.GGUID, PA.YWLX, PA.YWMX) PP GROUP BY GGUID) PAR ON V.GUID=PAR.GGUID WHERE GUID='5292D748-9CAC-93E5-7492-545063CABEEB'
8cacvv4vp0bbmUPDATE SMS_RECV SET CLZT=1, DQZT=1 WHERE CLZT=0 AND DQZT=1 AND TO_CHAR(TJSJ, 'YYYYMMDD')=TO_CHAR(SYSDATE, 'YYYYMMDD')
8qhvuumj0ngbbSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR GR WHERE 1=1 OR (JDID IN (27009, 26944, 26943, 26945, 26946, 26994, 26845, 26942) ) START WITH JDID IN (27009, 26944, 26943, 26945, 26946, 26994, 26845, 26942) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='52259494-3647-6543-268A-575A326C80FB' AND GGUID='52259494-3647-6543-268A-575A326C80FB' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
a0xc4nq6swjvyINSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL, QUERY_TYPE, QUERY_IS_APPROX, QUERY_ARGS) VALUES ( :tid, :kea_id, NULL, NULL, 0, NULL, NULL, NULL, 'N', NULL, NULL, NULL, NULL)
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
avh53nb5qwq9aSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (17971, 17969, 17972, 22442, 17973, 17970) ) START WITH JDID IN (17971, 17969, 17972, 22442, 17973, 17970) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
b3zgx1xckrwxuselect host, userid, password, flag, authusr, authpwd, passwordx, authpwdx from link$ where owner#=:1 and name=:2
bcp1yfzdsfq57SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (26932, 26977) ) START WITH JDID IN (26932, 26977) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='24ABE652-4BBE-9D40-5B85-7A9A2CF8119' AND GGUID='24ABE652-4BBE-9D40-5B85-7A9A2CF8119' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
bngd3h7xxyz19UPDATE SMS_RECV SET CLZT=1, DQZT=1 WHERE CLZT=1 AND DQZT=0 AND TO_CHAR(TJSJ, 'YYYYMMDDhh24MI')=TO_CHAR(SYSDATE, 'YYYYMMDDhh24MI')
bzahms2z5x2qkSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (14872, 14871, 14873, 14869, 14876, 14870, 14874) ) START WITH JDID IN (14872, 14871, 14873, 14869, 14876, 14870, 14874) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
c8gnrhxma4tasSELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d5jz0t3f6r3bdINSERT INTO SMS_SEND (ID, YWMC, CPMC, FSSJ, FFHM, JSHM, CZHM, DXNR, JRH, CLZT, CPID, CLSJ) VALUES(SEQ_SMS_SEND.NEXTVAL, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , 0, :B9 , :B10 )
d8ccpd7xxc1r3 SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (16932, 16845, 16767, 16805, 16632, 16717, 16847, 16631, 16905, 16676, 16904, 16716, 16718, 16804, 16798, 16622, 16647, 16734, 16778, 16814, 16815, 16779, 16733, 16852, 16854, 16648, 16686, 16780, 16858, 16913, 16935, 16735, 16781, 16855, 16857, 16687, 16782, 16649, 16853, 16856, 16816, 16914, 16721, 16807, 16722, 16808, 16769, 16906, 16849, 16635, 16936, 16766, 16634, 16806, 16771, 16809, 16770, 16810, 16636, 16817, 16861, 16859, 16736, 16915, 16931, 16860, 16862, 16650, 16820, 16863, 16865, 16818, 16651, 16821, 16866, 16916, 16943, 16819, 16864, 16628, 16843, 16844, 16846, 16714, 16629, 16713, 16901, 16715, 16625, 16902, 16626, 16627, 16630, 16842, 16900, 16664, 16700, 16750, 16873, 16875, 16751, 16829, 16876, 16926, 16830, 16697, 16923, 16698, 16699, 16787, 16874, 16924, 16925, 19624, 16723, 16908, 16693, 16694, 16941, 16919, 16869, 16657, 16692, 16747, 16784, 16870, 16719, 16768, 16933, 16633, 16907, 16848, 16720, 16701, 16703, 16788, 16667, 16704, 16789, 16832, 16880, 16884, 16666, 16668, 16752, 16881, 16882, 16790, 16877, 16879, 16883, 16665, 16702, 16831, 16867, 16822, 16737, 16738, 16823, 16934, 16688, 16917, 16872, 16662, 16944, 16696, 16828, 16660, 16921, 16922, 16827, 16661, 16663, 16638, 16677, 16939, 16678, 16724, 16850, 16772, 16725, 16637, 16940, 16726, 16773, 16639, 16811, 16803, 16748, 16785, 16786, 16659, 16695, 16658, 16920, 16749, 16871, 16644, 16645, 16682, 16729, 16731, 16776, 16732, 16683, 16685, 16911, 16942, 16681, 16684, 16912, 16642, 16643, 16646, 16730, 16777, 16813, 16671, 16672, 16706, 16756, 16757, 16834, 16889, 16938, 16707, 16887, 16890, 16927, 16753, 16886, 16705, 16928, 16669, 16670, 16673, 16754, 16755, 16833, 16885, 16888, 16674, 16791, 16792, 16891, 16892, 16893, 16793, 16894, 16794, 16758, 16835, 16799, 16903, 16774, 16909, 16640, 16937, 16641, 16679, 16727, 16655, 16691, 16739, 16825, 16689, 16743, 16746, 16918, 16656, 16740, 16742, 16826, 16868, 16744, 16652, 16653, 16654, 16741, 16824, 16690, 16745, 16783, 16728, 16910, 16851, 16680, 16775, 16812, 16796, 16929, 16797, 16708, 16709, 16710, 16795) ) START WITH JDID IN (16932, 16845, 16767, 16805, 16632, 16717, 16847, 16631, 16905, 16676, 16904, 16716, 16718, 16804, 16798, 16622, 16647, 16734, 16778, 16814, 16815, 16779, 16733, 16852, 16854, 16648, 16686, 16780, 16858, 16913, 16935, 16735, 16781, 16855, 16857, 16687, 16782, 16649, 16853, 16856, 16816, 16914, 16721, 16807, 16722, 16808, 16769, 16906, 16849, 16635, 16936, 16766, 16634, 16806, 16771, 16809, 16770, 16810, 16636, 16817, 16861, 16859, 16736, 16915, 16931, 16860, 16862, 16650, 16820, 16863, 16865, 16818, 16651, 16821, 16866, 16916, 16943, 16819, 16864, 16628, 16843, 16844, 16846, 16714, 16629, 16713, 16901, 16715, 16625, 16902, 16626, 16627, 16630, 16842, 16900, 16664, 16700, 16750, 16873, 16875, 16751, 16829, 16876, 16926, 16830, 16697, 16923, 16698, 16699, 16787, 16874, 16924, 16925, 19624, 16723, 16908, 16693, 16694, 16941, 16919, 16869, 16657, 16692, 16747, 16784, 16870, 16719, 16768, 16933, 16633, 16907, 16848, 16720, 16701, 16703, 16788, 16667, 16704, 16789, 16832, 16880, 16884, 16666, 16668, 16752, 16881, 16882, 16790, 16877, 16879, 16883, 16665, 16702, 16831, 16867, 16822, 16737, 16738, 16823, 16934, 16688, 16917, 16872, 16662, 16944, 16696, 16828, 16660, 16921, 16922, 16827, 16661, 16663, 16638, 16677, 16939, 16678, 16724, 16850, 16772, 16725, 16637, 16940, 16726, 16773, 16639, 16811, 16803, 16748, 16785, 16786, 16659, 16695, 16658, 16920, 16749, 16871, 16644, 16645, 16682, 16729, 16731, 16776, 16732, 16683, 16685, 16911, 16942, 16681, 16684, 16912, 16642, 16643, 16646, 16730, 16777, 16813, 16671, 16672, 16706, 16756, 16757, 16834, 16889, 16938, 16707, 16887, 16890, 16927, 16753, 16886, 16705, 16928, 16669, 16670, 16673, 16754, 16755, 16833, 16885, 16888, 16674, 16791, 16792, 16891, 16892, 16893, 16793, 16894, 16794, 16758, 16835, 16799, 16903, 16774, 16909, 16640, 16937, 16641, 16679, 16727, 16655, 16691, 16739, 16825, 16689, 16743, 16746, 16918, 16656, 16740, 16742, 16826, 16868, 16744, 16652, 16653, 16654, 16741, 16824, 16690, 16745, 16783, 16728, 16910, 16851, 16680, 16775, 16812, 16796, 16929, 16797, 16708, 16709, 16710, 16795) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='E6EBCAAD-3968-3FAD-916D-55A7EC8EBB7D' AND GGUID='E6EBCAAD-3968-3FAD-916D-55A7EC8EBB7D' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
f5qhp77fs8bvvSELECT s.owner, s.synonym_name, 'SYNONYM' as object_type FROM sys.all_synonyms s, sys.all_objects o WHERE s.table_name = o.object_name AND s.table_owner = o.owner AND object_type IN ('PACKAGE', 'PROCEDURE', 'SEQUENCE', 'TABLE', 'TYPE', 'VIEW', 'FUNCTION' ) ORDER BY s.owner, s.synonym_name
fk4u2awrujc6vSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (16951, 16956, 16960, 16963, 16950, 16954, 25861, 16949, 16959, 16957, 16961, 20245, 20246) ) START WITH JDID IN (16951, 16956, 16960, 16963, 16950, 16954, 25861, 16949, 16959, 16957, 16961, 20245, 20246) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
fkx9dq22y7mfcINSERT INTO T_USER_LOG(ID, YHCZ, ZHMC, SJHM, QC, IP, TJSJ, DLLX, GZHMC, GSJHM, GGUID, GUID, YWMC, CPMC, DLSFCG, CWDM, GQC) VALUES(SEQ_CO_LOG.NEXTVAL, '手机客户端:测试用户登录成功', '*********', ''*********',', ''*********',', 'x.x.x.x', SYSDATE, 2, 'TXSM', ''*********',', '3530D5D7-D8D4-3998-CCB1-8C23ED5C9AB', 'E847C230-9FE3-DA68-A62B-BFDF6D7464A', '10', '10', 0, 20, ''*********',')
fyakfbwrt6wzcINSERT INTO T_CO_LOG(ID, YHCZ, ZHMC, SJHM, QC, IP, TJSJ, YWMC, CPMC, GUID, DLSFCG, DLLX, CWDM) VALUES(SEQ_CO_LOG.NEXTVAL, '管理员用户:登录成功', '11250067791', '11250067791', '11250067791', '116.255.134.168', SYSDATE, '30', '10', '9196C1F7-5B40-CBA2-1B64-7746C4DE151D', 0, 11, 0)
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced70.000.00
CCursor + sql area evicted1570.040.01
CPU used by this session293,41182.3111.36
CPU used when call started282,28679.1910.93
CR blocks created5,3481.500.21
Cached Commit SCN referenced5580.160.02
Commit SCN cached60.000.00
DB time19,466,6325,460.90753.88
DBWR checkpoint buffers written921,900258.6235.70
DBWR checkpoints1070.030.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer280.010.00
DBWR tablespace checkpoint buffers written230.010.00
DBWR thread checkpoint buffers written921,329258.4635.68
DBWR transaction table writes1,6390.460.06
DBWR undo block writes25,0697.030.97
HSC Heap Segment Block Changes1,751,029491.2167.81
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1,721,028482.7966.65
Heap Segment Array Updates2860.080.01
IMU CR rollbacks1520.040.01
IMU Flushes8430.240.03
IMU Redo allocation size1,216,640341.3047.12
IMU commits5,3511.500.21
IMU contention1990.060.01
IMU ktichg flush00.000.00
IMU pool not allocated34,1909.591.32
IMU recursive-transaction flush00.000.00
IMU undo allocation size5,622,9761,577.39217.76
IMU- failed to get a private strand34,1909.591.32
LOB table id lookup cache misses00.000.00
Number of read IOs issued3,6001.010.14
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Requests to/from client523,006146.7220.25
RowCR - row contention790.020.00
RowCR attempts1740.050.01
RowCR hits950.030.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink10.000.00
SQL*Net roundtrips to/from client523,382146.8220.27
SQL*Net roundtrips to/from dblink720.020.00
TBS Extension: bytes extended6,442,450,9441,807,277.51249,494.65
TBS Extension: files extended60.000.00
TBS Extension: tasks created20.000.00
TBS Extension: tasks executed20.000.00
active txn count during cleanout1,005,421282.0538.94
application wait time140,02939.285.42
auto extends on undo tablespace00.000.00
background checkpoints completed1000.030.00
background checkpoints started1040.030.00
background timeouts17,7084.970.69
branch node splits00.000.00
buffer is not pinned count1,649,542462.7463.88
buffer is pinned count1,743,148489.0067.51
bytes received via SQL*Net from client92,603,63925,977.763,586.23
bytes received via SQL*Net from dblink35,69710.011.38
bytes sent via SQL*Net to client458,384,983128,589.0817,751.72
bytes sent via SQL*Net to dblink24,8856.980.96
calls to get snapshot scn: kcmgss926,832260.0035.89
calls to kcmgas95,32726.743.69
calls to kcmgcs2,580,441723.8899.93
cell physical IO interconnect bytes71,170,379,26419,965,169.642,756,191.59
change write time624,719175.2524.19
cleanout - number of ktugct calls943,459264.6736.54
cleanouts and rollbacks - consistent read gets1,6380.460.06
cleanouts only - consistent read gets610.020.00
cluster key scan block gets4,4251.240.17
cluster key scans3,3410.940.13
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed910.030.00
commit batch/immediate requested910.030.00
commit cleanout failures: block lost44,25912.421.71
commit cleanout failures: buffer being written50.000.00
commit cleanout failures: callback failure70.000.00
commit cleanout failures: cannot pin1900.050.01
commit cleanouts102,87828.863.98
commit cleanouts successfully completed58,41716.392.26
commit immediate performed910.030.00
commit immediate requested910.030.00
commit txn count during cleanout4760.130.02
concurrency wait time963,323270.2437.31
consistent changes24,0576.750.93
consistent gets134,098,05937,618.045,193.17
consistent gets - examination1,804,118506.1069.87
consistent gets direct229,50264.388.89
consistent gets from cache133,868,55737,553.665,184.28
consistent gets from cache (fastpath)131,117,27336,781.865,077.73
cursor authentications6990.200.03
data blocks consistent reads - undo records applied8,1212.280.31
db block changes6,924,7221,942.57268.17
db block gets8,655,5402,428.11335.20
db block gets direct6920.190.03
db block gets from cache8,654,8482,427.91335.17
db block gets from cache (fastpath)1,404,216393.9254.38
deferred (CURRENT) block cleanout applications26,3487.391.02
dirty buffers inspected35,2569.891.37
enqueue conversions1,2060.340.05
enqueue deadlocks90.000.00
enqueue releases774,067217.1529.98
enqueue requests774,258217.2029.98
enqueue timeouts620.020.00
enqueue waits7,5582.120.29
exchange deadlocks200.010.00
execute count916,619257.1435.50
failed probes on index block reclamation00.000.00
file io service time720.020.00
file io wait time10,454,260,1342,932,695.87404,858.65
free buffer inspected4,161,3231,167.36161.15
free buffer requested2,481,373696.0996.10
global undo segment hints helped00.000.00
heap block compress1,0520.300.04
hot buffers moved to head of LRU494,585138.7419.15
immediate (CR) block cleanout applications1,6990.480.07
immediate (CURRENT) block cleanout applications8010.220.03
in call idle wait time8,872,5512,488.98343.60
index crx upgrade (positioned)270.010.00
index crx upgrade (prefetch)00.000.00
index fast full scans (full)420.010.00
index fetch by key115,51032.404.47
index scans kdiixs13,613,4261,013.66139.94
leaf node 90-10 splits1080.030.00
leaf node splits1410.040.01
lob reads00.000.00
lob writes460.010.00
lob writes unaligned460.010.00
logical read bytes from cache1,167,551,578,112327,529,030.4545,215,381.38
logons cumulative114,36832.084.43
max cf enq hold time11,2003.140.43
messages received144,46940.535.59
messages sent144,47540.535.60
min active SCN optimization applied on CR00.000.00
no buffer to keep pinned count00.000.00
no work - consistent read gets130,504,56336,609.975,054.01
non-idle wait count4,605,4681,291.96178.35
non-idle wait time21,842,8986,127.51845.90
opened cursors cumulative1,115,182312.8443.19
parse count (describe)220.010.00
parse count (failures)70,78219.862.74
parse count (hard)99,28527.853.84
parse count (total)801,020224.7131.02
parse time cpu31,8918.951.24
parse time elapsed62,52217.542.42
physical read IO requests693,407194.5226.85
physical read bytes15,463,530,4964,337,928.40598,851.00
physical read total IO requests1,650,088462.8963.90
physical read total bytes38,872,964,09610,904,892.321,505,420.34
physical read total multi block requests21,5506.050.83
physical reads1,887,638529.5373.10
physical reads cache1,513,651424.6258.62
physical reads cache prefetch829,763232.7732.13
physical reads direct373,987104.9114.48
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace144,48540.535.60
physical reads prefetch warmup00.000.00
physical write IO requests756,627212.2529.30
physical write bytes10,245,079,0402,874,015.05396,757.77
physical write total IO requests797,243223.6530.87
physical write total bytes32,297,415,1689,060,277.311,250,771.25
physical write total multi block requests40,91511.481.58
physical writes1,250,620350.8348.43
physical writes direct287,26080.5811.12
physical writes direct (lob)210.010.00
physical writes direct temporary tablespace286,56880.3911.10
physical writes from cache963,360270.2537.31
physical writes non checkpoint1,205,932338.3046.70
pinned buffers inspected2630.070.01
pinned cursors current140.000.00
prefetch clients - default240.010.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use5030.140.02
process last non-idle time3,8401.080.15
recovery block gets from cache00.000.00
recovery blocks read00.000.00
recursive calls11,457,9783,214.27443.73
recursive cpu usage62,17417.442.41
redo KB read7,566,5052,122.60293.03
redo blocks checksummed by FG (exclusive)12,832,8773,599.96496.97
redo blocks read for recovery00.000.00
redo blocks written15,064,0304,225.86583.38
redo buffer allocation retries14,8644.170.58
redo entries5,103,0541,431.54197.62
redo k-bytes read for recovery00.000.00
redo log space requests778,425218.3730.15
redo log space wait time7,067,5881,982.64273.70
redo ordering marks60,83017.062.36
redo size7,515,264,1682,108,229.93291,041.13
redo size for direct writes5,743,2321,611.13222.42
redo subscn max counts959,584269.1937.16
redo synch long waits9410.260.04
redo synch time1,468,967412.0856.89
redo synch time (usec)14,688,959,8194,120,640.88568,854.46
redo synch writes21,3245.980.83
redo wastage2,829,856793.85109.59
redo write time99,70427.973.86
redo writes9,9982.800.39
rollback changes - undo records applied1140.030.00
rollbacks only - consistent read gets1,2370.350.05
root node splits00.000.00
rows fetched via callback78,85322.123.05
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits244,32568.549.46
session logical reads142,753,65140,046.175,528.37
shared hash latch upgrades - no wait119,26033.464.62
shared hash latch upgrades - wait1640.050.01
sorts (disk)50.000.00
sorts (memory)1,052,815295.3440.77
sorts (rows)16,242,8944,556.56629.03
sql area evicted30,7988.641.19
sql area purged230.010.00
summed dirty queue length94,00326.373.64
switch current to new buffer2,3850.670.09
table fetch by rowid134,78637.815.22
table fetch continued row2520.070.01
table scan blocks gotten127,023,95435,633.574,919.21
table scan rows gotten4,156,004,6951,165,869.00160,948.21
table scans (direct read)30.000.00
table scans (long tables)6720.190.03
table scans (short tables)331,96893.1312.86
temp space allocated (bytes)00.000.00
total cf enq hold time152,32042.735.90
total number of cf enq holders134,25137.665.20
total number of times SMON posted140.000.00
transaction rollbacks710.020.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied840.020.00
undo change vector size193,090,86054,167.087,477.77
user I/O wait time109,00530.584.22
user calls927,583260.2135.92
user commits21,4256.010.83
user rollbacks4,3971.230.17
workarea executions - onepass100.000.00
workarea executions - optimal477,957134.0818.51
write clones created in background4870.140.02
write clones created in foreground2,4730.690.10

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current312392
workarea memory allocated31,48930,129
logons current766856
session uga memory max23,569,646,257,87223,619,087,336,312
session pga memory118,065,852,624118,279,969,680
session pga memory max139,435,717,488139,786,186,224
session cursor cache count483,147,271483,869,138
session uga memory222,993,844,916,328223,257,268,856,504

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)104105.03

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)
LGWR14.6G267.574.179847.3G5.762.09441976.1K2.13
Others7.6G5.732.1785613.4G6.113.8476942.2K14.13
Buffer Cache Reads11.6G191.933.320590M0.000M684.2K0.16
DBWR0M0.010M7.4G211.152.1350878413414.30
Direct Reads2.8G2.66.815770982M1.68.27547695030.93
Direct Writes0M0.000M1.2G1.89.35402412.7K54.50
Streams AQ0M0.000M0M0.000M1344.31
TOTAL:36.5G467.8910.494730.3G226.598.706691725.5K8.12

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 File13.3G193.213.823297.4G211.442.139010.171.63
Control File14.8G270.744.26484145M2.61.0406760.030.00
Log File7.3G2.292.098897.3G5.172.085150.060.00
Archive Log0M0.000M7.3G2.112.09525  
Temp File1.1G1.66.3167142.2G3.55.6280980.000.07
TOTAL:36.6G467.9010.503724.3G224.896.988190.090.72

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR 14.6G267.574.179847.3G5.782.10507954K0.03
LGWR (Control File) 14.6G267.514.1798433M0.59.009257953.6K0.02
LGWR (Log File) 0M0.060M7.3G5.182.095814246.73
Others 7.6G5.752.1875413.4G6.123.8572321.4K1.32
Others (Log File) 7.3G2.232.100300M0.000M79640.01
Others (Archive Log) 0M0.000M7.3G2.112.100020 
Others (Data File) 8M0.27.0022446G1.991.72551191612.07
Others (Control File) 303M3.24.084999113M2.02.03169911.5K0.45
Buffer Cache Reads 11.6G191.983.325920M0.000M684.3K0.16
Buffer Cache Reads (Data File) 11.6G191.983.325920M0.000M684.3K0.16
DBWR 0M0.010M7.4G211.222.13789300.00
DBWR (Data File) 0M0.000M7.4G211.222.137890 
DBWR (Control File) 0M0.010M0M0.000M300.00
Direct Reads 2.8G2.66.815770982M1.68.2754760 
Direct Reads (Data File) 2.8G2.66.815770982M1.68.2754760 
Direct Writes 0M0.000M1.2G1.89.3540240 
Direct Writes (Data File) 0M0.000M1.2G1.89.3540240 
Streams AQ 0M0.000M0M0.000M1344.31
Streams AQ (Data File) 0M0.000M0M0.000M1344.31
TOTAL: 36.6G467.9610.509030.4G226.698.729701659.8K0.10

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
USERCENTER20120220_DATA 685,4931920.092.54713,973200496,73413.18
USERCENTER_TEMP 5,91120.0024.4412,670400.00
UNDOTBS1 7300.001.0017,6705411608.42
SYSAUX 1,163028.491.051,168000.00
SYSTEM 400024.381.0016901,078975.42
USERCENTER_HIS 2035.001.000000.00
USERCENTER_INFO 2045.001.000000.00
USERS 2045.001.000000.00
EXAMPLE 100.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)
EXAMPLE/opt/oracle/oradata/jqhx/example01.dbf 100.001.000000.00
SYSAUX/opt/oracle/oradata/jqhx/sysaux01.dbf 1,163028.491.051,168000.00
SYSTEM/opt/oracle/oradata/jqhx/system01.dbf 400024.381.0016901,078975.42
UNDOTBS1/opt/oracle/oradata/jqhx/undotbs01.dbf 7300.001.0017,6705411608.42
USERCENTER20120220_DATA/opt/oracle/oradata/jqhx/USERCENTER20120220_DATA.dbf 630,7141770.092.512,5401185,45224.04
USERCENTER20120220_DATA/opt/oracle/oradata/jqhx/USERCENTER20120220_DATA1.dbf 54,268150.092.84363,141102165,3247.41
USERCENTER20120220_DATA/opt/oracle/oradata/jqhx/USERCENTER20120220_DATA2.dbf 51102.581.00348,29298145,9585.93
USERCENTER_HIS/opt/oracle/oradata/jqhx/USERCENTER_HIS.dbf 2035.001.000000.00
USERCENTER_INFO/opt/oracle/oradata/jqhx/USERCENTER_INFO.dbf 2045.001.000000.00
USERCENTER_TEMP/opt/oracle/oradata/jqhx/USERCENTER_TEMP.dbf 5,91120.0024.4412,67040 
USERS/opt/oracle/oradata/jqhx/users01.dbf 2045.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
D370,73099142,312,0911,513,576960,56000505,704

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0801,73900548119,590

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
B0131569115743842058060838420   
E03944894704804580608580608966691   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D2880.10351.1640,359,7241199127.00
D5760.19711.0235,489,6281144566.00
D8640.291061.0034,934,9191138351.00
D1,1520.381421.0034,907,2991138042.00
D1,4400.481771.0034,906,9261138038.00
D1,7280.572131.0034,906,6881138035.00
D2,0160.672481.0034,906,5091138033.00
D2,3040.772841.0034,906,4011138032.00
D2,5920.863191.0034,906,3221138031.00
D2,8800.963551.0034,906,2621138030.00
D3,0081.003711.0034,906,2391138030.00
D3,1681.053901.0034,906,2101138030.00
D3,4561.154261.0034,906,1571138029.00
D3,7441.244611.0034,906,0891138028.00
D4,0321.344971.0034,906,0481138028.00
D4,3201.445321.0034,905,3041138020.00
D4,6081.535681.0034,903,0151137994.00
D4,8961.636031.0034,897,1641137928.00
D5,1841.726391.0034,864,1131137558.00
D5,4721.826741.0034,813,4731136991.00
D5,7601.917100.9733,962,3251129354.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
89.5821,5622,508

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)
B03,144935.603.960.42100.000.00429,260
E03,0821,061.082.630.25100.000.00429,260

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K472,758472,75800
64K128K43243200
128K256K36836800
256K512K11011000
512K1024K3,0663,06600
1M2M80280200
2M4M484800
4M8M787800
8M16M10910900
16M32M303000
32M64M14214200
64M128M606000
128M256M100100

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
5240.132,362,450.821,560,062.9460.009,019744,067,826
1,0480.252,362,450.82378,854.7886.001,793520,002,585
2,0960.502,362,450.82110,083.9796.00151469,019,026
3,1440.752,362,450.82103,283.1996.0013467,728,976
4,1921.002,362,450.82102,330.9796.003467,548,347
5,0301.202,362,450.82816.67100.000448,291,940
5,8691.402,362,450.82816.67100.000448,291,940
6,7071.602,362,450.82816.67100.000448,291,940
7,5461.802,362,450.82816.67100.000448,291,940
8,3842.002,362,450.82816.67100.000448,291,940
12,5763.002,362,450.82816.67100.000448,291,940
16,7684.002,362,450.82816.67100.000448,291,940
25,1526.002,362,450.82816.67100.000448,291,940
33,5368.002,362,450.82816.67100.000448,291,940

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)
2,7200.5936733,2722,370,8610.374,644,4757.41868,644
3,2000.6984654,6463,440,1230.543,575,2135.711,100,108
3,6800.791,32576,7144,452,5770.702,562,7594.091,308,805
4,1600.901,80598,1205,464,2290.861,551,1072.481,517,416
4,3200.931,964103,5695,800,7800.911,214,5561.941,586,950
4,3520.941,996104,5745,868,0390.921,147,2971.831,600,855
4,3840.942,028105,6835,935,3560.931,079,9801.721,614,758
4,4160.952,060106,8546,002,5800.941,012,7561.621,628,661
4,4480.962,092108,0846,070,2880.95945,0481.511,642,722
4,4800.972,123109,1866,137,9700.96877,3661.401,656,701
4,5120.972,155110,1796,210,9180.97804,4181.281,671,622
4,5440.982,187111,3366,265,4670.98749,8691.201,682,692
4,5760.992,219112,3386,305,1690.99710,1671.131,690,570
4,6080.992,251113,3546,344,5280.99670,8081.071,698,395
4,6401.002,283114,6116,388,6891.00626,6471.001,706,908
4,6721.012,314116,1096,389,9041.00625,4321.001,707,115
4,7041.012,345117,4816,389,9651.00625,3711.001,707,121
4,7361.022,377118,4566,390,0271.00625,3091.001,707,127
4,7681.032,409119,2846,390,0991.00625,2371.001,707,133
4,8001.032,440120,0666,390,1641.00625,1721.001,707,139
4,8321.042,472120,8336,390,2261.00625,1101.001,707,144
4,8641.052,504121,6466,390,2871.00625,0491.001,707,148
4,8961.062,535122,5026,390,3411.00624,9951.001,707,152
4,9281.062,567123,5346,390,3851.00624,9511.001,707,155
5,1201.102,759128,8976,390,6831.00624,6531.001,707,180
5,6001.213,239144,3046,391,3291.00624,0071.001,707,239
6,0801.313,719164,4536,391,8931.00623,4430.991,707,289
6,5601.414,198191,1416,392,3791.00622,9570.991,707,331
7,0401.524,678227,6946,392,9031.00622,4330.991,707,372
7,5201.625,158269,8156,393,4221.00621,9140.991,707,412
8,0001.725,638311,9786,394,0491.00621,2870.991,707,455
8,4801.836,118351,9106,394,7761.00620,5600.991,707,498
8,9601.936,598385,9366,395,4901.00619,8460.991,707,541
9,4402.037,078423,1806,396,1851.00619,1510.991,707,579

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,9040.506,927,60635,489,172,920
4,8800.634,282,54940,358,593,223
5,8560.753,969,17234,934,163,724
6,8320.883,967,98234,906,238,733
7,8081.003,966,78634,906,238,733
8,7841.133,965,60234,906,238,733
9,7601.253,964,41234,906,238,733
10,7361.383,959,65233,960,279,663
11,7121.503,958,46233,960,279,663
12,6881.633,957,66933,960,279,663
13,6641.753,956,47933,960,279,663
14,6401.883,954,89333,960,279,663
15,6162.003,954,49633,960,279,663

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)
321.000000
642.000000
963.000000
1284.000000
1605.000000
1926.000000
2247.000000
2568.000000
2889.000000
32010.000000
35211.000000
38412.000000
41613.000000
44814.000000
48015.000000
51216.000000
54417.000000
57618.000000
60819.000000
64020.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 block227,1097,05331
1st level bmb269,3975502
undo header390244625
undo block206319
segment header5,35441
2nd level bmb50200
file header block200

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
SQ-Sequence Cache 5,2135,12104,16097,73823,494.62
TX-Transaction (row lock contention) 18918001871,2526,697.38
KO-Multiple Object Checkpoint (fast object checkpoint) 3030037926,356.67
CF-Controlfile Transaction 270,080270,0413922745199.34
JD-Job Queue Date 784784013333,420.00
FB-Format Block 59,73759,73701,80373.67
TX-Transaction (index contention) 1211210118322.63
HW-Segment High Water Mark 5,2265,224247412.76
TX-Transaction 23,72923,729046811.73

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.3222,8582,1684625.6/51.20/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
03-9月 10:593,9984,3562,16838510/00/0/0/0/0/0
03-9月 10:493,9363,4131,78643450/00/0/0/0/0/0
03-9月 10:394,3243,7601,18433350/00/0/0/0/0/0
03-9月 10:293,4253,0671,23431360/00/0/0/0/0/0
03-9月 10:193,2654,13163146260/00/0/0/0/0/0
03-9月 10:094,3724,1311,23535360/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM db client latch2,5620.00 00 
ASM map operation hash table10.00 00 
ASM network state latch5,3930.00 00 
AWR Alerted Metric Element list42,7710.00 00 
Change Notification Hash table latch1,1740.00 00 
Consistent RBA10,1040.00 00 
DML lock allocation95,0960.010.0000 
Event Group Locks228,3700.010.0000 
FAL Queue3060.00 00 
FIB s.o chain latch6390.00 00 
FOB s.o list latch4,9300.060.0000 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch38,9700.370.916444,0510.11
JS Sh mem access90.00 00 
JS mem alloc latch50.00 00 
JS queue access latch60.00 00 
JS queue state obj latch26,4220.00 00 
JS slv state obj latch2320.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 latch1,2790.00 00 
KTF sga latch210.00 01,1940.00
KWQMN job cache list latch30.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch40.00 00 
KWQS pqueue ctx latch670.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0760.00
Memory Management Latch10.00 01,2790.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 Latch420.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process456,8430.00 00 
OS process allocation236,3410.090.0000 
OS process: request allocation228,1530.100.0000 
PL/SQL warning settings130,3320.000.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch23,6190.00 00 
Reserved Space Latch4140.00 00 
SGA IO buffer pool latch8,0550.020.00014,2580.02
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1230.00 01,2320.00
SQL memory manager workarea list latch450,7670.000.0000 
Shared B-Tree3180.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$KSFQP9630.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch133,0570.020.0000 
active service list694,4700.320.0207,0460.06
alert log latch2070.00 00 
archive control3740.00 00 
archive process latch1,0283.791.0000 
begin backup scn array530.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles1,029,2521.680.0000 
cache buffers chains298,736,9041.270.00153,743,5340.00
cache buffers lru chain973,4080.760.020100,878,6250.22
cache table scan latch242,3830.010.000242,3830.01
call allocation343,1992.870.71210 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch228,1840.040.0100 
channel operations parent latch360,2560.060.0100 
checkpoint queue latch1,523,0120.000.000993,2030.07
client/application info684,6870.000.0000 
compile environment latch114,2120.020.0000 
corrupted undo seg latch4130.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch5,3930.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch5,3930.00 00 
dml lock allocation5,3930.00 00 
done queue latch10.00 00 
dummy allocation228,2670.830.0100 
enqueue freelist latch10.00 01,163,9390.00
enqueue hash chains1,602,6110.190.08135,7780.01
enqueues530.00 00 
fifth spare latch10.00 00 
file cache latch6330.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA114,0140.00 00 
global tx hash mapping5670.00 00 
granule operation10.00 00 
hash table column usage latch4260.00 04,927,2860.02
hash table modification latch1020.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch220.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch740.00 0730.00
job_queue_processes free list latch1500.00 00 
job_queue_processes parameter latch8520.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch1040.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch3540.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock430.00 00 
ksuosstats global area3870.00 00 
ksv allocation latch5,4760.00 00 
ksv class latch830.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch228,1530.120.0000 
ktm global data980.00 00 
kwqbsn:qsga1390.00 00 
lgwr LWN SCN10,7190.030.0000 
list of block allocation73,0571.380.79370 
loader state object freelist700.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.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 parent30,1830.00 01190.00
managed standby latch2040.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch490.00 00 
messages646,5976.150.0000 
mostly latch-free SCN10,8800.310.0000 
msg queue latch10.00 00 
multiblock read objects1,358,2370.020.000270.00
name-service namespace bucket10.00 00 
ncodef allocation latch5,3930.00 00 
object queue header heap16,9290.00 09,4200.00
object queue header operation7,850,7160.080.0100 
object stats modification610.00 00 
parallel query alloc buffer7510.00 00 
parallel query stats10.00 00 
parameter list4,8160.00 00 
parameter table management457,4940.120.2000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue839,47713.010.000906,3534.35
process allocation228,2934.081.0680113,9030.22
process group creation228,1530.110.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5600.180.0000 
query server freelists10.00 00 
queued dump request130.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation352,05225.220.0104,981,43010.56
redo copy10.00 05,079,6980.16
redo writing816,75226.550.0000 
reservation so alloc latch2070.00 00 
resmgr group change latch114,1330.000.0000 
resmgr:active threads228,2670.001.0000 
resmgr:actses change group114,0960.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list228,2661.130.0000 
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 objects31,036,0600.310.0002790.00
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache412,2310.680.0000 
session allocation634,9420.020.000406,9540.02
session idle bit2,143,8070.000.0100 
session queue latch10.00 00 
session state list latch228,4101.210.0100 
session switching119,3900.110.00020.00
session timer5,6380.00 00 
shared pool9,871,8721.110.05120 
shared pool sim alloc10.00 00 
shared pool simulator108,4170.050.1400 
sim partition latch10.00 00 
simulator hash latch18,652,6220.000.0000 
simulator lru latch918,8310.020.00012,174,3012.96
sort extent pool6,6710.00 00 
space background state object latch70.00 00 
space background task latch4,9420.160.0002,5660.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch1780.00 00 
transaction allocation64,3330.010.4000 
transaction branch allocation6,1480.100.0000 
undo global data1,123,9880.030.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
cache buffers chains298,736,9043,802,3693,6223,802,528
redo writing816,752216,82272216,750
post/wait queue839,477109,20914109,195
shared pool9,871,872109,1545,429104,094
row cache objects31,036,06096,47034396,145
redo allocation352,05288,80254188,275
messages646,59739,7851339,772
cache buffer handles1,029,25217,299917,292
call allocation343,1999,8646,9653,916
process allocation228,2939,3169,898622
cache buffers lru chain973,4087,3771677,214
object queue header operation7,850,7166,641626,579
enqueue hash chains1,602,6112,9722252,768
sequence cache412,2312,79342,789
session state list latch228,4102,767152,752
resmgr:free threads list228,2662,57082,562
active service list694,4702,207512,159
dummy allocation228,2671,888181,870
list of block allocation73,0571,007793246
parameter table management457,494550108446
simulator hash latch18,652,6225082506
undo global data1,123,9883803377
OS process: request allocation228,1532331232
channel operations parent latch360,2562001199
In memory undo latch38,97014513216
session idle bit2,143,8071071106
channel handle pool latch228,18485184
shared pool simulator108,41756848
archive process latch1,02839390
transaction allocation64,333523
resmgr:active threads228,267110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchkticmt: child0899
In memory undo latchktiFlush: child042108
In memory undo latchktiFlushMe010
OS process: request allocationksoreqholder_delete010
active service listkswslogon: session logout08964
active service listkswsgsnp: get service name ptr01227
active service listkswsite: service iterator010
active service listkswslogon: session login016
archive process latchkcrrsarc0390
cache buffer handleskcbzfs069
cache buffer handleskcbzgs030
cache buffers chainskcbgtcr_201,600794
cache buffers chainskcbgtcr: fast path (cr pin)01,3101,964
cache buffers chainskcbgcur_2041439
cache buffers chainskcbchg1: mod cr pin0303123
cache buffers chainskcbgtcr: kslbegin excl0131122
cache buffers chainskcbgcur: fast path (shr)083109
cache buffers chainskcbzwb07426
cache buffers chainskcbrls: fast release024335
cache buffers chainskcbrls_2021125
cache buffers chainskcbgcur_401033
cache buffers chainskcbgtcr: fast path093
cache buffers chainskcbchg1: clear MS bit06153
cache buffers chainskcbnew: new latch again043
cache buffers chainskcbzgb: scan from tail. nowait040
cache buffers chainskcbzibmlt: multi-block read: nowait040
cache buffers chainskcbzdh030
cache buffers chainskcbchg1: mod cur pin02109
cache buffers chainskcbbic2013
cache buffers chainskcbget: fast exchange012
cache buffers chainskcbget: pin buffer010
cache buffers chainskcbzibmlt: finish free bufs012
cache buffers lru chainkcbbic2059162
cache buffers lru chainkcbzgb0565
cache buffers lru chainkcbzgws0390
cache buffers lru chainkcbzar: KSLNBEGIN0130
call allocationksuxds04,7314,838
call allocationksudlp: top call02,2101,778
call allocationksucrp: top call043369
call allocationksudlc : rec call054
call allocationksuprc034
call allocationksusroll010
channel handle pool latchksrchconnect()011
channel operations parent latchksrchdelete_sub()011
dummy allocationktcscnfy01313
dummy allocationktcdod055
enqueue hash chainsksqrcl0197128
enqueue hash chainsksqgtl301478
enqueue hash chainsksqcmi: get hash chain latch after wait01321
enqueue hash chainsksqcmi: kslgpl096
enqueue hash chainsksqcmi: if deadlock detected022
list of block allocationktlabl0730726
list of block allocationktcdod06266
list of block allocationktlbbl012
messagesksaamb: after wakeup0913
messagesksarcv030
messagesksarcv: after wait010
object queue header operationkcbo_switch_cq07855
object queue header operationkcbo_unlink_q01333
object queue header operationkcbo_link_q013
parameter table managementksp_param_table_free01214
parameter table managementkspcpy0264
post/wait queueksliwat:remove0813
post/wait queueksliwat:add:nowait050
post/wait queueksliwat:add:wait011
process allocationksucrp:105,9530
process allocationksudlp02,8303,333
process allocationksuapc01,1186,566
redo allocationkcrfw_redo_gen: redo allocation 102890
redo allocationkcrfw_redo_gen: redo allocation 30205527
redo allocationkcrfw_redo_gen: redo allocation 20380
redo allocationkcrfw_redo_write: before write0814
redo allocationkcrfw_redo_gen: redo allocation 0010
redo writingkcrfws: in loop07072
redo writingkcrfw_cal_target_rba010
redo writingkcrfwnf: new logfile010
resmgr:active threadskgskgtwt010
resmgr:free threads listkskthrcreate088
row cache objectskqreqd: reget01738
row cache objectskqrpre: find obj0103195
row cache objectskqreqd064140
row cache objectskqrso030
sequence cachekdnnxt: cached seq023
sequence cachekdnss021
session idle bitksupuc: clear busy011
session state list latchkpseqd091
session state list latchkpseqa0614
shared poolkghalo04,9384,318
shared poolkghfre0181497
shared poolkghalp0169149
shared poolkghupr10123432
shared poolkgh_heap_sizes01622
shared poolkghasp0720
shared poolkghdmp:old030
shared pool simulatorkglsim_upd_newhp086
simulator hash latchkcbsacc: lookup dba022
transaction allocationktcxbr011
transaction allocationktiNonImuPoolAllocate010
undo global dataktudba: KSLBEGIN0294
undo global datakturax010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekgllkdl1 8570,0480
Library Cachekglhdgn2 10668,3380
Library Cachekglget1 167,6860
Library Cachekglpndl1 957,0990
Library Cachekglhdgn1 623,5490
Library Cachekglpin1 43,2140
Cursor Pinkkslce [KKSCHLPIN2]1,9240
Library Cachekgldtin1 421,4850
Library Cachekgllkc1 571,3840
Library Cachekglhdgh1 641,2340
Library Cachekglpnal1 901,1760
Cursor Pinkksfbc [KKSCHLFSP2]540
Cursor ParentkkscsPruneChild [KKSPRTLOC35]300
Cursor PinkksLockDelete [KKSCHLPIN6]220
Library Cachekglget2 2200
Cursor Pinkksfbc [KKSCHLPIN1]200
Library Cachekglrfcl1 79150
Library Cachekglobpn1 71100
Library Cachekgllkal3 8240
Library Cachekglini1 3230
Cursor Parentkksfbc [KKSPRTLOC3]30
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]20

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
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE50,360,86435.28
USERCENTERUSERCENTER20120220_DATASMS_MASS TABLE23,893,29616.74
USERCENTERUSERCENTER20120220_DATASMS_SEND_ENT TABLE21,388,22414.98
USERCENTERUSERCENTER20120220_DATASMS_SEND_AH TABLE14,373,53610.07
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE9,132,2086.40

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE1,672,93588.63
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX8720.05
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX6590.03
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE3200.02
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE2550.01

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE680,92698.20
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX8720.13
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX6590.10
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE3200.05
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE2550.04

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE680,92698.20
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX8720.13
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX6590.10
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE3200.05
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE2550.04

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

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Reads%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE229,17461.28

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE896,39371.68
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE5,7260.46
USERCENTERUSERCENTER20120220_DATAT_USER_LOG TABLE1,1770.09
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1,1020.09
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX9120.07

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE692,09191.47
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE5,2780.70
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1,0160.13
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX9020.12
USERCENTERUSERCENTER20120220_DATAT_USER_LOG TABLE7450.10

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_2877231475_4191TABLE PARTITION6710.23

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE66392.86

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE4,884,73695.29
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE176,9443.45
SYSSYSTEMSEQ$ TABLE14,2720.28
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE10,5920.21
USERCENTERUSERCENTER20120220_DATAT_USER_LOG TABLE9,9360.19

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX10634.42
USERCENTERUSERCENTER20120220_DATASMS_SEND_XW TABLE7524.35
USERCENTERUSERCENTER20120220_DATAT_FEE TABLE5718.51
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE3912.66
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX154.87

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
USERCENTERUSERCENTER20120220_DATAF_PAR_EXC TABLE296,08597.84
USERCENTERUSERCENTER20120220_DATASMS_SEND_XW TABLE3,1291.03
SYSSYSTEMSEQ$ TABLE1,0130.33
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE5570.18
USERCENTERUSERCENTER20120220_DATAT_FEE TABLE5320.18

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control700.000 21
dc_files10100.000 010
dc_global_oids4740.000 068
dc_histogram_data461,9280.030 02,876
dc_histogram_defs318,0610.270 03,102
dc_object_grants20.000 032
dc_objects301,9630.020 52,276
dc_profiles114,2070.000 01
dc_rollback_segments33,9450.000 0704
dc_segments141,7320.060 181,127
dc_sequences1,0780.090 1,07824
dc_tablespaces2,109,0050.000 011
dc_users8,892,4070.000 0132
global database name116,5710.000 01
outstanding_alerts553.640 29
sch_lj_oids50.000 051


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS228,2820.000 00
BODY1,8220.222,6960.3350
CLUSTER244.17263.8500
DBLINK228,3430.000 00
EDITION114,2180.00228,4190.0000
INDEX8425.008425.0000
QUEUE610.001990.0000
RULESET0 20.0000
SCHEMA114,2410.000 00
SQL AREA837,8403.251,950,9627.9971,96823
SQL AREA BUILD99,33528.500 00
SQL AREA STATS28,35999.4228,34999.4200
SUBSCRIPTION130.00130.0000
TABLE/PROCEDURE172,5440.01462,9300.124620
TRIGGER1,4490.003,1140.2270


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 cache3,008.003,008.002,528.003,104.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target4,192.004,192.004,192.004,768.000SHR/MAN
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target7,808.007,808.007,232.007,808.000GRO/DEF
Shared IO Pool0.000.000.000.000STA/
java pool32.0032.0032.0032.000STA/
large pool32.0032.0032.0032.000STA/
shared pool4,640.004,640.004,448.004,640.000GRO/DEF
streams pool32.0032.0032.0032.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
BOther852.20 1.111.892727770770
Freeable78.060.001.562.1610 5050
SQL6.695.510.010.12313751240
PL/SQL2.591.100.000.0102767767
EOther943.00 1.101.832828858858
Freeable125.690.001.341.7710 9494
SQL4.583.190.010.09313840294
PL/SQL3.391.670.000.0101856856

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers3,154,116,608 
Fixed Size2,237,488 
Redo Buffers17,973,248 
Variable Size7,281,314,768 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory32.0032.000.00
largePX msg pool7.817.810.00
largefree memory24.1924.190.00
sharedASH buffers48.0048.000.00
sharedKGLH0610.97564.31-7.64
sharedKGLHD98.6291.41-7.32
sharedSQLA2,032.242,032.290.00
shareddbktb: trace buffer46.8846.880.00
sharedevent statistics per sess56.6256.620.00
sharedfree memory1,086.051,132.464.27
sharedkglsim object batch78.0778.070.00
sharedksunfy : SSO free list52.7852.780.00
sharedprivate strands64.6864.680.00
streamsfree memory32.0032.000.00
 buffer_cache3,008.003,008.000.00
 fixed_sga2.132.130.00
 log_buffer17.1417.140.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator0803 10:21:130.000.000.00
QMON Slaves0803 10:21:230.000.580.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 20.0000.000.000.000.000.000.000

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12733) 20100.000.000.000.000.0017.66
SYS.AQ$_ALERT_QT_E(12732) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 53530.000.000.0544.850.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(12733) 0.000.000.00 
SYS.AQ$_ALERT_QT_E(12732) 0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 0.010.010.000.85

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   
LOCALHOST_LOC_3938_JQHX(41)/SYS.ALERT_QUE 2000.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 %
3,9020.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.003,9010.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/opt/oracle/admin/jqhx/adump  
audit_trailNONE  
compatible11.2.0.0.0  
control_file_record_keep_time14  
control_files/opt/oracle/oradata/jqhx/control01.ctl, /opt/oracle/fast_recovery_area/jqhx/control02.ctl  
db_block_size8192  
db_domainlocaldomain  
db_namejqhx  
db_recovery_file_dest/opt/oracle/fast_recovery_area  
db_recovery_file_dest_size53687091200  
diagnostic_dest/opt/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=jqhxXDB)  
memory_target12582912000  
open_cursors300  
pga_aggregate_target3600  
processes3000  
remote_login_passwordfileEXCLUSIVE  
sga_max_size10502537216  
sga_target7549747200  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/opt/oracle/fast_recovery_area/jqhx/control02.ctl  
/opt/oracle/oradata/jqhx/control01.ctl  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report