ITPub博客

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

werdgdsds

原创 Linux操作系统 作者:yagerya 时间:2013-07-19 18:08:40 0 删除 编辑


Using the report name /tmp/awrrpt_1_10059_10061.html

AWR Report for DB: MYCAR, Inst: mycar, Snaps: 10059-10061

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:1005918-Jul-13 17:00:0192      4.4
End Snap:1006118-Jul-13 17:23:2694      4.2
Elapsed:            23.42 (mins)  
DB Time:            144.25 (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):           6.2         4.9      0.04        0.01
DB CPU(s):            2.3           1.9     0.01    0.00
Redo size:          6,566.9        5,232.2  
Logical reads:        2,651.3       2,112.4  
Block changes:          27.4           21.8  
Physical reads:         0.5        0.4  
Physical writes:        2.0           1.6  
User calls:           560.0          446.2  
Parses:         166.6           132.7  
Hard parses:           0.1             0.1  
W/A MB processed:         0.8           0.6  
Logons:         0.2        0.1  
Executes:           168.1         134.0  
Rollbacks:            0.0           0.0  
Transactions:             1.3   


Instance Efficiency Percentages (Target 100%)








Buffer Nowait %:        100.00Redo NoWait %:         100.00
Buffer  Hit   %:           99.99In-memory Sort %:        100.00
Library Hit   %:         99.90Soft Parse %:         99.96
Execute to Parse %:           0.93Latch Hit %:       100.00
Parse CPU to Parse Elapsd %:          2.55% Non-Parse CPU:        99.94


Shared Pool Statistics







BeginEnd
Memory Usage %:          73.95        73.97
% SQL with executions>1:        94.48         95.53
% Memory for SQL w/exec>1:        88.58          88.96


Top 5 Timed Foreground Events










EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 3,276 37.85 
log file sync2,0263511734.06Commit
db file sequential read3601123121.30User I/O
latch: shared pool18105740.12Concurrency
direct path sync1991480.11User I/O


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





Load Average BeginLoad Average End%User%System%WIO%Idle
   0.10   0.66  40.8  17.6   0.1  41.6

Instance CPU





%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
      58.3     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):       436.4    440.2
% Host Mem used for SGA+PGA:    31.50   31.55



Main Report




Back to Top




Wait Events Statistics



Back to Top



Time Model Statistics



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

  • 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 time6,920.7779.96
PL/SQL execution elapsed time3,650.7342.18
DB CPU3,275.9737.85
parse time elapsed89.641.04
connection management call elapsed time65.860.76
hard parse elapsed time49.710.57
hard parse (sharing criteria) elapsed time41.200.48
sequence load elapsed time0.260.00
PL/SQL compilation elapsed time0.010.00
repeated bind elapsed time0.000.00
failed parse elapsed time0.000.00
DB time8,655.13 
background elapsed time422.74 
background cpu time1.04 


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_TIME328,163 
IDLE_TIME233,835 
IOWAIT_TIME552 
NICE_TIME0 
SYS_TIME98,837 
USER_TIME229,132 
LOAD01
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
18-Jul 17:00:010.10     
18-Jul 17:14:3421.0258.2740.6717.5641.730.12
18-Jul 17:23:260.6658.6540.9817.6441.350.06


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       43.7%  of Total DB time     8,655.13 (s)

  • Total FG Wait Time:          508.25 (s)  DB CPU time:     3,275.97 (s)












Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  3,276 37.85
Commit2,02603511734.06
User I/O99201251261.45
Concurrency1051282670.32
Network579,6390300.03
Configuration110017620.01
Other13,209100000.00
System I/O1770000.00
Application20000.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 sync2,02603511731.154.06
db file sequential read36001123120.201.30
latch: shared pool180105740.010.12
direct path sync10991480.000.11
latch: cache buffers chains59081310.030.09
cursor: pin S40512690.000.06
library cache: mutex X13043420.010.05
Disk file operations I/O3930390.220.04
SQL*Net message to client561,097020318.080.02
undo segment extension110017620.000.01
SQL*Net more data from client2,3600101.340.01
latch: row cache objects700650.000.01
asynch descriptor resize13,205100007.490.00
read by other session400590.000.00
SQL*Net more data to client16,1820009.170.00
latch: session allocation1001330.000.00
direct path read2230000.130.00
cursor: mutex S1100010.000.00
control file sequential read1770000.100.00
SQL*Net message from client561,0950203,311362318.08 
jobq slave wait2,9201001,4965121.66 


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 write4,2460220522.4152.14
control file parallel write4720761600.2717.91
os thread startup5405510160.0312.98
db file async I/O submit506046910.2910.84
latch: shared pool14053900.011.29
LGWR wait for redo copy40512740.001.21
control file sequential read2,3990421.361.04
Disk file operations I/O3701380.020.33
SQL*Net message to client5600110.320.18
latch: call allocation901810.010.17
reliable message2500150.010.09
enq: CF - contention1002670.000.06
db file sequential read980030.060.06
rdbms ipc reply250070.010.04
ADR block file read130030.010.01
log file sync10080.000.00
asynch descriptor resize275100000.160.00
buffer busy waits20010.000.00
ADR block file write50000.000.00
rdbms ipc message8,1217131,78639144.60 
DIAG idle wait2,7721002,81010141.57 
smon timer8381,5021877060.00 
dispatcher timer241001,440600140.01 
shared server idle wait471001,411300190.03 
Space Manager: slave idle wait257981,40654710.15 
pmon timer518851,40427110.29 
Streams AQ: qmn slave idle wait9701,402144560.05 
Streams AQ: qmn coordinator idle wait150331,40293480.09 
SQL*Net message from client701027390.40 
class slave wait8011090.00 


Back to Wait Events Statistics

Back to Top



Wait Event Histogram



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

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

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

  • Ordered by Event (idle events last)






















































  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s  >1s
ADR block file read1376.9  7.715.4   
ADR block file write5100.0       
ADR file lock6100.0       
Disk file operations I/O42498.6.5.2   .2.5
LGWR wait for redo copy475.0      25.0
SQL*Net break/reset to client2100.0       
SQL*Net message to client561.7K100.0   .0 .0 
SQL*Net more data from client236099.5.2.0   .2 
SQL*Net more data to client16.2K100.0       
asynch descriptor resize13.5K100.0   .0 .0 
buffer busy waits580.0 20.0     
control file parallel write47348.61.31.1 .81.746.1.4
control file sequential read258199.9     .0.0
cursor: mutex S1 100.0      
cursor: pin S450.0      50.0
db file async I/O submit50638.726.111.1.21.01.020.21.8
db file sequential read44643.01.12.28.714.81.623.15.4
direct path read223100.0       
direct path sync1       100.0
direct path write21100.0       
enq: CF - contention1      100.0 
latch free2100.0       
latch: cache buffers chains6025.0 1.7  3.370.0 
latch: call allocation9  11.1  22.266.7 
latch: enqueue hash chains1100.0       
latch: row cache objects714.3   14.342.928.6 
latch: session allocation1      100.0 
latch: shared pool3218.8    3.165.612.5
library cache: mutex X1323.17.7   7.753.87.7
log file parallel write424679.6.8.5.5.7.717.0.1
log file sync202752.71.2.8.8.81.640.02.0
os thread startup54     57.420.422.2
rdbms ipc reply2596.0     4.0 
read by other session4 25.0  25.0 50.0 
reliable message2592.0     8.0 
undo segment extension1      100.0 
DIAG idle wait2771      86.913.1
SQL*Net message from client561.8K90.62.0.5.4.7.45.2.2
Space Manager: slave idle wait257.4      99.6
Streams AQ: qmn coordinator idle wait15058.0   .72.06.033.3
Streams AQ: qmn slave idle wait9748.5      51.5
class slave wait887.5     12.5 
dispatcher timer24       100.0
jobq slave wait2920.0  .0  99.9 
pmon timer5182.3 .2.2.8.64.891.1
rdbms ipc message81225.9.61.81.19.21.223.057.3
shared server idle wait47       100.0
smon timer8       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
Disk file operations I/O299.3    .2.2.2
SQL*Net message to client5100.0 .0.0.0.0  
SQL*Net more data from client599.8.0.1.0    
asynch descriptor resize1100.0  .0    
control file parallel write21953.53.45.111.418.67.6.2.2
control file sequential read199.9 .0    .0
cursor: pin S150.0     25.025.0
db file async I/O submit11078.11.43.65.95.73.61.6.2
db file sequential read11271.52.54.97.63.44.72.03.4
enq: CF - contention1    100.0   
latch: cache buffers chains4230.08.321.721.716.71.7  
latch: call allocation633.311.133.322.2    
latch: row cache objects271.4  28.6    
latch: session allocation1   100.0    
latch: shared pool2121.9 12.521.921.99.4 12.5
library cache: mutex X738.5 38.5 7.77.7 7.7
log file parallel write72482.91.43.54.64.92.7.1.0
log file sync84458.13.06.18.713.09.11.7.3
os thread startup1457.43.73.77.41.93.75.616.7
rdbms ipc reply196.0  4.0    
read by other session250.0 25.025.0    
reliable message292.0 4.04.0    
undo segment extension1     100.0  


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
Disk file operations I/O199.8.2      
LGWR wait for redo copy175.0 25.0     
control file parallel write199.8.2      
control file sequential read1100.0 .0     
cursor: pin S175.025.0      
db file async I/O submit199.8.2      
db file sequential read1596.62.2.9.2    
direct path sync1   100.0    
latch: shared pool487.512.5      
library cache: mutex X192.37.7      
log file parallel write1100.0.0      
log file sync699.7.2.0     
os thread startup983.35.611.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$USERS8,6553,27613,711
mycar0003
SYS$BACKGROUND00012
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$USERS99112510528005794493
mycar1000001900
SYS$BACKGROUND146260580000


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   78.2% of Total DB Time (s):         8,655

  • Captured PL/SQL account for    2.8% of Total DB Time (s):        8,655

































