ITPub博客

首页 > Linux操作系统 > Linux操作系统 > awrrpt_1_9716_9717.html

awrrpt_1_9716_9717.html

原创 Linux操作系统 作者:yagerya 时间:2013-07-04 17:58:15 0 删除 编辑


AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9716-9717

body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}
pre.awr  {font:8pt Courier;color:black; background:White;}
h1.awr     {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}
h2.awr     {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
h3.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;}
th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}
th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}
td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}
td.awrc    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}
td.awrnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;}
td.awrncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;}
td.awrncrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-right: thin solid black;}
td.awrcrb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-right: thin solid black;}
td.awrclb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;}
td.awrcbb    {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;border-right: thin solid black;}
a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}
td.awrnct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:White;vertical-align:top;}
td.awrct   {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:#FFFFCC; vertical-align:top;}
td.awrnclbt  {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-left: thin solid black;}
td.awrncbbt  {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;border-top: thin solid black;}
td.awrncrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-right: thin solid black;}
td.awrcrbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-right: thin solid black;}
td.awrclbt     {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;}
td.awrcbbt   {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;border-right: thin solid black;}
table.tdiff {  border_collapse: collapse; }


WORKLOAD REPOSITORY report for






DB NameDB IdInstanceInst numStartup TimeReleaseRAC
MYCAR1652681432mycar126-Mar-13 18:0311.2.0.1.0NO






Host NamePlatformCPUsCoresSocketsMemory (GB)
vm192168000035Linux x86 64-bit   4   4   4    8.00








Snap IdSnap TimeSessionsCursors/Session
Begin Snap:971604-Jul-13 14:00:18102      3.6
End Snap:971704-Jul-13 14:57:50117      3.5
Elapsed:            57.53 (mins)  
DB Time:            624.29 (mins)  


Report Summary



Cache Sizes






BeginEnd
Buffer Cache:       784M       784MStd Block Size:           8K
Shared Pool Size:     1,264M     1,264MLog Buffer:    15,596K

Load Profile



















Per SecondPer TransactionPer ExecPer Call
DB Time(s):          10.9         9.6      0.03        0.01
DB CPU(s):            2.2           1.9     0.01    0.00
Redo size:          4,232.5        3,755.4  
Logical reads:        6,564.1       5,824.2  
Block changes:          18.4           16.3  
Physical reads:           593.7          526.8  
Physical writes:        1.1           1.0  
User calls:         1,250.7        1,109.7  
Parses:         355.0           314.9  
Hard parses:           0.1             0.1  
W/A MB processed:         3.2           2.8  
Logons:         0.1        0.1  
Executes:           356.2         316.1  
Rollbacks:            0.0           0.0  
Transactions:             1.1   


Instance Efficiency Percentages (Target 100%)








Buffer Nowait %:         99.98Redo NoWait %:         100.00
Buffer  Hit   %:           99.82In-memory Sort %:        100.00
Library Hit   %:         99.95Soft Parse %:         99.98
Execute to Parse %:           0.36Latch Hit %:        99.97
Parse CPU to Parse Elapsd %:         12.06% Non-Parse CPU:        99.87


Shared Pool Statistics







BeginEnd
Memory Usage %:          73.46        73.55
% SQL with executions>1:        95.96         94.95
% Memory for SQL w/exec>1:        94.48          93.06


Top 5 Timed Foreground Events










EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 7,552 20.16 
db file sequential read24,5941,272523.40User I/O
log file sync4,1331,0532552.81Commit
read by other session4,133223540.60User I/O
enq: KO - fast object checkpoint225123130.14Application


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





Load Average BeginLoad Average End%User%System%WIO%Idle
   0.00   8.31  38.1  16.4   0.3  45.4

Instance CPU





%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
      54.6     99.9     0.0

Memory Statistics








BeginEnd
Host Mem (MB):     8,192.0     8,192.0
SGA use (MB):       2,144.0       2,144.0
PGA use (MB):       451.7    486.3
% Host Mem used for SGA+PGA:    31.69   32.11



Main Report




Back to Top




Wait Events Statistics



Back to Top



Time Model Statistics



  • Total time in database user-calls (DB Time): 37457.6s

  • Statistics including the word "background" measure background process
       time, and so do not contribute to the DB time statistic

  • Ordered by % or DB time desc, Statistic name


















Statistic NameTime (s)% of DB Time
sql execute elapsed time34,272.8291.50
PL/SQL execution elapsed time17,487.7246.69
DB CPU7,552.3920.16
parse time elapsed95.450.25
connection management call elapsed time64.350.17
hard parse elapsed time30.670.08
sequence load elapsed time0.290.00
PL/SQL compilation elapsed time0.290.00
hard parse (sharing criteria) elapsed time0.280.00
failed parse elapsed time0.090.00
repeated bind elapsed time0.000.00
hard parse (bind mismatch) elapsed time0.000.00
DB time37,457.57 
background elapsed time1,669.46 
background cpu time1.75 


Back to Wait Events Statistics

Back to Top



Operating System Statistics



  • *TIME statistic values are diffed.     All others display actual values.  End Value is displayed if different

  • ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name























StatisticValueEnd Value
BUSY_TIME756,139 
IDLE_TIME628,563 
IOWAIT_TIME3,903 
NICE_TIME0 
SYS_TIME226,510 
USER_TIME528,138 
LOAD08
RSRC_MGR_CPU_WAIT_TIME0 
PHYSICAL_MEMORY_BYTES8,589,934,592 
NUM_CPUS4 
NUM_CPU_CORES4 
NUM_CPU_SOCKETS4 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 


Back to Wait Events Statistics

Back to Top



Operating System Statistics - Detail







Snap TimeLoad%busy%user%sys%idle%iowait
04-Jul 14:00:180.00     
04-Jul 14:57:508.3154.6138.1416.3645.390.28


Back to Wait Events Statistics

Back to Top



Foreground Wait Class



  • s  - second, ms - millisecond -    1000th of a second

  • ordered by wait time desc, waits desc

  • %Timeouts: value of 0 indicates value was < .5%.  Value of null is truly 0

  • Captured Time accounts for       27.5%  of Total DB time    37,457.57 (s)

  • Total FG Wait Time:        2,745.45 (s)  DB CPU time:     7,552.39 (s)












Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  7,552 20.16
User I/O49,99801,530314.08
Commit4,13301,0532552.81
Concurrency2221964310.26
Application4805210910.14
Network3,160,0440800.02
Other187,690100600.02
Configuration100000.00
System I/O820000.00


Back to Wait Events Statistics

Back to Top



Foreground Wait Events



  • s  - second, ms - millisecond -    1000th of a second

  • Only events with Total Wait Time (s) >= .001 are shown

  • ordered by wait time desc, waits desc (idle events last)

  • %Timeouts: value of 0 indicates value was < .5%.  Value of null is truly 0

































EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
db file sequential read24,59401,272526.323.40
log file sync4,13301,0532551.062.81
read by other session4,1330223541.060.60
enq: KO - fast object checkpoint2205123130.010.14
library cache: mutex X1004847730.000.13
direct path read17,66903124.540.08
latch: cache buffers chains1500291940.040.08
cursor: pin S9099970.000.02
SQL*Net message to client3,107,453070798.830.02
reliable message22541930.010.01
direct path sync10332800.000.01
enq: TX - index contention10033090.000.01
latch: shared pool11032530.000.01
cursor: mutex S310027600.000.01
enq: TX - row lock contention13011130.000.00
SQL*Net more data to client47,48101012.210.00
buffer busy waits1301800.000.00
asynch descriptor resize187,6611001048.240.00
latch: row cache objects8011010.000.00
db file parallel read901620.000.00
latch: object queue header operation1004540.000.00
latch: cache buffers lru chain1004430.000.00
Disk file operations I/O3970000.100.00
SQL*Net more data from client5,1100001.310.00
db file scattered read3,1910000.820.00
enq: SQ - contention100000.000.00
SQL*Net break/reset to client130000.000.00
latch: In memory undo latch80000.000.00
SQL*Net message from client3,107,4420127,53241798.83 
jobq slave wait6,9831003,5405071.80 


Back to Wait Events Statistics

Back to Top



Background Wait Events



  • ordered by wait time desc, waits desc (idle events last)

  • Only events with Total Wait Time (s) >= .001 are shown

  • %Timeouts: value of 0 indicates value was < .5%.  Value of null is truly 0


































EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write8,9100661742.2939.61
control file parallel write1,09803783440.2822.62
db file async I/O submit88503303730.2319.78
os thread startup128023518350.0314.07
direct path sync201679520.000.95
log file sync30518040.000.32
latch: shared pool30517610.000.32
control file sequential read5,4450511.400.27
enq: CF - contention20316110.000.19
db file sequential read5701140.010.05
latch: call allocation2001260.000.02
latch: cache buffers chains1002400.000.01
ADR block file read130030.000.00
Disk file operations I/O850000.020.00
db file parallel read320010.010.00
ADR file lock60010.000.00
LGWR wait for redo copy80010.000.00
asynch descriptor resize303100000.080.00
direct path write90000.000.00
ADR block file write50000.000.00
rdbms ipc message18,8447573,23538864.84 
DIAG idle wait6,8691006,92110081.77 
shared server idle wait1161003,482300160.03 
Streams AQ: qmn slave idle wait24603,475141240.06 
Streams AQ: qmn coordinator idle wait373333,47593150.10 
pmon timer1,257903,46127530.32 
Space Manager: slave idle wait5431003,44363400.14 
dispatcher timer571003,421600140.01 
smon timer12923,3002750090.00 
SQL*Net message from client4920781590.13 
class slave wait17031790.00 


Back to Wait Events Statistics

Back to Top



Wait Event Histogram



  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

  • % of Waits: value of .0 indicates value was <.05%; value of null is truly 0

  • % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms

  • Ordered by Event (idle events last)




























































  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s  >1s
ADR block file read1376.9   23.1   
ADR block file write5100.0       
ADR file lock683.3  16.7    
Disk file operations I/O48299.6.4      
LGWR wait for redo copy887.5  12.5    
SQL*Net break/reset to client13100.0       
SQL*Net message to client3108.3K100.0.0.0.0  .0 
SQL*Net more data from client511299.9.0 .0 .0  
SQL*Net more data to client47.5K100.0.0    .0 
asynch descriptor resize188K100.0.0.0   .0 
buffer busy waits1361.5     38.5 
control file parallel write109849.72.5.3.8.9.934.910.0
control file sequential read552799.9     .0.0
cursor: mutex S366.7      33.3
cursor: pin S966.7 11.1    22.2
db file async I/O submit88535.613.75.3.91.2.730.412.2
db file parallel read4139.039.0  7.3 14.6 
db file scattered read3191100.0       
db file sequential read24.7K77.11.51.12.02.5.515.1.3
direct path read17.7K98.61.1.0.0.0 .2.0
direct path sync3   33.3   66.7
direct path write13100.0       
enq: CF - contention2      50.050.0
enq: KO - fast object checkpoint2213.6 9.1   22.754.5
enq: SQ - contention10100.0       
enq: TX - index contention1010.0 10.050.010.0 10.010.0
enq: TX - row lock contention13 15.438.5 7.7 38.5 
latch free7100.0       
latch: In memory undo latch8100.0       
latch: cache buffers chains15143.02.0.7 1.3 51.02.0
latch: cache buffers lru chain1      100.0 
latch: call allocation250.0     50.0 
latch: object queue header operation1      100.0 
latch: redo allocation1100.0       
latch: row cache objects812.5 25.0 25.0 37.5 
latch: shared pool1457.1     21.421.4
library cache: mutex X1010.0     30.060.0
log file parallel write891282.7.7.4.5.6.313.61.2
log file sync413759.42.71.31.01.3.926.37.2
os thread startup128     53.125.021.9
read by other session413373.41.91.52.92.4.617.1.2
reliable message2365.2     30.44.3
DIAG idle wait6869      93.36.7
SQL*Net message from client3108.3K94.42.3.5.2.3.21.9.2
Space Manager: slave idle wait543.2      99.8
Streams AQ: qmn coordinator idle wait37362.7.3  .3 3.533.2
Streams AQ: qmn slave idle wait24649.6      50.4
class slave wait1788.2      11.8
dispatcher timer57       100.0
jobq slave wait6984.0.0 .0.0.099.9.0
pmon timer12575.4.1.1 .3.21.892.0
rdbms ipc message18.8K5.9.92.32.15.01.024.358.5
shared server idle wait116       100.0
smon timer128.3      91.7


Back to Wait Events Statistics

Back to Top



Wait Event Histogram Detail (64 msec to 2 sec)



  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

  • Units for % of Total Waits:     ms is milliseconds    s is 1024 milliseconds (approximately 1 second)

  • % of Total Waits: total waits for all wait classes, including Idle

  • % of Total Waits: value of .0 indicates value was <.05%;     value of null is truly 0

  • Ordered by Event (only non-idle events are displayed)

































  % of Total Waits
EventWaits 64ms  to 2s<32ms<64ms<1/8s<1/4s<1/2s  <1s  <2s>=2s
SQL*Net message to client5100.0.0.0.0.0   
SQL*Net more data to client1100.0    .0  
asynch descriptor resize1100.0   .0   
buffer busy waits561.5 7.723.17.7   
control file parallel write48455.11.12.13.79.218.89.2.8
control file sequential read399.9    .0.0 
cursor: pin S177.8     11.111.1
db file async I/O submit33557.41.23.26.210.69.27.54.7
db file parallel read685.47.34.92.4    
db file sequential read379484.6.43.24.05.42.1.3.0
direct path read3399.8.0.0.0.1.1 .0
enq: CF - contention1    50.0  50.0
enq: KO - fast object checkpoint522.7  4.54.513.6 54.5
enq: TX - index contention180.0    10.0 10.0
enq: TX - row lock contention561.57.7 7.723.1   
latch: cache buffers chains8047.01.34.611.927.85.32.0 
latch: cache buffers lru chain1    100.0   
latch: call allocation150.0  50.0    
latch: object queue header operation1    100.0   
latch: row cache objects362.5 12.512.512.5   
latch: shared pool557.1   14.37.114.37.1
library cache: mutex X310.010.0  10.010.0 60.0
log file parallel write131585.2.51.42.84.64.21.2.0
log file sync133866.51.12.24.48.110.46.11.1
os thread startup3353.114.15.51.6.83.1.821.1
read by other session71582.7.63.64.56.51.8.2.0
reliable message865.2 8.7 13.08.74.3 


Back to Wait Events Statistics

Back to Top



