Re: Finding where Oracle is consuming memory

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 5 May 2004 21:44:20 +0100
Message-ID: <40995221$0$25317$cc9e4d1f@news-text.dial.pipex.com>

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.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.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.

>

Received on Wed May 05 2004 - 15:44:20 CDT