total system global area different
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: total system global area different

  1. #1
    Join Date
    Jan 2005
    Posts
    221

    total system global area different

    Hi all,


    the total of my SGA is 126590924 bytes, but when I look into the memory on the OS, it allocated more than this figure, I was wondering why????

    thanks so much

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    post what you are actually looking at.

    Not all memory usuage is part of the sga

  3. #3
    Join Date
    Jan 2005
    Posts
    221
    SQL> show sga

    Total System Global Area 126590924 bytes
    Fixed Size 454604 bytes
    Variable Size 100663296 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 307200 bytes
    SQL>





    when I look into task manager, I saw that this database took 154,440K

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    pga memory

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