Re: Shared Pool: Can it be filled *over* 100% ?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 12 Aug 2004 20:09:33 +0200
Message-ID: <bgcnh0140tcjd89nb8mumr1lcs0639om1n@4ax.com>

On Thu, 12 Aug 2004 15:38:29 +0200, "Christian Antognini" <christian.antognini_at_trivadis.com> wrote:

>In many situations Oracle allocates more memory than specified by the
>INIT.ORA parameters. Therefore this formula makes no sense, or at least
>should be used with care... A plain select on V$SGASTAT is better...

The query is just plain wrong, as I have demonstrated earlier today. Multiple records will be selected from v$sgastat, except the 'free memory' record. Those records will be summed *after* the cartesian product with v$parameter has been determined. Try it yourself.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Aug 12 2004 - 13:09:33 CDT