Is there any ThumbRule for Shared Pool calculation ?

From: satish p <satish.pullela_at_wipro.com>
Date: Sun, 29 Jul 2001 23:41:40 -0700
Message-ID: <F001.00358A41.20010729233541@fatcity.com>

Hi Folks,

For Oracle Version 8.1.0 and above, Is there any Shared Pool calculation for Concurrent users >100? Oracle running in Dedicated mode.

The below mentioned is Shared pool calculation for Oracle ver 7.x Server running in Dedicated mode.

Formula

Max Session Memory * No. of concurrent users

+ Total Shared SQL Area Usage

+ PLSQL Sharable Memory

+ Minimum 30% Free Space

Is something like this available for Version 8.1.0 and above?

Regards
Satish Received on Mon Jul 30 2001 - 01:41:40 CDT