|
Re: How much space will take Per session. [message #64042 is a reply to message #64019] |
Wed, 08 December 2004 16:23 |
Frank Naude
Messages: 4587 Registered: April 1998
|
Senior Member |
|
|
Hi,
It depends on your system and parameter settings. Why
don't you just start a session and see how much
memory was allocated to the process? Alternatively,
look at the PGA statistics provided in
V$SYSSTAT/ V$SESSTAT. In Oracle 9i and 10g you can
also get this info from V$PROCESS (PGA_USED_MEM,
PGA_ALLOCATED_MEM and PGA_MAX_MEM columns).
Best regards.
Frank
|
|
|