Elapsed  Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO    SQL IdSQL ModuleSQL Text
6,528.289,6420.6875.4349.070.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
202.771202.772.340.3950.691uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...
24.28124.280.280.3360.856ajkhukk78nsr 
begin prvt_hdm.auto_execute( :...
20.718,9890.000.249.520.0087hfb2vvgt6tp 
select 1 from sys_area_country...
18.62118.620.220.1149.14fdjtrdaz8hpvg 
INSERT /*+ APPEND LEADING(@"SE...
16.7828.390.191.0098.98bunssq950snhf 
insert into wrh$_sga_target_ad...
11.12230.480.137.778.046gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...
10.601,5540.010.120.7997.95dnx1ugz1qwd2p 
insert into OPERATE_LOG (LOG_I...
10.4381.300.120.0099.883sqgkcng6vx8r 
INSERT INTO sys.wri$_adv_ratio...
9.5619.560.110.0045.64692wcvj50ytxz 
insert into wrh$_resource_limi...


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.3% of Total CPU Time (s):       3,276

  • Captured PL/SQL account for    0.1% of Total CPU Time (s):         3,276

































CPU    Time (s)Executions CPU per  Exec (s)%TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
3,203.519,6420.3397.796,528.2849.070.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
1.978,9890.000.0620.719.520.0087hfb2vvgt6tp 
select 1 from sys_area_country...
1.427,4230.000.042.1865.090.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
1.1856,3540.000.042.4747.860.00520mkxqpf15q8 
select 1 from dual
1.0831,3720.000.039.2111.720.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
0.86840.010.031.1376.280.009nkj1gjfq5k91 
select * from CC_USER where Lo...
0.86230.040.0311.127.778.046gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...
0.809,5910.000.028.449.440.019arur6gysf1z0 
select t.*, '' as name from sy...
0.7910.790.02202.770.3950.691uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...
0.6417,0920.000.022.7023.5415.414xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...


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

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






















































User I/O Time (s)Executions UIO per  Exec (s)%TotalElapsed    Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
102.781102.7880.98202.770.3950.691uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...
16.6128.3013.0916.781.0098.98bunssq950snhf 
insert into wrh$_sga_target_ad...
14.78114.7811.6424.280.3360.856ajkhukk78nsr 
begin prvt_hdm.auto_execute( :...
10.4281.308.2110.430.0099.883sqgkcng6vx8r 
INSERT INTO sys.wri$_adv_ratio...
10.391,5540.018.1810.600.7997.95dnx1ugz1qwd2p 
insert into OPERATE_LOG (LOG_I...
9.1519.157.2118.620.1149.14fdjtrdaz8hpvg 
INSERT /*+ APPEND LEADING(@"SE...
5.8315.834.605.860.3499.5884k66tf2s7y1c 
insert into wrh$_bg_event_summ...
4.7014.703.704.700.2699.91gj6uc50hpnr1p 
insert into WRH$_MUTEX_SLEEP (...
4.691,4850.003.695.014.4793.5559ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
4.3614.363.449.560.0045.64692wcvj50ytxz 
insert into wrh$_resource_limi...
4.1241.033.244.120.0099.982gxbvynrd71dr 
INSERT INTO sys.wri$_adv_rec_a...
3.7821.892.987.222.1652.33dayq182sk41ks 
insert into wrh$_memory_target...
3.7213.722.933.990.0093.34f318xdxdn0pdc 
insert into wrh$_log (snap_id,...
3.7113.712.923.720.0099.836hwjmjgrpsuaa 
insert into wrh$_enqueue_stat ...
3.0013.002.363.000.0099.97fp6ajqcjfqf2j 
insert into wrh$_streams_pool_...
2.8912.892.282.900.4199.67dnwpm0gdccrph 
insert into wrh$_process_memor...
2.5512.552.012.550.4799.81350myuyx0t1d6 
insert into wrh$_tablespace_st...


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:     3,726,244

  • Captured SQL account for   87.0% of Total













































Buffer Gets ExecutionsGets     per Exec  %TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
1,446,5389,642150.0238.826,528.2849.070.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
368,2728,98940.979.8820.719.520.0087hfb2vvgt6tp 
select 1 from sys_area_country...
153,4569,59116.004.128.449.440.019arur6gysf1z0 
select t.*, '' as name from sy...
152,9247,42320.604.102.1865.090.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
152,60531,3724.864.109.2111.720.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
136,0667,45118.263.650.9365.780.005ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
86,54717,3075.002.323.9316.000.00bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
71,584591,213.291.920.9642.0827.6389nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
61,7688,8247.001.660.5978.010.491fnv7qu1a8qsc 
select * from product_down_set...
61,74682753.001.660.3083.480.0015u508g96b995 
select count(*) from appstore_...
58,681491,197.571.570.2082.320.001dv841hap05xc 
SELECT COUNT(*) AS c from (sel...
52,58484626.001.411.1376.280.009nkj1gjfq5k91 
select * from CC_USER where Lo...
52,25917,0923.061.402.7023.5415.414xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
43,400143,100.001.160.2364.940.00faup55dtz1ufw 
SELECT COUNT(*) AS c from sys_...


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:          654

  • Captured SQL account for   35.5% of Total

































Physical ReadsExecutionsReads    per Exec  %TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
1221122.0018.65202.770.3950.691uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...
1001,5540.0615.2910.600.7997.95dnx1ugz1qwd2p 
insert into OPERATE_LOG (LOG_I...
651,4850.049.945.014.4793.5559ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
34134.005.2024.280.3360.856ajkhukk78nsr 
begin prvt_hdm.auto_execute( :...
14114.002.142.290.000.0247mm81hm9sggy 
SELECT sum(case when a.sessio...
1142.751.680.2322.8775.60gkuh6srmynubb 
select distinct temp.SOFT_ID, ...
1081.251.5310.430.0099.883sqgkcng6vx8r 
INSERT INTO sys.wri$_adv_ratio...
515.000.769.560.0045.64692wcvj50ytxz 
insert into wrh$_resource_limi...
414.000.615.860.3499.5884k66tf2s7y1c 
insert into wrh$_bg_event_summ...
3590.050.460.9642.0827.6389nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...


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:          654

  • Captured SQL account for   19.4% of Total

  • Total UnOptimized Read Requests:         654

  • Captured SQL account for   19.4% 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
2642641264.000.0040.371uk5m5qbzj1vt
sqlplus@vm192168000035 (TNS V1-V3)
BEGIN dbms_workload_repository...
104104252.000.0015.901cq3qr774cu45 
insert into WRH$_IOSTAT_FILETY...
3434134.000.005.206ajkhukk78nsr 
begin prvt_hdm.auto_execute( :...
101081.250.001.533sqgkcng6vx8r 
INSERT INTO sys.wri$_adv_ratio...
33590.050.000.4689nfp8fv1y8vw 
SELECT COUNT(*) AS c from (sel...
331,4440.000.000.46c00br6fharcvs 
select c.* from diag_user_soft...
2217,0920.000.000.314xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
229,6420.000.000.319y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
1140.250.000.152gxbvynrd71dr 
INSERT INTO sys.wri$_adv_rec_a...
11230.040.000.156gvch1xu9ca3g 
DECLARE job BINARY_INTEGER := ...


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:      236,290

  • Captured SQL account for   95.1% of Total













































Executions Rows ProcessedRows per ExecElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
56,35456,3541.002.4747.860.00520mkxqpf15q8 
select 1 from dual
31,37231,3711.009.2111.720.005nggumnh49yzc 
select * from SYS_PRODUCT wher...
17,30717,3071.003.9316.000.00bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
17,09279,7054.662.7023.5415.414xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
13,0442,7610.211.1430.960.005ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...
9,6428,5610.896,528.2849.070.009y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
9,5916020.068.449.440.019arur6gysf1z0 
select t.*, '' as name from sy...
8,9898,9891.0020.719.520.0087hfb2vvgt6tp 
select 1 from sys_area_country...
8,82400.000.5978.010.491fnv7qu1a8qsc 
select * from product_down_set...
7,45126,1103.500.9365.780.005ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
7,423246,09833.152.1865.090.000ay7wjuhgzj9k 
select d.* from diag_soft_vers...
3,0573,0571.000.1843.290.00a6j566u48p8nf 
select * from SYS_PDT_TYPE whe...
3,02300.000.2633.390.11drvvh1sx3r1my 
select l.LAN_NAME, d.* from SY...
2,9192,9191.000.2122.990.001qp4my7430ph5 
select * from DIAG_SOFT_VERSIO...


Back to SQL Statistics

Back to Top



SQL ordered by Parse Calls



  • Total Parse Calls:       234,085

  • Captured SQL account for   95.9% of Total













































Parse CallsExecutions % Total Parses   SQL IdSQL ModuleSQL Text
56,35456,35424.07520mkxqpf15q8 
select 1 from dual
31,37231,37213.405nggumnh49yzc 
select * from SYS_PRODUCT wher...
17,30717,3077.39bm7qdt1qj4cg0 
select l.LAN_NAME, d.* from DI...
17,09217,0927.304xbg42tpyp0gm 
select * from SYS_PRODUCT_LANG...
13,04413,0445.575ky6k3fa3cu3y 
select * from SYS_VENDER_LANG_...
9,6429,6424.129y8z91h8pk7d7 
SELECT C.* FROM COUNTRY_CODE C...
9,5919,5914.109arur6gysf1z0 
select t.*, '' as name from sy...
8,9898,9893.8487hfb2vvgt6tp 
select 1 from sys_area_country...
8,8248,8243.771fnv7qu1a8qsc 
select * from product_down_set...
7,4517,4513.185ck2pk4pxbq6y 
select v.* from DIAG_SOFT_VERS...
7,4237,4233.170ay7wjuhgzj9k 
select d.* from diag_soft_vers...
3,0573,0571.31a6j566u48p8nf 
select * from SYS_PDT_TYPE whe...
3,0233,0231.29drvvh1sx3r1my 
select l.LAN_NAME, d.* from SY...
2,9192,9191.251qp4my7430ph5 
select * from DIAG_SOFT_VERSIO...


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,989,52220.156wm3n4d7bnddg 
SELECT source, (case when tim...
1,050,28740.0869k5bhm12sz98 
SELECT dbin.instance_number, d...


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
10725s34t44u10q4g 
SELECT a.name task_name, nvl(e...
1022c8gnrhxma4tas 
SELECT owner#, property FROM s...
100469k5bhm12sz98 
SELECT dbin.instance_number, d...
912gdn3ysuyssf82 
SELECT advisor_id FROM sys.wri...
725918naypzfmabd6
EM_PING
INSERT INTO MGMT_SYSTEM_PERFOR...
6728p9z2ztb272bm 
SELECT sx.instance_number, sx...
651138vwv6hx92ymmm 
UPDATE MGMT_CURRENT_METRICS SE...
6326wm3n4d7bnddg 
SELECT source, (case when tim...
6347davq1msn9b8kd 
UPDATE MGMT_POLICY_ASSOC_EVAL_...
5625uw1u291s3m0k 
SELECT case when cnt = 0 then ...
522aktbxfjwnzgmu 
update WRM$_DATABASE_INSTANCE ...
51279p5tvdmjymwx7 
UPDATE MGMT_POLICY_ASSOC_EVAL_...
514f0wj261bm8snd 
update wrm$_wr_control set sna...
5020ut2yw7mxf0aq 
insert into WRM$_SNAPSHOT (sna...
371,48559ygsb7wnbc69 
insert into DIAG_DOWNLOAD_RECO...
3517zsc0j9jsfm0h 
select last_sample_date_num, l...
302bunssq950snhf 
insert into wrh$_sga_target_ad...
296cumjq42201t37 
select u1.user#, u2.user#, u3....
2621cq3qr774cu45 
insert into WRH$_IOSTAT_FILETY...
2621cq3qr774cu45 
insert into WRH$_IOSTAT_FILETY...
262dayq182sk41ks 
insert into wrh$_memory_target...


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         
0ut2yw7mxf0aqinsert into WRM$_SNAPSHOT   (snap_id,  dbid,    instance_number,  startup_time,     begin_interval_time,  end_interval_time,  snap_level,     status,  error_count,  bl_moved,    snap_flag)  values   (:snap_id,  :dbid,  :instance_number,  :startup_time,     :begin_interval_time,  :end_interval_time,  :snap_level,     :status,  0,  0,  :bind1)
15u508g96b995select count(*) from appstore_push_history t         where t.auto_push=0        and          t.message_type = :1              and           t.serial_no = :2              and          t.fault_deal_flag = :3           
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))
1cq3qr774cu45
insert into WRH$_IOSTAT_FILETYPE    (snap_id,  dbid,  instance_number,        filetype_id,      small_read_megabytes,  small_write_megabytes,     large_read_megabytes,    large_write_megabytes,        small_read_reqs,  small_write_reqs,  small_sync_read_reqs,        large_read_reqs,  large_write_reqs,      small_read_servicetime,  small_write_servicetime,        small_sync_read_latency,      large_read_servicetime,  large_write_servicetime,     retries_on_error)   (select      :snap_id,  :dbid,  :instance_number,         filetype_id,    sum(small_read_megabytes) small_read_megabytes,       sum(small_write_megabytes) small_write_megabytes,       sum(large_read_megabytes) large_read_megabytes,        sum(large_write_megabytes) large_write_megabytes,        sum(small_read_reqs) small_read_reqs,    sum(small_write_reqs) small_write_reqs,       sum(small_sync_read_reqs) small_sync_read_reqs,        sum(large_read_reqs) large_read_reqs,    sum(large_write_reqs) large_write_reqs,       sum(small_read_servicetime) small_read_servicetime,    sum(small_write_servicetime) small_write_servicetime,        sum(small_sync_read_latency) small_sync_read_latency,    sum(large_read_servicetime) large_read_servicetime,      sum(large_write_servicetime) large_write_servicetime,       sum(retries_on_error) retries_on_error      from v$iostat_file      group by filetype_id)
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     
1uk5m5qbzj1vtBEGIN dbms_workload_repository.create_snapshot; END;
 
2gxbvynrd71drINSERT INTO sys.wri$_adv_rec_actions (task_id,  rec_id,  act_id) VALUES (:1, :2, :3)
350myuyx0t1d6insert into wrh$_tablespace_stat    (snap_id,  dbid,  instance_number,    ts#,  tsname,  contents,      status,  segment_space_management,  extent_management,      is_backup)  select    :snap_id,  :dbid,  :instance_number,     ts.ts#,  ts.name as tsname,     decode(ts.contents$,  0,  (decode(bitand(ts.flags,  16),  16,    'UNDO',        'PERMANENT')),  1,  'TEMPORARY')           as contents,    decode(ts.online$,  1,    'ONLINE',  2,  'OFFLINE',         4,  'READ ONLY',  'UNDEFINED')         as status,    decode(bitand(ts.flags, 32),  32, 'AUTO',  'MANUAL') as segspace_mgmt,       decode(ts.bitmapped,  0,  'DICTIONARY',  'LOCAL')   as extent_management,     (case when b.active_count > 0       then 'TRUE' else 'FALSE' end)          as is_backup  from sys.ts$ ts,        (select dfile.ts#,              sum( case when bkup.status = 'ACTIVE'                then 1 else 0 end ) as active_count     from v$backup bkup,  file$ dfile     where bkup.file# = dfile.file#       and dfile.status$ = 2     group by dfile.ts#) b  where ts.online$ != 3    and bitand(ts.flags,  2048) != 2048    and ts.ts#  = b.ts#
3sqgkcng6vx8rINSERT INTO sys.wri$_adv_rationale (id,  task_id,  rec_id,  obj_id,  impact_msg_id,  impact_val,  msg_id,  type,  attr1,  attr2,  attr3,  attr4,  attr5,  exec_name) VALUES (:1,  :2,  :3,  :4,  :5,    :6,  :7,  :8,  :9,  :10,  :11,    :12,  ' ',  :13) RETURNING rowid INTO :14
47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0         then 1 else 0 end) as fgw,         sum(case when a.session_type = 1 and a.wait_time <> 0         then 1 else 0 end) as fgc,      sum(case when a.session_type <> 1 and a.wait_time = 0         then 1 else 0 end) as bgw,         sum(case when a.session_type <> 1 and a.wait_time <> 0         then 1 else 0 end) as bgc,        sum(case when v.event_id is not null and               a.session_type = 1 and a.wait_time = 0          then 1 else 0 end) as fgi  FROM  WRH$_ACTIVE_SESSION_HISTORY a     ,     V$EVENT_NAME v  WHERE a.event_id = v.event_id(+)    AND v.wait_class(+) = 'Idle'    AND  a.dbid = :dbid  AND a.instance_number = :inst  AND a.snap_id > :bid AND a.snap_id <= :eid
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
5uw1u291s3m0kSELECT case when cnt = 0 then 0 else (1000000 * total) / cnt end  FROM (      SELECT SUM(m.num_interval) AS cnt,          SUM(m.num_interval * m.average) AS total        FROM  WRH$_SYSMETRIC_SUMMARY m ,   WRH$_METRIC_NAME n      WHERE m.dbid        =  :dbid        and m.instance_number =  :inst_num          and m.snap_id        >  :begin_snap_id    and m.snap_id          <=  :end_snap_id     and m.metric_id       = n.metric_id        and n.dbid          =  :dbid      and n.metric_name = 'Current OS Load'       )
692wcvj50ytxzinsert into wrh$_resource_limit   (snap_id,  dbid,  instance_number,    resource_name,    current_utilization,     max_utilization,  initial_allocation,    limit_value)  select    :snap_id,  :dbid,  :instance_number,  resource_name,  current_utilization,     max_utilization,  initial_allocation,  limit_value  from    v$resource_limit  where    limit_value != ' UNLIMITED' and     max_utilization > 0
69k5bhm12sz98
SELECT dbin.instance_number,         dbin.db_name,  dbin.instance_name,  dbin.host_name,  dbin.version,     CASE WHEN s1.startup_time = s2.startup_time        THEN 0 ELSE 1 END as bounce,         CAST(s1.end_interval_time AS DATE) as begin_time,           CAST(s2.end_interval_time AS DATE) as end_time,           ROUND((cast(           (case when s2.end_interval_time > s1.end_interval_time             then s2.end_interval_time else s1.end_interval_time             end) as date) -           cast(s1.end_interval_time as date)) * 86400) as int_secs,         CASE WHEN (s1.status <> 0 OR s2.status <> 0)          THEN 1 ELSE 0 END as err_detect,       round(       greatest(           (extract(day from s2.flush_elapsed) * 86400) +         (extract(hour from s2.flush_elapsed) * 3600) +         (extract(minute from s2.flush_elapsed) * 60) +        extract(second from s2.flush_elapsed),          (extract(day from s1.flush_elapsed) * 86400) +        (extract(hour from s1.flush_elapsed) * 3600) +           (extract(minute from s1.flush_elapsed) * 60) +           extract(second from s1.flush_elapsed), 0       )) as max_flush_secs  FROM     WRM$_SNAPSHOT s1 ,   WRM$_DATABASE_INSTANCE dbin ,   WRM$_SNAPSHOT s2    WHERE  s1.dbid = :dbid    AND   s2.dbid = :dbid  AND   s1.instance_number = s2.instance_number   AND   dbin.instance_number = s1.instance_number     AND   s1.snap_id  = :bid  AND     s2.snap_id = :eid  AND   dbin.dbid
= s1.dbid   AND   dbin.startup_time = s1.startup_time  and dbin.instance_number = :inst
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid,  :inst_num ,  :end_snap_id ); end;
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;
6hwjmjgrpsuaainsert into wrh$_enqueue_stat   (snap_id,  dbid,  instance_number,  eq_type,    req_reason,    total_req#,  total_wait#,  succ_req#,  failed_req#,    cum_wait_time,    event#)  select    :snap_id,  :dbid,  :instance_number,  eq_type,  req_reason,       total_req#,    total_wait#,  succ_req#,  failed_req#,       cum_wait_time,  event#  from    v$enqueue_statistics  where      total_req# != 0  order by    eq_type,  req_reason
6wm3n4d7bnddg
 SELECT source,     (case when time_secs < 1 then 1 else time_secs end) as time_secs,         operation    FROM   ( SELECT  1  as source,            trunc((sysdate - cast(ll.log_date as date)) * 86400)               as time_secs,              decode(ll.operation,               'OPEN',   0                  ,   1 ) as operation,             ll.log_id as log_id      FROM    DBA_SCHEDULER_WINDOW_LOG ll ,               ( SELECT max(l.log_id) as max_log_id              FROM  DBA_SCHEDULER_WINDOW_LOG l ,              DBA_SCHEDULER_WINGROUP_MEMBERS m             WHERE  l.window_name = m.window_name              AND  m.window_group_name = 'MAINTENANCE_WINDOW_GROUP'            AND  l.operation in ('OPEN',  'CLOSE')               AND    CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM  WRM$_SNAPSHOT bsi  WHERE  bsi.dbid = :dbid  AND bsi.instance_number = :inst    AND bsi.snap_id = :bid                               )           ) max_log          WHERE  ll.log_id = max_log.max_log_id         UNION ALL        SELECT    2  as source,            trunc((sysdate - cast(l.log_date as date)) * 86400)              as time_secs,             decode(l.operation,             'OPEN',   0                ,    1 ) as operation,           l.log_id as log_id           FROM  DBA_SCHEDULER_WINDOW_LOG l ,
      DBA_SCHEDULER_WINGROUP_MEMBERS m        WHERE  l.window_name = m.window_name        AND  m.window_group_name = 'MAINTENANCE_WINDOW_GROUP'         AND  l.operation in ('OPEN',  'CLOSE')        AND    CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM  WRM$_SNAPSHOT esi  WHERE  esi.dbid = :dbid    AND esi.instance_number = :inst  AND esi.snap_id = :eid                         )        AND  CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM  WRM$_SNAPSHOT bsi  WHERE  bsi.dbid = :dbid  AND bsi.instance_number = :inst  AND bsi.snap_id = :bid                         )       UNION ALL          SELECT  0  as source,             trunc((sysdate - et.etime) * 86400) as time_secs,             3  as operation,           0 as log_id        FROM (    SELECT cast(max(end_interval_time) as date) as etime FROM  WRM$_SNAPSHOT esi  WHERE  esi.dbid = :dbid  AND esi.instance_number = :inst    AND esi.snap_id = :eid             ) et       UNION ALL          SELECT  0  as source,             trunc((sysdate - bt.btime) * 86400) as time_secs,             2  as operation,           0 as log_id        FROM (    SELECT cast(min(end_interval_time) as date) as btime FROM  WRM$_SNAPSHOT bsi  WHERE  bsi.dbid = :dbid  AND bsi.instance_number = :inst    AND bsi.snap_id = :bid             ) bt     )  WHERE time_secs >= 0  ORDER B
Y source ASC,  time_secs DESC,    log_id ASC
7zsc0j9jsfm0hselect last_sample_date_num,    last_sample_date,  total_samples from WRI$_DBU_CPU_USAGE_SAMPLE where dbid     = :dbid and version  = :version
84k66tf2s7y1cinsert into wrh$_bg_event_summary   (snap_id,  dbid,  instance_number,       event_id,  total_waits,     total_timeouts,    time_waited_micro) select   :snap_id,  :dbid,  :instance_number,  event_id,    total_waits - total_waits_fg,    total_timeouts - total_timeouts_fg,    time_waited_micro - time_waited_micro_fg  from    v$system_event    where    (total_waits - total_waits_fg) > 0  order by    event_id
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       
8p9z2ztb272bm SELECT sx.instance_number,           sx.id,  sum(decode(e.snap_id,  NULL,  0,  1)) as cnt  FROM   (SELECT s.instance_number,    s.snap_id,  x.id,  x.name      FROM      WRM$_SNAPSHOT s ,   X$KEHSQT x     WHERE    s.dbid = :dbid    AND s.instance_number = :inst  AND s.snap_id >= :bid AND s.snap_id <= :eid       AND    s.status = 0           AND  x.ver_type = :existence      ) sx,      WRM$_SNAP_ERROR e  WHERE  e.dbid(+) = :dbid   AND  e.instance_number(+) = sx.instance_number     AND  e.snap_id(+) = sx.snap_id    AND    e.table_name(+) = sx.name  GROUP BY sx.instance_number,  sx.id    ORDER BY sx.instance_number
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 ,  VALUE = :B6 ,  STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
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 )         
9nkj1gjfq5k91select * from CC_USER where Lower(USER_NAME) = :1
9p5tvdmjymwx7UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 ,  SYSDATE),  ROWS_EVALUATED = NVL(:B11 ,  0),  TOTAL_VIOLATIONS_LOGGED = NVL(:B10 ,  TOTAL_VIOLATIONS_LOGGED),  NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 ,  :B8 ),  MAX_VIOLATION_LEVEL = NVL(:B7 ,  :B6 ),  COMPLIANCE_SCORE = NVL(:B5 ,  :B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1
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        
a6j566u48p8nfselect * from SYS_PDT_TYPE where PDT_TYPE_ID = :1        
aktbxfjwnzgmuupdate WRM$_DATABASE_INSTANCE set    last_ash_sample_id = :last_ash_sample_id where  instance_number    = :instance_number   and  dbid             = :dbid   and  startup_time = (select max(startup_time)                from   WRM$_DATABASE_INSTANCE             where    instance_number = :instance_number2                 and  dbid          = :dbid2 )
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     
bunssq950snhfinsert into wrh$_sga_target_advice   (snap_id,    dbid,  instance_number,     SGA_SIZE,  SGA_SIZE_FACTOR,  ESTD_DB_TIME,    ESTD_PHYSICAL_READS)  select    :snap_id,  :dbid,  :instance_number,     SGA_SIZE,  SGA_SIZE_FACTOR,  ESTD_DB_TIME,  ESTD_PHYSICAL_READS  from      v$sga_target_advice
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          
c8gnrhxma4tasSELECT owner#,    property FROM sys.wri$_adv_tasks WHERE id = :1
cumjq42201t37select u1.user#,  u2.user#,  u3.user#,  failures,  flag,  interval#,       what,  nlsenv,  env,  field1,  next_date  from sys.job$ j,  sys.user$ u1,  sys.user$ u2,  sys.user$ u3  where job=:1 and (next_date <= sysdate or :2 != 0)  and lowner = u1.name and powner = u2.name and cowner = u3.name
davq1msn9b8kdUPDATE MGMT_POLICY_ASSOC_EVAL_DETAILS SET CRIT_COUNTER = NVL(:B9 , CRIT_COUNTER),  WARN_COUNTER = NVL(:B8 , WARN_COUNTER),  INFO_COUNTER = NVL(:B7 , INFO_COUNTER),  LAST_ERROR_MESSAGE = :B6 ,  LAST_EVALUATION_DATE = :B5 WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND COLL_NAME = :B2 AND RESULT_KEY_VALUE = :B1
dayq182sk41ksinsert into wrh$_memory_target_advice   (snap_id,  dbid,  instance_number,     memory_size,  memory_size_factor,     estd_db_time,  estd_db_time_factor,  version)  select    :snap_id,  :dbid,  :instance_number,     memory_size,  memory_size_factor,     estd_db_time,  estd_db_time_factor,  version  from    v$memory_target_advice
dnwpm0gdccrphinsert into wrh$_process_memory_summary    (snap_id,  dbid,  instance_number,       category,  num_processes,  non_zero_allocs,        used_total,  allocated_total,      allocated_stddev,  allocated_max,  max_allocated_max)  select    :snap_id,  :dbid,  :instance_number,     category,     COUNT(*)             num_processes,     SUM(DECODE(allocated, 0, 0, 1)) non_zero_allocs,     SUM(used)             used_total,     SUM(allocated)           allocated_total,       STDDEV(allocated)        allocated_stddev,     MAX(allocated)           allocated_max,     MAX(max_allocated)       max_allocated_max  from v$process_memory    group by category
dnx1ugz1qwd2pinsert into OPERATE_LOG (LOG_ID, LOG_TYPE,  OPERATE_DATE,  OPERATE_DESC,  OPERATE_RESULT,  REMOTE_ADDRESS,  USER_ID,    USER_NAME, CLASS_NAME, METHOD_NAME)        values (:1, :2,  :3,  :4,  :5,    :6,  :7,  :8, :9, :10)        
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        
f0wj261bm8sndupdate wrm$_wr_control    set snap_interval = :bind1,  snapint_num = :bind2,    retention = :bind3,      retention_num = :bind4,  most_recent_snap_id = :bind5,       most_recent_snap_time = :bind6,    mrct_snap_time_num = :bind7,       status_flag = :bind8,  most_recent_purge_time = :bind9,     mrct_purge_time_num = :bind10,       most_recent_split_id = :bind11,  most_recent_split_time = :bind12,       swrf_version = :bind13,    registration_status = :bind14,         mrct_baseline_id = :bind15,  topnsql = :bind16,  mrct_bltmpl_id = :bind17      where dbid = :dbid
f318xdxdn0pdcinsert into wrh$_log        (snap_id,  dbid,  instance_number,    group#,  thread#,       sequence#,  bytes,  members,  archived,        status,  first_change#,  first_time)   select :snap_id,  :dbid,  :instance_number,         group#,  thread#,  sequence#,    bytes,         members,  archived,  status,  first_change#,  first_time     from v$log
faup55dtz1ufwSELECT COUNT(*) AS c    from sys_product sp       left join sys_vender sv on  sv.vender_id = sp.filiale_id       left join sys_pdt_type spt on spt.pdt_type_id = sp.pdt_type_id     left join sys_user su on sp.user_id =su.user_id          join appstore_token ap on ap.cc = su.cc          where sp.pdt_state = 1     AND     sp.filiale_id = :1           AND     sp.pdt_type_id = :2        
fdjtrdaz8hpvg
INSERT /*+ APPEND  LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1")  USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1")     */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id,  dbid,    instance_number,  sample_id,  sample_time ,  session_id,  session_serial#,  session_type ,  flags ,  user_id ,    sql_id,  sql_child_number,  sql_opcode,  force_matching_signature ,  top_level_sql_id,    top_level_sql_opcode ,    sql_plan_hash_value,  sql_plan_line_id ,  sql_plan_operation#,    sql_plan_options# ,  sql_exec_id,  sql_exec_start ,  plsql_entry_object_id,  plsql_entry_subprogram_id ,  plsql_object_id,      plsql_subprogram_id ,  qc_instance_id,  qc_session_id,  qc_session_serial# ,    event_id,  seq#,  p1,  p2,  p3 ,  wait_time,  time_waited ,  blocking_session,    blocking_session_serial#,  blocking_inst_id ,  current_obj#,  current_file#,  current_block#,  current_row# ,  top_level_call#,  consumer_group_id,  xid,  remote_instance#,  time_model ,  service_hash,  program,  module,  action,  client_id,  machine,  port,    ecid ,  tm_delta_time,  tm_delta_cpu_time,  tm_delta_db_time,  delta_time,  delta_read_io_requests,  delta_write_io_requests,  delta_read_io_bytes,  delta_write_io_bytes,  delta_interconnect_io_bytes,    pga_allocated,    temp_space_allocated  )  (SELECT :snap_id,  :dbid,  :instance_number,  a.sample_id,  a.sample_time ,  a.session_id,  a.session_serial#,  a.session_type ,  decode(a.flags,  0,    to_number(NULL),  a.
flags) ,  a.user_id ,  a.sql_id,  a.sql_child_number,  a.sql_opcode,  a.force_matching_signature ,  a.top_level_sql_id,  a.top_level_sql_opcode ,  a.sql_plan_hash_value,  a.sql_plan_line_id ,  a.sql_plan_operation#,  a.sql_plan_options# ,    a.sql_exec_id,    a.sql_exec_start ,  a.plsql_entry_object_id,  a.plsql_entry_subprogram_id ,  a.plsql_object_id,        a.plsql_subprogram_id ,    a.qc_instance_id,  a.qc_session_id,  a.qc_session_serial# ,  a.event_id,  a.seq#,  a.p1,  a.p2,  a.p3 ,  a.wait_time,  a.time_waited ,    a.blocking_session,  a.blocking_session_serial#,  a.blocking_inst_id ,    a.current_obj#,  a.current_file#,  a.current_block#,  a.current_row# ,    a.top_level_call#,  a.consumer_group_id,  a.xid,  a.remote_instance#,  a.time_model ,  a.service_hash ,  substrb(a.program,  1,  64) ,    a.module,  a.action,  a.client_id,  a.machine,    a.port,  a.ecid ,  decode(a.tm_delta_time,  0,    to_number(null),  a.tm_delta_time),  decode(a.tm_delta_time,  0,  to_number(null),  a.tm_delta_cpu_time),  decode(a.tm_delta_time,  0,    to_number(null),  a.tm_delta_db_time),    decode(a.delta_time,  0,  to_number(null),         a.delta_time),  decode(a.delta_time,  0,  to_number(null),       decode(a.delta_read_io_requests,  0,    to_number(null),          a.delta_read_io_requests)),  decode(a.delta_time,  0,  to_number(null),        decode(a.delta_write_io_requests,  0,  to_number(null),             a.delta_write_io_requests)),  decode(a.delta_time,  0,  to_number(null),
    decode(a.delta_read_io_bytes,  0,  to_number(null),          a.delta_read_io_bytes)),  decode(a.delta_time,  0,  to_number(null),        decode(a.delta_write_io_bytes,    0,  to_number(null),              a.delta_write_io_bytes)),  decode(a.delta_time,  0,  to_number(null),          decode(a.delta_interconnect_io_bytes,  0,  to_number(null),           a.delta_interconnect_io_bytes)),  decode(a.pga_allocated,  0,  to_number(null),  a.pga_allocated),  decode(a.pga_allocated,    0,  to_number(null),           decode(a.temp_space_allocated,  0,  to_number(null),             a.temp_space_allocated))    FROM   x$ash a,       (SELECT h.sample_addr,  h.sample_id        FROM   x$kewash h       WHERE          ( (h.sample_id >= :begin_flushing) and              (h.sample_id <  :latest_sample_id) )          and (h.is_awr_sample = 'Y')        ) shdr     WHERE shdr.sample_addr     = a.sample_addr    and shdr.sample_id     = a.sample_id       and a.need_awr_sample    = 'Y')
