Home » RDBMS Server » Performance Tuning » Oracle Instance Related Query (Oracle 10g)
Oracle Instance Related Query [message #519778] Tue, 16 August 2011 21:41 Go to next message
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
Re: Oracle Instance Related Query [message #519781 is a reply to message #519778] Tue, 16 August 2011 21:51 Go to previous messageGo to next message
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/
Re: Oracle Instance Related Query [message #519796 is a reply to message #519778] Wed, 17 August 2011 00:47 Go to previous message
John Watson
Messages: 8922
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?
Previous Topic: start with and connect by
Next Topic: Query sub-factoring issue
Goto Forum:
  


Current Time: Thu Mar 28 16:42:48 CDT 2024