- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How much physical memory is Oracle using?
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
тАО11-12-2001 01:37 PM
тАО11-12-2001 01:37 PM
How much physical memory is Oracle using?
TIA, Haitham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2001 01:38 PM
тАО11-12-2001 01:38 PM
Re: How much physical memory is Oracle using?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2001 01:49 PM
тАО11-12-2001 01:49 PM
Re: How much physical memory is Oracle using?
hi,
firstly, for 256Mb of RAM,
the setting of dbc_max_pct
is way too high for 50.
Reduce it to 10 and dbc_min_pct to 5.
UNIX95= ps -e -o vsz=Kbytes -o ruser -o pid,args=Command-Line |grep oracle |sort -rnk1
Also, you can look at
ipcs -am |grep oracle.
With 256Mb , there is little
you can do nitpicking on memory usage. NFS shouldnt make that much of a difference on memory usage. It is probale that one of the system's database is more active.
I would suggest to change
the dbc values (reduce them).
Also, for such a small memory, it is pointless to
have pseudo swap . So, if you have pseudoswap , disable it.
The easiest way is to add additional memory.
-raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2001 02:16 PM
тАО11-12-2001 02:16 PM
Re: How much physical memory is Oracle using?
Your buffer settings do not appear to be 50%, and you are, in fact, using more buffer space on the fast system. I doubt that decreasing buffer size will help. The 20MB being used on the slow system might even be too low. That really depends on what else is running on the servers, since oracle does its own buffering.
Question: do you have online JFS, and if so are you using oracle's recommended mount options? Without them, oracle data gets buffered twice, hurting performance.
You are doing more paging on the slow system. This might be a function of data use as much as configuration. Since you are paging, though, you should do everything possible to optimize the disk access speeds of your sawap areas.
Are the servers identical in their disk speeds, etc? Is the data layout identical (or close?). Have you taken care to segregate index from data space?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2001 02:24 PM
тАО11-12-2001 02:24 PM
Re: How much physical memory is Oracle using?
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2001 09:10 AM
тАО11-13-2001 09:10 AM
Re: How much physical memory is Oracle using?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2001 09:19 AM
тАО11-13-2001 09:19 AM
Re: How much physical memory is Oracle using?
This could help you
UNIX95= ps -e -o vsz=Kbytes -o ruser -o pid,args=Command-Line | sort -rnk1 | more
-USA..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2001 09:23 AM
тАО11-13-2001 09:23 AM
Re: How much physical memory is Oracle using?
If anything loads before Oracle which would push part of Oracle's SGA into swap, you're pooched. Check the memory report in Glance on both your machines. I think you will find the slower machine to have consistent VM Reads and Writes where the faster machine doesn't.
And to echo what has already been said, 256MB of RAM is absurdly low for Oracle. You need more physical RAM. Lots more. What you are currently trying to do is akin to pulling a freight train with a motorcycle.
Cheers,
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2001 09:25 AM
тАО11-13-2001 09:25 AM
Re: How much physical memory is Oracle using?
Don't worry about the buffer cache, it'll take care of itself. If you have buffer cache too large, then apps, like oracle have less memory to play with. r% min and 10% max are good numbers to use, but rarely ever 50%.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2001 09:29 AM
тАО11-13-2001 09:29 AM
Re: How much physical memory is Oracle using?
live free or die
harry