fp6ajqcjfqf2jinsert into wrh$_streams_pool_advice     (snap_id,  dbid,  instance_number,  size_for_estimate,     size_factor,  estd_spill_count,  estd_spill_time,      estd_unspill_count,  estd_unspill_time) select    :snap_id,  :dbid,  :instance_number,  streams_pool_size_for_estimate,     streams_pool_size_factor,  estd_spill_count,  estd_spill_time,     estd_unspill_count,  estd_unspill_time  from     v$streams_pool_advice    where streams_pool_size_for_estimate > 0
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gj6uc50hpnr1pinsert into WRH$_MUTEX_SLEEP      (snap_id,  dbid,  instance_number,      mutex_type,  location,  sleeps,  wait_time) select     :snap_id,  :dbid,  :instance_number,       mutex_type,    location,  sleeps,  wait_time  from    v$mutex_sleep  where    sleeps > 0 order by     mutex_type,  location
gkuh6srmynubb
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 v.VALID_FLAG=1 and s.VALID_FLAG=1         AND             d.CHECK_STATE=:5                        AND              us.SERIAL_NO=:6                AND             su.cc=:7              ) temp               where temp.RN=1 order by temp.SOFT_ID desc,  temp.VERSION_DETAIL_ID    


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 count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced80.010.00
CCursor + sql area evicted00.000.00
CPU used by this session325,797231.81184.69
CPU used when call started325,682231.73184.63
CR blocks created610.040.03
Cached Commit SCN referenced3520.250.20
Commit SCN cached600.040.03
DB time882,166627.67500.09
DBWR checkpoint buffers written2,7061.931.53
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 writes400.030.02
DBWR undo block writes4610.330.26
DFO trees parallelized00.000.00
HSC Heap Segment Block Changes6,1054.343.46
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts2140.150.12
Heap Segment Array Updates710.050.04
IMU CR rollbacks880.060.05
IMU Flushes6140.440.35
IMU Redo allocation size1,774,4801,262.561,005.94
IMU commits1,1740.840.67
IMU contention180.010.01
IMU ktichg flush00.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush10.000.00
IMU undo allocation size4,765,3443,390.592,701.44
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued2230.160.13
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 contention00.000.00
RowCR attempts2870.200.16
RowCR hits3120.220.18
SMON posted for dropping temp segment00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink50.000.00
SQL*Net roundtrips to/from client561,097399.23318.08
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 cleanout2490.180.14
application wait time00.000.00
auto extends on undo tablespace00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts5,8674.173.33
branch node splits10.000.00
buffer is not pinned count1,051,305748.01595.98
buffer is pinned count2,636,6421,876.001,494.70
bytes received via SQL*Net from client65,207,16846,395.5736,965.51
bytes sent via SQL*Net to client208,877,770148,618.69118,411.43
calls to get snapshot scn: kcmgss242,363172.44137.39
calls to kcmgas3,3202.361.88
calls to kcmgcs116,74683.0766.18
cell physical IO interconnect bytes96,099,84068,376.0354,478.37
change write time7850.560.45
cleanout - number of ktugct calls2130.150.12
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets50.000.00
cluster key scan block gets3200.230.18
cluster key scans1870.130.11
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed00.000.00
commit batch/immediate requested00.000.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure90.010.01
commit cleanout failures: cannot pin100.010.01
commit cleanouts10,5007.475.95
commit cleanouts successfully completed10,4817.465.94
commit immediate performed00.000.00
commit immediate requested00.000.00
commit txn count during cleanout8730.620.49
concurrency wait time8,5816.114.86
consistent changes1450.100.08
consistent gets3,674,6862,614.582,083.16
consistent gets - examination514,179365.84291.48
consistent gets direct2400.170.14
consistent gets from cache3,674,4462,614.412,083.02
consistent gets from cache (fastpath)2,876,1412,046.401,630.47
cursor authentications450.030.03
data blocks consistent reads - undo records applied1230.090.07
db block changes38,47927.3821.81
db block gets51,55836.6829.23
db block gets direct450.030.03
db block gets from cache51,51336.6529.20
db block gets from cache (fastpath)17,58812.519.97
deferred (CURRENT) block cleanout applications5,9224.213.36
dirty buffers inspected00.000.00
enqueue conversions3570.250.20
enqueue deadlocks00.000.00
enqueue releases21,65615.4112.28
enqueue requests21,65815.4112.28
enqueue timeouts00.000.00
enqueue waits10.000.00
exchange deadlocks00.000.00
execute count236,290168.12133.95
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time158,464,394112,749.0589,832.42
free buffer inspected7630.540.43
free buffer requested1,3060.930.74
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress590.040.03
hot buffers moved to head of LRU1410.100.08
immediate (CR) block cleanout applications50.000.00
immediate (CURRENT) block cleanout applications6450.460.37
index crx upgrade (positioned)310.020.02
index crx upgrade (prefetch)00.000.00
index fast full scans (full)1610.110.09
index fetch by key149,806106.5984.92
index scans kdiixs1329,361234.34186.71
leaf node 90-10 splits580.040.03
leaf node splits830.060.05
lob reads2470.180.14
lob writes680.050.04
lob writes unaligned680.050.04
logons cumulative2200.160.12
max cf enq hold time00.000.00
messages received3,0112.141.71
messages sent3,0112.141.71
min active SCN optimization applied on CR2090.150.12
no buffer to keep pinned count00.000.00
no work - consistent read gets2,971,7292,114.421,684.65
non-idle wait count608,820433.18345.14
non-idle wait time91,99965.4652.15
opened cursors cumulative235,708167.71133.62
parse count (describe)00.000.00
parse count (failures)10.000.00
parse count (hard)930.070.05
parse count (total)234,085166.55132.70
parse time cpu1940.140.11
parse time elapsed7,5965.404.31
physical read IO requests6540.470.37
physical read bytes5,357,5683,811.963,037.17
physical read total IO requests3,2532.311.84
physical read total bytes47,923,20034,097.8527,167.35
physical read total multi block requests00.000.00
physical reads6540.470.37
physical reads cache4140.290.23
physical reads cache prefetch00.000.00
physical reads direct2400.170.14
physical reads direct (lob)2230.160.13
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests1,5761.120.89
physical write bytes22,536,19216,034.7312,775.62
physical write total IO requests4,6463.312.63
physical write total bytes48,176,64034,278.1827,311.02
physical write total multi block requests410.030.02
physical writes2,7511.961.56
physical writes direct450.030.03
physical writes direct (lob)170.010.01
physical writes direct temporary tablespace00.000.00
physical writes from cache2,7061.931.53
physical writes non checkpoint1,0610.750.60
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,4792.481.97
queries parallelized00.000.00
recursive calls121,45686.4268.85
recursive cpu usage4060.290.23
redo blocks checksummed by FG (exclusive)10,9207.776.19
redo blocks written19,80714.0911.23
redo buffer allocation retries00.000.00
redo entries12,8079.117.26
redo k-bytes read total00.000.00
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks3650.260.21
redo size9,229,5846,566.945,232.19
redo size for direct writes370,304263.48209.92
redo subscn max counts1,1950.850.68
redo synch time35,20825.0519.96
redo synch writes2,0401.451.16
redo wastage579,652412.43328.60
redo write time22,04515.6912.50
redo writes2,1231.511.20
remote Oradebug requests00.000.00
rollback changes - undo records applied00.000.00
rollbacks only - consistent read gets610.040.03
root node splits00.000.00
rows fetched via callback97,88169.6455.49
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits160,731114.3691.12
session logical reads3,726,2442,651.262,112.38
shared hash latch upgrades - no wait72,30951.4540.99
shared hash latch upgrades - wait30.000.00
sorts (disk)00.000.00
sorts (memory)28,48420.2716.15
sorts (rows)601,258427.80340.85
sql area evicted810.060.05
sql area purged10.000.00
summed dirty queue length00.000.00
switch current to new buffer1770.130.10
table fetch by rowid1,599,1181,137.79906.53
table fetch continued row41,52929.5523.54
table scan blocks gotten863,519614.40489.52
table scan rows gotten42,805,02330,456.2224,265.89
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)43,49630.9524.66
temp space allocated (bytes)1,048,576746.07594.43
total cf enq hold time3,8702.752.19
total number of cf enq holders1050.070.06
total number of times SMON posted50.000.00
transaction rollbacks00.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size2,603,2401,852.231,475.76
user I/O wait time12,6869.037.19
user calls787,040559.99446.17
user commits1,7641.261.00
user rollbacks00.000.00
workarea executions - multipass00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal24,56517.4813.93
write clones created in background00.000.00
write clones created in foreground30.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,345,829,936,6641,346,147,590,760
session pga memory457,724,402,552457,789,413,424
session pga memory max515,429,559,768515,378,438,160
session cursor cache count13,296,01513,302,709
session uga memory803,995,508,435,512804,102,893,795,936
opened cursors current406391
workarea memory allocated7,4097,409
logons current9294


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)
Others40M1.86.02846015M0.67.010672356244.33
DBWR0M0.000M21M1.11.01494150690.07
LGWR0M0.000M10M1.51.0071152123103.36
Buffer Cache Reads4M0.29.0028460M0.000M410268.73
Direct Reads2M0.16.0014230M0.000M2230.00
Direct Writes0M0.000M0M0.010M210.00
TOTAL:46M2.31.03272946M3.31.032729684577.88


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 File41M1.84.02917115M0.67.0106721.69 
Data File5M0.48.00355721M1.12.014941168.99 
Log File0M0.000M10M1.51.007115  
TOTAL:46M2.31.03272946M3.31.03272936.09 


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
41M1.86.02917115M0.67.01067226162.70

 Others (Control File)
