- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle performance issue.
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
тАО01-17-2004 04:41 AM
тАО01-17-2004 04:41 AM
Oracle performance issue.
Could be this is an oracle problem (According to the DBA they have tune the DB maximum).
Please advice me to monitor and catch the secret in the system.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2004 05:56 AM
тАО01-17-2004 05:56 AM
Re: Oracle performance issue.
Next, 2GB is really a tiny amount of memory for Oracle these days. Almost certainly your machine is swapping. Use Glance or vmstat to exemine the page-out rate. If the value is anything over about 10 (and zero would be good) for any length of time then you are swapping way too much. If you can't get more memory then get your DBA's to limit the size of the SGA. You may need a club for this. Any overhead of going to disk more often for Oracle I/O is less costly --- by at least two orders of magnitudes (2 powers of 10) --- than swapping.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2004 12:28 PM
тАО01-17-2004 12:28 PM
Re: Oracle performance issue.
I'm attaching a good script for collecting such data based on sar.
Note that shared memory issues often slow oracle down.
shmmax should be set liberaly, but can not exceed 25% of total memory. Total memory is defined as ram plus swap.
swapinfo -tam will get you a figure on total memory.
See attachement.
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
тАО01-17-2004 01:26 PM
тАО01-17-2004 01:26 PM
Re: Oracle performance issue.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2004 01:29 PM
тАО01-17-2004 01:29 PM
Re: Oracle performance issue.
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=223730.1
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2004 03:45 PM
тАО01-17-2004 03:45 PM
Re: Oracle performance issue.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2004 04:22 PM
тАО01-17-2004 04:22 PM
Re: Oracle performance issue.
I echo others that you are short on memory. You are left with only 700 MB for buffer cache and system memory. Particularly on 11i, system memory (for kernel's dynamic allocation with most of it going to vx_inode_cache) can be found much higher than previous releases. Look at system memory in glance's memory window. It does not include buffer cache.
Also Add the "KB used" columns in your "swapinfo -tam" corresponding to each "dev" type. You will need to add atleast that much of memory to your system.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2004 06:24 AM
тАО01-18-2004 06:24 AM
Re: Oracle performance issue.
What is clear, is that the available memory resources are overcommitted. To solve that, one can increase the physical memory as suggested, but I'd like to see more proof that it is not simply a configuration problem.
Specifically, do you really know the SGA needs to be 1.3GB? Maybe this particular application can run happily with 200MB shared pool and 110MB buffer space but someone fat-fingers that to 1100MB buffers? Or they imported an initXXX.ora file from an other server with more memory and failed to reduce that?!
Nuwan, please help us help you better by describing some more. Notably, how many users are connected? 5? 500? You should anticipate 2 - 10mb per user connection to Oracle, on top of the SGA, so your current config can possible only handle 50 or so connections (on a good day). On a bad day, with lots of sorting that may be less still.
Be sure to carefully rad Brian's reply. IMHO that is the most useful one so far.
What are the oracle sort settings / pga target settings, and the likes. What are your dbc_max_pct settings? cooked or raw? How much memory/user do you see (top?)...
Good Luck
Hein.