DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Instance size

  1. #1
    Join Date
    Nov 2000
    Posts
    3

    Smile

    Hi,

    Im sure this is an easy one for an experienced dba, but i need to find the size of an instance, ive looked at v$sga this tells me fixed size, variable size, database buffers, redo buffers but i do not know if this is enough, is there a query i can do to get a reasonable indication of the size of an instance?

    Thanks
    Aidan.

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Check:
    1. buffer cache hit ratio
    2. library cache hit ratio
    3. ratio of sorts in memory to disk
    The higher the values, the better. If they are low, consider increasing the repective parameters in init.ora. You should be able to find these scripts in the DBA HAndbook.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    V$SGASTAT will give more info.

  4. #4
    In NT you should add bytes for each connection, ORACLE.EXE gets bigger and bigger.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  5. #5
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    in SVRMGRL do
    show sga

    that will give you total size of SGA as well as the variable size, fixed size etc that you saw in V$SGA.

    Hope this is what you're looking for.

  6. #6
    Join Date
    Nov 2000
    Posts
    3

    Thumbs up

    Thats great, thanks everyone, especially maachan, youve all been very helpful.

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