41M1.84.02917115M0.67.01067225811.69

 Others (Data File)
0M0.020M0M0.000M3577.40

DBWR
0M0.000M21M1.11.0149410 

 DBWR (Data File)
0M0.000M21M1.11.0149410 

LGWR
0M0.000M10M1.51.0071150 

 LGWR (Log File)
0M0.000M10M1.51.0071150 

Buffer Cache Reads
4M0.29.0028460M0.000M409269.38

 Buffer Cache Reads (Data File)
4M0.29.0028460M0.000M409269.38

Direct Reads
2M0.16.0014230M0.000M0 

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

Direct Writes
0M0.000M0M0.010M0 

 Direct Writes (Data File)
0M0.000M0M0.010M0 

TOTAL:
47M2.31.03344046M3.31.032729302538.76


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)
SYSAUX2090396.891.00841100.00
MYCAR429039.931.005440455.00
UNDOTBS1000.000.0099030.00
SYSTEM210575.241.0050030.00
PASSPORT6086.671.0042000.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.dbf24604.391.00178000.00
MYCAR/oracle/oradata/mycar/mycar01.dbf183087.701.003660455.00
PASSPORT/oracle/oradata/mycar/passport.dbf6086.671.0042000.00
SYSAUX/oracle/oradata/mycar/sysaux01.dbf2090396.891.00841100.00
SYSTEM/oracle/oradata/mycar/system01.dbf210575.241.0050030.00
UNDOTBS1/oracle/oradata/mycar/undotbs01.dbf00  99030.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,5301003,725,8754262,7060010


