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

Thread: v$sgastat

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    v$sgastat

    Can somebody explain the missing values in the query below that add
    up to about 96M

    FYI
    $ grep pool spfilepbh1020.ora
    *.java_pool_size=31457280
    *.large_pool_size=8388608
    *.shared_pool_size=153431142

    SQL> select pool, bytes from v$sgastat;

    POOL BYTES
    ------------ ----------
    1978176
    92274688
    6406144
    shared pool 11704
    shared pool 3704
    shared pool 807488
    shared pool 1928
    ....
    ....
    ...
    large pool 8388608
    java pool 33554432

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    And how did you calculate the missing values?
    why don't u execute this query instead?

    select pool,sum(bytes)/(1024*1024) from v$sgastat group by pool
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    I think your missing the point to my question, I want to know what "pool"
    these numbers are associated with.

    As you see I say select pool, bytes from v$sgastat; the first 3 numbers come
    back without a "pool". I want to know if this is an indication if anything is wrong

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    I think that should be buffer cache value.
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Log into sqlplus and do: show sga

    You are gonna find your values represent: Fixed size, Database buffers and, Redo buffers.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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