Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Finding where Oracle is consuming memory
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.
jg
-- @home.com is bogus. http://www.autoweek.com/specials/galleries/chaparral/pages/Chaparral-071.htmReceived on Wed May 05 2004 - 17:35:22 CDT