Cook Book for recycle pool

I will later transform this in a PL/SQL

select
‘ALTER TABLE ‘||OBJECT_NAME||’ STORAGE (BUFFER_POOL RECYCLE);’
from (
SELECT * FROM (
SELECT OBJECT_NAME,VALUE,blocks,value/blocks val_blocks FROM V$SEGMENT_STATISTICS t1,
dba_segments t2
WHERE t1.OWNER=’MANAGER’ and t2.OWNER=’MANAGER’ AND
STATISTIC_NAME=’logical reads’
and segment_name=object_name
and segment_type=’TABLE’
and blocks<100000
and value>10
order by 4) where rownum<840)

DBA 102: Beyond the basics

By Michael J. Hillenbrand
http://searchoracle.techtarget.com/tip/0,289483,sid41_gci1261659,00.html?Offer=ORint807dba

Five ways to prepare for a SOX audit

By Michael Hillenbrand

http://searchoracle.techtarget.com/tip/0,289483,sid41_gci1266605,00.html?track=NL-390&ad=600115&asrc=EM_NLT_2001770

Objects to put in keep buffer

This  is a cook book that i created yesterday, so objects with high val_block is a candidate to this area.

But be in mind that the objects must be SMALL

SELECT * FROM (

SELECT OBJECT_NAME,VALUE,blocks,value/blocks val_block FROM
V$SEGMENT_STATISTICS t1,
dba_segments t2
WHERE t1.OWNER=’&schema’ and t2.OWNER=t1.owner AND
STATISTIC_NAME=’logical reads’
and segment_name=object_name
and blocks<1280
and value>100000
order by 4 desc)

For more information about buffer pool : http://jonathanlewis.wordpress.com/2007/09/05/hit-ratios-2/