How to calculate the utilization of SGA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to calculate the utilization of SGA

  1. #1
    Join Date
    Jan 2003
    Posts
    9

    How to calculate the utilization of SGA

    Hi!!

    how to calculate the utilization of the SGA, like utilization of "Data buffer cache", "Redo Log Buffer", "Library cache" and "Data dict. cache"??

    help me...thanks

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    You could use some tools like dbtools for SGA utilization. You can download a evaluation at:
    http://www.softtreetech.com/

  3. #3
    Join Date
    Jan 2003
    Posts
    9

    Smile

    thank you, ggnanaraj...

    But, I need the script or formula to calculate the utilization(ex. from the V$ tables)??

    Do you have other idea about it??

    thanks...

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    v$sgastat
    Agasimani
    OCP(10g/9i/8i/8)

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