Re: Session memory usage

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 28 Jul 2004 21:18:07 +0100
Message-ID: <410809d8$0$6451$cc9e4d1f@news-text.dial.pipex.com>

<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0407280618.41443c93_at_posting.google.com...
> 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.

Windows process space for Oracle (on indeed any other process) is limited to circa 1.7gb. allocate 1.6gb to SGA and the limit is a lot less, set it at 24mb and you can probably have an awful lot of very slow sessions.

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

unless a mid-tier does it for you, in which case MTS would be somewhat daft (and therefore is almost certainly implemented somewhere).

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Wed Jul 28 2004 - 15:18:07 CDT