niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » *nix » AIX
Performance problem
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
jon.fife@gmail.com
*nix forums beginner


Joined: 07 Jun 2006
Posts: 8

PostPosted: Wed Jul 19, 2006 1:17 pm    Post subject: Re: Performance problem Reply with quote
News wrote:
Quote:
I have performance problems with star queries on Oracle 10g under aix
5.2 ML07 that occur periodically. The only way to get around it is to
restart computer but someone could explain why this happens all of
sudden ?

below is the output of nmon

Hints-Mode-(verbose)-
¦ Code Resource Stats Now Warn Danger
¦ DANGER -> CPU %busy 100.0% >80% >90%
¦ OK -> Paging size %free 94.0% <20% <10%
¦ OK -> Paging Space RAM:pg106.2% <50% <10%
¦ DANGER -> Page Faults faults 13222.4 >4/s >40/s
¦ OK -> Top Disk hdisk3 %busy 23.0% >40% >60%

If you know the problem is with some specific queries, start by doing
(or having your DBA do) a trace of the problematic queries to see what
they are doing when the performance problems arise.

Otherwise, what processes are consuming the CPU? If they are Oracle
processes you should be able to trace them back to specific sessions
and specific queries within the DB and then trace them. If the
cpu-utilizing processes aren't Oracle, what are they?

Jon
Back to top
News
*nix forums addict


Joined: 03 Nov 2005
Posts: 64

PostPosted: Wed Jul 19, 2006 9:55 am    Post subject: Performance problem Reply with quote
I have performance problems with star queries on Oracle 10g under aix
5.2 ML07 that occur periodically. The only way to get around it is to
restart computer but someone could explain why this happens all of
sudden ?

below is the output of nmon

Hints-Mode-(verbose)-
¦ Code Resource Stats Now Warn Danger
¦ DANGER -> CPU %busy 100.0% >80% >90%
¦ OK -> Paging size %free 94.0% <20% <10%
¦ OK -> Paging Space RAM:pg106.2% <50% <10%
¦ DANGER -> Page Faults faults 13222.4 >4/s >40/s
¦ OK -> Top Disk hdisk3 %busy 23.0% >40% >60%
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Thu Dec 04, 2008 2:39 am | All times are GMT
navigation Forum index » *nix » AIX
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Unknown in header problem -SOLVED- Light Speed Postfix 0 Thu Jul 03, 2008 10:40 am
No new posts problem with sending mail nuxia Postfix 0 Mon Apr 21, 2008 3:58 am
No new posts Postfix 2.3.8 Virtual problem Blotto Postfix 0 Fri Apr 04, 2008 6:11 am
No new posts Postfix sending problem for local domain remote email monkey_magix Postfix 0 Mon Sep 10, 2007 10:17 am
No new posts bounce problem murkis Postfix 0 Sun Oct 08, 2006 3:45 pm

Home Loan | Debt Consolidation | Free Advertising | Internet Advertising | Loans
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.5772s ][ Queries: 20 (0.4958s) ][ GZIP on - Debug on ]