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

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 12 Aug 2004 20:07:15 +0200
Message-ID: <3ccnh0dtoh9q1oa0fhrc705nlqejgfopal@4ax.com>

On Thu, 12 Aug 2004 18:28:55 +0200, "Christian Antognini" <christian.antognini_at_trivadis.com> wrote:

>**** Post for FREE via your newsreader at post.usenet.com ****
>
>Hi Sybrand
>
>> I spot a cartesian product between v$sgastat and v$parameter.
>
>Since only one row is selected from each view, this is not the problem....
>
>
>Chris

Sorry to say so, but you are incorrect. Multiple records are selected from v$sgastat, as the shared pool is broken down in several components. The condition read != 'free memory'

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Aug 12 2004 - 13:07:15 CDT