Re: Finding where Oracle is consuming memory

From: Forte Agent <1443131_at_usenetplanet.com>
Date: Thu, 06 May 2004 21:37:05 -0400
Message-ID: <f1ql90lc3pp5r6h3o2e5a52ag7fgrimv1l@4ax.com>

On Wed, 5 May 2004 21:44:20 +0100, "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote:

>I suspect the answer is Oracle version and or parameter dependent.
>
>The instance and all processes connecting to the db will use memory - the
>sga is just one component of the memory usage of the server. Give us a clue
>
>what Oracle version?
>
>sort_area_size and retained size, number of sessions, pga_aggregate_target
>etc etc.

Sorry, It is 9.2.0.4. Received on Thu May 06 2004 - 20:37:05 CDT