WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
JKDB1477930046jkdb121-9月 -13 13:0911.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
DBSERVER1Microsoft Windows x86 64-bit 32 32 4 127.93

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:885124-9月 -13 09:00:18150 6.2
End Snap:885224-9月 -13 10:00:32153 6.4
Elapsed:  60.23 (mins)  
DB Time:  553.89 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,624M 18,624MStd Block Size: 8K
Shared Pool Size: 2,816M 2,816MLog Buffer: 27,696K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 9.2 0.1 0.03 0.03
DB CPU(s): 1.5 0.0 0.00 0.00
Redo size: 191,849.7 1,854.6  
Logical reads: 64,709.2 625.5  
Block changes: 1,151.6 11.1  
Physical reads: 640.1 6.2  
Physical writes: 168.7 1.6  
User calls: 334.2 3.2  
Parses: 126.0 1.2  
Hard parses: 44.8 0.4  
W/A MB processed: 1.0 0.0  
Logons: 0.3 0.0  
Executes: 304.4 2.9  
Rollbacks: 0.0 0.0  
Transactions: 103.5   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 99.77In-memory Sort %: 100.00
Library Hit %: 82.89Soft Parse %: 64.41
Execute to Parse %: 58.61Latch Hit %: 99.89
Parse CPU to Parse Elapsd %: 29.18% Non-Parse CPU: 34.92

Shared Pool Statistics

BeginEnd
Memory Usage %: 62.90 62.25
% SQL with executions>1: 57.46 61.60
% Memory for SQL w/exec>1: 69.00 70.95

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
row cache lock1,57921,9731391666.12Concurrency
DB CPU 5,424 16.32 
db file sequential read502,6843,20369.64User I/O
log file sync376,9551,64744.96Commit
cursor: mutex S5,823,8721,11703.36Concurrency

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

Load Average BeginLoad Average End%User%System%WIO%Idle
   4.9 0.4  94.7
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
4.8 90.8 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 131,004.6 131,004.6
SGA use (MB): 22,144.0 22,144.0
PGA use (MB): 401.2 413.5
% Host Mem used for SGA+PGA: 17.21 17.22

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
connection management call elapsed time14,232.5142.83
parse time elapsed12,234.8136.81
sql execute elapsed time10,241.5630.82
hard parse elapsed time8,785.3426.44
DB CPU5,424.3116.32
failed parse elapsed time545.401.64
inbound PL/SQL rpc elapsed time169.780.51
PL/SQL execution elapsed time160.250.48
hard parse (sharing criteria) elapsed time9.040.03
PL/SQL compilation elapsed time1.240.00
hard parse (bind mismatch) elapsed time0.390.00
repeated bind elapsed time0.190.00
sequence load elapsed time0.050.00
DB time33,233.55 
background elapsed time2,535.25 
background cpu time151.99 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME19,068 
AVG_IDLE_TIME342,111 
AVG_SYS_TIME1,363 
AVG_USER_TIME17,595 
BUSY_TIME614,101 
IDLE_TIME10,951,309 
SYS_TIME47,333 
USER_TIME566,871 
VM_IN_BYTES-2,609,959,125,677,481,984 
VM_OUT_BYTES2,374,945,116,508,160 
PHYSICAL_MEMORY_BYTES137,368,281,088 
NUM_CPUS32 
NUM_CPU_CORES32 
NUM_CPU_SOCKETS4 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
24-9月 09:00:180.00     
24-9月 10:00:320.005.314.900.4194.690.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Concurrency5,845,56410023,620471.07
DB CPU  5,424 16.32
User I/O530,45103,25869.80
Commit376,95501,64744.96
Network883,5080200.01
Other3,74797210.01
Application4,0270100.00
System I/O4460010.00
Configuration140090.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
row cache lock1,5795321,973139160.0066.12
db file sequential read502,68403,20361.349.64
log file sync376,95501,64741.014.96
cursor: mutex S5,823,8721001,117015.583.36
library cache lock10,4900427410.031.28
cursor: pin S wait on X1109889200.000.30
direct path read9,07303640.020.11
read by other session16,71501610.040.05
buffer busy waits4,5950410.010.01
kksfbc child completion311002550.000.01
db file scattered read2430270.000.00
db file parallel read6702230.000.00
SQL*Net message to client856,7730102.290.00
latch: row cache objects2,0840100.010.00
SQL*Net more data to client26,0820100.070.00
Disk file operations I/O1,6680100.000.00
SQL*Net break/reset to client3,2320100.010.00
control file sequential read4460010.000.00
enq: TX - row lock contention7930000.000.00
SQL*Net message from dblink2870010.000.00
latch: shared pool5560000.000.00
log file switch (private strand flush incomplete)200570.000.00
ADR block file read360030.000.00
library cache: mutex X3710000.000.00
latch: In memory undo latch7490000.000.00
latch free640010.000.00
enq: KO - fast object checkpoint200160.000.00
ADR block file write50060.000.00
latch: cache buffers chains1,2310000.000.00
SQL*Net more data from client810000.000.00
enq: HW - contention120010.000.00
asynch descriptor resize3,598100000.010.00
enq: TX - index contention210000.000.00
SQL*Net message from client856,7680391,3714572.29 
jobq slave wait8,631994,4255130.02 
Streams AQ: waiting for messages in the queue729993,61349560.00 
wait for unread message on broadcast channel3,623983,6139970.01 
single-task message200180.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 parallel write560,41701,37021.5054.04
log file parallel write352,244098530.9438.86
control file parallel write1,7670950.000.35
control file sequential read4,6370720.010.29
db file sequential read2880260.000.06
os thread startup13702120.000.06
LGWR wait for redo copy1,3930000.000.00
Disk file operations I/O1250010.000.00
direct path write60070.000.00
ADR block file read130020.000.00
ADR block file write50050.000.00
direct path read100250.000.00
log file sequential read40040.000.00
latch free250000.000.00
reliable message40010.000.00
latch: messages290000.000.00
db file scattered read20010.000.00
log file single write40010.000.00
rdbms ipc reply40000.000.00
log file sync20010.000.00
SQL*Net message to client2,2500000.010.00
asynch descriptor resize952100000.000.00
latch: redo writing140000.000.00
rdbms ipc message357,561551,6601440.96 
Streams AQ: waiting for time management or cleanup tasks215220,4399732840.00 
DIAG idle wait7,1281007,22310130.02 
Streams AQ: qmn coordinator idle wait258503,614140080.00 
Streams AQ: qmn slave idle wait13203,614273800.00 
pmon timer1,483813,61324360.00 
Space Manager: slave idle wait7211003,60750020.00 
shared server idle wait1201003,602300140.00 
dispatcher timer601003,601600120.00 
smon timer12833,4552879190.00 
SQL*Net message from client3,0330410.01 
class slave wait150000.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 read4957.14.18.222.46.12.0  
ADR block file write10  10.090.0    
ADR file lock12100.0       
Disk file operations I/O179396.8.7.61.2.4.1.2 
LGWR wait for redo copy1387100.0       
SQL*Net break/reset to client325499.9.1.0 .0   
SQL*Net message from dblink34992.63.7.6 3.2   
SQL*Net message to client858.9K100.0       
SQL*Net message to dblink346100.0       
SQL*Net more data from client8296.32.4 1.2    
SQL*Net more data to client26.1K100.0  .0    
asynch descriptor resize4554100.0       
buffer busy waits459761.833.15.0.1    
buffer deadlock2100.0       
control file parallel write176854.23.83.66.330.41.6.1 
control file sequential read508487.71.51.62.56.7.1  
cursor: mutex S5822.4K97.72.0.3.0.0.0.0 
cursor: pin S3100.0       
cursor: pin S wait on X11   9.163.6 9.118.2
db file parallel read67   1.520.965.711.9 
db file parallel write560.3K47.514.319.813.04.7.6.0 
db file scattered read24512.26.55.352.718.44.5.4 
db file sequential read503.1K13.51.822.046.811.82.91.2 
direct path read907414.87.760.011.84.31.0.4 
direct path write666.7    33.3  
direct path write temp1100.0       
enq: HW - contention1250.050.0      
enq: KO - fast object checkpoint2    50.050.0  
enq: TX - index contention21100.0       
enq: TX - row lock contention79387.611.9.5     
kksfbc child completion31      100.0 
latch free8878.418.23.4     
latch: In memory undo latch749100.0       
latch: cache buffers chains1231100.0       
latch: cache buffers lru chain3100.0       
latch: checkpoint queue latch1100.0       
latch: enqueue hash chains3100.0       
latch: messages29100.0       
latch: redo allocation3100.0       
latch: redo writing14100.0       
latch: row cache objects208489.16.53.01.3.0.1  
latch: shared pool55686.213.1.4.2 .2  
library cache load lock2100.0       
library cache lock10.5K13.35.16.49.313.016.036.9 
library cache: mutex X37198.7 .3 .8.3  
log file parallel write352K72.52.43.66.713.41.4.0 
log file sequential read450.0  50.0    
log file single write4100.0       
log file switch (private strand flush incomplete)2      100.0 
log file sync376.7K57.46.24.59.617.64.5.2 
os thread startup137   19.779.6 .7 
rdbms ipc reply4100.0       
read by other session16.7K89.21.62.94.11.8.3.2 
reliable message666.733.3      
row cache lock1579.1 .4.4.63.82.292.7
DIAG idle wait7120      100.0 
SQL*Net message from client859.7K63.77.76.39.64.31.25.12.2
Space Manager: slave idle wait721       100.0
Streams AQ: qmn coordinator idle wait25650.0      50.0
Streams AQ: qmn slave idle wait1312.3      97.7
Streams AQ: waiting for messages in the queue729.1   .3.1.499.0
Streams AQ: waiting for time management or cleanup tasks2123.8     28.647.6
class slave wait15100.0       
dispatcher timer60       100.0
jobq slave wait8625    .0 100.0 
pmon timer148419.1      80.9
rdbms ipc message357.3K23.18.213.428.914.64.73.33.9
shared server idle wait121       100.0
single-task message3    33.366.7  
smon timer12       100.0
wait for unread message on broadcast channel3624   .2.6.698.7 

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/O399.8.2      
control file parallel write199.9.1      
cursor: mutex S10100.0.0.0.0    
cursor: pin S wait on X172.7   9.1  18.2
db file parallel read888.110.41.5     
db file parallel write65100.0.0.0.0    
db file scattered read199.6 .4     
db file sequential read593598.8.6.4.2.0.0  
direct path read3599.6.2.1.1 .0  
kksfbc child completion31 100.0      
library cache lock387463.116.113.95.71.2.0  
log file parallel write126100.0.0.0.0    
log file switch (private strand flush incomplete)2 100.0      
log file sync83999.8.2.0.0    
os thread startup199.3.7      
read by other session3099.8.1.0.0.0   
row cache lock415.21.3.1 .3.4.492.2

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
cursor: pin S wait on X281.8 9.1   9.1 
row cache lock14537.81.360.22.125.01.12.4.2

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

  % of Total Waits
