OraFAQ Forum: Performance Tuning » Oracle Instance Related Query

Home » RDBMS Server » Performance Tuning » Oracle Instance Related Query (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Instance Related Query [message #519778]

Tue, 16 August 2011 21:41

saswatic
Messages: 5
Registered: June 2011
Location: India

Junior Member

Dear All,

I seek your experienced advice for one of the issues I have for my project as stated below:-

We have an Oracle instance in which several schemas are present. According to the AWR report for an identified time frame, it is shown that one particular schema is occupying most of the CPU/resources. So my question is that by any way can this affect the performance of other schemas?

Thanks in Advance,
Warm Regards
Saswati

Report message to a moderator

Re: Oracle Instance Related Query [message #519781 is a reply to message #519778]

Tue, 16 August 2011 21:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So my question is that by any way can this affect the performance of other schemas?
yes, no, maybe

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Oracle Instance Related Query [message #519796 is a reply to message #519778]

Wed, 17 August 2011 00:47

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I don't understand your question as written. Can you attach the AWR report (text version) so that we can see the evidence of the problem?

Report message to a moderator

Previous Topic:	start with and connect by
Next Topic:	Query sub-factoring issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 05:01:04 CST 2024