soadb@husoaa04[/export/home/oracledb/oracle]cat awrrpt_1_24997_24998.html AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
SOADB196954648soadb1110.2.0.4.0NOhusoaa04

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2499713-Dec-13 22:00:0632 4.7
End Snap:2499813-Dec-13 23:00:1831 2.5
Elapsed:  60.20 (mins)  
DB Time:  6.23 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 736M 736MStd Block Size: 8K
Shared Pool Size: 736M 736MLog Buffer: 14,372K

Load Profile

Per SecondPer Transaction
Redo size: 26,921.29 133,395.35
Logical reads: 122,816.05 608,555.21
Block changes: 145.43 720.60
Physical reads: 428.77 2,124.54
Physical writes: 6.75 33.47
User calls: 1.89 9.38
Parses: 3.82 18.94
Hard parses: 0.28 1.37
Sorts: 2.55 12.64
Logons: 0.01 0.07
Executes: 19.66 97.41
Transactions: 0.20 

% Blocks changed per Read: 0.12Recursive Call %: 98.38
Rollback per transaction %: 0.14Rows per Sort: 1677.08

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.65In-memory Sort %: 100.00
Library Hit %: 96.51Soft Parse %: 92.78
Execute to Parse %: 80.56Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 88.05% Non-Parse CPU: 99.49

Shared Pool Statistics

