data dicitonary hit ratio
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: data dicitonary hit ratio

  1. #1
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    data dicitonary hit ratio

    data dicitonary hit ratio is varying recently from 50% to 75 % on one of our database (oracle 817 on Sun solaris). Its recently Started doing that and I 'm the backup dba for this database. Not sure exactly whats going on. Its seems the extents on tablesspaces, tables are created randomly.

    Most of my miss ratio is on tablespace extents, segments etc. Objects with randomly created storage options cause this much problem ??? Any ideas ? Is this pretty common ?
    Reddy,Sam

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    +

    Dynamic allocation of extents, non cached sequences..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width