ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rere

rere

原创 Linux操作系统 作者:yagerya 时间:2013-07-12 18:03:20 0 删除 编辑


AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9905-9906

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:990512-Jul-13 11:00:17107      4.5
End Snap:990612-Jul-13 11:43:41110      4.2
Elapsed:            43.40 (mins)  
DB Time:            193.14 (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):           4.5         2.7      0.02        0.01
DB CPU(s):            2.4           1.5     0.01    0.00
Redo size:          6,216.2        3,798.1  
Logical reads:        3,249.1       1,985.2  
Block changes:          29.8           18.2  
Physical reads:         0.5        0.3  
Physical writes:        1.9           1.2  
User calls:           769.2          470.0  
Parses:         226.2           138.2  
Hard parses:           0.1             0.1  
W/A MB processed:         1.8           1.1  
Logons:         0.1        0.1  
Executes:           227.5         139.0  
Rollbacks:            0.0           0.0  
Transactions:             1.6   


Instance Efficiency Percentages (Target 100%)








Buffer Nowait %:        100.00Redo NoWait %:         100.00
Buffer  Hit   %:           99.99In-memory Sort %:        100.00
Library Hit   %:         99.92Soft Parse %:         99.96
Execute to Parse %:           0.59Latch Hit %:        99.98
Parse CPU to Parse Elapsd %:         54.38% Non-Parse CPU:        99.82


Shared Pool Statistics







BeginEnd
Memory Usage %:          73.15        73.22
% SQL with executions>1:        92.66         95.00
% Memory for SQL w/exec>1:        87.42          93.87


Top 5 Timed Foreground Events










EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 6,196 53.47 
log file sync4,514344762.97Commit
db file sequential read82423280.20User I/O
latch: shared pool2842210.07Concurrency
latch: cache buffers chains444930.04Concurrency


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





Load Average BeginLoad Average End%User%System%WIO%Idle
   0.63   0.87  41.8  17.8   0.1  40.4

Instance CPU





%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
      59.5     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):       465.5    470.7
% Host Mem used for SGA+PGA:    31.85   31.92



Main Report




Back to Top




Wait Events Statistics



Back to Top



Time Model Statistics



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

  • 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 time11,037.0095.24
DB CPU6,196.0253.47
PL/SQL execution elapsed time6,066.9052.35
parse time elapsed28.110.24
hard parse elapsed time14.450.12
connection management call elapsed time14.230.12
sequence load elapsed time0.290.00
hard parse (sharing criteria) elapsed time0.120.00
PL/SQL compilation elapsed time0.020.00
failed parse elapsed time0.010.00
repeated bind elapsed time0.000.00
hard parse (bind mismatch) elapsed time0.000.00
DB time11,588.21 
background elapsed time471.36 
background cpu time1.52 


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_TIME620,375 
IDLE_TIME421,141 
IOWAIT_TIME1,501 
NICE_TIME0 
SYS_TIME184,942 
USER_TIME434,998 
LOAD11
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
12-Jul 11:00:170.63     
12-Jul 11:43:410.8759.5641.7717.7640.440.14


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       56.8%  of Total DB time    11,588.21 (s)

  • Total FG Wait Time:          389.55 (s)  DB CPU time:     6,196.02 (s)











Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  6,196 53.47
Commit4,5140344762.97
User I/O1,469025170.22
Concurrency761162060.13
Network1,481,4570400.03
Application360070.00
Other46,557100000.00
System I/O440000.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
log file sync4,5140344761.062.97
db file sequential read824023280.190.20
latch: shared pool20842210.000.07
latch: cache buffers chains4404930.010.04
SQL*Net message to client1,429,695030335.450.03
library cache: mutex X5024060.000.02
direct path read3720240.090.01
buffer busy waits901820.000.01
SQL*Net more data to client48,29701011.330.01
db file parallel read801770.000.01
enq: TX - index contention1000340.000.00
Disk file operations I/O2600010.060.00
SQL*Net break/reset to client360070.010.00
asynch descriptor resize46,5561000010.920.00
SQL*Net more data from client3,4650000.810.00
direct path sync10020.000.00
SQL*Net message from client1,429,694093,04465335.45 
jobq slave wait5,6181002,8655101.32 


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 write9,6480235242.2649.85
control file parallel write91501001090.2121.24
db file async I/O submit1,107081730.2617.19
os thread startup980292970.026.17
ADR block file read130107400.002.04
ADR block file write5059090.000.96
control file sequential read4,3090101.010.17
LGWR wait for redo copy2013750.000.16
db file sequential read740030.020.05
Disk file operations I/O580000.010.00
log file sync20080.000.00
asynch descriptor resize287100000.070.00
rdbms ipc message15,9246858,72936883.74 
DIAG idle wait5,1511005,20710111.21 
smon timer91002,7003000090.00 
shared server idle wait871002,612300210.02 
Streams AQ: qmn slave idle wait18302,608142520.04 
Streams AQ: qmn coordinator idle wait279342,60893480.07 
Space Manager: slave idle wait500992,60752150.12 
pmon timer992862,60226230.23 
dispatcher timer431002,581600180.01 
SQL*Net message from client27005170.06 
class slave wait110000.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 read1369.2     7.723.1
ADR block file write580.0      20.0
ADR file lock6100.0       
Disk file operations I/O31898.1.6.3.3.3 .3 
LGWR wait for redo copy250.0     50.0 
SQL*Net break/reset to client3688.92.8    8.3 
SQL*Net message to client1429.9K100.0     .0 
SQL*Net more data from client346599.9 .0 .0   
SQL*Net more data to client48.3K100.0       
asynch descriptor resize46.8K100.0       
buffer busy waits988.9     11.1 
control file parallel write91545.13.3.41.43.93.941.0.9
control file sequential read435399.9 .0   .0 
cursor: mutex S1100.0       
cursor: pin S1100.0       
db file async I/O submit110737.719.59.1.92.24.125.51.1
db file parallel read8     25.075.0 
db file sequential read89644.01.16.816.115.45.111.3.2
direct path read37296.0  .3.51.12.2 
direct path sync1  100.0     
direct path write28100.0       
enq: TX - index contention1010.0  30.040.0 20.0 
latch free2100.0       
latch: In memory undo latch3100.0       
latch: cache buffers chains4422.7 2.3 6.86.861.4 
latch: row cache objects1100.0       
latch: shared pool2  50.0    50.0
library cache: mutex X520.0    60.0 20.0
log file parallel write965085.3.8.5.61.11.210.2.2
log file sync451665.72.31.01.62.52.922.61.4
os thread startup98     50.039.810.2
read by other session1100.0       
DIAG idle wait5151      90.99.1
SQL*Net message from client1430K90.52.0.6.4.7.54.9.3
Space Manager: slave idle wait500       100.0
Streams AQ: qmn coordinator idle wait27961.6 .4  .43.933.7
Streams AQ: qmn slave idle wait18349.2      50.8
class slave wait11100.0       
dispatcher timer43       100.0
jobq slave wait5620.0   .0.099.9 
pmon timer9926.8.3.2.6.51.43.287.0
rdbms ipc message15.9K4.3.62.61.710.61.524.854.0
shared server idle wait87       100.0
smon timer9       100.0


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
ADR block file read269.2  7.7  7.715.4
Disk file operations I/O199.7  .3    
LGWR wait for redo copy150.0    50.0  
SQL*Net break/reset to client391.7 8.3     
SQL*Net message to client1100.0   .0   
buffer busy waits188.9    11.1  
control file parallel write38158.14.610.913.77.93.9.7.2
control file sequential read2100.0  .0 .0  
db file async I/O submit29373.44.87.07.24.12.41.0.1
db file parallel read625.025.025.025.0    
db file sequential read10388.54.12.91.91.8.6.2 
direct path read897.8.8.3.3.8   
enq: TX - index contention280.010.0 10.0    
latch: cache buffers chains2738.66.825.025.04.5   
library cache: mutex X180.0     20.0 
log file parallel write101089.51.73.22.91.7.7.2.0
log file sync107976.03.95.86.44.52.11.3.2
os thread startup4450.018.48.24.15.14.15.15.1


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
ADR block file read284.615.4      
ADR block file write180.0 20.0     
control file parallel write299.8.2      
db file async I/O submit199.9.1      
latch: shared pool150.0  50.0    
log file parallel write1100.0.0      
log file sync799.8.1 .0    
os thread startup594.95.1      


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$USERS11,5756,18818,430
mycar138014
SYS$BACKGROUND00017
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$USERS14692576160014812634
mycar0000001940
SYS$BACKGROUND157098290000


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   94.6% of Total DB Time (s):        11,588

  • Captured PL/SQL account for    0.2% of Total DB Time (s):       11,588

































