variable size in SGA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: variable size in SGA

Hybrid View

  1. #1
    Join Date
    Aug 2001
    Posts
    56

    Angry

    Hi
    from the svrmgr prompt
    svrmgr>show sga
    it shows
    Total system global area: 715053084
    fixed size: 75804
    variable size: 244789248
    Database buffer: 459694080
    Redo Buffers: 10493952

    I want to decrease my SgA size:


    sga size should not be greater than 2/3 of physical memory. my server windows Nt meory is 1 GB.
    what includes fixed size,vraibale size. and database buffer size. my database buffer size is also high.

    pls tell me how to find each and every thing for sga details.

    Thanks
    Anuj
    Anuj
    India

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    SELECT * FROM V$SGASIZE;

    Everything which SHARED_POOL is variable size
    The FIXED_SIZE is space used for some small Oracle processes. The rest is pretty much self expalitory.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by grjohnson
    SELECT * FROM V$SGASIZE;

    Everything which SHARED_POOL is variable size
    The FIXED_SIZE is space used for some small Oracle processes. The rest is pretty much self expalitory.

    Cheers,
    V$SGASIZE ???

    Let me correct you about the fixed area. It contains atomic variables: latches, pointers into other areas of the SGA. They can be found in X$KSMFSV. These variables (their names) are cryptic and non-important (for me and you).


  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    That's what I like about you Julian, you cut like a spoon...i.e. blunt...

    "latches, pointers into other areas of the SGA"... and what I said was "small Oracle processes"... hence latches, pointers.

    and YES, you are correct, it's not v$SGASIZE... sorry....

    V$SGASTAT.....

    Okay, are we happy now?

    Cheers

    [Edited by grjohnson on 10-11-2001 at 02:38 AM]
    OCP 8i, 9i DBA
    Brisbane Australia

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    :-))

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