Back to Buffer Pool Statistics

Back to Top



Checkpoint Activity



  • Total Physical Writes:                  2,751




MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00002,7060


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
B01445726821199399532811993   
E01446336512223799532822237   


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
D640.0881.852,905,15211892882.00
D1280.16161.292,035,4861680289.00
D1920.24241.011,592,240162263.00
D2560.33321.001,578,303142829.00
D3200.41391.001,574,793137935.00
D3840.49471.001,574,186137089.00
D4480.57551.001,573,713136429.00
D5120.65631.001,573,349135922.00
D5760.73711.001,573,049135503.00
D6400.82791.001,572,766135109.00
D7040.90871.001,572,536134788.00
D7680.98951.001,572,338134513.00
D7841.00971.001,572,292134448.00
D8321.061021.001,572,152134253.00
D8961.141101.001,571,971134001.00
D9601.221181.001,571,780133734.00
D1,0241.311261.001,571,650133553.00
D1,0881.391341.001,571,549133412.00
D1,1521.471421.001,571,462133291.00
D1,2161.551501.001,571,382133180.00
D1,2801.631581.001,571,281133038.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.001,0680


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
2K4K21,61221,61200
64K128K1,2401,24000
128K256K68668600
256K512K8800
512K1024K91191100
1M2M10310300
2M4M1100
4M8M4400


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.1328,120,921.7952,829,686.2635.00405,27195,433,405,200
2840.2528,120,921.7952,667,945.2035.00401,13495,242,727,197
5680.5028,120,921.7913,327,939.9068.00948,864,438,550
8520.7528,120,921.7912,964,308.2868.00048,435,749,942
1,1361.0028,120,921.7912,107,330.2270.00047,425,450,743
1,3631.2028,120,921.7911,946,154.4570.00047,235,439,164
1,5901.4028,120,921.7911,946,004.6270.00047,235,262,536
1,8181.6028,120,921.7911,945,893.7070.00047,235,131,767
2,0451.8028,120,921.7911,945,893.7070.00047,235,131,767
2,2722.0028,120,921.7911,945,893.7070.00047,235,131,767
3,4083.0028,120,921.7911,945,893.7070.00047,235,131,767
4,5444.0028,120,921.7911,945,734.1170.00047,234,943,625
6,8166.0028,120,921.7911,945,734.1170.00047,234,943,625
9,0888.0028,120,921.7911,945,734.1170.00047,234,943,625


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.59392,1367,464,4671.00305,0511.08118,443
8800.701678,0737,469,6771.00299,8411.06382,307
1,0080.8029511,9137,482,0581.00287,4601.02383,071
1,1360.9042316,0967,484,4281.00285,0901.01383,363
1,2641.0055120,5047,486,4021.00283,1161.00383,610
1,3921.1067923,9637,488,0641.00281,4540.99383,828
1,5201.2080727,8817,488,9441.00280,5740.99383,952
1,6481.3093531,9647,489,3611.00280,1570.99384,007
1,7761.411,06335,2427,489,7831.00279,7350.99384,046
1,9041.511,19138,8217,490,0771.00279,4410.99384,067
2,0321.611,31942,5217,490,3351.00279,1830.99384,084
2,1601.711,44746,1827,490,5211.00278,9970.99384,098
2,2881.811,57550,0147,490,6961.00278,8220.98384,110
2,4161.911,70353,2967,490,8471.00278,6710.98384,120
2,5442.011,83156,3197,490,9381.00278,5800.98384,130


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,726,9391,591,945,921
1,6080.756,681,5451,573,864,560
2,1441.006,675,5371,572,292,268
2,6801.256,672,8671,571,506,122
3,2161.506,671,5321,571,191,663
3,7521.756,670,8641,571,034,434
4,2882.006,670,8641,571,034,434


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 block7031
undo header300


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)
CF-Controlfile Transaction650650010260.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.442,7699044240/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
18-Jul 17:201841,37030442400/00/0/0/0/0/0
18-Jul 17:109392990422400/00/0/0/0/0/0
18-Jul 17:0016147029932400/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 latch20.00 00 
ASM db client latch9400.00 00 
ASM map operation hash table20.00 00 
ASM network state latch250.00 00 
AWR Alerted Metric Element list12,0220.00 00 
Change Notification Hash table latch4620.00 00 
Consistent RBA2,1230.00 00 
DML lock allocation12,2220.00 00 
Event Group Locks1970.00 00 
FAL Queue690.00 00 
FOB s.o list latch8580.00 00 
File State Object Pool Parent Latch20.00 00 
IPC stats buffer allocation latch20.00 00 
In memory undo latch15,2310.00 02,1040.00
JS Sh mem access60.00 00 
JS mem alloc latch20.00 00 
JS queue access latch40.00 00 
JS queue state obj latch9,8280.00 00 
JS slv state obj latch940.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST20.00 00 
KJC message pool free list20.00 00 
KJCT flow control latch20.00 00 
KMG MMAN ready and startup request latch4670.00 00 
KTF sga latch80.00 03700.00
KWQP Prop Status40.00 00 
KWQS pqsubs latch100.00 00 
KWQS pqueue ctx latch640.00 00 
Locator state objects pool parent latch20.00 00 
Lsod array latch20.00 00 
MQL Tracking Latch0  0270.00
Memory Management Latch20.00 04670.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch80.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process9050.00 00 
OS process allocation1,0690.00 00 
OS process: request allocation3880.00 00 
PL/SQL warning settings3240.00 00 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch1,6330.00 00 
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch480.00 04400.00
SQL memory manager workarea list latch59,8100.00 00 
Shared B-Tree1940.00 00 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
WCR: sync20.00 00 
Write State Object Pool Parent Latch20.00 00 
X$KSFQP4,6700.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch9610.00 00 
active service list3,9480.050.0005,9330.00
archive control240.00 00 
archive process latch2070.00 00 
begin backup scn array210.00 00 
buffer pool20.00 00 
business card20.00 00 
cache buffer handles10,2920.00 00 
cache buffers chains7,064,6880.000.3581,2420.00
cache buffers lru chain3,0770.00 06,6540.00
call allocation1,0160.891.1110 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch4080.00 00 
channel operations parent latch7,3860.00 00 
checkpoint queue latch46,4910.00 02,5920.00
client/application info1,4980.00 00 
compile environment latch2200.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch250.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch250.00 00 
dml lock allocation250.00 00 
done queue latch20.00 00 
dummy allocation4400.00 00 
enqueue hash chains43,6460.000.5000 
enqueues24,5920.010.0000 
fifth spare latch20.00 00 
file cache latch1240.00 00 
flashback copy20.00 00 
gc element20.00 00 
gcs commit scn state20.00 00 
gcs partitioned table hash20.00 00 
gcs pcm hashed value bucket hash20.00 00 
gcs resource freelist20.00 00 
gcs resource hash20.00 00 
gcs resource scan list20.00 00 
gcs shadows freelist20.00 00 
ges domain table20.00 00 
ges enqueue table freelist20.00 00 
ges group table20.00 00 
ges process hash list20.00 00 
ges process parent latch20.00 00 
ges resource hash list20.00 00 
ges resource scan list20.00 00 
ges resource table freelist20.00 00 
ges value block free list20.00 00 
global KZLD latch for mem in SGA1400.00 00 
global tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch330.00 021,4790.00
hash table modification latch650.00 00 
heartbeat check20.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch270.00 0250.00
job_queue_processes free list latch500.00 00 
job_queue_processes parameter latch3200.00 00 
k2q lock allocation20.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kks stats4790.00 00 
kokc descriptor allocation latch2380.00 00 
ksfv messages20.00 00 
kss move lock180.00 00 
ksuosstats global area1000.00 00 
ksv allocation latch580.00 00 
ksv class latch360.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch3880.00 00 
ktm global data190.00 00 
kwqbsn:qsga540.00 00 
lgwr LWN SCN2,5540.00 00 
list of block allocation5230.00 00 
loader state object freelist5360.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch60.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation40.00 00 
logminer work area20.00 00 
longop free list parent20.00 00 
managed standby latch690.00 00 
mapped buffers lru chain20.00 00 
message pool operations parent latch770.00 00 
messages20,6500.030.0000 
mostly latch-free SCN2,5540.00 00 
msg queue latch20.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch250.00 00 
object queue header heap310.00 0130.00
object queue header operation13,2850.00 00 
object stats modification80.00 00 
parallel query alloc buffer1820.00 00 
parallel query stats20.00 00 
parameter list2300.00 00 
parameter table management4380.00 00 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue5,1870.020.0004,2530.07
process allocation4420.00 01950.00
process group creation3880.00 00 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch3500.00 00 
query server freelists20.00 00 
queued dump request40.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation11,3870.00 012,7450.00
redo copy20.00 012,7451.29
redo writing8,2590.00 00 
resmgr group change latch2970.00 00 
resmgr:active threads4400.00 00 
resmgr:actses change group1760.00 00 
resmgr:actses change state20.00 00 
resmgr:free threads list4380.00 00 
resmgr:plan CPU method20.00 00 
resmgr:resource group CPU method20.00 00 
resmgr:schema config1620.00 00 
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects169,4100.020.200420.00
rules engine rule set statistics2000.00 00 
second spare latch20.00 00 
sequence cache11,5440.00 00 
session allocation172,0540.000.25057,3520.00
session idle bit1,631,2140.000.0700 
session queue latch20.00 00 
session state list latch4650.00 00 
session switching9920.00 00 
session timer5180.00 00 
shared pool21,0700.790.20160 
shared pool sim alloc20.00 00 
shared pool simulator1,0410.00 00 
sim partition latch20.00 00 
simulator hash latch269,9700.00 00 
simulator lru latch1,3020.080.000268,5540.04
sort extent pool490.00 00 
space background task latch9900.00 09320.00
state object free list40.00 00 
statistics aggregation1,1200.00 00 
tablespace key chain20.00 00 
temp lob duration state obj allocation30.00 00 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch600.00 00 
transaction allocation8400.00 00 
undo global data12,7860.00 00 
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 