Wait Event Histogram Detail (4 sec to 2 min)



  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

  • Units for % of Total Waits:    s is 1024 milliseconds (approximately 1 second)    m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)

  • % of Total Waits: total waits for all wait classes, including Idle

  • % of Total Waits: value of .0 indicates value was <.05%;     value of null is truly 0

  • Ordered by Event (only non-idle events are displayed)






















  % of Total Waits
EventWaits 4s     to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
control file parallel write999.2.7 .1    
cursor: mutex S166.733.3      
cursor: pin S188.9 11.1     
db file async I/O submit4295.34.2.6     
db file sequential read4100.0.0 .0    
direct path read2100.0.0 .0    
direct path sync233.333.3 33.3    
enq: CF - contention150.050.0      
enq: KO - fast object checkpoint1245.536.418.2     
enq: TX - index contention190.010.0      
latch: shared pool192.97.1      
library cache: mutex X640.020.010.030.0    
log file parallel write4100.0.0.0.0    
log file sync4798.9.7.3.1    
os thread startup2778.91.610.28.6.8   
read by other session1100.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



  • ordered by DB Time







Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS37,3397,5472,04622,579
mycar1185051
SYS$BACKGROUND00324
mycarXDB0000


Back to Wait Events Statistics

Back to Top



Service Wait Class Stats



  • Wait Class info for services in the Service Statistics section. 

  • Total Waits and Time Waited displayed for the following wait      classes:  User I/O, Concurrency, Administrative, Network

  • Time Waited (Wt Time) in seconds









Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS499941530221960031598218
mycar4000002230
SYS$BACKGROUND185171302360000


Back to Wait Events Statistics

Back to Top





SQL Statistics



Back to Top



SQL ordered by Elapsed Time



  • Resources reported for PL/SQL code includes the resources used by all SQL     statements called by the code.

  • % Total DB Time is the Elapsed Time of the SQL statement divided     into the Total Database Time multiplied by 100

  • %Total - Elapsed Time    as a percentage of Total DB time

  • %CPU    - CPU Time    as a percentage of Elapsed Time

  • %IO    - User I/O Time as a percentage of Elapsed Time

  • Captured SQL account for   91.3% of Total DB Time (s):        37,458

  • Captured PL/SQL account for    0.0% of Total DB Time (s):       37,458

































Elapsed  Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO    SQL IdSQL ModuleSQL Text
32,074.509,2253.4885.6322.280.005spk48gcmhf2g 
SELECT * FROM COUNTRY_CODE C J...
1,455.994563.193.890.1899.347m9w85hj1ukqg 
select t.* from df_data_stream...
93.60214.460.2511.5416.47asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
83.21183.210.225.850.00fqmpmkfr6pqyk
PLSQLDev.exe
select s.synonym_name object_n...
61.06232.650.1630.400.004040jw7rmjbqj 
select cbi.* FROM diag_soft ds...
49.321650.300.1335.540.8989nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
42.1639,7140.000.1174.810.00c2t5v51gankkv 
select ds.unified_id as unifie...
29.93516,4100.000.0847.170.00520mkxqpf15q8 
select 1 from dual
24.3552,5500.000.077.7510.595nggumnh49yzc 
select * from SYS_PRODUCT wher...
23.417,7830.000.066.480.0087hfb2vvgt6tp 
select 1 from sys_area_country...


Back to SQL Statistics

Back to Top



SQL ordered by CPU Time



  • Resources reported for PL/SQL code includes the resources used by all SQL     statements called by the code.

  • %Total - CPU Time    as a percentage of Total DB CPU

  • %CPU    - CPU Time    as a percentage of Elapsed Time

  • %IO    - User I/O Time as a percentage of Elapsed Time

  • Captured SQL account for   97.1% of Total CPU Time (s):       7,552

  • Captured PL/SQL account for    0.0% of Total CPU Time (s):         7,552

































