Operating System - HP-UX
1748122 Members
3501 Online
108758 Solutions
New Discussion юеВ

Re: Oracle Memory usage on HP-UX

 
SOLVED
Go to solution
David Cassin
Advisor

Oracle Memory usage on HP-UX

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?
5 REPLIES 5
Borislav Perkov
Respected Contributor
Solution

Re: Oracle Memory usage on HP-UX

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
Steven E. Protter
Exalted Contributor

Re: Oracle Memory usage on HP-UX

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: Oracle Memory usage on HP-UX

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
spex
Honored Contributor

Re: Oracle Memory usage on HP-UX

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
David Cassin
Advisor

Re: Oracle Memory usage on HP-UX

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