BeginEnd
Memory Usage %: 70.76 71.71
% SQL with executions>1: 77.49 82.32
% Memory for SQL w/exec>1: 71.40 72.98

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  275  73.7 
db file scattered read 105,928 61 1 16.2User I/O
db file sequential read 73,595 5 0 1.4User I/O
log file parallel write 2,346 2 1 .7System I/O
control file parallel write 1,442 2 1 .5System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 374.91 100.33
DB CPU 275.26 73.66
PL/SQL execution elapsed time 13.59 3.64
parse time elapsed 3.36 0.90
hard parse elapsed time 2.96 0.79
failed parse elapsed time 0.17 0.05
PL/SQL compilation elapsed time 0.14 0.04
hard parse (sharing criteria) elapsed time 0.12 0.03
repeated bind elapsed time 0.11 0.03
connection management call elapsed time 0.06 0.02
sequence load elapsed time 0.02 0.01
hard parse (bind mismatch) elapsed time 0.00 0.00
DB time 373.68  
background elapsed time 2,525.48  
background cpu time 2,521.13  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 187,913 0.00 66 0 257.77
System I/O 6,674 0.00 4 1 9.16
Network 5,854 0.00 1 0 8.03
Commit 493 0.00 0 1 0.68
Concurrency 14 0.00 0 24 0.02
Other 268 0.00 0 0 0.37
Application 761 0.00 0 0 1.04
Configuration 44 0.00 0 1 0.06

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file scattered read 105,928 0.00 61 1 145.31
db file sequential read 73,595 0.00 5 0 100.95
log file parallel write 2,346 0.00 2 1 3.22
control file parallel write 1,442 0.00 2 1 1.98
SQL*Net more data from client 529 0.00 1 1 0.73
log file sync 493 0.00 0 1 0.68
os thread startup 6 0.00 0 57 0.01
rdbms ipc reply 39 0.00 0 1 0.05
SQL*Net break/reset to client 737 0.00 0 0 1.01
latch free 131 0.00 0 0 0.18
control file sequential read 2,878 0.00 0 0 3.95
log file switch completion 5 0.00 0 6 0.01
log buffer space 39 0.00 0 0 0.05
direct path read 5,171 0.00 0 0 7.09
reliable message 38 0.00 0 0 0.05
SQL*Net message to client 5,205 0.00 0 0 7.14
direct path write temp 3,173 0.00 0 0 4.35
SQL*Net more data to client 120 0.00 0 0 0.16
LGWR wait for redo copy 57 0.00 0 0 0.08
enq: RO - fast object reuse 24 0.00 0 0 0.03
log file single write 4 0.00 0 0 0.01
db file parallel read 9 0.00 0 0 0.01
latch: cache buffers chains 4 0.00 0 0 0.01
buffer busy waits 4 0.00 0 0 0.01
direct path write 37 0.00 0 0 0.05
log file sequential read 4 0.00 0 0 0.01
latch: redo allocation 2 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
SQL*Net message from client 5,202 0.00 22,089 4246 7.14
virtual circuit status 121 100.00 3,529 29164 0.17
Streams AQ: qmn slave idle wait 129 0.00 3,513 27229 0.18
Streams AQ: qmn coordinator idle wait 130 100.00 3,512 27018 0.18
jobq slave wait 118 100.00 347 2939 0.16
Streams AQ: waiting for time management or cleanup tasks 1 100.00 269 268948 0.00
class slave wait 3 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 2,343 0.00 2 1 3.21
control file parallel write 1,442 0.00 2 1 1.98
os thread startup 6 0.00 0 57 0.01
control file sequential read 1,775 0.00 0 0 2.43
log buffer space 39 0.00 0 0 0.05
events in waitclass Other 190 0.00 0 0 0.26
log file single write 4 0.00 0 0 0.01
latch: cache buffers chains 3 0.00 0 0 0.00
db file sequential read 13 0.00 0 0 0.02
log file sequential read 4 0.00 0 0 0.01
direct path read 30 0.00 0 0 0.04
direct path write 29 0.00 0 0 0.04
buffer busy waits 1 0.00 0 0 0.00
rdbms ipc message 13,696 83.92 30,356 2216 18.79
pmon timer 1,218 100.00 3,524 2893 1.67
Streams AQ: qmn slave idle wait 129 0.00 3,513 27229 0.18
Streams AQ: qmn coordinator idle wait 130 100.00 3,512 27018 0.18
smon timer 6 50.00 1,023 170580 0.01
Streams AQ: waiting for time management or cleanup tasks 1 100.00 269 268948 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 38,960
AVG_IDLE_TIME 321,324
AVG_IOWAIT_TIME 5,792
AVG_SYS_TIME 2,840
AVG_USER_TIME 36,013
BUSY_TIME 312,512
IDLE_TIME 2,571,359
IOWAIT_TIME 47,160
SYS_TIME 23,545
USER_TIME 288,967
LOAD 0
OS_CPU_WAIT_TIME 99,725,216,400
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 6,557,696
VM_OUT_BYTES 835,584
PHYSICAL_MEMORY_BYTES 68,684,804,096
NUM_CPUS 8
NUM_CPU_SOCKETS 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 366.30 268.50 1,547,255 4,906,126
soadb1 7.30 6.80 1,212 172,341
SYS$BACKGROUND 0.00 0.00 4,762 438,557,929
soadb1XDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 184402 6542 4 0 0 0 548 0
soadb1 553 48 0 0 0 0 5180 14
SYS$BACKGROUND 2964 9 10 34 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
1,146 1,138 14,210 0.08 306.79 7cq8d0jqxzum1   delete from smon_scn_time wher...
124 78 1 123.85 33.14 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
20 8 1 19.73 5.28 btrbwhdzccc68 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
14 14 1 13.96 3.74 235a9tfrp53ys DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
12 10 1 12.40 3.32 4049pr0xgymgb DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
12 2 1 11.82 3.16 6dr2b3qpsr392 DBMS_SCHEDULER select /*+ no_parallel(t) no_...
6 3 1 6.25 1.67 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
4 3 1 4.21 1.13 06yqffk58rhwc DBMS_SCHEDULER select /*+ no_parallel_index(t...
4 1 1 3.68 0.98 4u5fuanhvrjpu DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
4 4 1 3.57 0.95 ghdcby0n08nq3 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1,138 1,146 14,210 0.08 306.79 7cq8d0jqxzum1   delete from smon_scn_time wher...
78 124 1 77.58 33.14 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
14 14 1 13.96 3.74 235a9tfrp53ys DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
10 12 1 10.09 3.32 4049pr0xgymgb DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
8 20 1 7.57 5.28 btrbwhdzccc68 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
4 4 1 3.57 0.95 ghdcby0n08nq3 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
3 4 1 3.41 1.13 06yqffk58rhwc DBMS_SCHEDULER select /*+ no_parallel_index(t...
3 6 1 3.29 1.67 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
3 3 2 1.56 0.88 bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
3 3 2,780 0.00 0.75 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
2 12 1 2.36 3.16 6dr2b3qpsr392 DBMS_SCHEDULER select /*+ no_parallel(t) no_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
202,106,074 14,210 14,222.81 45.56 1137.56 1146.40 7cq8d0jqxzum1   delete from smon_scn_time wher...
1,961,508 1 1,961,508.00 0.44 77.58 123.85 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
391,093 1 391,093.00 0.09 13.96 13.96 235a9tfrp53ys DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
360,753 1 360,753.00 0.08 10.09 12.40 4049pr0xgymgb DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
204,647 1,014 201.82 0.05 0.77 0.77 cvhk2j2gymzhd DBMS_SCHEDULER SELECT SU.NAME, SO.NAME, A.S...
160,472 1 160,472.00 0.04 3.29 6.25 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
126,517 2,780 45.51 0.03 2.79 2.79 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
124,552 1 124,552.00 0.03 0.72 0.73 24b3xmp4wd3tu   delete from sys.wri$_optstat_h...
119,194 2 59,597.00 0.03 3.12 3.27 bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
101,363 1 101,363.00 0.02 7.57 19.73 btrbwhdzccc68 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
1,495,131 1 1,495,131.00 96.54 77.58 123.85 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
388,243 1 388,243.00 25.07 10.09 12.40 4049pr0xgymgb DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
367,535 1 367,535.00 23.73 13.96 13.96 235a9tfrp53ys DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
330,599 1 330,599.00 21.35 7.57 19.73 btrbwhdzccc68 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
115,010 1 115,010.00 7.43 2.36 11.82 6dr2b3qpsr392 DBMS_SCHEDULER select /*+ no_parallel(t) no_...
79,426 1 79,426.00 5.13 3.29 6.25 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
47,075 12 3,922.92 3.04 1.27 2.95 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
46,048 1 46,048.00 2.97 0.94 3.68 4u5fuanhvrjpu DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
35,696 1 35,696.00 2.30 1.08 2.47 ctkp25m7h5wgy DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
14,330 1 14,330.00 0.93 0.32 1.26 bhknx5mjxg6y1 DBMS_SCHEDULER select /*+ no_parallel(t) no_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
14,210 14,210 1.00 0.08 0.08 7cq8d0jqxzum1   delete from smon_scn_time wher...
3,437 2,541 0.74 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
2,780 20,195 7.26 0.00 0.00 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
1,039 16,651 16.03 0.00 0.00 4y1y43113gv8f   delete from histgrm$ where obj...
1,022 1,022 1.00 0.00 0.00 cydgw456rs7z0   insert into sys.wri$_optstat_h...
1,014 0 0.00 0.00 0.00 cvhk2j2gymzhd DBMS_SCHEDULER SELECT SU.NAME, SO.NAME, A.S...
961 961 1.00 0.00 0.00 d4fx505x4f6yy   INSERT INTO audit_trail( cikey...
560 560 1.00 0.00 0.00 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
559 8,474 15.16 0.00 0.00 83taa7kaw59c1   select name, intcol#, segcol#,...
555 727 1.31 0.00 0.00 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
555 555 4.02 8hd36umbhpgsz   select parttype, partcnt, pa...
477 477 3.46 3pphjhb4cv3jw   INSERT INTO CUBE_SCOPE( CIKEY,...
477 477 3.46 435dczbfgs18y   BEGIN INSERT INTO cube_scope(...
477 477 3.46 6g4su86aysa1z   INSERT INTO cube_instance( ci...
477 961 3.46 d4fx505x4f6yy   INSERT INTO audit_trail( cikey...
347 347 2.51 cbdfcfcp1pgtp   select intcol#, col# , type#...
271 271 1.96 130dvvr5s8bgn   select obj#, dataobj#, part#...
257 257 1.86 3kywng531fcxu   delete from tab_stats$ where o...
235 235 1.70 0h6b2sajwb74n   select privilege#, level from ...
219 219 1.59 27xdav1rg5g14   select u.name, o.name, o.nam...
175 175 1.27 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
163 163 1.18 b5cr4hhndmbuf   update tab$ set ts#=:2, file#=...
163 163 1.18 gsfnqdfcvy33q   delete from superobj$ where su...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,482,297 1 0.32 31a13pnjps7j3   SELECT source, (case w...
1,653,174 2 0.21 8vkjh60z1g287   select OBJOID, CLSOID, RUNT...
1,363,893 477 0.18 6g4su86aysa1z   INSERT INTO cube_instance( ci...
1,335,876 118 0.17 78m9ryygp65v5 sqlplus@husoaa04 (TNS V1-V3) SELECT /*+ ALL_ROWS */ COUNT(*...
1,148,376 2 0.15 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
32 477 6g4su86aysa1z   INSERT INTO cube_instance( ci...
27 1 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
27 36 dv7aptbr6m6bn   INSERT INTO audit_details ( ci...
26 2 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...
25 1 bhvyz9bgyrhb2   SELECT name, datatype, value, ...
24 1 0cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
22 1 akh9zqqkx3wj7   select 1, max(id) from sys.wr...
21 1 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
21 1 31a13pnjps7j3   SELECT source, (case w...
21 1 76natvnhtqqhw   INSERT INTO SYS.WRI$_ADV_TASKS...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
06yqffk58rhwcselect /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4226, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")||sys_op_descend("INTCOL#")||sys_op_descend(SYS_EXTRACT_UTC("SAVTIME")))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" t where "OBJ#" is not null or "INTCOL#" is not null or SYS_EXTRACT_UTC("SAVTIME") is not null
0cn2wm9d7zq8dSELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_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 = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
130dvvr5s8bgnselect obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
235a9tfrp53ysselect /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("CIKEY"), count(distinct "CIKEY"), count("CI_PARTITION_DATE"), count(distinct "CI_PARTITION_DATE") from "ORABPEL"."AUDIT_TRAIL" t where TBL$OR$IDX$PART$NUM("ORABPEL"."AUDIT_TRAIL", 0, 4, 0, "ROWID") = :objn
24b3xmp4wd3tudelete from sys.wri$_optstat_histgrm_history where savtime < :1
27xdav1rg5g14select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1) from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
31a13pnjps7j3 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(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.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(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
3kywng531fcxudelete from tab_stats$ where obj#=:1
3pphjhb4cv3jwINSERT INTO CUBE_SCOPE( CIKEY, DOMAIN_REF, SCOPE_BIN, CI_PARTITION_DATE ) VALUES ( :B1, :B2, '0', :B3 ) RETURNING SCOPE_BIN INTO :O0
4049pr0xgymgbselect /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("CIKEY"), count(distinct "CIKEY"), count("CI_PARTITION_DATE"), count(distinct "CI_PARTITION_DATE") from "ORABPEL"."AUDIT_TRAIL" sample ( 25.0000000000) t where TBL$OR$IDX$PART$NUM("ORABPEL"."AUDIT_TRAIL", 0, 4, 0, "ROWID") = :objn
435dczbfgs18yBEGIN INSERT INTO cube_scope( cikey, domain_ref, scope_bin, ci_partition_date ) VALUES ( :1, :2, '0', :3 ) RETURNING scope_bin INTO :4; END;
4u5fuanhvrjpuselect /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), sum(sys_op_opnsize("CIKEY")), substrb(dump(min("CIKEY"), 16, 0, 32), 1, 120), substrb(dump(max("CIKEY"), 16, 0, 32), 1, 120), count("DOMAIN_REF"), count(distinct "DOMAIN_REF"), sum(sys_op_opnsize("DOMAIN_REF")), substrb(dump(min("DOMAIN_REF"), 16, 0, 32), 1, 120), substrb(dump(max("DOMAIN_REF"), 16, 0, 32), 1, 120), count("MODIFY_DATE"), count(distinct "MODIFY_DATE"), substrb(dump(min("MODIFY_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("MODIFY_DATE"), 16, 0, 32), 1, 120), count(case when "SCOPE_BIN" is null then null else 1 end), sum(sys_op_opnsize("SCOPE_BIN")), count("CI_PARTITION_DATE"), count(distinct "CI_PARTITION_DATE"), substrb(dump(min("CI_PARTITION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CI_PARTITION_DATE"), 16, 0, 32), 1, 120) from "ORABPEL"."CUBE_SCOPE" sample ( .6402183185) t where TBL$OR$IDX$PART$NUM("ORABPEL"."CUBE_SCOPE", 0, 4, 0, "ROWID") = :objn
4y1y43113gv8fdelete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
6dr2b3qpsr392 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "ORABPEL"."AUDIT_TRAIL" sample block ( 2.5397083399, 1) t where TBL$OR$IDX$PART$NUM("ORABPEL"."AUDIT_TRAIL", 0, 4, 0, "ROWID") = :objn
6g4su86aysa1zINSERT INTO cube_instance( cikey, domain_ref, process_id, revision_tag, creation_date, creator, modify_date, modifier, state, priority, title, status, stage, conversation_id, scope_revision, scope_csize, scope_usize, process_guid, process_type, metadata, root_id, parent_id, test_run_id, at_count_id, at_event_id, at_detail_id ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26 )
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
76natvnhtqqhwINSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
78m9ryygp65v5SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
7cq8d0jqxzum1delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8a1pvy4cy8hgvinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue) values(:1, :2, :3, :4, :5, :6, :7)
8hd36umbhpgszselect parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9qgtwh66xg6nzupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
akh9zqqkx3wj7select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
b5cr4hhndmbufupdate tab$ set ts#=:2, file#=:3, block#=:4, bobj#=decode(:5, 0, null, :5), tab#=decode(:6, 0, null, :6), intcols=:7, kernelcols=:8, clucols=decode(:9, 0, null, :9), audit$=:10, flags=:11, pctfree$=:12, pctused$=:13, initrans=:14, maxtrans=:15, rowcnt=:16, blkcnt=:17, empcnt=:18, avgspc=:19, chncnt=:20, avgrln=:21, analyzetime=:22, samplesize=:23, cols=:24, property=:25, degree=decode(:26, 1, null, :26), instances=decode(:27, 1, null, :27), dataobj#=:28, avgspc_flb=:29, flbcnt=:30, trigflag=:31, spare1=:32, spare2=decode(:33, 0, null, :33), spare4=:34, spare6=:35 where obj#=:1
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
bd502nbh9abbsselect s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bhknx5mjxg6y1 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "ORABPEL"."AUDIT_DETAILS" t where TBL$OR$IDX$PART$NUM("ORABPEL"."AUDIT_DETAILS", 0, 4, 0, "ROWID") = :objn
bhvyz9bgyrhb2SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
btrbwhdzccc68select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("CIKEY"), count(distinct "CIKEY"), count("LOG"), count(distinct "LOG"), count("CI_PARTITION_DATE"), count(distinct "CI_PARTITION_DATE") from "ORABPEL"."AUDIT_TRAIL" sample ( 3.3084784153) t where TBL$OR$IDX$PART$NUM("ORABPEL"."AUDIT_TRAIL", 0, 4, 0, "ROWID") = :objn
cbdfcfcp1pgtpselect intcol#, col# , type#, spare1, segcol#, charsetform from partcol$ where obj# = :1 order by pos#
ctkp25m7h5wgyselect /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("MODIFY_DATE"), count(distinct "MODIFY_DATE"), substrb(dump(min("MODIFY_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("MODIFY_DATE"), 16, 0, 32), 1, 120), count("CI_PARTITION_DATE"), count(distinct "CI_PARTITION_DATE") from "ORABPEL"."CUBE_SCOPE" sample ( 6.4021831852) t where TBL$OR$IDX$PART$NUM("ORABPEL"."CUBE_SCOPE", 0, 4, 0, "ROWID") = :objn
cvhk2j2gymzhdSELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
cydgw456rs7z0insert into sys.wri$_optstat_histhead_history(obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp# from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
d4fx505x4f6yyINSERT INTO audit_trail( cikey, domain_ref, count_id, block, block_csize, block_usize, log, ci_partition_date ) VALUES( :1, :2, :3, :4, :5, :6, :7, :8 )
dv7aptbr6m6bnINSERT INTO audit_details ( cikey, domain_ref, detail_id, bin_csize, bin_usize, bin, ci_partition_date ) VALUES ( :1, :2, :3, :4, :5, :6, :7 )
ghdcby0n08nq3 select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("CREATOR"), count(distinct "CREATOR"), sum(sys_op_opnsize("CREATOR")), substrb(dump(min(substrb("CREATOR", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CREATOR", 1, 32)), 16, 0, 32), 1, 120), count("MODIFIER"), count(distinct "MODIFIER"), sum(sys_op_opnsize("MODIFIER")), substrb(dump(min(substrb("MODIFIER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MODIFIER", 1, 32)), 16, 0, 32), 1, 120), count("STAGE"), count(distinct "STAGE"), sum(sys_op_opnsize("STAGE")), substrb(dump(min(substrb("STAGE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("STAGE", 1, 32)), 16, 0, 32), 1, 120), count("ROOT_ID"), count(distinct "ROOT_ID"), count("METADATA"), count(distinct "METADATA"), sum(sys_op_opnsize("METADATA")), substrb(dump(min(substrb("METADATA", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("METADATA", 1, 32)), 16, 0, 32), 1, 120), count("EXT_STRING1"), count(distinct "EXT_STRING1"), sum(sys_op_opnsize("EXT_STRING1")), substrb(dump(min(substrb("EXT_STRING1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("EXT_STRING1", 1, 32)), 16, 0, 32), 1, 120), count("EXT_STRING2"), count(distinct "EXT_STRING2"), sum(sys_op_opnsize("EXT_STRING2")), substrb(dump(min(substrb("EXT_STRING2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("EXT_STRING2", 1, 32)), 16, 0, 32), 1, 120), count("EXT_INT1" ), count(distinct "EXT_INT1"), sum(sys_op_opnsize("EXT_INT1")), substrb(dump(min("EXT_INT1"), 16, 0, 32), 1, 120), substrb(dump(max("EXT_INT1"), 16, 0, 32), 1, 120), count("TEST_RUN_ID"), count(distinct "TEST_RUN_ID"), sum(sys_op_opnsize("TEST_RUN_ID")), substrb(dump(min(substrb("TEST_RUN_ID", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TEST_RUN_ID", 1, 32)), 16, 0, 32), 1, 120) from "ORABPEL"."CUBE_INSTANCE" t where TBL$OR$IDX$PART$NUM("ORABPEL"."CUBE_INSTANCE", 0, 4, 0, "ROWID") = :objn
gsfnqdfcvy33qdelete from superobj$ where subobj# = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 275,084 76.15 377.34
CPU used when call started 1,547 0.43 2.12
CR blocks created 18,811 5.21 25.80
Cached Commit SCN referenced 15,161 4.20 20.80
Commit SCN cached 172 0.05 0.24
DB time 61,408 17.00 84.24
DBWR checkpoint buffers written 10,895 3.02 14.95
DBWR checkpoints 41 0.01 0.06
DBWR transaction table writes 81 0.02 0.11
DBWR undo block writes 5,897 1.63 8.09
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 482 0.13 0.66
IMU Redo allocation size 745,232 206.31 1,022.27
IMU commits 131 0.04 0.18
IMU contention 4 0.00 0.01
IMU ktichg flush 9 0.00 0.01
IMU pool not allocated 360 0.10 0.49
IMU recursive-transaction flush 0 0.00 0.00
IMU undo allocation size 785,440 217.44 1,077.42
IMU- failed to get a private strand 360 0.10 0.49
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 5,101 1.41 7.00
active txn count during cleanout 17,817 4.93 24.44
application wait time 5 0.00 0.01
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 11,502 3.18 15.78
branch node splits 0 0.00 0.00
buffer is not pinned count 439,893,261 121,779.71 603,420.11
buffer is pinned count 616,440 170.65 845.60
bytes received via SQL*Net from client 3,067,563 849.22 4,207.91
bytes sent via SQL*Net to client 813,480 225.20 1,115.88
calls to get snapshot scn: kcmgss 388,100 107.44 532.37
calls to kcmgas 79,738 22.07 109.38
calls to kcmgcs 1,073 0.30 1.47
change write time 908 0.25 1.25
cleanout - number of ktugct calls 19,208 5.32 26.35
cleanouts and rollbacks - consistent read gets 17,285 4.79 23.71
cleanouts only - consistent read gets 1,160 0.32 1.59
cluster key scan block gets 438,176,183 121,304.35 601,064.72
cluster key scans 48,885 13.53 67.06
commit batch/immediate performed 7 0.00 0.01
commit batch/immediate requested 7 0.00 0.01
commit cleanout failures: block lost 42 0.01 0.06
commit cleanout failures: buffer being written 2 0.00 0.00
commit cleanout failures: callback failure 342 0.09 0.47
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 12,814 3.55 17.58
commit cleanouts successfully completed 12,428 3.44 17.05
commit immediate performed 7 0.00 0.01
commit immediate requested 7 0.00 0.01
commit txn count during cleanout 1,929 0.53 2.65
concurrency wait time 35 0.01 0.05
consistent changes 1,371,128 379.58 1,880.83
consistent gets 443,107,574 122,669.55 607,829.32
consistent gets - examination 2,727,926 755.20 3,742.01
consistent gets direct 5,142 1.42 7.05
consistent gets from cache 443,102,430 122,668.13 607,822.26
current blocks converted for CR 1 0.00 0.00
cursor authentications 121 0.03 0.17
data blocks consistent reads - undo records applied 1,362,120 377.09 1,868.48
db block changes 525,314 145.43 720.60
db block gets 529,052 146.46 725.72
db block gets direct 9,824 2.72 13.48
db block gets from cache 519,227 143.74 712.25
deferred (CURRENT) block cleanout applications 5,320 1.47 7.30
dirty buffers inspected 2,918 0.81 4.00
enqueue conversions 925 0.26 1.27
enqueue releases 43,147 11.94 59.19
enqueue requests 43,164 11.95 59.21
enqueue timeouts 28 0.01 0.04
enqueue waits 23 0.01 0.03
exchange deadlocks 0 0.00 0.00
execute count 71,010 19.66 97.41
failed probes on index block reclamation 1 0.00 0.00
free buffer inspected 1,547,012 428.27 2,122.10
free buffer requested 1,570,059 434.65 2,153.72
heap block compress 14,578 4.04 20.00
hot buffers moved to head of LRU 4,359 1.21 5.98
immediate (CR) block cleanout applications 18,445 5.11 25.30
immediate (CURRENT) block cleanout applications 3,871 1.07 5.31
index crx upgrade (positioned) 2,298 0.64 3.15
index fast full scans (full) 827 0.23 1.13
index fetch by key 698,356 193.33 957.96
index scans kdiixs1 103,651 28.69 142.18
leaf node 90-10 splits 61 0.02 0.08
leaf node splits 235 0.07 0.32
lob reads 3,748 1.04 5.14
lob writes 6,566 1.82 9.01
lob writes unaligned 6,557 1.82 8.99
logons cumulative 48 0.01 0.07
messages received 5,306 1.47 7.28
messages sent 5,306 1.47 7.28
no buffer to keep pinned count 2 0.00 0.00
no work - consistent read gets 440,305,499 121,893.83 603,985.60
opened cursors cumulative 26,746 7.40 36.69
parse count (failures) 345 0.10 0.47
parse count (hard) 996 0.28 1.37
parse count (total) 13,804 3.82 18.94
parse time cpu 140 0.04 0.19
parse time elapsed 159 0.04 0.22
physical read IO requests 180,358 49.93 247.40
physical read bytes 12,687,695,872 3,512,451.78 17,404,246.74
physical read total IO requests 183,300 50.74 251.44
physical read total bytes 12,735,287,296 3,525,626.95 17,469,529.90
physical read total multi block requests 105,918 29.32 145.29
physical reads 1,548,791 428.77 2,124.54
physical reads cache 1,543,619 427.33 2,117.45
physical reads cache prefetch 1,368,488 378.85 1,877.21
physical reads direct 5,172 1.43 7.09
physical reads direct (lob) 5,141 1.42 7.05
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 8,366 2.32 11.48
physical write bytes 199,860,224 55,329.15 274,156.69
physical write total IO requests 14,759 4.09 20.25
physical write total bytes 370,981,888 102,702.34 508,891.48
physical write total multi block requests 4,848 1.34 6.65
physical writes 24,397 6.75 33.47
physical writes direct 9,854 2.73 13.52
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 9,421 2.61 12.92
physical writes from cache 14,543 4.03 19.95
physical writes non checkpoint 22,563 6.25 30.95
pinned buffers inspected 14 0.00 0.02
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 490,187 135.70 672.41
process last non-idle time 3,545 0.98 4.86
recovery blocks read 0 0.00 0.00
recursive calls 415,899 115.14 570.51
recursive cpu usage 8,614 2.38 11.82
redo blocks read for recovery 0 0.00 0.00
redo blocks written 97,891 27.10 134.28
redo buffer allocation retries 4 0.00 0.01
redo entries 271,627 75.20 372.60
redo log space requests 5 0.00 0.01
redo log space wait time 3 0.00 0.00
redo ordering marks 6,098 1.69 8.36
redo size 97,245,208 26,921.29 133,395.35
redo subscn max counts 9,931 2.75 13.62
redo synch time 29 0.01 0.04
redo synch writes 493 0.14 0.68
redo wastage 1,216,656 336.82 1,668.94
redo write time 136 0.04 0.19
redo writer latching time 0 0.00 0.00
redo writes 2,336 0.65 3.20
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 1,524 0.42 2.09
rows fetched via callback 98,905 27.38 135.67
session connect time 0 0.00 0.00
session cursor cache hits 35,572 9.85 48.80
session logical reads 443,636,746 122,816.05 608,555.21
session pga memory 7,908,104 2,189.27 10,847.88
session uga memory 17,179,568,040 4,755,978.15 23,565,936.95
session uga memory max 136,861,168 37,888.54 187,738.23
shared hash latch upgrades - no wait 29,595 8.19 40.60
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 9,213 2.55 12.64
sorts (rows) 15,450,946 4,277.43 21,194.71
sql area evicted 451 0.12 0.62
sql area purged 420 0.12 0.58
summed dirty queue length 3,366 0.93 4.62
switch current to new buffer 503 0.14 0.69
table fetch by rowid 638,638 176.80 876.05
table fetch continued row 176 0.05 0.24
table scan blocks gotten 1,133,581 313.82 1,554.98
table scan rows gotten 6,329,710 1,752.31 8,682.73
table scans (cache partitions) 0 0.00 0.00
table scans (long tables) 37 0.01 0.05
table scans (short tables) 4,877 1.35 6.69
total number of times SMON posted 3 0.00 0.00
transaction rollbacks 7 0.00 0.01
undo change vector size 48,504,872 13,428.05 66,536.18
user I/O wait time 6,584 1.82 9.03
user calls 6,839 1.89 9.38
user commits 728 0.20 1.00
user rollbacks 1 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 6,162 1.71 8.45
write clones created in background 0 0.00 0.00
write clones created in foreground 2 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 150,779 151,251
opened cursors current 150 77
logons current 32 31

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 1.99

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
ORABPEL 162,744 45 0.37 9.30 466 0 0 0.00
SYSAUX 11,580 3 0.30 2.08 2,361 1 0 0.00
USERS 8,533 2 0.06 1.00 2 0 0 0.00
SYSTEM 2,563 1 0.47 1.77 1,330 0 1 0.00
TEMP 281 0 0.04 15.25 3,341 1 0 0.00
UNDOTBS1 47 0 0.00 1.00 983 0 3 0.00
UNICOMDEV_DATA 2 0 0.00 1.00 2 0 0 0.00
UNICOMNODE_DATA 2 0 0.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
ORABPEL /soaapp/db/soadb1/orabpel.dbf 9,315 3 0.33 5.35 20 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel1.dbf 21,567 6 0.36 9.08 150 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel2.dbf 21,257 6 0.38 9.19 25 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel3.dbf 23,370 6 0.35 9.53 11 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel4.dbf 22,623 6 0.35 9.80 51 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel5.dbf 22,847 6 0.36 9.70 5 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel6.dbf 21,953 6 0.37 9.63 199 0 0 0.00
ORABPEL /soaapp/db/soadb1/orabpel7.dbf 19,812 5 0.45 9.80 5 0 0 0.00
SYSAUX /soaapp/db/soadb1/sysaux01.dbf 11,580 3 0.30 2.08 2,361 1 0 0.00
SYSTEM /soaapp/db/soadb1/system01.dbf 2,563 1 0.47 1.77 1,330 0 1 0.00
TEMP /soaapp/db/soadb1/temp01.dbf 281 0 0.04 15.25 3,341 1 0  
UNDOTBS1 /soaapp/db/soadb1/undotbs01.dbf 12 0 0.00 1.00 346 0 0 0.00
UNDOTBS1 /soaapp/db/soadb1/undotbs02.dbf 35 0 0.00 1.00 637 0 3 0.00
UNICOMDEV_DATA /soaapp/db/soadb1/UNICOMDEV_DATA01.DBF 2 0 0.00 1.00 2 0 0 0.00
UNICOMNODE_DATA /soaapp/db/soadb1/UNICOMNODE_DATA01.DBF 2 0 0.00 1.00 2 0 0 0.00
USERS /soaapp/db/soadb1/users01.dbf 8,533 2 0.06 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 91,034 100 443,614,595 1,545,858 14,543 0 0 4


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 8 584 7128 10171 92160 10171  
E 0 9 1726 8284 36671 92160 36671  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 64 0.09 7,916 5302.22 ###############
D 128 0.17 15,832 1.37 111,143,749
D 192 0.26 23,748 1.03 84,035,342
D 256 0.35 31,664 1.03 83,361,135
D 320 0.43 39,580 1.02 82,896,306
D 384 0.52 47,496 1.02 82,520,373
D 448 0.61 55,412 1.01 82,301,759
D 512 0.70 63,328 1.01 82,110,277
D 576 0.78 71,244 1.01 81,870,345
D 640 0.87 79,160 1.01 81,694,291
D 704 0.96 87,076 1.00 81,297,808
D 736 1.00 91,034 1.00 81,198,439
D 768 1.04 94,992 1.00 81,098,771
D 832 1.13 102,908 1.00 80,884,682
D 896 1.22 110,824 0.99 80,711,750
D 960 1.30 118,740 0.99 80,517,314
D 1,024 1.39 126,656 0.99 80,288,564
D 1,088 1.48 134,572 0.98 79,902,702
D 1,152 1.57 142,488 0.98 79,536,438
D 1,216 1.65 150,404 0.97 79,067,999
D 1,280 1.74 158,320 0.96 78,259,606

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 512 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 6,540 5,857 85.75 0.00 0.00 0.00 0.00 669,690
E 6,540 5,857 75.42 0.00 0.00 0.00 0.00 669,690

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 5,880 5,880 0 0
64K 128K 39 39 0 0
128K 256K 44 44 0 0
256K 512K 27 27 0 0
512K 1024K 108 108 0 0
1M 2M 35 35 0 0
2M 4M 24 24 0 0
4M 8M 2 2 0 0
8M 16M 2 2 0 0
32M 64M 2 2 0 0
64M 128M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
818 0.13 33,511.98 2,337.36 93.00 0
1,635 0.25 33,511.98 2,337.36 93.00 0
3,270 0.50 33,511.98 2,337.36 93.00 0
4,905 0.75 33,511.98 2,337.36 93.00 0
6,540 1.00 33,511.98 2,337.36 93.00 0
7,848 1.20 33,511.98 1,800.23 95.00 0
9,156 1.40 33,511.98 1,800.23 95.00 0
10,464 1.60 33,511.98 1,800.23 95.00 0
11,772 1.80 33,511.98 1,800.23 95.00 0
13,080 2.00 33,511.98 1,800.23 95.00 0
19,620 3.00 33,511.98 1,800.23 95.00 0
26,160 4.00 33,511.98 1,800.23 95.00 0
39,240 6.00 33,511.98 1,800.23 95.00 0
52,320 8.00 33,511.98 1,800.23 95.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
416 0.57 89 6,168 468,298 0.88 61,981 181.76 47,120,297
496 0.67 166 12,335 506,558 0.96 23,721 69.56 47,130,497
576 0.78 245 19,810 525,797 0.99 4,482 13.14 47,135,716
656 0.89 324 28,845 529,572 1.00 707 2.07 47,136,959
736 1.00 403 37,941 529,938 1.00 341 1.00 47,137,157
816 1.11 416 39,325 529,938 1.00 341 1.00 47,137,176
896 1.22 416 39,325 529,938 1.00 341 1.00 47,137,176
976 1.33 416 39,325 529,938 1.00 341 1.00 47,137,176
1,056 1.43 416 39,325 529,938 1.00 341 1.00 47,137,176
1,136 1.54 416 39,325 529,938 1.00 341 1.00 47,137,176
1,216 1.65 416 39,325 529,938 1.00 341 1.00 47,137,176
1,296 1.76 416 39,325 529,938 1.00 341 1.00 47,137,176
1,376 1.87 416 39,325 529,938 1.00 341 1.00 47,137,176
1,456 1.98 416 39,325 529,938 1.00 341 1.00 47,137,176
1,536 2.09 416 39,325 529,938 1.00 341 1.00 47,137,176

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
768 0.50 26,302 111,282,402
1,152 0.75 18,537 83,001,000
1,536 1.00 18,306 81,198,396
1,920 1.25 18,106 79,631,267
2,304 1.50 17,942 78,356,452
2,688 1.75 17,942 78,356,452
3,072 2.00 17,942 78,356,452

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)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo block 3 0 0
data block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse) 351 351 0 23 0 0.09

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 7.00 2,074 337 4 5760/5760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
13-Dec 23:09 1,627 188 0 4 5,760 0/0 0/0/0/0/0/0
13-Dec 22:59 1,354 123 0 3 5,760 0/0 0/0/0/0/0/0
13-Dec 22:49 1,484 104 0 3 5,760 0/0 0/0/0/0/0/0
13-Dec 22:39 40 168 0 3 5,760 0/0 0/0/0/0/0/0
13-Dec 22:29 1 172 0 1 5,760 0/0 0/0/0/0/0/0
13-Dec 22:19 1,712 698 337 3 5,760 0/0 0/0/0/0/0/0
13-Dec 22:09 786 621 0 3 5,760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,589 0.00   0 0  
AWR Alerted Metric Element list 13,595 0.00   0 0  
Consistent RBA 2,345 0.00   0 0  
FOB s.o list latch 136 0.00   0 0  
In memory undo latch 3,891 0.00   0 1,493 0.00
JS mem alloc latch 12 0.00   0 0  
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 26,026 0.00   0 0  
JS slv state obj latch 30 0.00   0 0  
KMG MMAN ready and startup request latch 1,200 0.00   0 0  
KTF sga latch 3 0.00   0 1,134 0.00
KWQMN job cache list latch 1 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,200 0.00
OS process 171 0.00   0 0  
OS process allocation 1,313 0.00   0 0  
OS process: request allocation 89 0.00   0 0  
PL/SQL warning settings 1,072 0.00   0 0  
SGA IO buffer pool latch 106,030 0.00 0.00 0 106,030 0.00
SQL memory manager latch 1 0.00   0 1,200 0.00
SQL memory manager workarea list latch 167,943 0.00   0 0  
Shared B-Tree 132 0.00   0 0  
active checkpoint queue latch 4,817 0.00   0 0  
active service list 7,430 0.00   0 1,218 0.00
archive control 11 0.00   0 0  
begin backup scn array 69 0.00   0 0  
cache buffer handles 3,870 0.00   0 0  
cache buffers chains 889,934,140 0.00 0.01 0 3,206,326 0.00
cache buffers lru chain 37,548 0.23 0.00 0 2,902,933 0.00
cache table scan latch 0     0 105,925 0.00
channel handle pool latch 169 0.00   0 0  
channel operations parent latch 18,316 0.00   0 0  
checkpoint queue latch 150,501 0.00   0 15,420 0.00
client/application info 269 0.00   0 0  
commit callback allocation 80 0.00   0 0  
compile environment latch 48 0.00   0 0  
dictionary lookup 110 0.00   0 0  
dml lock allocation 13,859 0.00   0 0  
dummy allocation 97 0.00   0 0  
enqueue hash chains 87,317 0.00 0.00 0 0  
enqueues 68,256 0.00 0.00 0 0  
event group latch 44 0.00   0 0  
file cache latch 365 0.00   0 0  
global KZLD latch for mem in SGA 35 0.00   0 0  
hash table column usage latch 55 0.00   0 5,094 0.00
hash table modification latch 51 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 62 0.00   0 0  
kks stats 3,141 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 41 0.00   0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 7 0.00   0 0  
kwqbsn:qsga 131 0.00   0 0  
lgwr LWN SCN 3,006 0.00   0 0  
library cache 130,730 0.00   0 1,089 0.00
library cache load lock 1,624 0.00   0 0  
library cache lock 61,495 0.00   0 66 0.00
library cache lock allocation 646 0.00   0 0  
library cache pin 27,305 0.00   0 0  
library cache pin allocation 123 0.00   0 0  
list of block allocation 394 0.00   0 0  
loader state object freelist 17,338 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 79 0.00   0 102 0.00
message pool operations parent latch 237 0.00   0 0  
messages 36,347 0.02 0.14 0 0  
mostly latch-free SCN 3,007 0.03 0.00 0 0  
multiblock read objects 221,714 0.00   0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 20,363 0.00   0 1,987 0.00
object queue header operation 3,181,122 0.00 0.00 0 0  
object stats modification 127 0.00   0 0  
parallel query alloc buffer 480 0.00   0 0  
parameter list 110 0.00   0 0  
parameter table allocation management 66 0.00   0 0  
post/wait queue 841 0.00   0 537 0.00
process allocation 89 0.00   0 44 0.00
process group creation 89 0.00   0 0  
qmn task queue latch 516 25.00 1.00 0 0  
redo allocation 12,583 0.02 1.00 0 272,441 0.00
redo copy 0     0 272,464 0.02
redo writing 14,116 0.01 0.00 0 0  
resmgr group change latch 61 0.00   0 0  
resmgr:active threads 90 0.00   0 0  
resmgr:actses change group 40 0.00   0 0  
resmgr:free threads list 89 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 407,686 0.00   0 0  
rules engine rule set statistics 100 0.00   0 0  
sequence cache 572 0.00   0 0  
session allocation 298,146 0.02 0.00 0 0  
session idle bit 14,490 0.00   0 0  
session state list latch 153 0.00   0 0  
session switching 58 0.00   0 0  
session timer 1,218 0.00   0 0  
shared pool 292,417 0.00 0.00 0 0  
shared pool sim alloc 32 0.00   0 0  
shared pool simulator 60,779 0.00   0 0  
simulator hash latch 27,997,405 0.00 0.00 0 0  
simulator lru latch 14,940 0.27 0.02 0 27,850,543 0.01
slave class 4 0.00   0 0  
slave class create 16 6.25 1.00 0 0  
sort extent pool 261 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 2 0.00   0 0  
threshold alerts latch 180 0.00   0 0  
transaction allocation 130,950 0.00   0 0  
transaction branch allocation 1,218 0.00   0 0  
undo global data 53,085 0.00   0 0  
user lock 140 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 889,934,140 752 4 748 0 0 0
qmn task queue latch 516 129 129 0 0 0 0
simulator lru latch 14,940 41 1 40 0 0 0
messages 36,347 7 1 6 0 0 0
redo allocation 12,583 2 2 0 0 0 0
slave class create 16 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbzib: multi-block read: nowait 0 5 0
cache buffers chains kcbgtcr: kslbegin excl 0 4 7
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 1
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers chains kcbrls: kslbegin 0 1 4
event range base latch No latch 0 129 129
messages ksaamb: after wakeup 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 2 0
simulator lru latch kcbs_simulate: simulate set 0 1 0
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYS SYSTEM SMON_SCN_TIME   TABLE 438,764,896 98.90
ORABPEL ORABPEL AUDIT_TRAIL TRAIL_1312 TABLE PARTITION 882,224 0.20
SYS SYSTEM SMON_SCN_TIME_SCN_IDX   INDEX 558,944 0.13
SYS SYSTEM SMON_SCN_TIME_TIM_IDX   INDEX 531,248 0.12
SYS SYSTEM OBJ$   TABLE 166,880 0.04

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ORABPEL ORABPEL AUDIT_TRAIL TRAIL_1312 TABLE PARTITION 1,326,440 85.64
ORABPEL ORABPEL CUBE_SCOPE SCOPE_1312 TABLE PARTITION 85,963 5.55
ORABPEL ORABPEL CUBE_INSTANCE TANCE_1312 TABLE PARTITION 29,649 1.91
ORABPEL ORABPEL AUDIT_DETAILS TAILS_1312 TABLE PARTITION 18,583 1.20
ORABPEL ORABPEL AT_FK   INDEX 4,493 0.29

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSTEM HISTGRM$   TABLE 3 100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM SMON_SCN_TIME   TABLE 1 100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 113 0.00 0   4 1
dc_constraints 171 33.33 0   171 1
dc_database_links 75 0.00 0   0 1
dc_files 165 0.00 0   0 15
dc_global_oids 215 1.86 0   0 173
dc_histogram_data 6,246 34.12 0   2,445 67,614
dc_histogram_defs 9,826 36.32 0   1,358 5,049
dc_object_grants 931 6.12 0   0 275
dc_object_ids 7,457 1.26 0   74 2,303
dc_objects 4,745 7.86 0   305 1,946
dc_profiles 41 0.00 0   0 1
dc_rollback_segments 4,551 0.00 0   0 272
dc_segments 4,240 0.92 0   250 1,690
dc_sequences 22 0.00 0   22 10
dc_table_scns 14 100.00 0   0 0
dc_tablespaces 45,256 0.00 0   0 11
dc_usernames 530 0.19 0   0 60
dc_users 49,314 0.00 0   0 92
outstanding_alerts 54 0.00 0   0 9


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 79 5.06 796 0.25 0 0
CLUSTER 18 0.00 34 0.00 0 0
INDEX 155 49.03 1,139 10.71 1 0
SQL AREA 7,487 7.89 81,971 2.95 643 471
TABLE/PROCEDURE 1,207 7.13 8,028 8.72 297 0
TRIGGER 524 0.00 758 0.00 0 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 63.65   1.87 3.99 22 301 34 34
  Freeable 20.81 0.00 1.30 1.07 5   16 16
  SQL 0.74 0.44 0.03 0.06 0 7 25 17
  PL/SQL 0.56 0.39 0.02 0.04 0 0 32 32
E Other 57.14   1.73 3.91 22 23 33 33
  Freeable 17.44 0.00 1.25 1.15 5   14 14
  SQL 0.53 0.28 0.02 0.04 0 4 25 19
  PL/SQL 0.32 0.24 0.01 0.01 0 0 31 31

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 771,751,936  
Fixed Size 2,056,504  
Redo Buffers 14,716,928  
Variable Size 822,087,368  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor 32.29 33.09 2.50
shared FileOpenBlock 11.83 11.83 0.00
shared Heap0: KGL 10.07 10.31 2.37
shared KQR M SO 29.75 30.84 3.69
shared KTI-UNDO 24.38 24.38 0.00
shared PCursor 12.10 12.31 1.72
shared VIRTUAL CIRCUITS 7.36 7.36 0.00
shared XDB Schema Cac 9.09 9.09 0.00
shared event statistics per sess 29.25 29.25 0.00
shared free memory 215.21 208.19 -3.26
shared library cache 19.59 20.05 2.32
shared private strands 46.08 46.08 0.00
shared sessions 17.30 17.30 0.00
shared sql area 124.72 128.12 2.73
shared transaction 7.68 7.68 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 736.00 736.00 0.00
  fixed_sga 1.96 1.96 0.00
  log_buffer 14.04 14.04 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 139,844 0 0
QMON Slaves 27,033 0 0

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 Apply

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 Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /soaapp/db/product/admin/soadb1/adump   
background_dump_dest /soaapp/db/product/admin/soadb1/bdump   
compatible 10.2.0.3.0   
control_files /soaapp/db/soadb1/control01.ctl, /soaapp/db/soadb1/control02.ctl, /soaapp/db/soadb1/control03.ctl   
core_dump_dest /soaapp/db/product/admin/soadb1/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name soadb1   
db_recovery_file_dest /soaapp/db/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=soadb1XDB)   
job_queue_processes 10   
local_listener LISTENER_SOADB   
open_cursors 300   
pga_aggregate_target 6857687040   
processes 3000   
remote_login_passwordfile EXCLUSIVE   
sessions 3305   
sga_target 1610612736   
undo_management AUTO   
undo_retention 1800   
undo_tablespace UNDOTBS1   
user_dump_dest /soaapp/db/product/admin/soadb1/udump   
utl_file_dir /usr/tmp/soadb   


Back to Top

End of Report soadb@husoaa04[/export/home/oracledb/oracle]ll total 1776 -rw-r--r-- 1 soadb oinstall 253934 Sep 7 23:33 121-awrrpt_1_22655_22656.html -rw-r--r-- 1 soadb oinstall 257912 Dec 13 23:14 awrrpt_1_24997_24998.html -rw-r--r-- 1 soadb oinstall 239365 Dec 13 23:14 awrrpt_1_24998_24999.html -rw-r--r-- 1 soadb oinstall 82 Mar 20 2013 bdumpdirtmp.log drwxr-xr-x 4 soadb oinstall 8192 Dec 5 09:26 check -rw-r--r-- 1 soadb oinstall 443 Nov 6 2010 listener.ora -rw-r--r-- 1 soadb oinstall 64831 Nov 6 2012 ora_info.log -rw-r--r-- 1 soadb oinstall 43838 Nov 6 2012 ora_info.sh -rw-r--r-- 1 soadb oinstall 777 Nov 6 2010 tnsnames.ora -rw-r--r-- 1 soadb oinstall 0 Nov 6 2012 x