Back to Latch Statistics

Back to Top



Latch Sleep Breakdown



  • ordered by misses desc










Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains7,064,68817060110
shared pool21,07016734136
row cache objects169,41035728
session idle bit1,631,21428226
call allocation1,0169100
session allocation172,054413
enqueue hash chains43,646211


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
active service listkswslogon: session logout011
cache buffers chainskcbgtcr: fast path (cr pin)03434
cache buffers chainskcbrls_101515
cache buffers chainskcbgtcr: fast path073
cache buffers chainskcbrls_2035
cache buffers chainskcbgcur_2010
cache buffers chainskcbgtcr_2013
call allocationksudlp: top call070
call allocationksuxds0310
enqueue hash chainsksqgtl3010
row cache objectskqrpre: find obj047
row cache objectskqreqd: reget030
session allocationksuxds011
session idle bitksupuc: clear busy011
session idle bitksupuc: set busy011
shared poolkghalo02226
shared poolkghupr1086
shared poolkghfre032
shared poolkghalp010


Back to Latch Statistics

Back to Top



Mutex Sleep Summary



  • ordered by number of sleeps desc











Mutex TypeLocationSleepsWait    Time (ms)
Library Cachekglpin1   4881,794
Library Cachekgllkdl1  85976
Cursor PinkksLockDelete [KKSCHLPIN6]20
Cursor Pinkksfbc [KKSCHLPIN1]20
Library CachekglIsOwnerVersionable 1211109
Library Cachekglhdgn2 1061517
Library Cachekglpndl1  951-56
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]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:       3,726,244

  • Captured Segments account for    93.9% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeLogical Reads%Total
