Re: Memory Problem

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 May 2005 06:28:46 -0700
Message-ID: <1115040526.740592.71560@z14g2000cwz.googlegroups.com>

There are several different memory areas associated with Oracle databases and sessions. Which one you look at depends on what you are interested in and why.

For information about memory being used in the shared pool by stored procedures, functions, and packages try looking at v$db_object_cache.

For overall numbers on the shared pool look at v$sga and v$sgastat.

See the Oracle version# Reference manual for information on the mentioned views.

HTH -- Mark D Powell -- Received on Mon May 02 2005 - 08:28:46 CDT