EventWaits 4m to 1h <2m <4m <8m<1/4h<1/2h< 1h>=1h
row cache lock399.8.2     

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
JKDB32,3915,289523231,821
SYS$USERS8391361,7901,956
JKDBXDB0000
SYS$BACKGROUND00061

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
JKDB 5208003220569862423235008811872
SYS$USERS 9642381469403850023130
SYS$BACKGROUND 415213820000

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
3,240.0339,4530.089.750.240.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
2,781.52  8.3786.87 4vs91dcv7u1p6   insert into sys.aud$( sessioni...
928.13115,0010.012.793.7896.66b7za0szn758fx TablesMover.exe DELETE FROM "CAPTURELIST" WHER...
745.802,5840.292.2499.580.002xpqurujh3b0r InterCMSServer.exe begin Proc_InsertDevStatus(Dev...
745.142,5840.292.2499.590.007540avtkcgmx9 InterCMSServer.exe UPDATE CURDEVICESTATUS SET STA...
633.2884,2960.011.916.9092.11a3s6pu4n0ttcm GPS.exe begin Proc_InsertGPSData(Vehic...
620.0784,2970.011.875.2494.07dyn8c65fxx7g6 GPS.exe UPDATE CURGPSDATA SET VEHICLEN...
603.3784,2960.011.823.1196.677cd89mtu3ytgw GPS.exe INSERT INTO HISGPSDATA (VEHICL...
307.404650.660.9221.5440.00fdy888x3xs0dq w3wp.exe begin prc_query(p_tableName=>:...
254.322,5840.100.7799.130.00c12apabd94unq InterCMSServer.exe SELECT COUNT(*) FROM DEVICESTA...

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
2,416.32  44.552,781.5286.87 4vs91dcv7u1p6   insert into sys.aud$( sessioni...
742.642,5840.2913.69745.8099.580.002xpqurujh3b0r InterCMSServer.exe begin Proc_InsertDevStatus(Dev...
742.102,5840.2913.68745.1499.590.007540avtkcgmx9 InterCMSServer.exe UPDATE CURDEVICESTATUS SET STA...
252.102,5840.104.65254.3299.130.00c12apabd94unq InterCMSServer.exe SELECT COUNT(*) FROM DEVICESTA...
243.492,5620.104.49243.8199.870.00gh6w1qbq7x4nx InterCMSServer.exe UPDATE DEVICESTATUS A SET ENDT...
242.662,5840.094.47242.9199.900.00arqy5fh5swxja InterCMSServer.exe SELECT A.STATUSNO, A.ENDTIME F...
126.8823,2040.012.34133.5994.980.00g0kdm9gds168g DataCollector_ZYJ_Oracle.exe begin PT_HDPHOTO(t_DeviceID=>:...
66.224650.141.22307.4021.5440.00fdy888x3xs0dq w3wp.exe begin prc_query(p_tableName=>:...
63.7623,2040.001.1863.61100.230.0064jtwyfuxpkr3 DataCollector_ZYJ_Oracle.exe SELECT COUNT(1) FROM HDPHOTOS ...
56.3823,2040.001.0462.6090.070.002y018xjrv9360 DataCollector_ZYJ_Oracle.exe UPDATE HDPHOTOS SET LASTUPDATE...

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
897.12115,0010.0127.52928.133.7896.66b7za0szn758fx TablesMover.exe DELETE FROM "CAPTURELIST" WHER...
583.3184,2970.0117.89620.075.2494.07dyn8c65fxx7g6 GPS.exe UPDATE CURGPSDATA SET VEHICLEN...
583.3184,2960.0117.89603.373.1196.677cd89mtu3ytgw GPS.exe INSERT INTO HISGPSDATA (VEHICL...
583.3184,2960.0117.89633.286.9092.11a3s6pu4n0ttcm GPS.exe begin Proc_InsertGPSData(Vehic...
122.954650.263.77307.4021.5440.00fdy888x3xs0dq w3wp.exe begin prc_query(p_tableName=>:...
66.62233.312.0473.7410.4590.356x1yqcvu5jc5s w3wp.exe SELECT TO_NUMBER(COUNT(*)) FRO...
0.227410.000.0136.741.020.617ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0.1610.160.014.1296.103.964uphfayydzm8b TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
0.1410.140.004.1096.303.4038r77vn8nj8v8 TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
0.1260.020.000.3052.5541.542nszajb0qbyvp   DECLARE job BINARY_INTEGER := ...

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
66,561,5232,58425,759.1028.46745.8099.580.002xpqurujh3b0r InterCMSServer.exe begin Proc_InsertDevStatus(Dev...
66,553,7712,58425,756.1028.46745.1499.590.007540avtkcgmx9 InterCMSServer.exe UPDATE CURDEVICESTATUS SET STA...
22,175,8882,5848,582.009.48242.9199.900.00arqy5fh5swxja InterCMSServer.exe SELECT A.STATUSNO, A.ENDTIME F...
22,175,8882,5848,582.009.48254.3299.130.00c12apabd94unq InterCMSServer.exe SELECT COUNT(*) FROM DEVICESTA...
21,989,6462,5628,583.009.40243.8199.870.00gh6w1qbq7x4nx InterCMSServer.exe UPDATE DEVICESTATUS A SET ENDT...
17,462,60023,204752.577.47133.5994.980.00g0kdm9gds168g DataCollector_ZYJ_Oracle.exe begin PT_HDPHOTO(t_DeviceID=>:...
8,760,69323,204377.553.7562.6090.070.002y018xjrv9360 DataCollector_ZYJ_Oracle.exe UPDATE HDPHOTOS SET LASTUPDATE...
8,667,11323,204373.523.7163.61100.230.0064jtwyfuxpkr3 DataCollector_ZYJ_Oracle.exe SELECT COUNT(1) FROM HDPHOTOS ...
2,172,2475440,226.800.9329.1579.310.000b15085bqkbkc ORACLE.EXE SELECT "A2"."DEVICEID", "A2"."...
2,172,0195440,222.570.9332.6981.420.00bfk31x8d42g67 ORACLE.EXE SELECT DISTINCT "A1"."DEVICEID...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
133,088115,0011.165.75928.133.7896.66b7za0szn758fx TablesMover.exe DELETE FROM "CAPTURELIST" WHER...
77,78084,2970.923.36620.075.2494.07dyn8c65fxx7g6 GPS.exe UPDATE CURGPSDATA SET VEHICLEN...
77,77984,2960.923.36603.373.1196.677cd89mtu3ytgw GPS.exe INSERT INTO HISGPSDATA (VEHICL...
77,77984,2960.923.36633.286.9092.11a3s6pu4n0ttcm GPS.exe begin Proc_InsertGPSData(Vehic...
66,488465142.982.87307.4021.5440.00fdy888x3xs0dq w3wp.exe begin prc_query(p_tableName=>:...
49,303224,651.502.1373.7410.4590.356x1yqcvu5jc5s w3wp.exe SELECT TO_NUMBER(COUNT(*)) FRO...
29129.000.004.1296.103.964uphfayydzm8b TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
27127.000.004.0497.961.890zv836yqahwkw TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
23123.000.004.1096.303.4038r77vn8nj8v8 TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
23123.000.004.0597.422.88b0x81hnmwjn5x TablesMover.exe Select CAPTURELIST.*, CAPTUREL...

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
133,088133,088115,0011.160.0025.63b7za0szn758fx TablesMover.exe DELETE FROM "CAPTURELIST" WHER...
77,78077,78084,2970.920.0014.98dyn8c65fxx7g6 GPS.exe UPDATE CURGPSDATA SET VEHICLEN...
77,77977,77984,2960.920.0014.987cd89mtu3ytgw GPS.exe INSERT INTO HISGPSDATA (VEHICL...
48,28948,289224,144.500.009.306x1yqcvu5jc5s w3wp.exe SELECT TO_NUMBER(COUNT(*)) FRO...
2929129.000.000.014uphfayydzm8b TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
2727127.000.000.010zv836yqahwkw TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
2323123.000.000.0038r77vn8nj8v8 TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
2323123.000.000.00b0x81hnmwjn5x TablesMover.exe Select CAPTURELIST.*, CAPTUREL...
664650.010.000.00fdy888x3xs0dq w3wp.exe begin prc_query(p_tableName=>:...
331,5910.000.000.00fnkxtujrrunb8 TablesCopier.exe Insert into CAPTURELIST(ListNo...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
134,994134,7501.0013.1798.700.112q76h51xvr4xw TablesCopier.exe UPDATE CALCVEHFLOW SET ALLVEHS...
134,98500.0012.5694.670.01c3szhz60a32mw TablesCopier.exe UPDATE VEHPLATEBLACKMAIN SET L...
115,001115,0011.00928.133.7896.66b7za0szn758fx TablesMover.exe DELETE FROM "CAPTURELIST" WHER...
84,29784,2971.00620.075.2494.07dyn8c65fxx7g6 GPS.exe UPDATE CURGPSDATA SET VEHICLEN...
84,29684,2961.00603.373.1196.677cd89mtu3ytgw GPS.exe INSERT INTO HISGPSDATA (VEHICL...
84,29684,2961.00633.286.9092.11a3s6pu4n0ttcm GPS.exe begin Proc_InsertGPSData(Vehic...
39,45355,7971.413,240.030.240.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
23,20623,2061.001.9092.620.00aadqr5sqm5pu0 DataCollector_ZYJ_Oracle.exe select count(*) from road
23,20427,7361.2062.6090.070.002y018xjrv9360 DataCollector_ZYJ_Oracle.exe UPDATE HDPHOTOS SET LASTUPDATE...
23,20423,1811.0063.61100.230.0064jtwyfuxpkr3 DataCollector_ZYJ_Oracle.exe SELECT COUNT(1) FROM HDPHOTOS ...
23,20423,2041.00133.5994.980.00g0kdm9gds168g DataCollector_ZYJ_Oracle.exe begin PT_HDPHOTO(t_DeviceID=>:...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
84,29784,29618.51a3s6pu4n0ttcm GPS.exe begin Proc_InsertGPSData(Vehic...
39,46039,4538.67cm5vu20fhtnq1   select /*+ connect_by_filterin...
23,20623,2065.10aadqr5sqm5pu0 DataCollector_ZYJ_Oracle.exe select count(*) from road
23,20423,2045.10g0kdm9gds168g DataCollector_ZYJ_Oracle.exe begin PT_HDPHOTO(t_DeviceID=>:...
8,1848,1841.801wr2png6s6xa3   SELECT /* OPT_DYN_SAMP */ /*+ ...
5,3855,3851.183d1djwagx2831 w3wp.exe SELECT PLATFORMID, PLATFORMNAM...
4,0054,0050.88dva2s149vds50 w3wp.exe SELECT ID, DEPARTMENTID, EMPLC...
3,6943,6940.81g3hxajqptdbsc w3wp.exe SELECT ID, PID, COMPANYID, DEP...
2,7802,7800.61cjaa80k1hvpc1   select 1 from sys.cdc_change_t...
2,5842,5840.572xpqurujh3b0r InterCMSServer.exe begin Proc_InsertDevStatus(Dev...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
51,593,560 1.75f711myt0q6cma   insert into sys.aud$( sessioni...
30,834,912 1.044vs91dcv7u1p6   insert into sys.aud$( sessioni...
4,756,3891390.1618naypzfmabd6   INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
1,219 f711myt0q6cma   insert into sys.aud$( sessioni...
1,131 4vs91dcv7u1p6   insert into sys.aud$( sessioni...
655465fdy888x3xs0dq w3wp.exe begin prc_query(p_tableName=>:...
16613918naypzfmabd6   INSERT INTO MGMT_SYSTEM_PERFOR...
101148dkrbkzpyuyq4p w3wp.exe Select Contenttype, Decode(Con...
101148dkrbkzpyuyq4p w3wp.exe Select Contenttype, Decode(Con...
8062nszajb0qbyvp   DECLARE job BINARY_INTEGER := ...
7061att0guk2skhm   select lobtsn, lobrdba, lobobj...
3418x0funf899dka   INSERT INTO wri$_adv_addm_inst...
341a0xc4nq6swjvy   INSERT INTO wri$_adv_addm_fdg ...
340b41wak2bb7atw   SELECT sum(delta_cpu_time) as...
322,80353saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
32297j83n99qkydw OEM.SystemPool DELETE FROM MGMT_DUPLICATE_TAR...
3228ddcvbkncpbrax   update "JKDB_SG"."MLOG$_TRAFFI...
2631yzr1rwpsaqh4 OEM.SystemPool INSERT INTO MGMT_HA_MTTR (TARG...
2634a8d9qrv5thzd OEM.SystemPool UPDATE MGMT_HA_MTTR SET COLLEC...
25600xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
24305sghzkq6r6yv   select ts#, file#, block#, col...
2483m779j2ytuk15   update "JKDB_SG"."MLOG$_CURCMS...
2366c9wx6z8w9qpu   select a.default_selectivity f...
23174fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
2308p9z2ztb272bm   SELECT sx.instance_number, sx...
2312g2hcpty0f43ux emagent_SQL_oracle_database begin dbsnmp.mgmt_response.get...
2212974anujtt8zw4h   select o.owner#, o.name, o.nam...
227417ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
227417ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
223b3zgx1xckrwxu   select host, userid, password,...
225bd4bznqbq73hk   select bo#, intcol# from icold...
21023buxzfxyp1vy   SELECT greatest(0, 1000*servi...
2104g46czps3t55u   SELECT sum(case when snap_id ...

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
0b15085bqkbkcSELECT "A2"."DEVICEID", "A2"."DEVICETYPENO", "A2"."STATUSNO", "A2"."TIMEID", "A2"."LASTUPDATE" FROM "CURDEVICESTATUS" "A2", (SELECT DISTINCT "A3"."DEVICEID" "DEVICEID" FROM "JKDB_SG"."MLOG$_CURDEVICESTATUS1" "A3" WHERE "A3"."SNAPTIME$$">:1 AND "A3"."DMLTYPE$$"<>'D') "A1" WHERE "A2"."DEVICEID"="A1"."DEVICEID"
0xqn4sx1ytghrselect /*+ first_rows(1) no_expand */ tab.msgid from "SYSMAN"."AQ$_MGMT_TASK_QTABLE_F" tab where q_name = :1 and (state = :2 ) and queue_id = :3 and ( tab.user_data.scheduled_time <= CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) AND (tab.user_data.message_code = 0 OR tab.user_data.message_code = 1))
0zv836yqahwkwSelect CAPTURELIST.*, CAPTURELIST."ROWID" from CAPTURELIST where (rownum<=1000) and (OpTime<='2013-08-25 09:59:45')
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))
1att0guk2skhmselect lobtsn, lobrdba, lobobjid from x$lobstat where lobspcalloc > 0 and lobcurrtime >= :1 order by lobspcalloc desc
1wr2png6s6xa3SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), 0), NVL(SUM(C2), 0) FROM (SELECT /*+ NO_PARALLEL("MLOG$_DEVICE1") FULL("MLOG$_DEVICE1") NO_PARALLEL_INDEX("MLOG$_DEVICE1") */ 1 AS C1, 1 AS C2 FROM "JKDB_SG"."MLOG$_DEVICE1" SAMPLE BLOCK (2.005092 , 1) SEED (1) "MLOG$_DEVICE1") SAMPLESUB
1yzr1rwpsaqh4INSERT INTO MGMT_HA_MTTR (TARGET_GUID, COLLECTION_TIMESTAMP, ESTIMATED_MTTR) VALUES (:B3 , :B2 , :B1 )
23buxzfxyp1vy SELECT greatest(0, 1000*servicetime - req*:expio ) as impact FROM ( SELECT sum( case when iostat.snap_id = :eid then iostat.small_read_reqs else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_reqs else 0 end) as req, sum( case when iostat.snap_id = :eid then iostat.small_read_servicetime else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_servicetime else 0 end) as servicetime FROM WRH$_IOSTAT_FILETYPE iostat, WRH$_IOSTAT_FILETYPE_NAME fn WHERE iostat.dbid = fn.dbid AND iostat.filetype_id = fn.filetype_id AND (fn.filetype_name = 'Data File' OR fn.filetype_name = 'Temp File') AND iostat.dbid = :dbid AND iostat.instance_number = :inst AND iostat.snap_id IN (:bid, :eid) )
2nszajb0qbyvpDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'), wwv_flow_platform.get_preference('SMTP_HOST_PORT')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2q76h51xvr4xwUPDATE CALCVEHFLOW SET ALLVEHSPEED = ALLVEHSPEED + :B1 , ALLVEHCOUNT = ALLVEHCOUNT + 1, BELOW60 = BELOW60 + :B11 , FROM60TO70 = FROM60TO70 + :B10 , FROM70TO80 = FROM70TO80 + :B9 , FROM80TO90 = FROM80TO90 + :B8 , FROM90TO100 = FROM90TO100 + :B7 , FROM100TO110 = FROM100TO110 + :B6 , FROM110TO120 = FROM110TO120 + :B5 , ABOVE120 = ABOVE120 + :B4 WHERE DEVICEID=:B3 AND OPTIME = TO_DATE(TO_CHAR(:B2 , 'yyyy-mm-dd hh24') || ':00:00', 'yyyy-mm-dd hh24:mi:ss')
2xpqurujh3b0rbegin Proc_InsertDevStatus(DeviceID=>:DeviceID, StatusNo=>:StatusNo, TimeId=>:TimeId); end;
2y018xjrv9360UPDATE HDPHOTOS SET LASTUPDATE = :B5 , PHOTOPATH = :B4 WHERE DEVICEID = :B3 AND PHOTONAME = :B2 AND ROADNO = :B1
38r77vn8nj8v8Select CAPTURELIST.*, CAPTURELIST."ROWID" from CAPTURELIST where (rownum<=1000) and (OpTime<='2013-08-25 09:57:49')
3d1djwagx2831SELECT PLATFORMID, PLATFORMNAME, PLATFORMCODE, DNAME, CONFIGNAME, CONFIGFILE, ISREG, REGCODE, SYSTYPE, SYSHOMEPAGE, CONNSTR, REMARK, STATUS FROM ORG_PLATFORM WHERE PLATFORMCODE = :PLATFORMCODE
3m779j2ytuk15update "JKDB_SG"."MLOG$_CURCMSOPDETAIL" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS')
4a8d9qrv5thzdUPDATE MGMT_HA_MTTR SET COLLECTION_TIMESTAMP = :B3 , ESTIMATED_MTTR = :B2 WHERE TARGET_GUID = :B1
4g46czps3t55u SELECT sum(case when snap_id = :begin_snap_id then value else 0 end) as begin_sga, sum(case when snap_id = :end_snap_id then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :inst_num AND (sga.snap_id = :begin_snap_id OR sga.snap_id = :end_snap_id )
4uphfayydzm8bSelect CAPTURELIST.*, CAPTURELIST."ROWID" from CAPTURELIST where (rownum<=1000) and (OpTime<='2013-08-25 09:58:19')
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
64jtwyfuxpkr3SELECT COUNT(1) FROM HDPHOTOS WHERE DEVICEID = :B3 AND PHOTONAME = :B2 AND ROADNO = :B1
6c9wx6z8w9qpuselect a.default_selectivity from association$ a where a.obj# = :1 and a.property = :2
6x1yqcvu5jc5sSELECT TO_NUMBER(COUNT(*)) FROM CaptureList WHERE 1=1 And OPTIME>To_Date('2013-09-20 00:28', 'yyyy-mm-dd hh24:mi') And OPTIME<To_Date('2013-09-24 08:38', 'yyyy-mm-dd hh24:mi') And VEHPLATE='桂AJ1818'
74anujtt8zw4hselect o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o where d.p_obj#=:1 and (d.p_timestamp=nvl(:2, d.p_timestamp) or d.property=2) and o.owner#=nvl(:3, o.owner#) and d.d_obj#=o.obj# order by o.obj#
74fnxs1kfd150DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 )
7540avtkcgmx9UPDATE CURDEVICESTATUS SET STATUSNO = :B3 , TIMEID = :B2 , LASTUPDATE=SYSDATE WHERE DEVICEID = :B1
7cd89mtu3ytgwINSERT INTO HISGPSDATA (VEHICLENO, COLOR, TYPE, LOCATETIME, LONGITUDE, LATITUDE, HEIGHT, GPSSPEED, REALSPEED, DIRECTION, VEHICLECODE, STATUS, COMPANYIP) VALUES(:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 )
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
8p9z2ztb272bm SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number
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)
97j83n99qkydwDELETE FROM MGMT_DUPLICATE_TARGETS WHERE DUPLICATE_EMD_URL = :B2 AND RESOLVED_TIME < (:B1 - (1/24))
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)
a3s6pu4n0ttcmbegin Proc_InsertGPSData(VehicleNo=>:VehicleNo, Color=>:Color, Types=>:Types, LocateTime=>:LocateTime, Longitude=>:Longitude, Latitude=>:Latitude, Height=>:Height, GPSSpeed=>:GPSSpeed, RealSpeed=>:RealSpeed, Direction=>:Direction, VehicleCode=>:VehicleCode, Status=>:Status, CompanyIP=>:CompanyIP); end;
aadqr5sqm5pu0select count(*) from road
arqy5fh5swxjaSELECT A.STATUSNO, A.ENDTIME FROM DEVICESTATUS A WHERE A.NEWFLAG = 1 AND A.DEVICEID = :B1
b0x81hnmwjn5xSelect CAPTURELIST.*, CAPTURELIST."ROWID" from CAPTURELIST where (rownum<=1000) and (OpTime<='2013-08-25 09:56:49')
b3zgx1xckrwxuselect host, userid, password, flag, authusr, authpwd, passwordx, authpwdx from link$ where owner#=:1 and name=:2
b41wak2bb7atw SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :inst_num AND b.snap_id = :begin_snap_id AND e.dbid = :dbid AND e.instance_number = :inst_num AND e.snap_id = :end_snap_id AND e.session_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
b7za0szn758fxDELETE FROM "CAPTURELIST" WHERE "ROWID"=:1
bd4bznqbq73hkselect bo#, intcol# from icoldep$ where obj#=:1
bfk31x8d42g67SELECT DISTINCT "A1"."DEVICEID" FROM "JKDB_SG"."MLOG$_CURDEVICESTATUS1" "A1" WHERE "A1"."DEVICEID"<>ALL (SELECT "A2"."DEVICEID" FROM "CURDEVICESTATUS" "A2" WHERE "A1"."DEVICEID"="A2"."DEVICEID") AND "A1"."SNAPTIME$$">:1 AND "A1"."DMLTYPE$$"<>'I'
c12apabd94unqSELECT COUNT(*) FROM DEVICESTATUS A WHERE A.NEWFLAG = 1 AND A.DEVICEID = :B1
c3szhz60a32mwUPDATE VEHPLATEBLACKMAIN SET LISTNO = :B2 , OPTIME = :B1 WHERE TRIM(VEHPLATE) = TRIM(:B3 )
cjaa80k1hvpc1select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
ddcvbkncpbraxupdate "JKDB_SG"."MLOG$_TRAFFICINFORMATION1" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS')
dkrbkzpyuyq4pSelect Contenttype, Decode(Contenttype, 1, '咨询', 2, '投诉', 3, '建议', 4, '救援', 5, '报料', 6, '举报', 7, '调度指令', 8, '突发性交通事件', 9, '计划性交通事件', 10, '内部通知', 11, '外部公告') As Contenttypename, Contenttitle, a.Contenttitlename, Count(1) Alertgroupno From (Select Contenttype, Contenttitle, t.Contentid, t.Userid From Alert t Where t.Userid = '30001' And t.Alerttime <= Sysdate And t.Flags In (0, 2) Group By t.Contenttype, t.Contenttitle, t.Userid, t.Contentid) Left Join Alertcontenttitle a On Contenttitle = a.Contenttitleid Group By Contenttype, Contenttitle, a.Contenttitlename Order By Contenttype
dva2s149vds50SELECT ID, DEPARTMENTID, EMPLCODE, EMPLNAME, NICKNAME, IDCARD, ISOPERATER, SEX, BIRTHDAY, EMPLSTATE, ENTERDATE, TRYOUTDATE, DEPARTDATE, STATE, NATION, PERMRESIDENCE, PRKIND, POLITICSVISAGE, MARRYFLG, HEALTHSTATE, OFFICEPHONE, FAMILYPHONE, PHONE, MOBILE, EMAIL, HEIGHT, WEIGHT, BLOOD, GRADUATEFROM, EDULEVEL, COLLEGEMAJOR, PRINCIPALSHIP, ADDRESS, POSTCODE, SPECIALITY, FACEEXAM, WRITTENEXAM, NOTES, PASSWORD, KEYCODE, PHOTO, STATUS, PROJECTID, SEAL, UNAME, BIRTHADD, APARTYDATE, AGROUPDATE, INTEREST, EMPLSERIAL FROM ORG_EMPLOYEE WHERE ID = :ID
dyn8c65fxx7g6UPDATE CURGPSDATA SET VEHICLENO=:B1 , COLOR=:B13 , TYPE=:B12 , LOCATETIME=:B11 , LONGITUDE=:B10 , LATITUDE=:B9 , HEIGHT=:B8 , GPSSPEED=:B7 , REALSPEED=:B6 , DIRECTION=:B5 , VEHICLECODE=:B4 , STATUS=:B3 , COMPANYIP=:B2 WHERE VEHICLENO=:B1
f711myt0q6cmainsert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fdy888x3xs0dqbegin prc_query(p_tableName=>:p_tableName, p_colName=>:p_colName, p_strWhere=>:p_strWhere, p_orderColumn=>:p_orderColumn, p_orderStyle=>:p_orderStyle, p_curPage=>:p_curPage, p_pageSize=>:p_pageSize, p_totalRecords=>:p_totalRecords, p_totalPages=>:p_totalPages, v_cur=>:v_cur); end;
fnkxtujrrunb8Insert into CAPTURELIST(ListNo, DeviceID, LaneNo, AreaNo, RoadNo, Optime, DirectionNo, VehPlate, VehPlateManual, VehPlateSoft, PlateColorNo, VehSpeed, VehBodyColorNo, VehBodyDeepNo, VehTypeNo, PlateTypeNo, UpLoad) VALUES('DCABBAB4-BFCB-4b6a-92B4-981E4A71DACD', 220677, 2, 1, 46, '2013-06-04 14:42:20', 43, '粤TG9474', ' ', ' ', 3, 112, 1, 0, 0, 2, '1')
g0kdm9gds168gbegin PT_HDPHOTO(t_DeviceID=>:t_DeviceID, t_PhotoName=>:t_PhotoName, t_RoadNO=>:t_RoadNO, t_LastUpdate=>:t_LastUpdate, t_PhotoPath=>:t_PhotoPath); end;
g2hcpty0f43uxbegin dbsnmp.mgmt_response.get_latest_curs(:a); end;
g3hxajqptdbscSELECT ID, PID, COMPANYID, DEPACODE, DEPANAME, DEPADESC, DEPASERIAL, DEPAMANAGER, STATUS FROM ORG_DEPARTMENT WHERE ID = :ID
gh6w1qbq7x4nxUPDATE DEVICESTATUS A SET ENDTIME = :B1 WHERE A.NEWFLAG = 1 AND A.DEVICEID = :B2

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 double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced2040.060.00
CCursor + sql area evicted6870.190.00
CPU used by this session536,683148.511.44
CPU used when call started535,938148.311.43
CR blocks created9,1592.530.02
Cached Commit SCN referenced9750.270.00
Commit SCN cached10.000.00
DB time4,476,2791,238.6811.97
DBWR checkpoint buffers written608,820168.471.63
DBWR checkpoints30.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written160.000.00
DBWR transaction table writes4490.120.00
DBWR undo block writes32,1928.910.09
HSC Compressed Segment Block Changes00.000.00
HSC Heap Segment Block Changes632,393175.001.69
HSC OLTP Space Saving00.000.00
HSC OLTP positive compression00.000.00
HSC OLTP recursive compression00.000.00
Heap Segment Array Inserts1430.040.00
Heap Segment Array Updates30,9178.560.08
IMU CR rollbacks1,2040.330.00
IMU Flushes43,41312.010.12
IMU Redo allocation size53,706,79614,861.80143.67
IMU commits332,44591.990.89
IMU contention5,0401.390.01
IMU ktichg flush00.000.00
IMU pool not allocated4820.130.00
IMU recursive-transaction flush00.000.00
IMU undo allocation size1,125,892,448311,558.183,011.82
IMU- failed to get a private strand4820.130.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued14,0023.870.04
RowCR - row contention20.000.00
RowCR attempts1150.030.00
RowCR hits990.030.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink20.000.00
SQL*Net roundtrips to/from client856,705237.072.29
SQL*Net roundtrips to/from dblink3130.090.00
active txn count during cleanout9,8752.730.03
application wait time980.030.00
background checkpoints completed10.000.00
background checkpoints started10.000.00
background timeouts18,6885.170.05
branch node splits60.000.00
buffer is not pinned count9,615,0732,660.6925.72
buffer is pinned count16,257,1584,498.7043.49
bytes received via SQL*Net from client265,417,84873,446.72710.01
bytes received via SQL*Net from dblink106,99629.610.29
bytes sent via SQL*Net to client594,444,614164,495.361,590.17
bytes sent via SQL*Net to dblink147,55040.830.39
calls to get snapshot scn: kcmgss1,731,018479.014.63
calls to kcmgas554,396153.411.48
calls to kcmgcs1,066,870295.232.85
cell physical IO interconnect bytes25,727,994,8807,119,478.7268,823.63
change write time1,4740.410.00
cleanout - number of ktugct calls16,9564.690.05
cleanouts and rollbacks - consistent read gets6500.180.00
cleanouts only - consistent read gets3,0960.860.01
cluster key scan block gets14,9504.140.04
cluster key scans13,8553.830.04
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed1,4970.410.00
commit batch/immediate requested1,4970.410.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written10.000.00
commit cleanout failures: callback failure21,5485.960.06
commit cleanout failures: cannot pin4,5101.250.01
commit cleanouts1,479,019409.283.96
commit cleanouts successfully completed1,452,960402.063.89
commit immediate performed1,4970.410.00
commit immediate requested1,4970.410.00
commit txn count during cleanout89,57824.790.24
concurrency wait time2,362,200653.676.32
consistent changes5,8321.610.02
consistent gets228,278,42363,169.45610.66
consistent gets - examination1,472,775407.553.94
consistent gets direct1,789,472495.184.79
consistent gets from cache226,488,95162,674.27605.87
consistent gets from cache (fastpath)222,994,21861,707.20596.52
cursor authentications2,6140.720.01
data blocks consistent reads - undo records applied4,7081.300.01
db block changes4,161,7351,151.6411.13
db block gets5,564,0911,539.7014.88
db block gets direct1220.030.00
db block gets from cache5,563,9691,539.6714.88
db block gets from cache (fastpath)1,150,546318.383.08
deferred (CURRENT) block cleanout applications634,502175.581.70
dirty buffers inspected6650.180.00
enqueue conversions9090.250.00
enqueue releases1,380,827382.103.69
enqueue requests1,380,841382.113.69
enqueue timeouts30.000.00
enqueue waits8280.230.00
exchange deadlocks20.000.00
execute count1,100,122304.432.94
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time4,593,690,8801,271,171.1412,288.35
free buffer inspected644,739178.411.72
free buffer requested721,149199.561.93
heap block compress11,9733.310.03
hot buffers moved to head of LRU595,001164.651.59
immediate (CR) block cleanout applications3,7461.040.01
immediate (CURRENT) block cleanout applications341,43994.480.91
index crx upgrade (positioned)5,5641.540.01
index crx upgrade (prefetch)40.000.00
index fast full scans (full)14,8864.120.04
index fetch by key1,120,382310.033.00
index scans kdiixs1502,855139.151.35
leaf node 90-10 splits410.010.00
leaf node splits1,7400.480.00
lob reads4600.130.00
lob writes1220.030.00
lob writes unaligned1220.030.00
logons cumulative1,0190.280.00
max cf enq hold time00.000.00
messages received912,976252.642.44
messages sent912,977252.642.44
min active SCN optimization applied on CR2,1770.600.01
no buffer to keep pinned count00.000.00
no work - consistent read gets225,685,51562,451.94603.72
non-idle wait count8,996,6112,489.5524.07
non-idle wait time3,090,778855.288.27
opened cursors cumulative1,007,946278.922.70
parse count (describe)350.010.00
parse count (failures)8,2972.300.02
parse count (hard)162,03844.840.43
parse count (total)455,297125.991.22
parse time cpu353,00197.680.94
parse time elapsed1,209,654334.743.24
physical read IO requests519,319143.711.39
physical read bytes18,948,235,2645,243,376.2750,687.45
physical read total IO requests524,424145.121.40
physical read total bytes19,031,984,1285,266,551.3550,911.48
physical read total multi block requests14,1413.910.04
physical reads2,313,017640.066.19
physical reads cache523,528144.871.40
physical reads cache prefetch20,2325.600.05
physical reads direct1,789,489495.194.79
physical reads direct (lob)150.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests560,582155.121.50
physical write bytes4,994,162,6881,381,990.1313,359.63
physical write total IO requests1,284,554355.463.44
physical write total bytes6,696,010,7521,852,927.3817,912.15
physical write total multi block requests2,1440.590.01
physical writes609,639168.701.63
physical writes direct1390.040.00
physical writes direct (lob)30.000.00
physical writes direct temporary tablespace10.000.00
physical writes from cache609,500168.661.63
physical writes non checkpoint419,680116.131.12
pinned buffers inspected1430.040.00
pinned cursors current40.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use10.000.00
process last non-idle time3,7281.030.01
recursive aborts on index block reclamation00.000.00
recursive calls1,693,967468.764.53
recursive cpu usage450,609124.691.21
redo blocks checksummed by FG (exclusive)725,190200.681.94
redo blocks written1,577,113436.424.22
redo buffer allocation retries20.000.00
redo entries1,486,153411.253.98
redo log space requests20.000.00
redo log space wait time140.000.00
redo ordering marks7,6412.110.02
redo size693,296,420191,849.741,854.60
redo size for direct writes4080.110.00
redo subscn max counts333,70492.340.89
redo synch time187,88151.990.50
redo synch writes377,425104.441.01
redo wastage88,286,40024,430.71236.17
redo write time103,58428.660.28
redo writes352,17097.450.94
rollback changes - undo records applied1,5550.430.00
rollbacks only - consistent read gets3,1980.880.01
rows fetched via callback328,04790.780.88
session connect time00.000.00
session cursor cache hits333,88392.390.89
session logical reads233,842,51564,709.16625.54
shared hash latch upgrades - no wait54,37915.050.15
shared hash latch upgrades - wait40.000.00
sorts (memory)133,08436.830.36
sorts (rows)783,133216.712.09
sql area evicted153,76642.550.41
sql area purged8,2972.300.02
summed dirty queue length1,3890.380.00
switch current to new buffer153,95542.600.41
table fetch by rowid11,307,9383,129.1430.25
table fetch continued row12,4613.450.03
table scan blocks gotten97,466,37926,971.00260.73
table scan rows gotten14,787,368,1084,091,976.5839,556.93
table scans (direct read)20.000.00
table scans (long tables)20.000.00
table scans (short tables)313,09386.640.84
temp space allocated (bytes)00.000.00
total cf enq hold time1,4310.400.00
total number of cf enq holders1620.040.00
total number of times SMON posted20.000.00
transaction rollbacks1,4970.410.00
transaction tables consistent read rollbacks280.010.00
transaction tables consistent reads - undo records applied3220.090.00
undo change vector size242,823,30067,194.33649.56
user I/O wait time326,04590.220.87
user calls1,207,749334.213.23
user commits373,825103.451.00
user rollbacks00.000.00
workarea executions - optimal79,16721.910.21
write clones created in foreground130.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory29,422,732,167,61629,847,993,139,544
opened cursors current925986
workarea memory allocated01,747
logons current150153
session uga memory max197,250,583,024198,745,018,944
session pga memory12,834,822,56813,027,149,640
session pga memory max18,256,624,76018,625,700,680
session cursor cache count3,680,8103,707,049

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 Reads13.7G3.883.868560M0.000M0 
DBWR0M0.000M4.7G155.131.317740 
Buffer Cache Reads4G139.831.131510M0.000M503.3K6.45
LGWR1M0.01.0002761.5G198.81.426150422.60
Others79M1.41.02186083M1.46.02296768381.64
Direct Writes0M0.000M1M0.01.0002760 
Streams AQ1M0.01.0002760M0.000M305.20
TOTAL:17.7G145.135.022486.2G355.411.76714510.2K6.38

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 File17.6G143.735.000354.7G155.151.318296.466.34
Log File0M0.000M1.5G198.80.4258734.00 
Control File80M1.41.02213783M1.47.0229671.22 
Temp File0M0.000M0M0.000M0.00 
TOTAL:17.7G145.145.022486.2G355.421.767146.416.34

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 13.7G3.883.868560M0.000M0 
Direct Reads (Data File) 13.7G3.883.868560M0.000M0 
DBWR 0M0.000M4.7G155.131.317740 
DBWR (Data File) 0M0.000M4.7G155.131.317740 
Buffer Cache Reads 4G139.831.131780M0.000M503.2K6.45
Buffer Cache Reads (Data File) 4G139.831.131780M0.000M503.2K6.45
LGWR 1M0.01.0002761.5G198.80.426150321.97
LGWR (Log File) 0M0.000M1.5G198.79.42587384.00
LGWR (Control File) 1M0.01.0002761M0.01.000276241.29
Others 79M1.41.02186083M1.46.02296750801.25
Others (Control File) 79M1.40.02186082M1.46.02269150601.22
Others (Data File) 0M0.010M1M0.00.000276207.80
Streams AQ 1M0.01.0002760M0.000M305.20
Streams AQ (Data File) 1M0.01.0002760M0.000M305.20
Direct Writes 0M0.000M1M0.01.0002760 
Direct Writes (Data File) 0M0.000M1M0.01.0002760 
TOTAL: 17.7G145.135.022766.2G355.401.76714508.4K6.39

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HDCAPTURE 424,8141186.141.00470,18713020,4800.80
GPS 77,918227.501.0084,3832300.00
SYSTEM 15,73340.53113.902490480.00
JKDB_SG 49507.2136.312,10014,2331.02
UNDOTBS1 100.001.002,49111800.11
SYSAUX 29905.521.091,375000.00
TEMP 100.001.001000.00
USERS 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
GPSE:\JKDB\GPS 11,26437.451.0012,294300.00
GPSE:\JKDB\GPS1 16,40057.541.0017,709500.00
GPSE:\JKDB\GPS2 26,44977.031.0028,483800.00
GPSE:\JKDB\GPS3 23,80578.011.0025,897700.00
HDCAPTUREE:\JKDB\HDCAPTURE 84,300237.021.00109,8643047.50
HDCAPTUREE:\JKDB\HDCAPTURE1 61,164175.841.0064,725181430.14
HDCAPTUREE:\JKDB\HDCAPTURE2 74,141215.111.0066,607185,2800.78
HDCAPTUREE:\JKDB\HDCAPTURE3 75,962215.381.0071,5722010,0620.79
HDCAPTUREE:\JKDB\HDCAPTURE4 65,056185.711.0063,515184,9590.87
HDCAPTUREE:\JKDB\HDCAPTURE5 34,31997.541.0050,2071400.00
HDCAPTUREE:\JKDB\HDCAPTURE6 29,87288.051.0043,69712320.00
JKDB_SGE:\JKDB\JKDB_SG 28607.3440.941,41503,6041.04
JKDB_SGE:\JKDB\JKDB_SG1 20907.0329.9868506290.89
SYSAUXE:\JKDB\SYSAUX01.DBF 29905.521.091,375000.00
SYSTEME:\JKDB\SYSTEM01.DBF 15,73340.53113.902490480.00
TEMPE:\JKDB\TEMP01.DBF 100.001.00100 
UNDOTBS1E:\JKDB\UNDOTBS01.DBF 100.001.002,49111800.11
USERSE:\JKDB\USERS01.DBF 100.001.001000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D2,294,325100232,033,207523,532609,5410024,939

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000608,7330

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
B035519301339077441058493417744105   
E036552081473218100508493417810050   

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
D1,8560.1022997.866,502,886143576708.00
D3,7120.2045897.496,477,959143408656.00
D5,5680.3068697.246,461,562143298120.00
D7,4240.4091597.056,448,763143211841.00
D9,2800.501,1445.06336,46112006001.00
D11,1360.601,3731.1878,3481265940.00
D12,9920.701,6011.0972,7491228195.00
D14,8480.801,8301.0569,6771207486.00
D16,7040.902,0591.0368,1211196995.00
D18,5601.002,2881.0066,5141186163.00
D18,6241.002,2961.0066,4481185722.00
D20,4161.102,5170.9764,5481172911.00
D22,2721.202,7450.9663,6001166518.00
D24,1281.302,9740.9562,8221161273.00
D25,9841.403,2030.9462,1401156680.00
D27,8401.493,4320.9361,4971152345.00
D29,6961.593,6600.9260,9421148602.00
D31,5521.693,8890.9160,4011144954.00
D33,4081.794,1180.9059,9141141670.00
D35,2641.894,3470.8959,3821138082.00
D37,1201.994,5760.8858,6341133039.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.003,7450

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)
B13,88212,283401.220.000.000.000.001,048,576
E13,88212,278413.511.710.41100.000.001,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K74,46974,46900
64K128K62862800
128K256K2200
256K512K161600
512K1024K3,1663,16600
1M2M86686600
2M4M101000
4M8M2200

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
1,7350.13208,816.120.00100.000423,634,093
3,4710.25208,816.120.00100.000423,634,093
6,9410.50208,816.120.00100.000423,634,093
10,4120.75208,816.120.00100.000423,634,093
13,8821.00208,816.120.00100.000423,634,093
16,6581.20208,816.120.00100.000423,634,093
19,4351.40208,816.120.00100.000423,634,093
22,2111.60208,816.120.00100.000423,634,093
24,9881.80208,816.120.00100.000423,634,093
27,7642.00208,816.120.00100.000423,634,093
41,6463.00208,816.120.00100.000423,634,093
55,5284.00208,816.120.00100.000423,634,093
83,2926.00208,816.120.00100.000423,634,093
111,0568.00208,816.120.00100.000423,634,093

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)
1,9200.67373,4402,515,9071.0065,7891.066,370
2,2400.7836131,4482,516,2611.0065,4351.0554,749
2,5600.8968147,8942,519,0141.0062,6821.0155,193
2,8801.001,00164,1782,519,5201.0062,1761.0055,275
3,2001.111,32080,4482,519,8271.0061,8691.0055,330
3,5201.221,64096,9002,520,0371.0061,6590.9955,370
3,8401.331,960114,0552,520,1921.0061,5040.9955,398
4,1601.442,279130,3672,520,3021.0061,3940.9955,421
4,4801.562,599147,2282,520,3921.0061,3040.9955,439
4,8001.672,919163,8292,520,4511.0061,2450.9955,451
5,1201.783,239180,4402,520,5071.0061,1890.9855,463
5,4401.893,558196,9622,520,5531.0061,1430.9855,473
5,7602.003,878213,5492,520,6041.0061,0920.9855,482

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,5360.2544,717,8486,693,282,980
8,3040.3844,435,0406,650,751,880
11,0720.5044,346,1956,637,575,943
13,8400.63620,07380,650,289
16,6080.75564,24171,726,798
19,3760.88549,91370,118,842
22,1441.00528,71166,444,463
24,9121.13518,56165,467,729
27,6801.25509,36163,966,085
30,4481.38503,91563,301,640
33,2161.50497,41262,178,728
35,9841.63492,86561,673,751
38,7521.75484,77660,358,150
41,5201.88483,66660,358,150
44,2882.00483,66660,358,150

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)
641.000000
1282.000000
1923.000000
2564.000000
3205.000000
3846.000000
4487.000000
5128.000000
5769.000000
64010.000000
70411.000000
76812.000000
83213.000000
89614.000000
96015.000000
1,02416.000000
1,08817.000000
1,15218.000000
1,21619.000000
1,28020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1280.2929621.0062,1771.0067
1920.43310721.0062,1771.0075
2560.57310721.0062,1771.0075
3200.71310721.0062,1771.0075
3840.86310721.0062,1771.0075
4481.00310721.0062,1771.0075
5121.14310721.0062,1771.0075
5761.29310721.0062,1771.0075
6401.43310721.0062,1771.0075
7041.57310721.0062,1771.0075
7681.71310721.0062,1771.0075
8321.86310721.0062,1771.0075
8962.00310721.0062,1771.0075
9602.14310721.0062,1771.0075

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block24,758211
undo header17900
1st level bmb100
undo block100

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) 793793079300.37
KO-Multiple Object Checkpoint (fast object checkpoint) 181802023.50
TX-Transaction (index contention) 636302100.00
HW-Segment High Water Mark 38238201200.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
231.75373,9431,258106943.9/6972.90/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
24-9月 09:515,72069,1529686,9440/00/0/0/0/0/0
24-9月 09:415,17360,321662106,9510/00/0/0/0/0/0
24-9月 09:315,43765,5881,25896,9560/00/0/0/0/0/0
24-9月 09:215,28061,58065086,9620/00/0/0/0/0/0
24-9月 09:115,16760,5931,24776,9680/00/0/0/0/0/0
24-9月 09:014,96856,70963986,9730/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 latch1860.00 00 
AQ deq log cmt cbk chunk latch120.00 00 
AQ deq log statistics latch50.00 00 
AQ dequeue txn counter latch3,1480.00 00 
AQ ht cmt cbk chunk latch220.00 00 
ASM db client latch2,4080.00 00 
ASM map operation hash table10.00 00 
ASM network state latch700.00 00 
AWR Alerted Metric Element list33,6710.00 00 
Change Notification Hash table latch1,2020.00 00 
Consistent RBA352,2420.000.0000 
DML lock allocation2,126,2880.000.0000 
Event Group Locks9210.00 00 
FOB s.o list latch3,5660.030.0000 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch2,568,6730.130.220379,6270.00
JS Sh mem access70.00 00 
JS mem alloc latch60.00 00 
JS queue access latch70.00 00 
JS queue state obj latch26,1700.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,2000.00 00 
KTF sga latch180.00 01,2040.00
KWQMN job cache list latch490.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch160.00 00 
KWQS pqueue ctx latch1220.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0710.00
Memory Management Latch10.00 01,2000.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 Latch190.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process3,5740.00 00 
OS process allocation3,5860.00 00 
OS process: request allocation1,8370.050.0000 
PL/SQL warning settings118,2330.000.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch30,4430.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 01,1970.00
SQL memory manager workarea list latch149,4580.000.0000 
Shared B-Tree4710.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch565,2430.280.0100 
active service list12,1140.110.6203,8160.00
begin backup scn array70.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles14,1290.00 00 
cache buffers chains481,060,0100.030.010669,4980.00
cache buffers lru chain919,0500.000.0901,341,1320.00
cache table scan latch2450.00 02450.00
call allocation38,7310.010.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch1,8560.00 00 
channel operations parent latch24,5660.000.0000 
checkpoint queue latch14,591,9880.000.010611,6510.00
client/application info25,0230.00 00 
compile environment latch1,0190.00 00 
constraint object allocation1,1120.00 00 
corrupted undo seg latch6,1620.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch700.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch700.00 00 
dml lock allocation700.00 00 
done queue latch10.00 00 
dummy allocation2,0360.00 00 
enqueue hash chains2,763,5210.030.0000 
enqueues474,5160.040.0200 
fifth spare latch10.00 00 
file cache latch2230.00 00 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA7350.00 00 
global ctx hash table latch10.00 00 
global tx hash mapping6,9970.00 00 
granule operation10.00 00 
hash table column usage latch1,0360.00 023,063,9050.13
hash table modification latch1140.00 00 
heartbeat check10.00 00 
instance information2,8920.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 latch1000.00 0991.01
job_queue_processes free list latch2020.00 00 
job_queue_processes parameter latch8830.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats991,0220.020.0600 
kokc descriptor allocation latch1,1300.00 00 
ksfv messages10.00 00 
kss move lock310.00 00 
ksuosstats global area2440.00 00 
ksv allocation latch1300.00 00 
ksv class latch610.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch1,8370.050.0000 
ktm global data220.00 00 
kwqbsn:qsga1910.00 00 
lgwr LWN SCN352,8110.040.0000 
list of block allocation4,1160.00 00 
loader state object freelist640.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.00 020.00
mapped buffers lru chain10.00 00 
message pool operations parent latch1530.00 00 
messages2,252,4160.860.0000 
mostly latch-free SCN353,6420.230.0100 
msg queue latch10.00 00 
multiblock read objects1,0220.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch700.00 00 
object queue header heap1,1060.00 08150.00
object queue header operation3,095,7570.000.0000 
object stats modification360.00 00 
parallel query alloc buffer4810.00 00 
parallel query stats10.00 00 
parameter list7,1780.00 00 
parameter table management3,1660.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
policy information15,1830.010.0000 
post/wait queue550,2470.000.000377,8860.02
process allocation1,9740.050.0009200.00
process group creation1,8370.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5280.380.5000 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation1,825,6460.040.0001,484,6820.37
redo copy10.00 01,486,4610.12
redo writing1,631,6310.080.0100 
resmgr group change latch1,8880.00 00 
resmgr:active threads2,0360.00 00 
resmgr:actses change group8450.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list2,0350.100.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config310.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects54,096,7550.930.00128,6080.01
rules engine aggregate statistics60.00 00 
rules engine rule set statistics1120.00 00 
second spare latch10.00 00 
sequence cache3,3150.00 00 
session allocation58,4590.000.00019,4880.00
session idle bit2,434,1330.000.0300 
session queue latch10.00 00 
session state list latch3,4170.200.0000 
session switching4,6560.020.0000 
session timer1,4830.00 00 
shared pool8,829,2620.040.1500 
shared pool sim alloc10.00 00 
shared pool simulator1,525,9550.010.5800 
sim partition latch10.00 00 
simulator hash latch14,789,1330.000.0000 
simulator lru latch40,5110.020.00014,696,1620.06
sort extent pool1180.00 00 
space background state object latch80.00 00 
space background task latch2,6600.150.0002,4000.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation40.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch1620.00 00 
transaction allocation162,1750.00 00 
transaction branch allocation9,1250.010.0000 
undo global data2,009,7680.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
row cache objects54,096,755501,9292,111500,171
cache buffers chains481,060,010138,2261,232136,998
messages2,252,41619,3532919,324
shared pool8,829,2623,8385663,279
In memory undo latch2,568,6733,4167502,667
active checkpoint queue latch565,2431,577151,562
redo writing1,631,6311,224141,210
mostly latch-free SCN353,6428075802
enqueue hash chains2,763,5217283725
redo allocation1,825,6467153712
enqueues474,5161963193
kks stats991,0221599150
checkpoint queue latch14,591,9881011100
shared pool simulator1,525,955854937
session idle bit2,434,13339138
cache buffers lru chain919,05033330
active service list12,1141386
qmn task queue latch528211

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchkticmt: child066979
In memory undo latchktiFlush: child0148587
In memory undo latchktichg: child0266
active checkpoint queue latchkcbbacq: scan active checkpoints01515
active service listkswslogon: session logout086
active service listkswsite: service iterator010
cache buffers chainskcbgtcr: fast path (cr pin)09701,251
cache buffers chainskcbgtcr_2029443
cache buffers chainskcbgcur_20234194
cache buffers chainskcbrls_10615
cache buffers chainskcbchg1: kslbegin: bufs not pinned051
cache buffers chainskcbgcur: fast path (shr)032
cache buffers chainskcbrls_2032
cache buffers chainskcbzwb032
cache buffers chainskcbget: exchange024
cache buffers chainskcbget: pin buffer020
cache buffers chainskcbgtcr: fast path020
cache buffers chainskcbgtcr: kslbegin excl013
cache buffers chainskcbnlc010
cache buffers lru chainkcbzgws030
checkpoint queue latchkcbklbc_cql010
enqueue hash chainsksqgtl3023
enqueue hash chainsksqrcl010
enqueuesksqgel: create enqueue022
enqueuesksqdel011
kks statskksAllocChildStat099
lgwr LWN SCNkcs023030
messagesksarcv0257
messagesksaamb: after wakeup0422
mostly latch-free SCNkcslcu3025
qmn task queue latchkwqmnmvtsks: delay to ready list010
redo allocationkcrfw_redo_gen: redo allocation 1030
redo writingkcrfwcr01414
row cache objectskqrpre: find obj08071,171
row cache objectskqreqd: reget0755282
row cache objectskqreqd0488558
row cache objectskqrso05032
row cache objectskqrget0749
row cache objectskqrget3045
session idle bitksupuc: clear busy011
shared poolkghalo0336231
shared poolkghupr10187167
shared poolkghalp01793
shared poolkghfre01749
shared poolkgh_heap_sizes0422
shared poolkgh_next_free040
shared poolkghfru010
shared pool simulatorkglsim_unpin_simhp04510
shared pool simulatorkglsim_scan_lru: scan0325
shared pool simulatorkglsim_chg_simhp_free014

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
hash tablekkshGetNextChild [KKSHBKLOC1]9,902,0480
Cursor ParentkkscsPruneChild [KKSPRTLOC35]22,7730
Cursor Pinkkslce [KKSCHLPIN2]6,2936
hash tablekkshhcins [KKSHBKLOC3]1,3060
hash tablekkshListChanged [KKSHBKLOC10]1,0190
Library Cachekglhdgn2 1063740
Library Cachekgllkal3 822170
hash tablekkshhcdel [KKSHBKLOC4]810
Library Cachekglpndl1 95160
Library Cachekglobpn1 7113-0
Library Cachekglpin1 490
Library Cachekglpnal1 906-0
Library Cachekglrfcl1 795-0
Library Cachekgllkdl1 854-0
Library CachekglIsOwnerVersionable 12130
Cursor Pinkksfbc [KKSCHLFSP2]30
Library Cachekgldtin1 4220
Library Cachekglhdgn1 622-0
Library Cachekglget2 21-0
Library Cachekgllkc1 571-0
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]10
Cursor PinkksLockDelete [KKSCHLPIN6]10

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
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX121,587,34452.00
JKDB_SGJKDB_SGDEVICESTATUS TABLE66,582,01628.47
JKDB_SGJKDB_SGHDPHOTOS TABLE17,602,8007.53
HDCAPTUREHDCAPTURECAPTURELIST TABLE7,753,0723.32
JKDB_SGJKDB_SGMLOG$_CURDEVICESTATUS1 TABLE6,510,7842.78

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSTEMSYSTEMAUD$ TABLE1,789,45477.36
HDCAPTUREHDCAPTUREPK_CAPTURELIST INDEX236,35010.22
GPSGPSSYS_C0024700 INDEX77,9213.37
HDCAPTUREHDCAPTURECAPTURELIST TABLE70,1383.03
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_VEHPLATE INDEX61,9482.68

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
HDCAPTUREHDCAPTUREPK_CAPTURELIST INDEX236,35345.51
GPSGPSSYS_C0024700 INDEX77,92115.00
HDCAPTUREHDCAPTURECAPTURELIST TABLE70,13813.51
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_VEHPLATE INDEX61,94811.93
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX54,30510.46

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
HDCAPTUREHDCAPTUREPK_CAPTURELIST INDEX236,35345.51
GPSGPSSYS_C0024700 INDEX77,92115.00
HDCAPTUREHDCAPTURECAPTURELIST TABLE70,13813.51
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_VEHPLATE INDEX61,94811.93
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX54,30510.46

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
SYSTEMSYSTEMAUD$ TABLE1,789,454100.00

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
HDCAPTUREHDCAPTUREPK_CAPTURELIST INDEX248,01340.68
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_VEHPLATE INDEX218,57735.85
GPSGPSSYS_C0024700 INDEX86,01214.11
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX7,5961.25
HDCAPTUREHDCAPTURECAPTURELIST TABLE5,4750.90

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
HDCAPTUREHDCAPTUREPK_CAPTURELIST INDEX246,47243.97
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_VEHPLATE INDEX210,31437.52
GPSGPSSYS_C0024700 INDEX84,08015.00
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX6,6141.18
HDCAPTUREHDCAPTURECAPTURELIST TABLE4,1850.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1477930046_8845TABLE PARTITION11884.89
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB32.16

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_SYSAUTH1 INDEX14,80799.46
SYSTEMSYSTEMAUD$ TABLE20.01

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
HDCAPTUREHDCAPTUREPK_CAPTURELIST INDEX208,91241.02
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_VEHPLATE INDEX166,91232.78
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX47,6809.36
HDCAPTUREHDCAPTURECAPTURELIST TABLE25,8725.08
GPSGPSSYS_C0024700 INDEX13,8082.71

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
JKDB_SGJKDB_SGHDPHOTOS TABLE79692.67
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX212.44
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1477930046_8845INDEX PARTITION121.40
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1477930046_8845INDEX PARTITION60.70
GPSGPSSYS_C0024700 INDEX40.47

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HDCAPTUREHDCAPTUREidx_systemlog_optime INDEX1100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
JKDB_SGJKDB_SGHDPHOTOS TABLE4,23393.84
HDCAPTUREHDCAPTUREIDX_CAPTURELIST_OPTIME INDEX1974.37
SYSTEMSYSTEMAUD$ TABLE440.98
HDCAPTUREHDCAPTURECALCVEHFLOW TABLE320.71
SYSSYSTEMI_SLOG1 INDEX40.09

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control670.000 21
dc_files17100.000 00
dc_global_oids7,5920.260 071
dc_histogram_data2,339,6830.030 03,584
dc_histogram_defs768,1490.380 23,960
dc_object_grants90,7660.060 01,746
dc_objects1,584,8440.020 85,910
dc_profiles8350.000 01
dc_rollback_segments1,8800.000 048
dc_segments1,111,4870.030 71,411
dc_sequences1591.890 15910
dc_table_scns12,9870.010 37722
dc_tablespaces6,212,6750.000 09
dc_users8,062,2710.000 27156
global database name3,2360.000 01
outstanding_alerts4214.290 66
sch_lj_oids540.000 09


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
APP CONTEXT2,1760.092,1760.0900
BODY6,0220.9114,6400.66390
CLUSTER4870.621611.8600
DBLINK1,5720.130 00
EDITION8330.001,6550.0000
INDEX10618.878523.5300
OBJECT ID1100.000 00
QUEUE8,6950.0010,4260.0110
RULESET60.0060.0000
SCHEMA2,0330.000 00
SQL AREA572,32278.971,717,23231.9247,4178,295
SUBSCRIPTION70.007100.0070
TABLE/PROCEDURE534,7860.051,115,4200.302,4740
TRIGGER273,7850.00361,0020.00130


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache18,624.0018,624.0016,704.0019,008.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target13,888.0013,888.0013,888.0013,888.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target22,144.0022,144.0022,144.0022,144.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool448.00448.00448.00448.000SHR/DEF
large pool64.0064.0064.0064.000STA/
shared pool2,816.002,816.002,432.004,736.000GRO/DEF
streams pool64.0064.0064.0064.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
BOther263.49 1.731.24925152152
 Freeable104.310.000.760.494 138138
 PL/SQL27.3311.600.180.3623150150
 SQL5.351.110.040.05021135131
EOther271.22 1.751.24925155155
 Freeable106.380.000.760.504 140140
 PL/SQL27.8312.200.180.3523153153
 SQL9.854.430.070.21227139136

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers19,528,679,424 
Fixed Size2,186,200 
Redo Buffers28,360,704 
Variable Size3,556,770,856 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javaJOXLE6.896.890.00
javafree memory440.85440.850.00
largePX msg pool7.817.810.00
largefree memory56.1956.190.00
sharedASH buffers50.0050.000.00
sharedCCUR191.33182.61-4.56
sharedFileOpenBlock33.4733.470.00
sharedKGH: NO ACCESS501.39501.390.00
sharedKGLHD59.0556.23-4.78
sharedPCUR167.88161.78-3.64
sharedSQLA829.86829.43-0.05
shareddb_block_hash_buckets89.0089.000.00
sharedfree memory1,044.651,063.051.76
sharedkglsim heap36.1536.150.00
sharedkglsim object batch70.5870.580.00
streamsKTG hash buckets1.261.260.00
streamsfree memory62.7362.73-0.00
 buffer_cache18,624.0018,624.000.00
 fixed_sga2.082.080.00
 log_buffer27.0527.050.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0921 13:32:100.050.150.00
QMON Coordinator0921 13:32:000.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

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

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 66100.000.000.183.750.000.44
SYSMAN.MGMT_NOTIFY_Q(74054) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(73724) 61610.000.000.110.080.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12343) 0.000.000.030.62
SYSMAN.MGMT_NOTIFY_Q(74054) 0.000.00  
SYSMAN.MGMT_TASK_Q(73724) 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
DBSERVER1_1830_JKDB(22)/SYS.ALERT_QUE 6600.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   

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,6140.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,6140.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_destD:\APP\ADMINISTRATOR\ADMIN\JKDB\ADUMP  
audit_trailDB  
compatible11.2.0.0.0  
control_filesE:\JKDB\CONTROL01.CTL, E:\JKDB\CONTROL02.CTL, E:\JKDB\CONTROL03.CTL  
db_block_size8192  
db_domain    
db_nameJKDB  
diagnostic_destD:\APP\ADMINISTRATOR  
dispatchers(PROTOCOL=TCP) (SERVICE=JKDBXDB)  
job_queue_processes1000  
nls_languageSIMPLIFIED CHINESE  
nls_territoryCHINA  
open_cursors300  
pga_aggregate_target14556332032  
processes500  
remote_login_passwordfileEXCLUSIVE  
sec_case_sensitive_logonFALSE  
sessions800  
sga_target23219666944  
undo_tablespaceUNDOTBS1  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report