WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORA11G4172642243ora11g128-Aug-12 03:0811.1.0.7.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
sdu1Linux x86 64-bit 4 4 1 15.60

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:905511-Mar-13 22:00:2073 6.9
End Snap:905611-Mar-13 23:00:2270 6.4
Elapsed:  60.03 (mins)  
DB Time:  11.28 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 2,112M 2,112MStd Block Size: 8K
Shared Pool Size: 2,064M 2,064MLog Buffer: 10,444K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.2 1.5 0.00 0.00
DB CPU(s): 0.1 0.6 0.00 0.00
Redo size: 10,660.9 82,227.4  
Logical reads: 1,409.2 10,869.5  
Block changes: 273.7 2,111.3  
Physical reads: 5.0 38.3  
Physical writes: 1.6 12.5  
User calls: 143.3 1,105.0  
Parses: 45.6 351.6  
Hard parses: 17.8 136.9  
W/A MB processed: 151,546.1 1,168,879.6  
Logons: 0.8 6.1  
Executes: 97.6 752.4  
Rollbacks: 0.0 0.0  
Transactions: 0.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.65In-memory Sort %: 100.00
Library Hit %: 73.80Soft Parse %: 61.07
Execute to Parse %: 53.27Latch Hit %: 99.78
Parse CPU to Parse Elapsd %: 0.00% Non-Parse CPU: 82.50

Shared Pool Statistics

BeginEnd
Memory Usage %: 83.44 86.61
% SQL with executions>1: 78.33 74.77
% Memory for SQL w/exec>1: 78.98 75.69

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 278 41.04 
row cache lock87130148919.13Concurrency
db file sequential read17,2135938.76User I/O
library cache lock221102973.04Concurrency
control file sequential read29,980700.98System I/O

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

