- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Datebase System Slow performance. (Oracle 11g ...
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
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
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
05-21-2012 08:40 AM
05-21-2012 08:40 AM
Datebase System Slow permance.. ( Oracle 11g R2)..
Greetings ,
I hoping to get some ideas as to how I might go about fixing this problem that I think I have. I have a rx6600 server w 4 1.6Ghz cpus and I'm having some slow performance (like its saying always 50 to 60 % CPU utilization )issues. . What do I need to look at to see why my system is slow.
In my server each every oracle instant its take 19659M.. (Database version is Oracle 11g R2 ans Service Guard 2 node Cluster..)
Pri-Server : 32 GB Physical Memory and 8 CPU.
Scon-Server:16 GB Physical Memory and 4 CPU.
CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
14 ? 1866 root 152 20 44224K 2820K run 0:28 2.79 2.79 cimprovagt
10 ? 2391 root 168 20 15612K 1164K sleep 0:03 0.27 0.27 utild
12 ? 9186 oracle 154 20 19659M 9928K sleep 0:02 0.18 0.18 oracleewagdb
2 ? 9246 oracle 154 20 19656M 7928K sleep 0:00 0.60 0.18 ora_j000_ewagdb
8 ? 7640 oracle 154 20 19665M 12424K sleep 0:13 0.14 0.14 oracleewagdb
12 ? 9211 oracle 154 20 19659M 10184K sleep 0:01 0.13 0.13 oracleewagdb
4 ? 2627 oracle 154 20 19658M 9900K sleep 0:03 0.12 0.12 ora_dia0_ewagdb
4 ? 9248 oracle 154 20 19656M 7340K sleep 0:00 0.35 0.10 ora_j001_ewagdb
6 ? 2641 oracle 154 20 19661M 12696K sleep 0:03 0.10 0.10 ora_mmon_ewagdb
4 ? 9236 oracle 154 20 19658M 9208K sleep 0:00 0.08 0.08 oracleewagdb
14 ? 1527 root 154 20 11160K 1284K sleep 0:01 0.07 0.07 sendmail:
2 ? 2 root 128 20 72K 64K sleep 0:00 0.05 0.04 vhand
6 ? 2635 oracle 154 20 19656M 7660K sleep 0:00 0.02 0.02 ora_ckpt_ewagdb
If any one give the best advice , because system its very critical sutivation ....
Regards
Rajamani
- Tags:
- Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-21-2012 01:02 PM
05-21-2012 01:02 PM
Re: Datebase System Slow performance. (Oracle 11g R2)..
What version of HP-UX do you have?
Do you have Glance installed?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2012 12:15 PM
05-22-2012 12:15 PM
Re: Datebase System Slow performance. (Oracle 11g R2)..
Dear,
HP unix 11.31 and Oracle DB 11g R2..
Regards
Rajamani..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2012 03:20 AM
07-14-2012 03:20 AM
Re: Datebase System Slow performance. (Oracle 11g R2)..
Hi
These processes are from same instance. An instance is a set of memory and processes.
you can check oracle concepts : http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm#i12483
You should also provide more information regarding your system being slow :
- is this new ? if so, what has changed ?
- are symptoms at server level ? database level ?
- do you have database monitoring in place ? (perfstat if nothing else)
and more important would you have a baseline (performance) for your server & database.
Regards
Jean-Luc