Re: Finding where Oracle is consuming memory

From: Joel Garry <joel-garry_at_home.com>
Date: 5 May 2004 15:35:22 -0700
Message-ID: <91884734.0405051435.684edbbb@posting.google.com>

Forte Agent <1443131_at_usenetplanet.com> wrote in message news:<67ai90huiiq0od6r0tcbnqsbo0097r3s4c_at_4ax.com>...
> We have a HP/UX server that has about 500MB of free memory when
> database runs. If this database is shutdown, it reports having 1500MB
> of free memory. So we can conclude this database instance consumes
> about 1GB of memory. We know this database has about 500MB of SGA.
> So where is the rest of memory going? PGA? How can we find detailed
> report of which component is consuming how much memory among this 1GB?
> Thank you in advance.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=148466.1 is a pretty good reference, if strangely formatted.

--
@home.com is bogus.
http://www.autoweek.com/specials/galleries/chaparral/pages/Chaparral-071.htm

Received on Wed May 05 2004 - 17:35:22 CDT