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

how are you calculating these numbers - and what spreadsheet? You didnt post anything here yesterday

It is bound to depend a lot on the TOAD start-up options.