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:409430-8月 -13 10:00:40687 .7
End Snap:409530-8月 -13 11:00:44704 .7
Elapsed:  60.07 (mins)  
DB Time:  65.83 (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): 1.1 0.1 0.01 0.01
DB CPU(s): 1.2 0.1 0.01 0.01
Redo size: 9,367.9 866.0  
Logical reads: 87,015.8 8,044.2  
Block changes: 54.9 5.1  
Physical reads: 36.9 3.4  
Physical writes: 65.9 6.1  
User calls: 168.9 15.6  
Parses: 160.4 14.8  
Hard parses: 16.1 1.5  
W/A MB processed: 6.6 0.6  
Logons: 20.9 1.9  
Executes: 181.5 16.8  
Rollbacks: 1.9 0.2  
Transactions: 10.8   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 92.71Soft Parse %: 89.96
Execute to Parse %: 11.62Latch Hit %: 99.69
Parse CPU to Parse Elapsd %: 53.73% Non-Parse CPU: 94.53

Shared Pool Statistics

BeginEnd
Memory Usage %: 73.11 73.94
% SQL with executions>1: 65.67 58.86
% Memory for SQL w/exec>1: 78.93 79.96

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 4,266 108.00 
library cache: mutex X45,9545701214.44Concurrency
enq: TX - row lock contention99313130.78Application
SQL*Net message from dblink25914530.35Network
SQL*Net break/reset to client60,270900.22Application

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

