Home » RDBMS Server » Server Administration » How much space will take Per session.
How much space will take Per session. [message #64019] Mon, 06 December 2004 19:52 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Dear frends,

I wanted to know How much space is reqd for oracle server to establish one session.

Thax,

Bhavin..

 

 
Re: How much space will take Per session. [message #64042 is a reply to message #64019] Wed, 08 December 2004 16:23 Go to previous message
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
Previous Topic: Database Link Issue
Next Topic: Installing Oracle 9i/8i in UNIX/SOLARIS
Goto Forum:
  


Current Time: Fri Jan 24 23:26:47 CST 2025