Load Average BeginLoad Average End%User%System%WIO%Idle
2.05 1.50 5.8 8.6 1.9 85.5
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
2.0 13.8 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 15,974.4 15,974.4
SGA use (MB): 5,200.0 5,200.0
PGA use (MB): 331.6 257.5
% Host Mem used for SGA+PGA: 34.63 34.63

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time411.1760.73
parse time elapsed290.1042.85
DB CPU277.8741.04
hard parse elapsed time264.0739.00
PL/SQL execution elapsed time173.2225.58
failed parse elapsed time80.5711.90
connection management call elapsed time17.172.54
hard parse (sharing criteria) elapsed time12.381.83
PL/SQL compilation elapsed time0.570.08
repeated bind elapsed time0.170.03
Java execution elapsed time0.070.01
hard parse (bind mismatch) elapsed time0.030.00
sequence load elapsed time0.010.00
DB time677.08 
background elapsed time25.04 
background cpu time8.51 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME207,902 
IDLE_TIME1,226,879 
IOWAIT_TIME26,970 
NICE_TIME9 
SYS_TIME123,359 
USER_TIME82,884 
LOAD22
RSRC_MGR_CPU_WAIT_TIME0 
PHYSICAL_MEMORY_BYTES16,750,383,104 
NUM_CPUS4 
NUM_CPU_CORES4 
NUM_CPU_SOCKETS1 
GLOBAL_RECEIVE_SIZE_MAX8,388,608 
GLOBAL_SEND_SIZE_MAX8,388,608 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX174,760 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX131,072 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
11-Mar 22:00:202.05     
11-Mar 23:00:221.5014.495.788.601.8885.51

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  278 41.04
Concurrency2,970421575323.12
User I/O17,36606138.94
System I/O29,9800700.98
Network370,3490100.13
Commit6010010.06
Other10646010.01
Scheduler480010.01
Application0 0 0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
row cache lock87113014890.1919.13
db file sequential read17,213059336.868.76
library cache lock2021102970.003.04
control file sequential read29,98007064.200.98
library cache: mutex X1,235100542.640.67
latch: shared pool1,5930113.410.19
db file scattered read1360180.290.16
SQL*Net message to client370,349010793.040.13
log file sync6010011.290.06
latch: row cache objects3200110.070.05
resmgr:internal state change3670680.010.03
direct path write1001030.000.02
cursor: pin S49100010.100.01
resmgr:cpu quantum480010.100.01
direct path write temp160020.030.00
latch: session allocation380000.080.00
latch free170000.040.00
latch: cache buffers chains140000.030.00
SQL*Net message from client370,329037,417101793.00 
jobq slave wait752992,23829761.61 
auto-sqltune: wait graph update21001050000.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
library cache lock10443120.0017.22
os thread startup8404420.1813.98
log file parallel write3,0670216.576.35
control file sequential read4,5450109.734.76
control file parallel write1,3170112.824.01
db file parallel write2,1870104.682.21
SQL*Net break/reset to client3,3720007.221.17
latch: shared pool2000110.040.86
db file sequential read120060.030.29
SQL*Net message to client9,26800019.850.09
latch free100130.000.05
library cache: mutex X13,5631000029.040.05
LGWR wait for redo copy460000.100.01
log file sync10020.000.01
direct path write50000.010.01
rdbms ipc message17,0478253,818315736.50 
DIAG idle wait7,1641007,165100015.34 
fbar timer121003,6003000080.03 
Space Manager: slave idle wait720993,58649811.54 
Streams AQ: qmn coordinator idle wait256503,585140020.55 
Streams AQ: qmn slave idle wait13003,585275740.28 
pmon timer1,253953,58228592.68 
shared server idle wait1191003,570300030.25 
dispatcher timer591003,540600050.13 
smon timer111003,3003000070.02 
JOX Jit Process Sleep12928974180.03 
SQL*Net message from client9,26806119.85 
class slave wait90000.02 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
LGWR wait for redo copy46100.0       
SQL*Net break/reset to client337299.3.5.2 .1   
SQL*Net message to client379K100.0.0.0     
control file parallel write131891.13.74.5.7    
control file sequential read34K98.8.6.6.1.0   
cursor: mutex X4100.0       
cursor: pin S4971.42.018.48.2    
db file parallel write218794.44.9.6   .0 
db file scattered read1363.76.6 45.644.1   
db file sequential read17K62.2.3.316.919.8.3.1 
direct path write683.3     16.7 
direct path write temp1631.318.850.0     
latch free1888.95.6  5.6   
latch: cache buffer handles1100.0       
latch: cache buffers chains1492.97.1      
latch: enqueue hash chains1100.0       
latch: row cache objects3240.618.86.3  34.4  
latch: session allocation38100.0       
latch: shared pool161291.52.52.4.61.21.5.2 
library cache lock4       100.0
library cache: mutex X14K98.7.2.5.2.1.1.2 
log file parallel write306789.94.54.8.8.0 .0 
log file sync60281.411.16.1.8.5   
os thread startup84   1.2 84.514.3 
resmgr:cpu quantum4860.427.112.5     
resmgr:internal state change333.3     66.7 
row cache lock8739.131.03.41.1   25.3
DIAG idle wait7163      100.0 
JOX Jit Process Sleep128.3      91.7
SQL*Net message from client379K22.51.714.316.519.912.012.3.7
Space Manager: slave idle wait720.3      99.7
Streams AQ: qmn coordinator idle wait25648.4.41.2    50.0
Streams AQ: qmn slave idle wait1301.5      98.5
auto-sqltune: wait graph update2       100.0
class slave wait988.911.1      
dispatcher timer59       100.0
fbar timer12       100.0
jobq slave wait752      .999.1
pmon timer12534.7      95.3
rdbms ipc message17K3.3.3.3.4.91.030.063.7
shared server idle wait119       100.0
smon timer11       100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS358119163,432
ora11g32215921,606
SYS$BACKGROUND00038
ora11gXDB0000

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 1578860105210092130
ora11g 157812862136003611301
SYS$BACKGROUND 1701366180000

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
461133.566.838szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
9463,7090.001.29du3npcpzq82sp SDU@sdu1 (TNS V1-V3) select sSubscriberID, sSubscri...
821,6870.001.1859d21tvx4xn3q   update user$ set name=:2, pass...
88120.651.1559p216atzcyfh amosperf@sdu1 (TNS V1-V3) select sql_text from (select s...
88120.631.113uhm3u5jynbak amosperf@sdu1 (TNS V1-V3) select sql_text from (select s...
87120.631.11byzbk6f5n4upz amosperf@sdu1 (TNS V1-V3) select sql_text from (select s...
7216.530.966ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
6032.040.90bph1a3spdtg6g SDU@sdu1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
6051.220.908wyymnrxrudgd SDU@sdu1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
6023.050.902y7qjmt522cxk SDU@sdu1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
88120.652.801.1559p216atzcyfh amosperf@sdu1 (TNS V1-V3) select sql_text from (select s...
88120.632.711.113uhm3u5jynbak amosperf@sdu1 (TNS V1-V3) select sql_text from (select s...
78120.622.691.11byzbk6f5n4upz amosperf@sdu1 (TNS V1-V3) select sql_text from (select s...
551060.041.710.71c0j6cx9kzjf7g DBMS_SCHEDULER SELECT EXTRACTVALUE(VALUE(T), ...
4963,7090.001.531.29du3npcpzq82sp SDU@sdu1 (TNS V1-V3) select sSubscriberID, sSubscri...
333,2720.001.010.4343ruajmwv9fus   insert into histgrm$(obj#, int...
33120.220.960.40d98d5kh4u6ufx amosperf@sdu1 (TNS V1-V3) select o.sid, o.user_name, o...
231,3470.000.890.384y1y43113gv8f   delete from histgrm$ where obj...
2363,7130.000.740.5012kbqx41uwvdn SDU@sdu1 (TNS V1-V3) select sSubscriberID, sSubscri...
2711.940.700.966ajkhukk78nsr   begin prvt_hdm.auto_execute( :...

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
828,65063,70913.0116.324.258.72du3npcpzq82sp SDU@sdu1 (TNS V1-V3) select sSubscriberID, sSubscri...
254,86063,7134.005.022.043.3612kbqx41uwvdn SDU@sdu1 (TNS V1-V3) select sSubscriberID, sSubscri...
136,6643,27241.772.692.802.8943ruajmwv9fus   insert into histgrm$(obj#, int...
121,9301,58676.882.400.410.46cvhk2j2gymzhd DBMS_SCHEDULER SELECT SU.NAME, SO.NAME, A.S...
90,8521,34767.451.792.482.574y1y43113gv8f   delete from histgrm$ where obj...
67,65122,3263.031.330.961.237br6xgmpmhukc SDU@sdu1 (TNS V1-V3) Select sScreenNumber, sScreenT...
34,529132,656.080.680.9346.228szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
16,8071,57310.680.330.110.38d0xmnp08rhfbg   insert into sys.wri$_optstat_h...
14,48040236.020.290.330.8063kf3an2j0pkc   insert into sys.wri$_optstat_h...
13,2374,6562.840.260.140.1696g93hntrzjtr   select /*+ rule */ bucket_cnt,...

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
14,006131,077.3878.290.9346.228szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
7321261.004.090.280.370u3a2gth3r9vw amosperf@sdu1 (TNS V1-V3) select sum(bytes)/1024 from DB...
7321261.004.090.280.4147fh8q7arykp9 amosperf@sdu1 (TNS V1-V3) select tablespace_name , sum(...
484020.120.270.330.8063kf3an2j0pkc   insert into sys.wri$_optstat_h...
131,5730.010.070.110.38d0xmnp08rhfbg   insert into sys.wri$_optstat_h...
12121.000.070.020.618xgd2r1h0kr34 DBMS_SCHEDULER insert into wri$_adv_sqlt_plan...
824.000.040.000.06dckagq5arxva5 SDU@sdu1 (TNS V1-V3) delete from t_bme...
623.000.030.010.056s2jxg0nq736d SDU@sdu1 (TNS V1-V3) delete from F2...
5110.450.030.010.086kqztxmbnwzht SDU@sdu1 (TNS V1-V3) update F1 ...
422.000.020.010.035ungsgg5wj7cd TOTO@TOTO1 (TNS V1-V3) delete from R...

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
63,71363,7171.000.000.0012kbqx41uwvdn TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
63,70963,7181.000.000.00du3npcpzq82sp TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
22,3265900.030.000.007br6xgmpmhukc TOTO@TOTO1 (TNS V1-V3) Select sScreenNumber, sScreenT...
4,6563,7590.810.000.0096g93hntrzjtr   select /*+ rule */ bucket_cnt,...
3,5663,5661.000.000.00a5ks9fhw2v9s1 TOTO@TOTO1 (TNS V1-V3) select * from dual
3,27222,2396.800.000.0043ruajmwv9fus   insert into histgrm$(obj#, int...
3,21151,02815.890.000.00db78fxqxwxt7r   select /*+ rule */ bucket, en...
1,9571,9571.000.000.009tgj4g8y4rwy8   select type#, blocks, extents,...
1,68700.000.000.003972rvxu3knn3 TOTO@TOTO1 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
1,6871,6871.000.000.0059d21tvx4xn3q   update user$ set name=:2, pass...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
3,5663,5662.17a5ks9fhw2v9s1 TOTO@TOTO1 (TNS V1-V3) select * from dual
1,9571,9571.199tgj4g8y4rwy8   select type#, blocks, extents,...
1,6871,6871.033972rvxu3knn3 TOTO@TOTO1 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
1,6871,6871.0359d21tvx4xn3q   update user$ set name=:2, pass...
1,6871,6871.03a6u3yjca29nqc TOTO@TOTO1 (TNS V1-V3) declare m_stmt varchar2(512...
1,0561,0560.640ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
1,0561,0560.64459f3z9u4fb3u   select value$ from props$ wher...
8958950.55520mkxqpf15q8 TOTO@TOTO1 (TNS V1-V3) select 1 from dual
7167160.440khbp2znt4394 sqlplus@TOTO1 (TNS V1-V3) select tablespace_name, statu...
7167160.446v3dub2363sa5 sqlplus@TOTO1 (TNS V1-V3) select name, open_mode from v...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
15,365,33020.71803u6vwz0ah1p   select OBJOID, CLSOID, RUNT...
3,289,400100.15bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DE...
2,274,577110.116kqztxmbnwzht TOTO@TOTO1 (TNS V1-V3) update F1 ...
2,127,429120.10g278wv0zzpn5j   select unique objn from ((sele...
2,127,364120.1099xa2xfxq7xmc amosperf@TOTO1 (TNS V1-V3) select * from (select event, ...
2,099,70050.107bdgxpmaqxx89 TOTO@TOTO1 (TNS V1-V3) update F1 ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
2,16400v3dvmc22qnam   insert into sys.col_usage$ (ob...
302101gfaj4z5hn1kf   delete from dependency$ where ...
297697ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
297697ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
247331gu8t96d0bdmu   select t.ts#, t.file#, t.block...
221,9579tgj4g8y4rwy8   select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0khbp2znt4394select tablespace_name, status from dba_tablespaces
0u3a2gth3r9vwselect sum(bytes)/1024 from DBA_FREE_SPACE
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
12kbqx41uwvdnselect sSubscriberID, sSubscriberNumber, sMainType, sUserType, sUserSort , sUserState, sServiceActiveFlag, sActiveRoute, sActiveType, nSingleMain , sBarringFlag, sFeeType, sChargeAccount, sSameCallFlag from F1 WHERE sSubscriberID=:sSubscriberID
1gfaj4z5hn1kfdelete from dependency$ where d_obj#=: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# (+)
2y7qjmt522cxkselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960645348'
3972rvxu3knn3delete from sdo_geor_ddl__table$$
3uhm3u5jynbakselect sql_text from (select sql_text from v$sqlarea where disk_reads > 5000 * executions order by executions desc) where rownum<6
43ruajmwv9fusinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
47fh8q7arykp9select tablespace_name , sum(bytes)/1024 bytes from dba_free_space group by tablespace_name
4y1y43113gv8fdelete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
520mkxqpf15q8select 1 from dual
59d21tvx4xn3qupdate user$ set name=:2, password=:3, datats#=:4, tempts#=:5, type#=:6, defrole=:7, resource$=:8, ptime=DECODE(to_char(:9, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :9), exptime=DECODE(to_char(:10, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :10), ltime=DECODE(to_char(:11, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :11), astatus=:12, lcount=:13, defschclass=:14, spare1=:15, spare4=:16 where user#=:1
59p216atzcyfhselect sql_text from (select sql_text from v$sqlarea order by loads desc) where rownum<6
5ungsgg5wj7cddelete from R_BIND_ASSOCIATEDNUM where SSUBSCRIBERID = :0
63kf3an2j0pkcinsert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6kqztxmbnwzhtupdate F1 set sSubscriberNumber = :0 where sSubscriberNumber = :1
6s2jxg0nq736ddelete from F2la where 1=1 and subscriberID = :0
6v3dub2363sa5select name, open_mode from v$database
7bdgxpmaqxx89update F1 set sSubscriberid = :0 , sUserState = :1 , sActiveType = :2 , nSingleMain = :3 , sActiveRoute = :4 , SCHARGEACCOUNT = :5 where sSubscriberNumber = :6
7br6xgmpmhukcSelect sScreenNumber, sScreenType, sScreenFlow from R_BWList_SubscriberBWList where nServiceID =:nServiceID and sSubscriberNumber=:sSubscriberNumber and sSubscriberNumType=:sSubscriberNumType and sScreenNumber=:sScreenNumber and sScreenNumberType=:sScreenNumberType and sScreenType=:sScreenType and (sScreenFlow=:sScreenFlow or sScreenFlow=0) and sSPID=:sSPID and sMatchType=0 and rownum =1
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#
803u6vwz0ah1p select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
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'))
8wyymnrxrudgdselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615375915431'
8xgd2r1h0kr34insert into wri$_adv_sqlt_plans (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml) 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, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
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
99xa2xfxq7xmcselect * from (select event, count(*) from v$session_wait group by event order by count(*) desc) where rownum < 6
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a5ks9fhw2v9s1select * from dual
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bph1a3spdtg6gselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618965065765'
byzbk6f5n4upzselect sql_text from (select sql_text from v$sqlarea where buffer_gets > 5000 * executions order by executions desc) where rownum<6
c0j6cx9kzjf7gSELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
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
d0xmnp08rhfbginsert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) 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#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
d98d5kh4u6ufxselect o.sid, o.user_name, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where o.sid=s.sid group by o.sid, o.user_name, osuser, machine order by o.user_name desc
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dckagq5arxva5delete from t_bme_subscriber where resourceNumber = :0
du3npcpzq82spselect sSubscriberID, sSubscriberNumber, sAssociatedNum1, sAssociatedNum2, sAssociatedNum3, sAssociatedNum4, sAssociatedNum5, sAssociatedNum6, sAssociatedNum7, sAssociatedNum8, sAssociatedNum9, sAssociatedNum10, sAssociatedNumTypeList, sActiveFlagList from R_Bind_AssociatedNum WHERE sAssociatedNum1 =:sAssociatedNum1 OR sAssociatedNum2 =:sAssociatedNum2 OR sAssociatedNum3 =:sAssociatedNum3 OR sAssociatedNum4 =:sAssociatedNum4 OR sAssociatedNum5 =:sAssociatedNum5 OR sAssociatedNum6 =:sAssociatedNum6 OR sAssociatedNum7 =:sAssociatedNum7 OR sAssociatedNum8 =:sAssociatedNum8 OR sAssociatedNum9 =:sAssociatedNum9 OR sAssociatedNum10 =:sAssociatedNum10
g278wv0zzpn5jselect unique objn from ((select objn from SYS_MFBA_STAGE_RID) union all (select d.objn "OBJN" from SYS_FBA_DL d, SYS_MFBA_TRACKED_TXN t where (d.usn=t.usn) and (d.slot = t.slot)))

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced640.020.14
CCursor + sql area evicted1,5350.433.29
CPU used by this session15,2024.2232.55
CPU used when call started11,2283.1224.04
CR blocks created220.010.05
Cached Commit SCN referenced1,5280.423.27
Commit SCN cached110.000.02
DB time278,22977.24595.78
DBWR checkpoint buffers written5,5141.5311.81
DBWR checkpoints00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR transaction table writes1140.030.24
DBWR undo block writes2,2340.624.78
Effective IO time00.000.00
HSC Heap Segment Block Changes52,97114.71113.43
Heap Segment Array Inserts6400.181.37
Heap Segment Array Updates50.000.01
IMU CR rollbacks90.000.02
IMU Flushes710.020.15
IMU Redo allocation size164,85645.77353.01
IMU commits3630.100.78
IMU contention70.000.01
IMU ktichg flush70.000.01
IMU pool not allocated00.000.00
IMU recursive-transaction flush00.000.00
IMU undo allocation size1,098,360304.932,351.95
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses40.000.01
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
RowCR - row contention00.000.00
RowCR attempts00.000.00
RowCR hits00.000.00
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client370,354102.82793.05
active txn count during cleanout5490.151.18
application wait time00.000.00
auto extends on undo tablespace00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts13,9513.8729.87
branch node splits00.000.00
buffer is not pinned count1,538,201427.043,293.79
buffer is pinned count301,37983.67645.35
bytes received via SQL*Net from client90,824,23125,215.06194,484.43
bytes sent via SQL*Net to client244,248,10867,809.33523,015.22
calls to get snapshot scn: kcmgss1,369,687380.262,932.95
calls to kcmgas25,7467.1555.13
calls to kcmgcs36,86210.2378.93
cell physical IO interconnect bytes930,956,800258,456.671,993,483.51
change write time5180.141.11
cleanout - number of ktugct calls6090.171.30
cleanouts and rollbacks - consistent read gets130.000.03
cleanouts only - consistent read gets800.020.17
cluster key scan block gets108,24630.05231.79
cluster key scans98,87027.45211.71
commit batch/immediate performed130.000.03
commit batch/immediate requested130.000.03
commit cleanout failures: block lost610.020.13
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure1000.030.21
commit cleanout failures: cannot pin00.000.00
commit cleanouts9,6402.6820.64
commit cleanouts successfully completed9,4792.6320.30
commit immediate performed130.000.03
commit immediate requested130.000.03
commit txn count during cleanout5870.161.26
concurrency wait time16,4534.5735.23
consistent changes754,257209.401,615.11
consistent gets2,693,625747.825,767.93
consistent gets - examination1,087,174301.832,328.00
consistent gets direct60.000.01
consistent gets from cache2,693,619747.825,767.92
consistent gets from cache (fastpath)966,827268.422,070.29
current blocks converted for CR00.000.00
cursor authentications18,3095.0839.21
data blocks consistent reads - undo records applied300.010.06
db block changes985,971273.732,111.29
db block gets2,382,417661.425,101.54
db block gets direct3420.090.73
db block gets from cache2,382,075661.325,100.80
db block gets from cache (fastpath)59,84516.61128.15
deferred (CURRENT) block cleanout applications4,8221.3410.33
dirty buffers inspected20.000.00
drop segment calls in space pressure00.000.00
enqueue conversions7270.201.56
enqueue deadlocks00.000.00
enqueue releases113,56931.53243.19
enqueue requests113,53331.52243.11
enqueue timeouts00.000.00
enqueue waits00.000.00
exchange deadlocks00.000.00
execute count351,36097.55752.38
failed probes on index block reclamation00.000.00
frame signature mismatch00.000.00
free buffer inspected21,4315.9545.89
free buffer requested185,71851.56397.68
global undo segment hints helped00.000.00
heap block compress3700.100.79
hot buffers moved to head of LRU36,95610.2679.13
immediate (CR) block cleanout applications930.030.20
immediate (CURRENT) block cleanout applications3,6301.017.77
index crx upgrade (positioned)130.000.03
index crx upgrade (prefetch)00.000.00
index fast full scans (full)7180.201.54
index fetch by key422,019117.16903.68
index scans kdiixs1743,359206.371,591.78
java call heap collected bytes00.000.00
java call heap collected count00.000.00
java call heap gc count00.000.00
java call heap live object count00.000.00
java call heap live object count max00.000.00
java call heap live size00.000.00
java call heap live size max00.000.00
java call heap object count00.000.00
java call heap object count max00.000.00
java call heap total size00.000.00
java call heap total size max00.000.00
java call heap used size00.000.00
java call heap used size max00.000.00
leaf node 90-10 splits800.020.17
leaf node splits2800.080.60
lob reads110,58330.70236.79
lob writes251,87269.93539.34
lob writes unaligned251,86869.92539.33
local undo segment hints helped00.000.00
logons cumulative2,8400.796.08
messages received5,3471.4811.45
messages sent5,3471.4811.45
min active SCN optimization applied to CR230.010.05
no work - consistent read gets548,066152.161,173.59
opened cursors cumulative191,21653.09409.46
parse count (describe)260.010.06
parse count (failures)1020.030.22
parse count (hard)63,91917.75136.87
parse count (total)164,18845.58351.58
parse time cpu4,8641.3510.42
parse time elapsed22,7086.3048.63
physical IO disk bytes930,956,800258,456.671,993,483.51
physical read IO requests17,3554.8237.16
physical read bytes146,563,07240,689.54313,839.55
physical read total IO requests51,88614.40111.10
physical read total bytes712,269,824197,743.751,525,203.05
physical read total multi block requests120.000.03
physical reads17,8914.9738.31
physical reads cache17,8854.9738.30
physical reads cache prefetch5360.151.15
physical reads direct60.000.01
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests2,3270.654.98
physical write bytes47,988,73613,322.86102,759.61
physical write total IO requests13,3153.7028.51
physical write total bytes218,686,97660,712.92468,280.46
physical write total multi block requests2250.060.48
physical writes5,8581.6312.54
physical writes direct3420.090.73
physical writes direct (lob)80.000.02
physical writes direct temporary tablespace3300.090.71
physical writes from cache5,5161.5311.81
physical writes non checkpoint2,6360.735.64
pinned buffers inspected120.000.03
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use1,3400.372.87
recursive calls919,332255.231,968.59
recursive cpu usage9,5522.6520.45
redo blocks checksummed by FG (exclusive)16,7554.6535.88
redo blocks written80,53122.36172.44
redo buffer allocation retries00.000.00
redo entries118,11832.79252.93
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks2,0730.584.44
redo size38,400,21210,660.8582,227.43
redo size for direct writes98,73627.41211.43
redo subscn max counts3,3870.947.25
redo synch time480.010.10
redo synch writes1,8100.503.88
redo wastage1,145,000317.882,451.82
redo write time2030.060.43
redo writer latching time10.000.00
redo writes3,0670.856.57
rollback changes - undo records applied00.000.00
rollbacks only - consistent read gets90.000.02
rows fetched via callback124,61834.60266.85
session connect time00.000.00
session cursor cache hits99,84727.72213.81
session logical reads5,076,0421,409.2410,869.47
shared hash latch upgrades - no wait578,200160.521,238.12
shared hash latch upgrades - wait3500.100.75
sorts (memory)13,4273.7328.75
sorts (rows)4,758,5421,321.0910,189.60
space was found by tune down00.000.00
sql area evicted60,39316.77129.32
sql area purged1390.040.30
steps of tune down ret. in space pressure00.000.00
summed dirty queue length20.000.00
switch current to new buffer3,3880.947.25
table fetch by rowid333,88792.70714.96
table fetch continued row7460.211.60
table scan blocks gotten63,26917.57135.48
table scan rows gotten3,194,543886.886,840.56
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)12,3433.4326.43
total number of times SMON posted00.000.00
transaction rollbacks130.000.03
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
tune down retentions in space pressure00.000.00
undo change vector size14,457,8244,013.8530,958.94
user I/O wait time6,0621.6812.98
user calls516,023143.261,104.97
user commits4590.130.98
user rollbacks80.000.02
workarea executions - optimal9,3322.5919.98
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory194,389,624,923,608194,441,276,873,176
opened cursors current505448
logons current7370
session uga memory max4,185,263,809,9844,186,165,263,440
session pga memory101,195,064,272101,185,427,904
session pga memory max130,523,079,632130,552,830,400
session cursor cache count41,596,45641,605,301

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

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)
TOTO_USER_DAT 7,72724.021.00202000.00
TOTO_USER_IDX 6,37922.351.0067000.00
SYSAUX 3,21614.511.071,144000.00
SYSTEM 1808.891.00538000.00
UNDOTBS1 000.000.00357000.00
TEMP 1502.0022.0019000.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)
TOTO_USER_DAT/dev/vx/rdsk/vgphydb/lvdata 7,72724.021.00202000.00
TOTO_USER_IDX/dev/vx/rdsk/vgphydb/lvindex 6,37922.351.0067000.00
SYSAUX/dev/vx/rdsk/vgora/lvsysaux 3,21614.511.071,144000.00
SYSTEM/dev/vx/rdsk/vgora/lvsystem 1808.891.00538000.00
TEMP/dev/vx/rdsk/vgora/lvtemp 1502.0022.001900 
UNDOTBS1/dev/vx/rdsk/vgora/lvundo 00  357000.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
D260,1721005,075,38117,8855,516000


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
B0114833469623592160006235 
E0102711437286092160002860 

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D2080.1025,623194.653,247,497,161
D4160.2051,246117.141,954,333,378
D6240.3076,86965.401,091,022,150
D8320.39102,49231.32522,596,897
D1,0400.49128,11512.96216,142,454
D1,2480.59153,7386.05101,009,914
D1,4560.69179,3613.2854,761,828
D1,6640.79204,9841.9432,309,928
D1,8720.89230,6071.2721,265,160
D2,0800.98256,2301.0216,992,582
D2,1121.00260,1721.0016,683,391
D2,2881.08281,8530.9015,011,374
D2,4961.18307,4760.8313,814,475
D2,7041.28333,0990.7812,995,029
D2,9121.38358,7220.7412,299,166
D3,1201.48384,3450.7011,725,175
D3,3281.58409,9680.6711,216,026
D3,5361.67435,5910.6510,762,633
D3,7441.77461,2140.6210,386,321
D3,9521.87486,8370.6010,034,047
D4,1601.97512,4600.589,722,979

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.005190

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

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K8,7658,76500
64K128K747400
128K256K404000
256K512K444400
512K1024K19919900
1M2M19519500
2M4M2200
4M8M101000
16M32M2200

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
3500.131,231,167.910.00100.000184,877,226
7000.251,231,167.910.00100.000184,877,226
1,4000.501,231,167.910.00100.000184,877,226
2,1000.751,231,167.910.00100.000184,877,226
2,8001.001,231,167.910.00100.000184,877,226
3,3601.201,231,167.910.00100.000184,877,226
3,9201.401,231,167.910.00100.000184,877,226
4,4801.601,231,167.910.00100.000184,877,226
5,0401.801,231,167.910.00100.000184,877,226
5,6002.001,231,167.910.00100.000184,877,226
8,4003.001,231,167.910.00100.000184,877,226
11,2004.001,231,167.910.00100.000184,877,226
16,8006.001,231,167.910.00100.000184,877,226
22,4008.001,231,167.910.00100.000184,877,226

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
4000.1920937,78416,935,5720.981,251,7431.34292,672
6080.2941747,74117,050,2660.991,137,0491.22304,725
8160.4062559,92117,106,3510.991,080,9641.16310,662
1,0240.5083372,04517,142,9470.991,044,3681.12314,354
1,2320.601,04184,79217,172,0021.001,015,3131.09317,405
1,4400.701,24996,53217,195,6931.00991,6221.06319,911
1,6480.801,457109,22117,216,1981.00971,1171.04322,095
1,8560.901,665121,08317,234,7151.00952,6001.02324,068
2,0641.001,872133,98017,251,6101.00935,7051.00325,889
2,2721.102,080145,94917,266,9521.00920,3630.98327,556
2,4801.202,288158,31417,280,9251.00906,3900.97329,093
2,6881.302,496170,74117,293,8691.00893,4460.95330,537
2,8961.402,704182,95717,306,0251.00881,2900.94331,901
3,1041.502,912195,51517,317,3541.00869,9610.93333,185
3,3121.603,120207,95517,328,0181.00859,2970.92334,402
3,5201.713,328220,61017,338,1341.01849,1810.91335,562
3,7281.813,536232,98217,347,7341.01839,5810.90336,668
3,9361.913,744246,16217,357,5431.01829,7720.89337,720
4,1442.014,013261,78917,368,4731.01818,8420.88338,930

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,9500.387,070,5551,533,263,693
2,6000.502,471,942169,573,323
3,2500.631,885,81525,348,744
3,9000.751,775,89516,683,391
4,5500.881,712,17816,683,391
5,2001.001,667,97716,683,391
5,8501.131,632,44913,088,120
6,5001.251,602,75913,088,120
7,1501.381,568,23213,331,698
7,8001.501,557,72410,195,220
8,4501.631,553,0538,798,820
9,1001.751,549,8847,872,892
9,7501.881,549,0507,627,646
10,4002.001,549,0507,627,646

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP 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
161.002494,3021.00935,7051.0035,138
322.0091774,3021.00935,7051.00128,780

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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
22.144,2561,190561111.9/63949.90/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
11-Mar 22:53173071,185263,9350/00/0/0/0/0/0
11-Mar 22:4315351585163,9390/00/0/0/0/0/0
11-Mar 22:33133061,187163,9340/00/0/0/0/0/0
11-Mar 22:2328584586163,9140/00/0/0/0/0/0
11-Mar 22:1333111,190163,9500/00/0/0/0/0/0
11-Mar 22:032,0612,397590561,1120/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch2,3860.00 00 
ASM map operation hash table10.00 00 
AWR Alerted Metric Element list25,6610.00 00 
Change Notification Hash table latch1,2100.00 00 
Consistent RBA3,0670.00 00 
DML lock allocation1,726,4420.000.0000 
Event Group Locks2,8300.00 00 
FAL request queue960.00 00 
FOB s.o list latch14,7210.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch130.00 00 
In memory undo latch7,7730.00 02,8940.00
JOX JIT latch10.00 010.00
JOX SGA heap latch8950.00 00 
JS Sh mem access70.00 00 
JS mem alloc latch110.00 00 
JS queue access latch120.00 00 
JS queue state obj latch25,9900.00 00 
JS slv state obj latch2330.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFR redo allocation latch10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list130.00 00 
KJCT flow control latch130.00 00 
KMG MMAN ready and startup request latch1,1940.00 00 
KTF sga latch480.00 09290.00
Locator state objects pool parent latch10.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch130.00 01,1940.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch1,381,4620.020.0000 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process9,0130.00 00 
OS process allocation7,1910.00 00 
OS process: request allocation5,6610.00 00 
PL/SQL warning settings4,7470.00 00 
QMT10.00 00 
Real-time plan statistics latch4,0870.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1210.00 01,1930.00
SQL memory manager workarea list latch82,8000.00 00 
Shared B-Tree1290.00 00 
Streams Generic10.00 00 
Testing130.00 00 
Token Manager10.00 00 
Write State Object Pool Parent Latch10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch3,3810.00 00 
active service list17,3020.020.0002,699,5790.00
archive control1,0130.00 00 
archive process latch1,3850.00 00 
begin backup scn array90.00 00 
buffer pool130.00 00 
business card10.00 00 
cache buffer handles777,8120.090.0000 
cache buffers chains11,164,8430.030.000199,9340.03
cache buffers lru chain18,3490.020.000464,6060.04
cache table scan latch1360.00 01360.00
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch5,6760.00 00 
channel operations parent latch27,8230.00 00 
checkpoint queue latch70,3350.00 05,2280.00
client/application info8,1590.00 00 
commit callback allocation10.00 00 
compile environment latch2,8410.00 00 
corrupted undo seg lock130.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch590.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch590.00 00 
dictionary lookup130.00 00 
dml lock allocation590.00 00 
done queue latch130.00 00 
dummy allocation5,6860.00 00 
enqueue hash chains227,8340.020.0200 
enqueues203,5670.070.0000 
fifth spare latch130.00 00 
file cache latch1700.00 00 
flashback archiver latch120.00 00 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state130.00 00 
gcs partitioned table hash130.00 00 
gcs pcm hashed value bucket hash130.00 00 
gcs resource freelist130.00 00 
gcs resource hash130.00 00 
gcs resource scan list130.00 00 
gcs shadows freelist130.00 00 
ges domain table130.00 00 
ges enqueue table freelist130.00 00 
ges group table130.00 00 
ges process hash list130.00 00 
ges process parent latch130.00 00 
ges resource hash list130.00 00 
ges resource scan list130.00 00 
ges resource table freelist130.00 00 
ges value block free list130.00 00 
global KZLD latch for mem in SGA1,7130.00 00 
global tx hash mapping10.00 00 
granule operation130.00 00 
hash table column usage latch4860.00 0422,9960.05
hash table modification latch810.00 00 
heartbeat check130.00 00 
internal temp table object number allocation latch30.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 0180.00
job_queue_processes free list latch70.00 00 
job_queue_processes parameter latch8570.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats382,7550.070.0600 
kokc descriptor allocation latch300.00 00 
ksfv messages130.00 00 
kss move lock450.00 00 
ksuosstats global area2420.00 00 
ksv allocation latch1230.00 00 
ksv class latch770.00 00 
ksv msg queue latch130.00 00 
ksz_so allocation latch5,6610.00 00 
ktm global data170.00 00 
kwqbsn:qsga1280.00 00 
lgwr LWN SCN3,0720.030.0000 
list of block allocation3,5900.00 00 
loader state object freelist560.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation10.00 00 
logminer work area10.00 00 
longop free list parent1400.00 01260.00
mapped buffers lru chain10.00 00 
message pool operations parent latch130.00 00 
messages44,6230.000.0000 
mostly latch-free SCN3,0780.130.0000 
msg queue latch130.00 00 
multiblock read objects1,8540.00 00 
name-service namespace bucket130.00 00 
ncodef allocation latch590.00 00 
object queue header heap1980.00 01580.00
object queue header operation358,2530.000.0000 
object stats modification1570.00 00 
parallel query alloc buffer4610.00 00 
parallel query stats10.00 00 
parameter list7,2870.00 00 
parameter table management5,6870.00 00 
peshm10.00 00 
pesom_free_list5750.00 00 
pesom_hash_node5750.00 00 
pesom_heap_alloc60.00 00 
post/wait queue9260.00 06050.00
process allocation5,7450.021.0002,8290.00
process group creation5,6610.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5230.00 00 
query server freelists10.00 00 
queued dump request110.00 00 
recovery domain hash list130.00 00 
redo allocation15,0300.040.000118,1350.02
redo copy130.00 0118,1400.05
redo writing15,0990.00 00 
resmgr group change latch2,1430.00 00 
resmgr:active threads6,4630.020.0006040.00
resmgr:actses change group1,0970.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list5,7070.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method20.00 00 
resmgr:schema config8330.00 0590.00
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects8,431,4520.530.0002,2330.04
second spare latch130.00 00 
sequence cache5,5620.00 00 
session allocation603,0970.200.0300 
session idle bit1,326,5050.010.0100 
session queue latch130.00 00 
session state list latch2,2990.00 00 
session switching720.00 00 
session timer1,2530.00 00 
shared pool3,373,1220.630.0820 
shared pool sim alloc10.00 00 
shared pool simulator637,5270.000.0000 
sim partition latch130.00 00 
simulator hash latch219,2720.00 00 
simulator lru latch130.00 0218,9990.03
sort extent pool2000.00 00 
space background state object latch80.00 00 
space background task latch2,6520.00 02,3880.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain130.00 00 
temp lob duration state obj allocation50.00 00 
temporary table state object allocation40.00 00 
test excl. parent l0130.00 00 
test excl. parent2 l0130.00 00 
third spare latch130.00 00 
threshold alerts latch1660.00 00 
transaction allocation529,2670.000.0000 
undo global data14,2860.00 00 
user lock6,8770.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects8,431,45244,5403344,508
shared pool3,373,12221,1101,66419,510
cache buffers chains11,164,8433,249153,235
session allocation603,0971,220401,181
cache buffer handles777,8126681667
kks stats382,75525716242
session idle bit1,326,5051672165
enqueue hash chains227,83441140
process allocation5,745110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffer handleskcbzfs010
cache buffers chainskcbgtcr_90120124
cache buffers chainskcbgtcr: fast path0154
cache buffers chainskcbzgb: scan from tail. nowait040
cache buffers chainskcbrls_20310
cache buffers chainskcbrls: fast release010
enqueue hash chainsksqrcl010
kks statskksAllocChildStat01616
object queue header operationkcbo_switch_cq010
object queue header operationkcbo_unlink_q012
process allocationksucrp:1010
row cache objectskqreqd: reget0220
row cache objectskqrget077
row cache objectskqrpre: find obj0425
session allocationksuxds: KSUSFCLC not set0180
session allocationksufap: active sessions0150
session allocationksuxds: not user session043
session allocationksucri0336
session idle bitksupuc: clear busy010
session idle bitksuxds010
shared poolkghalo01,076875
shared poolkghalp0393333
shared poolkghupr10163393
shared poolkgh_heap_sizes01232
shared poolkghasp01016
shared poolkghfre0915

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library CachekglGetHandleReference 11513,56114
Library Cachekglhdgn2 1063092,279
Library Cachekglobpn1 71305251
Library Cachekglhdgn1 62187521
Library Cachekglpin1 412347
Library Cachekglpndl1 95123354
Library Cachekgllkdl1 8560422
Library Cachekglpnal1 905446
Library Cachekgldtin1 4239300
Library Cachekglget2 231337
Library Cachekgllkc1 5750
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]41
Library Cachekglrfcl1 7913

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
TOTOTOTO_USER_IDXI_BME_PERSON_SUB_NUMBER INDEX396,1127.80
TOTOTOTO_USER_DATINDEX_BIND_NUMBER1 INDEX195,7923.86
TOTOTOTO_USER_DATSYS_C0011178 INDEX191,9363.78
SYSSYSTEMI_H_OBJ#_COL# INDEX131,4242.59
SYSSYSTEMUSER$ TABLE80,6401.59

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
TOTOTOTO_USER_DATINDEX_BIND_NUMBER1 INDEX1,3287.42
TOTOTOTO_USER_IDXI_BME_SUBSCRIBER_CREATETIME INDEX1,1146.23
TOTOTOTO_USER_DATSYS_C0011178 INDEX2201.23
TOTOTOTO_USER_DATR_BIND_ASSOCIATEDNUM TABLE1180.66
SYSSYSAUXWRI$_ADV_MESSAGE_GROUPS TABLE1080.60

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

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX60410.31
SYSSYSTEMHISTGRM$ TABLE59410.14
SYSSYSTEMI_H_OBJ#_COL# INDEX1883.21
SYSSYSAUXWRI$_OPTSTAT_HISTGRM_HISTORY TABLE1182.01
SYSSYSAUXWRH$_SQLTEXT TABLE440.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXSYS_LOB0000005575C00040$$ LOB41.17
SYSSYSAUXSYS_LOB0000005981C00038$$ LOB41.17
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY42243_9044TABLE PARTITION41.17

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX70.97
SYSSYSAUXWRH$_PGA_TARGET_ADVICE_PK INDEX30.42
SYSSYSAUXWRH$_WAITSTAT_PK42243_9044INDEX PARTITION30.42
SYSSYSAUXWRH$_DB_CACHE_ADVICE_PK42243_9044INDEX PARTITION20.28
SYSSYSTEMI_OBJ1 INDEX10.14

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSSYSTEMHISTGRM$ TABLE44,92844.88
SYSSYSTEMI_H_OBJ#_COL# INDEX44,73644.69
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX3,9043.90
SYSSYSTEMUSER$ TABLE1,7761.77
SYSSYSAUXWRI$_OPTSTAT_HISTHEAD_HISTORY TABLE1,7601.76

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
TOTOTOTO_USER_IDXI_BME_SUBSCRIBER_CREATETIME INDEX2100.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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control830.000 21
dc_constraints11734.190 1171
dc_database_links4,4600.000 01
dc_files2220.000 06
dc_global_oids817.410 027
dc_histogram_data824,4000.410 2,7721,536
dc_histogram_defs1,076,1030.430 1,5751,775
dc_object_grants5610.710 016
dc_objects1,015,7090.060 56821
dc_profiles1,7550.000 02
dc_rollback_segments8240.000 022
dc_segments255,2600.090 4591
dc_sequences248.330 242
dc_table_scns11100.000 00
dc_tablespaces14,1110.000 08
dc_users153,2320.010 1,685112
global database name3,4850.000 01
outstanding_alerts4812.500 07


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY14415.973128.0100
CLUSTER3590.001890.0000
INDEX1,7587.051,45516.63210
JAVA DATA20.000 00
SQL AREA270,76966.04483,89738.276,396211
TABLE/PROCEDURE1,135,8620.04225,9820.695420
TRIGGER2,0500.882,0500.8800


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache2,112.002,112.002,112.002,576.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target2,800.002,800.002,800.003,280.000SHR/DEF
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target5,200.005,200.004,720.005,200.000GRO/DEF
Shared IO Pool944.00944.00944.00944.000STA/
java pool16.0016.0016.0032.000SHR/DEF
large pool16.0016.0016.0016.000STA/
shared pool2,064.002,064.001,104.002,064.000GRO/DEF
streams pool0.000.000.000.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther270.52 3.616.8540407575
 Freeable51.880.001.081.487 4848
 SQL6.322.100.110.302115845
 JAVA2.362.361.181.672422
 PL/SQL0.530.300.010.02007373
EOther213.78 2.975.3822227272
 Freeable37.880.000.841.067 4545
 SQL3.410.110.060.08095542
 JAVA2.362.361.181.672422
 PL/SQL0.220.090.000.00007070

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers2,214,592,512 
Fixed Size2,176,320 
Redo Buffers10,694,656 
Variable Size6,123,686,592 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory4.354.350.00
javajoxlod exec hp11.1911.190.00
javajoxs heap0.460.460.00
largePX msg pool0.990.990.00
largefree memory15.0115.010.00
sharedCCursor210.42219.944.53
sharedCursor Stats26.9726.970.00
sharedKGL handle76.1076.850.98
sharedPCursor209.75212.451.29
shareddb_block_hash_buckets22.2522.250.00
sharedfree memory341.79276.36-19.14
sharedkglsim object batch36.2836.280.00
sharedsql area961.391,021.816.28
 buffer_cache2,112.002,112.000.00
 fixed_sga2.082.080.00
 log_buffer10.2010.200.00
 shared_io_pool944.00944.000.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

No data exists for this section of the report.

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/oracle/app/admin/ora11g/adump  
audit_trailNONE  
compatible11.1.0.0.0  
control_files/dev/vx/rdsk/vgora/lvctl1, /dev/vx/rdsk/vgora/lvctl2, /dev/vx/rdsk/vgora/lvctl3  
db_block_size8192  
db_domain    
db_nameora11g  
db_recovery_file_dest    
db_recovery_file_dest_size2147483648  
diagnostic_dest/oracle/app  
dispatchers(PROTOCOL=TCP) (SERVICE=ora11gXDB)  
local_listener    
log_archive_dest_1location=/home/oracle/archive  
memory_target8388608000  
open_cursors300  
processes150  
remote_listener    
remote_login_passwordfileEXCLUSIVE  
sec_case_sensitive_logonFALSE  
spfile/dev/vx/rdsk/vgora/lvspfile  
undo_tablespaceUNDOTBS1  


Back to Top

End of Report