Take a look at v$sesstat for the statistics on pga and
uga memory used
hth
connor
- Hussain Ahmed Qadri <hussain_at_skm.org.pk> wrote: >
Hi all,
>
> Can anyone tell me what is the memory any session
> takes when it logs on to
> the database? That's is, when a person opens a SQL
> plus window, how much
> memory is allocated to that session (just opening it
> and then the session is
> idle). And when he performs certain query, which
> returns over a few thousand
> records or more, what is the effect on the memory
> usage of that session. Any
> guidelines perhaps?
>
> Regards,
>
> DBA
> SKMCH&RC
>
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
Received on Sat Mar 22 2003 - 02:55:35 CST