|
<P>
No data exists for this section of the report.
<P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘99997‘></A>
<P>
<H3 class=‘awr‘>Complete List of SQL Text</H3><P>
<TABLE BORDER=1>
<TR><TH class=‘awrbg‘>SQL Id</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘0h6b2sajwb74n‘></A>0h6b2sajwb74n</TD><TD class=‘awrc‘>select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘0m9ka0jk9kk4z‘></A>0m9ka0jk9kk4z</TD><TD class=‘awrnc‘>SELECT OWNER,TABLE_NAME FROM ALL_TABLES WHERE OWNER = ‘SKODACOM_READ‘ ORDER BY OWNER</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘0pt2789bczdp0‘></A>0pt2789bczdp0</TD><TD class=‘awrc‘>
SELECT T.TABLE_NAME,T.TABLESPACE_NAME,T.CLUSTER_NAME,T.IOT_NAME,T.PCT_FREE,T.PCT_USED,T.INI_TRANS,T.MAX_TRANS,T.INITIAL_EXTENT,T.NEXT_EXTENT,T.MIN_EXTENTS,T.MAX_EXTENTS,T.PCT_INCREASE,T.FREELISTS,T.FREELIST_GROUPS,T.LOGGING,T.BACKED_UP,T.NUM_ROWS,T.BLOCKS,T.EMPTY_BLOCKS,T.AVG_SPACE,T.CHAIN_CNT,T.AVG_ROW_LEN,T.AVG_SPACE_FREELIST_BLOCKS,T.NUM_FREELIST_BLOCKS,T.DEGREE,T.INSTANCES,T.CACHE,T.TABLE_LOCK,T.SAMPLE_SIZE,T.LAST_ANALYZED,T.PARTITIONED,T.IOT_TYPE,T.TEMPORARY,T.SECONDARY,T.NESTED,T.BUFFER_POOL,T.MONITORING,T.CLUSTER_OWNER,TC.COMMENTS,T.OBJECT_ID_TYPE,T.TABLE_TYPE_OWNER,T.TABLE_TYPE,T.GLOBAL_STATS,T.USER_STATS,T.DURATION,T.SKIP_CORRUPT,T.ROW_MOVEMENT,ET.TABLE_NAME EXT_TABLE_NAME,T.DEPENDENCIES,T.COMPRESSION,T.DROPPED,T.STATUS DROP_STATUS,(SELECT STATUS FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_NAME = T.TABLE_NAME AND OBJECT_TYPE = ‘TABLE‘) STATUS,(SELECT GENERATED FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_NAME = T.TABLE_NAME AND OBJECT_TYPE = ‘TABLE‘) GENERATED FROM SYS.ALL_ALL_TABLES T,SYS.ALL_EXTERNAL_TABLES ET,SYS.ALL_TAB_COMMENTS TC WHERE T.IOT_NAME IS NULL AND T.NESTED = ‘NO‘ AND T.SECONDARY = ‘N‘ AND NOT EXISTS (SELECT 1 FROM SYS.ALL_MVIEWS MV WHERE MV.OWNER = T.OWNER AND MV.MVIEW_NAME = T.TABLE_NAME) AND TC.OWNER(+) = T.OWNER AND TC.TABLE_NAME(+) = T.TABLE_NAME AND ET.TABLE_NAME(+) = T.TABLE_NAME AND ET.OWNER(+) = T.OW
NER AND T.OWNER = ‘SKODACOM‘ ORDER BY T.TABLE_NAME ASC</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘15xnmd14bcfby‘></A>15xnmd14bcfby</TD><TD class=‘awrnc‘>
SELECT T.TABLE_NAME,SYS.ALL_TAB_COMMENTS TC WHERE T.IOT_NAME IS NULL AND T.NESTED = ‘NO‘ AND T.SECONDARY = ‘N‘ AND NOT EXISTS (SELECT 1 FROM SYS.ALL_MVIEWS MV WHERE MV.OWNER = T.OWNER AND MV.MVIEW_NAME = T.TABLE_NAME) AND TC.OWNER(+) = T.OWNER AND TC.TABLE_NAME(+) = T.TABLE_NAME AND ET.TABLE_NAME(+) = T.TABLE_NAME AND ET.OWNER(+) = T.OW
NER AND T.OWNER = ‘SKODACOM_READ‘ ORDER BY T.TABLE_NAME ASC</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘1srfjbzhb29z8‘></A>1srfjbzhb29z8</TD><TD class=‘awrc‘> select from sys.wrh$_active_session_history</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘31a13pnjps7j3‘></A>31a13pnjps7j3</TD><TD class=‘awrnc‘>
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‘,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) FROWRM$_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,1 ) as operation
,l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l,‘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
</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘32wqka2zwvu65‘></A>32wqka2zwvu65</TD><TD class=‘awrc‘>insert into wrh$_parameter (snap_id,dbid,instance_number,parameter_hash,value,isdefault,ismodified) select :snap_id,:dbid,:instancenumber,i.ksppihash hash,sv.ksppstvl,sv.ksppstdf,decode(bitand(sv.ksppstvf,7),1,‘MODIFIED‘,‘FALSE‘) from x$ksppi i,x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like ‘#%‘ escape ‘#‘) or (sv.ksppstdf = ‘FALSE‘) or (bitand(sv.ksppstvf,5) > 0)) or (i.ksppinm like ‘##%‘ escape ‘#‘)) order by hash</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘350f5yrnnmshs‘></A>350f5yrnnmshs</TD><TD class=‘awrnc‘>lock table sys.mon_mods$ in exclusive mode nowait</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘3c1kubcdjnppq‘></A>3c1kubcdjnppq</TD><TD class=‘awrc‘>update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),equijoin_preds = equijoin_preds + decode(bitand(:flag,2),nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),range_preds = range_preds + decode(bitand(:flag,8),like_preds = like_preds + decode(bitand(:flag,16),null_preds = null_preds + decode(bitand(:flag,32),timestamp = :time where obj# = :objn and intcol# = :coln</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘49s332uhbnsma‘></A>49s332uhbnsma</TD><TD class=‘awrnc‘> declare
vsn varchar2(20);
begin
vsn := dbms_rcvman.getPackageVersion;
:pkg_vsn:pkg_vsn_i := vsn;
if vsn is not null then
:pkg_vsnub4 :=
to_number(substr(vsn,2) || substr(vsn,4,2) ||
substr(vsn,7,2) || nvl(substr(vsn,10,‘00‘));
end if;
end;</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘53btfq0dt9bs9‘></A>53btfq0dt9bs9</TD><TD class=‘awrc‘>insert into sys.col_usage$ values ( :objn,:coln,decode(bitand(:flag,:time)</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘572fbaj0fdw2b‘></A>572fbaj0fdw2b</TD><TD class=‘awrnc‘>select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid,:eid,
:rpt_options ))</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘586b2udq6dbng‘></A>586b2udq6dbng</TD><TD class=‘awrc‘>insert into wrh$_sysstat (snap_id,stat_id,value) select :snap_id,:instance_number,value from v$sysstat order by stat_id</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘5h7w8ykwtb2xt‘></A>5h7w8ykwtb2xt</TD><TD class=‘awrnc‘>INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID,NAME,DATATYPE,VALUE,FLAGS,DESCRIPTION) VALUES (:B6,:B5,:B4,:B3,:B2,:B1 )</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘5n73rjfpt3q4b‘></A>5n73rjfpt3q4b</TD><TD class=‘awrc‘>BEGIN :snap_id:=dbms_workload_repository.create_snapshot; END;
</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘6cxqh7mktnbjm‘></A>6cxqh7mktnbjm</TD><TD class=‘awrnc‘>insert into smon_scn_time (thread,time_mp,time_dp,scn,scn_wrp,scn_bas,num_mappings,tim_scn_map) values (0,:1,:2,:3,:4,:5,:6,:7)</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘772s25v1y0x8k‘></A>772s25v1y0x8k</TD><TD class=‘awrc‘>select shared_pool_size_for_estimate s,shared_pool_size_factor 100 f,estd_lc_load_time l,0 from v$shared_pool_advice</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘7cq8d0jqxzum1‘></A>7cq8d0jqxzum1</TD><TD class=‘awrnc‘>delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘7mvdhsu3d43ag‘></A>7mvdhsu3d43ag</TD><TD class=‘awrc‘>select a.obj# OBJOID,a.class_oid CLSOID,decode(bitand(a.flags,16384),a.next_run_date,a.last_enabled_time) RUNTIME,(2a.priority + decode(bitand(a.job_status,decode(a.running_instance,-1,1))) PRI,1 JOBTYPE,a.schedule_limit SCHLIM,a.job_weight WT,NULL,a.running_instance) INST,1) RUNNOW,decode(bitand(a.job_status,8388608),1) ENQ_SCHLIM from sys.scheduler$_job a where bitand(a.job_status,515) = 1 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 not null and a.class_oid in (select b.obj# from scheduler$_class b where bitand(b.flags,:4) <> 0 and b.affinity = :5) order by RUNTIME,CLSOID,PRI,WT DESC,OBJOID</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘7vgmvmy8vvb9s‘></A>7vgmvmy8vvb9s</TD><TD class=‘awrnc‘>insert into wrh$_tempstatxs (snap_id,file#,creation_change#,phyrds,phywrts,singleblkrds,readtim,writetim,singleblkrdtim,phyblkrd,phyblkwrt,wait_count,time) select :snap_id,:instance_number tf.tfnum,to_number(tf.tfcrc_scn) creation_change#,ts.kcftiopyr,ts.kcftiopyw,ts.kcftiosbr,ts.kcftioprt,ts.kcftiopwt,ts.kcftiosbt,ts.kcftiopbr,ts.kcftiopbw,fw.count,fw.time from x$kcftio ts,x$kcctf tf,x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘803b7z0t84sq7‘></A>803b7z0t84sq7</TD><TD class=‘awrc‘>select job,0) from sys.job$ where (((:1 <= next_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and ‘Y‘ = :5)) and (this_date is null) order by next_date,job </TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘84qubbrsr0kfn‘></A>84qubbrsr0kfn</TD><TD class=‘awrnc‘>insert into wrh$_latch (snap_id,latch_hash,level#,gets,misses,sleeps,immediate_gets,immediate_misses,spin_gets,sleep1,sleep2,sleep3,sleep4,wait_time) select :snap_id,hash,wait_time from v$latch order by hash</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘84vvbj8g8sups‘></A>84vvbj8g8sups</TD><TD class=‘awrc‘>SELECT V.VIEW_NAME,V.TEXT_LENGTH,V.TEXT,V.TYPE_TEXT_LENGTH,V.TYPE_TEXT,V.OID_TEXT_LENGTH,V.OID_TEXT,V.VIEW_TYPE_OWNER,V.VIEW_TYPE,V.SUPERVIEW_NAME,(SELECT STATUS FROM SYS.ALL_OBJECTS WHERE OWNER = V.OWNER AND OBJECT_NAME = V.VIEW_NAME AND OBJECT_TYPE = ‘VIEW‘ AND SUBOBJECT_NAME IS NULL) STATUS,(SELECT COMMENTS FROM SYS.ALL_TAB_COMMENTS WHERE OWNER = V.OWNER AND TABLE_NAME = V.VIEW_NAME) COMMENTS,C.CONSTRAINT_NAME,C.CONSTRAINT_TYPE FROM SYS.ALL_VIEWS V,SYS.ALL_CONSTRAINTS C WHERE C.OWNER(+) = V.OWNER AND C.TABLE_NAME(+) = V.VIEW_NAME AND V.OWNER = ‘SKODACOM‘ AND V.VIEW_NAME = ‘VIEW_THREAD_USER‘ ORDER BY V.OWNER,V.VIEW_NAME ASC</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘86synsm5txwj6‘></A>86synsm5txwj6</TD><TD class=‘awrnc‘>SELECT V.VIEW_NAME,SYS.ALL_CONSTRAINTS C WHERE C.OWNER(+) = V.OWNER AND C.TABLE_NAME(+) = V.VIEW_NAME AND V.OWNER = ‘SKODACOM‘ ORDER BY V.OWNER,V.VIEW_NAME ASC</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘8dw6saa5zu2sk‘></A>8dw6saa5zu2sk</TD><TD class=‘awrc‘>
select
service_name,uio_waits,uio_time,con_waits,con_time,
adm_waits,adm_time,net_waits,net_time
from
(select
stat1.service_name service_name,db_time,
con_waits,adm_waits,net_time
from
(select s1.service_name,
sum(decode(s1.stat_name,‘DB time‘,s1.diff,0)) db_time
from
(select e.service_name service_name,
e.stat_name stat_name,
e.value - b.value diff
from dba_hist_service_stat b,
dba_hist_service_stat e
where b.snap_id = :bid
and e.snap_id = :eid
and b.instance_number = :inst_num
and e.instance_number = :inst_num
and b.dbid = :dbid
and e.dbid = :dbid
and b.stat_id = e.stat_id
and b.service_name_hash = e.service_name_hash) s1
group by s1.service_name) stat1,
(select s2.service_name,
sum(decode(s2.wait_class,‘User I/O‘,
s2.total_waits,0)) uio_waits,
s2.time_waited,0)) uio_time,‘Concurrency‘,0)) con_waits,
sum(dec
ode(s2.wait_class,0)) con_time,‘Administrative‘,0)) adm_waits,0)) adm_time,‘Network‘,0)) net_waits,0)) net_time
from
(select e.service_name service_name,
e.wait_class wait_class,
e.total_waits - b.total_waits total_waits,
e.time_waited - b.time_waited time_waited
from dba_hist_service_wait_class b,
dba_hist_service_wait_class e
where b.snap_id = :bid
and e.snap_id = :eid
and b.instance_number = :inst_num
and e.instance_number = :inst_num
and b.dbid = :dbid
and e.dbid = :dbid
and b.wait_class_id = e.wait_class_id
and b.service_name_hash = e.service_name_hash) s2
group by s2.service_name) stat2
where
stat1.service_name = stat2.service_name
order by
db_time desc,service_name)
wh
ere rownum <= :top_n_svc</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘8p447s6p0rv6b‘></A>8p447s6p0rv6b</TD><TD class=‘awrnc‘>select java_pool_size_for_estimate s,java_pool_size_factor 100 f,0 from v$java_pool_advice</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘8swypbbr0m372‘></A>8swypbbr0m372</TD><TD class=‘awrc‘>select order#,types from access$ where d_obj#=:1</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘95w06sfdyppfj‘></A>95w06sfdyppfj</TD><TD class=‘awrnc‘>SELECT FROM (SELECT "NAVICAT_TABLE".,ROWNUM "NAVICAT_ROWNUM" FROM (SELECT FROM "SKODACOM"."VIEW_THREAD_USER") "NAVICAT_TABLE" WHERE ROWNUM <= 1000) WHERE "NAVICAT_ROWNUM" > 0</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘a1xgxtssv5rrp‘></A>a1xgxtssv5rrp</TD><TD class=‘awrc‘>select sum(used_blocks),ts.ts# from GV$SORT_SEGMENT gv,ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘a1y2ba3awndas‘></A>a1y2ba3awndas</TD><TD class=‘awrnc‘>SELECT VALUE FROM DBA_HIST_PARAMETER WHERE SNAP_ID = :B4 AND DBID = :B3 AND INSTANCE_NUMBER = :B2 AND PARAMETER_NAME = :B1 </TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘agpd044zj368m‘></A>agpd044zj368m</TD><TD class=‘awrc‘>insert into wrh$_system_event (snap_id,event_id,total_waits,total_timeouts,time_waited_micro) select :snap_id,time_waited_micro from v$system_event order by event_id</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘awppxms81us4n‘></A>awppxms81us4n</TD><TD class=‘awrnc‘>SELECT SUM(TIME_WAITED_MICRO) FROM DBA_HIST_SYSTEM_EVENT WHERE SNAP_ID = :B3 AND DBID = :B2 AND INSTANCE_NUMBER = :B1 AND WAIT_CLASS != ‘Idle‘</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘aykvshm7zsabd‘></A>aykvshm7zsabd</TD><TD class=‘awrc‘>select size_for_estimate,size_factor * 100 f,estd_physical_read_time,estd_physical_reads from v$db_cache_advice where id = ‘3‘</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘b2gnxm5z6r51n‘></A>b2gnxm5z6r51n</TD><TD class=‘awrnc‘>lock table sys.col_usage$ in exclusive mode nowait</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘b7jn4mf49n569‘></A>b7jn4mf49n569</TD><TD class=‘awrc‘>select o.name,u.name from obj$ o,type$ t,user$ u where o.oid$ = t.tvoid and u.user#=o.owner# and bitand(t.properties,8388608) = 8388608 and (sysdate-o.ctime) > 0.0007</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘bsa0wjtftg3uw‘></A>bsa0wjtftg3uw</TD><TD class=‘awrnc‘>select file# from file$ where ts#=:1</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘bunssq950snhf‘></A>bunssq950snhf</TD><TD class=‘awrc‘>insert into wrh$_sga_target_advice (snap_id,SGA_SIZE,SGA_SIZE_FACTOR,ESTD_DB_TIME,ESTD_PHYSICAL_READS) select :snap_id,ESTD_PHYSICAL_READS fro v$sga_target_advice</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘cfz686a6qp0kg‘></A>cfz686a6qp0kg</TD><TD class=‘awrnc‘>select o.obj#,o.name,t.spare1,DECODE(bitand(t.flags,268435456),268435456,t.initrans,t.pctfree$) from sys.obj$ o,sys.user$ u,sys.tab$ t where (bitand(t.trigflag,1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘chsyr0gssbuqf‘></A>chsyr0gssbuqf</TD><TD class=‘awrc‘>select f.file#,f.ts#,f.length from fet$ f,ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘chunmygjj8x7g‘></A>chunmygjj8x7g</TD><TD class=‘awrnc‘>SELECT OWNER,COLUMN_NAME,DATA_TYPE FROM ALL_TAB_COLUMNS WHERE OWNER = ‘SKODACOM‘ ORDER BY OWNER,TABLE_NAME</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘cqgv56fmuj63x‘></A>cqgv56fmuj63x</TD><TD class=‘awrc‘>select owner#,namespace,remoteowner,linkname,p_timestamp,p_obj#,nvl(property,0),subname,d_attrs from dependency$ d,obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘cvn54b7yz0s8u‘></A>cvn54b7yz0s8u</TD><TD class=‘awrnc‘>select /+ index(idl_ub1$ i_idl_ub11) +/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘d5bwbakqj3f79‘></A>d5bwbakqj3f79</TD><TD class=‘awrc‘>SELECT OWNER,TABLE_NAME FROM ALL_TABLES WHERE OWNER = ‘SKODACOM‘ ORDER BY OWNER</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘d92h3rjp0y217‘></A>d92h3rjp0y217</TD><TD class=‘awrnc‘>begin prvt_hdm.auto_execute( :db_id,:inst_id,:end_snap ); end;</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘f9u3p2bz694dd‘></A>f9u3p2bz694dd</TD><TD class=‘awrc‘>select count() from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and ‘Y‘ = :3)) </TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘g00cj285jmgsw‘></A>g00cj285jmgsw</TD><TD class=‘awrnc‘>update sys.mon_mods$ set inserts = inserts + :ins,updates = updates + :upd,deletes = deletes + :del,flags = (decode(bitand(flags,:flag),:flag,flags,flags + :flag)),drop_segments = drop_segments + :dropseg,timestamp = :time where obj# = :objn</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘g2wr3u7s1gtf3‘></A>g2wr3u7s1gtf3</TD><TD class=‘awrc‘>select count() from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘g337099aatnuj‘></A>g337099aatnuj</TD><TD class=‘awrnc‘>update smon_scn_time set orig_thread=0,time_mp=:1,time_dp=:2,scn=:3,scn_wrp=:4,scn_bas=:5,num_mappings=:6,tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)</TD></TR>
<TR><TD class=‘awrc‘><A class=‘awr‘ NAME=‘g6wf9na8zs5hb‘></A>g6wf9na8zs5hb</TD><TD class=‘awrc‘>insert into wrh$_sysmetric_summary (snap_id,begin_time,end_time,intsize,group_id,metric_id,num_interval,maxval,minval,average,standard_deviation) select :snap_id,begtime,endtime,intsize_csec,groupid,metricid,numintv,max,min,avg,std FROM x$kewmsmdv WHERE groupid = 2</TD></TR>
<TR><TD class=‘awrnc‘><A class=‘awr‘ NAME=‘grwydz59pu6mc‘></A>grwydz59pu6mc</TD><TD class=‘awrnc‘>select text from view$ where rowid=:1</TD></TR>
</TABLE>
<P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘23‘></A>
<H2 class=‘awr‘>
Instance Activity Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1200‘>
Instance Activity Stats
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1300‘>
Instance Activity Stats - Absolute Values
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1400‘>
Instance Activity Stats - Thread Activity
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1200‘></A>
<H3 class=‘awr‘>Instance Activity Stats</H3>
<UL>
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Statistic</TH><TH class=‘awrbg‘>Total</TH><TH class=‘awrbg‘>per Second</TH><TH class=‘awrbg‘>per Trans</TH></TR>
<TR><TD class=‘awrc‘>CPU used by this session</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6,163</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.11</TD> <TD ALIGN=‘right‘ class=‘awrc‘>42.50</TD></TR>
<TR><TD class=‘awrnc‘>CPU used when call started</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,864</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>12.86</TD></TR>
<TR><TD class=‘awrc‘>CR blocks created</TD> <TD ALIGN=‘right‘ class=‘awrc‘>57</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.39</TD></TR>
<TR><TD class=‘awrnc‘>Cached Commit SCN referenced</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>43</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.30</TD></TR>
<TR><TD class=‘awrc‘>Commit SCN cached</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD></TR>
<TR><TD class=‘awrnc‘>DB time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6,749</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.12</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>46.54</TD></TR>
<TR><TD class=‘awrc‘>DBWR checkpoint buffers written</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6,544</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.11</TD> <TD ALIGN=‘right‘ class=‘awrc‘>45.13</TD></TR>
<TR><TD class=‘awrnc‘>DBWR checkpoints</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>DBWR transaction table writes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>429</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.96</TD></TR>
<TR><TD class=‘awrnc‘>DBWR undo block writes</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,236</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.52</TD></TR>
<TR><TD class=‘awrc‘>PX local messages recv‘d</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>PX local messages sent</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>SMON posted for undo segment shrink</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD></TR>
<TR><TD class=‘awrnc‘>SQLNet roundtrips to/from client</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,059</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7.30</TD></TR>
<TR><TD class=‘awrc‘>active txn count during cleanout</TD> <TD ALIGN=‘right‘ class=‘awrc‘>407</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.81</TD></TR>
<TR><TD class=‘awrnc‘>application wait time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>background checkpoints completed</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>background checkpoints started</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>background timeouts</TD> <TD ALIGN=‘right‘ class=‘awrc‘>186,987</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.22</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,289.57</TD></TR>
<TR><TD class=‘awrnc‘>buffer is not pinned count</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>174,347</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,202.39</TD></TR>
<TR><TD class=‘awrc‘>buffer is pinned count</TD> <TD ALIGN=‘right‘ class=‘awrc‘>133,180</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.29</TD> <TD ALIGN=‘right‘ class=‘awrc‘>918.48</TD></TR>
<TR><TD class=‘awrnc‘>bytes received via SQLNet from client</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>76,373</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.32</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>526.71</TD></TR>
<TR><TD class=‘awrc‘>bytes sent via SQL*Net to client</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,402,040</TD> <TD ALIGN=‘right‘ class=‘awrc‘>24.14</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9,669.24</TD></TR>
<TR><TD class=‘awrnc‘>calls to get snapshot scn: kcmgss</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>75,641</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.30</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>521.66</TD></TR>
<TR><TD class=‘awrc‘>calls to kcmgas</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,774</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.05</TD> <TD ALIGN=‘right‘ class=‘awrc‘>19.13</TD></TR>
<TR><TD class=‘awrnc‘>calls to kcmgcs</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>670</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.62</TD></TR>
<TR><TD class=‘awrc‘>change write time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>43</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.30</TD></TR>
<TR><TD class=‘awrnc‘>cleanout - number of ktugct calls</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>451</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.11</TD></TR>
<TR><TD class=‘awrc‘>cleanouts and rollbacks - consistent read gets</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>cleanouts only - consistent read gets</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.09</TD></TR>
<TR><TD class=‘awrc‘>cluster key scan block gets</TD> <TD ALIGN=‘right‘ class=‘awrc‘>112,507</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.94</TD> <TD ALIGN=‘right‘ class=‘awrc‘>775.91</TD></TR>
<TR><TD class=‘awrnc‘>cluster key scans</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>15,721</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.27</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>108.42</TD></TR>
<TR><TD class=‘awrc‘>commit batch/immediate performed</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>commit batch/immediate requested</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>commit cleanout failures: block lost</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>commit cleanout failures: callback failure</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>51</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.35</TD></TR>
<TR><TD class=‘awrc‘>commit cleanouts</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5,571</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>38.42</TD></TR>
<TR><TD class=‘awrnc‘>commit cleanouts successfully completed</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5,520</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>38.07</TD></TR>
<TR><TD class=‘awrc‘>commit immediate performed</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>commit immediate requested</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>commit txn count during cleanout</TD> <TD ALIGN=‘right‘ class=‘awrc‘>214</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.48</TD></TR>
<TR><TD class=‘awrnc‘>concurrency wait time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>150</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.03</TD></TR>
<TR><TD class=‘awrc‘>consistent changes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>28,801</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.50</TD> <TD ALIGN=‘right‘ class=‘awrc‘>198.63</TD></TR>
<TR><TD class=‘awrnc‘>consistent gets</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>279,100</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.81</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,924.83</TD></TR>
<TR><TD class=‘awrc‘>consistent gets - examination</TD> <TD ALIGN=‘right‘ class=‘awrc‘>63,733</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>439.54</TD></TR>
<TR><TD class=‘awrnc‘>consistent gets direct</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>42</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.29</TD></TR>
<TR><TD class=‘awrc‘>consistent gets from cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>279,058</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.81</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,924.54</TD></TR>
<TR><TD class=‘awrnc‘>cursor authentications</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>54</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.37</TD></TR>
<TR><TD class=‘awrc‘>data blocks consistent reads - undo records applied</TD> <TD ALIGN=‘right‘ class=‘awrc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.40</TD></TR>
<TR><TD class=‘awrnc‘>db block changes</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>67,815</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>467.69</TD></TR>
<TR><TD class=‘awrc‘>db block gets</TD> <TD ALIGN=‘right‘ class=‘awrc‘>125,161</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>863.18</TD></TR>
<TR><TD class=‘awrnc‘>db block gets direct</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>78</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.54</TD></TR>
<TR><TD class=‘awrc‘>db block gets from cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>125,083</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.15</TD> <TD ALIGN=‘right‘ class=‘awrc‘>862.64</TD></TR>
<TR><TD class=‘awrnc‘>deferred (CURRENT) block cleanout applications</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,549</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.06</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>24.48</TD></TR>
<TR><TD class=‘awrc‘>dirty buffers inspected</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>enqueue conversions</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>31,016</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.53</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>213.90</TD></TR>
<TR><TD class=‘awrc‘>enqueue releases</TD> <TD ALIGN=‘right‘ class=‘awrc‘>415,841</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,867.87</TD></TR>
<TR><TD class=‘awrnc‘>enqueue requests</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>415,841</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7.16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,867.87</TD></TR>
<TR><TD class=‘awrc‘>enqueue waits</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>execute count</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>41,480</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.71</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>286.07</TD></TR>
<TR><TD class=‘awrc‘>free buffer inspected</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,433</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.88</TD></TR>
<TR><TD class=‘awrnc‘>free buffer requested</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9,587</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>66.12</TD></TR>
<TR><TD class=‘awrc‘>heap block compress</TD> <TD ALIGN=‘right‘ class=‘awrc‘>236</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.63</TD></TR>
<TR><TD class=‘awrnc‘>hot buffers moved to head of LRU</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.05</TD></TR>
<TR><TD class=‘awrc‘>immediate (CR) block cleanout applications</TD> <TD ALIGN=‘right‘ class=‘awrc‘>13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.09</TD></TR>
<TR><TD class=‘awrnc‘>immediate (CURRENT) block cleanout applications</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>894</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6.17</TD></TR>
<TR><TD class=‘awrc‘>index fast full scans (full)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>index fetch by key</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>48,566</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.84</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>334.94</TD></TR>
<TR><TD class=‘awrc‘>index scans kdiixs1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>49,246</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.85</TD> <TD ALIGN=‘right‘ class=‘awrc‘>339.63</TD></TR>
<TR><TD class=‘awrnc‘>leaf node 90-10 splits</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>122</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.84</TD></TR>
<TR><TD class=‘awrc‘>leaf node splits</TD> <TD ALIGN=‘right‘ class=‘awrc‘>175</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.21</TD></TR>
<TR><TD class=‘awrnc‘>lob reads</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4,455</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.08</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>30.72</TD></TR>
<TR><TD class=‘awrc‘>lob writes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,746</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>53.42</TD></TR>
<TR><TD class=‘awrnc‘>lob writes unaligned</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7,746</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>53.42</TD></TR>
<TR><TD class=‘awrc‘>logons cumulative</TD> <TD ALIGN=‘right‘ class=‘awrc‘>59</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.41</TD></TR>
<TR><TD class=‘awrnc‘>messages received</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6,069</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>41.86</TD></TR>
<TR><TD class=‘awrc‘>messages sent</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6,069</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>41.86</TD></TR>
<TR><TD class=‘awrnc‘>no buffer to keep pinned count</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>no work - consistent read gets</TD> <TD ALIGN=‘right‘ class=‘awrc‘>155,334</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.68</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,071.27</TD></TR>
<TR><TD class=‘awrnc‘>opened cursors cumulative</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9,470</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>65.31</TD></TR>
<TR><TD class=‘awrc‘>parse count (failures)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.04</TD></TR>
<TR><TD class=‘awrnc‘>parse count (hard)</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>229</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.58</TD></TR>
<TR><TD class=‘awrc‘>parse count (total)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8,895</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.15</TD> <TD ALIGN=‘right‘ class=‘awrc‘>61.34</TD></TR>
<TR><TD class=‘awrnc‘>parse time cpu</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>315</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.17</TD></TR>
<TR><TD class=‘awrc‘>parse time elapsed</TD> <TD ALIGN=‘right‘ class=‘awrc‘>330</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.28</TD></TR>
<TR><TD class=‘awrnc‘>physical read IO requests</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,218</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.40</TD></TR>
<TR><TD class=‘awrc‘>physical read bytes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12,951,552</TD> <TD ALIGN=‘right‘ class=‘awrc‘>223.04</TD> <TD ALIGN=‘right‘ class=‘awrc‘>89,321.05</TD></TR>
<TR><TD class=‘awrnc‘>physical read total IO requests</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>43,824</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.75</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>302.23</TD></TR>
<TR><TD class=‘awrc‘>physical read total bytes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>752,499,712</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12,958.85</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5,189,653.19</TD></TR>
<TR><TD class=‘awrnc‘>physical read total multi block requests</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>92</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.63</TD></TR>
<TR><TD class=‘awrc‘>physical reads</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,581</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10.90</TD></TR>
<TR><TD class=‘awrnc‘>physical reads cache</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,531</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10.56</TD></TR>
<TR><TD class=‘awrc‘>physical reads cache prefetch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>363</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.50</TD></TR>
<TR><TD class=‘awrnc‘>physical reads direct</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>50</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.34</TD></TR>
<TR><TD class=‘awrc‘>physical reads direct (lob)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.12</TD></TR>
<TR><TD class=‘awrnc‘>physical reads prefetch warmup</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>physical write IO requests</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4,880</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.08</TD> <TD ALIGN=‘right‘ class=‘awrc‘>33.66</TD></TR>
<TR><TD class=‘awrnc‘>physical write bytes</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>54,312,960</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>935.33</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>374,572.14</TD></TR>
<TR><TD class=‘awrc‘>physical write total IO requests</TD> <TD ALIGN=‘right‘ class=‘awrc‘>93,197</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.60</TD> <TD ALIGN=‘right‘ class=‘awrc‘>642.74</TD></TR>
<TR><TD class=‘awrnc‘>physical write total bytes</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,387,083,776</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>23,887.07</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9,566,095.01</TD></TR>
<TR><TD class=‘awrc‘>physical write total multi block requests</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,981</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>13.66</TD></TR>
<TR><TD class=‘awrnc‘>physical writes</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6,630</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.11</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>45.72</TD></TR>
<TR><TD class=‘awrc‘>physical writes direct</TD> <TD ALIGN=‘right‘ class=‘awrc‘>86</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.59</TD></TR>
<TR><TD class=‘awrnc‘>physical writes direct (lob)</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>78</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.54</TD></TR>
<TR><TD class=‘awrc‘>physical writes direct temporary tablespace</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>physical writes from cache</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6,544</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.11</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>45.13</TD></TR>
<TR><TD class=‘awrc‘>physical writes non checkpoint</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,092</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.53</TD></TR>
<TR><TD class=‘awrnc‘>pinned buffers inspected</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>prefetch warmup blocks aged out before use</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>prefetched blocks aged out before use</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,321</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.11</TD></TR>
<TR><TD class=‘awrc‘>recursive calls</TD> <TD ALIGN=‘right‘ class=‘awrc‘>293,416</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5.05</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,023.56</TD></TR>
<TR><TD class=‘awrnc‘>recursive cpu usage</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,700</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11.72</TD></TR>
<TR><TD class=‘awrc‘>redo blocks written</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40,432</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.70</TD> <TD ALIGN=‘right‘ class=‘awrc‘>278.84</TD></TR>
<TR><TD class=‘awrnc‘>redo buffer allocation retries</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>redo entries</TD> <TD ALIGN=‘right‘ class=‘awrc‘>37,093</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.64</TD> <TD ALIGN=‘right‘ class=‘awrc‘>255.81</TD></TR>
<TR><TD class=‘awrnc‘>redo log space requests</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>redo log space wait time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD></TR>
<TR><TD class=‘awrnc‘>redo ordering marks</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>554</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.82</TD></TR>
<TR><TD class=‘awrc‘>redo size</TD> <TD ALIGN=‘right‘ class=‘awrc‘>15,993,812</TD> <TD ALIGN=‘right‘ class=‘awrc‘>275.43</TD> <TD ALIGN=‘right‘ class=‘awrc‘>110,302.15</TD></TR>
<TR><TD class=‘awrnc‘>redo synch time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.06</TD></TR>
<TR><TD class=‘awrc‘>redo synch writes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12,625</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.22</TD> <TD ALIGN=‘right‘ class=‘awrc‘>87.07</TD></TR>
<TR><TD class=‘awrnc‘>redo wastage</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4,007,000</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>69.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>27,634.48</TD></TR>
<TR><TD class=‘awrc‘>redo write time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>562</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.88</TD></TR>
<TR><TD class=‘awrnc‘>redo writer latching time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>redo writes</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10,838</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.19</TD> <TD ALIGN=‘right‘ class=‘awrc‘>74.74</TD></TR>
<TR><TD class=‘awrnc‘>rollback changes - undo records applied</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>rollbacks only - consistent read gets</TD> <TD ALIGN=‘right‘ class=‘awrc‘>57</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.39</TD></TR>
<TR><TD class=‘awrnc‘>rows fetched via callback</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>20,094</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.35</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>138.58</TD></TR>
<TR><TD class=‘awrc‘>session cursor cache hits</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5,836</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40.25</TD></TR>
<TR><TD class=‘awrnc‘>session logical reads</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>404,261</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6.96</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,788.01</TD></TR>
<TR><TD class=‘awrc‘>session pga memory</TD> <TD ALIGN=‘right‘ class=‘awrc‘>486,792</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8.38</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3,357.19</TD></TR>
<TR><TD class=‘awrnc‘>session pga memory max</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,797,512</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>30.96</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>12,396.63</TD></TR>
<TR><TD class=‘awrc‘>session uga memory</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4,296,593,600</TD> <TD ALIGN=‘right‘ class=‘awrc‘>73,991.95</TD> <TD ALIGN=‘right‘ class=‘awrc‘>29,631,680.00</TD></TR>
<TR><TD class=‘awrnc‘>session uga memory max</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>94,606,512</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,629.23</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>652,458.70</TD></TR>
<TR><TD class=‘awrc‘>shared hash latch upgrades - no wait</TD> <TD ALIGN=‘right‘ class=‘awrc‘>49,110</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.85</TD> <TD ALIGN=‘right‘ class=‘awrc‘>338.69</TD></TR>
<TR><TD class=‘awrnc‘>sorts (memory)</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,478</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.34</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>134.33</TD></TR>
<TR><TD class=‘awrc‘>sorts (rows)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>229,737</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.96</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,584.39</TD></TR>
<TR><TD class=‘awrnc‘>sql area purged</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>summed dirty queue length</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>switch current to new buffer</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>30</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.21</TD></TR>
<TR><TD class=‘awrc‘>table fetch by rowid</TD> <TD ALIGN=‘right‘ class=‘awrc‘>65,614</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>452.51</TD></TR>
<TR><TD class=‘awrnc‘>table fetch continued row</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>175</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.21</TD></TR>
<TR><TD class=‘awrc‘>table scan blocks gotten</TD> <TD ALIGN=‘right‘ class=‘awrc‘>22,650</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.39</TD> <TD ALIGN=‘right‘ class=‘awrc‘>156.21</TD></TR>
<TR><TD class=‘awrnc‘>table scan rows gotten</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>572,074</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.85</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,945.34</TD></TR>
<TR><TD class=‘awrc‘>table scans (long tables)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>table scans (short tables)</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,380</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.52</TD></TR>
<TR><TD class=‘awrc‘>total number of times SMON posted</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD></TR>
<TR><TD class=‘awrnc‘>transaction rollbacks</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>undo change vector size</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4,400,552</TD> <TD ALIGN=‘right‘ class=‘awrc‘>75.78</TD> <TD ALIGN=‘right‘ class=‘awrc‘>30,348.63</TD></TR>
<TR><TD class=‘awrnc‘>user I/O wait time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>146</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.01</TD></TR>
<TR><TD class=‘awrc‘>user calls</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,324</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.13</TD></TR>
<TR><TD class=‘awrnc‘>user commits</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>145</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD></TR>
<TR><TD class=‘awrc‘>user rollbacks</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>workarea executions - optimal</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7,517</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>51.84</TD></TR>
<TR><TD class=‘awrc‘>write clones created in background</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>write clones created in foreground</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#23‘>Back to Instance Activity Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1300‘></A>
<H3 class=‘awr‘>Instance Activity Stats - Absolute Values</H3>
<UL>
<LI class=‘awr‘> Statistics with absolute values (should not be diffed)
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Statistic</TH><TH class=‘awrbg‘>Begin Value</TH><TH class=‘awrbg‘>End Value</TH></TR>
<TR><TD class=‘awrc‘>session cursor cache count</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,903</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8,770</TD></TR>
<TR><TD class=‘awrnc‘>opened cursors current</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>42</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>39</TD></TR>
<TR><TD class=‘awrc‘>logons current</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#23‘>Back to Instance Activity Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1400‘></A>
<H3 class=‘awr‘>Instance Activity Stats - Thread Activity</H3>
<UL>
<LI class=‘awr‘> Statistics identified by ‘(derived)‘ come from sources other than SYSSTAT
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Statistic</TH><TH class=‘awrbg‘>Total</TH><TH class=‘awrbg‘>per Hour</TH></TR>
<TR><TD class=‘awrc‘>log switches (derived)</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.06</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#23‘>Back to Instance Activity Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘24‘></A>
<H2 class=‘awr‘>
IO Stats
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1700‘>
Tablespace IO Stats
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1800‘>
File IO Stats
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1700‘></A>
<H3 class=‘awr‘>Tablespace IO Stats</H3>
<UL>
<LI class=‘awr‘> ordered by IOs (Reads + Writes) desc
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Tablespace</TH><TH class=‘awrbg‘>Reads</TH><TH class=‘awrbg‘>Av Reads/s</TH><TH class=‘awrbg‘>Av Rd(ms)</TH><TH class=‘awrbg‘>Av Blks/Rd</TH><TH class=‘awrbg‘>Writes</TH><TH class=‘awrbg‘>Av Writes/s</TH><TH class=‘awrbg‘>Buffer Waits</TH><TH class=‘awrbg‘>Av Buf Wt(ms)</TH></TR>
<TR><TD class=‘awrc‘>SYSAUX</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>130</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.69</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.53</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3,008</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>SYSTEM</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>237</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.39</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.11</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>881</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>UNDOTBS1</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>986</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>SKODACOM</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>849</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.98</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.04</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>EBUY_USER</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>PEICHE</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#24‘>Back to IO Stats</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1800‘></A>
<H3 class=‘awr‘>File IO Stats</H3>
<UL>
<LI class=‘awr‘> ordered by Tablespace,File
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Tablespace</TH><TH class=‘awrbg‘>Filename</TH><TH class=‘awrbg‘>Reads</TH><TH class=‘awrbg‘>Av Reads/s</TH><TH class=‘awrbg‘>Av Rd(ms)</TH><TH class=‘awrbg‘>Av Blks/Rd</TH><TH class=‘awrbg‘>Writes</TH><TH class=‘awrbg‘>Av Writes/s</TH><TH class=‘awrbg‘>Buffer Waits</TH><TH class=‘awrbg‘>Av Buf Wt(ms)</TH></TR>
<TR><TD class=‘awrc‘>EBUY_USER</TD> <TD class=‘awrc‘>/u01/oradata/skodacom/ebuy_user01.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>PEICHE</TD> <TD class=‘awrnc‘>/u01/oradata/skodacom/peiche_data_file1.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>SKODACOM</TD> <TD class=‘awrc‘>/u01/oradata/skodacom/skodacom_user01.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>695</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.88</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.05</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>SKODACOM</TD> <TD class=‘awrnc‘>/u01/oradata/skodacom/skodacom_user02.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>120</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.58</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>SKODACOM</TD> <TD class=‘awrc‘>/u01/oradata/skodacom/skodacom_user03.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>34</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.88</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>SYSAUX</TD> <TD class=‘awrnc‘>/u01/oradata/skodacom/sysaux.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>130</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.69</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.53</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,008</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>SYSTEM</TD> <TD class=‘awrc‘>/u01/oradata/skodacom/system.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>237</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.39</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.11</TD> <TD ALIGN=‘right‘ class=‘awrc‘>881</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>UNDOTBS1</TD> <TD class=‘awrnc‘>/u01/oradata/skodacom/undotbs1.dbf</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>986</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#24‘>Back to IO Stats</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘1900‘></A>
<H3 class=‘awr‘>Buffer Pool Statistics</H3>
<UL>
<LI class=‘awr‘> Standard block size Pools D: default,K: keep,R: recycle
<LI class=‘awr‘> Default Pools for other block sizes: 2k,4k,8k,16k,32k
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>P</TH><TH class=‘awrbg‘>Number of Buffers</TH><TH class=‘awrbg‘>Pool Hit%</TH><TH class=‘awrbg‘>Buffer Gets</TH><TH class=‘awrbg‘>Physical Reads</TH><TH class=‘awrbg‘>Physical Writes</TH><TH class=‘awrbg‘>Free Buff Wait</TH><TH class=‘awrbg‘>Writ Comp Wait</TH><TH class=‘awrbg‘>Buffer Busy Waits</TH></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>105,152</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100</TD> <TD ALIGN=‘right‘ class=‘awrc‘>404,709</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,532</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6,544</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD></TR>
</TABLE><P>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘26‘></A>
<H2 class=‘awr‘>
Advisory Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#2000‘>
Instance Recovery Stats
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#2100‘>
Buffer Pool Advisory
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#2400‘>
PGA Aggr Summary
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#2600‘>
PGA Aggr Target Stats
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#2700‘>
PGA Aggr Target Histogram
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#2800‘>
PGA Memory Advisory
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#5500‘>
Shared Pool Advisory
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6900‘>
SGA Target Advisory
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#7100‘>
Streams Pool Advisory
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#5700‘>
Java Pool Advisory
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘2000‘></A>
<H3 class=‘awr‘>Instance Recovery Stats</H3>
<UL>
<LI class=‘awr‘> B: Begin snapshot,E: End snapshot
</UL>
<TABLE BORDER=1><TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>Targt MTTR (s) </TH><TH class=‘awrbg‘>Estd MTTR (s)</TH><TH class=‘awrbg‘>Recovery Estd IOs</TH><TH class=‘awrbg‘>Actual Redo Blks</TH><TH class=‘awrbg‘>Target Redo Blks</TH><TH class=‘awrbg‘>Log File Size Redo Blks</TH><TH class=‘awrbg‘>Log Ckpt Timeout Redo Blks</TH><TH class=‘awrbg‘>Log Ckpt Interval Redo Blks </TH></TR>
<TR><TD class=‘awrc‘>B</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7</TD> <TD ALIGN=‘right‘ class=‘awrc‘>163</TD> <TD ALIGN=‘right‘ class=‘awrc‘>173</TD> <TD ALIGN=‘right‘ class=‘awrc‘>878</TD> <TD ALIGN=‘right‘ class=‘awrc‘>184320</TD> <TD ALIGN=‘right‘ class=‘awrc‘>878</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>E</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>169</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>431</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6306</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>184320</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6306</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘2100‘></A>
<H3 class=‘awr‘>Buffer Pool Advisory</H3>
<UL>
<LI class=‘awr‘> Only rows with estimated physical reads >0 are displayed
<LI class=‘awr‘> ordered by Block Size,Buffers For Estimate
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>P</TH><TH class=‘awrbg‘>Size for Est (M)</TH><TH class=‘awrbg‘>Size Factor</TH><TH class=‘awrbg‘>Buffers for Estimate</TH><TH class=‘awrbg‘>Est Phys Read Factor</TH><TH class=‘awrbg‘>Estimated Physical Reads</TH></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>80</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.09</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9,920</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.12</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,723,336</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>160</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.19</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,840</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.10</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,663,197</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>240</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.28</TD> <TD ALIGN=‘right‘ class=‘awrc‘>29,760</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.08</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,629,478</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>320</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.38</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>39,680</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.06</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,582,075</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>400</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>49,600</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,505,137</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>480</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.57</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>59,520</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,456,910</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>560</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.66</TD> <TD ALIGN=‘right‘ class=‘awrc‘>69,440</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,444,051</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>640</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.75</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>79,360</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,426,428</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>720</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.85</TD> <TD ALIGN=‘right‘ class=‘awrc‘>89,280</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,061</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>800</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.94</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>99,200</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,425,878</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>848</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>105,152</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,878</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>880</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.04</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>109,120</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,878</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>960</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>119,040</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,878</TD></TR>
<TR><TD class=‘awrnc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,040</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.23</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>128,960</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,878</TD></TR>
<TR><TD class=‘awrc‘>D</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,120</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.32</TD> <TD ALIGN=‘right‘ class=‘awrc‘>138,880</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,200</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.42</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>148,800</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,280</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.51</TD> <TD ALIGN=‘right‘ class=‘awrc‘>158,720</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,360</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.60</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>168,640</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,440</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.70</TD> <TD ALIGN=‘right‘ class=‘awrc‘>178,560</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,520</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.79</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>188,480</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,600</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.89</TD> <TD ALIGN=‘right‘ class=‘awrc‘>198,400</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,416,287</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘2400‘></A>
<H3 class=‘awr‘>PGA Aggr Summary</H3>
<UL>
<LI class=‘awr‘> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>PGA Cache Hit %</TH><TH class=‘awrbg‘>W/A MB Processed</TH><TH class=‘awrbg‘>Extra W/A MB Read/Written</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>237</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘2600‘></A>
<H3 class=‘awr‘>PGA Aggr Target Stats</H3>
<UL>
<LI class=‘awr‘> B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
<LI class=‘awr‘> Auto PGA Target - actual workarea memory target
<LI class=‘awr‘> W/A PGA Used - amount of memory used for all Workareas (manual + auto)
<LI class=‘awr‘> %PGA W/A Mem - percentage of PGA memory allocated to workareas
<LI class=‘awr‘> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
<LI class=‘awr‘> %Man W/A Mem - percentage of workarea memory under manual control
</UL>
<TABLE BORDER=1><TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>PGA Aggr Target(M)</TH><TH class=‘awrbg‘>Auto PGA Target(M)</TH><TH class=‘awrbg‘>PGA Mem Alloc(M) </TH><TH class=‘awrbg‘>W/A PGA Used(M) </TH><TH class=‘awrbg‘>%PGA W/A Mem</TH><TH class=‘awrbg‘>%Auto W/A Mem</TH><TH class=‘awrbg‘>%Man W/A Mem</TH><TH class=‘awrbg‘>Global Mem Bound(K)</TH></TR>
<TR><TD class=‘awrc‘>B</TD> <TD ALIGN=‘right‘ class=‘awrc‘>234</TD> <TD ALIGN=‘right‘ class=‘awrc‘>167</TD> <TD ALIGN=‘right‘ class=‘awrc‘>104.32</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>47,841</TD></TR>
<TR><TD class=‘awrnc‘>E</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>234</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>167</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>104.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>47,841</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘2700‘></A>
<H3 class=‘awr‘>PGA Aggr Target Histogram</H3>
<UL>
<LI class=‘awr‘> Optimal Executions are purely in-memory operations
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘> Low Optimal</TH><TH class=‘awrbg‘> High Optimal</TH><TH class=‘awrbg‘>Total Execs</TH><TH class=‘awrbg‘>Optimal Execs</TH><TH class=‘awrbg‘>1-Pass Execs</TH><TH class=‘awrbg‘>M-Pass Execs</TH></TR>
<TR><TD class=‘awrc‘>2K</TD> <TD class=‘awrc‘>4K</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,220</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,220</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>64K</TD> <TD class=‘awrnc‘>128K</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>54</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>54</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>128K</TD> <TD class=‘awrc‘>256K</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>512K</TD> <TD class=‘awrnc‘>1024K</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>206</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>206</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>1M</TD> <TD class=‘awrc‘>2M</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘2800‘></A>
<H3 class=‘awr‘>PGA Memory Advisory</H3>
<UL>
<LI class=‘awr‘> When using Auto Memory Mgmt,minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>PGA Target Est (MB)</TH><TH class=‘awrbg‘>Size Factr</TH><TH class=‘awrbg‘>W/A MB Processed</TH><TH class=‘awrbg‘>Estd Extra W/A MB Read/ Written to Disk </TH><TH class=‘awrbg‘>Estd PGA Cache Hit %</TH><TH class=‘awrbg‘>Estd PGA Overalloc Count</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>29</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>493.61</TD> <TD ALIGN=‘right‘ class=‘awrc‘>84.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.25</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>290.49</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>90.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>117</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.50</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>61.76</TD> <TD ALIGN=‘right‘ class=‘awrc‘>98.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>175</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.75</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>234</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>280</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.20</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>327</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.40</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>374</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.60</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>420</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.80</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>467</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>701</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>934</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1,402</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1,869</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,595.47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘5500‘></A>
<H3 class=‘awr‘>Shared Pool Advisory</H3>
<UL>
<LI class=‘awr‘> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
<LI class=‘awr‘> Note there is often a 1:Many correlation between a single logical object
in the Library Cache,and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache),with the number of Lib Cache Memory Objects is invalid.
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Shared Pool Size(M)</TH><TH class=‘awrbg‘>SP Size Factr</TH><TH class=‘awrbg‘>Est LC Size (M)</TH><TH class=‘awrbg‘>Est LC Mem Obj</TH><TH class=‘awrbg‘>Est LC Time Saved (s)</TH><TH class=‘awrbg‘>Est LC Time Saved Factr</TH><TH class=‘awrbg‘>Est LC Load Time (s)</TH><TH class=‘awrbg‘>Est LC Load Time Factr</TH><TH class=‘awrbg‘>Est LC Mem Obj Hits</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>144</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.53</TD> <TD ALIGN=‘right‘ class=‘awrc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,651</TD> <TD ALIGN=‘right‘ class=‘awrc‘>785</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.99</TD> <TD ALIGN=‘right‘ class=‘awrc‘>69</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>462,980</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>176</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.65</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>66</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5,481</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>788</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.99</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>66</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.12</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>468,081</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>208</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.76</TD> <TD ALIGN=‘right‘ class=‘awrc‘>97</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,673</TD> <TD ALIGN=‘right‘ class=‘awrc‘>795</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>59</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>473,154</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>240</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.88</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>128</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10,038</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>795</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>59</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>473,713</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>272</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>159</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12,385</TD> <TD ALIGN=‘right‘ class=‘awrc‘>795</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>59</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>473,815</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>304</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.12</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>190</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>14,665</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>795</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>59</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>473,823</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>336</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.24</TD> <TD ALIGN=‘right‘ class=‘awrc‘>221</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16,921</TD> <TD ALIGN=‘right‘ class=‘awrc‘>796</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.98</TD> <TD ALIGN=‘right‘ class=‘awrc‘>473,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>368</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.35</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17,777</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>796</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.98</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>473,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>400</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17,777</TD> <TD ALIGN=‘right‘ class=‘awrc‘>796</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.98</TD> <TD ALIGN=‘right‘ class=‘awrc‘>473,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>432</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.59</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>464</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.71</TD> <TD ALIGN=‘right‘ class=‘awrc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>496</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.82</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>528</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.94</TD> <TD ALIGN=‘right‘ class=‘awrc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17,851</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>560</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.06</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17,851</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘6900‘></A>
<H3 class=‘awr‘>SGA Target Advisory</H3>
<UL>
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>SGA Target Size (M)</TH><TH class=‘awrbg‘>SGA Size Factor</TH><TH class=‘awrbg‘>Est DB Time (s)</TH><TH class=‘awrbg‘>Est Physical Reads</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>292</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.25</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,502</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,291</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>584</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.50</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,197</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,204</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>876</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.75</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,078</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,363</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1,168</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,076</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,878</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1,460</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.25</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,076</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,878</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1,752</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.50</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,070</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,174</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>2,044</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.75</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,062</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,174</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>2,336</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,062</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,174</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#26‘>Back to Advisory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘7100‘></A>
</TABLE><P>
<H3 class=‘awr‘>Streams Pool Advisory</H3> （编辑：核心网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
