- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Memory usage on HP-UX
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2006 09:00 PM
тАО07-30-2006 09:00 PM
Can anyone give me advice on this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2006 09:54 PM
тАО07-30-2006 09:54 PM
SolutionHere 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2006 10:23 PM
тАО07-30-2006 10:23 PM
Re: Oracle Memory usage on HP-UX
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2006 11:10 PM
тАО07-30-2006 11:10 PM
Re: Oracle Memory usage on HP-UX
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2006 11:30 PM
тАО07-30-2006 11:30 PM
Re: Oracle Memory usage on HP-UX
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 01:36 AM
тАО07-31-2006 01:36 AM