MYCARMYCARUNI_IP_RANGE INDEX1,420,03238.11
MYCARMYCARSYS_VENDER TABLE294,7847.91
MYCARMYCARSYS_PRODUCT TABLE174,3524.68
MYCARMYCARSYS_PRODUCT_IP_RULE TABLE154,9924.16
MYCARMYCARDIAG_SOFT_VERSION TABLE150,1604.03


Back to Segment Statistics

Back to Top



Segments by Physical Reads



  • Total Physical Reads:          654

  • Captured Segments account for    42.0% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhysical Reads%Total
MYCARMYCAROPERATE_LOG TABLE10015.29
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE385.81
SYSSYSAUXWRH$_SQL_PLAN TABLE243.67
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX223.36
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_10051TABLE PARTITION203.06


Back to Segment Statistics

Back to Top



Segments by Physical Read Requests



  • Total Physical Read Requests:          654

  • Captured Segments account for    42.0% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhys Read Requests%Total
MYCARMYCAROPERATE_LOG TABLE10015.29
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE385.81
SYSSYSAUXWRH$_SQL_PLAN TABLE243.67
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX223.36
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_10051TABLE PARTITION203.06


Back to Segment Statistics

Back to Top



Segments by UnOptimized Reads



  • Total UnOptimized Read Requests:         654

  • Captured Segments account for    42.0% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypeUnOptimized Reads%Total