Elapsed  Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO    SQL IdSQL ModuleSQL Text
10,854.1116,6290.6593.6756.000.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
28.36430.660.245.130.116gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...
8.803,7540.000.085.4185.7959ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
8.7215,8840.000.0830.970.0087hfb2vvgt6tp 
select 1 from sys_area_country...
7.0625,8780.000.0637.620.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
6.31151,3490.000.0538.590.00520mkxqpf15q8 
select 1 from dual
5.11190.270.0479.660.007c9aurkrt70vn 
select * from ( select p.*, pt...
4.6567,0110.000.0437.470.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
4.343,4980.000.0453.980.0083trawx9dw96s 
select decode(ld.DISPLAY_NAME,...
3.7621.880.0331.640.007v67qgf92mxfb
PL/SQL Developer
-- --select * from user_carbas...


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   98.8% of Total CPU Time (s):       6,196

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

































CPU    Time (s)Executions CPU per  Exec (s)%TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
6,078.2616,6290.3798.1010,854.1156.000.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
4.07190.210.075.1179.660.007c9aurkrt70vn 
select * from ( select p.*, pt...
2.7015,8840.000.048.7230.970.0087hfb2vvgt6tp 
select 1 from sys_area_country...
2.6625,8780.000.047.0637.620.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
2.44151,3490.000.046.3138.590.00520mkxqpf15q8 
select 1 from dual
2.343,4980.000.044.3453.980.0083trawx9dw96s 
select decode(ld.DISPLAY_NAME,...
2.252330.010.042.7182.920.009nkj1gjfq5k91 
select * from CC_USER where Lo...
1.7467,0110.000.034.6537.470.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
1.7230.570.033.1654.290.004hyzzmwyq9k00
PL/SQL Developer
-- --select * from user_carbas...
1.46430.030.0228.365.130.116gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...


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   54.6% of Total User I/O Wait Time (s):           26

  • Captured PL/SQL account for    0.1% of Total User I/O Wait Time (s):          26

































User I/O Time (s)Executions UIO per  Exec (s)%TotalElapsed    Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
7.553,7540.0029.538.805.4185.7959ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
2.68300.0910.492.710.5998.86asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
1.36270.055.321.8410.8974.009kyafghcc1xh6 
select distinct temp.SOFT_ID, ...
1.015,0640.003.951.4815.9768.37dx9uj64072dw7 
select * from SYS_PRODUCT_BURN...
0.79740.013.091.360.2958.252gyywxdrf81zu 
select distinct s.SOFT_ID, s.S...
0.491880.001.942.1357.2323.2289nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
0.03430.000.1228.365.130.116gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...
0.0216,6290.000.0810,854.1156.000.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
0.0235,9590.000.071.8444.431.004xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
0.016,2120.000.050.8027.511.4412gmchtj8pp10 
select usd.*, s.soft_name as S...


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:     8,460,857

  • Captured SQL account for   86.5% of Total










































Buffer Gets ExecutionsGets     per Exec  %TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
2,764,00716,629166.2232.6710,854.1156.000.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
640,03115,88440.297.568.7230.970.0087hfb2vvgt6tp 
select 1 from sys_area_country...
461,24725,87817.825.457.0637.620.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
434,54025,87816.795.143.0946.290.005ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
342,5781891,812.584.051.2969.680.001dv841hap05xc 
SELECT COUNT(*) AS c from (sel...
342,5781891,812.584.051.3866.590.006zzzr28dtrtpd 
select * from ( select us.FREE...
339,7731881,807.304.022.1357.2323.2289nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
292,86867,0114.373.464.6537.470.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
262,38516,39916.003.102.4828.720.009arur6gysf1z0 
select t.*, '' as name from sy...
183,13536,6255.002.162.7537.670.00bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
145,858233626.001.722.7182.920.009nkj1gjfq5k91 
select * from CC_USER where Lo...
105,2405,59518.811.241.1045.770.000nrknqc0j9kgr 
select * from ( select p.*, pt...
90,10830,0363.001.061.5639.970.111fnv7qu1a8qsc 
select * from product_down_set...


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:        1,369

  • Captured SQL account for   23.7% of Total

































Physical ReadsExecutionsReads    per Exec  %TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
1153,7540.038.408.805.4185.7959ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
861880.466.282.1357.2323.2289nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
52301.733.802.710.5998.86asdsn1yqzjk0r 
select r.DOWNLOAD_ID, r.VERSIO...
23270.851.681.8410.8974.009kyafghcc1xh6 
select distinct temp.SOFT_ID, ...
21740.281.531.360.2958.252gyywxdrf81zu 
select distinct s.SOFT_ID, s.S...
195,0640.001.391.4815.9768.37dx9uj64072dw7 
select * from SYS_PRODUCT_BURN...
335,9590.000.221.8444.431.004xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
316,6290.000.2210,854.1156.000.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
24,8800.000.150.3937.862.39c00br6fharcvs 
select c.* from diag_user_soft...
025,8780.000.007.0637.620.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...


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:        1,369

  • Captured SQL account for    2.2% of Total

  • Total UnOptimized Read Requests:       1,369

  • Captured SQL account for    2.2% 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
2121740.280.001.532gyywxdrf81zu 
select distinct s.SOFT_ID, s.S...
3335,9590.000.000.224xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
3316,6290.000.000.229y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
224,8800.000.000.15c00br6fharcvs 
select c.* from diag_user_soft...
113,7540.000.000.0759ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
0025,8780.00 0.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
001470.00 0.000bw79rck3c9j6
sqlplus@vm192168000035 (TNS V1-V3)
select 'username : ' || s.user...
0020.00 0.000fvkywuhw4whr
PL/SQL Developer
select m.* from (select s.sof...
005,5950.00 0.000nrknqc0j9kgr 
select * from ( select p.*, pt...
0010.00 0.0011p815z8hkfms
Oracle Enterprise Manager.purge system performan
DELETE MGMT_SYSTEM_PERFORMANCE...


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:      592,421

  • Captured SQL account for   95.9% of Total






















































Executions Rows ProcessedRows per ExecElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
151,349151,3501.006.3138.590.00520mkxqpf15q8 
select 1 from dual
67,01166,9501.004.6537.470.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
36,62536,6251.002.7537.670.00bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
35,95951,9811.451.8444.431.004xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
33,29611,9790.361.8752.090.005ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...
30,03600.001.5639.970.111fnv7qu1a8qsc 
select * from product_down_set...
25,878648,87525.077.0637.620.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
25,87882,1433.173.0946.290.005ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
16,62915,5910.9410,854.1156.000.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
16,3995150.032.4828.720.009arur6gysf1z0 
select t.*, '' as name from sy...
16,17516,1761.001.6328.030.00b43g51pg3hyza 
select * from COUNTRY_CODE whe...
15,88415,8821.008.7230.970.0087hfb2vvgt6tp 
select 1 from sys_area_country...
8,9388,9381.000.4938.680.00a6j566u48p8nf 
select * from SYS_PDT_TYPE whe...
8,80200.000.8231.390.94drvvh1sx3r1my 
select l.LAN_NAME, d.* from SY...
8,3878,3871.000.5243.100.001qp4my7430ph5 
select * from DIAG_SOFT_VERSIO...
6,21411,4561.840.5043.990.00f6j95rdnz0mmw 
select t.* from sys_product t ...
6,21200.000.8027.511.4412gmchtj8pp10 
select usd.*, s.soft_name as S...


Back to SQL Statistics

Back to Top



SQL ordered by Parse Calls



  • Total Parse Calls:       588,926

  • Captured SQL account for   96.4% of Total






















































Parse CallsExecutions % Total Parses   SQL IdSQL ModuleSQL Text
151,350151,34925.70520mkxqpf15q8 
select 1 from dual
67,01167,01111.385nggumnh49yzc 
select * from SYS_PRODUCT wher...
36,62536,6256.22bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
35,95935,9596.114xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
33,29633,2965.655ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...
30,03630,0365.101fnv7qu1a8qsc 
select * from product_down_set...
25,87825,8784.390ay7wjuhgzj9k 
select d.* from diag_soft_vers...
25,87825,8784.395ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
16,62916,6292.829y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
16,39916,3992.789arur6gysf1z0 
select t.*, '' as name from sy...
16,17616,1752.75b43g51pg3hyza 
select * from COUNTRY_CODE whe...
15,88415,8842.7087hfb2vvgt6tp 
select 1 from sys_area_country...
8,9388,9381.52a6j566u48p8nf 
select * from SYS_PDT_TYPE whe...
8,8028,8021.49drvvh1sx3r1my 
select l.LAN_NAME, d.* from SY...
8,3878,3871.421qp4my7430ph5 
select * from DIAG_SOFT_VERSIO...
6,2146,2141.06f6j95rdnz0mmw 
select t.* from sys_product t ...
6,2126,2121.0512gmchtj8pp10 
select usd.*, s.soft_name as S...


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
1,051,54990.086uj36dxzapkn6 
select count(*) from ((select ...


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
10715s34t44u10q4g 
SELECT a.name task_name, nvl(e...
7210618naypzfmabd6
EM_PING
INSERT INTO MGMT_SYSTEM_PERFOR...
6919yt4ka3n2svmc
DBMS_SCHEDULER
update sys.scheduler$_job set ...
574cabqn4dp09qck 
SELECT TASK_CLASS, ROUND(NVL(S...
53111p815z8hkfms
Oracle Enterprise Manager.purge system performan
DELETE MGMT_SYSTEM_PERFORMANCE...
5170b2gnxm5z6r51n 
lock table sys.col_usage$ in e...
51156g00cj285jmgsw 
update sys.mon_mods$ set inser...
4057gzxf61vj6wq4 
SELECT ID FROM SYS.WRI$_ADV_TA...
373,75459ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
3517zsc0j9jsfm0h 
select last_sample_date_num, l...
3319rfkm1bf915a0 
UPDATE WRH$_SEG_STAT_OBJ SET s...
29279kyafghcc1xh6 
select distinct temp.SOFT_ID, ...


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         
0bw79rck3c9j6select
      'username      : '      || s.username   || chr(10)   ||
      'schema         : '      || s.schemaname || chr(10)   ||
      'osuser         : '      || s.osuser     || chr(10)   ||
      'program         : '      || s.program    || chr(10)   ||
      'spid         : '      || p.spid       || chr(10)   ||
      'sid         : '      || s.sid          || chr(10)   ||
      'serial#         : '      || s.serial#    || chr(10)   ||
      'kill string   : '      || ''''          || s.sid       || ', ' || s.serial# || '''' || chr(10) ||
      'machine         : '      || s.machine    || chr(10)   ||
      'terminal      : '      || s.terminal   || chr(10)   ||
      'sql_id         : '      || q.sql_id     || chr(10)   ||
      'sql_text      : '      || q.sql_text
from v$session s,
     v$process p,
     v$sql     q
where s.paddr = p.addr
and p.spid  = 774
and s.sql_id = q.sql_id(+)
0fvkywuhw4whr

select m.* from
  (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price,  default_bprice) as price, v.CUR_ID, t4.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_soft_desc t3, 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
   (
   (s.pdt_type_id not in (121, 215, 243) and v.cur_id = pr.cur_id)
      or
     (s.pdt_type_id in (121, 215, 243)
      --and p.filiale_id = 23550
     and  pr.cur_id in (select cu.cur_id from sys_currency_unit cu where upper(cu.cur_code)='JPY')
     )
    )
   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.lan_id = 1002 and pr.cur_id = t4.cur_id
      and s.soft_id not in (select soft_id from diag_user_soft_center  where user_id = 25673  and serial_no = '982490041761')
      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 = 25673  and
               u.order_status in (0,  1, 3) and u.serial_no = '982490041761')
      and p.serial_no = '982490041761' and p.pdt_state = 1 and p.user_id = 25673
      and t2.lan_id = 1002 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 vers
ion_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 = 1002 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
0nrknqc0j9kgrselect * 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      AND      p.PDT_STATE = :2        AND    USER_ID = :3                                order by UPDATE_TIME desc ) where rownum <= 2147483647
11p815z8hkfmsDELETE MGMT_SYSTEM_PERFORMANCE_LOG WHERE TIME < :B2 AND ROWNUM <= :B1
12gmchtj8pp10select usd.*, s.soft_name as SOFT_NAME, su.cc as cc, decode(mu.user_name, null, '鏈?煡', mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd       join SYS_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_id = usd.last_upd_user_id                                  join DIAG_SOFT s on usd.soft_id = s.soft_id                                 where                  usd.USER_ID = :1                                    and         usd.IS_OPEN_FLAG = :2            and         usd.SOFT_TYPE = :3                        order by usd.CREATE_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))
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          
1qp4my7430ph5select * from  DIAG_SOFT_VERSION where VERSION_ID = :1     
2gyywxdrf81zu
select distinct 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, to_char(d.UPLOAD_TIME, 'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME,          decode(s.VEHICLE_TYPE_ID,  null, 1,  s.VEHICLE_TYPE_ID) as VEHICLE_TYPE,    decode(s.SOFT_APPLICABLE_AREA_ID,  null, 1,  s.SOFT_APPLICABLE_AREA_ID) as SOFT_APPLICABLE_AREA, us.free_end_time        from DIAG_USER_SOFT_CENTER us,  DIAG_SOFT_VERSION_DETAIL d,   DIAG_SOFT_VERSION v,    DIAG_SOFT s , DIAG_SOFT_DESC sd       where us.SOFT_ID=s.SOFT_ID and d.VERSION_ID=v.VERSION_ID and v.SOFT_ID=s.SOFT_ID  and (sd.SOFT_ID=s.SOFT_ID        AND                sd.LAN_ID = :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                   s.SOFT_ID=:5                         AND                   us.SERIAL_NO=:6                       order by s.SOFT_ID desc,  v.VERSION_NO desc,  d.VERSI
ON_DETAIL_ID desc    
4hyzzmwyq9k00
--
--select * from user_carbaseinfo uc where uc.serial_no like '965190000051'


--select * from diag_soft ds where ds.soft_id=2089

select m.* from
  (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price,  default_bprice) as price, v.CUR_ID, t4.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_soft_desc t3, 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
   (
   (s.pdt_type_id not in (121, 215, 243) and v.cur_id = pr.cur_id)
      or
      (s.pdt_type_id in (121, 215, 243)
       and p.filiale_id = 23550
       and  pr.cur_id in (select cu.cur_id from sys_currency_unit cu where upper(cu.cur_code)='JPY')
       )
      or
      (s.pdt_type_id in (121, 215, 243)
      and p.filiale_id <> 23550
      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 s.soft_id = t3.soft_id and t3.lan_id = 1002 and pr.cur_id = t4.cur_id
      and s.soft_id not in (select soft_id from diag_user_soft_center  where user_id = 25673  and serial_no = '982490041761')
      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 = 25673  and
               u.order_status in (0,  1, 3) and u
.serial_no = '982490041761')
      and p.serial_no = '982490041761' and p.pdt_state = 1 and p.user_id = 25673
      and t2.lan_id = 1002 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 = 1002 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


  -- select * from sys_product sp where sp.serial_no='982490041761'
4xbg42tpyp0gmselect * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1          
520mkxqpf15q8select 1 from dual
59ygsb7wnbc69insert into DIAG_DOWNLOAD_RECORD (DOWNLOAD_ID, DOWNLOAD_IP,  DOWNLOAD_PERSON,  DOWNLOAD_TIME,  LAN_Id,    SOFT_ID,  SOFT_NAME,  SOFT_TYPE,  USER_ID,  VERSION_DETAIL_ID,    VERSION_ID,  VERSION_NO,  SERIAL_NO)         values (:1, :2,  :3,  :4,  :5,  :6,  :7,  :8,    :9,  :10,  :11,  :12, :13)        
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    
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      
5s34t44u10q4gSELECT a.name task_name,    nvl(e.status,  a.status) status#,     a.last_exec_name as last_execution,    e.exec_type_id as execution_type# FROM wri$_adv_tasks a,       wri$_adv_executions e WHERE a.id = e.task_id(+)     and a.advisor_id = e.advisor_id(+)   and a.last_exec_name = e.name(+)     and a.id = :1
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;
6uj36dxzapkn6select count(*)        from ((select distinct m.*              from CNT_MESSAGE_DESC m, sys_user u             where u.cc=:1 and m.MESSAGE_TYPE = 0                and (m.read_user is null or              m.read_user not like '%46849%')) UNION          (select distinct m.*              from CNT_MESSAGE_DESC m,                 sys_user          u,               sys_product        sp,               sys_vender       sv             where (m.MESSAGE_TYPE = 3 and sp.USER_ID = u.USER_ID and               m.send_user_id = sp.VENDER_ID and                  sv.VENDER_ID = sp.VENDER_ID)            and u.cc = :2               and (m.read_user is null or                m.read_user not like '%46849%'))UNION (         select distinct m.*              from CNT_MESSAGE_DESC m               where  m.MESSAGE_TYPE = 2 and m.receive_user_id= :3 and m.read_flag = 0              )        )where RECEIVE_VALID_FLAG = 1    
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
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
7v67qgf92mxfb
--
--select * from user_carbaseinfo uc where uc.serial_no like '965190000051'


--select * from diag_soft ds where ds.soft_id=2089

select m.* from
  (select s.soft_id, t1.version_no, t1.creater_time, t3.soft_name as soft_desc, t2.remark, t2.version_detail_id, nvl(buy_price,  default_bprice) as price, v.CUR_ID, t4.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_soft_desc t3, 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
   (
   (s.pdt_type_id not in (121, 215, 243) and v.cur_id = pr.cur_id)
      or
      (s.pdt_type_id in (121, 215, 243)
       and p.filiale_id = 23550
       and  pr.cur_id in (select cu.cur_id from sys_currency_unit cu where upper(cu.cur_code)='JPY')
       )
      or
      (s.pdt_type_id in (121, 215, 243)
      and p.filiale_id != 23550
      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 s.soft_id = t3.soft_id and t3.lan_id = 1002 and pr.cur_id = t4.cur_id
      and s.soft_id not in (select soft_id from diag_user_soft_center  where user_id = 25673  and serial_no = '982490041761')
      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 = 25673  and
               u.order_status in (0,  1, 3) and u.seria
l_no = '982490041761')
      and p.serial_no = '982490041761' and p.pdt_state = 1 and p.user_id = 25673
      and t2.lan_id = 1002 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 = 1002 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


  -- select * from sys_product sp where sp.serial_no='982490041761'
7zsc0j9jsfm0hselect last_sample_date_num,    last_sample_date,  total_samples from WRI$_DBU_CPU_USAGE_SAMPLE where dbid     = :dbid and version  = :version
83trawx9dw96sselect decode(ld.DISPLAY_NAME,    null, l.LAN_NAME,  ld.DISPLAY_NAME) LAN_NAME,  d.* from DIAG_SOFT_VERSION_DETAIL d         left join sys_lan l on d.LAN_ID=l.LAN_ID         left join SYS_LAN_DISPLAY ld on ld.LAN_ID=l.LAN_ID               AND         (ld.DISP_LAN_ID = :1)         WHERE           (d.VERSION_ID = :2)      AND      (d.CHECK_STATE = :3)         
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       
9arur6gysf1z0select t.*, '' as name   from sys_product_ip_rule t where t.product_id = :1 and  (t.start_time is null or t.start_time<= sysdate)    and (t.end_time is null or t.end_time>sysdate )         
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      
9nkj1gjfq5k91select * from CC_USER where Lower(USER_NAME) = :1
9rfkm1bf915a0UPDATE WRH$_SEG_STAT_OBJ SET snap_id = :lah_snap_id  WHERE dbid = :dbid    AND (OBJ#,  DATAOBJ#) IN (SELECT NUM1_KEWRATTR,  NUM2_KEWRATTR FROM X$KEWRATTRSTALE)
9y8z91h8pk7d7SELECT C.* FROM COUNTRY_CODE C   JOIN (select country_code    from COUNTRY_IP_RANGE IP     WHERE IP.Start_Ip1 <= ip_to_number(:1)           AND IP.End_Ip1 >= ip_to_number(:2)    and rownum=1) IP ON C.COUNTRY_CODE = ip.country_code          
9yt4ka3n2svmcupdate sys.scheduler$_job set  last_enabled_time = :1,    next_run_date = :2,  job_status = :3 where  obj# = :4
a6j566u48p8nfselect * from SYS_PDT_TYPE where PDT_TYPE_ID = :1        
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     
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b43g51pg3hyzaselect * from COUNTRY_CODE where COUNTRY_CODE = :1       
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     
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        
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
drvvh1sx3r1myselect l.LAN_NAME,  d.* from SYS_PDT_TYPE_DESC d,  sys_lan l where d.LAN_ID=l.LAN_ID AND d.PDT_TYPE_ID = :1        
dx9uj64072dw7select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc        
f6j95rdnz0mmwselect t.* from sys_product t where t.user_id=:1 and t.pdt_state = 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


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 count780.030.02
Batched IO (full) vector count00.000.00
Batched IO block miss count3090.120.07
Batched IO buffer defrag count00.000.00
Batched IO double miss count30.000.00
Batched IO same unit count1610.060.04
Batched IO single block count780.030.02
Batched IO slow jump count00.000.00
Batched IO vector block count700.030.02
Batched IO vector read count30.000.00
Block Cleanout Optim referenced100.000.00
CCursor + sql area evicted200.010.00
CPU used by this session616,465236.73144.64
CPU used when call started616,300236.67144.60
CR blocks created810.030.02
Cached Commit SCN referenced1360.050.03
Commit SCN cached950.040.02
DB time1,423,146546.51333.92
DBWR checkpoint buffers written4,8721.871.14
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes3770.140.09
DBWR undo block writes1,0250.390.24
DFO trees parallelized00.000.00
HSC Heap Segment Block Changes12,6614.862.97
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1240.050.03
Heap Segment Array Updates700.030.02
IMU CR rollbacks810.030.02
IMU Flushes1,6060.620.38
IMU Redo allocation size4,513,0481,733.071,058.90
IMU commits2,6951.030.63
IMU contention1260.050.03
IMU ktichg flush00.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush20.000.00
IMU undo allocation size10,867,3764,173.222,549.83
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued3720.140.09
OS Involuntary context switches00.000.00
OS Page faults00.000.00
OS Page reclaims00.000.00
OS System time used00.000.00
OS User time used00.000.00
OS Voluntary context switches00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations not downgraded00.000.00
RowCR - row contention10.000.00
RowCR attempts630.020.01
RowCR hits620.020.01
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 client1,429,714549.03335.46
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 cleanout2230.090.05
application wait time260.010.01
auto extends on undo tablespace00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts10,9264.202.56
branch node splits00.000.00
buffer is not pinned count3,029,9051,163.52710.91
buffer is pinned count3,468,5671,331.98813.84
bytes received via SQL*Net from client151,004,87857,987.9435,430.52
bytes sent via SQL*Net to client534,853,575205,391.08125,493.57
calls to get snapshot scn: kcmgss598,738229.92140.48
calls to kcmgas6,5482.511.54
calls to kcmgcs303,787116.6671.28
cell physical IO interconnect bytes171,533,31265,871.1440,247.14
change write time1520.060.04
cleanout - number of ktugct calls3190.120.07
cleanouts and rollbacks - consistent read gets10.000.00
cleanouts only - consistent read gets120.000.00
cluster key scan block gets410.020.01
cluster key scans370.010.01
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed40.000.00
commit batch/immediate requested40.000.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure90.000.00
commit cleanout failures: cannot pin1110.040.03
commit cleanouts23,7599.125.57
commit cleanouts successfully completed23,6399.085.55
commit immediate performed40.000.00
commit immediate requested40.000.00
commit txn count during cleanout2,1250.820.50
concurrency wait time4,4741.721.05
consistent changes1760.070.04
consistent gets8,347,9413,205.721,958.69
consistent gets - examination1,247,932479.22292.80
consistent gets direct3860.150.09
consistent gets from cache8,347,5553,205.581,958.60
consistent gets from cache (fastpath)6,932,0152,661.991,626.47
cursor authentications960.040.02
data blocks consistent reads - undo records applied1640.060.04
db block changes77,71129.8418.23
db block gets112,91643.3626.49
db block gets direct650.020.02
db block gets from cache112,85143.3426.48
db block gets from cache (fastpath)41,01215.759.62
deferred (CURRENT) block cleanout applications13,2475.093.11
dirty buffers inspected00.000.00
enqueue conversions5200.200.12
enqueue deadlocks00.000.00
enqueue releases43,02216.5210.09
enqueue requests43,02316.5210.09
enqueue timeouts00.000.00
enqueue waits100.000.00
exchange deadlocks00.000.00
execute count592,421227.50139.00
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time104,217,77640,021.0524,452.79
free buffer inspected2,2440.860.53
free buffer requested2,3650.910.55
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress730.030.02
hot buffers moved to head of LRU8470.330.20
immediate (CR) block cleanout applications130.000.00
immediate (CURRENT) block cleanout applications7650.290.18
index crx upgrade (positioned)320.010.01
index crx upgrade (prefetch)00.000.00
index fast full scans (full)7030.270.16
index fetch by key339,710130.4579.71
index scans kdiixs1927,356356.12217.59
leaf node 90-10 splits610.020.01
leaf node splits1060.040.02
lob reads4100.160.10
lob writes340.010.01
lob writes unaligned340.010.01
logons cumulative2030.080.05
max cf enq hold time00.000.00
messages received6,3642.441.49
messages sent6,3642.441.49
min active SCN optimization applied on CR6360.240.15
no buffer to keep pinned count00.000.00
no work - consistent read gets6,681,7462,565.881,567.75
non-idle wait count1,557,312598.03365.39
non-idle wait time85,08232.6719.96
opened cursors cumulative590,992226.95138.67
parse count (describe)00.000.00
parse count (failures)180.010.00
parse count (hard)2140.080.05
parse count (total)588,926226.16138.18
parse time cpu1,1050.420.26
parse time elapsed2,0320.780.48
physical read IO requests1,3690.530.32
physical read bytes11,214,8484,306.652,631.36
physical read total IO requests5,7312.201.34
physical read total bytes82,853,88831,817.0319,440.14
physical read total multi block requests00.000.00
physical reads1,3690.530.32
physical reads cache9830.380.23
physical reads cache prefetch1010.040.02
physical reads direct3860.150.09
physical reads direct (lob)3720.140.09
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests3,3571.290.79
physical write bytes40,443,90415,531.019,489.42
physical write total IO requests10,0133.852.35
physical write total bytes88,679,42434,054.1120,807.00
physical write total multi block requests450.020.01
physical writes4,9371.901.16
physical writes direct650.020.02
physical writes direct (lob)270.010.01
physical writes direct temporary tablespace00.000.00
physical writes from cache4,8721.871.14
physical writes non checkpoint1,5570.600.37
pinned buffers inspected00.000.00
pinned cursors current10.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 time3,0591.170.72
queries parallelized00.000.00
recursive calls228,70987.8353.66
recursive cpu usage1,3090.500.31
redo blocks checksummed by FG (exclusive)18,0266.924.23
redo blocks written35,65013.698.36
redo buffer allocation retries00.000.00
redo entries23,6239.075.54
redo k-bytes read total00.000.00
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks5300.200.12
redo size16,187,4366,216.203,798.08
redo size for direct writes534,820205.38125.49
redo subscn max counts1,5350.590.36
redo synch time34,55813.278.11
redo synch writes4,5371.741.06
redo wastage1,413,080542.64331.55
redo write time23,5349.045.52
redo writes4,8241.851.13
remote Oradebug requests00.000.00
rollback changes - undo records applied160.010.00
rollbacks only - consistent read gets800.030.02
root node splits00.000.00
rows fetched via callback267,760102.8262.82
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits447,066171.68104.90
session logical reads8,460,8573,249.081,985.18
shared hash latch upgrades - no wait114,77744.0826.93
shared hash latch upgrades - wait120.000.00
sorts (disk)00.000.00
sorts (memory)82,22131.5719.29
sorts (rows)3,220,5851,236.75755.65
sql area evicted2510.100.06
sql area purged180.010.00
summed dirty queue length00.000.00
switch current to new buffer2270.090.05
table fetch by rowid2,641,3081,014.30619.73
table fetch continued row50,98519.5811.96
table scan blocks gotten1,813,528696.42425.51
table scan rows gotten129,374,83649,681.7030,355.43
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)108,11241.5225.37
temp space allocated (bytes)00.000.00
total cf enq hold time2,7901.070.65
total number of cf enq holders1960.080.05
total number of times SMON posted00.000.00
transaction rollbacks40.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size4,373,1681,679.361,026.08
user I/O wait time2,5630.980.60
user calls2,003,149769.24470.00
user commits4,2591.641.00
user rollbacks30.000.00
workarea executions - multipass00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal79,01530.3418.54
write clones created in background00.000.00
write clones created in foreground10.000.00


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,306,673,622,8241,307,131,297,120
session pga memory431,149,092,752431,276,601,816
session pga memory max485,362,064,560485,454,070,168
session cursor cache count12,568,30712,573,971
session uga memory759,867,355,465,408760,082,114,068,376
opened cursors current477460
workarea memory allocated1,7241,724
logons current107110


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)
Others68M1.68.02611229M0.70.011136620632.20
DBWR0M0.000M38M1.28.014592110772.68
LGWR0M0.000M18M1.85.006912482548.23
Buffer Cache Reads7M0.38.0026880M0.000M89027.36
Direct Reads2M0.14.0007680M0.000M3724.04
Direct Writes0M0.000M1M0.01.000384280.00
TOTAL:77M2.20.02956986M3.85.03302513.4K40.13


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
Control File69M1.67.02649629M0.70.0111360.17 
Data File10M0.53.00384038M1.29.01459218.72 
Log File0M0.000M18M1.85.006912  
TOTAL:79M2.20.03033785M3.85.0326414.64 


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)

Others
69M1.68.02649629M0.70.01113643760.18

 Others (Control File)
69M1.67.02649629M0.70.01113643530.17

 Others (Data File)
0M0.010M0M0.000M231.35

DBWR
0M0.000M38M1.28.0145920 

 DBWR (Data File)
0M0.000M38M1.28.0145920 

LGWR
0M0.000M18M1.85.0069120 

 LGWR (Log File)
0M0.000M18M1.85.0069120 

Buffer Cache Reads
7M0.38.0026880M0.000M87426.46

 Buffer Cache Reads (Data File)
7M0.38.0026880M0.000M87426.46

Direct Reads
2M0.14.0007680M0.000M0 

 Direct Reads (Data File)
2M0.14.0007680M0.000M0 

Direct Writes
0M0.000M1M0.01.0003840 

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

TOTAL:
78M2.20.02995386M3.85.03302552504.56


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)
MYCAR1,281017.101.001,801180.00
UNDOTBS1000.000.00772010.00
SYSAUX7704.291.00653000.00
SYSTEM1050.001.007801740.00
PASSPORT11078.181.0053000.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.dbf1,105014.131.001,189000.00
MYCAR/oracle/oradata/mycar/mycar01.dbf176035.741.00612080.00
PASSPORT/oracle/oradata/mycar/passport.dbf11078.181.0053000.00
SYSAUX/oracle/oradata/mycar/sysaux01.dbf7704.291.00653000.00
SYSTEM/oracle/oradata/mycar/system01.dbf1050.001.007801740.00
UNDOTBS1/oracle/oradata/mycar/undotbs01.dbf00  772010.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,5301008,460,2279844,8720010


Back to Buffer Pool Statistics

Back to Top



Checkpoint Activity



  • Total Physical Writes:                  4,937




MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00004,8720


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
B01462658471725899532817258   
E01457756342564299532825642   


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.652,597,59211391801.00
D1600.20201.021,596,555166649.00
D2400.30301.001,576,621140261.00
D3200.40391.001,572,644134997.00
D4000.50491.001,571,988134128.00
D4800.60591.001,571,533133526.00
D5600.70691.001,571,196133080.00
D6400.80791.001,570,895132681.00
D7200.90891.001,570,651132359.00
D8001.00991.001,570,465132112.00
D8801.101081.001,570,256131835.00
D9601.201181.001,570,045131556.00
D1,0401.301281.001,569,902131366.00
D1,1201.401381.001,569,808131243.00
D1,2001.501481.001,569,730131139.00
D1,2801.601581.001,569,630131006.00
D1,3601.701671.001,568,964130125.00
D1,4401.801770.971,520,73918970.00
D1,5201.901870.961,509,78818967.00
D1,6002.001970.921,448,21318949.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.004,6030


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
2K4K68,75968,75900
64K128K3,4483,44800
128K256K1,8901,89000
256K512K707000
512K1024K4,3234,32300
1M2M50250200
2M4M1100
4M8M222200


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.1326,344,827.5652,811,682.4733.00399,89993,319,024,643
2840.2526,344,827.5652,649,941.4133.00395,76293,128,345,214
5680.5026,344,827.5613,327,939.9066.00946,770,934,725
8520.7526,344,827.5612,964,308.2867.00046,342,242,911
1,1361.0026,344,827.5612,107,330.2269.00045,331,936,157
1,3631.2026,344,827.5611,946,154.4569.00045,141,923,156
1,5901.4026,344,827.5611,946,004.6269.00045,141,746,527
1,8181.6026,344,827.5611,945,893.7069.00045,141,615,757
2,0451.8026,344,827.5611,945,893.7069.00045,141,615,757
2,2722.0026,344,827.5611,945,893.7069.00045,141,615,757
3,4083.0026,344,827.5611,945,893.7069.00045,141,615,757
4,5444.0026,344,827.5611,945,734.1169.00045,141,427,613
6,8166.0026,344,827.5611,945,734.1169.00045,141,427,613
9,0888.0026,344,827.5611,945,734.1169.00045,141,427,613


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.59412,0427,232,8041.00257,2121.08114,631
8800.701697,5637,237,6181.00252,3981.06360,371
1,0080.8029711,4307,248,6871.00241,3291.02361,081
1,1360.9042515,7537,250,9071.00239,1091.01361,362
1,2641.0055319,6487,252,7131.00237,3031.00361,596
1,3921.1068123,1397,254,2421.00235,7740.99361,801
1,5201.2080926,5747,255,0911.00234,9250.99361,923
1,6481.3093629,8887,255,4731.00234,5430.99361,975
1,7761.411,06433,6837,255,8581.00234,1580.99362,012
1,9041.511,19237,4617,256,1261.00233,8900.99362,032
2,0321.611,32041,0047,256,3551.00233,6610.98362,049
2,1601.711,44844,4167,256,5221.00233,4940.98362,061
2,2881.811,57648,6777,256,6841.00233,3320.98362,072
2,4161.911,70452,6847,256,8271.00233,1890.98362,082
2,5442.011,83257,0227,256,9121.00233,1040.98362,091


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.506,380,2681,575,961,957
1,6080.756,356,1341,571,250,561
2,1441.006,351,0531,570,465,328
2,6801.256,331,3651,509,060,134
3,2161.506,326,2841,520,053,391
3,7521.756,325,6491,520,053,391
4,2882.006,325,0141,447,497,893


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 block9182
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)
TX-Transaction (index contention)1313010034.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.454,9551,0585240/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
12-Jul 11:401021,2011,05832400/00/0/0/0/0/0
12-Jul 11:302002,21745352400/00/0/0/0/0/0
12-Jul 11:20821,0911,05322400/00/0/0/0/0/0
12-Jul 11:107044644922400/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 latch10.00 00 
ASM db client latch1,6620.00 00 
ASM map operation hash table10.00 00 
ASM network state latch470.00 00 
AWR Alerted Metric Element list22,7570.00 00 
Change Notification Hash table latch8620.00 00 
Consistent RBA4,8240.00 00 
DML lock allocation27,9220.00 00 
Event Group Locks1540.00 00 
FAL Queue1250.00 00 
FOB s.o list latch6310.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch35,3540.011.0004,8840.00
JS Sh mem access50.00 00 
JS mem alloc latch40.00 00 
JS queue access latch50.00 00 
JS queue state obj latch18,6820.00 00 
JS slv state obj latch1,468,3040.350.0000 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch8630.00 00 
KTF sga latch140.00 06610.00
KWQP Prop Status20.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch570.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0520.00
Memory Management Latch10.00 08630.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch150.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process1,0390.00 00 
OS process allocation1,5580.00 00 
OS process: request allocation3030.00 00 
PL/SQL warning settings4060.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch2,9240.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch880.00 08310.00
SQL memory manager workarea list latch127,3310.00 00 
Shared B-Tree2400.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP2,3330.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch1,9500.00 00 
active service list6,1240.00 02,8780.00
archive control440.00 00 
archive process latch3750.271.0000 
begin backup scn array280.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles111,2480.010.0000 
cache buffers chains15,931,6890.000.1742,8000.00
cache buffers lru chain5,3400.00 07,6490.00
call allocation9030.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch3380.00 00 
channel operations parent latch12,5310.00 00 
checkpoint queue latch89,4910.00 04,6180.00
client/application info1,5170.00 00 
compile environment latch2030.00 00 
corrupted undo seg latch520.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch470.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch470.00 00 
dml lock allocation470.00 00 
done queue latch10.00 00 
dummy allocation4040.00 00 
enqueue hash chains86,5720.00 00 
enqueues44,6030.010.0000 
fifth spare latch10.00 00 
file cache latch1450.00 00 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA530.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch1000.00 0896,6640.00
hash table modification latch880.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch510.00 0504.00
job_queue_processes free list latch1040.00 00 
job_queue_processes parameter latch6090.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats1,5750.00 00 
kokc descriptor allocation latch5280.00 00 
ksfv messages10.00 00 
kss move lock230.00 00 
ksuosstats global area1770.00 00 
ksv allocation latch920.00 00 
ksv class latch470.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch3030.00 00 
ktm global data140.00 00 
kwqbsn:qsga950.00 00 
lgwr LWN SCN5,3280.00 00 
list of block allocation4290.00 00 
loader state object freelist8300.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch90.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
managed standby latch1250.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch10.00 00 
messages40,2320.020.0000 
mostly latch-free SCN5,3240.00 00 
msg queue latch10.00 00 
multiblock read objects1800.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch470.00 00 
object queue header heap420.00 0470.00
object queue header operation19,0130.00 00 
object stats modification80.00 00 
parallel query alloc buffer3370.00 00 
parallel query stats10.00 00 
parameter list2780.00 00 
parameter table management4050.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue8,8470.00 06,5700.00
process allocation4010.00 01530.00
process group creation3030.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch6540.00 00 
query server freelists10.00 00 
queued dump request80.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation25,2130.000.00023,6490.00
redo copy10.00 023,6490.16
redo writing18,1700.010.0000 
resmgr group change latch3410.00 00 
resmgr:active threads4040.00 00 
resmgr:actses change group1170.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list4030.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects1,192,5690.000.040930.00
rules engine rule set statistics1000.00 00 
second spare latch10.00 00 
sequence cache28,7140.00 00 
session allocation455,3140.000.000151,7730.00
session idle bit4,157,8670.000.0100 
session queue latch10.00 00 
session state list latch4610.00 00 
session switching7980.00 00 
session timer9920.00 00 
shared pool32,1350.080.0880 
shared pool sim alloc10.00 00 
shared pool simulator2,2680.00 00 
sim partition latch10.00 00 
simulator hash latch562,1980.000.0000 
simulator lru latch2,6290.00 0559,3810.01
sort extent pool740.00 00 
space background task latch1,8760.00 01,7280.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch1160.00 00 
transaction allocation7500.00 00 
undo global data29,1230.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 


Back to Latch Statistics

Back to Top



Latch Sleep Breakdown



  • ordered by misses desc










Latch NameGet RequestsMissesSleepsSpin Gets
JS slv state obj latch1,468,3045,14440
cache buffers chains15,931,68925444210
session idle bit4,157,8671881187
row cache objects1,192,56926125
shared pool32,13525223
In memory undo latch35,354330
archive process latch375110


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: child012
In memory undo latchktiFlushMe010
In memory undo latchkticmt: child010
archive process latchkcrrgpll010
cache buffers chainskcbgtcr: fast path (cr pin)02720
cache buffers chainskcbgtcr: fast path0112
cache buffers chainskcbrls_20513
cache buffers chainskcbgtcr_2044
cache buffers chainskcbrls_10412
cache buffers chainskcbgcur_2020
row cache objectskqreqd: reget010
session idle bitksupuc: clear busy010
shared poolkghalo010
shared poolkghupr1012


Back to Latch Statistics

Back to Top



Mutex Sleep Summary



  • ordered by number of sleeps desc








Mutex TypeLocationSleepsWait    Time (ms)
Library CachekglIsOwnerVersionable 1213-0
Library Cachekgllkdl1  85129
Library Cachekglpndl1  95133
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]10
Cursor Pinkksfbc [KKSCHLPIN1]10


Back to Latch Statistics

Back to Top



Parent Latch Statistics




          No data exists for this section of the report.


Back to Latch Statistics

Back to Top



Child Latch Statistics




          No data exists for this section of the report.


Back to Latch Statistics

Back to Top





Segment Statistics



Back to Top



Segments by Logical Reads



  • Total Logical Reads:       8,460,857

  • Captured Segments account for    95.4% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeLogical Reads%Total
MYCARMYCARUNI_IP_RANGE INDEX2,719,12032.14
MYCARMYCARDIAG_SOFT_VERSION TABLE648,4487.66
MYCARMYCARSYS_VENDER TABLE534,9606.32
MYCARMYCARDIAG_SOFT_VERSION_DETAIL TABLE471,4405.57
MYCARMYCARIND_VERSION_ID_DSD INDEX420,0324.96


Back to Segment Statistics

Back to Top



Segments by Physical Reads



  • Total Physical Reads:        1,369

  • Captured Segments account for    35.7% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhysical Reads%Total
MYCARMYCAROPERATE_LOG TABLE1228.91
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1218.84
MYCARMYCARCOM_IND_DUSC INDEX906.57
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE433.14
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX282.05


Back to Segment Statistics

Back to Top



Segments by Physical Read Requests



  • Total Physical Read Requests:        1,369

  • Captured Segments account for    35.7% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhys Read Requests%Total
MYCARMYCAROPERATE_LOG TABLE1228.91
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1218.84
MYCARMYCARCOM_IND_DUSC INDEX906.57
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE433.14
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX282.05


Back to Segment Statistics

Back to Top



Segments by UnOptimized Reads



  • Total UnOptimized Read Requests:       1,369

  • Captured Segments account for    35.7% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeUnOptimized Reads%Total
MYCARMYCAROPERATE_LOG TABLE1228.91
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1218.84
MYCARMYCARCOM_IND_DUSC INDEX906.57
MYCARMYCARDIAG_USER_SOFT_CENTER TABLE433.14
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX282.05


Back to Segment Statistics

Back to Top



Segments by Optimized Reads




          No data exists for this section of the report.


Back to Segment Statistics

Back to Top



Segments by Direct Physical Reads




          No data exists for this section of the report.


Back to Segment Statistics

Back to Top



Segments by Physical Writes



  • Total Physical Writes:         4,937

  • Captured Segments account for    52.6% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhysical Writes%Total
MYCARMYCAROPERATE_LOG TABLE85217.26
MYCARMYCARCOM_IND_DUSC INDEX74415.07
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX1883.81
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1733.50
MYCARMYCARPK_OPERATE_LOG INDEX581.17


Back to Segment Statistics

Back to Top



Segments by Physical Write Requests



  • Total Physical Write Requestss:       3,357

  • Captured Segments account for    54.7% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhys Write Requests%Total
MYCARMYCARCOM_IND_DUSC INDEX66419.78
MYCARMYCAROPERATE_LOG TABLE40211.97
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX1594.74
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE1524.53
MYCARMYCARSYS_PRODUCT TABLE401.19


Back to Segment Statistics

Back to Top



Segments by Direct Physical Writes



  • Total Direct Physical Writes:           65

  • Captured Segments account for  100.0% of Total






OwnerTablespace      NameObject NameSubobject   NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_9895TABLE PARTITION3858.46
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB1827.69
SYSSYSAUXSYS_LOB0000006207C00004$$ LOB913.85


Back to Segment Statistics

Back to Top



Segments by Table Scans



  • Total Table Scans:           703

  • Captured Segments account for    46.4% of Total





OwnerTablespace      NameObject NameSubobject   NameObj. TypeTable Scans%Total
MYCARMYCARPK_SYS_LAN INDEX32546.23
MYCARMYCARIND_VERSION_ID_DSD INDEX10.14


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 TABLE2,97624.80
MYCARMYCARPK_OPERATE_LOG INDEX1,60013.33
MYCARMYCARCOM_IND_DUSC INDEX1,1849.87
SYSSYSAUXWRH$_SQL_PLAN TABLE1,0088.40
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX9447.87


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
MYCARMYCARPK_DIAG_DOWNLOAD_RECORD INDEX1076.92
SYSSYSAUXWRI$_ADV_MESSAGE_GROUPS_PK INDEX215.38
MYCARMYCARPK_DIAG_USER_SOFT_CENTER INDEX17.69


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 INDEX787.50
SYSSYSTEMAUD$ TABLE112.50


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_control470.000 21
dc_global_oids7870.000 058
dc_histogram_data6,1690.000 08,442
dc_histogram_defs9,5240.000 06,247
dc_objects17,1930.000 53,004
dc_profiles1050.000 01
dc_rollback_segments1,4980.000 052
dc_segments3,7140.000 111,583
dc_sequences8870.110 88741
dc_tablespaces175,1020.000 010
dc_users184,7180.000 0188
global database name1,8400.000 02
outstanding_alerts280.000 07
sch_lj_oids40.000 016



Back to Top




Library Cache Activity



  • "Pct Misses"  should be very low 














NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1,0360.001,4070.0000
CLUSTER30.0020.0000
DBLINK1100.000 00
EDITION1160.002190.0000
INDEX90.0090.0000
QUEUE480.001540.0000
SCHEMA1620.000 00
SQL AREA11,6793.16605,8830.099218
SUBSCRIPTION170.00170.0000
TABLE/PROCEDURE4,9300.0055,4240.02110
TRIGGER350.00600.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
BOther398.90 3.667.632832109109
 Freeable63.560.000.990.634 6464
 SQL1.771.100.020.020128781
 PL/SQL1.291.020.010.0300107107
EOther401.08 3.587.542832112112
 Freeable65.940.001.010.634 6565
 SQL2.331.660.030.061128982
 PL/SQL1.411.100.010.0301110110


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
sharedCCUR86.8986.83-0.06
sharedFileOpenBlock15.2015.200.00
sharedKGLHD26.4726.46-0.04
sharedKGLS16.5716.56-0.05
sharedPCUR76.3576.620.35
sharedPLMCD13.6313.630.00
sharedSQLA481.93482.990.22
sharedfree memory339.35338.44-0.27
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)
42420.000.000.020.100.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.020.020.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 %
2,6040.00100.000.000.00


Back to Shared Server Statistics

Back to Top



Shared Servers Common Queue




          No data exists for this section of the report.


Back to Shared Server Statistics

Back to Top



Shared Servers Dispatchers



  • 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.002,6040.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-766164/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-10-21

  • 博文量
    20
  • 访问量
    54695