Re: Problems about RAC/Multiple database
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 12 Mar 2009 17:01:29 -0500
Message-ID: <dBful.9475$%54.4698_at_nlpi070.nbdc.sbc.com>
emdproduction_at_hotmail.com wrote:
> Dear group,
>
> we have a RAC environment which has several databases on it.
>
> Recently one of our database is consuming too much CPU, and it
> eventually cause the the server to reboot because the miscount > crs
> expected.
>
> Is there any way i can manage the CPU usage at database level? Say
> db1 can only use 20% of host cpu, db2 can use 15% of cpu?
>
> Do you have other suggestions as how to prevent this happening?
>
> Thanks
>
> Charlie
Date: Thu, 12 Mar 2009 17:01:29 -0500
Message-ID: <dBful.9475$%54.4698_at_nlpi070.nbdc.sbc.com>
emdproduction_at_hotmail.com wrote:
> Dear group,
>
> we have a RAC environment which has several databases on it.
>
> Recently one of our database is consuming too much CPU, and it
> eventually cause the the server to reboot because the miscount > crs
> expected.
>
> Is there any way i can manage the CPU usage at database level? Say
> db1 can only use 20% of host cpu, db2 can use 15% of cpu?
>
> Do you have other suggestions as how to prevent this happening?
>
> Thanks
>
> Charlie
you can manage profiles and enable "quotas"
since you didn't say what you tried or what you read or anything here, let me google that for you...
http://www.lmgtfy.com/?q=oracle+resource+profile+quota Received on Thu Mar 12 2009 - 17:01:29 CDT