topic Re: Oracle Memory usage on HP-UX in Operating System - HP-UX

Oracle Memory usage on HP-UX

David Cassin — Mon, 31 Jul 2006 04:00:19 GMT

I have an HP server (rp4440) running hp-ux 11i, and Oracle. I want to find out how to find the amount of memory that Oracle is using for each oracle database.

Can anyone give me advice on this?

Re: Oracle Memory usage on HP-UX

Borislav Perkov — Mon, 31 Jul 2006 04:54:23 GMT

Hi,
Here is one script I had taken from this forum.
It works mainly for geting the memory of the user used, but if you put also the oracle instance you will get an approx. result of the used memory by that instance.
if the istance is PROD you should put:

./claimed_memory oraclePROD

Regards,
Borislav

Re: Oracle Memory usage on HP-UX

Steven E. Protter — Mon, 31 Jul 2006 05:23:15 GMT

Shalom David,

If you find something, take a look at the oracle SGA settings in init.ora. This has a profound effect on actual memory use.

SEP

Re: Oracle Memory usage on HP-UX

Yogeeraj_1 — Mon, 31 Jul 2006 06:10:47 GMT

hi,

this is a rather complex question, when calculating you should take these major considerations into account:

a) how much you have assigned to your buffer cache (for maximum performance)
b) how big is your shared/java pool (a function of how much sql/plsql/java you are running in your database)
c) do you run in shared server (then the large pool is used and will be large -- that is part of the sga) or in dedicated server -- dynamic allocations of memory

Also, the following can give you some indication of some amount of memory use by the database:
SQL> show sga

Total System Global Area 1048576000 bytes
Fixed Size 782424 bytes
Variable Size 259002280 bytes
Database Buffers 788529152 bytes
Redo Buffers 262144 bytes

ALso, if you are using 10g and have defined the sga_target, this may vary over time.

hope this helps too!

kind regards
yogeeraj

Re: Oracle Memory usage on HP-UX

spex — Mon, 31 Jul 2006 06:30:06 GMT

Hi David,

SELECT * FROM v$sga;

to see overall memory usage.

This returns cumulative SGA/PGA usage across all processes:

SELECT sum(s.value)
FROM
v$session se,
v$sesstat s,
v$statname n
WHERE
s.statistic# = n.statistic# and
se.sid = s.sid and
(n.name = 'session pga memory max');

From the OS:

# ipcs -ma

to see shared memory usage.

PCS

Re: Oracle Memory usage on HP-UX

David Cassin — Mon, 31 Jul 2006 08:36:54 GMT

Thankyou all for the information. I used the script that was supplied by Borislav which was very helpful.