Shared Pool cache Hit % ratio!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Shared Pool cache Hit % ratio!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    I have a query:

    1.How should we tune SHARED_POOL_SIZE cache Hit ratio!
    What should be the Percentage of cache Hit ratio for SHARED
    pool.

    Is there any particular select query for it!

    2.Would deleting innumerable Trace files occupying unnecessary disk space create any impact on the Production/development Database!

    3.Does configuring SHARED_POOL_SIZE automatically allocates required memory to Data Dictionary cache,Library Cache,Shared Sql Area!

    Thanks&Regards,

    Amitst.

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    Q(1)
    read metalink doc 16347.1
    Q(2)
    if auto extend is on for ur tablespaces and they are acquiring space as and when required and the datafile resides on the same drive/volume where the junk trace is growing relentlessly u shall have a fragmented tablespace impacting performance as many pieces are to be accessed on the disk.
    Q(3)
    yes
    sonofsita
    http://www.ordba.net

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