session PGA memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: session PGA memory

  1. #1
    Join Date
    May 2006
    Posts
    1

    session PGA memory

    Hi,

    We are running the server in MTS / shared server - version is oracle 8.1.7.4.1

    When I login to the db i.e either SQLPLUS or TOAD, the TOAD session takes around 11MB of session PGA memory, and the SQLPLUS session takes 2MB. Is there any parameter impact with this?. These connected sessions are just idle but still it takes 11mb and 2mb.

    Please let me know what is the relation with the size?. And today I observed that login to the SQLPLUS (just connected to db and it is idle), this session PGA memory

    It has taken nearly 9 MB. The same thing is happening for the aspnet_wp.exe sessions. For more info you can refer the excel sheet which I sent you yesterday.



    Thanks and Regards

    Venkatesh

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    how are you calculating these numbers - and what spreadsheet? You didnt post anything here yesterday

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    It is bound to depend a lot on the TOAD start-up options.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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