skip to main | skip to sidebar

ORACLE DOCS

Monday, 7 July 2008

blocks that reside in the buffer_cache

select o.object_name,count(*) number_of_blocks
from dba_objects o, V$BH bh
where o.data_object_id=bh.objd
and o.owner!='SYS'
group by o.object_name
order by count(*) desc



Hit ratio:
select name,physical_reads,db_block_gets,consistent_gets,1-(physical_reads/(db_block_gets+consistent_gets))"HIT RATIO" from v$buffer_pool_statistics
Posted by tjay at 05:00

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2008 (33)
    • ▼  July (33)
      • loading objects into shared pool
      • sga components used,free
      • log sequence number
      • statspack
      • sql_trace
      • schedules
      • job scripts
      • flashback scripts
      • PARALLELISM rman
      • Block number of the row
      • recovery question
      • blocks that reside in the buffer_cache
      • Hit Ratios
      • archivelog destination
      • DBWR and LGWR
      • database buffer cache, library cache
      • changing global_name
      • append and parallel hints, nologging
      • snapshot too old
      • enterprise manager
      • shrink_me
      • number of rows per block
      • shrink,alter table move,deallocate unused
      • corrupt blocks
      • droping all user_objects
      • redo scripts
      • rman scripts
      • tablespace usage
      • temp tablespace scripts
      • undo_retention
      • Some useful unix commands
      • Changing username
      • Rman scenerios

About Me

My photo
tjay
View my complete profile