is "Total System Global Area" in oracle reflecting actual system memory used??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: is "Total System Global Area" in oracle reflecting actual system memory used??

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    is "Total System Global Area" in oracle reflecting actual system memory used??

    hi,

    I have try to figure exactly how much when oracle DB is started....i perform a "show sga" : "Total System Global Area is 8.2MB" but when i actually shut it down...the system free memory difference b4 and after is "19.6M" ...how is that so??

    How can I get a gd gauge of the memory Oracle will use???

    any comments ??

    thanks in advance.
    ngwh,
    Singapore.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    The memory used also depends on the number of server processes created for the user connections (user process) to the database.

    HTH.

  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi ggna,

    thanks for your feedback...so in that sense there will be effectively no control to the user connection which will cause system memory to increase unless we control the user processes thru oracle system init parameter right???

    thanks

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