Re: Session memory usage

From: <sybrandb_at_yahoo.com>
Date: 28 Jul 2004 07:18:39 -0700
Message-ID: <a1d154f4.0407280618.41443c93@posting.google.com>

fredrik_bertilsson_at_passagen.se (Fredrik Bertilsson) wrote in message news:<31f7e57d.0407280201.26084b99_at_posting.google.com>...
> Hi,
> does someone know how much memory a user session takes on a Oracle
> database server? How many concurrent user sessions can a normal server
> (4 GB primary memory) handle, before connection pooling is needed?
>
> /Fredrik

Memory consumption is tracked in v$sesstat. Join with v$statname and look for 'session pga memory' and 'session uga memory'. Uga is usually some 400k, pga can be huge.

The rest of your question is platform dependent. On Winblows you usually run into problems with 4G with about 200 sessions
(speaking from experience), when not using Multithreaded Server.

Connection pooling is dependent on MTS, you would need to enable MTS first.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Wed Jul 28 2004 - 09:18:39 CDT