WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ECDB2594257367ecdb122-12月-12 02:1211.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
ECORA-01Microsoft Windows x86 64-bit 4 4 2 4.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1157710-1月 -13 22:00:3242 6.2
End Snap:1157810-1月 -13 23:00:4785 4.8
Elapsed:  60.26 (mins)  
DB Time:  1,812.72 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 912M 912MStd Block Size: 8K
Shared Pool Size: 944M 944MLog Buffer: 18,928K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 30.1 13.5 0.46 0.14
DB CPU(s): 3.0 1.3 0.05 0.01
Redo size: 19,176.5 8,578.8  
Logical reads: 17,979.5 8,043.3  
Block changes: 126.5 56.6  
Physical reads: 213.6 95.6  
Physical writes: 18.5 8.3  
User calls: 222.3 99.4  
Parses: 48.5 21.7  
Hard parses: 3.5 1.6  
W/A MB processed: 5.4 2.4  
Logons: 0.1 0.0  
Executes: 65.8 29.4  
Rollbacks: 0.0 0.0  
Transactions: 2.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.33In-memory Sort %: 100.00
Library Hit %: 95.62Soft Parse %: 92.82
Execute to Parse %: 26.33Latch Hit %: 99.88
Parse CPU to Parse Elapsd %: 78.74% Non-Parse CPU: 94.92

Shared Pool Statistics

BeginEnd
Memory Usage %: 83.89 83.20
% SQL with executions>1: 68.49 68.60
% Memory for SQL w/exec>1: 67.40 68.52

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
cursor: pin S31,07691,861295684.46Concurrency
DB CPU 10,808 9.94 
resmgr:cpu quantum18,4513,6071953.32Scheduler
direct path read335,03821910.20User I/O
db file sequential read68,24218930.17User I/O

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

Load Average BeginLoad Average End%User%System%WIO%Idle
   69.0 1.2  29.8
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
74.3 105.9 3.3
Memory Statistics

