- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to find out used memory by Oracle
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
тАО02-07-2003 01:20 AM
тАО02-07-2003 01:20 AM
We have Oracle running on a HP9000/800 L2000.
Currently four instances has been configured, we want to add a new instance, but how can I find out if we have enough memory available on the system.
When using swapinfo, I see the following result :
# swapinfo
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 3145728 165296 2980432 5% 0 - 1 /dev/vg00/lvol2
reserve - 541408 -541408
memory 763012 269684 493328 35%
Please help me out.
Regs David
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 01:27 AM
тАО02-07-2003 01:27 AM
Re: How to find out used memory by Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 01:45 AM
тАО02-07-2003 01:45 AM
Re: How to find out used memory by Oracle
Is it always Oracle that is swapping out memory to disk? There are running more programm's on this machine. Isn't it that when idle time reaches a specified value (kernel param) memory gets swapped to disk automaticly ??
I am actualy looking for a way to see how much memory each oracle instance is claming, and how much there is available to clame.
So, in my opinion it is not always bad to have some swap in "dev", is this right ?
Regs David
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 01:49 AM
тАО02-07-2003 01:49 AM
Re: How to find out used memory by Oracle
clame --> claim
Regs David
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 01:53 AM
тАО02-07-2003 01:53 AM
Re: How to find out used memory by Oracle
swapinfo -at is more informative.
Oracle will confirm that oracle does its own buffer caching so you can put the kernel parameter swapmem_on to 0 to use all memory for processes or at least reduce dbc_max_pct to 20 from 50.
It is a lot more than memoy usage involved since things like kernel tuning affect whether more processes will run.
see
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x9811a24d9abcd4118fef0090279cd0f9,00.html
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 02:11 AM
тАО02-07-2003 02:11 AM
Re: How to find out used memory by Oracle
You can also check the usage of memory
with the ipcs command.
Look at the manpages for the different usages.
That refers to memory, seemaphores etc.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 02:24 AM
тАО02-07-2003 02:24 AM
Re: How to find out used memory by Oracle
Hi,
try:
swapinfo -tam (in megs) and look at the USED col. like Stefan mentioned.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 02:45 AM
тАО02-07-2003 02:45 AM
Re: How to find out used memory by Oracle
eg. all our HP servers run lots of oracle instances and I never allow swap device usage to get >0 or else performance is affected adversely.
ipcs -ma (and look for the oracle entries and the size column)
shows the amount of shared memory the oracle instances are using themselves, but you need to add in user processes also.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 03:23 AM
тАО02-07-2003 03:23 AM
Re: How to find out used memory by Oracle
You're helping me a lot !!
Looking at the hints you give I come up with the following :
dbc_max_pct already was set to 10 --> is it important to have it at 20 ?? Might this be the reason why swapinfo -tam reports me a 161Mb swap on disk ??
When using the ipcs command :
ipcs -ma | awk 'NR<=3||/ora/{print $1,$2,$3,$4,$5,$6,$10,$11,$11}'
IPC status from /dev/kmem as of 12:00:15 2003 2003
T ID KEY MODE OWNER GROUP SEGSZ CPID CPID
Shared Memory:
m 3145 0x95e56888 --rw-r----- oracle dba 48558080 1832 1832
m 3146 0x26056810 --rw-r----- oracle dba 40169472 1871 1871
m 3147 0x399446fc --rw-r----- oracle dba 48558080 1906 1906
m 4172 0xc6c6bad0 --rw-r----- oracle dba 40169472 1943 1943
m 8269 0x6a618be8 --rw-r----- oracle dba 31780864 1978 1978
You can see each instance claiming aprox 40 Mb. We have 1Gb of internal memory (soon 2Gb).
Is it wise to increase dbc_max_pct ?? The system is mainly an Oracle server, but also some other programs running on it ?
The other programs claim in total about 40 Mb as well, including OS.
So, how do I get rid of my current swap on disk ? And how can I afterwards make sure a new instance can be added ?
1gb of memory and aprox 250 SHmem in use does not seem a bottleneck to me.
Thanks for all your help so far, please help me out to finish the last bit.
Regs David
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2003 03:47 AM
тАО02-07-2003 03:47 AM
SolutionThe only way to get rid of your current swap on disk is to free up some memory - shutdown an oracle instance (or more), or some user processes, but I doubt very much you will be able to free up enough.
The only way to make swapinfo output look better is to reboot, but as soon as you start all your databases and all your users get on it will start to show device swap as USED again - until you add some more RAM (or dont startup as many databases).
Use this command to get a rough idea of which processes are using the most memory - maybe some are erroneous and can be shutdown;
UNIX95= ps -e -o vsz=Kbytes -o ruser -o pid,args=Command-Line | sort -rnk1 | more
It displays processes in order of which are using the most RAM.