Load Average BeginLoad Average End%User%System%WIO%Idle
1.22 0.87 3.7 2.0 0.0 94.3
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
5.0 87.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): 1,257.5 1,291.5
% Host Mem used for SGA+PGA: 18.77 18.84

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU4,265.52108.00
sql execute elapsed time2,295.6958.12
connection management call elapsed time746.0218.89
parse time elapsed433.9610.99
hard parse elapsed time213.005.39
failed parse elapsed time39.351.00
hard parse (sharing criteria) elapsed time18.000.46
PL/SQL execution elapsed time5.450.14
sequence load elapsed time1.160.03
PL/SQL compilation elapsed time0.300.01
repeated bind elapsed time0.000.00
DB time3,949.70 
background elapsed time47.69 
background cpu time20.76 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME492,815 
IDLE_TIME8,156,220 
IOWAIT_TIME952 
NICE_TIME42 
SYS_TIME173,247 
USER_TIME316,005 
LOAD11
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES17,408 
VM_OUT_BYTES0 
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
30-8月 10:00:401.22     
30-8月 11:00:440.875.703.652.0094.300.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  4,266 108.00
Concurrency49,53705741214.53
Application60,36904011.00
Network332,93101400.37
User I/O34,24701000.24
Commit27,8880600.16
Other71488000.00
Configuration510010.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
library cache: mutex X45,9540570121.1814.44
enq: TX - row lock contention990313130.000.78
SQL*Net message from dblink259014530.010.35
SQL*Net break/reset to client60,2700901.550.22
direct path write temp10,0040810.260.21
log file sync27,8880600.720.16
latch: shared pool3,0380210.080.06
cursor: pin S wait on X4101180.000.02
db file sequential read18,5820100.480.01
SQL*Net message to client324,8610008.330.01
direct path read temp4,6110000.120.01
Disk file operations I/O5930000.020.01
SQL*Net more data to client7,5460000.190.00
kksfbc child completion31000510.000.00
enq: TX - index contention430030.000.00
buffer busy waits1290000.000.00
enq: SQ - contention480010.000.00
read by other session2260000.010.00
latch: row cache objects2130000.010.00
enq: TX - contention110010.000.00
cursor: pin S380000.000.00
latch free620000.000.00
row cache lock50020.000.00
library cache lock40020.000.00
latch: cache buffers chains490000.000.00
enq: HW - contention30010.000.00
db file scattered read2310000.010.00
wait list latch free30010.000.00
latch: In memory undo latch210000.000.00
SQL*Net more data from client210000.000.00
SQL*Net message from client324,83201,819,66656028.33 
jobq slave wait7,5191003,7645010.19 
single-task message15021610.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
latch free5,81705190.15105.96
log file parallel write34,2450600.8811.96
latch: call allocation7220340.025.76
os thread startup13802180.005.23
latch: shared pool1,5200210.043.89
db file async I/O submit7,4990100.192.41
asynch descriptor resize75,097100101.931.69
control file parallel write1,3990100.041.08
Disk file operations I/O1040030.000.56
SQL*Net message to client299,4440007.680.35
Log archive I/O300020.000.11
db file sequential read540010.000.08
control file sequential read3,8290000.100.07
ADR block file read160020.000.07
latch: active service list140020.000.05
library cache: mutex X200110.000.05
log file sequential read350000.000.02
direct path sync10030.000.01
LGWR wait for redo copy270000.000.00
rdbms ipc message54,5143764,81711891.40 
DIAG idle wait7,1731007,18110010.18 
Space Manager: slave idle wait1,396986,90049430.04 
Streams AQ: waiting for time management or cleanup tasks6675,8729786700.00 
SQL*Net message from client374,38604,781139.60 
pmon timer1,207993,60429860.03 
dispatcher timer601003,600600030.00 
shared server idle wait1201003,600300020.00 
Streams AQ: qmn coordinator idle wait256503,585140040.01 
Streams AQ: qmn slave idle wait12803,585280090.00 
smon timer16633,3952121820.00 
class slave wait200000.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 read1656.36.36.331.3    
ADR block file write5100.0       
ADR file lock6100.0       
ARCH wait for archivelog lock1100.0       
Disk file operations I/O69799.6.3    .1 
LGWR wait for redo copy27100.0       
Log archive I/O303.396.7      
SQL*Net break/reset to client60.3K99.9.0.0.0.0 .0 
SQL*Net message from dblink25925.57.35.05.43.1.453.3 
SQL*Net message to client624.1K100.0       
SQL*Net message to dblink244100.0       
SQL*Net more data from client21100.0       
SQL*Net more data to client7546100.0       
asynch descriptor resize75.7K100.0       
buffer busy waits12993.86.2      
buffer deadlock9100.0       
control file parallel write139999.9  .1 .1  
control file sequential read3841100.0       
cursor: pin S3994.92.6  2.6   
cursor: pin S wait on X414.931.7 2.443.99.87.3 
db file async I/O submit749999.9 .0 .0 .0 
db file scattered read215100.0       
db file sequential read18.4K99.7.0.1.2.1   
db file single write10100.0       
direct path read temp4611100.0       
direct path sync1  100.0     
direct path write22100.0       
direct path write temp10K98.3.3.2.4.4.1.2 
enq: FB - contention1100.0       
enq: HW - contention366.7 33.3     
enq: SQ - contention4883.314.62.1     
enq: TX - contention1127.345.527.3     
enq: TX - index contention4346.516.316.39.311.6   
enq: TX - row lock contention99  1.0 1.02.096.0 
kksfbc child completion3      100.0 
latch free58771.1.0.058.537.92.4.1 
latch: In memory undo latch22100.0       
latch: active service list1656.331.3 12.5    
latch: cache buffers chains49100.0       
latch: call allocation72473.3.82.33.38.611.6  
latch: enqueue hash chains3100.0       
latch: row cache objects21397.71.9.5     
latch: shared pool455974.09.311.24.5.8.1  
library cache load lock2100.0       
library cache lock425.025.050.0     
library cache: mutex X45.9K31.4.4.1.047.511.88.8 
log file parallel write34.2K99.9.0.0.0.0.0.0 
log file sequential read35100.0       
log file single write2100.0       
log file sync27.9K99.7.1.0.1.1.0.0 
os thread startup138    5.194.9  
read by other session22698.7  1.3    
reliable message8100.0       
row cache lock520.040.040.0     
wait list latch free580.020.0      
DIAG idle wait7173      100.0 
SQL*Net message from client699K79.9.89.0.7.3.31.47.5
Space Manager: slave idle wait1377  .3 .3 .598.9
Streams AQ: qmn coordinator idle wait25850.0      50.0
Streams AQ: qmn slave idle wait129       100.0
Streams AQ: waiting for time management or cleanup tasks633.3     33.333.3
class slave wait20100.0       
dispatcher timer60       100.0
jobq slave wait7519.1  .0  99.9 
pmon timer1207.1     .499.5
rdbms ipc message54.5K4.41.52.24.38.610.646.621.9
shared server idle wait120       100.0
single-task message15     33.366.7 
smon timer205.0 5.0 10.0 10.070.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
Disk file operations I/O199.9  .1    
SQL*Net break/reset to client10100.0.0      
SQL*Net message from dblink13846.740.98.5  3.9  
cursor: pin S wait on X392.74.9  2.4   
db file async I/O submit2100.0.0.0     
direct path write temp2599.8.2.1 .0   
enq: TX - row lock contention954.09.14.08.174.7   
kksfbc child completion3 100.0      
latch free499.9.1      
library cache: mutex X404391.27.11.6.1.0   
log file parallel write4100.0.0.0.0    
log file sync6100.0.0.0.0    

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

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$USERS3,9514,267133313,694
SYS$BACKGROUND00030
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 3425110495045740033294214
SYS$BACKGROUND 191014330000

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
57.48227,9060.001.4699.980.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
33.0722,1200.000.8499.920.332rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
31.8747.970.8181.0727.28d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
30.9374,9130.000.7896.890.000k8522rmdzg4k   select privilege# from sysauth...
30.06142.150.76100.010.00bapm596n71ksu   SELECT * FROM (SELECT DISTINCT...
27.56132.120.7099.950.000dvt133hht7z1   SELECT * FROM (SELECT DISTINCT...
24.1374,8440.000.61102.510.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
18.8574,8450.000.4893.690.00459f3z9u4fb3u   select value$ from props$ wher...
17.8682.230.4599.990.00f864vaafk20d4   SELECT * FROM (SELECT DISTINCT...
15.4462.570.3999.950.004r4scc3q60nf0   SELECT * FROM (SELECT DISTINCT...

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
57.47227,9060.001.3557.4899.980.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
33.0522,1200.000.7733.0799.920.332rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
30.07142.150.7030.06100.010.00bapm596n71ksu   SELECT * FROM (SELECT DISTINCT...
29.9774,9130.000.7030.9396.890.000k8522rmdzg4k   select privilege# from sysauth...
27.55132.120.6527.5699.950.000dvt133hht7z1   SELECT * FROM (SELECT DISTINCT...
25.8446.460.6131.8781.0727.28d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
24.7374,8440.000.5824.13102.510.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
17.8682.230.4217.8699.990.00f864vaafk20d4   SELECT * FROM (SELECT DISTINCT...
17.6674,8450.000.4118.8593.690.00459f3z9u4fb3u   select value$ from props$ wher...
15.4362.570.3615.4499.950.004r4scc3q60nf0   SELECT * FROM (SELECT DISTINCT...

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
8.6942.1788.0631.8781.0727.28d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
0.178220.001.710.6646.2125.52167wxs395avun   INSERT INTO SMS_SEND (ID, YWMC...
0.161,2870.001.590.5985.8226.44d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...
0.1122,1200.001.1233.0799.920.332rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
0.1122,1210.001.1213.75100.670.8079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
0.041500.000.420.1396.9131.872zfk3ymatx835 oracle@bogon (TNS V1-V3) INSERT INTO "SMS_SEND" "A1" ("...
0.001,5040.000.050.7291.900.694m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.0010.000.010.19100.170.696ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.00670.000.010.0398.832.90a4rpas1bqxyd0   INSERT INTO SMS_RECV (ID, TJSJ...
0.00910.000.000.04111.031.190q3c228dffzgt   INSERT INTO SMS_ORDER (ID, LSH...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
2,107,060227,9069.250.6757.481000cm5vu20fhtnq1   select /*+ connect_by_filterin...
452,77074,9136.040.1430.9396.900k8522rmdzg4k   select privilege# from sysauth...
407,864581,572.800.133.161000aup4fgkmr583a   SELECT V.GUID, V.ZHMC, V.SJHM,...
341,7411801,898.560.118.2899.90bngd3h7xxyz19   UPDATE SMS_RECV SET CLZT=1, DQ...
341,6401801,898.000.116.9410008cacvv4vp0bbm   UPDATE SMS_RECV SET CLZT=1, DQ...
224,53374,8453.000.0718.8593.70459f3z9u4fb3u   select value$ from props$ wher...
161,56222,1207.300.0533.0799.9.32rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
149,69074,8432.000.0513.36101.305ur69atw3vfhj   select decode(failover_method,...
139,45522,1216.300.0413.75100.7.879c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
132,81622,1366.000.045.8798.704htx4ts19yknq   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
114,050428,512.5085.7431.8781.0727.28d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
1381,2870.110.100.5985.8226.44d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...
731500.490.050.1396.9131.872zfk3ymatx835 oracle@bogon (TNS V1-V3) INSERT INTO "SMS_SEND" "A1" ("...
688220.080.050.6646.2125.52167wxs395avun   INSERT INTO SMS_SEND (ID, YWMC...
3422,1200.000.0333.0799.920.332rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
3422,1210.000.0313.75100.670.8079c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
25125.000.020.19100.170.696ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
2670.030.000.0398.832.90a4rpas1bqxyd0   INSERT INTO SMS_RECV (ID, TJSJ...
150.200.003.1699.950.00aup4fgkmr583a   SELECT V.GUID, V.ZHMC, V.SJHM,...
010.000.000.00649.350.0005sghzkq6r6yv   select ts#, file#, block#, col...

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
4,6114,61141,152.750.0019.75d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...
1381381,2870.110.000.59d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...
73731500.490.000.312zfk3ymatx835 oracle@bogon (TNS V1-V3) INSERT INTO "SMS_SEND" "A1" ("...
343422,1200.000.000.152rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
343422,1210.000.000.1579c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
22670.030.000.01a4rpas1bqxyd0   INSERT INTO SMS_RECV (ID, TJSJ...
0010.00 0.0005sghzkq6r6yv   select ts#, file#, block#, col...
003680.00 0.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
001770.00 0.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
00600.00 0.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
227,9063,073,38913.4957.481000cm5vu20fhtnq1   select /*+ connect_by_filterin...
74,913227,9723.0430.9396.900k8522rmdzg4k   select privilege# from sysauth...
74,84574,8441.0018.8593.70459f3z9u4fb3u   select value$ from props$ wher...
74,84474,8441.0024.13102.500ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
74,84374,8451.0013.36101.305ur69atw3vfhj   select decode(failover_method,...
22,13622,1361.005.8798.704htx4ts19yknq   select f_ip, to_char(f_invalid...
22,12122,1071.0013.75100.7.879c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
22,12022,1211.0033.0799.9.32rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
3,8363,8361.000.1896.30grwydz59pu6mc   select text from view$ where r...
1,5041,5041.000.7291.9.74m7m0t6fjcs5x   update seq$ set increment$=:2,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
74,913227,90612.96cm5vu20fhtnq1   select /*+ connect_by_filterin...
74,91274,91312.960k8522rmdzg4k   select privilege# from sysauth...
74,84574,84412.950ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
74,84574,84512.95459f3z9u4fb3u   select value$ from props$ wher...
74,84574,84312.955ur69atw3vfhj   select decode(failover_method,...
22,13622,1363.834htx4ts19yknq   select f_ip, to_char(f_invalid...
22,12122,1203.832rgmdtpdz21yq   BEGIN proc_locationinfo(:1, :2...
22,12122,1213.8379c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...
1,3261,5040.234m7m0t6fjcs5x   update seq$ set increment$=:2,...
3741,2870.06d5jz0t3f6r3bd   INSERT INTO SMS_SEND (ID, YWMC...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,401,88760.095gh60az1a4s7w   SELECT * FROM (SELECT DISTINCT...
3,657,07540.08b10jp3ak2bbx5   SELECT * FROM (SELECT DISTINCT...
2,975,99350.063va7bfq0j6k2a   SELECT * FROM (SELECT DISTINCT...
2,946,66130.06d5fdcdry3r89k   SELECT * FROM (SELECT DISTINCT...
2,946,63180.065czh73ynvhvt0   SELECT * FROM (SELECT DISTINCT...
2,931,82160.06ffvqzgdcr2fjr   SELECT * FROM (SELECT DISTINCT...
2,929,67520.064y89c2qwpug31   SELECT * FROM (SELECT DISTINCT...
2,899,587110.06bqpfpt3h5qkns   SELECT * FROM (SELECT DISTINCT...
2,212,05330.05d5fdcdry3r89k   SELECT * FROM (SELECT DISTINCT...
1,725,143140.04bapm596n71ksu   SELECT * FROM (SELECT DISTINCT...
1,699,20760.035gh60az1a4s7w   SELECT * FROM (SELECT DISTINCT...
1,600,57160.034r4scc3q60nf0   SELECT * FROM (SELECT DISTINCT...
1,509,743140.03bapm596n71ksu   SELECT * FROM (SELECT DISTINCT...
1,490,58330.03fu9854xtftcsf   SELECT * FROM (SELECT DISTINCT...
1,487,78360.035gh60az1a4s7w   SELECT * FROM (SELECT DISTINCT...
1,487,29920.03c81m7gnggu2z0   SELECT * FROM (SELECT DISTINCT...
1,486,495130.03grqqndp0ayjzd   SELECT * FROM (SELECT DISTINCT...
1,484,48990.03dt7r2av4qcz9m   SELECT * FROM (SELECT DISTINCT...
1,483,22720.03c81m7gnggu2z0   SELECT * FROM (SELECT DISTINCT...
1,478,82960.03ffvqzgdcr2fjr   SELECT * FROM (SELECT DISTINCT...
1,473,473130.038az3t0s675hqf   SELECT * FROM (SELECT DISTINCT...
1,469,51540.03b10jp3ak2bbx5   SELECT * FROM (SELECT DISTINCT...
1,469,32780.035czh73ynvhvt0   SELECT * FROM (SELECT DISTINCT...
1,468,48320.034y89c2qwpug31   SELECT * FROM (SELECT DISTINCT...
1,466,19350.03d5bk3k95fw56u   SELECT * FROM (SELECT DISTINCT...
1,459,50550.03486vwb6tb9td8   SELECT * FROM (SELECT DISTINCT...
1,459,091150.038qhvuumj0ngbb   SELECT * FROM (SELECT DISTINCT...
1,459,083150.038qhvuumj0ngbb   SELECT * FROM (SELECT DISTINCT...
1,457,211350.034gmwwb6mkz29b   SELECT * FROM (SELECT DISTINCT...
1,451,37750.03486vwb6tb9td8   SELECT * FROM (SELECT DISTINCT...
1,449,021300.032wkxwatd6t2jy   SELECT * FROM (SELECT DISTINCT...
1,211,19560.024r4scc3q60nf0   SELECT * FROM (SELECT DISTINCT...
1,151,05930.027znyd9jkyrkw5   SELECT * FROM (SELECT DISTINCT...
1,147,65380.02f864vaafk20d4   SELECT * FROM (SELECT DISTINCT...
1,130,01360.02ffvqzgdcr2fjr   SELECT * FROM (SELECT DISTINCT...
1,074,25540.02d8ccpd7xxc1r3   SELECT * FROM (SELECT DISTINCT...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
6216ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
5316sqdp7673k5x3   UPDATE wri$_adv_addm_tasks SET...
372b3zgx1xckrwxu   select host, userid, password,...
3601n9crga6mbw2x   SELECT nvl(v.first_val, 0), n...
3513118naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
3418x0funf899dka   INSERT INTO wri$_adv_addm_inst...
31105sghzkq6r6yv   select ts#, file#, block#, col...
231akh9zqqkx3wj7   select 1, max(id) from sys.wri...
2217708bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
2274,8440ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
2274,845459f3z9u4fb3u   select value$ from props$ wher...
2222,1364htx4ts19yknq   select f_ip, to_char(f_invalid...
2274,8435ur69atw3vfhj   select decode(failover_method,...
2222,12179c9nwfb1cjqq   INSERT INTO T_LOCATION_INFO(F_...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05sghzkq6r6yvselect ts#, file#, block#, cols, nvl(size$, -1), pctfree$, pctused$, initrans, maxtrans, hashkeys, func, extind, avgchn, nvl(degree, 1), nvl(instances, 1), nvl(flags, 0), nvl(spare1, 0)from clu$ where obj#=:1
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
0dvt133hht7z1SELECT * 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 ZDZT=1 AND GGUID='9252A7AF-0178-D9E1-5947-122982251' AND GGUID='9252A7AF-0178-D9E1-5947-122982251' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0q3c228dffzgtINSERT INTO SMS_ORDER (ID, LSH, YHLX, YHID, YWLX, SPBZ, CPBZ, DGJG, DGMS, LKID, DXNR, YXKSSJ, YXJSSJ, SJC, DGZT, TJSJ) VALUES(SEQ_SMS_ORDER.NEXTVAL, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B11 , :B12 , :B13 , SYSDATE)
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)
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1n9crga6mbw2x SELECT nvl(v.first_val, 0), nvl(v.last_val, 0), nvl(v.delta_val, 0), decode(v.stat_id, NULL, 0, 1), decode(osmap.required, 'N', 0, 1), osmap.statistic_hash, osmap.keh_id FROM ( SELECT b.value as first_val, e.value as last_val, (e.value - b.value) as delta_val, b.stat_id FROM WRH$_OSSTAT b , WRH$_OSSTAT e WHERE b.dbid = :dbid and e.dbid = :dbid and b.instance_number = :inst_num and e.instance_number = :inst_num and b.snap_id = :begin_snap_id and e.snap_id = :end_snap_id and b.stat_id = e.stat_id ) v, X$KEHOSMAP osmap WHERE osmap.statistic_hash = v.stat_id(+) ORDER BY osmap.keh_id ASC
2rgmdtpdz21yqBEGIN proc_locationinfo(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15); END;
2wkxwatd6t2jySELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (24810, 24814, 24808, 24809, 24813, 24807, 24812, 24811) ) START WITH JDID IN (24810, 24814, 24808, 24809, 24813, 24807, 24812, 24811) 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)
3va7bfq0j6k2aSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (17919, 26414, 26452, 23634, 23660, 25865, 25876, 26619, 25868, 25869, 25872, 25874, 25887, 25999, 25875, 25870, 25871, 25873, 17920) ) START WITH JDID IN (17919, 26414, 26452, 23634, 23660, 25865, 25876, 26619, 25868, 25869, 25872, 25874, 25887, 25999, 25875, 25870, 25871, 25873, 17920) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='16C46047-7B4F-DD3E-DA15-78CF8946063' AND GGUID='16C46047-7B4F-DD3E-DA15-78CF8946063' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
486vwb6tb9td8SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (24555, 24552, 24554, 24559, 24553, 24556, 24570, 24558, 26664) ) START WITH JDID IN (24555, 24552, 24554, 24559, 24553, 24556, 24570, 24558, 26664) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
4gmwwb6mkz29bSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR GR WHERE 1=1 OR (JDID IN (24810, 24814, 24808, 24809, 24813, 24807, 24812, 24811) ) START WITH JDID IN (24810, 24814, 24808, 24809, 24813, 24807, 24812, 24811) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='8DF7F62A-CADA-3E10-DA18-3C3BAD502E16' AND GGUID='8DF7F62A-CADA-3E10-DA18-3C3BAD502E16' 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
4r4scc3q60nf0SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (23868, 23884, 23887, 23886, 23883, 23885, 23888, 26251, 26250, 26282, 26283, 26281, 24788, 24789, 23867, 24044, 24043, 23881, 24050, 23882, 24042, 24053, 26271, 26201, 26267, 26276, 26278, 26268, 26269, 26270, 26273, 26274, 26272, 26277, 23872, 23873, 26284, 24802, 24801, 23879, 24805, 24806, 23961, 23890, 23889, 26280, 24804, 24803, 23871, 23954, 23951, 23953, 23950, 26199, 26200, 26206, 26194, 26195, 26196, 26197, 26198) ) START WITH JDID IN (23868, 23884, 23887, 23886, 23883, 23885, 23888, 26251, 26250, 26282, 26283, 26281, 24788, 24789, 23867, 24044, 24043, 23881, 24050, 23882, 24042, 24053, 26271, 26201, 26267, 26276, 26278, 26268, 26269, 26270, 26273, 26274, 26272, 26277, 23872, 23873, 26284, 24802, 24801, 23879, 24805, 24806, 23961, 23890, 23889, 26280, 24804, 24803, 23871, 23954, 23951, 23953, 23950, 26199, 26200, 26206, 26194, 26195, 26196, 26197, 26198) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
4y89c2qwpug31SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (18219, 16081, 16091, 16083, 16079, 16090, 16080, 16089, 16087, 16084, 16088, 16085, 16082, 16086, 21103) ) START WITH JDID IN (18219, 16081, 16091, 16083, 16079, 16090, 16080, 16089, 16087, 16084, 16088, 16085, 16082, 16086, 21103) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
5czh73ynvhvt0SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (20120, 12011, 12012, 12013, 12014, 20490, 20122, 12022, 12023, 12025, 12026, 12027, 22188, 22189, 22190, 11712) ) START WITH JDID IN (20120, 12011, 12012, 12013, 12014, 20490, 20122, 12022, 12023, 12025, 12026, 12027, 22188, 22189, 22190, 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
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
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6sqdp7673k5x3UPDATE wri$_adv_addm_tasks SET actual_analysis = :aa, database_time = :dbt, active_sessions = round(:dbt / (1000000 * :sint), 2), perc_flush_time = round(:ft / :sint, 2), perc_mw_time = round(:mw / :sint, 2) WHERE task_id = :tid
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)
7znyd9jkyrkw5SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR GR WHERE 1=1 OR (JDID IN (26884, 26914, 26915, 26953, 26954, 26916, 26918, 26919, 26925, 26926, 26927, 26928, 26906, 26930, 26951, 26952, 26931, 26885, 26923, 26920, 26921, 26922, 26924, 26910, 26911, 26907, 26908, 26909) ) START WITH JDID IN (26884, 26914, 26915, 26953, 26954, 26916, 26918, 26919, 26925, 26926, 26927, 26928, 26906, 26930, 26951, 26952, 26931, 26885, 26923, 26920, 26921, 26922, 26924, 26910, 26911, 26907, 26908, 26909) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='7ACFE8F9-D1B5-431C-24F1-F1C211E88843' AND GGUID='7ACFE8F9-D1B5-431C-24F1-F1C211E88843' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
8az3t0s675hqfSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (17919, 26414, 26452, 23634, 23660, 25865, 25876, 26619, 25868, 25869, 25872, 25874, 25887, 25999, 25875, 25870, 25871, 25873, 17920) ) START WITH JDID IN (17919, 26414, 26452, 23634, 23660, 25865, 25876, 26619, 25868, 25869, 25872, 25874, 25887, 25999, 25875, 25870, 25871, 25873, 17920) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
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
8x0funf899dkaINSERT INTO wri$_adv_addm_inst ( TASK_ID, INSTANCE_NUMBER, INSTANCE_NAME, HOST_NAME, STATUS, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, METER_LEVEL, LOCAL_TASK_ID) VALUES ( :tid, :inst_num, :inst_name, :host_name, :st, NULL, NULL, NULL, NULL, NULL)
a4rpas1bqxyd0INSERT INTO SMS_RECV (ID, TJSJ, ZJHM, CPID, JRH, DXNR, DXCD, CLZT, DQZT) VALUES(SEQ_SMS_RECV.NEXTVAL, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , 1, 1)
akh9zqqkx3wj7select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
aup4fgkmr583aSELECT V.GUID, V.ZHMC, V.SJHM, V.KFLX, V.XTMC, V.QC, V.JC, V.XYED, V.ZHSF, V.ZHSC, (V.ZHSC+V.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 P.GGUID, SUM(P.GNF) GNF FROM F_PRE P WHERE TO_CHAR(FSSJ, 'yyyymm')='201308' 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='201308') 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')='201308' GROUP BY PA.GGUID, PA.YWLX, PA.YWMX) PP GROUP BY GGUID) PAR ON V.GUID=PAR.GGUID WHERE GUID='DD8B2F51-DA2C-F067-64B4-C315C2CF235D'
b10jp3ak2bbx5SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (26624, 24824, 25002, 24820, 24821, 25003, 24822, 24823, 24819) ) START WITH JDID IN (26624, 24824, 25002, 24820, 24821, 25003, 24822, 24823, 24819) 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
bapm596n71ksuSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (26884, 26914, 26915, 26953, 26954, 26916, 26918, 26919, 26925, 26926, 26927, 26928, 26906, 26930, 26951, 26952, 26931, 26885, 26923, 26920, 26921, 26922, 26924, 26910, 26911, 26907, 26908, 26909) ) START WITH JDID IN (26884, 26914, 26915, 26953, 26954, 26916, 26918, 26919, 26925, 26926, 26927, 26928, 26906, 26930, 26951, 26952, 26931, 26885, 26923, 26920, 26921, 26922, 26924, 26910, 26911, 26907, 26908, 26909) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 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')
bqpfpt3h5qknsSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (19430, 19431, 26293, 22205, 26294) ) START WITH JDID IN (19430, 19431, 26293, 22205, 26294) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
c81m7gnggu2z0SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (23259, 23256, 151, 152, 129, 128, 21880, 21152, 430, 174, 20224, 118, 120, 131, 124, 122, 119, 116, 111, 112, 114) ) START WITH JDID IN (23259, 23256, 151, 152, 129, 128, 21880, 21152, 430, 174, 20224, 118, 120, 131, 124, 122, 119, 116, 111, 112, 114) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='7BF23FB9-6412-DEC1-B591-E1AD971F47F5' AND GGUID='7BF23FB9-6412-DEC1-B591-E1AD971F47F5' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d5bk3k95fw56uSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR GR WHERE 1=1 OR (JDID IN (26165, 26166, 26167, 26168, 26170, 26171, 26172, 26173, 26174, 26175, 26176, 26177, 26178, 26179) ) START WITH JDID IN (26165, 26166, 26167, 26168, 26170, 26171, 26172, 26173, 26174, 26175, 26176, 26177, 26178, 26179) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 AND GGUID='57E0A92E-E383-C236-81A9-2376268225' AND GGUID='57E0A92E-E383-C236-81A9-2376268225' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
d5fdcdry3r89kSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (21132, 11956, 21122, 21123, 21121, 21633, 21630, 21632, 21631, 21624, 21627, 21625, 21621, 21623, 21622, 21636, 21629, 21628) ) START WITH JDID IN (21132, 11956, 21122, 21123, 21121, 21633, 21630, 21632, 21631, 21624, 21627, 21625, 21621, 21623, 21622, 21636, 21629, 21628) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
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
dt7r2av4qcz9mSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (20120, 12011, 12012, 12013, 12014, 20490, 20122, 12022, 12023, 12025, 12026, 12027, 22188, 22189, 22190, 11712) ) START WITH JDID IN (20120, 12011, 12012, 12013, 12014, 20490, 20122, 12022, 12023, 12025, 12026, 12027, 22188, 22189, 22190, 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
f864vaafk20d4SELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (26884, 26914, 26915, 26953, 26954, 26916, 26918, 26919, 26925, 26926, 26927, 26928, 26906, 26930, 26951, 26952, 26931, 26885, 26923, 26920, 26921, 26922, 26924, 26910, 26911, 26907, 26908, 26909) ) START WITH JDID IN (26884, 26914, 26915, 26953, 26954, 26916, 26918, 26919, 26925, 26926, 26927, 26928, 26906, 26930, 26951, 26952, 26931, 26885, 26923, 26920, 26921, 26922, 26924, 26910, 26911, 26907, 26908, 26909) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
ffvqzgdcr2fjrSELECT * 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 ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
fu9854xtftcsfSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR WHERE 1=1 OR (JDID IN (18061, 17087, 17076, 17075, 17080, 17081, 17085, 17086, 17092, 17077, 17078, 17082, 17084, 17096, 19395, 18062, 21240, 25864, 17083, 26436, 17090, 17091, 17093, 17088, 26437, 26435) ) START WITH JDID IN (18061, 17087, 17076, 17075, 17080, 17081, 17085, 17086, 17092, 17077, 17078, 17082, 17084, 17096, 19395, 18062, 21240, 25864, 17083, 26436, 17090, 17091, 17093, 17088, 26437, 26435) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND INSTR(ZDSF, 'xcgl')>0 AND ZDZT=1 ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
grqqndp0ayjzdSELECT * FROM (SELECT DISTINCT * FROM V_US_CO_GR GR WHERE 1=1 OR (JDID IN (23259, 23256, 151, 152, 129, 128, 21880, 21152, 430, 174, 20224, 118, 120, 131, 124, 122, 119, 116, 111, 112, 114) ) START WITH JDID IN (23259, 23256, 151, 152, 129, 128, 21880, 21152, 430, 174, 20224, 118, 120, 131, 124, 122, 119, 116, 111, 112, 114) CONNECT BY PRIOR JDFID = JDID ) WHERE 1=1 AND ZDZT=1 AND GGUID='7BF23FB9-6412-DEC1-B591-E1AD971F47F5' AND GGUID='7BF23FB9-6412-DEC1-B591-E1AD971F47F5' ORDER BY FZMC ASC, ZDMC ASC, ZCSJ DESC
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 referenced90.000.00
CCursor + sql area evicted740.020.00
CPU used by this session299,96983.227.69
CPU used when call started298,33382.777.65
CR blocks created2,3400.650.06
Cached Commit SCN referenced2750.080.01
Commit SCN cached90.000.00
DB time712,384197.6518.27
DBWR checkpoint buffers written10,1292.810.26
DBWR checkpoints10.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes5990.170.02
DBWR undo block writes1,8160.500.05
HSC Heap Segment Block Changes46,49712.901.19
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1240.030.00
Heap Segment Array Updates1,2820.360.03
IMU CR rollbacks8450.230.02
IMU Flushes2,9010.800.07
IMU Redo allocation size3,452,788957.9688.56
IMU commits29,4048.160.75
IMU contention1860.050.00
IMU ktichg flush00.000.00
IMU pool not allocated230.010.00
IMU recursive-transaction flush20.000.00
IMU undo allocation size27,797,9287,712.37712.97
IMU- failed to get a private strand230.010.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Requests to/from client324,59790.068.33
RowCR - row contention6400.180.02
RowCR attempts7680.210.02
RowCR hits1280.040.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink10.000.00
SQL*Net roundtrips to/from client324,81590.128.33
SQL*Net roundtrips to/from dblink2440.070.01
TBS Extension: tasks created00.000.00
active txn count during cleanout2,2900.640.06
application wait time3,9601.100.10
auto extends on undo tablespace00.000.00
background checkpoints completed10.000.00
background checkpoints started10.000.00
background timeouts20,0075.550.51
branch node splits00.000.00
buffer is not pinned count1,104,912306.5528.34
buffer is pinned count1,170,819324.8430.03
bytes received via SQL*Net from client70,152,02119,463.261,799.28
bytes received via SQL*Net from dblink110,49830.662.83
bytes sent via SQL*Net to client160,728,04444,593.034,122.39
bytes sent via SQL*Net to dblink97,93827.172.51
calls to get snapshot scn: kcmgss667,286185.1317.11
calls to kcmgas43,45812.061.11
calls to kcmgcs477,110132.3712.24
cell physical IO interconnect bytes3,249,958,912901,681.5983,355.79
change write time3270.090.01
cleanout - number of ktugct calls1,3210.370.03
cleanouts and rollbacks - consistent read gets6420.180.02
cleanouts only - consistent read gets100.000.00
cluster key scan block gets3,2810.910.08
cluster key scans2,5860.720.07
commit batch performed70.000.00
commit batch requested70.000.00
commit batch/immediate performed760.020.00
commit batch/immediate requested760.020.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure140.000.00
commit cleanout failures: cannot pin410.010.00
commit cleanouts45,92012.741.18
commit cleanouts successfully completed45,86512.721.18
commit immediate performed690.020.00
commit immediate requested690.020.00
commit txn count during cleanout2800.080.01
concurrency wait time57,62015.991.48
consistent changes16,2194.500.42
consistent gets313,286,25186,919.398,035.25
consistent gets - examination628,046174.2516.11
consistent gets direct80.000.00
consistent gets from cache313,286,22186,919.388,035.25
consistent gets from cache (fastpath)312,537,69686,711.718,016.05
cursor authentications7970.220.02
data blocks consistent reads - undo records applied3,4100.950.09
db block changes197,90154.915.08
db block gets346,20396.058.88
db block gets direct410.010.00
db block gets from cache346,16296.048.88
db block gets from cache (fastpath)66,20118.371.70
deferred (CURRENT) block cleanout applications39,61310.991.02
dirty buffers inspected00.000.00
enqueue conversions1,1280.310.03
enqueue releases334,71292.868.58
enqueue requests334,72692.878.59
enqueue timeouts00.000.00
enqueue waits2050.060.01
exchange deadlocks90.000.00
execute count654,170181.5016.78
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time1,712,078475.0143.91
free buffer inspected37,44310.390.96
free buffer requested28,4197.880.73
global undo segment hints helped00.000.00
heap block compress1,1960.330.03
hot buffers moved to head of LRU1,6690.460.04
immediate (CR) block cleanout applications6520.180.02
immediate (CURRENT) block cleanout applications8670.240.02
in call idle wait time10,291,9112,855.43263.97
index crx upgrade (positioned)310.010.00
index crx upgrade (prefetch)10.000.00
index fast full scans (full)330.010.00
index fetch by key117,63232.643.02
index scans kdiixs12,211,435613.5556.72
leaf node 90-10 splits230.010.00
leaf node splits740.020.00
lob reads00.000.00
lob writes270.010.00
lob writes unaligned270.010.00
logical read bytes from cache2,569,275,826,176712,830,155.2165,897,453.80
logons cumulative75,13520.851.93
max cf enq hold time00.000.00
messages received41,98711.651.08
messages sent41,98711.651.08
min active SCN optimization applied on CR00.000.00
no buffer to keep pinned count00.000.00
no work - consistent read gets312,134,13186,599.748,005.70
non-idle wait count668,820185.5617.15
non-idle wait time65,42718.151.68
opened cursors cumulative776,994215.5719.93
parse count (describe)30.000.00
parse count (failures)30,1358.360.77
parse count (hard)58,03216.101.49
parse count (total)578,154160.4114.83
parse time cpu23,3516.480.60
parse time elapsed43,45912.061.11
physical read IO requests23,3516.480.60
physical read bytes1,089,683,456302,326.1327,948.48
physical read total IO requests27,2477.560.70
physical read total bytes1,183,864,320328,456.0530,364.06
physical read total multi block requests3,5850.990.09
physical reads133,01836.913.41
physical reads cache18,9605.260.49
physical reads cache prefetch2280.060.01
physical reads direct114,05831.642.93
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace114,05031.642.93
physical reads prefetch warmup00.000.00
physical write IO requests17,5254.860.45
physical write bytes1,945,698,304539,822.3149,903.78
physical write total IO requests54,67815.171.40
physical write total bytes2,066,094,592573,225.5452,991.73
physical write total multi block requests7,1901.990.18
physical writes237,51265.906.09
physical writes direct227,38363.095.83
physical writes direct (lob)200.010.00
physical writes direct temporary tablespace227,34263.075.83
physical writes from cache10,1292.810.26
physical writes non checkpoint228,95263.525.87
pinned buffers inspected00.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use3720.100.01
process last non-idle time3,5951.000.09
recovery block gets from cache00.000.00
recovery blocks read00.000.00
recursive calls7,660,2522,125.29196.47
recursive cpu usage45,15612.531.16
redo KB read29,3428.140.75
redo blocks checksummed by FG (exclusive)11,3513.150.29
redo blocks read for recovery00.000.00
redo blocks written86,76524.072.23
redo buffer allocation retries00.000.00
redo entries61,60117.091.58
redo k-bytes read for recovery00.000.00
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks4720.130.01
redo size33,765,0209,367.90866.01
redo size for direct writes337,34893.608.65
redo subscn max counts1,8900.520.05
redo synch long waits00.000.00
redo synch time3420.090.01
redo synch time (usec)6,892,3161,912.23176.78
redo synch writes32,3008.960.83
redo wastage9,294,7442,578.77238.39
redo write time5970.170.02
redo writes34,2429.500.88
rollback changes - undo records applied880.020.00
rollbacks only - consistent read gets1,7130.480.04
rows fetched via callback90,95025.232.33
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits171,78147.664.41
session logical reads313,633,58787,015.768,044.16
shared hash latch upgrades - no wait78,05621.662.00
shared hash latch upgrades - wait710.020.00
sorts (disk)40.000.00
sorts (memory)695,525192.9717.84
sorts (rows)14,927,5174,141.55382.86
sql area evicted24,4926.800.63
sql area purged100.000.00
summed dirty queue length00.000.00
switch current to new buffer6,0561.680.16
table fetch by rowid129,47135.923.32
table fetch continued row2920.080.01
table scan blocks gotten309,909,15985,982.447,948.63
table scan rows gotten10,857,902,5023,012,459.87278,486.30
table scans (direct read)00.000.00
table scans (long tables)3,0260.840.08
table scans (short tables)222,08861.625.70
temp space allocated (bytes)00.000.00
total cf enq hold time500.010.00
total number of cf enq holders640.020.00
total number of times SMON posted80.000.00
transaction rollbacks760.020.00
transaction tables consistent reads - undo records applied800.020.00
undo change vector size8,206,9322,276.96210.49
user I/O wait time9870.270.03
user calls608,909168.9415.62
user commits32,2868.960.83
user rollbacks6,7031.860.17
workarea executions - onepass80.000.00
workarea executions - optimal318,68588.428.17
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current480463
workarea memory allocated22,46422,464
logons current687704
session uga memory max22,110,358,800,49622,142,530,681,920
session pga memory102,727,399,344102,889,433,456
session pga memory max153,334,201,584153,521,649,296
session cursor cache count453,829,826454,308,958
session uga memory194,459,108,177,896194,754,914,398,304

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)11.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Direct Reads891M1.28.247202794M1.34.22029046110.00
Direct Writes0M0.000M983M1.44.27272710K0.28
Others91M1.08.02524773M0.78.02025367050.02
Buffer Cache Reads146M5.11.0405060M0.000M18.4K0.01
DBWR0M0.000M79M2.08.02191874990.02
LGWR0M0.000M42M9.52.01165268.5K0.02
TOTAL:1.1G7.47.3129561.9G15.17.546842115.8K0.04

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
Temp File891M1.28.2472021.7G2.78.4927400.000.00
Data File144M5.12.03995179M2.09.0219180.02 
Control File61M1.07.01692443M0.78.0119300.000.00
Log File29M0.01.00804542M9.52.0116520.000.00
Archive Log0M0.000M29M0.01.008045  
TOTAL:1.1G7.47.3121241.9G15.17.5462870.010.00

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)
Direct Reads 891M1.28.247202794M1.34.2202900 
Direct Reads (Data File) 891M1.28.247202794M1.34.2202900 
Direct Writes 0M0.000M983M1.44.2727270 
Direct Writes (Data File) 0M0.000M983M1.44.2727270 
Others 91M1.08.02524773M0.78.02025338980.01
Others (Control File) 61M1.06.01692444M0.77.01220738270.00
Others (Archive Log) 0M0.000M29M0.01.0080450 
Others (Log File) 29M0.01.0080450M0.000M330.00
Others (Data File) 1M0.01.0002770M0.000M380.92
Buffer Cache Reads 146M5.11.0405060M0.000M18.4K0.01
Buffer Cache Reads (Data File) 146M5.11.0405060M0.000M18.4K0.01
DBWR 0M0.000M79M2.08.0219180 
DBWR (Data File) 0M0.000M79M2.08.0219180 
LGWR 0M0.000M42M9.52.011652180.00
LGWR (Log File) 0M0.000M42M9.52.01165240.00
LGWR (Control File) 0M0.000M0M0.010M140.00
TOTAL: 1.1G7.47.3129561.9G15.17.54684222.3K0.01

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 18,82050.031.015,44524600.07
USERCENTER_TEMP 4,61110.0024.7310,004300.00
UNDOTBS1 000.000.001,225050.00
SYSAUX 3401.181.00765000.00
SYSTEM 000.000.0086010.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX/opt/oracle/oradata/jqhx/sysaux01.dbf 3401.181.00765000.00
SYSTEM/opt/oracle/oradata/jqhx/system01.dbf 00  86010.00
UNDOTBS1/opt/oracle/oradata/jqhx/undotbs01.dbf 00  1,225050.00
USERCENTER20120220_DATA/opt/oracle/oradata/jqhx/USERCENTER20120220_DATA.dbf 17,20950.031.012,73414280.07
USERCENTER20120220_DATA/opt/oracle/oradata/jqhx/USERCENTER20120220_DATA1.dbf 1,61100.061.012,4761310.00
USERCENTER20120220_DATA/opt/oracle/oradata/jqhx/USERCENTER20120220_DATA2.dbf 00  235010.00
USERCENTER_TEMP/opt/oracle/oradata/jqhx/USERCENTER_TEMP.dbf 4,61110.0024.7310,00430 

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,736100313,582,94819,03910,12900466

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000010,1280

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
B0121068121734380258060843802   
E01268057822956158060829561   

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.1239,014,4621173338.00
D5760.19711.0135,188,5791138135.00
D8640.291061.0034,896,5881135448.00
D1,1520.381421.0034,867,8031135183.00
D1,4400.481771.0034,867,4841135180.00
D1,7280.572131.0034,867,2901135178.00
D2,0160.672481.0034,867,1541135177.00
D2,3040.772841.0034,867,0811135176.00
D2,5920.863191.0034,867,0311135176.00
D2,8800.963551.0034,866,9961135176.00
D3,0081.003711.0034,866,9821135176.00
D3,1681.053901.0034,866,9681135175.00
D3,4561.154261.0034,866,9411135175.00
D3,7441.244611.0034,866,8981135175.00
D4,0321.344971.0034,866,8791135175.00
D4,3201.445321.0034,866,1221135168.00
D4,6081.535681.0034,863,7431135146.00
D4,8961.636031.0034,857,6511135090.00
D5,1841.726391.0034,823,2411134773.00
D5,4721.826741.0034,788,8321134456.00
D5,7601.917100.9834,002,1561128118.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
92.2623,8191,998

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)
B02,9941,257.540.000.000.000.00429,260
E03,0341,291.550.000.000.000.00429,260

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K312,200312,20000
64K128K79079000
128K256K39239200
256K512K909000
512K1024K3,5133,51300
1M2M1,2641,26400
2M4M565600
4M8M323200
8M16M13413400
16M32M222200
32M64M12812800
64M128M11011000
128M256M8080

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.131,808,413.061,180,167.9561.006,417273,794,308
1,0480.251,808,413.06344,359.0984.001,710197,222,949
2,0960.501,808,413.0689,672.9195.0076173,890,262
3,1440.751,808,413.0688,013.7495.0011173,738,260
4,1921.001,808,413.0687,072.8395.003173,652,059
5,0301.201,808,413.06816.67100.000165,749,833
5,8691.401,808,413.06816.67100.000165,749,833
6,7071.601,808,413.06816.67100.000165,749,833
7,5461.801,808,413.06816.67100.000165,749,833
8,3842.001,808,413.06816.67100.000165,749,833
12,5763.001,808,413.06816.67100.000165,749,833
16,7684.001,808,413.06816.67100.000165,749,833
25,1526.001,808,413.06816.67100.000165,749,833
33,5368.001,808,413.06816.67100.000165,749,833

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.5926627,3842,072,3920.383,928,5326.81783,331
3,2000.6974548,1302,957,7560.553,043,1685.28976,881
3,6800.791,22267,3193,805,1730.702,195,7513.811,153,521
4,1600.901,70287,9844,651,7770.861,349,1472.341,330,112
4,3200.931,86193,3144,933,4210.911,067,5031.851,388,973
4,3520.941,89394,3074,989,7100.921,011,2141.751,400,743
4,3840.941,92595,4265,046,0440.93954,8801.661,412,512
4,4160.951,95796,1385,102,2970.94898,6271.561,424,281
4,4480.961,98996,9625,159,0280.95841,8961.461,436,207
4,4800.972,02097,8025,215,7530.96785,1711.361,448,051
4,5120.972,05298,7235,277,7170.97723,2071.251,460,837
4,5440.982,08499,4625,320,8460.98680,0781.181,469,690
4,5760.992,116100,4095,354,1820.99646,7421.121,476,364
4,6080.992,148101,2985,387,2380.99613,6861.061,482,997
4,6401.002,180102,1735,424,3131.00576,6111.001,490,187
4,6721.012,212103,1235,425,3501.00575,5741.001,490,353
4,7041.012,244104,0625,425,4081.00575,5161.001,490,358
4,7361.022,276105,2005,425,4661.00575,4581.001,490,364
4,7681.032,308105,9605,425,5301.00575,3941.001,490,370
4,8001.032,339106,6655,425,5891.00575,3351.001,490,375
4,8321.042,371107,5285,425,6461.00575,2781.001,490,379
4,8641.052,403108,4785,425,6941.00575,2301.001,490,383
4,8961.062,434109,2415,425,7451.00575,1791.001,490,386
4,9281.062,466109,9375,425,7871.00575,1371.001,490,389
5,1201.102,658114,6105,426,0731.00574,8511.001,490,411
5,6001.213,138126,9645,426,6701.00574,2541.001,490,464
6,0801.313,618143,9435,427,2041.00573,7201.001,490,509
6,5601.414,098169,8035,427,6581.00573,2660.991,490,547
7,0401.524,578204,1255,428,1541.00572,7700.991,490,584
7,5201.625,058241,6505,428,6441.00572,2800.991,490,620
8,0001.725,538277,6055,429,2391.00571,6850.991,490,660
8,4801.836,018307,1375,429,9381.00570,9860.991,490,700
8,9601.936,498338,9665,430,6211.00570,3030.991,490,739
9,4402.036,977367,2695,431,2841.00569,6400.991,490,775

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.505,957,80435,187,758,729
4,8800.633,733,38139,012,666,708
5,8560.753,485,37134,894,876,076
6,8320.883,484,32634,866,982,490
7,8081.003,483,28134,866,982,490
8,7841.133,482,23634,866,982,490
9,7601.253,480,84334,866,982,490
10,7361.383,477,70834,002,281,324
11,7121.503,476,66334,002,281,324
12,6881.633,475,61834,002,281,324
13,6641.753,474,57334,002,281,324
14,6401.883,473,17934,002,281,324
15,6162.003,472,48334,002,281,324

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 block43200
segment header1900
1st level bmb900
undo header500
2nd level bmb100

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 999909931313.74
TX-Transaction (index contention) 454504302.79
SQ-Sequence Cache 1,5531,55304800.63
TX-Transaction 34,48934,49001101.82
FB-Format Block 424201010.00
HW-Segment High Water Mark 4,2574,2570300.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
21.2135,0361,3763116.5/380/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
30-8月 10:591122,3231,37610380/00/0/0/0/0/0
30-8月 10:491733,0161,29131370/00/0/0/0/0/0
30-8月 10:392204,1096894270/00/0/0/0/0/0
30-8月 10:291527,061874160/00/0/0/0/0/0
30-8月 10:191928,6296894270/00/0/0/0/0/0
30-8月 10:093579,898879160/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 latch210.00 00 
AQ dequeue txn counter latch40.00 00 
AQ disk delete txn counter latch40.00 00 
ASM db client latch2,4090.00 00 
ASM map operation hash table10.00 00 
ASM network state latch630.00 00 
AWR Alerted Metric Element list54,8800.00 00 
Change Notification Hash table latch1,2010.00 00 
Consistent RBA34,2460.00 00 
DML lock allocation107,8310.010.0000 
Event Group Locks150,2250.020.0000 
FAL Queue980.00 00 
FIB s.o chain latch60.00 00 
FOB s.o list latch1,3520.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch174,1920.010.96047,3920.05
JS Sh mem access70.00 00 
JS mem alloc latch50.00 00 
JS queue access latch60.00 00 
JS queue state obj latch26,1340.00 00 
JS slv state obj latch2371.270.0000 
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,2010.00 00 
KTF sga latch190.00 01,1680.00
KWQMN job cache list latch110.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch40.00 00 
KWQS pqueue ctx latch780.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch10.00 01,2010.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 Latch400.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process300,9290.00 00 
OS process allocation157,8540.050.0000 
OS process: request allocation150,1320.050.0000 
PL/SQL warning settings97,5470.010.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch22,2060.00 00 
Reserved Space Latch40.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1210.00 01,2000.00
SQL memory manager workarea list latch249,0320.00 00 
Shared B-Tree3480.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$KSFQP9090.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch11,1160.140.0000 
active service list458,2060.080.0402,6770.04
alert log latch20.00 00 
archive control630.00 00 
archive process latch2950.00 00 
begin backup scn array220.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles5740.00 00 
cache buffers chains627,378,3120.330.0001,386,4680.00
cache buffers lru chain22,4880.010.000216,430,2230.03
cache table scan latch2280.00 02280.00
call allocation226,1070.530.6330 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch150,1490.030.0000 
channel operations parent latch242,4340.010.0000 
checkpoint queue latch756,4000.00 09,5980.00
client/application info450,3470.000.0000 
compile environment latch75,1470.030.0000 
corrupted undo seg latch3330.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch630.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch630.00 00 
dml lock allocation630.00 00 
done queue latch10.00 00 
dummy allocation150,2691.040.0100 
enqueue freelist latch10.00 0339,4260.00
enqueue hash chains670,8010.060.010140.00
enqueues30.00 00 
fifth spare latch10.00 00 
file cache latch2350.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 SGA74,9410.00 00 
global tx hash mapping1,1400.00 00 
granule operation10.00 00 
hash table column usage latch3480.00 05,566,2530.01
hash table modification latch980.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch690.00 0690.00
job_queue_processes free list latch1400.00 00 
job_queue_processes parameter latch8510.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch3920.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock410.00 00 
ksuosstats global area3630.00 00 
ksv allocation latch1430.00 00 
ksv class latch810.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch150,1320.050.0400 
ktm global data600.00 00 
kwqbsn:qsga1300.00 00 
lgwr LWN SCN34,3540.00 00 
list of block allocation46,5600.010.0000 
loader state object freelist540.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 parent990.00 040.00
managed standby latch970.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch250.00 00 
messages233,7970.020.0000 
mostly latch-free SCN34,6380.140.0000 
msg queue latch10.00 00 
multiblock read objects36,7780.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch630.00 00 
object queue header heap89,0480.00 01410.00
object queue header operation173,2740.000.0000 
object stats modification30.00 00 
parallel query alloc buffer7210.00 00 
parallel query stats10.00 00 
parameter list1,1620.00 00 
parameter table management301,9920.080.1500 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue44,7150.110.00030,5590.02
process allocation150,2704.001.045174,9600.16
process group creation150,1320.030.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5210.00 00 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation198,7730.010.00061,5240.11
redo copy10.00 061,5500.21
redo writing116,4420.010.0000 
reservation so alloc latch20.00 00 
resmgr group change latch75,0750.000.0000 
resmgr:active threads150,2690.00 00 
resmgr:actses change group75,0300.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list150,2681.220.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 objects26,759,7850.210.0001070.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache317,6770.690.0000 
session allocation452,8850.020.000302,6820.01
session idle bit1,445,4590.000.0000 
session queue latch10.00 00 
session state list latch150,1981.670.0000 
session switching75,1170.020.0000 
session timer1,2080.00 00 
shared pool6,942,7511.030.0740 
shared pool sim alloc10.00 00 
shared pool simulator97,5580.050.1600 
sim partition latch10.00 00 
simulator hash latch59,357,8970.000.0000 
simulator lru latch4,9970.060.00033,184,1720.63
sort extent pool1,0700.00 00 
space background state object latch100.00 00 
space background task latch5,2331.180.0002,4070.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 latch1740.00 00 
transaction allocation61,3330.000.0000 
transaction branch allocation2,2170.140.0000 
undo global data180,3200.000.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains627,378,3122,099,331552,099,284
shared pool6,942,75171,3844,78267,136
row cache objects26,759,78555,15021354,943
process allocation150,2706,0126,282263
session state list latch150,1982,50152,496
resmgr:free threads list150,2681,83051,825
dummy allocation150,2691,55791,548
call allocation226,1071,209762489
enqueue hash chains670,8014313428
active service list458,20638816372
parameter table management301,99225537219
ksz_so allocation latch150,13280377
shared pool simulator97,55844737
In memory undo latch174,19224232

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child01920
In memory undo latchkticmt: child040
In memory undo latchktichg: child014
active service listkswslogon: session logout02716
active service listkswsite: service iterator010
cache buffers chainskcbgtcr: fast path (cr pin)01610
cache buffers chainskcbchg1: mod cr pin0145
cache buffers chainskcbgcur: fast path (shr)0103
cache buffers chainskcbgtcr: fast path061
cache buffers chainskcbzwb063
cache buffers chainskcbrls_20513
cache buffers chainskcbgtcr_2045
cache buffers chainskcbgcur_2034
cache buffers chainskcbrls: fast release015
call allocationksuxds0612399
call allocationksudlp: top call0146185
call allocationksucrp: top call03175
call allocationksuprc011
dummy allocationktcscnfy099
enqueue hash chainsksqrcl021
enqueue hash chainsksqgtl3011
ksz_so allocation latchksz_parent_so_del1033
parameter table managementksp_param_table_free0442
parameter table managementkspcpy041
process allocationksucrp:104,0390
process allocationksudlp01,7672,268
process allocationksuapc04754,013
resmgr:free threads listkskthrcreate055
row cache objectskqreqd: reget01219
row cache objectskqrpre: find obj05998
row cache objectskqreqd033106
session state list latchkpseqa034
session state list latchkpseqd021
shared poolkghalo04,4064,055
shared poolkghalp0143131
shared poolkghupr10142373
shared poolkghfre066209
shared poolkgh_heap_sizes01610
shared poolkghasp094
shared pool simulatorkglsim_upd_newhp077

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglget1 143,2040
Library Cachekglhdgn2 10641,8030
Library Cachekgllkdl1 8532,1610
Library Cachekglpndl1 953,4970
Library Cachekglpin1 42,9130
Library Cachekglhdgn1 621,8900
Library Cachekgldtin1 421,7530
Library Cachekglhdgh1 641,0410
Library Cachekglpnal1 909500
Cursor Pinkkslce [KKSCHLPIN2]4450
Library Cachekgllkc1 573600
Library Cachekglget2 2200
Cursor Pinkksfbc [KKSCHLFSP2]200
Library Cachekglobpn1 71160
Library Cachekglrfcl1 79110
Cursor Pinkksfbc [KKSCHLPIN1]100
Library CachekglGetHandleReference 12460
Cursor PinkksLockDelete [KKSCHLPIN6]50
Library Cachekglhdgc1 10210
Library Cachekglini1 3210

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 TABLE231,294,20873.75
USERCENTERUSERCENTER20120220_DATASMS_SEND_ENT TABLE32,732,14410.44
USERCENTERUSERCENTER20120220_DATASMS_MASS TABLE23,635,3287.54
USERCENTERUSERCENTER20120220_DATASMS_SEND_AH TABLE11,015,8563.51
SYSSYSTEMI_SYSAUTH1 INDEX3,612,9121.15

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE18,66614.03
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1450.11
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX890.07
USERCENTERUSERCENTER20120220_DATASMS_SEND TABLE450.03
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE340.03

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE18,42878.92
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1450.62
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX890.38
USERCENTERUSERCENTER20120220_DATASMS_SEND TABLE450.19
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE340.15

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE18,42878.92
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1450.62
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX890.38
USERCENTERUSERCENTER20120220_DATASMS_SEND TABLE450.19
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE340.15

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE2,1400.90
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1,1680.49
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX1,0420.44
USERCENTERUSERCENTER20120220_DATASMS_SEND TABLE3420.14
USERCENTERUSERCENTER20120220_DATAT_USER TABLE3230.14

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE1,4528.29
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX1,0936.24
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX9895.64
USERCENTERUSERCENTER20120220_DATASMS_SEND TABLE3041.73
USERCENTERUSERCENTER20120220_DATAT_USER TABLE2961.69

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_4085TABLE PARTITION210.01
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB200.01

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE3,02898.99

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
USERCENTERUSERCENTER20120220_DATAT_LOCATION_INFO TABLE27,47239.35
SYSSYSTEMSEQ$ TABLE19,87228.47
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX4,6726.69
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX4,3526.23
USERCENTERUSERCENTER20120220_DATASMS_SEND_ENT TABLE2,8004.01

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
USERCENTERUSERCENTER20120220_DATAT_FEE TABLE9867.12
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX4430.14
SYSSYSAUXWRH$_SERVICE_STAT_PKWRH$_SERVIC_2877231475_4085INDEX PARTITION21.37
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX10.68
USERCENTERUSERCENTER20120220_DATASMS_RECV TABLE10.68

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX2100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_FFHM_TJSJ INDEX10173.19
USERCENTERUSERCENTER20120220_DATASMS_SEND_XW TABLE2719.57
USERCENTERUSERCENTER20120220_DATAF_PAR TABLE21.45
USERCENTERUSERCENTER20120220_DATASMS_SEND TABLE21.45
USERCENTERUSERCENTER20120220_DATAPRI_SMS_SEND_JSHM_TJSJ INDEX10.72

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control650.000 21
dc_files100.000 010
dc_global_oids4200.000 052
dc_histogram_data487,3570.000 02,790
dc_histogram_defs332,7430.010 03,271
dc_object_grants1310.000 013
dc_objects262,9730.010 52,212
dc_profiles75,0090.000 01
dc_rollback_segments31,3500.000 0704
dc_segments161,7270.010 131,110
dc_sequences1,5050.400 1,50529
dc_tablespaces2,275,4740.000 011
dc_users6,740,2940.000 0129
global database name77,4240.000 01
outstanding_alerts420.000 07
sch_lj_oids50.000 016


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS149,8790.000 00
BODY1,9620.152,5900.2730
CLUSTER812.50812.5000
DBLINK150,1240.000 00
EDITION75,0240.00150,0330.0000
INDEX650.00650.0000
QUEUE770.002350.0000
SCHEMA75,0340.000 00
SQL AREA561,9154.711,332,3558.4631,51112
SQL AREA BUILD58,07147.840 00
SQL AREA STATS27,71799.2927,71699.2900
SUBSCRIPTION80.0080.0000
TABLE/PROCEDURE140,1700.01410,5380.082870
TRIGGER1,9220.004,7340.1570


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
BOther997.57 1.442.2727339691691
Freeable256.380.001.040.689 247247
PL/SQL7.475.470.010.0201689689
SQL5.002.240.010.0103,097671450
EOther1,012.58 1.432.2527339706706
Freeable267.560.001.030.669 261261
PL/SQL7.275.280.010.0201704704
SQL4.742.150.010.0103,097686443

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
sharedKGLH0485.50514.435.96
sharedKGLHD79.3185.377.63
sharedSQLA2,028.812,029.580.04
shareddbktb: trace buffer46.8846.880.00
sharedevent statistics per sess56.6256.620.00
sharedfree memory1,247.661,209.07-3.09
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 Slaves0803 10:21:230.040.000.00
QMON Coordinator0803 10:21:130.000.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

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

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 0020.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,6040.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,6040.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