MYCARMYCAROPERATE_LOG TABLE10015.29
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE385.81
SYSSYSAUXWRH$_SQL_PLAN TABLE243.67
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX223.36
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_10051TABLE PARTITION203.06


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:         2,751

  • Captured Segments account for    47.4% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhysical Writes%Total
MYCARMYCAROPERATE_LOG TABLE40114.58
MYCARMYCARCOM_IND_DUSC INDEX2248.14
MYCARMYCARPK_OPERATE_LOG INDEX572.07
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE552.00
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX552.00


Back to Segment Statistics

Back to Top



Segments by Physical Write Requests



  • Total Physical Write Requestss:       1,576

  • Captured Segments account for    46.0% of Total








OwnerTablespace      NameObject NameSubobject   NameObj. TypePhys Write Requests%Total
MYCARMYCAROPERATE_LOG TABLE1569.90
MYCARMYCARCOM_IND_DUSC INDEX1418.95
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE493.11
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX483.05
SYSSYSAUXWRH$_SQL_PLAN TABLE412.60


Back to Segment Statistics

Back to Top



Segments by Direct Physical Writes



  • Total Direct Physical Writes:           45

  • Captured Segments account for  100.0% of Total





OwnerTablespace      NameObject NameSubobject   NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1652681432_10051TABLE PARTITION2862.22
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB1737.78


Back to Segment Statistics

Back to Top



Segments by Table Scans



  • Total Table Scans:           161

  • Captured Segments account for    30.4% of Total




OwnerTablespace      NameObject NameSubobject   NameObj. TypeTable Scans%Total
MYCARMYCARPK_SYS_LAN INDEX4930.43


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 TABLE1,74428.99
MYCARMYCARPK_OPERATE_LOG INDEX76812.77
SYSSYSAUXWRH$_SQL_PLAN TABLE72011.97
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX62410.37
MYCARMYCARDIAG_DOWNLOAD_RECORD TABLE2724.52


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
MYCARMYCARIND2_DIAG_DOWNLOAD_RECORD INDEX360.00
MYCARMYCARPK_DIAG_DOWNLOAD_RECORD INDEX240.00


Back to Segment Statistics

Back to Top



Segments by ITL Waits




          No data exists for this section of the report.


Back to Segment Statistics

Back to Top



Segments by Buffer Busy Waits



  • % 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
SYSSYSTEMAUD$ TABLE3100.00


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_control300.000 41
dc_global_oids2670.000 048
dc_histogram_data1,2490.080 04,778
dc_histogram_defs1,7266.890 05,453
dc_objects2,0330.200 02,702
dc_profiles1650.000 01
dc_rollback_segments9090.000 052
dc_segments9110.000 151,390
dc_sequences3450.000 34556
dc_tablespaces19,2670.000 010
dc_users31,4670.000 0165
global database name1,0960.000 02
outstanding_alerts140.000 07
sch_lj_oids20.000 016



Back to Top




Library Cache Activity



  • "Pct Misses"  should be very low 













NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY5630.007390.0000
CLUSTER30.0020.0000
DBLINK2820.000 00
EDITION1740.003390.0000
QUEUE320.001120.0000
SCHEMA3050.000 00
SQL AREA8,7071.75244,1300.09501
SUBSCRIPTION90.0090.0000
TABLE/PROCEDURE1,7420.0028,6130.19550
TRIGGER100.00250.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.00752.00816.000GRO/MAN
KEEP buffer cache0.000.000.0032.000SHR/MAN
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
BOther379.76 4.048.1628329494
 Freeable53.940.001.080.684 5050
 SQL1.550.950.020.020257266
 PL/SQL1.180.950.010.03009292
EOther379.98 3.968.0928329696
 Freeable56.940.001.090.674 5252
 SQL2.131.530.030.071257468
 PL/SQL1.220.990.010.03009494


Back to Memory Statistics

Back to Top



SGA Memory Summary









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


Back to Memory Statistics

Back to Top



SGA breakdown difference



  • ordered by Pool, Name    

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



















PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool7.507.500.00
largefree memory8.508.500.00
sharedCCUR87.2287.250.03
sharedFileOpenBlock15.2015.200.00
sharedKGLHD25.8225.860.16
sharedKGLS14.0014.00-0.03
sharedPCUR76.7276.790.09
sharedPLMCD13.2512.99-1.98
sharedSQLA498.86499.200.07
sharedfree memory329.32329.08-0.07
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)
34340.000.001.072.390.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.030.07


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 %
1,4050.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.001,4050.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_keep_cache_size0  
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

Report written to /tmp/awrrpt_1_10059_10061.html
SQL> 

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

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

注册时间:2012-10-21

  • 博文量
    20
  • 访问量
    55011