CPU    Time (s)Executions CPU per  Exec (s)%TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
7,146.269,2250.7794.6232,074.5022.280.005spk48gcmhf2g 
SELECT * FROM COUNTRY_CODE C J...
31.5439,7140.000.4242.1674.810.00c2t5v51gankkv 
select ds.unified_id as unifie...
18.57230.810.2561.0630.400.004040jw7rmjbqj 
select cbi.* FROM diag_soft ds...
17.531650.110.2349.3235.540.8989nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
14.12516,4100.000.1929.9347.170.00520mkxqpf15q8 
select 1 from dual
13.711650.080.1816.0085.723.316zzzr28dtrtpd 
select * from ( select us.FREE...
13.671650.080.1814.7592.652.761dv841hap05xc 
SELECT COUNT(*) AS c from (sel...
12.48340,5460.000.1722.0056.720.005d80ww4xabj00 
select t.* from df_unit_conver...
10.80210.510.1493.6011.5416.47asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
8.064,8710.000.1111.8967.810.002asdyf7j381tv 
select s.*, l.LAN_NAME from DI...


Back to SQL Statistics

Back to Top



SQL ordered by User I/O Wait Time



  • Resources reported for PL/SQL code includes the resources used by all SQL     statements called by the code.

  • %Total - User I/O Time as a percentage of Total User I/O Wait time

  • %CPU    - CPU Time    as a percentage of Elapsed Time

  • %IO    - User I/O Time as a percentage of Elapsed Time

  • Captured SQL account for   97.7% of Total User I/O Wait Time (s):        1,547

  • Captured PL/SQL account for    0.2% of Total User I/O Wait Time (s):           1,547

































User I/O Time (s)Executions UIO per  Exec (s)%TotalElapsed    Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
1,446.454563.1793.511,455.990.1899.347m9w85hj1ukqg 
select t.* from df_data_stream...
19.1929.591.2422.710.4284.48fdjtrdaz8hpvg 
INSERT /*+ APPEND LEADING(@"SE...
15.42210.731.0093.6011.5416.47asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
9.925,0360.000.6410.402.6995.41dx9uj64072dw7 
select * from SYS_PRODUCT_BURN...
8.6528,3390.000.5610.7510.2780.534xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
4.39800.050.285.6014.8778.499kyafghcc1xh6 
select distinct temp.SOFT_ID, ...
3.790 0.2510.860.7734.921uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...
2.5852,5500.000.1724.357.7510.595nggumnh49yzc 
select * from SYS_PRODUCT wher...
1.934,0260.000.122.243.7585.89c00br6fharcvs 
select c.* from diag_user_soft...
0.531650.000.0316.0085.723.316zzzr28dtrtpd 
select * from ( select us.FREE...


Back to SQL Statistics

Back to Top



SQL ordered by Gets



  • Resources reported for PL/SQL code includes the resources used by all SQL     statements called by the code.

  • %Total - Buffer Gets    as a percentage of Total Buffer Gets

  • %CPU    - CPU Time    as a percentage of Elapsed Time

  • %IO    - User I/O Time as a percentage of Elapsed Time

  • Total Buffer Gets:    22,656,056

  • Captured SQL account for   88.9% of Total

























































Buffer Gets ExecutionsGets     per Exec  %TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
3,346,8679,225362.8014.7732,074.5022.280.005spk48gcmhf2g 
SELECT * FROM COUNTRY_CODE C J...
1,918,54016511,627.528.4716.0085.723.316zzzr28dtrtpd 
select * from ( select us.FREE...
1,918,51816511,627.388.4714.7592.652.761dv841hap05xc 
SELECT COUNT(*) AS c from (sel...
1,916,58116511,615.648.4649.3235.540.8989nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
1,362,8044,871279.786.0211.8967.810.002asdyf7j381tv 
select s.*, l.LAN_NAME from DI...
1,349,1242164,244.005.9593.6011.5416.47asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
1,077,70839,71427.144.7642.1674.810.00c2t5v51gankkv 
select ds.unified_id as unifie...
1,069,7961762,929.184.7217.7329.910.007c9aurkrt70vn 
select * from ( select p.*, pt...
868,7547511,583.393.839.3466.743.106u4dt8af4b0x1 
select * from ( select us.FREE...
855,583340,5462.513.7822.0056.720.005d80ww4xabj00 
select t.* from df_unit_conver...
532,0371928,001.952.351.1087.980.00aygjw8hmzpntb 
select * from ( select s.SOFT_...
453,4762022,673.802.001.4770.3227.071dgz6vdqx9dy0 
SELECT COUNT(*) AS c from DIAG...
391,88418,95920.671.735.3457.830.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
351,11218,95918.521.552.4065.950.005ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
326,637456716.311.441,455.990.1899.347m9w85hj1ukqg 
select t.* from df_data_stream...
318,7717,78340.961.4123.416.480.0087hfb2vvgt6tp 
select 1 from sys_area_country...
281,13617,57116.001.244.1554.400.005ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...
252,80852,5504.811.1224.357.7510.595nggumnh49yzc 
select * from SYS_PRODUCT wher...


Back to SQL Statistics

Back to Top



SQL ordered by Reads



  • %Total - Physical Reads as a percentage of Total Disk Reads

  • %CPU    - CPU Time    as a percentage of Elapsed Time

  • %IO    - User I/O Time as a percentage of Elapsed Time

  • Total Disk Reads:    2,049,244

  • Captured SQL account for   94.5% of Total

































Physical ReadsExecutionsReads    per Exec  %TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
1,347,2972164,157.0065.7593.6011.5416.47asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
154,119165934.057.5249.3235.540.8989nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
152,892165926.627.4614.7592.652.761dv841hap05xc 
SELECT COUNT(*) AS c from (sel...
152,771165925.887.4516.0085.723.316zzzr28dtrtpd 
select * from ( select us.FREE...
97,557751,300.764.769.3466.743.106u4dt8af4b0x1 
select * from ( select us.FREE...
20,35345644.630.991,455.990.1899.347m9w85hj1ukqg 
select t.* from df_data_stream...
10,73314766.640.521.3191.102.535g35vsgdmpdds 
select * from ( select row_.*,...
27800.340.005.6014.8778.499kyafghcc1xh6 
select distinct temp.SOFT_ID, ...
235,0360.000.0010.402.6995.41dx9uj64072dw7 
select * from SYS_PRODUCT_BURN...
17200.850.001.4770.3227.071dgz6vdqx9dy0 
SELECT COUNT(*) AS c from DIAG...


Back to SQL Statistics

Back to Top



SQL ordered by Physical Reads (UnOptimized)



  • UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs

  • %Opt    - Optimized Reads as percentage of SQL Read Requests

  • %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs

  • Total Physical Read Requests:           48,494

  • Captured SQL account for   64.8% of Total

  • Total UnOptimized Read Requests:      48,494

  • Captured SQL account for   64.8% of Total

  • Total Optimized Read Requests:             1

  • Captured SQL account for    0.0% of Total

































UnOptimized Read ReqsPhysical  Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total   SQL IdSQL ModuleSQL Text
20,35320,35345644.630.0041.977m9w85hj1ukqg 
select t.* from df_data_stream...
3,4193,41916520.720.007.0589nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
2,8632,86316517.350.005.906zzzr28dtrtpd 
select * from ( select us.FREE...
2,8422,84216517.220.005.861dv841hap05xc 
SELECT COUNT(*) AS c from (sel...
1,6001,6007521.330.003.306u4dt8af4b0x1 
select * from ( select us.FREE...
1501501510.000.000.31bn4b3vjw2mj3u 
SELECT OBJOID, CLSOID, DECODE(...
128128149.140.000.265g35vsgdmpdds 
select * from ( select row_.*,...
1717200.850.000.041dgz6vdqx9dy0 
SELECT COUNT(*) AS c from DIAG...
1212560.210.000.026gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...
11110 0.000.021uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...


Back to SQL Statistics

Back to Top



SQL ordered by Executions



  • %CPU    - CPU Time    as a percentage of Elapsed Time

  • %IO    - User I/O Time as a percentage of Elapsed Time

  • Total Executions:    1,229,498

  • Captured SQL account for   97.4% of Total

































Executions Rows ProcessedRows per ExecElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
516,410516,4031.0029.9347.170.00520mkxqpf15q8 
select 1 from dual
340,546174,4800.5122.0056.720.005d80ww4xabj00 
select t.* from df_unit_conver...
52,55052,4491.0024.357.7510.595nggumnh49yzc 
select * from SYS_PRODUCT wher...
39,71439,7121.0042.1674.810.00c2t5v51gankkv 
select ds.unified_id as unifie...
30,06330,0631.004.9324.610.00bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
28,339170,3936.0110.7510.2780.534xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
21,92700.001.1565.160.051fnv7qu1a8qsc 
select * from product_down_set...
18,959628,79233.175.3457.830.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
18,95966,7703.522.4065.950.005ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
17,5717,7980.444.1554.400.005ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...


Back to SQL Statistics

Back to Top



SQL ordered by Parse Calls



  • Total Parse Calls:     1,225,129

  • Captured SQL account for   97.7% of Total

































Parse CallsExecutions % Total Parses   SQL IdSQL ModuleSQL Text
516,411516,41042.15520mkxqpf15q8 
select 1 from dual
340,547340,54627.805d80ww4xabj00 
select t.* from df_unit_conver...
52,55052,5504.295nggumnh49yzc 
select * from SYS_PRODUCT wher...
39,71439,7143.24c2t5v51gankkv 
select ds.unified_id as unifie...
30,06330,0632.45bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
28,33928,3392.314xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
21,92721,9271.791fnv7qu1a8qsc 
select * from product_down_set...
18,95918,9591.550ay7wjuhgzj9k 
select d.* from diag_soft_vers...
18,95918,9591.555ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
17,57117,5711.435ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...


Back to SQL Statistics

Back to Top



SQL ordered by Sharable Memory



  • Only Statements with Sharable Memory greater than 1048576 are displayed















Sharable Mem (b)Executions % Total   SQL IdSQL ModuleSQL Text
4,317,48310.33gjm43un5cy843 
SELECT SUM(USED), SUM(TOTAL) F...
2,265,37030.17ab3swhv5g138y 
select OBJOID, CLSOID, RUNTIME...
1,732,252170.133hpxs5dvc897x 
select * from ( select mm.*, n...
1,298,216150.10bn4b3vjw2mj3u 
SELECT OBJOID, CLSOID, DECODE(...


Back to SQL Statistics

Back to Top



SQL ordered by Version Count



  • Only Statements with Version Count greater than 20 are displayed




























































































































































Version Count Executions    SQL IdSQL ModuleSQL Text
9025rygsj4dbw6jt 
insert into sys.mon_mods$ (obj...
73122fsbqktj5vw6n9 
select next_run_date, obj#, ru...
7212118naypzfmabd6
EM_PING
INSERT INTO MGMT_SYSTEM_PERFOR...
7172ctsfqq07f876g 
SELECT NVL(CRIT_COUNTER, 0), N...
6919yt4ka3n2svmc
DBMS_SCHEDULER
update sys.scheduler$_job set ...
675fcb5u7n0r523m 
SELECT NVL(AVG((VALUE*1000.0)/...
675fcb5u7n0r523m 
SELECT NVL(AVG((VALUE*1000.0)/...
652038vwv6hx92ymmm 
UPDATE MGMT_CURRENT_METRICS SE...
6515bn4b3vjw2mj3u 
SELECT OBJOID, CLSOID, DECODE(...
575cabqn4dp09qck 
SELECT TASK_CLASS, ROUND(NVL(S...
53203gfdn12rn0fg3m 
SELECT TARGET_GUID FROM MGMT_T...
51469vt6njn4h1wf1 
SELECT TRIM(B.METRIC_NAME) FRO...
51119b2gnxm5z6r51n 
lock table sys.col_usage$ in e...
51188g00cj285jmgsw 
update sys.mon_mods$ set inser...
50513x0kdm7z3yasw 
SELECT TARGET_TYPE, TYPE_META_...
505869avkb73kf5g 
SELECT NVL((((SUM(DURATION)/(6...
4762aq8yqxyyb40nn 
update sys.job$ set this_date=...
453ab3swhv5g138y 
select OBJOID, CLSOID, RUNTIME...
4057gzxf61vj6wq4 
SELECT ID FROM SYS.WRI$_ADV_TA...
392g4gp07gt2z920 
update sys.scheduler$_job set ...
391gjm43un5cy843 
SELECT SUM(USED), SUM(TOTAL) F...
391gjm43un5cy843 
SELECT SUM(USED), SUM(TOTAL) F...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
3534cw5gh4duww26p 
SELECT COUNT(*) AS c from ( se...
29809kyafghcc1xh6 
select distinct temp.SOFT_ID, ...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
281777jfd5z2qky8p 
select * from ( select mm.*, n...
26173hpxs5dvc897x 
select * from ( select mm.*, n...
26173hpxs5dvc897x 
select * from ( select mm.*, n...
26173hpxs5dvc897x 
select * from ( select mm.*, n...
26173hpxs5dvc897x 
select * from ( select mm.*, n...
26173hpxs5dvc897x 
select * from ( select mm.*, n...
26173hpxs5dvc897x 
select * from ( select mm.*, n...
247g4kcn01rx9d0m 
SELECT COUNT(*) AS c from ( se...
247g4kcn01rx9d0m 
SELECT COUNT(*) AS c from ( se...
247g4kcn01rx9d0m 
SELECT COUNT(*) AS c from ( se...
247g4kcn01rx9d0m 
SELECT COUNT(*) AS c from ( se...
2371r00pg8rfnkpa 
select * from ( select m.* fro...
2371r00pg8rfnkpa 
select * from ( select m.* fro...
2371r00pg8rfnkpa 
select * from ( select m.* fro...
2371r00pg8rfnkpa 
select * from ( select m.* fro...


Back to SQL Statistics

Back to Top




Complete List of SQL Text




























































SQL IdSQL Text
0ay7wjuhgzj9kselect d.* from diag_soft_version_detail d left join diag_soft_version v on v.version_id = d.version_id     where v.soft_id = :1 order by d.upload_time desc         
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME,  TIME,  DURATION,    MODULE,  ACTION,  IS_TOTAL,  NAME,  VALUE,  CLIENT_DATA,  HOST_URL) VALUES (:B9 ,  SYSDATE,  :B8 ,  SUBSTR(:B7 ,  1,  512),  SUBSTR(:B6 , 1, 32),  :B5 ,  SUBSTR(:B4 , 1, 128),  SUBSTR(:B3 , 1, 128),    SUBSTR(:B2 , 1, 128),  SUBSTR(:B1 , 1, 256))
1dgz6vdqx9dy0SELECT COUNT(*) AS c  from DIAG_SOFT_VERSION v join DIAG_SOFT s on s.SOFT_ID = v.SOFT_ID      join SYS_PDT_TYPE pdt on pdt.PDT_TYPE_ID=s.PDT_TYPE_ID      WHERE                        exists(select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=:1)          order by v.UPDATE_TIME desc    
1dv841hap05xcSELECT COUNT(*) AS c    from (select max(version_no) version_no,  soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv        join DIAG_SOFT s on s.soft_id=vv.soft_id        left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID        AND                 sd.LAN_ID = :1                )     join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID        where exists(          select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id           and to_char(v.CREATER_TIME,    'yyyy-mm-dd') <= to_char(us.FREE_END_TIME,  'yyyy-mm-dd')                                 AND                 (v.VALID_FLAG = :2)               AND                   (d.CHECK_STATE = :3)                  )               AND                   (s.VALID_FLAG = :4)                               AND                   (us.SERIAL_NO = :5)                      AND                  (s.pdt_type_id = :6)                                order by upper(s.SOFT_NAME) asc         
1fnv7qu1a8qscselect * from product_down_setting p where p.serial_no=:1          
1r00pg8rfnkpa
select * from ( select m.*           from (select s.soft_id,    t1.version_no,    t1.creater_time,  t4.soft_name as soft_desc,   t2.remark,  t2.version_detail_id,              nvl(UPGRADE_PRICE,  DEFAULT_BPRICE) as price,  v.CUR_ID, t5.cur_code               from diag_soft s,  sys_product p,  sys_vender v,  diag_soft_price pr,  diag_soft_version t1,  diag_soft_version_detail t2,                diag_user_soft_center    t3, diag_soft_desc t4, sys_currency_unit t5              where s.pdt_type_id = p.pdt_type_id and  s.soft_id = pr.soft_id and v.cur_id = pr.cur_id and upper(s.soft_name)  not like '%ZY'  and              t4.soft_id = s.soft_id and t4.lan_id = :1 and pr.cur_id = t5.cur_id and             p.vender_id = v.vender_id and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and               s.soft_id = t3.soft_id and t3.user_id = :2 and  t3.free_end_time < sysdate and p.serial_no = :3                  and p.serial_no = t3.serial_no and p.pdt_state = 1 and p.user_id = :4 and t2.lan_id = :5                   and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2) m,            (select r.soft_id, max(version_no)as version_no, lan_id               from diag_soft_version r , diag_soft_version_detail rr, diag_soft s            where r.version_id = rr.version_id        and lan_id = :6 and s.soft_id = r.soft_id and s.valid_flag  = 1 and
r.VALID_FLAG = 1 and rr.CHECK_STATE = 2          group by r.soft_id, lan_id ) n        where m.soft_id = n.soft_id and m.version_no = n.version_no         and not exists      (          select 1 from         (          select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s            where r.version_id = rr.version_id              and lan_id = :7 and s.soft_id = r.soft_id and s.valid_flag  = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2             group by r.soft_id, lan_id           ) tr,                (             select  soft_id, info.version from user_order uo,    order_detail_info info                where uo.order_id = info.order_id and            uo.order_status in (0,    1, 3)  and uo.serial_no = :8 and uo.buy_origin = 1  and                uo.user_id = :9              ) rt        where tr.soft_id = rt.soft_id and tr.version_no = rt.version                ) ) where rownum <= 10
1uk5m5qbzj1vtBEGIN dbms_workload_repository.create_snapshot; END;
 
2asdyf7j381tvselect s.*,  l.LAN_NAME from DIAG_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.LAN_ID where s.SOFT_ID=:1        
3hpxs5dvc897x
select * from ( select mm.*, nvl2(t3.soft_name, t3.soft_name, mm.soft_name) as soft_desc    from (select distinct m.* from    (select s.soft_id, t1.version_no, t1.creater_time, t2.remark, t2.version_detail_id, nvl(buy_price,  default_bprice) as price, t4.CUR_ID, t4.cur_code, s.soft_name       from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, sys_currency_unit t4    where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id          and        v.cur_id = pr.cur_id                  and p.vender_id = v.vender_id       and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and upper(s.soft_name) not in ('KARRY',  'ZHONGXINGZHY')    and s.soft_id not in(select ds.soft_id from diag_soft ds where ds.pdt_type_id in (121, 142,  143 ) and ds.soft_name in ('WLGY', 'LAIYANG''DFG', 'HIGER', 'QIRUIZYDISPLAY', 'KINGLONG', 'UFO', 'DFACLX', 'YUCHAI', 'DFAC_CHAOCHAI', 'RIICH', 'ZZMAZDA', 'HQE', 'DFBF', 'DFAC_SHANGYONG', 'QUANCHAI', 'JMMOTOR', 'DIAS', 'WXDIESEL', 'BJGJ', 'JAC', 'YQHT', 'TJYQZYMID', 'CHDAIHATSU', 'MYXINCHEN', 'DETC', 'ZHONGXINGZHY', 'WABCOABS', 'HANGTIANMIT', 'SPARK', 'DFCNG', 'NJXYT', 'ZHONGHUAO3', 'ZHONGHUAEN', 'CHANGCHENGZY_CN', 'NJYWK', 'GREATWALL', 'QIRUI', 'LIUWEI', 'KARRY', 'RELY'))    and s.soft_id not in (select soft_id from diag_user_soft_center  where user_id = :1  and serial_no = :2)
      and s.soft_id not in (select uz.soft_id from user_order u,  order_detail_info uz where u.order_id = uz.order_id and u.user_id = :3  and                 u.order_status in (0,  1, 3) and u.serial_no = :4)       and p.serial_no = :5 and p.pdt_state = 1 and p.user_id = :6     and t2.lan_id = :7 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m,     (select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id      and lan_id = :8 and s.soft_id = r.soft_id and s.valid_flag  = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2       group by r.soft_id, lan_id )n    where m.soft_id = n.soft_id and m.version_no = n.version_no            )mm left join diag_soft_desc  t3 on mm.soft_id = t3.soft_id and t3.lan_id = :9     order by NLSSORT(soft_desc,  'NLS_SORT=SCHINESE_PINYIN_M') ) where rownum <= 10
3x0kdm7z3yaswSELECT TARGET_TYPE,  TYPE_META_VER,  NVL(CATEGORY_PROP_1, ' '),  NVL(CATEGORY_PROP_2, ' '),  NVL(CATEGORY_PROP_3, ' '),  NVL(CATEGORY_PROP_4, ' '),  NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
4040jw7rmjbqjselect cbi.* FROM diag_soft ds, car_base_info cbi where ds.soft_name in (select dsxn.auto_code from user_carbaseinfo uc, diag_soft_x431_name dsxn      where uc.serial_no=:1 and uc.auto_id=cbi.car_brand_id and uc.diag_entrance_id = cbi.diag_entrance_id and dsxn.auto_id=cbi.car_brand_id)     AND DS.PDT_TYPE_ID=:2          
4xbg42tpyp0gmselect * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1        
520mkxqpf15q8select 1 from dual
5ck2pk4pxbq6yselect v.* from  DIAG_SOFT_VERSION v         where exists (select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID        AND          d.CHECK_STATE=:1             )         and exists(select 'X' from DIAG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VALID_FLAG=1)        and v.VALID_FLAG=1 and v.SOFT_ID = :2        AND           to_char(v.CREATER_TIME,    'yyyy-mm-dd') <= to_char(:3,  'yyyy-mm-dd')                 order by v.VERSION_NO desc    
5d80ww4xabj00select t.* from df_unit_conversion t where t.private_unit_id = :1 and t.unified_unit_id=:2        
5g35vsgdmpdds
select * from ( select row_.*,    rownum rownum_ from ( select us.FREE_END_TIME,    vv.version_no MAX_VERSION_No,  s.*,  decode(sd.SOFT_NAME,  null, s.SOFT_NAME,  sd.SOFT_NAME) as softDesc,  decode(sd.REMARK,  null, s.REMARK,  sd.REMARK) as remarkDesc      from (select max(version_no) version_no,  soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv    join DIAG_SOFT s on s.soft_id=vv.soft_id    left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID         AND                 sd.LAN_ID = :1                 )      join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID      where exists(           select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id            and to_char(v.CREATER_TIME,  'yyyy-mm-dd') <= to_char(us.FREE_END_TIME,    'yyyy-mm-dd')                                  AND                  (v.VALID_FLAG = :2)                AND                 (d.CHECK_STATE = :3)                  )                AND                 (s.VALID_FLAG = :4)                             AND                 (us.SERIAL_NO = :5)                    AND                   (s.pdt_type_id = :6)                                  order by s.UPDATE_TIME desc ) row_ where rownum <= 20) where ro
wnum_ > 10
5ky6k3fa3cu3yselect * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2) and LAN_ID = :3          
5nggumnh49yzcselect * from SYS_PRODUCT where SERIAL_NO = :1      
5rygsj4dbw6jtinsert into sys.mon_mods$ (obj#,  inserts,  updates,  deletes,    timestamp,  flags,  drop_segments) values (:1,    :2,  :3,  :4,  :5,  :6,  :7)
5spk48gcmhf2gSELECT *          FROM COUNTRY_CODE C         JOIN COUNTRY_IP_RANGE IP ON C.COUNTRY_CODE = ip.country_code        WHERE IP.Start_Ip1 <= ip_to_number(:1)          AND IP.End_Ip1 >= ip_to_number(:2)      
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;
6u4dt8af4b0x1
select * from ( select us.FREE_END_TIME,  vv.version_no MAX_VERSION_No,  s.*,  decode(sd.SOFT_NAME,  null, s.SOFT_NAME,  sd.SOFT_NAME) as softDesc,  decode(sd.REMARK,    null, s.REMARK,  sd.REMARK) as remarkDesc       from (select max(version_no) version_no,  soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv      join DIAG_SOFT s on s.soft_id=vv.soft_id      left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID           AND                   sd.LAN_ID = :1                   )        join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID      where exists(             select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id           and to_char(v.CREATER_TIME,  'yyyy-mm-dd') <= to_char(us.FREE_END_TIME,  'yyyy-mm-dd')                             AND                (v.VALID_FLAG = :2)                  AND                  (d.CHECK_STATE = :3)                    )                  AND                  (s.VALID_FLAG = :4)                              AND                  (us.SERIAL_NO = :5)                 AND                 (s.pdt_type_id = :6)                                    order by s.UPDATE_TIME desc ) where rownum <= 10
6zzzr28dtrtpd
select * from ( select us.FREE_END_TIME,  vv.version_no MAX_VERSION_No,  s.*,  decode(sd.SOFT_NAME,  null, s.SOFT_NAME,  sd.SOFT_NAME) as softDesc,  decode(sd.REMARK,    null, s.REMARK,  sd.REMARK) as remarkDesc       from (select max(version_no) version_no,  soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv      join DIAG_SOFT s on s.soft_id=vv.soft_id      left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID           AND                   sd.LAN_ID = :1                   )        join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID      where exists(             select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id           and to_char(v.CREATER_TIME,  'yyyy-mm-dd') <= to_char(us.FREE_END_TIME,  'yyyy-mm-dd')                             AND                (v.VALID_FLAG = :2)                  AND                  (d.CHECK_STATE = :3)                    )                  AND                  (s.VALID_FLAG = :4)                              AND                  (us.SERIAL_NO = :5)                 AND                 (s.pdt_type_id = :6)                                   order by upper(s.SOFT_NAME) asc ) where rownum <= 10000
77jfd5z2qky8p
select * from ( select mm.*, nvl2(t3.soft_name, t3.soft_name, mm.soft_name) as soft_desc    from (select distinct m.* from    (select s.soft_id, t1.version_no, t1.creater_time, t2.remark, t2.version_detail_id, nvl(buy_price,  default_bprice) as price, t4.CUR_ID, t4.cur_code, s.soft_name       from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, sys_currency_unit t4    where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id          and        v.cur_id = pr.cur_id                  and p.vender_id = v.vender_id       and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and upper(s.soft_name) not in ('KARRY',  'ZHONGXINGZHY')    and s.soft_id not in(select ds.soft_id from diag_soft ds where ds.pdt_type_id in (121, 142,  143 ) and ds.soft_name in ('WLGY', 'LAIYANG''DFG', 'HIGER', 'QIRUIZYDISPLAY', 'KINGLONG', 'UFO', 'DFACLX', 'YUCHAI', 'DFAC_CHAOCHAI', 'RIICH', 'ZZMAZDA', 'HQE', 'DFBF', 'DFAC_SHANGYONG', 'QUANCHAI', 'JMMOTOR', 'DIAS', 'WXDIESEL', 'BJGJ', 'JAC', 'YQHT', 'TJYQZYMID', 'CHDAIHATSU', 'MYXINCHEN', 'DETC', 'ZHONGXINGZHY', 'WABCOABS', 'HANGTIANMIT', 'SPARK', 'DFCNG', 'NJXYT', 'ZHONGHUAO3', 'ZHONGHUAEN', 'CHANGCHENGZY_CN', 'NJYWK', 'GREATWALL', 'QIRUI', 'LIUWEI', 'KARRY', 'RELY'))    and s.soft_id not in (select soft_id from diag_user_soft_center  where user_id = :1  and serial_no = :2)
      and s.soft_id not in (select uz.soft_id from user_order u,  order_detail_info uz where u.order_id = uz.order_id and u.user_id = :3  and                 u.order_status in (0,  1, 3) and u.serial_no = :4)       and p.serial_no = :5 and p.pdt_state = 1 and p.user_id = :6     and t2.lan_id = :7 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m,     (select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id      and lan_id = :8 and s.soft_id = r.soft_id and s.valid_flag  = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2       group by r.soft_id, lan_id )n    where m.soft_id = n.soft_id and m.version_no = n.version_no            )mm left join diag_soft_desc  t3 on mm.soft_id = t3.soft_id and t3.lan_id = :9     order by NLSSORT(soft_desc,  'NLS_SORT=SCHINESE_PINYIN_M') ) where rownum <= 2147483647
7c9aurkrt70vnselect * from ( select p.*, pt.PDT_TYPE, sc.name, v.VENDER_NAME, f.VENDER_NAME as FILIAL_ENAME, c.customer_name     from SYS_PRODUCT p       left join SYS_PDT_TYPE pt on p.pdt_type_id = pt.pdt_type_id         left join SYS_SOFT_CONF sc on p.SOFT_CONF_ID = sc.SOFT_CONF_ID     left join sys_vender v on p.VENDER_ID = v.VENDER_ID        left join sys_vender f on p.filiale_id = f.VENDER_ID     left join customer c on c.customer_number_id = p.customer_number      where 1=1        AND     p.PRODUCT_PART = :1                                       order by UPDATE_TIME desc ) where rownum <= 10
7gzxf61vj6wq4SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY,  :B2 ) = :B2 AND A.OWNER# = :B1
7m9w85hj1ukqgselect t.* from df_data_stream_desc t where t.version_detail_id = :1 and t.unified_id is not null          
869avkb73kf5gSELECT NVL((((SUM(DURATION)/(60*1000))/60)*100), 0),    NVL(AVG((VALUE*1000.0)/DURATION), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE IS_TOTAL='Y' AND DURATION > 0 AND TIME > (SYSDATE-(1/24)) AND JOB_NAME = 'JOB_DISPATCHER' AND HOST_URL = :B1
87hfb2vvgt6tpselect 1      from sys_area_country    where 1=1      AND        DOWNLOAD_AREA_ID = (select distinct t1.download_area_id           from sys_vender t1           join sys_vender t2 ON  (t2.user_type=2 and t1.vender_id = t2.filiale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id)              join sys_product tp ON (t2.vender_id = tp.vender_id )or (tp.vender_id is null and t2.vender_id = tp.filiale_id)           where t1.user_type = 3         and tp.serial_no = :1)                     and country_id = :2    
89nfp8fv1y8vwSELECT COUNT(*) AS c    from (select max(version_no) version_no,  soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv        join DIAG_SOFT s on s.soft_id=vv.soft_id        left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID        AND                 sd.LAN_ID = :1                )     join DIAG_USER_SOFT_CENTER us on s.SOFT_ID=us.SOFT_ID        where exists(          select 'X' from DIAG_SOFT_VERSION_DETAIL d join DIAG_SOFT_VERSION v on d.version_id=v.version_id where v.soft_id=s.soft_id           and to_char(v.CREATER_TIME,    'yyyy-mm-dd') <= to_char(us.FREE_END_TIME,  'yyyy-mm-dd')                                 AND                 (v.VALID_FLAG = :2)               AND                   (d.CHECK_STATE = :3)                  )               AND                   (s.VALID_FLAG = :4)                               AND                   (us.SERIAL_NO = :5)                      AND                  (s.pdt_type_id = :6)                                 order by s.UPDATE_TIME desc         
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 ,  VALUE = :B6 ,  STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
9kyafghcc1xh6
select distinct temp.SOFT_ID,  temp.SOFT_NAME,    temp.VERSION_NO,  temp.LAN_ID,    temp.SOFT_DESC,  temp.VERSION_DETAIL_ID,  temp.REMARK, temp.FILE_SIZE, to_char(temp.UPLOAD_TIME, 'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME,          decode(temp.VEHICLE_TYPE_ID,    null, 1,  temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE,  decode(temp.SOFT_APPLICABLE_AREA_ID,    null, 1,  temp.SOFT_APPLICABLE_AREA_ID) as SOFT_APPLICABLE_AREA, temp.free_end_time         from (      select s.SOFT_ID,  s.SOFT_NAME,  v.VERSION_NO,  d.LAN_ID,  decode(sd.SOFT_NAME,  null, s.SOFT_NAME,  sd.SOFT_NAME) as SOFT_DESC,  d.VERSION_DETAIL_ID,  d.REMARK, d.FILE_SIZE, d.UPLOAD_TIME,     us.free_end_time, s.VEHICLE_TYPE_ID,  s.SOFT_APPLICABLE_AREA_ID,  ROW_NUMBER() OVER(PARTITION BY v.SOFT_ID ORDER BY v.VERSION_NO DESC) RN          from DIAG_USER_SOFT_CENTER us left join sys_user su on us.user_id=su.user_id           left join DIAG_SOFT s on s.soft_id=us.soft_id         left join DIAG_SOFT_VERSION v on v.soft_id=s.soft_id              left join DIAG_SOFT_VERSION_DETAIL d on d.version_id=v.version_id         join sys_product sp on (sp.serial_no=us.serial_no and sp.pdt_type_id=s.pdt_type_id)            left join DIAG_SOFT_DESC sd on (sd.soft_id=s.soft_id       AND                   sd.LAN_ID = :1                     )         where 1=1                          AND                   (( not exists (select 'X' from DIAG_SOFT_
VERSION_DETAIL d2 where  d2.LAN_ID=:2 and d2.CHECK_STATE=2 and d2.VERSION_Id=v.VERSION_Id )            and d.LAN_ID=:3           ) or (d.LAN_ID=:4))                             and to_char(v.CREATER_TIME,  'yyyy-mm-dd') <= to_char(us.FREE_END_TIME,  'yyyy-mm-dd')            and d.CHECK_STATE=2 and v.VALID_FLAG=1 and s.VALID_FLAG=1                AND             us.SERIAL_NO=:5                AND              su.cc=:6              ) temp           where temp.RN=1 order by temp.SOFT_ID desc,    temp.VERSION_DETAIL_ID      
9vt6njn4h1wf1SELECT TRIM(B.METRIC_NAME) FROM MGMT_TARGETS A,  MGMT_METRICS B WHERE B.METRIC_GUID = :B2 AND A.TARGET_TYPE = B.TARGET_TYPE AND A.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = A.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = A.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = A.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = A.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = A.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ') AND A.TARGET_GUID=:B1
9yt4ka3n2svmcupdate sys.scheduler$_job set  last_enabled_time = :1,  next_run_date = :2,  job_status = :3 where  obj# = :4
ab3swhv5g138y
select OBJOID,     CLSOID,  RUNTIME,  PRI,  JOBTYPE,   SCHLIM,   WT,  INST,   RUNNOW,  ENQ_SCHLIM from ( select a.obj# OBJOID,  a.class_oid CLSOID,     decode(bitand(a.flags,  16384),  0,  a.next_run_date,           a.last_enabled_time) RUNTIME,     (2*a.priority +     decode(bitand(a.job_status,  4),  0,  0,          decode(a.running_instance,  :1,  -1,    1))) PRI,     1 JOBTYPE,     decode(a.schedule_limit,  NULL,        decode(bitand(a.flags,    4194304),  4194304,  p.schedule_limit,    NULL),          a.schedule_limit) SCHLIM,    a.job_weight WT,     decode(a.running_instance,  NULL,    0,  a.running_instance) INST,      decode(bitand(a.flags,  16384),  0,  0,  1) RUNNOW,      decode(bitand(a.job_status,  8388608),  0,  0,  1) ENQ_SCHLIM  from sys.scheduler$_job a,  sys.scheduler$_program p,    v$database v,                v$instance i  where a.program_oid = p.obj#(+)    and bitand(a.job_status,  515) = 1    and bitand(a.flags,    1048576) = 0    and ((bitand(a.flags,  134217728 + 268435456) = 0) or          (bitand(a.job_status,  1024) <> 0))    and bitand(a.flags,    4096) = 0    and (a.next_run_date <= :2     or bitand(a.flags,  16384) <> 0)    and a.instance_id is null    and (a.class_oid is null      or (a.class_oid is not null      and a.class_oid in (select b.obj# from sys.scheduler$_class b                  where b.affinity is null)))    and (a.database_role = v.database_role     or (a.database_role is null and v.database_role = 'PRIMARY'
))    and ( i.logins = 'ALLOWED' or bitand(a.flags,  17179869184) <> 0 ) union all  select l.obj#,  l.class_oid,       decode(bitand(l.flags,  16384),  0,    l.next_run_date,        l.last_enabled_time),     (2*decode(bitand(l.flags,  8589934592),  0,  q.priority,    pj.priority) +       decode(bitand(l.job_status,    4),  0,  0,        decode(l.running_instance,  :3,  -1,  1))),  1,     decode(bitand(l.flags,  8589934592),  0,  q.schedule_limit,        decode(pj.schedule_limit,  NULL,  q.schedule_limit,  pj.schedule_limit)),     decode(bitand(l.flags,  8589934592),  0,  q.job_weight,  pj.job_weight),      decode(l.running_instance,  NULL,  0,  l.running_instance),      decode(bitand(l.flags,  16384),  0,  0,  1),       decode(bitand(l.job_status,    8388608),  0,  0,  1)  from sys.scheduler$_lightweight_job l,  sys.scheduler$_program q,    (select sl.obj# obj#,             decode(bitand(sl.flags,  8589934592),  0,    sl.program_oid,               spj.program_oid) program_oid,           decode(bitand(sl.flags,  8589934592),  0,  NULL,              spj.priority) priority,         decode(bitand(sl.flags,  8589934592),    0,  NULL,            spj.job_weight) job_weight,           decode(bitand(sl.flags,  8589934592),  0,  NULL,              spj.schedule_limit) schedule_limit        from sys.scheduler$_lightweight_job sl,  scheduler$_job spj     where sl.program_oid = spj.obj#(+)) pj ,  v$instance i    where pj.obj# = l.ob
j#    and pj.program_oid = q.obj#(+)    and (:4 = 0 or l.running_instance = :5)    and bitand(l.job_status,  515) = 1     and ((bitand(l.flags,    134217728 + 268435456) = 0) or           (bitand(l.job_status,  1024) <> 0))    and bitand(l.flags,  4096) = 0    and (l.next_run_date <= :6      or bitand(l.flags,  16384) <> 0)    and l.instance_id is null     and (l.class_oid is null      or (l.class_oid is not null    and l.class_oid in (select w.obj# from sys.scheduler$_class w                   where w.affinity is null)))    and ( i.logins = 'ALLOWED' or bitand(l.flags,  17179869184) <> 0 ) union all  select c.obj#,  0,  c.next_start_date,  0,  2,  c.duration,  1,  0,  0,  0  from sys.scheduler$_window c ,  v$instance i  where bitand(c.flags,  1) <> 0    and bitand(c.flags,  2) = 0    and bitand(c.flags,    64) = 0    and c.next_start_date <= :7    and i.logins = 'ALLOWED' union all  select d.obj#,  0,  d.next_start_date + d.duration,          0,  4,  numtodsinterval(0, 'minute'),  1,  0,  0,  0  from sys.scheduler$_window d ,  v$instance i  where bitand(d.flags,  1) <> 0      and bitand(d.flags,  2) = 0     and bitand(d.flags,  64) = 0     and d.next_start_date <= :8    and i.logins = 'ALLOWED' union all  select f.obj#,  0,  e.attr_tstamp,  0,           decode(bitand(e.flags,  131072),  0,  2,  3),          e.attr_intv,  1,    0,  0,    0  from sys.scheduler$_global_attribute e,  sys.obj$ f,  sys.obj$ g,  v$instance i  where e.obj# = g.obj#
 and g.name = 'CURRENT_OPEN_WINDOW'    and e.value = f.name    and f.type# = 69    and e.attr_tstamp is not null    and e.attr_intv is not null    and i.logins = 'ALLOWED' union all  select i.obj#,  0,  h.attr_tstamp + h.attr_intv,  0,         decode(bitand(h.flags,  131072),  0,  4,  5),        numtodsinterval(0,    'minute'),  1,    0,  0,    0  from sys.scheduler$_global_attribute h,  sys.obj$ i,  sys.obj$ j,  v$instance ik  where h.obj# = j.obj#    and j.name = 'CURRENT_OPEN_WINDOW'    and h.value = i.name    and i.type# = 69    and h.attr_tstamp is not null     and h.attr_intv is not null    and ik.logins = 'ALLOWED') order by RUNTIME,  JOBTYPE,    CLSOID,  PRI,  WT DESC,  OBJOID
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
asdsn1yqzjk0rselect r.DOWNLOAD_ID, r.VERSION_ID, r.SOFT_ID, r.VERSION_NO, r.VERSION_DETAIL_ID, r.USER_ID, r.LAN_ID, r.DOWNLOAD_PERSON, r.DOWNLOAD_TIME,        r.SOFT_TYPE, r.DOWNLOAD_IP, r.SERIAL_NO, l.LAN_NAME as LAN_NAME, (select soft_name from diag_soft where soft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD  r        join SYS_LAN l on r.serial_no =:1 and r.soft_type = 2       and r.lan_id = l.lan_id order by r.DOWNLOAD_TIME desc     
aygjw8hmzpntbselect * from ( select s.SOFT_NAME,  pdt.PDT_TYPE,  v.* from DIAG_SOFT_VERSION v join DIAG_SOFT s on s.SOFT_ID = v.SOFT_ID          join SYS_PDT_TYPE pdt on pdt.PDT_TYPE_ID=s.PDT_TYPE_ID          WHERE                       exists(select 'X' from DIAG_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=:1)      order by v.UPDATE_TIME desc ) where rownum <= 10
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bm7qdt1qj4cg0select l.LAN_NAME,  d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l  on d.LAN_ID=l.LAN_ID where VERSION_DETAIL_ID = :1     
bn4b3vjw2mj3u
SELECT OBJOID,    CLSOID,     DECODE(BITAND(FLAGS,  16384),  0,  RUNTIME,        LETIME),    (2*PRI +     DECODE(BITAND(STATUS,  4),  0,  0,         decode(INST,  :1,  -1,  1))),     JOBTYPE,    SCHLIM,  WT,  INST,  RUNNOW,  ENQ_SCHLIM,  INST_ID  FROM (  select a.obj# OBJOID,  a.class_oid CLSOID,    a.next_run_date RUNTIME,      a.last_enabled_time LETIME,  a.flags FLAGS,  a.job_status STATUS,         1 JOBTYPE,  a.priority PRI,      decode(a.schedule_limit,  NULL,          decode(bitand(a.flags,  4194304),  4194304,                    b.schedule_limit,  NULL),             a.schedule_limit) SCHLIM,        a.job_weight WT,      decode(a.running_instance,  NULL,  0,  a.running_instance) INST,        decode(bitand(a.flags,  16384),  0,  0,  1) RUNNOW,      decode(bitand(a.job_status,  8388608),  0,  0,  1) ENQ_SCHLIM,      a.instance_id INST_ID    from sys.scheduler$_job a,  sys.scheduler$_program b,  v$database v ,          v$instance i  where a.program_oid = b.obj#(+)    and (a.database_role = v.database_role       or (a.database_role is null and v.database_role = 'PRIMARY'))    and ( i.logins = 'ALLOWED' or bitand(a.flags,  17179869184) <> 0 )  union all  select c.obj#,  c.class_oid,  c.next_run_date,      c.last_enabled_time,  c.flags,  c.job_status,    1,        decode(bitand(c.flags,  8589934592),  0,  d.priority,  pj.priority),      decode(bitand(c.flags,  8589934592),    0,  d.schedule_limit,         decode(pj.s
chedule_limit,    NULL,  d.schedule_limit,           pj.schedule_limit)),      decode(bitand(c.flags,  8589934592),  0,  d.job_weight,  pj.job_weight),       decode(c.running_instance,  NULL,  0,  c.running_instance),        decode(bitand(c.flags,    16384),  0,  0,  1) RUNNOW,         decode(bitand(c.job_status,  8388608),  0,  0,  1) ENQ_SCHLIM,         c.instance_id INST_ID  from sys.scheduler$_lightweight_job c,  sys.scheduler$_program d,         (select sl.obj# obj#,          decode(bitand(sl.flags,  8589934592),  0,  sl.program_oid,               spj.program_oid) program_oid,        decode(bitand(sl.flags,  8589934592),  0,  NULL,               spj.priority) priority,              decode(bitand(sl.flags,  8589934592),  0,  NULL,                 spj.job_weight) job_weight,        decode(bitand(sl.flags,  8589934592),  0,  NULL,               spj.schedule_limit) schedule_limit     from sys.scheduler$_lightweight_job sl,  scheduler$_job spj        where sl.program_oid = spj.obj#(+)) pj,  v$instance i  where pj.obj# = c.obj#    and pj.program_oid = d.obj#(+)    and ( i.logins = 'ALLOWED' or bitand(c.flags,  17179869184) <> 0 )    and (:2 = 0 or c.running_instance = :3))  WHERE BITAND(STATUS,  515) = 1    AND BITAND(FLAGS,  1048576) = 0      AND ((BITAND(FLAGS,  134217728 + 268435456) = 0) OR          (BITAND(STATUS,  1024) <> 0))    AND BITAND(FLAGS,    4096) = 0    AND (RUNTIME <= :4     OR
BITAND(FLAGS,  16384) <> 0)    and ((CLSOID is not null and       INST_ID is null and         CLSOID in (select e.obj# from sys.scheduler$_class e     where bitand(e.flags,    :5) <> 0 and lower(e.affinity) = lower(:6))) or        (INST_ID is not null and INST_ID = :7)) ORDER BY 3,  2,  4,  7 DESC,  1
c00br6fharcvsselect c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_id         join diag_soft_version v on v.soft_id = s.soft_id        join diag_soft_version_detail d on d.version_id = v.version_id           join sys_product p on p.serial_no = c.serial_no           where d.version_detail_id = :1 and c.serial_no = :2 and c.user_id = :3          
c2t5v51gankkvselect ds.unified_id          as unified_data_id,          du.stream_display_name as unified_data_name,               ddsu.unit_name          as unified_data_unit_name,         ddsu.unit_id        as unified_data_unit_id     from df_data_stream_desc ds        left join df_unified_data_desc dud on dud.data_stream_id = ds.unified_id         left join df_unified_data_name_desc du on (du.data_stream_id =ds.unified_id and du.lan_id = :1)         left join df_data_stream_unit ddsu on ddsu.unit_id =dud.data_stream_unit_id     where ds.version_detail_id = :2     and ds.data_stream_id = :3        
cabqn4dp09qckSELECT TASK_CLASS,  ROUND(NVL(SUM(THROUGHPUT), 0), 2),  NVL(SUM(TOTAL_VALUE), 0),  NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID,  ACTION TASK_CLASS,  NVL(AVG(VALUE*1000/ DECODE(DURATION,    0, 1000, DURATION)), 0) THROUGHPUT,  SUM(VALUE) TOTAL_VALUE,  SUM(DURATION)/1000 TOTAL_DURATION,  COUNT(*) RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS
ctsfqq07f876gSELECT NVL(CRIT_COUNTER, 0),  NVL(WARN_COUNTER, 0),  NVL(INFO_COUNTER, 0) FROM MGMT_POLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND RESULT_KEY_VALUE = :B2 AND COLL_NAME = :B1
cw5gh4duww26p
SELECT COUNT(*) AS c  from (          select mm.*, nvl2(t3.soft_name, t3.soft_name, mm.soft_name) as soft_desc      from (select distinct m.* from    (select s.soft_id, t1.version_no, t1.creater_time, t2.remark, t2.version_detail_id, nvl(buy_price,    default_bprice) as price, t4.CUR_ID, t4.cur_code, s.soft_name        from diag_soft s, sys_product p, sys_vender v, diag_soft_price pr, diag_soft_version t1, diag_soft_version_detail t2, sys_currency_unit t4          where s.pdt_type_id = p.pdt_type_id and s.soft_id = pr.soft_id        and           v.cur_id = pr.cur_id                and p.vender_id = v.vender_id        and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and pr.cur_id = t4.cur_id and upper(s.soft_name) not like '%ZY' and upper(s.soft_name) not in ('KARRY',  'ZHONGXINGZHY')    and s.soft_id not in(select ds.soft_id from diag_soft ds where ds.pdt_type_id in (121, 142,  143 ) and ds.soft_name in ('WLGY', 'LAIYANG''DFG', 'HIGER', 'QIRUIZYDISPLAY', 'KINGLONG', 'UFO', 'DFACLX', 'YUCHAI', 'DFAC_CHAOCHAI', 'RIICH', 'ZZMAZDA', 'HQE', 'DFBF', 'DFAC_SHANGYONG', 'QUANCHAI', 'JMMOTOR', 'DIAS', 'WXDIESEL', 'BJGJ', 'JAC', 'YQHT', 'TJYQZYMID', 'CHDAIHATSU', 'MYXINCHEN', 'DETC', 'ZHONGXINGZHY', 'WABCOABS', 'HANGTIANMIT', 'SPARK', 'DFCNG', 'NJXYT', 'ZHONGHUAO3', 'ZHONGHUAEN', 'CHANGCHENGZY_CN', 'NJYWK', 'GREATWALL', 'QIRUI', 'LIUWEI', 'KARRY', 'RELY'))      and s.soft_id not in (select soft_id from diag_user_soft_center  where user_id = :1  and serial_no = :2)
                and s.soft_id not in (select uz.soft_id from user_order u,    order_detail_info uz where u.order_id = uz.order_id and u.user_id = :3    and               u.order_status in (0,  1, 3) and u.serial_no = :4)        and p.serial_no = :5 and p.pdt_state = 1 and p.user_id = :6        and t2.lan_id = :7 and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2)m,     (select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s where r.version_id = rr.version_id    and lan_id = :8 and s.soft_id = r.soft_id and s.valid_flag  = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2     group by r.soft_id, lan_id )n      where m.soft_id = n.soft_id and m.version_no = n.version_no             )mm left join diag_soft_desc  t3 on mm.soft_id = t3.soft_id and t3.lan_id = :9        )     
dx9uj64072dw7select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc      
fcb5u7n0r523mSELECT NVL(AVG((VALUE*1000.0)/DURATION), 0),    NVL((((SUM(DURATION)/(60*1000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A,  MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0
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')
fqmpmkfr6pqykselect s.synonym_name object_name,  o.object_type
from sys.all_synonyms s,
     sys.all_objects o
where s.owner in ('PUBLIC',  user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE',    'VIEW',  'PACKAGE', 'TYPE',  'PROCEDURE',  'FUNCTION',    'SEQUENCE')
fsbqktj5vw6n9
select next_run_date,  obj#,  run_job,    sch_job from (select decode(bitand(a.flags,  16384),  0,  a.next_run_date,           a.last_enabled_time) next_run_date,          a.obj# obj#,  decode(bitand(a.flags,  16384),  0,  0,  1) run_job,  a.sch_job  sch_job  from  (select p.obj# obj#,  p.flags flags,  p.next_run_date next_run_date,       p.job_status job_status,  p.class_oid class_oid,       p.last_enabled_time last_enabled_time,  p.instance_id instance_id,       1 sch_job   from sys.scheduler$_job p   where bitand(p.job_status,  3) = 1    and ((bitand(p.flags,  134217728 + 268435456) = 0) or       (bitand(p.job_status,  1024) <> 0))    and bitand(p.flags,  4096) = 0      and p.instance_id is NULL    and (p.class_oid is null      or (p.class_oid is not null      and p.class_oid in (select b.obj# from sys.scheduler$_class b                 where b.affinity is null)))   UNION ALL   select q.obj#,  q.flags,  q.next_run_date,  q.job_status,  q.class_oid,         q.last_enabled_time,  q.instance_id,  1   from sys.scheduler$_lightweight_job q   where bitand(q.job_status,  3) = 1    and ((bitand(q.flags,  134217728 + 268435456) = 0) or       (bitand(q.job_status,  1024) <> 0))    and bitand(q.flags,  4096) = 0      and q.instance_id is NULL    and (q.class_oid is null      or (q.class_oid is not null      and q.class_oid in (select c.obj# from sys.scheduler$_class c                 where c.affinity is null)))   UNION ALL   select j.job,  0,  from_tz(ca
st(j.next_date as timestamp),        to_char(systimestamp, 'TZH:TZM')),    1,  NULL,    from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')),    NULL,  0   from sys.job$ j   where (j.field1 is null or j.field1 = 0)     and j.this_date is null) a   order by 1)   where rownum = 1
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins,  updates = updates + :upd,  deletes = deletes + :del,  flags = (decode(bitand(flags,  :flag),  :flag,  flags,  flags + :flag)),  drop_segments = drop_segments + :dropseg,  timestamp = :time where obj# = :objn
g4gp07gt2z920update sys.scheduler$_job set  last_start_date = :1,  running_instance = :2,  running_slave = :3,  job_status = :4 where  obj# = :5
g4kcn01rx9d0m
SELECT COUNT(*) AS c  from (          select m.*         from (select s.soft_id,  t1.version_no,  t1.creater_time,    t4.soft_name as soft_desc,   t2.remark,  t2.version_detail_id,                nvl(UPGRADE_PRICE,    DEFAULT_BPRICE) as price,  v.CUR_ID, t5.cur_code             from diag_soft s,    sys_product p,    sys_vender v,  diag_soft_price pr,  diag_soft_version t1,  diag_soft_version_detail t2,               diag_user_soft_center    t3, diag_soft_desc t4, sys_currency_unit t5                where s.pdt_type_id = p.pdt_type_id and  s.soft_id = pr.soft_id and v.cur_id = pr.cur_id   and upper(s.soft_name)  not like '%ZY'  and               t4.soft_id = s.soft_id and t4.lan_id = :1 and pr.cur_id = t5.cur_id and               p.vender_id = v.vender_id and s.soft_id = t1.soft_id and t1.version_id = t2.version_id and                 s.soft_id = t3.soft_id and t3.user_id = :2 and  t3.free_end_time < sysdate and p.serial_no = :3             and p.serial_no = t3.serial_no and p.pdt_state = 1 and p.user_id = :4 and t2.lan_id = :5             and s.VALID_FLAG = 1 and t1.VALID_FLAG = 1 and t2.CHECK_STATE = 2 and pr.STATE = 2) m,           (select r.soft_id, max(version_no)as version_no, lan_id            from diag_soft_version r , diag_soft_version_detail rr, diag_soft s              where r.version_id = rr.version_id          and lan_id = :6 and s.soft_id = r.soft_id
and s.valid_flag  = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2           group by r.soft_id, lan_id ) n          where m.soft_id = n.soft_id and m.version_no = n.version_no           and not exists       (        select 1 from           (            select r.soft_id, max(version_no)as version_no, lan_id from diag_soft_version r , diag_soft_version_detail rr, diag_soft s              where r.version_id = rr.version_id            and lan_id = :7 and s.soft_id = r.soft_id and s.valid_flag  = 1 and r.VALID_FLAG = 1 and rr.CHECK_STATE = 2               group by r.soft_id, lan_id        ) tr,                  (            select  soft_id, info.version from user_order uo,  order_detail_info info              where uo.order_id = info.order_id and              uo.order_status in (0,  1, 3)  and uo.serial_no = :8 and uo.buy_origin = 1  and             uo.user_id = :9        ) rt          where tr.soft_id = rt.soft_id and tr.version_no = rt.version                  )      )         
gfdn12rn0fg3mSELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :B1
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)


Back to SQL Statistics

Back to Top





Instance Activity Statistics



Back to Top



Instance Activity Stats



  • Ordered by statistic name























































































































































































































































StatisticTotalper Secondper Trans
Batched IO (bound) vector count180.010.00
Batched IO (full) vector count180.010.00
Batched IO block miss count3,0130.870.77
Batched IO buffer defrag count130.000.00
Batched IO double miss count10.000.00
Batched IO same unit count2010.060.05
Batched IO single block count50.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count2,8250.820.73
Batched IO vector read count320.010.01
Block Cleanout Optim referenced180.010.00
CCursor + sql area evicted230.010.01
CPU used by this session745,503215.99191.65
CPU used when call started744,593215.73191.41
CR blocks created890.030.02
Cached Commit SCN referenced00.000.00
Commit SCN cached490.010.01
DB time3,905,0211,131.391,003.86
DBWR checkpoint buffers written3,8201.110.98
DBWR checkpoints220.010.01
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written2480.070.06
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes1520.040.04
DBWR undo block writes6180.180.16
DFO trees parallelized00.000.00
HSC Heap Segment Block Changes11,2503.262.89
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1270.040.03
Heap Segment Array Updates860.020.02
IMU CR rollbacks1040.030.03
IMU Flushes1,5610.450.40
IMU Redo allocation size4,224,0601,223.821,085.88
IMU commits2,3850.690.61
IMU contention2820.080.07
IMU ktichg flush00.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush30.000.00
IMU undo allocation size8,752,5842,535.852,250.02
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued17,6695.124.54
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations not downgraded00.000.00
RowCR - row contention40.000.00
RowCR attempts670.020.02
RowCR hits630.020.02
SMON posted for dropping temp segment00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client3,107,787900.41798.92
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout2830.080.07
application wait time5,2351.521.35
auto extends on undo tablespace00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts14,2984.143.68
branch node splits00.000.00
buffer is not pinned count7,697,4512,230.151,978.78
buffer is pinned count17,059,6754,942.644,385.52
bytes received via SQL*Net from client252,797,47873,242.0964,986.50
bytes sent via SQL*Net to client721,096,370208,920.61185,371.82
calls to get snapshot scn: kcmgss1,240,331359.36318.85
calls to kcmgas6,1531.781.58
calls to kcmgcs504,271146.10129.63
cell physical IO interconnect bytes16,962,907,1364,914,600.884,360,644.51
change write time590.020.02
cleanout - number of ktugct calls2890.080.07
cleanouts and rollbacks - consistent read gets70.000.00
cleanouts only - consistent read gets100.000.00
cluster key scan block gets2,2780.660.59
cluster key scans2,0340.590.52
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed120.000.00
commit batch/immediate requested120.000.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure70.000.00
commit cleanout failures: cannot pin2590.080.07
commit cleanouts17,9385.204.61
commit cleanouts successfully completed17,6725.124.54
commit immediate performed120.000.00
commit immediate requested120.000.00
commit txn count during cleanout9070.260.23
concurrency wait time33,1539.618.52
consistent changes3730.110.10
consistent gets22,563,4676,537.235,800.38
consistent gets - examination3,422,629991.63879.85
consistent gets direct2,011,474582.78517.09
consistent gets from cache20,551,9935,954.455,283.29
consistent gets from cache (fastpath)16,904,6314,897.724,345.66
cursor authentications990.030.03
data blocks consistent reads - undo records applied3770.110.10
db block changes63,37518.3616.29
db block gets92,58926.8323.80
db block gets direct1260.040.03
db block gets from cache92,46326.7923.77
db block gets from cache (fastpath)26,6177.716.84
deferred (CURRENT) block cleanout applications12,0603.493.10
dirty buffers inspected00.000.00
enqueue conversions9020.260.23
enqueue deadlocks00.000.00
enqueue releases47,91113.8812.32
enqueue requests47,92413.8812.32
enqueue timeouts00.000.00
enqueue waits570.020.01
exchange deadlocks00.000.00
execute count1,229,498356.22316.07
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time1,603,093,548464,458.42412,106.31
free buffer inspected44,22712.8111.37
free buffer requested38,89711.2710.00
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress1810.050.05
hot buffers moved to head of LRU16,5764.804.26
immediate (CR) block cleanout applications170.000.00
immediate (CURRENT) block cleanout applications8290.240.21
index crx upgrade (positioned)60.000.00
index crx upgrade (prefetch)00.000.00
index fast full scans (full)930.030.02
index fetch by key2,742,019794.44704.89
index scans kdiixs11,225,069354.93314.93
leaf node 90-10 splits550.020.01
leaf node splits780.020.02
lob reads6050.180.16
lob writes120.000.00
lob writes unaligned120.000.00
logons cumulative2940.090.08
max cf enq hold time00.000.00
messages received28,6538.307.37
messages sent28,6538.307.37
min active SCN optimization applied on CR70.000.00
no buffer to keep pinned count640.020.02
no work - consistent read gets18,528,8205,368.294,763.19
non-idle wait count3,436,817995.74883.50
non-idle wait time438,036126.91112.61
opened cursors cumulative1,227,949355.77315.67
parse count (describe)00.000.00
parse count (failures)20.000.00
parse count (hard)2230.060.06
parse count (total)1,225,129354.95314.94
parse time cpu9910.290.25
parse time elapsed8,2152.382.11
physical read IO requests48,49414.0512.47
physical read bytes16,787,406,8484,863,753.834,315,528.75
physical read total IO requests54,03015.6513.89
physical read total bytes16,878,313,4724,890,091.874,338,898.06
physical read total multi block requests15,9364.624.10
physical reads2,049,244593.72526.80
physical reads cache37,77010.949.71
physical reads cache prefetch9,8962.872.54
physical reads direct2,011,474582.78517.09
physical reads direct (lob)5390.160.14
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests2,4960.720.64
physical write bytes32,325,6329,365.598,309.93
physical write total IO requests9,1612.652.36
physical write total bytes84,593,66424,509.0121,746.44
physical write total multi block requests440.010.01
physical writes3,9461.141.01
physical writes direct1260.040.03
physical writes direct (lob)10.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache3,8201.110.98
physical writes non checkpoint1,4390.420.37
pinned buffers inspected00.000.00
pinned cursors current20.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time4,6411.341.19
queries parallelized00.000.00
recursive calls618,117179.08158.90
recursive cpu usage7300.210.19
redo blocks checksummed by FG (exclusive)16,4314.764.22
redo blocks written31,8149.228.18
redo buffer allocation retries00.000.00
redo entries20,4615.935.26
redo k-bytes read total00.000.00
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks4440.130.11
redo size14,608,6724,232.523,755.44
redo size for direct writes1,036,728300.37266.51
redo subscn max counts1,4210.410.37
redo synch time106,03130.7227.26
redo synch writes4,1561.201.07
redo wastage1,054,016305.38270.96
redo write time66,15019.1717.01
redo writes4,4561.291.15
remote Oradebug requests00.000.00
rollback changes - undo records applied340.010.01
rollbacks only - consistent read gets920.030.02
root node splits00.000.00
rows fetched via callback2,131,687617.61547.99
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits1,014,966294.06260.92
session logical reads22,656,0566,564.065,824.18
shared hash latch upgrades - no wait108,21531.3527.82
shared hash latch upgrades - wait70.000.00
sorts (disk)00.000.00
sorts (memory)67,82619.6517.44
sorts (rows)3,403,989986.23875.06
sql area evicted2420.070.06
sql area purged20.000.00
summed dirty queue length00.000.00
switch current to new buffer1800.050.05
table fetch by rowid10,520,7413,048.142,704.56
table fetch continued row90,55226.2423.28
table scan blocks gotten12,190,3273,531.863,133.76
table scan rows gotten1,248,918,757361,844.65321,058.81
table scans (direct read)780.020.02
table scans (long tables)6890.200.18
table scans (rowid ranges)00.000.00
table scans (short tables)185,54353.7647.70
temp space allocated (bytes)00.000.00
total cf enq hold time18,6505.404.79
total number of cf enq holders2400.070.06
total number of times SMON posted10.000.00
transaction rollbacks120.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size3,789,6001,097.95974.19
user I/O wait time154,68544.8239.76
user calls4,316,8891,250.721,109.74
user commits3,8861.131.00
user rollbacks40.000.00
workarea executions - multipass00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal71,90720.8318.49
write clones created in background00.000.00
write clones created in foreground330.010.01


Back to Instance Activity Statistics

Back to Top



Instance Activity Stats - Absolute Values



  • Statistics with absolute values (should not be diffed)











StatisticBegin ValueEnd Value
session uga memory max1,262,814,757,0481,263,365,716,816
session pga memory400,626,849,424400,791,229,416
session pga memory max451,109,873,904451,258,867,304
session cursor cache count11,764,83811,772,490
session uga memory704,301,310,874,448704,576,210,686,704
opened cursors current368414
workarea memory allocated1,7242,980
logons current102117


Back to Instance Activity Statistics

Back to Top



Instance Activity Stats - Thread Activity



  • Statistics identified by '(derived)' come from sources other than SYSSTAT




StatisticTotalper Hour
log switches (derived)00.00


Back to Instance Activity Statistics

Back to Top





IO Stats



Back to Top



IOStat by Function summary



  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024       other columns suffixed with K,M,G,T,P are in multiples of 1000

  • ordered by (Data Read + Write) desc










Function NameReads: DataReqs   per secData   per secWrites: DataReqs   per secData   per secWaits: CountAvg   Tm(ms)
Direct Reads15.3G5.124.552750M0.000M17.7K1.45
Buffer Cache Reads295M8.93.0854690M0.000M27.9K45.34
Others86M1.60.02491634M0.64.009850773398.07
DBWR0M0.000M30M0.72.008691885372.66
LGWR0M0.000M15M1.29.0043454456147.91
Direct Writes0M0.000M1M0.00.000289130.00
TOTAL:15.7G15.664.6631480M2.65.02317858.7K51.79


Back to IO Stats

Back to Top



IOStat by Filetype summary



  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024       other columns suffixed with K,M,G,T,P are in multiples of 1000

  • Small Read and Large Read are average service times, in milliseconds

  • Ordered by (Data Read + Write) desc







Filetype NameReads: DataReqs   per secData   per secWrites: DataReqs   per secData   per secSmall ReadLarge Read
Data File15.6G14.054.6388028M0.72.00811239.280.75
Control File87M1.60.02520634M0.64.0098500.81 
Log File0M0.000M16M1.30.004635  
TOTAL:15.7G15.654.6640178M2.65.02259833.700.75


Back to IO Stats

Back to Top



IOStat by Function/Filetype summary



  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024       other columns suffixed with K,M,G,T,P are in multiples of 1000

  • Ordered by (Data Read + Write) desc for each function

















Function/File NameReads: DataReqs   per secData   per secWrites: DataReqs   per secData   per secWaits: CountAvg   Tm(ms)

Direct Reads
15.3G5.124.552750M0.000M0 

 Direct Reads (Data File)
15.3G5.124.552750M0.000M0 

Buffer Cache Reads
295M8.93.0854690M0.000M27.8K45.44

 Buffer Cache Reads (Data File)
295M8.93.0854690M0.000M27.8K45.44

Others
86M1.60.02491634M0.64.00985055370.81

 Others (Control File)
86M1.60.02491634M0.64.00985055270.81

 Others (Data File)
0M0.000M0M0.000M100.20

DBWR
0M0.000M30M0.72.0086910 

 DBWR (Data File)
0M0.000M30M0.72.0086910 

LGWR
0M0.000M16M1.30.0046350 

 LGWR (Log File)
0M0.000M16M1.30.0046350 

Direct Writes
0M0.000M1M0.00.0002890 

 Direct Writes (Data File)
0M0.000M1M0.00.0002890 

TOTAL:
15.7G15.664.6631481M2.65.02346733.4K38.04


Back to IO Stats

Back to Top



Tablespace IO Stats



  • ordered by IOs (Reads + Writes) desc













TablespaceReadsAv    Reads/sAv   Rd(ms)Av     Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
MYCAR45,5671327.8244.911,46904,82446.60
SYSTEM2,83910.481.0078000.00
SYSAUX72011.111.04559000.00
UNDOTBS1000.000.00323010.00
PASSPORT140220.001.0067000.00


Back to IO Stats

Back to Top



File IO Stats



  • ordered by Tablespace, File















TablespaceFilenameReadsAv      Reads/sAv   Rd(ms)Av    Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
MYCAR/oracle/oradata/mycar/mycar.dbf42,7251229.3442.5851104,71647.03
MYCAR/oracle/oradata/mycar/mycar01.dbf2,84214.9679.97958010827.69
PASSPORT/oracle/oradata/mycar/passport.dbf140220.001.0067000.00
SYSAUX/oracle/oradata/mycar/sysaux01.dbf72011.111.04559000.00
SYSTEM/oracle/oradata/mycar/system01.dbf2,83910.481.0078000.00
UNDOTBS1/oracle/oradata/mycar/undotbs01.dbf00  323010.00


Back to IO Stats

Back to Top





Buffer Pool Statistics



Back to Top



Buffer Pool Statistics



  • Standard block size Pools  D: default,  K: keep,  R: recycle

  • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k




PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D96,53010020,643,53037,7753,820004,825


Back to Buffer Pool Statistics

Back to Top



Checkpoint Activity



  • Total Physical Writes:                  3,946




MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00003,5720


Back to Buffer Pool Statistics

Back to Top





Advisory Statistics



Back to Top



Instance Recovery Stats



  • B: Begin Snapshot,  E: End Snapshot





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
B014366166553519953285351   
E014761122182306299532823062   


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



  • Only rows with estimated physical reads >0 are displayed

  • ordered by Block Size, Buffers For Estimate























PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D800.10101.672,619,32511332310.00
D1600.20201.021,591,052161015.00
D2400.30301.001,570,724135883.00
D3200.40391.001,566,725130938.00
D4000.50491.001,566,098130164.00
D4800.60591.001,565,670129634.00
D5600.70691.001,565,378129273.00
D6400.80791.001,565,097128926.00
D7200.90891.001,564,862128636.00
D8001.00991.001,564,683128414.00
D8801.101081.001,564,500128188.00
D9601.201181.001,564,338127987.00
D1,0401.301281.001,564,223127845.00
D1,1201.401381.001,564,138127741.00
D1,2001.501481.001,564,068127653.00
D1,2801.601581.001,563,993127561.00
D1,3601.701671.001,563,333126745.00
D1,4401.801770.971,513,77318334.00
D1,5201.901870.961,502,53718331.00
D1,6002.001970.921,439,83918314.00


Back to Advisory Statistics

Back to Top



PGA Aggr Summary



  • PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory




PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.0010,8780


Back to Advisory Statistics

Back to Top



PGA Aggr Target Stats




          No data exists for this section of the report.


Back to Advisory Statistics

Back to Top



PGA Aggr Target Histogram



  • Optimal Executions are purely in-memory operations











  Low Optimal  High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K54,35754,35700
64K128K3,4463,44600
128K256K1,9581,95800
256K512K585800
512K1024K11,47511,47500
1M2M55055000
2M4M515100
4M8M121200


Back to Advisory Statistics

Back to Top



PGA Memory Advisory



  • When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value    where Estd PGA Overalloc Count is 0

















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
1420.1324,946,143.0752,492,447.7432.00364,97891,329,156,593
2840.2524,946,143.0752,330,706.6832.00360,84191,138,403,190
5680.5024,946,143.0713,323,513.8365.00945,134,285,775
8520.7524,946,143.0712,959,882.2166.00044,705,427,649
1,1361.0024,946,143.0712,103,143.6767.00043,695,011,420
1,3631.2024,946,143.0711,942,180.4768.00043,505,175,417
1,5901.4024,946,143.0711,942,030.6568.00043,504,998,719
1,8181.6024,946,143.0711,941,919.7368.00043,504,867,898
2,0451.8024,946,143.0711,941,919.7368.00043,504,867,898
2,2722.0024,946,143.0711,941,919.7368.00043,504,867,898
3,4083.0024,946,143.0711,941,919.7368.00043,504,867,898
4,5444.0024,946,143.0711,941,760.1468.00043,504,679,682
6,8166.0024,946,143.0711,941,760.1468.00043,504,679,682
9,0888.0024,946,143.0711,941,760.1468.00043,504,679,682


Back to Advisory Statistics

Back to Top



Shared Pool Advisory



  • SP: Shared Pool     Est LC: Estimated Library Cache   Factr: Factor

  • Note there is often a 1:Many correlation between a single logical object    in the Library Cache, and the physical number of memory objects associated    with it.  Therefore comparing the number of Lib Cache objects (e.g. in     v$librarycache), with the number of Lib Cache Memory Objects is invalid.


















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)
7520.59482,7386,992,7991.00231,9091.08126,062
8800.701768,9496,997,6551.00227,0531.06337,899
1,0080.8030413,3977,006,6261.00218,0821.02338,518
1,1360.9043217,8627,008,6141.00216,0941.01338,780
1,2641.0056021,5647,010,2101.00214,498338,998
1,3921.1068824,8297,011,5581.00213,1500.99339,187
1,5201.2081528,2127,012,3111.00212,3970.99339,298
1,6481.3094331,2077,012,6631.00212,0450.99339,347
1,7761.411,07134,7277,013,0011.00211,7070.99339,380
1,9041.511,19937,7967,013,2331.00211,4750.99339,398
2,0321.611,32740,9397,013,4181.00211,2900.99339,413
2,1601.711,45545,1047,013,5571.00211,1510.98339,423
2,2881.811,58349,1297,013,7001.00211,0080.98339,433
2,4161.911,71152,5517,013,8251.00210,8830.98339,442
2,5442.011,83955,8397,013,8961.00210,8120.98339,449


Back to Advisory Statistics

Back to Top



SGA Target Advisory












SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,0720.505,975,0011,570,002,873
1,6080.755,953,5851,565,465,292
2,1441.005,948,8261,564,682,951
2,6801.255,931,5741,501,939,165
3,2161.505,927,4101,513,048,414
3,7521.755,926,2201,513,048,414
4,2882.005,926,2201,439,195,378


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)
160.500000
321.000000
481.500000
642.000000
802.500000
963.000000
1123.500000
1284.000000
1444.500000
1605.000000
1765.500000
1926.000000
2086.500000
2247.000000
2407.500000
2568.000000
2728.500000
2889.000000
3049.500000
32010.000000


Back to Advisory Statistics

Back to Top



Java Pool Advisory




          No data exists for this section of the report.


Back to Advisory Statistics

Back to Top





Wait Statistics



Back to Top



Buffer Wait Statistics



  • ordered by wait time desc, waits desc





ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block4,82422547
undo header100


Back to Wait Statistics

Back to Top



Enqueue Activity



  • only enqueues with waits are shown 

  • Enqueue stats gathered prior to 10g should not be compared with 10g data

  • ordered by Wait Time desc, Waits desc













Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
KO-Multiple Object Checkpoint (fast object checkpoint)198198022512,311.82
CF-Controlfile Transaction1,5101,5100231,615.00
TX-Transaction (index contention)13130103309.00
TX-Transaction (row lock contention)15150131114.62
SQ-Sequence Cache79079001000.00


Back to Wait Statistics

Back to Top





Undo Statistics



Back to Top



Undo Segment Summary



  • Min/Max TR (mins) - Min and Max Tuned Retention (minutes)

  • STO - Snapshot Too Old count,    OOS - Out of Space count

  • Undo segment block stats:

  • uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed

  • eS - expired    Stolen,   eR - expired     Released,   eU - expired   reUsed




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
20.272,8337954240/2400/00/0/0/0/0/0


Back to Undo Statistics

Back to Top



Undo Segment Stats



  • Most recent 35 Undostat rows, ordered by Time desc








End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS  uS/uR/uU/   eS/eR/eU
04-Jul 14:508973279532400/00/0/0/0/0/0
04-Jul 14:404661812522400/00/0/0/0/0/0
04-Jul 14:305145478842400/00/0/0/0/0/0
04-Jul 14:206484118522400/00/0/0/0/0/0
04-Jul 14:101818878132400/00/0/0/0/0/0


Back to Undo Statistics

Back to Top





Latch Statistics



Back to Top



Latch Activity



  • "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for     willing-to-wait latch get requests

  • "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests

  • "Pct Misses" for both should be very close to 0.0








































































































































































































































Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch30.00 00 
ASM db client latch2,1780.00 00 
ASM map operation hash table30.00 00 
ASM network state latch600.00 00 
AWR Alerted Metric Element list29,9950.00 00 
Change Notification Hash table latch1,1360.00 00 
Consistent RBA4,4560.00 00 
DML lock allocation108,3620.00 00 
Event Group Locks2330.00 00 
FAL Queue1570.00 00 
FOB s.o list latch9230.00 00 
File State Object Pool Parent Latch30.00 00 
IPC stats buffer allocation latch30.00 00 
In memory undo latch37,0180.020.8904,6790.00
JS Sh mem access110.00 00 
JS mem alloc latch60.00 00 
JS queue access latch90.00 00 
JS queue state obj latch23,7220.00 00 
JS slv state obj latch1,360,8620.350.0000 
KFC FX Hash Latch30.00 00 
KFC Hash Latch30.00 00 
KFCL LE Freelist30.00 00 
KGNFS-NFS:SHM structure30.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list30.00 00 
KJCT flow control latch30.00 00 
KMG MMAN ready and startup request latch1,1500.00 00 
KTF sga latch180.00 08980.00
KWQP Prop Status20.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch660.00 00 
Locator state objects pool parent latch30.00 00 
Lsod array latch30.00 00 
MQL Tracking Latch0  0680.00
Memory Management Latch30.00 01,1500.00
Memory Queue30.00 00 
Memory Queue Message Subscriber #130.00 00 
Memory Queue Message Subscriber #230.00 00 
Memory Queue Message Subscriber #330.00 00 
Memory Queue Message Subscriber #430.00 00 
Memory Queue Subscriber30.00 00 
MinActiveScn Latch170.00 00 
Mutex30.00 00 
Mutex Stats30.00 00 
OS process1,4160.00 00 
OS process allocation2,0810.00 00 
OS process: request allocation4450.00 00 
PL/SQL warning settings4900.00 00 
PX hash array latch30.00 00 
QMT30.00 00 
Real-time plan statistics latch3,8570.00 00 
SGA IO buffer pool latch10.00 010.00
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA pool locks30.00 00 
SQL memory manager latch1150.00 01,0300.00
SQL memory manager workarea list latch338,7940.00 00 
Shared B-Tree3000.00 00 
Streams Generic30.00 00 
Testing30.00 00 
Token Manager30.00 00 
WCR: sync30.00 00 
Write State Object Pool Parent Latch30.00 00 
X$KSFQP2,3320.00 00 
XDB NFS Security Latch30.00 00 
XDB unused session pool30.00 00 
XDB used session pool30.00 00 
active checkpoint queue latch24,7000.00 00 
active service list7,9680.010.0003,4810.00
archive control580.00 00 
archive process latch4710.421.0000 
begin backup scn array130.00 00 
buffer pool30.00 00 
business card30.00 00 
cache buffer handles18,1480.00 00 
cache buffers chains38,203,8090.020.0229881,2590.00
cache buffers lru chain4,2500.021.0007,162,1200.01
cache table scan latch3,1910.00 03,1910.00
call allocation1,2590.320.5000 
cas latch30.00 00 
change notification client cache latch30.00 00 
channel handle pool latch5010.00 00 
channel operations parent latch16,8300.00 00 
checkpoint queue latch463,1140.00 04,0830.00
client/application info2,1440.00 00 
compile environment latch2940.00 00 
corrupted undo seg latch1140.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch600.00 00 
cvmap freelist lock30.00 00 
deferred cleanup latch600.00 00 
dml lock allocation600.00 00 
done queue latch30.00 00 
dummy allocation5760.00 00 
enqueue hash chains96,8480.000.000170.00
enqueues57,0270.010.0000 
fifth spare latch30.00 00 
file cache latch2590.00 00 
flashback copy30.00 00 
gc element30.00 00 
gcs commit scn state30.00 00 
gcs partitioned table hash30.00 00 
gcs pcm hashed value bucket hash30.00 00 
gcs resource freelist30.00 00 
gcs resource hash30.00 00 
gcs resource scan list30.00 00 
gcs shadows freelist30.00 00 
ges domain table30.00 00 
ges enqueue table freelist30.00 00 
ges group table30.00 00 
ges process hash list30.00 00 
ges process parent latch30.00 00 
ges resource hash list30.00 00 
ges resource scan list30.00 00 
ges resource table freelist30.00 00 
ges value block free list30.00 00 
global KZLD latch for mem in SGA1000.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch1950.00 0161,0800.00
hash table modification latch970.00 00 
heartbeat check30.00 00 
intra txn parallel recovery30.00 00 
io pool granule metadata list30.00 00 
job workq parent latch670.00 0640.00
job_queue_processes free list latch1320.00 00 
job_queue_processes parameter latch7750.00 00 
k2q lock allocation30.00 00 
kdlx hb parent latch30.00 00 
kgb parent30.00 00 
kks stats1,6420.00 00 
kokc descriptor allocation latch4980.00 00 
ksfv messages30.00 00 
kss move lock370.00 00 
ksuosstats global area2340.00 00 
ksv allocation latch1290.00 00 
ksv class latch730.00 00 
ksv msg queue latch30.00 00 
ksz_so allocation latch4450.00 00 
ktm global data170.00 00 
kwqbsn:qsga1260.00 00 
lgwr LWN SCN5,2820.00 00 
list of block allocation5430.00 00 
loader state object freelist1,2100.00 00 
lob segment dispenser latch30.00 00 
lob segment hash table latch130.00 00 
lob segment query latch30.00 00 
lock DBA buffer during media recovery30.00 00 
logical standby cache30.00 00 
logminer context allocation40.00 00 
logminer work area30.00 00 
longop free list parent40.00 010.00
managed standby latch1570.00 00 
mapped buffers lru chain30.00 00 
message pool operations parent latch1830.00 00 
messages91,4650.000.0000 
mostly latch-free SCN5,2810.020.0000 
msg queue latch30.00 00 
multiblock read objects13,4440.00 00 
name-service namespace bucket30.00 00 
ncodef allocation latch600.00 00 
object queue header heap760.00 050.00
object queue header operation283,3550.001.0000 
object stats modification120.00 00 
parallel query alloc buffer4430.00 00 
parallel query stats30.00 00 
parameter list3530.00 00 
parameter table management5760.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
post/wait queue14,2290.010.00012,2100.01
process allocation5730.00 02300.00
process group creation4450.00 00 
process queue30.00 00 
process queue reference30.00 00 
qmn task queue latch8750.00 00 
query server freelists30.00 00 
queued dump request110.00 00 
queuing load statistics30.00 00 
recovery domain hash list30.00 00 
redo allocation24,3500.020.20020,5430.04
redo copy30.00 020,5470.06
redo writing40,1200.00 00 
resmgr group change latch4690.00 00 
resmgr:active threads5740.00 00 
resmgr:actses change group1860.00 00 
resmgr:actses change state30.00 00 
resmgr:free threads list5730.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method30.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects1,130,5530.010.1211520.00
rules engine rule set statistics1000.00 00 
second spare latch30.00 00 
sequence cache25,5600.00 00 
session allocation1,549,4580.000.000516,4950.00
session idle bit9,149,7730.000.0100 
session queue latch30.00 00 
session state list latch6510.00 00 
session switching1,1380.00 00 
session timer1,2570.00 00 
shared pool38,9730.280.1580 
shared pool sim alloc30.00 00 
shared pool simulator2,3380.00 00 
sim partition latch30.00 00 
simulator hash latch2,291,9520.000.0000 
simulator lru latch1,7290.00 01,510,5290.06
sort extent pool960.00 00 
space background state object latch40.00 00 
space background task latch2,2480.00 02,2940.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain30.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
third spare latch30.00 00 
threshold alerts latch1640.00 00 
transaction allocation21,3610.00 00 
undo global data25,7650.00 00 
virtual circuit buffers30.00 00 
virtual circuit holder30.00 00 
virtual circuit queues30.00 00 


Back to Latch Statistics

Back to Top



Latch Sleep Breakdown



  • ordered by misses desc














Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains38,203,8098,9431558,792
JS slv state obj latch1,360,8624,77240
session idle bit9,149,7733955390
shared pool38,9731091695
row cache objects1,130,55367859
In memory undo latch37,018981
redo allocation24,350514
call allocation1,259422
archive process latch471220
cache buffers lru chain4,250110
object queue header operation283,355110


Back to Latch Statistics

Back to Top



Latch Miss Sources



  • only latches with sleeps are shown

  • ordered by name, sleeps desc



























Latch NameWhereNoWait Misses   SleepsWaiter Sleeps
In memory undo latchktiFlush: child073
In memory undo latchkticmt: child012
archive process latchkcrrgpll021
cache buffers chainskcbgtcr: fast path (cr pin)07383
cache buffers chainskcbgtcr_203825
cache buffers chainskcbrls_103342
cache buffers chainskcbgtcr: fast path01310
cache buffers chainskcbzwb040
cache buffers chainskcbrls_2033
cache buffers chainskcbchg1: kslbegin: bufs not pinned010
cache buffers chainskcbgcur_2010
cache buffers lru chainkcbzgws010
call allocationksudlp: top call010
call allocationksuxds011
object queue header operationkcbo_service_ockpt017
redo allocationkcrfw_redo_gen: redo allocation 1010
row cache objectskqreqd: reget060
row cache objectskqrpre: find obj028
session idle bitksupuc: clear busy044
session idle bitksupuc: set busy032
shared poolkghalo0126
shared poolkghupr1021
shared poolkghalp010
shared poolkghfre019


Back to Latch Statistics

Back to Top



Mutex Sleep Summary



  • ordered by number of sleeps desc











Mutex TypeLocationSleepsWait    Time (ms)
Cursor Pinkksfbc [KKSCHLPIN1]70
Library Cachekgllkdl1  854480
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]30
Library CachekglIsOwnerVersionable 1212850
Library Cachekglpin1   420
Cursor PinkksLockDelete [KKSCHLPIN6]20
Library Cachekglhdgn2 10614,141
Library Cachekgllkc1   57144


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



  • Total Logical Reads:      22,656,056

  • Captured Segments account for    95.8% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeLogical Reads%Total
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE7,116,84831.41
MYCARMYCARIDX_LIN INDEX3,300,75214.57
MYCARMYCARDIAG_SOFT_DESC TABLE1,507,0086.65
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1,424,7846.29
MYCARMYCARSYS_SOFT_CONF TABLE1,112,3204.91


Back to Segment Statistics

Back to Top



Segments by Physical Reads



  • Total Physical Reads:        2,049,244

  • Captured Segments account for    99.8% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhysical Reads%Total
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1,411,45468.88
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE613,14829.92
MYCARMYCARDF_DATA_STREAM_DESC TABLE13,3070.65
MYCARMYCARI_STREAM_VERSION_DETAIL_ID INDEX7,0600.34
MYCARMYCAROPERATE_LOG TABLE2690.01


Back to Segment Statistics

Back to Top



Segments by Physical Read Requests



  • Total Physical Read Requests:           48,494

  • Captured Segments account for    92.1% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhys Read Requests%Total
MYCARMYCARDF_DATA_STREAM_DESC TABLE13,30727.44
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE12,43725.65
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE11,41823.55
MYCARMYCARI_STREAM_VERSION_DETAIL_ID INDEX7,06014.56
MYCARMYCAROPERATE_LOG TABLE2690.55


Back to Segment Statistics

Back to Top



Segments by UnOptimized Reads



  • Total UnOptimized Read Requests:      48,494

  • Captured Segments account for    92.1% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeUnOptimized Reads%Total
MYCARMYCARDF_DATA_STREAM_DESC TABLE13,30727.44
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE12,43725.65
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE11,41823.55
MYCARMYCARI_STREAM_VERSION_DETAIL_ID INDEX7,06014.56
MYCARMYCAROPERATE_LOG TABLE2690.55


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



  • Total Direct Physical Reads:       2,011,474

  • Captured Segments account for  100.0% of Total





OwnerTablespace      NameObject NameSubobject   NameObj. TypeDirect Reads%Total
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1,411,45470.17
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE599,48029.80


Back to Segment Statistics

Back to Top



Segments by Physical Writes



  • Total Physical Writes:         3,946

  • Captured Segments account for    41.1% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhysical Writes%Total
MYCARMYCAROPERATE_LOG TABLE52113.20
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1614.08
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE1553.93
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_9713TABLE PARTITION1393.52
MYCARMYCARIND_DIAG_DOWNLOAD_RECORD INDEX1253.17


Back to Segment Statistics

Back to Top



Segments by Physical Write Requests



  • Total Physical Write Requestss:       2,496

  • Captured Segments account for    36.5% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhys Write Requests%Total
MYCARMYCAROPERATE_LOG TABLE2389.54
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1435.73
MYCARMYCARSYS_PRODUCT TABLE843.37
MYCARMYCARIND_DIAG_DOWNLOAD_RECORD INDEX823.29
MYCARMYCARSYS_USER TABLE371.48


Back to Segment Statistics

Back to Top



Segments by Direct Physical Writes



  • Total Direct Physical Writes:          126

  • Captured Segments account for    99.2% of Total




OwnerTablespace      NameObject NameSubobject   NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_9713TABLE PARTITION12599.21


Back to Segment Statistics

Back to Top



Segments by Table Scans



  • Total Table Scans:           782

  • Captured Segments account for    90.8% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeTable Scans%Total
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE66785.29
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE222.81
MYCARMYCARPK_SYS_LAN INDEX101.28
MYCARMYCARPK_DIAG_SOFT_VERSION_DETAIL INDEX50.64
MYCARMYCARCO_PRIVATE_UNIFIED_ID INDEX40.51


Back to Segment Statistics

Back to Top



Segments by DB Blocks Changes



  • % of Capture shows % of DB Block Changes for each top segment compared 

  • with total DB Block Changes for all segments captured by the Snapshot








OwnerTablespace      NameObject NameSubobject   NameObj. TypeDB Block Changes% of Capture
MYCARMYCAROPERATE_LOG TABLE3,02433.81
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE1,36015.21
MYCARMYCARSOFTIDUSERIDSERIALNO_UNIQUE INDEX1,24813.95
MYCARMYCARPK_DIAG_USER_SOFT_CENTER INDEX94410.55
MYCARMYCARPK_DIAG_DOWNLOAD_RECORD INDEX5926.62


Back to Segment Statistics

Back to Top



Segments by Row Lock Waits



  • % of Capture shows % of row lock waits for each top segment compared 

  • with total row lock waits for all segments captured by the Snapshot





OwnerTablespace      NameObject NameSubobject   NameObj. TypeRow Lock Waits% of Capture
MYCARMYCARSYS_USER TABLE1451.85
MYCARMYCARPK_DIAG_DOWNLOAD_RECORD INDEX1348.15


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



  • % of Capture shows % of Buffer Busy Waits for each top segment compared 

  • with total Buffer Busy Waits for all segments captured by the Snapshot





OwnerTablespace      NameObject NameSubobject   NameObj. TypeBuffer Busy Waits% of Capture
MYCARMYCARPK_DIAG_DOWNLOAD_RECORD INDEX758.33
MYCARMYCARSYS_USER TABLE541.67


Back to Segment Statistics

Back to Top




Dictionary Cache Stats



  • "Pct Misses"  should be very low (< 2% in most cases)

  • "Final Usage" is the number of cache entries being used


















CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control640.000 21
dc_files90.000 09
dc_global_oids5360.000 061
dc_histogram_data6,4470.000 04,864
dc_histogram_defs7,1171.460 06,340
dc_objects6,8170.060 53,141
dc_profiles1660.000 01
dc_rollback_segments8250.000 022
dc_segments3,1760.000 171,596
dc_sequences7810.000 78143
dc_tablespaces169,5210.000 010
dc_users184,4880.000 0173
global database name2,4510.000 02
outstanding_alerts420.000 07
sch_lj_oids633.330 016



Back to Top




Library Cache Activity



  • "Pct Misses"  should be very low 














NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1,1050.001,5740.0000
CLUSTER690.00200.0000
DBLINK2040.000 00
EDITION1810.003450.0000
INDEX90.0090.0000
QUEUE600.001900.0000
SCHEMA3120.000 00
SQL AREA15,0852.561,247,0970.04782
SUBSCRIPTION110.00110.0000
TABLE/PROCEDURE5,1170.1230,3110.18220
TRIGGER180.00580.0000



Back to Top





Memory Statistics



Back to Top



Memory Dynamic Components



  • Min/Max sizes since instance startup

  • Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred

  • ordered by Component



















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 cache784.00784.00784.00816.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target1,136.001,136.001,136.001,136.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target2,144.002,144.002,144.002,144.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool16.0016.0016.0016.000STA/
large pool16.0016.0016.0016.000STA/
shared pool1,264.001,264.001,264.001,264.000STA/
streams pool32.0032.000.0032.000GRO/IMM


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



  • B: Begin Snap     E: End Snap 

  • All rows below contain absolute values (i.e. not diffed over the interval)

  • Max Alloc is Maximum PGA Allocation size at snapshot time 

  • Hist Max Alloc is the Historical Max Allocation for still-connected processes

  • ordered by Begin/End snapshot, Alloc (MB) desc











CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther391.81 3.777.802832104104
 Freeable57.060.001.040.684 5555
 SQL1.631.030.020.020418276
 PL/SQL1.230.980.010.0300102102
EOther407.75 3.437.342832119119
 Freeable73.250.001.110.634 6666
 SQL3.703.010.040.141419689
 PL/SQL1.601.260.010.0201117117


Back to Memory Statistics

Back to Top



SGA Memory Summary









SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers822,083,584 
Fixed Size2,218,152 
Redo Buffers15,970,304 
Variable Size2,583,693,144 


Back to Memory Statistics

Back to Top



SGA breakdown difference



  • ordered by Pool, Name    

  • N/A value for Begin MB or End MB indicates the size of that Pool/Name was    insignificant, or zero in that snapshot



















PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool7.507.500.00
largefree memory8.508.500.00
sharedCCUR87.0987.330.27
sharedFileOpenBlock15.2015.200.00
sharedKGLHD26.6326.47-0.62
sharedKGLS17.2617.15-0.65
sharedPCUR76.1276.06-0.08
sharedPLMCD13.2212.93-2.20
sharedSQLA486.56488.470.39
sharedfree memory335.52334.37-0.34
streamsKTG hash buckets1.261.260.00
streamsfree memory30.7230.720.00
 buffer_cache784.00784.000.00
 fixed_sga2.122.120.00
 log_buffer15.2315.230.00


Back to Memory Statistics

Back to Top





Streams Statistics



Back to Top



Streams CPU/IO Usage



  • Streams processes ordered by Foreground CPU Time, descending





Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator0326 18:10:230.000.000.00
QMON Slaves0326 18:10:330.000.000.00


Back to Streams Statistics

Back to Top



Streams Capture




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Streams Capture Rate




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Streams Apply




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Streams Apply Rate




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Buffered Queues




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Buffered Queue Subscribers




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Rule Set




          No data exists for this section of the report.


Back to Streams Statistics

Back to Top



Persistent Queues



  • Ordered by Queue Name

  • * indicates queue (re)started between Begin/End snaps

  • %Exp Msgs   - % of msgs enqueued with expiry

  • %Delay Msgs - % of msgs enqueued with delay

  • %Trasf Time - % of Enqueue time spent in transformation

  • %Eval Time  - % of Enqueue time spent in rule evaluation







Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time

SYS.ALERT_QUE(12343)
00  0.000.00  

SYS.AQ$_ALERT_QT_E(12342)
00  0.000.00  

SYSMAN.MGMT_NOTIFY_Q(66903)
00  0.000.00  

SYSMAN.MGMT_TASK_Q(66573)
51510.000.000.020.080.000.00


Back to Streams Statistics

Back to Top



Persistent Queues Rate



  • Ordered by Queue Name

  • * indicates queue (re)started between Begin/End snaps







Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg

SYS.ALERT_QUE(12343)
0.000.00  

SYS.AQ$_ALERT_QT_E(12342)
0.000.00  

SYSMAN.MGMT_NOTIFY_Q(66903)
0.000.00  

SYSMAN.MGMT_TASK_Q(66573)
0.010.010.000.00


Back to Streams Statistics

Back to Top



Persistent Queue Subscribers



  • Ordered by Queue Name, Subscriber Name

  • * indicates Subscriber activity (re)started between Begin/End snaps





Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec

HAE_SUB(1)/SYS.ALERT_QUE
000   

VM19216800003_3938_MYCAR(22)/SYS.ALERT_QUE
0000.000.000.00


Back to Streams Statistics

Back to Top




Resource Limit Stats




          No data exists for this section of the report.



Back to Top





Shared Server Statistics



Back to Top



Shared Servers Activity



  • Values represent averages for all samples




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



  • Statistics are combined for all servers

  • Incoming and Outgoing Net % are included in %Busy




Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,4620.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



  • Ordered by %Busy, descending

  • Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue

  • Name suffixes:       "(N)" - dispatcher started between begin and end snapshots    "(R)" - dispatcher re-started between begin and end snapshots




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


Back to Shared Server Statistics

Back to Top




init.ora Parameters



  • if IP/Public/Source at End snap is different a '*' is displayed




























Parameter NameBegin valueEnd value (if different)
audit_file_dest/oracle/admin/mycar/adump  
audit_trailDB  
compatible11.2.0.0.0  
control_files/oracle/oradata/mycar/control01.ctl,    /oracle/flash_recovery_area/mycar/control02.ctl  
cursor_sharingEXACT  
db_block_size8192  
db_domain    
db_namemycar  
db_recovery_file_dest/oracle/flash_recovery_area  
db_recovery_file_dest_size4070572032  
deferred_segment_creationFALSE  
diagnostic_dest/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=mycarXDB)  
log_archive_dest_1location=/oracle/oradata/archivelog  
log_archive_formatarchive_%t_%s_%r.log  
log_archive_max_processes10  
memory_target3439329280  
open_cursors300  
processes500  
remote_login_passwordfileEXCLUSIVE  
sec_case_sensitive_logonFALSE  
sql_traceFALSE  
undo_retention14400  
undo_tablespaceUNDOTBS1  
workarea_size_policyAUTO  



Back to Top









Dynamic Remastering Stats




          No data exists for this section of the report.



Back to Top



End of Report

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22126868/viewspace-765517/,如需转载,请注明出处,否则将追究法律责任。

上一篇: asdsn1yqzjk0r
下一篇: ww
请登录后发表评论 登录
全部评论

注册时间:2012-10-21

  • 博文量
    20
  • 访问量
    54685