Oracle Memory usage estimation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Memory usage estimation

  1. #1
    Join Date
    Mar 2000
    Location
    Hong Kong
    Posts
    10

    Wink Oracle Memory usage estimation


    Any formula or good document for memory usgae estimation of Oracle 9i Database server (such as PGA/SGA memory usage, memory for dictinonary/library cache, NET connection, SQL connection, ...) ???

    Many thanks !!!
    Shirley

  2. #2
    Join Date
    Apr 2001
    Posts
    110
    Hi,

    Check out this script... maybe it'll help.

    SET LINESIZE 145
    SET PAGESIZE 9999
    SET FEEDBACK off
    SET VERIFY off

    COLUMN bytes FORMAT 999,999,999,999
    COLUMN percent FORMAT 999.99999

    break on report

    compute sum of bytes on report
    compute sum of percent on report

    SELECT
    a.name
    , a.bytes
    , a.bytes/(b.sum_bytes*100) Percent
    FROM sys.v_$sgastat a
    , (SELECT SUM(value)sum_bytes FROM sys.v_$sga) b
    ORDER BY bytes DESC
    /

    Cheers
    Oracbase
    What's next after 10g?

  3. #3
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    I think the query should be like this:

    SELECT
    a.name
    , a.bytes
    , (a.bytes/b.sum_bytes)*100 Percent
    FROM sys.v_$sgastat a
    , (SELECT SUM(value)sum_bytes FROM sys.v_$sga) b
    ORDER BY bytes DESC;


    -Raja

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