session uga memory and session pga memory under dedicated server mode !!
510293Jul 24 2007 — edited Jul 25 2007Hi, all.
The database is running under dedicated server mode.
And pga_aggregate_target is enabled.
I am wondering how memory is allocated when a connection is made.
When a connection is made, a server process is created on the server.
I can see the following value in the v$sesstat.
- session pga memory
- session pga memory max
- session uga memory
- session uga memory max
1. question1
"session pga memory + session uga memory" is the size of memory
that is currently allocated to the server process?
2. question2
session pga memory is part of pga_aggregate_target?
3. question3
session uga memory is allocated outside sga and pga?
Thanks and Regards.
Message was edited by:
user507290
Message was edited by:
user507290