BeginEnd
Host Mem (MB): 4,095.4 4,095.4
SGA use (MB): 2,560.0 2,560.0
PGA use (MB): 419.9 375.0
% Host Mem used for SGA+PGA: 72.76 71.66

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU10,807.819.94
sql execute elapsed time2,920.702.69
parse time elapsed1,125.901.04
hard parse elapsed time1,116.001.03
failed parse elapsed time772.040.71
PL/SQL execution elapsed time158.310.15
connection management call elapsed time19.900.02
hard parse (sharing criteria) elapsed time18.970.02
PL/SQL compilation elapsed time15.860.01
hard parse (bind mismatch) elapsed time12.640.01
repeated bind elapsed time0.450.00
sequence load elapsed time0.280.00
DB time108,763.48 
background elapsed time1,459.99 
background cpu time6.15 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME255,284 
AVG_IDLE_TIME108,328 
AVG_SYS_TIME4,203 
AVG_USER_TIME250,988 
BUSY_TIME1,021,517 
IDLE_TIME433,457 
SYS_TIME17,178 
USER_TIME1,004,341 
RSRC_MGR_CPU_WAIT_TIME355,237 
VM_IN_BYTES-10,623,428,569,183,666,176 
VM_OUT_BYTES2,709,196,615,811,072 
PHYSICAL_MEMORY_BYTES4,294,332,416 
NUM_CPUS4 
NUM_CPU_CORES4 
NUM_CPU_SOCKETS2 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
10-1月 22:00:320.00     
10-1月 23:00:470.0070.2169.031.1829.790.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Concurrency31,538091,866291384.46
DB CPU  10,808 9.94
Scheduler18,45103,6071953.32
User I/O433,942065110.60
Commit7,004091130.08
System I/O6,24801020.01
Network664,1600100.00
Other319,618100000.00
Configuration12100080.00
Application20070.00
Queueing0 0 0.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
cursor: pin S31,076091,86129563.8584.46
resmgr:cpu quantum18,45103,6071952.283.32
direct path read335,0380219141.450.20
db file sequential read68,242018938.440.17
Disk file operations I/O54301592930.070.15
log file sync7,004091130.870.08
db file scattered read30,02808433.720.08
control file sequential read6,24801020.770.01
library cache lock6034470.000.00
latch: cache buffers chains10601120.010.00
SQL*Net message to client663,91401082.150.00
asynch descriptor resize319,5791000039.540.00
latch: row cache objects1060020.010.00
undo segment extension12100080.000.00
SQL*Net message from dblink960010.010.00
latch: shared pool2270000.030.00
latch free330020.000.00
enq: TX - index contention400140.000.00
direct path write temp290010.000.00
read by other session50060.000.00
direct path write570000.010.00
enq: RO - fast object reuse20070.000.00
SQL*Net more data to client600000.010.00
cursor: pin S wait on X10040.000.00
enq: CR - block range reuse ckpt20010.000.00
SQL*Net message from client664,029016,3032582.16 
jobq slave wait6,063994,6007590.75 
single-task message60813440.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
control file sequential read3,52105091450.4434.86
db file parallel write6,7660365540.8425.01
Disk file operations I/O1720935430.026.40
Streams: flow control18030462570.023.17
os thread startup990313110.012.11
control file parallel write1,124025220.141.70
db file sequential read448013300.060.92
resmgr:cpu quantum240135580.000.92
log file parallel write10,0490611.240.40
rdbms ipc reply25305210.030.36
ADR block file read1201430.000.04
enq: CF - contention1001540.000.01
db file scattered read300490.000.01
latch: row cache objects100310.000.00
direct path read250010.000.00
reliable message2490000.030.00
log file sequential read60030.000.00
log file sync30030.000.00
direct path write170010.000.00
ADR block file write50000.000.00
log file single write60000.000.00
LGWR wait for redo copy450000.010.00
asynch descriptor resize240100000.030.00
latch free910000.010.00
rdbms ipc message32,8786660,36718364.07 
DIAG idle wait5,9931007,24812090.74 
dispatcher timer611003,665600750.01 
shared server idle wait1211003,638300700.01 
pmon timer1,304893,62727810.16 
Streams AQ: qmn coordinator idle wait1,409373,62625740.17 
Streams AQ: qmn slave idle wait95203,62638090.12 
Space Manager: slave idle wait683993,62453060.08 
Streams: waiting for messages5,571983,5766420.69 
smon timer18503,3431857100.00 
SQL*Net message from client2050010.03 
class slave wait200020.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 read1225.0  25.0  50.0 
ADR block file write5100.0       
ADR file lock6100.0       
Disk file operations I/O71565.5.62.1.72.89.410.58.5
LGWR wait for redo copy45100.0       
SQL*Net message from dblink9675.018.85.21.0    
SQL*Net message to client664.1K100.0.0.0 .0   
SQL*Net message to dblink90100.0       
SQL*Net more data to client6098.31.7      
Streams: flow control18066.1.6.61.13.31.116.710.6
asynch descriptor resize319.9K100.0       
buffer busy waits13100.0       
control file parallel write113193.52.7.3.3.4.32.3.4
control file sequential read978788.01.2.91.2.4.27.9.2
cursor: pin S31.3K1.0.0.0.11.51.546.549.3
cursor: pin S wait on X1  100.0     
db file parallel write676769.612.97.03.21.3.15.6.4
db file scattered read30K50.621.36.813.46.41.2.3 
db file sequential read68.2K63.53.58.820.72.3.6.6.0
direct path read335.1K93.8.81.72.6.5.5.1.0
direct path write7494.64.11.4     
direct path write temp2941.413.844.8     
enq: CF - contention1      100.0 
enq: CR - block range reuse ckpt250.050.0      
enq: RO - fast object reuse2   100.0    
enq: TX - index contention450.0   25.0 25.0 
latch free12498.4.8    .8 
latch: cache buffers chains10690.6.9 .9.9 6.6 
latch: row cache objects10780.41.94.73.74.74.7  
latch: shared pool22890.86.61.8.9    
library cache lock6 16.7 16.716.7 16.733.3
library cache: mutex X1100.0       
log file parallel write10.1K96.21.3.7.5.5.4.4 
log file sequential read650.0  50.0    
log file single write6100.0       
log file sync701394.21.5.8.5.8.61.5.0
os thread startup99    41.48.142.48.1
rdbms ipc reply25398.4     .8.8
read by other session5  20.080.0    
reliable message253100.0       
resmgr:cpu quantum18.5K2.0.4.61.14.34.386.01.3
undo segment extension1241.78.38.38.316.716.7  
DIAG idle wait6013      50.849.2
SQL*Net message from client664.3K70.524.62.5.7.5.2.7.2
Space Manager: slave idle wait686.3      99.7
Streams AQ: qmn coordinator idle wait141757.5  .1.4.44.437.3
Streams AQ: qmn slave idle wait95644.8      55.2
Streams: waiting for messages5579.8.1.1.421.8.661.914.3
class slave wait2090.05.0    5.0 
dispatcher timer61       100.0
jobq slave wait6089.3    .074.025.6
pmon timer13087.6 .1.1.1.21.190.9
rdbms ipc message32.9K15.51.1.71.35.42.028.246.0
shared server idle wait121       100.0
single-task message6      50.050.0
smon timer19      5.394.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
ADR block file read650.08.341.7     
Disk file operations I/O7981.03.21.11.11.33.8.68.0
Streams: flow control4972.82.2.6  13.910.6 
control file parallel write2797.31.8.2 .1.3.1.4
control file sequential read78891.9.3.61.4.15.4.2 
cursor: pin S18.7K4.24.75.012.09.715.213.435.9
db file parallel write40294.1.2.1  5.3.4 
db file scattered read9999.7.3.0.0    
db file sequential read40499.4.2.2.2.0.0.0 
direct path read32299.9.1.0.0.0.0.0 
enq: CF - contention1   100.0    
enq: TX - index contention175.025.0      
latch free199.2.8      
latch: cache buffers chains793.41.9 3.8.9   
library cache lock350.0  16.7  33.3 
log file parallel write3999.6.4.0     
log file sync10998.41.0.5.0 .1.0.0
os thread startup5049.52.09.110.12.019.28.1 
rdbms ipc reply498.4    .8.8 
resmgr:cpu quantum16.2K12.714.219.631.215.06.01.3 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
Disk file operations I/O5792.06.02.0     
control file parallel write499.6.1.3     
cursor: pin S11.2K64.113.212.67.92.1.1.0 
log file sync2100.0    .0  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
ECDB106,2249,48935146,220
SYS$USERS1,9961,27442118,798
ECDBXDB0000
SYS$BACKGROUND00038

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
ECDB 3493743373150791859006641591
SYS$USERS 845803143030000
SYS$BACKGROUND 660107103310000

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
141.18602.350.131.1883.186gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
77.987,3460.010.0778.625.850w18y2bj06rq3 w3wp.exe begin package_page.proc_page(p...
50.52550.920.050.6273.903am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
44.3567.390.040.6067.543sq8sqw641nta SMS_ECWeb_Block_IP_Script.exe begin PRO_EC_IIS_LOG_MONI(p_re...
44.09133.390.042.6598.268szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
43.06314.350.040.5467.27dymnwp8k35qs7 SMS_ECWeb_Block_IP_Script.exe SELECT COUNT(1) FROM (SELECT D...
36.34136.340.030.4767.94gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
32.60950.340.0356.270.003ppbwcr995f1x w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
31.01310.340.0317.610.005myvzcwq9kc1b w3wp.exe SELECT * FROM (SELECT ROWNUM r...
30.78291.060.0333.600.00gyy3zhvk0sufp w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....

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
61.317,3460.010.5777.9878.625.850w18y2bj06rq3 w3wp.exe begin package_page.proc_page(p...
20.791090.190.1928.2573.610.005qv7r97puku65 w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
18.35950.190.1732.6056.270.003ppbwcr995f1x w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
17.781,4710.010.1622.2579.930.006crb2ju7y6zvu w3wp.exe select * from (select * from s...
17.301,4720.010.1620.0286.430.00abam683fqr6b2 w3wp.exe select * from (select * from s...
13.682,9510.000.1316.2484.231.6363rtmgkxf3gfk w3wp.exe select count(*) from sw_Info w...
12.951260.100.1212.9599.960.00c0j6cx9kzjf7g DBMS_SCHEDULER SELECT EXTRACTVALUE(VALUE(T), ...
10.34290.360.1030.7833.600.00gyy3zhvk0sufp w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
9.8451.970.0916.3160.370.001k4432m7yzh52 w3wp.exe SELECT SPT.ID, SPT.TYPENAME, S...
9.7551.950.0917.1456.890.0040046a8b6vs4d w3wp.exe SELECT SB.ID, SB.BRANDNAME, SU...

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
117.43601.9615.50141.181.1883.186gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
43.33133.335.7244.092.6598.268szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
37.34550.684.9350.520.6273.903am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
29.9564.993.9544.350.6067.543sq8sqw641nta SMS_ECWeb_Block_IP_Script.exe begin PRO_EC_IIS_LOG_MONI(p_re...
28.9739.663.8243.060.5467.27dymnwp8k35qs7 SMS_ECWeb_Block_IP_Script.exe SELECT COUNT(1) FROM (SELECT D...
24.69124.693.2636.340.4767.94gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
24.51600.413.2424.970.2598.197mdacxfm37utk EM_PING SELECT COUNT(*) FROM MGMT_FAIL...
24.2846.073.2025.720.0094.407mgr3uwydqq8j   select decode(open_mode, 'MOU...
21.668450.032.8624.352.0588.960gn6g291nvc8u w3wp.exe SELECT MAX(a.f_inventory_amoun...
17.502420.072.3117.540.0999.778vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
14.098370.021.8619.1319.3373.683zqmg3y6vprtb w3wp.exe select b.attrname as 属性名称, a.a...
12.4234.141.6415.070.8382.42fdjtrdaz8hpvg   INSERT /*+ APPEND LEADING(@"SE...

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
7,908,4707,3461,076.5712.1777.9878.625.850w18y2bj06rq3 w3wp.exe begin package_page.proc_page(p...
5,016,18010946,020.007.7228.2573.610.005qv7r97puku65 w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
4,940,8482,9511,674.307.6016.2484.231.6363rtmgkxf3gfk w3wp.exe select count(*) from sw_Info w...
4,674,0959549,201.007.1932.6056.270.003ppbwcr995f1x w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
3,087,6381,4722,097.584.7520.0286.430.00abam683fqr6b2 w3wp.exe select * from (select * from s...
3,085,5511,4712,097.594.7522.2579.930.006crb2ju7y6zvu w3wp.exe select * from (select * from s...
1,786,7853945,815.002.7515.1648.370.001nfbydjcv21k4 w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
1,330,5564628,925.132.054.57100.040.15fy3c2z3n3v17d DBMS_SCHEDULER /* SQL Analyze(73, 1) */ SELEC...
1,162,4072940,083.001.7930.7833.600.00gyy3zhvk0sufp w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
797,7591746,927.001.2315.0945.480.00dcssauxd5hhtf w3wp.exe SELECT T1.TYPENAME, T1.Id, T2....
661,4305013,228.601.022.60100.100.003dhrg4hrbgk69 DBMS_SCHEDULER /* SQL Analyze(73, 1) */ selec...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
12,81913986.081.6644.092.6598.268szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
7,62861,271.330.9944.350.6067.543sq8sqw641nta SMS_ECWeb_Block_IP_Script.exe begin PRO_EC_IIS_LOG_MONI(p_re...
7,62832,542.670.9943.060.5467.27dymnwp8k35qs7 SMS_ECWeb_Block_IP_Script.exe SELECT COUNT(1) FROM (SELECT D...
4,0888454.840.5324.352.0588.960gn6g291nvc8u w3wp.exe SELECT MAX(a.f_inventory_amoun...
6999400.740.094.292.5488.36625rn54ngknu6 w3wp.exe select psp.f_sale_price from z...
6604,9550.130.096.4768.2726.4443ruajmwv9fus   insert into histgrm$(obj#, int...
6331933.320.084.2786.6612.903j1x4pd50mfpb DBMS_SCHEDULER /* SQL Analyze(73, 1) */ selec...
5618370.670.0719.1319.3373.683zqmg3y6vprtb w3wp.exe select b.attrname as 属性名称, a.a...
235603.920.03141.181.1883.186gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1591,8190.090.025.1589.0714.274y1y43113gv8f   delete from histgrm$ where obj...

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
12,74112,74113980.080.002.928szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
7,6287,62861,271.330.001.753sq8sqw641nta SMS_ECWeb_Block_IP_Script.exe begin PRO_EC_IIS_LOG_MONI(p_re...
7,6287,62832,542.670.001.75dymnwp8k35qs7 SMS_ECWeb_Block_IP_Script.exe SELECT COUNT(1) FROM (SELECT D...
4,0884,0888454.840.000.940gn6g291nvc8u w3wp.exe SELECT MAX(a.f_inventory_amoun...
6996999400.740.000.16625rn54ngknu6 w3wp.exe select psp.f_sale_price from z...
6606604,9550.130.000.1543ruajmwv9fus   insert into histgrm$(obj#, int...
5615618370.670.000.133zqmg3y6vprtb w3wp.exe select b.attrname as 属性名称, a.a...
323323605.380.000.076gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
208208553.780.000.053am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
1981981198.000.000.05gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
29,20229,2021.003.5175.970.00fa5n395tn6pza w3wp.exe select * from sw_PRODUCTS wher...
27,40427,3991.002.1582.800.00gauspxfd79xbj w3wp.exe select * from sw_SERIES where ...
25,78320,2710.792.9886.930.410c9272hgmxrdy w3wp.exe select f_sale_price from produ...
8,1758,1751.000.74104.860.00g1zrcv11nstpd w3wp.exe select spt.typename, sb.brandn...
7,8467,7910.990.6484.680.00168ybx4zj6bw2 w3wp.exe select * from sw_PRODUCTS_TYPE...
7,3467,3461.0077.9878.625.850w18y2bj06rq3 w3wp.exe begin package_page.proc_page(p...
4,95530,0896.076.4768.2726.4443ruajmwv9fus   insert into histgrm$(obj#, int...
3,4817,5302.160.8211.400.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
3,3223,3221.000.32107.100.000z64k20dy8zut w3wp.exe select brandname from sw_brand...
2,9512,9501.0016.2484.231.6363rtmgkxf3gfk w3wp.exe select count(*) from sw_Info w...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
29,20029,20216.67fa5n395tn6pza w3wp.exe select * from sw_PRODUCTS wher...
27,39727,40415.64gauspxfd79xbj w3wp.exe select * from sw_SERIES where ...
25,77525,78314.710c9272hgmxrdy w3wp.exe select f_sale_price from produ...
8,1758,1754.67g1zrcv11nstpd w3wp.exe select spt.typename, sb.brandn...
7,8467,8464.48168ybx4zj6bw2 w3wp.exe select * from sw_PRODUCTS_TYPE...
7,3467,3464.190w18y2bj06rq3 w3wp.exe begin package_page.proc_page(p...
3,4813,4811.99cm5vu20fhtnq1   select /*+ connect_by_filterin...
3,3223,3221.900z64k20dy8zut w3wp.exe select brandname from sw_brand...
1,9871,9871.13b6fwkg2dxr1t3 w3wp.exe select b.pmt_goodsdiscount, b....
1,6521,6520.945b9n551qcguc1 w3wp.exe select * from sw_Cart where 1!...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
314f75asf6dp7u2y w3wp.exe select count(id) from (SELECT ...
2822ghpzw5mg1ys8c w3wp.exe select count(id) from (SELECT ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0c9272hgmxrdyselect f_sale_price from product_sale_price where f_product_id=:product_id and F_PRICE_BM='ECBJ'
0gn6g291nvc8uSELECT MAX(a.f_inventory_amount - a.f_out_amount - a.f_sale_amount - a.f_shatter_amount) FROM inventory a WHERE a.f_product_id=:product_id
0w18y2bj06rq3begin package_page.proc_page(p_tablename=>:p_tablename, p_tablecolumn=>:p_tablecolumn, p_pagesize=>:p_pagesize, p_curpage=>:p_curpage, p_order=>:p_order, p_where=>:p_where, p_rowcount=>:p_rowcount, p_pagecount=>:p_pagecount, p_cursor=>:p_cursor); end;
0z64k20dy8zutselect brandname from sw_brand where id = :brandId
168ybx4zj6bw2select * from sw_PRODUCTS_TYPE where ID=:ID
1k4432m7yzh52 SELECT SPT.ID, SPT.TYPENAME, SUM(CASE WHEN SP.ID IS NULL THEN 0 ELSE 1 END) PROD_NOR_CNT, SUM(CASE WHEN SP_TH.ID IS NULL THEN 0 ELSE 1 END) PROD_TH_CNT FROM SW_PRODUCTS_TYPE SPT LEFT JOIN(SELECT SP.TYPEID, SP.ID FROM SW_PRODUCTS SP WHERE SP.ISONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER( SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP ON SP.TYPEID=SPT.ID LEFT JOIN(SELECT SP.TYPEID, SP.ID FROM SW_PRODUCTS SP WHERE SP.TH_PROD_ONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT ) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断 路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑 壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP_TH ON SP_TH.TYPEID=SPT.ID AND SP.ID=SP_TH.ID GROUP BY SPT.ID, SPT.TYPENAME ORDER BY SPT.ID
1nfbydjcv21k4SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and brandid=81GROUP BY typeid) T2 WHERE T1.Id=T2.typeid
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3dhrg4hrbgk69/* SQL Analyze(73, 1) */ select count(id) from (SELECT * from vw_products m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid) where ISONSALE=1 and SDELL=0 and TYPEID=265 and brandid=85 and seriesid=1461 and ATTR_404='1094'
3j1x4pd50mfpb/* SQL Analyze(73, 1) */ select * from (select id, productsname, typeId, productsid, unit, seriesid, pic, typename, brandname, seriesPrice, F_SALE_PRICE, PRODUCTSPRICE, isonsale, ISNEW, ISRECOMMONDL, ISSPECIALOFFER, ISHOT, stock, MINNUM, weight, sdell from v_products_all_list_stock where 1=1 and SDELL=0 and typeid in (select ID from sw_products_type t where t.pid in (select ID from sw_products_type t where t.pid=5)) order by ID DESC) where rownum<=10
3ppbwcr995f1xSELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and brandid=85GROUP BY typeid) T2 WHERE T1.Id=T2.typeid
3sq8sqw641ntabegin PRO_EC_IIS_LOG_MONI(p_ret=>:p_ret, p_msg=>:p_msg, p_cur=>:p_cur); end;
3zqmg3y6vprtbselect b.attrname as 属性名称, a.avalue as 属性值 from SW_PRODUCTS_ATTR a inner join sw_attr b on a.aid=b.id where productsid=:ID and a.aid in (select distinct(a.attrid) from sw_bas a inner join (select typeid, seriesid from sw_products where id=:ID) b on a.typeid=b.typeid and a.seriesid=b.seriesid) ORDER BY f_Sortorder ASC
40046a8b6vs4d SELECT SB.ID, SB.BRANDNAME, SUM(CASE WHEN SP.ID IS NULL THEN 0 ELSE 1 END) PROD_NOR_CNT, SUM(CASE WHEN SP_TH.ID IS NULL THEN 0 ELSE 1 END) PROD_TH_CNT FROM SW_BRAND SB LEFT JOIN(SELECT SP.BRANDID, SP.ID FROM SW_PRODUCTS SP WHERE SP.ISONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配 电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTEN T) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP ON SP.BRANDID=SB.ID LEFT JOIN(SELECT SP.BRANDID, SP.ID FROM SW_PRODUCTS SP WHERE SP.TH_PROD_ONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE ' %框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔 离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '% 微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) )SP_TH ON SP_TH.BRANDID=SB.ID AND SP.ID=SP_TH.ID GROUP BY SB.ID, SB.BRANDNAME ORDER BY SB.ID
43ruajmwv9fusinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)
4y1y43113gv8fdelete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
5b9n551qcguc1select * from sw_Cart where 1!=1
5myvzcwq9kc1b SELECT * FROM (SELECT ROWNUM rn, a.* FROM (SELECT t1.cnt+t2.cnt as cnt FROM( SELECT COUNT(1) cnt FROM SW_PRODUCTS SP JOIN SW_PRODUCTS_TYPE SPT ON SP.TYPEID=SPT.ID JOIN SW_BRAND SB ON SP.BRANDID=SB.ID JOIN SW_SERIES SS ON SS.ID=SP.SERIESID WHERE 1=1 AND SP.ISONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP .CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动 机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) ) t1, ( SELECT COUNT(1) cnt FROM SW_PRODUCTS SP JOIN SW_PRODUCTS_TYPE SPT ON SP.TYPEID=SPT.ID JOIN SW_BRAND SB ON SP.BRANDID=SB.ID JOIN SW_SERIES SS ON SS.ID=SP.SERIESID WHERE 1=1 AND SP.TH_PROD_ONSALE=1 AND SP.SDELL=0 AND (((((((((((((((UPPER(SP.PRODUCTSNAME) LIKE '%空气断路器%' OR UPPER(SP.CONTENT) LIKE '%空气断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%空气断 路器%' OR UPPER(SP.SEOKEYS) LIKE '%空气断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%框架式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%框架式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%框架式负荷隔离 %' OR UPPER(SP.SEOKEYS) LIKE '%框架式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型断路器%' OR UPPER(SP.CONTENT) LIKE '%微型断路器%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型断路器%' OR UPPER(SP.SEOKEYS) LIKE '%微型断路器%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微型隔离开关%' OR UPPER(SP.CONTENT) LIKE '%微型隔离开关%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微型隔离开关%' OR UPPER(SP.SEOKEYS) LIKE '%微型隔离开关%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%小型断路器附件%' OR UPPER(SP.CONTENT) LIKE '%小型断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%小型断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%小型断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳配电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳配电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳配电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳配电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳电动机保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳电动机保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳电动机保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳电动机保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器附件%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器附件%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器附件%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器附件%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳断路器本体%' OR UPPER(SP.CONTENT) LIKE '%塑壳断路器本体%' OR UPPER (SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳断路器本体%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳断路器本体%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.CONTENT) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳式负荷隔离%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳式负荷隔离%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%微断漏电保护%' OR UPPER(SP.CONTENT) LIKE '%微断漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%微断漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%微断漏电保护%')) OR (UPPER(SP.PRODUCTSNAME) LIKE '%塑壳漏电保护%' OR UPPER(SP.CONTENT) LIKE '%塑壳漏电保护%' OR UPPER(SP.PRODUCT_BM_SUPPLY) LIKE '%塑壳漏电保护%' OR UPPER(SP.SEOKEYS) LIKE '%塑壳漏电保护%'))) ) t2) a WHERE ROWNUM <=20) WHERE rn >= 1
5qv7r97puku65SELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and brandid=84GROUP BY typeid) T2 WHERE T1.Id=T2.typeid
625rn54ngknu6select psp.f_sale_price from zyd.product_sale_price psp where psp.f_price_bm =:priceType and psp.f_product_id =:product_sid
63rtmgkxf3gfkselect count(*) from sw_Info where InfoIsDisplay='1' and columnid in(1, 2, 3, 9, 10, 11)
6crb2ju7y6zvuselect * from (select * from sw_Info where InfoIsDisplay='1' and columnid in(1, 2, 3, 9, 10, 11) order by InfoOrders asc, InfoIsTop desc, InfoDateTime desc) where rownum<=10
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7mdacxfm37utkSELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND')
7mgr3uwydqq8j select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 'READ ONLY WITH APPLY', 1, 2) dbstate into :dbstate from v$database
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
abam683fqr6b2select * from (select * from sw_Info where InfoIsDisplay='1' and columnid in(1, 2, 3, 9, 10, 11) order by InfoDateTime desc) where rownum<=10
b6fwkg2dxr1t3select b.pmt_goodsdiscount, b.pmt_goodsdiscountproductids from vw_product_acrivity b
c0j6cx9kzjf7gSELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
dcssauxd5hhtfSELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and (UPPER(productsname) like UPPER('%断路器%') or UPPER(CONTENT) like UPPER('%断路器%') or UPPER(SEOKEYS) like UPPER('%断路器%'))GROUP BY typeid) T2 WHERE T1.Id=T2.typeid
dymnwp8k35qs7SELECT COUNT(1) FROM (SELECT DISTINCT T.USERAGENT FROM IIS.SW_PAGE_VIEW_LOG T WHERE 1 = 1 AND T.CLIENTHOST = :B3 AND T.LOGTIME BETWEEN :B2 AND :B1 )
f75asf6dp7u2yselect count(id) from (SELECT * from vw_products m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid) where ISONSALE=1 and SDELL=0 and brandid=84 and typeid =54
fa5n395tn6pzaselect * from sw_PRODUCTS where ID=:ID
fdjtrdaz8hpvg INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
fy3c2z3n3v17d/* SQL Analyze(73, 1) */ SELECT B.ID, B.PRODUCTSNAME, B.PRODUCTSPRICE, B. PRODUCTSID, B.TYPEID, B.PIC, B.PRODUCTSNO, B.SHORTCONTENT, B.typeid FROM (SELECT ROWNUM ROWNO, A.* FROM (SELECT m.* from (select a.*, nvl(b.f_sale_price, '0') as f_sale_price from vw_products a left join Product_Sale_Price b on a.Productsid=b.f_product_id and b.f_price_bm='ECBJ') m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid where 1=1 and ISONSALE=1 and SDELL=0 and TYPEID=265 and brandid=85 and seriesid=1461 and ATTR_404='1094' order by ORDERS desc , addtime desc )A )B WHERE (B.ROWNO > (1 -1 ) * 24 AND B.ROWNO <= 1 * 24) OR 1 IS NULL
g1zrcv11nstpdselect spt.typename, sb.brandname from sw_products sp , sw_products_type spt , sw_brand sb where 1=1 and sp.id=:ID and sp.typeid=spt.id and sp.brandid=sb.id
gauspxfd79xbjselect * from sw_SERIES where ID=:ID
ghpzw5mg1ys8cselect count(id) from (SELECT * from vw_products m inner join SW_PRODUCTS_TEMP n on m.id=n.productsid) where ISONSALE=1 and SDELL=0 and brandid=85 and typeid =265
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gyy3zhvk0sufpSELECT T1.TYPENAME, T1.Id, T2.NUM FROM sw_products_type T1, (SELECT typeid, COUNT(*) AS NUM FROM vw_products WHERE ISONSALE=1 and SDELL=0 and (UPPER(productsname) like UPPER('%接触器%') or UPPER(CONTENT) like UPPER('%接触器%') or UPPER(SEOKEYS) like UPPER('%接触器%'))GROUP BY typeid) T2 WHERE T1.Id=T2.typeid

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 referenced1040.030.01
CCursor + sql area evicted820.020.01
CPU used by this session1,007,266278.59124.63
CPU used when call started945,356261.47116.97
CR blocks created1340.040.02
Cached Commit SCN referenced11,7773.261.46
Commit SCN cached900.020.01
DB time11,289,4593,122.441,396.86
DBWR checkpoint buffers written7,7022.130.95
DBWR checkpoints50.000.00
DBWR object drop buffers written640.020.01
DBWR parallel query checkpoint 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 writes1440.040.02
DBWR undo block writes3,8261.060.47
DFO trees parallelized00.000.00
HSC Heap Segment Block Changes85,82423.7410.62
HSC IDL Compressed Blocks1,7990.500.22
Heap Segment Array Inserts8560.240.11
Heap Segment Array Updates3610.100.04
IMU CR rollbacks00.000.00
IMU Flushes00.000.00
IMU Redo allocation size00.000.00
IMU commits00.000.00
IMU contention00.000.00
IMU ktichg flush00.000.00
IMU pool not allocated8,8862.461.10
IMU recursive-transaction flush00.000.00
IMU undo allocation size00.000.00
IMU- failed to get a private strand8,8862.461.10
LOB table id lookup cache misses10.000.00
Number of read IOs issued337,38093.3141.74
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations downgraded 1 to 25 pct00.000.00
Parallel operations downgraded 25 to 50 pct00.000.00
Parallel operations downgraded 50 to 75 pct00.000.00
Parallel operations not downgraded00.000.00
RowCR - row contention00.000.00
RowCR attempts1200.030.01
RowCR hits1200.030.01
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink90.000.00
SQL*Net roundtrips to/from client663,956183.6482.15
SQL*Net roundtrips to/from dblink900.020.01
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout9740.270.12
application wait time20.000.00
background checkpoints completed30.000.00
background checkpoints started30.000.00
background timeouts13,0283.601.61
branch node splits20.000.00
buffer is not pinned count29,404,0108,132.573,638.21
buffer is pinned count47,417,10013,114.635,867.00
bytes received via SQL*Net from client365,987,005101,224.7845,284.21
bytes received via SQL*Net from dblink49,39013.666.11
bytes sent via SQL*Net to client854,433,643236,319.48105,720.57
bytes sent via SQL*Net to dblink37,67810.424.66
calls to get snapshot scn: kcmgss1,319,741365.01163.29
calls to kcmgas32,3778.954.01
calls to kcmgcs149,75041.4218.53
cell physical IO interconnect bytes7,145,505,2801,976,305.72884,125.87
change write time9080.250.11
cleanout - number of ktugct calls52,46514.516.49
cleanouts and rollbacks - consistent read gets410.010.01
cleanouts only - consistent read gets51,41714.226.36
cluster key scan block gets53,35314.766.60
cluster key scans34,9649.674.33
commit batch performed1280.040.02
commit batch requested1280.040.02
commit batch/immediate performed1400.040.02
commit batch/immediate requested1400.040.02
commit cleanout failures: block lost800.020.01
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure1680.050.02
commit cleanout failures: cannot pin00.000.00
commit cleanouts31,6748.763.92
commit cleanouts successfully completed31,4268.693.89
commit immediate performed120.000.00
commit immediate requested120.000.00
commit nowait performed1220.030.02
commit nowait requested1220.030.02
commit txn count during cleanout52,29914.466.47
commit wait/nowait performed1220.030.02
commit wait/nowait requested1220.030.02
concurrency wait time9,211,9012,547.831,139.80
consistent changes6,9991.940.87
consistent gets64,582,39717,862.227,990.89
consistent gets - examination4,427,4001,224.53547.81
consistent gets direct337,55493.3641.77
consistent gets from cache64,244,84217,768.867,949.13
consistent gets from cache (fastpath)59,047,04116,331.257,305.99
cursor authentications1,3310.370.16
data blocks consistent reads - undo records applied3240.090.04
db block changes457,313126.4856.58
db block gets423,813117.2252.44
db block gets direct3,8481.060.48
db block gets from cache419,965116.1551.96
db block gets from cache (fastpath)102,05528.2312.63
deferred (CURRENT) block cleanout applications16,8634.662.09
dirty buffers inspected40,50611.205.01
enqueue conversions1,6550.460.20
enqueue releases71,11119.678.80
enqueue requests71,14719.688.80
enqueue timeouts30.000.00
enqueue waits90.000.00
exchange deadlocks00.000.00
execute count237,78365.7729.42
failed probes on index block reclamation20.000.00
file io service time00.000.00
file io wait time886,234,458245,114.96109,655.34
free buffer inspected442,954122.5154.81
free buffer requested442,364122.3554.73
heap block compress8830.240.11
hot buffers moved to head of LRU48,72513.486.03
immediate (CR) block cleanout applications51,45814.236.37
immediate (CURRENT) block cleanout applications5,7331.590.71
index crx upgrade (positioned)56,99915.767.05
index crx upgrade (prefetch)00.000.00
index fast full scans (direct read)00.000.00
index fast full scans (full)4,5251.250.56
index fast full scans (rowid ranges)00.000.00
index fetch by key4,506,0301,246.28557.54
index scans kdiixs14,463,5481,234.53552.28
leaf node 90-10 splits1430.040.02
leaf node splits4590.130.06
lob reads340,51594.1842.13
lob writes3,4980.970.43
lob writes unaligned3,4980.970.43
logons cumulative2370.070.03
max cf enq hold time2,6210.720.32
messages received17,8804.952.21
messages sent17,8804.952.21
min active SCN optimization applied on CR20.000.00
no buffer to keep pinned count00.000.00
no work - consistent read gets59,503,18716,457.417,362.43
non-idle wait count1,530,801423.39189.41
non-idle wait time9,756,4032,698.431,207.18
opened cursors cumulative224,33362.0527.76
parse count (describe)200.010.00
parse count (failures)6410.180.08
parse count (hard)12,5813.481.56
parse count (total)175,18248.4521.68
parse time cpu54,87315.186.79
parse time elapsed69,69319.288.62
physical read IO requests435,958120.5853.94
physical read bytes6,326,091,7761,749,672.12782,738.40
physical read total IO requests445,751123.2955.15
physical read total bytes6,486,625,2801,794,072.52802,601.49
physical read total multi block requests8,9222.471.10
physical reads772,228213.5895.55
physical reads cache434,610120.2053.78
physical reads cache prefetch336,16692.9841.59
physical reads direct337,61893.3841.77
physical reads direct (lob)337,48893.3441.76
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests11,5943.211.43
physical write bytes547,954,688151,553.4567,799.39
physical write total IO requests23,9146.612.96
physical write total bytes658,880,000182,233.2081,524.38
physical write total multi block requests2,3210.640.29
physical writes66,88918.508.28
physical writes direct3,9081.080.48
physical writes direct (lob)720.020.01
physical writes direct temporary tablespace7420.210.09
physical writes from cache62,98117.427.79
physical writes non checkpoint61,61117.047.62
pinned buffers inspected60.000.00
pinned cursors current200.010.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use14,1543.911.75
process last non-idle time3,6061.000.45
queries parallelized00.000.00
recovery blocks read00.000.00
recursive calls732,905202.7190.68
recursive cpu usage86,43123.9110.69
redo blocks checksummed by FG (exclusive)26,2157.253.24
redo blocks read for recovery00.000.00
redo blocks written144,75740.0417.91
redo buffer allocation retries00.000.00
redo entries261,76872.4032.39
redo k-bytes read for recovery00.000.00
redo k-bytes read total00.000.00
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks3,3980.940.42
redo size69,334,20819,176.478,578.84
redo size for direct writes10,6122.941.31
redo subscn max counts57,59115.937.13
redo synch time9,6192.661.19
redo synch writes7,0621.950.87
redo wastage1,927,676533.16238.51
redo write time6950.190.09
redo writes10,0502.781.24
rollback changes - undo records applied230.010.00
rollbacks only - consistent read gets930.030.01
root node splits00.000.00
rows fetched via callback249,50069.0130.87
scheduler wait time362,568100.2844.86
session connect time00.000.00
session cursor cache hits162,54344.9620.11
session logical reads65,006,27017,979.458,043.34
shared hash latch upgrades - no wait113,61631.4214.06
shared hash latch upgrades - wait710.020.01
sorts (disk)00.000.00
sorts (memory)31,9398.833.95
sorts (rows)26,800,5467,412.503,316.08
sql area evicted11,9003.291.47
sql area purged6840.190.08
summed dirty queue length320,27388.5839.63
switch current to new buffer2,6570.730.33
table fetch by rowid29,945,1308,282.233,705.16
table fetch continued row3,103,865858.47384.05
table scan blocks gotten33,689,1709,317.764,168.42
table scan rows gotten410,645,221113,576.3650,809.85
table scans (direct read)00.000.00
table scans (long tables)130.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)32,3088.944.00
temp space allocated (bytes)1,048,576290.02129.74
total cf enq hold time6,6601.840.82
total number of cf enq holders530.010.01
total number of times SMON posted90.000.00
transaction rollbacks180.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size22,903,5126,334.662,833.89
user I/O wait time75,90720.999.39
user calls803,591222.2699.43
user commits8,0792.231.00
user rollbacks30.000.00
workarea executions - multipass00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal36,96310.224.57
write clones created in background00.000.00
write clones created in foreground150.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current262411
logons current4285
session uga memory max481,686,486,752483,010,199,408
session pga memory80,044,738,08880,259,805,256
session pga memory max107,042,605,272108,179,814,408
session cursor cache count3,487,9813,494,899
session uga memory141,566,566,682,408141,888,708,911,560

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)32.99

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Buffer Cache Reads3.3G27.12.9384360M0.000M98K3.23
Direct Reads2.6G93.33.7293420M0.000M0 
DBWR0M0.000M492M3.12.1360770 
Others153M2.72.04231639M0.64.01078610.9K50.63
LGWR1M0.02.00027672M2.83.0199139315.26
Direct Writes0M0.000M26M0.05.0071910 
Streams AQ0M0.000M0M0.000M20.00
TOTAL:6G123.181.71037629M6.65.173968109.1K7.99

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 File5.9G120.471.66639518M3.20.14326824.165.12
Control File154M2.71.04259335M0.63.00968054.56 
Log File0M0.000M71M2.81.0196370.00 
Temp File7M0.01.0019367M0.01.0019360.003.12
TOTAL:6G123.191.71092631M6.65.17452224.845.11

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Buffer Cache Reads 3.3G27.10.9384360M0.000M98K3.24
Buffer Cache Reads (Data File) 3.3G27.10.9384360M0.000M98K3.24
Direct Reads 2.6G93.34.7296180M0.000M0 
Direct Reads (Data File) 2.6G93.34.7296180M0.000M0 
DBWR 0M0.000M492M3.13.1360770 
DBWR (Data File) 0M0.000M492M3.13.1360770 
Others 154M2.72.04259339M0.64.010786983154.54
Others (Control File) 153M2.69.04231635M0.61.009680974154.78
Others (Data File) 1M0.02.0002764M0.03.0011069028.81
LGWR 1M0.02.00027672M2.83.0199136322.02
LGWR (Log File) 0M0.000M71M2.81.019637120.00
LGWR (Control File) 1M0.01.0002761M0.02.0002765127.20
Direct Writes 0M0.000M26M0.05.0071910 
Direct Writes (Data File) 0M0.000M26M0.05.0071910 
Streams AQ 0M0.000M0M0.000M20.00
Streams AQ (Data File) 0M0.000M0M0.000M20.00
TOTAL: 6G123.181.71092629M6.65.173968107.9K7.93

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TBS_DATA 330,718910.011.006000.00
TBS_STRADM 55,904151.824.475,5982210.00
TBS_IIS 15,54543.592.641,000040.00
TBS_ECDB_DAT 14,84642.056.712370210.00
SYSAUX 9,94435.403.662,909100.00
SYSTEM 3,71517.751.821,150000.00
TBS_ECDB_DATA 3,07813.971.58100110.00
TBS_ECDB_IND 2,11711.241.007000.00
UNDOTBS1 4102.201.00616090.00
TEMP 4001.2518.6341000.00
TBS_LOG 1102.731.0010000.00
TBS_TEST 1000.001.006000.00
USERS 500.001.003000.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)
SYSAUXD:\ORASYSDATA\ECDB\SYSAUX01.DBF 9,94435.403.662,909100.00
SYSTEMD:\ORASYSDATA\ECDB\SYSTEM01.DBF 3,71517.751.821,150000.00
TBS_DATAD:\ORADATA\ECDB\TBS_DAT01.DBF 172,797480.001.003000.00
TBS_DATAD:\ORADATA\ECDB\TBS_DAT02.DBF 157,921440.011.003000.00
TBS_ECDB_DATD:\ORADATA\ECDB\TBS_ECDB_DAT01.DBF 7,41122.126.801270210.00
TBS_ECDB_DATD:\ORADATA\ECDB\TBS_ECDB_DAT02.DBF 7,43521.986.62110000.00
TBS_ECDB_DATAC:\ORADATA\ECDB\TBS_DATA1.ORA 1,51903.681.5170110.00
TBS_ECDB_DATAC:\ORADATA\ECDB\TBS_DATA2.ORA 1,55904.251.653000.00
TBS_ECDB_INDD:\ORADATA\ECDB\TBS_ECDB_IND01.DBF 1,11800.961.003000.00
TBS_ECDB_INDD:\ORADATA\ECDB\TBS_ECDB_IND02.DBF 99901.551.004000.00
TBS_IISD:\ORADATA\ECDB\TBS_IIS01.ORA 8,55223.692.49759040.00
TBS_IISD:\ORADATA\ECDB\TBS_IIS02.ORA 6,99323.472.82241000.00
TBS_LOGD:\ORADATA\ECDB\TBS_LOG01.ORA 502.001.003000.00
TBS_LOGD:\ORADATA\ECDB\TBS_LOG02.ORA 603.331.007000.00
TBS_STRADMD:\ORADATA\ECDB\TBS_STRADM01.DBF 26,89171.674.412,824100.00
TBS_STRADMD:\ORADATA\ECDB\TBS_STRADM02.DBF 29,01381.954.522,7741210.00
TBS_TESTD:\ORADATA\ECDB\TBS_TEST1.ORA 500.001.003000.00
TBS_TESTD:\ORADATA\ECDB\TBS_TEST2.ORA 500.001.003000.00
TEMPD:\ORASYSDATA\ECDB\TEMP01.DBF 4001.2518.634100 
UNDOTBS1D:\ORASYSDATA\ECDB\UNDOTBS01.DBF 4102.201.00616090.00
USERSD:\ORASYSDATA\ECDB\USERS01.DBF 500.001.003000.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
D112,2909964,620,875434,66262,9780018
K63,040992,000190000

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00007,6990

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
B01122207139402044516588820445   
E011051243122195116588821951   

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
D800.0910365.518,993,738122780918.00
D1600.182084.022,067,44215215564.00
D2400.26302.1953,9161109185.00
D3200.35391.3934,086158895.00
D4000.44491.2229,939148378.00
D4800.53591.1427,960143359.00
D5600.61691.0926,875140608.00
D6400.70791.0626,142138750.00
D7200.79891.0425,553137256.00
D8000.88991.0225,093136089.00
D8800.961081.0124,732135173.00
D9121.001121.0024,606134853.00
D9601.051180.9924,407134350.00
D1,0401.141280.9824,091133547.00
D1,1201.231380.9723,809132832.00
D1,2001.321480.9623,565132213.00
D1,2801.401580.9523,362131698.00
D1,3601.491670.9423,144131146.00
D1,4401.581770.9322,888130496.00
D1,5201.671870.9022,058128392.00
D1,6001.751970.8821,743127593.00
K480.09646.1672713263.00
K960.19121.0016128.00
K1440.28181.0016128.00
K1920.38241.0016128.00
K2400.47301.0016128.00
K2880.56351.0016128.00
K3360.66411.0016128.00
K3840.75471.0016128.00
K4320.84531.0016128.00
K4800.94591.0016128.00
K5121.00631.0016128.00
K5281.03651.0016128.00
K5761.13711.0016128.00
K6241.22771.0016128.00
K6721.31831.0016128.00
K7201.41891.0016128.00
K7681.50951.0016128.00
K8161.591001.0016128.00
K8641.691061.0016128.00
K9121.781121.0016128.00
K9601.881181.0016128.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.0019,6180

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)
B512330419.871.690.40100.000.00102,400
E512303374.960.000.000.000.00102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K20,25320,25300
64K128K23423400
128K256K3,1563,15600
256K512K3,2343,23400
512K1024K2,2082,20800
1M2M6,0476,04700
2M4M1,3651,36500
4M8M20520500
8M16M16116100
16M32M595900
32M64M191900

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
640.1312,337,452.532,721,264.4182.0058,679131,210,723,006
1280.2512,337,452.532,571,127.8283.0044,923129,902,541,790
2560.5012,337,452.53242,970.8298.001,044109,616,672,573
3840.7512,337,452.53156,507.1599.00120108,863,290,888
5121.0012,337,452.532,680.09100.0014107,522,953,600
6141.2012,337,452.532,246.36100.000107,519,174,447
7171.4012,337,452.531,850.35100.000107,515,723,889
8191.6012,337,452.531,584.26100.000107,513,405,366
9221.8012,337,452.531,146.87100.000107,509,594,245
1,0242.0012,337,452.53664.08100.000107,505,387,623
1,5363.0012,337,452.530.00100.000107,499,601,269
2,0484.0012,337,452.530.00100.000107,499,601,269
3,0726.0012,337,452.530.00100.000107,499,601,269
4,0968.0012,337,452.530.00100.000107,499,601,269

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)
4640.49212,73810,212,2271.00168,5871.2467,447
5600.5911913,52110,217,5761.00163,2381.20313,152
6560.6921517,37610,237,9311.00142,8831.05314,401
7520.8031121,34910,241,5741.00139,2401.02314,740
8480.9040725,24110,243,2231.00137,5911.01314,943
9441.0050229,30810,244,3591.00136,4551.00315,078
1,0401.1059833,47810,245,1641.00135,6500.99315,180
1,1361.2069437,53210,245,8471.00134,9670.99315,267
1,2321.3179041,54410,246,5111.00134,3030.98315,350
1,3281.4188645,46510,247,0471.00133,7670.98315,420
1,4241.5198249,53210,247,5481.00133,2660.98315,485
1,5201.611,07853,43210,248,0001.00132,8140.97315,543
1,6161.711,17457,51710,248,3571.00132,4570.97315,590
1,7121.811,26961,73110,248,6951.00132,1190.97315,634
1,8081.921,36565,94010,249,0211.00131,7930.97315,676
1,9042.021,46169,88710,249,3111.00131,5030.96315,716

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,2800.5023,832,1249,185,986,655
1,9200.751,059,74428,557,604
2,5601.001,048,31724,605,897
3,2001.251,041,18822,529,159
3,8401.501,037,62922,209,283
4,4801.751,036,26622,209,283
5,1202.001,036,26822,209,283

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
1281.000000
1441.130000
1601.250000
1761.380000
1921.500000
2081.630000
2241.750000
2401.880000
2562.000000
2722.130000
2882.250000
3042.380000
3202.500000

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 block906
undo header900

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 1,0351,035010140.00
TX-Transaction (index contention) 440408.00
CR-Reuse Block Range (block range reuse ckpt) 1,2631,2630200.00
RO-Multiple Object Reuse (fast object reuse) 18180200.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
23.5912,0701,270616.8/36.30/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
10-1月 22:57701,0156743260/00/0/0/0/0/0
10-1月 22:47501,5571,2703360/00/0/0/0/0/0
10-1月 22:37739836613260/00/0/0/0/0/0
10-1月 22:271282,7413576170/00/0/0/0/0/0
10-1月 22:17821,1219553270/00/0/0/0/0/0
10-1月 22:073,1834,6533476170/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM db client latch2,3600.00 00 
ASM map operation hash table10.00 00 
ASM network state latch620.00 00 
AWR Alerted Metric Element list28,7410.00 00 
Change Notification Hash table latch1,2070.00 00 
Consistent RBA10,0570.00 00 
DML lock allocation28,6970.00 00 
Event Group Locks1630.00 00 
FOB s.o list latch1,1270.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch10.00 08,8850.01
JS Sh mem access911.111.0000 
JS mem alloc latch190.00 00 
JS queue access latch200.00 00 
JS queue state obj latch25,7920.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,0430.00 00 
KTF sga latch180.00 09600.00
KWQMN job cache list latch30.00 00 
KWQP Prop Status4520.00 00 
KWQS pqsubs latch40.00 00 
KWQS pqueue ctx latch750.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,0430.00
Memory Queue4560.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 Latch200.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process9520.00 00 
OS process allocation1,7120.00 00 
OS process: request allocation2810.00 00 
PL/SQL warning settings8,1360.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch3,5130.00 00 
SGA IO buffer pool latch30,8500.000.00030,8560.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 09230.00
SQL memory manager workarea list latch100,2290.00 00 
Shared B-Tree3,0060.00 00 
Streams Generic2290.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 latch7,8990.00 00 
active service list8,2070.00 02,3980.00
begin backup scn array1990.00 00 
bq:time manger info latch1280.00 00 
buffer pool10.00 00 
bufq statistics4560.00 00 
business card10.00 00 
cache buffer handles29,0500.010.0000 
cache buffers chains126,639,1120.140.0012,013,8830.00
cache buffers lru chain79,0980.070.0002,097,6750.01
cache table scan latch0  030,0310.00
call allocation4,2630.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch3130.00 00 
channel operations parent latch18,5250.00 00 
checkpoint queue latch387,3660.000.00061,2090.00
client/application info2,1740.00 00 
compile environment latch2370.00 00 
corrupted undo seg latch870.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch620.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch620.00 00 
dml lock allocation660.00 00 
done queue latch10.00 00 
dummy allocation4320.00 00 
enqueue hash chains143,8730.010.0000 
enqueues89,8770.050.0000 
fifth spare latch10.00 00 
file cache latch6490.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 SGA630.00 00 
global tx hash mapping370.00 00 
granule operation10.00 00 
hash table column usage latch5410.180.00017,368,2570.03
hash table modification latch960.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch240.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch730.00 0721.39
job_queue_processes free list latch1530.00 00 
job_queue_processes parameter latch8430.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch30.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats75,2480.060.0000 
kokc descriptor allocation latch1,0270.00 00 
ksfv messages10.00 00 
kss move lock410.00 00 
ksuosstats global area2450.00 00 
ksv allocation latch1420.00 00 
ksv class latch810.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch2810.00 00 
ktm global data360.00 00 
kwqbsn:qsga2,2130.00 00 
lgwr LWN SCN10,4550.380.0000 
list of block allocation6230.00 00 
loader state object freelist638,9300.270.0100 
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 parent2300.00 01560.00
mapped buffers lru chain10.00 00 
message pool operations parent latch7600.00 00 
messages92,2290.100.0000 
mostly latch-free SCN10,4310.360.0800 
msg queue latch10.00 00 
multiblock read objects105,9700.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch620.00 00 
object queue header heap65,9840.00 02,4180.00
object queue header operation1,075,7680.010.0000 
object stats modification1490.00 00 
parallel query alloc buffer4650.00 00 
parallel query stats10.00 00 
parameter list9120.00 00 
parameter table management4340.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue10,7690.00 07,1250.00
process allocation3800.00 01620.00
process group creation2810.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch3,8212.410.9700 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation31,2640.080.000261,7800.01
redo copy10.00 0261,7880.02
redo writing40,0730.00 00 
resmgr group change latch5220.00 00 
resmgr:active threads1,2130.00 06110.00
resmgr:actses change group2010.00 00 
resmgr:actses change state240.00 00 
resmgr:free threads list4610.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method40.00 00 
resmgr:schema config8390.00 0610.00
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects31,081,0700.090.0001,1490.26
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second spare latch10.00 00 
sequence cache25,8180.010.0000 
session allocation23,2700.00 07,7830.00
session idle bit1,614,6100.040.0100 
session queue latch10.00 00 
session state list latch4110.00 00 
session switching6580.00 00 
session timer1,3040.00 00 
shared pool919,5770.240.1100 
shared pool sim alloc10.00 00 
shared pool simulator126,5190.000.0000 
sim partition latch10.00 00 
simulator hash latch5,394,1990.000.0200 
simulator lru latch57,4600.270.0005,288,9530.65
sort extent pool2730.00 00 
space background state object latch60.00 00 
space background task latch2,4270.120.3302,0860.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain30.00 00 
temp lob duration state obj allocation50.00 00 
temporary table state object allocation30.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch2170.00 00 
transaction allocation1,2850.00 00 
transaction branch allocation1,3160.00 00 
undo global data91,3840.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains126,639,112175,623112175,514
row cache objects31,081,07027,35211027,245
shared pool919,5772,1832351,954
loader state object freelist638,9301,727171,710
session idle bit1,614,6106246618
simulator hash latch5,394,1991162114
qmn task queue latch3,82192893
mostly latch-free SCN10,43138335
space background task latch2,427312
JS Sh mem access9110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
JS Sh mem accessjsksGetShMemLatch011
PC and Classifier lists for WLMNo latch010
cache buffers chainskcbgtcr: fast path (cr pin)08923
cache buffers chainskcbrls_1041108
cache buffers chainskcbgtcr: fast path010
cache buffers chainskcbgtcr_2010
lgwr LWN SCNkcs023020
loader state object freelistkcblfs099
loader state object freelistkcblgs088
mostly latch-free SCNkcslcu3013
qmn task queue latchkwqmnmvtsks: delay to ready list0890
resmgr:resource group CPU methodkgkpgpickfirst020
resmgr:resource group CPU methodkgkprraddtorl025
resmgr:resource group CPU methodkgkprrpicknext010
row cache objectskqreqd: reget0851
row cache objectskqrpre: find obj01898
row cache objectskqreqd048
row cache objectskqrso033
session idle bitksupuc: clear busy072
session idle bitksupuc: set busy016
shared poolkghalp010085
shared poolkghalo097101
shared poolkghupr103336
shared poolkghasp021
shared poolkghfre024
shared poolkgh_heap_sizes018
simulator hash latchkcbsacc: lookup dba022

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor PinkksCheckCursor [KKSCHLBRKN]69,451,8950
Cursor PinkksLockDelete [KKSCHLPIN6]42,228,7480
Cursor Pinkkslce [KKSCHLPIN2]78,420-10
Library Cachekglhdgn2 106701

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
ECDBTBS_DATASW_PRODUCTS TABLE34,443,21652.98
ECDBTBS_ECDB_DATSW_INFO TABLE11,282,19217.36
ECDBTBS_ECDB_INDIND_PSP_PROD_PRICE INDEX7,121,53610.96
ECDBTBS_ECDB_DATPRODUCT_SALE_PRICE TABLE3,855,5205.93
ECDBTBS_ECDB_DATSW_PRODUCTS_TEMP TABLE3,781,7445.82

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,60442.81
ZYDTBS_STRADMINVENTORY TABLE218,10228.24
ECDBTBS_ECDB_DATPRODUCT_SALE_PRICE_LOG TABLE68,8808.92
IISTBS_IISSW_IIS_LOG TABLE28,3423.67
IISTBS_IISSW_PAGE_VIEW_LOG TABLE9,2331.20

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,31975.77
ZYDTBS_STRADMINVENTORY TABLE47,81510.97
IISTBS_IISSW_PAGE_VIEW_LOG TABLE9,2332.12
IISTBS_IISSW_IIS_LOG TABLE2,8820.66
ECDBTBS_ECDB_DATPRODUCT_SALE_PRICE_LOG TABLE2,2400.51

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,31975.77
ZYDTBS_STRADMINVENTORY TABLE47,81510.97
IISTBS_IISSW_PAGE_VIEW_LOG TABLE9,2332.12
IISTBS_IISSW_IIS_LOG TABLE2,8820.66
ECDBTBS_ECDB_DATPRODUCT_SALE_PRICE_LOG TABLE2,2400.51

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
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,61597.93
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB640.02

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
ZYDTBS_STRADMINVENTORY TABLE51,68277.27
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED1,9182.87
SYSSYSTEMHISTGRM$ TABLE1,2281.84
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX9941.49
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED9061.35

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
ZYDTBS_STRADMINVENTORY TABLE5,59248.23
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX7646.59
SYSSYSTEMHISTGRM$ TABLE6285.42
SYSSYSAUXI_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX4423.81
IISTBS_IISIND_MODULE_COL INDEX3192.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED1,92349.21
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED91123.31
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_2594257367_11566TABLE PARTITION2005.12
SYSSYSAUXSYS_LOB0000005778C00040$$ LOB551.41
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB150.38

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
ECDBTBS_ECDB_DATAIND_PROD_TEMP_SID INDEX1,46832.35
ECDBTBS_DATAPK_E_PRODUCTS_0604 INDEX2475.44
ECDBTBS_DATAIND_PRODUCT_TYPEID_0604 INDEX2194.83
ECDBTBS_ECDB_DATAIND_PRODUCT_SDELL INDEX1954.30
ECDBTBS_ECDB_DATAIND_PROD_NOR_ONSALE INDEX1954.30

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSSYSTEMHISTGRM$ TABLE61,95229.60
SYSSYSTEMI_H_OBJ#_COL# INDEX60,33628.83
ZYDTBS_STRADMINVENTORY TABLE51,23224.48
IISTBS_IISSW_IIS_LOG TABLE6,5123.11
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX5,3602.56

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
IISTBS_IISPK_PAGE_VIEW_LOG INDEX4100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
IISTBS_IISPK_PAGE_VIEW_LOG INDEX4100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control2840.000 21
dc_constraints44133.330 4411
dc_files20100.000 020
dc_global_oids8360.720 0126
dc_histogram_data425,9180.890 3,7172,994
dc_histogram_defs206,6942.590 2,0832,679
dc_object_grants37812.700 0121
dc_objects717,5490.060 942,044
dc_profiles1410.000 01
dc_rollback_segments8800.000 022
dc_segments200,6390.090 781,542
dc_sequences4440.680 4449
dc_table_scns20100.000 00
dc_tablespaces4,501,3460.000 014
dc_users4,590,5250.000 0136
global database name2,5090.000 01
outstanding_alerts702.860 213
sch_lj_objs60.000 03
sch_lj_oids60.000 010


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY2,5050.2421,1600.0420
CLUSTER3190.941432.1000
DBLINK1700.590 00
EDITION1520.002870.0000
INDEX1,8787.511,53118.03220
OBJECT ID20100.000 00
QUEUE1,1010.001,2540.0810
RULESET20.0020.0000
SCHEMA5780.170 00
SQL AREA48,36670.39723,4775.031,296842
SUBSCRIPTION137.69137.6900
TABLE/PROCEDURE130,0260.17123,9241.086230
TEMPORARY INDEX13684.56136100.00210
TEMPORARY TABLE37026.49370100.002720
TRIGGER5250.006,5350.0000


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache912.00912.00912.00928.000SHR/IMM
KEEP buffer cache512.00512.00512.00512.000INI/
PGA Target512.00512.00512.00512.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target2,560.002,560.002,560.002,560.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool16.0016.0016.0016.000STA/
large pool16.0016.0016.0016.000STA/
shared pool944.00944.00928.00944.000GRO/IMM
streams pool128.00128.00128.00128.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BFreeable247.060.009.1529.84152 2727
 Other161.90 3.684.46142644444
 PL/SQL6.953.010.170.55344242
 SQL3.971.350.140.302582923
EOther189.07 2.173.04143228787
 Freeable178.060.002.5811.1793 6969
 PL/SQL5.141.030.060.34348585
 SQL2.770.740.040.050617267

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers1,493,172,224 
Fixed Size2,178,736 
Redo Buffers19,382,272 
Variable Size1,157,628,240 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool7.817.810.00
largefree memory8.198.190.00
sharedCCUR77.8178.681.11
sharedFileOpenBlock10.5010.500.00
sharedKGLHD26.9727.271.09
sharedPCUR87.6487.750.13
sharedSQLA402.41399.55-0.71
sharedXDBSC9.589.580.00
shareddb_block_hash_buckets11.1311.130.00
sharedfree memory152.07158.594.28
sharedkglsim object batch12.6112.610.00
streamsapply shared t56.6156.610.00
streamsfree memory71.3771.370.00
streamskod objects3.993.990.00
 buffer_cache1,424.001,424.000.00
 fixed_sga2.082.080.00
 log_buffer18.4818.480.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)
Propagation Receiver1222 02:25:150.190.000.00
QMON Slaves1222 02:19:470.030.010.00
QMON Coordinator1222 02:19:340.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

Apply NameCoord Txns RcvdCoord Txns AppliedCoord Txns RollbkdCoord Wait Deps%Coord Wait Comit%Server Mesgs AppliedServer Dequeue Time(s)Server Apply Time(s)Reader Dequeue MesgsReader Lag (s)
APPLY 0000.000.0000.000.001140.00

Back to Streams Statistics
Back to Top

Streams Apply Rate

Apply NameCoord Txns Rcvd/secCoord Txns Appl/secCoord Txns Rbk/secServer Msgs Appl/secServer Dequeue Time/msgServer Apply Time/msgReader Dequeue Msgs/sec
APPLY 0.000.000.000.00  0.03

Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
STRADM.ECDB_QUEUE(99530) 1140.031140.0300.000.00

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Subscriber/QueueEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
APPLY(1)/STRADM.ECDB_QUEUE 1140.031140.0300.000.00

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 20100.000.003.030.000.000.01
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(66567) 61610.000.0010.035.220.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.001.51 
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_TASK_Q(66567) 0.020.020.160.09

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
ECORA_01_3938_ECDB(41)/SYS.ALERT_QUE 2000.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,6480.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,6480.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
aq_tm_processes2  
audit_file_destC:\APP\ADMINISTRATOR\ADMIN\ECDB\ADUMP  
audit_trailDB  
compatible11.2.0.0.0  
control_filesD:\ORASYSDATA\ECDB\CONTROL01.CTL, C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ECDB\CONTROL02.CTL  
db_block_size8192  
db_cache_size922746880  
db_domain    
db_file_multiblock_read_count32  
db_keep_cache_size536870912  
db_nameECDB  
db_recovery_file_destC:\app\Administrator\flash_recovery_area  
db_recovery_file_dest_size4102029312  
diagnostic_destC:\APP\ADMINISTRATOR  
dispatchers(PROTOCOL=TCP) (SERVICE=ECDBXDB)  
job_queue_processes10  
nls_date_formatYYYY-MM-DD  
nls_languageSIMPLIFIED CHINESE  
nls_territoryCHINA  
open_cursors500  
optimizer_modeCHOOSE  
pga_aggregate_target536870912  
processes150  
remote_login_passwordfileEXCLUSIVE  
sec_case_sensitive_logonFALSE  
session_cached_cursors150  
sga_max_size2684354560  
sga_target2684354560  
shared_pool_size805306368  
streams_pool_size134217728  
undo_tablespaceUNDOTBS1  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report d>28,3423.67 IISTBS_IISSW_PAGE_VIEW_LOG TABLE9,2331.20

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,31975.77
ZYDTBS_STRADMINVENTORY TABLE47,81510.97
IISTBS_IISSW_PAGE_VIEW_LOG TABLE9,2332.12
IISTBS_IISSW_IIS_LOG TABLE2,8820.66
ECDBTBS_ECDB_DATPRODUCT_SALE_PRICE_LOG TABLE2,2400.51

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,31975.77
ZYDTBS_STRADMINVENTORY TABLE47,81510.97
IISTBS_IISSW_PAGE_VIEW_LOG TABLE9,2332.12
IISTBS_IISSW_IIS_LOG TABLE2,8820.66
ECDBTBS_ECDB_DATPRODUCT_SALE_PRICE_LOG TABLE2,2400.51

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
ECDBTBS_DATASYS_LOB0000102469C00046$$ LOB330,61597.93
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB640.02

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
ZYDTBS_STRADMINVENTORY TABLE51,68277.27
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED1,9182.87
SYSSYSTEMHISTGRM$ TABLE1,2281.84
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX9941.49
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED9061.35

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
ZYDTBS_STRADMINVENTORY TABLE5,59248.23
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX7646.59
SYSSYSTEMHISTGRM$ TABLE6285.42
SYSSYSAUXI_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX4423.81
IISTBS_IISIND_MODULE_COL INDEX3192.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED1,92349.21
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED91123.31
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_2594257367_11566TABLE PARTITION2005.12
SYSSYSAUXSYS_LOB0000005778C00040$$ LOB551.41
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB150.38

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
ECDBTBS_ECDB_DATAIND_PROD_TEMP_SID INDEX1,46832.35
ECDBTBS_DATAPK_E_PRODUCTS_0604 INDEX2475.44
ECDBTBS_DATAIND_PRODUCT_TYPEID_0604 INDEX2194.83
ECDBTBS_ECDB_DATAIND_PRODUCT_SDELL INDEX1954.30
ECDBTBS_ECDB_DATAIND_PROD_NOR_ONSALE INDEX1954.30

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSSYSTEMHISTGRM$ TABLE61,95229.60
SYSSYSTEMI_H_OBJ#_COL# INDEX60,33628.83
ZYDTBS_STRADMINVENTORY TABLE51,23224.48
IISTBS_IISSW_IIS_LOG TABLE6,5123.11
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX5,3602.56

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits