OraFAQ Forum: Performance Tuning » To limit Cpu consumption

Home » RDBMS Server » Performance Tuning » To limit Cpu consumption (Oracle 10.2.0.4, Solaris 9)

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

To limit Cpu consumption [message #420389]

Fri, 28 August 2009 16:27

dasuwal@gmail.com
Messages: 20
Registered: June 2009

Junior Member

Hi Forum

I have a application which run with 12 threads (can) and put a lot of load on database (Oracle 10.2.0.4, Solaris 9). The cpu consumtions hit 95% during peak times.

I can limit the CPU time by CPU_per_session, but
Is there anyhow I can limit the cpu utilization of oracle sessions to 30%.

Thanks in advance.

Report message to a moderator

Re: To limit Cpu consumption [message #420409 is a reply to message #420389]

Sat, 29 August 2009 00:44

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can use resource manager but isn't the purpose of a CPU to run at 100%?
Note that resource manager comes into play ONLY when CPU reaches 100%.

Regards
Michel

Report message to a moderator

Re: To limit Cpu consumption [message #420447 is a reply to message #420389]

Sat, 29 August 2009 20:28

dasuwal@gmail.com
Messages: 20
Registered: June 2009

Junior Member

Hi Michel

but isn't the purpose of a CPU to run at 100%?
I need to limit the CPU consumption of certain application to 30 %, otherwise it choke the cpu with consumption of resources.

resource manager comes into play ONLY when CPU reaches 100%.
If Resource manager comes into play when CPU reaches 100 %, then what is fun of having resource manager. Doesnt that nullify the concept of managing resources.

Thanks for your advice.

Report message to a moderator

Re: To limit Cpu consumption [message #420458 is a reply to message #420447]

Sat, 29 August 2009 23:58

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

what is fun of having resource manager.

Limiting the CPU resource for each consumer.
If CPU does not reach 100% there is no need to limit someone.
If CPU reaches 100% then using resource manager you can limit some consumer (to 30% as you said) to prevent one process to keep the whole (or more than its share) CPU for itself.

Please read the link I posted.

Regards
Michel

Report message to a moderator

Re: To limit Cpu consumption [message #421247 is a reply to message #420447]

Sun, 06 September 2009 21:32

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

dasuwal@gmail.com wrote on Sun, 30 August 2009 08:28

I need to limit the CPU consumption of certain application to 30 %, otherwise it choke the cpu with consumption of resources.

If Resource manager comes into play when CPU reaches 100 %, then what is fun of having resource manager. Doesnt that nullify the concept of managing resources.

Thanks for your advice.

As my opinion, it is not necessary to limit CPU resource at OS level. Of course, I can use Zone in Solaris to limit CPU, I/O,.. resource, but I do not want.

Imagine, you have got 14 concurrent sessions doing DML at table(s) level, you'll got more contentions than you want: CPU, I/O, queuing,.. If you limit CPU ratio per sessions by both of Resource_Manager level and OS level, you'll achieve your purpose, but Waiting and Queuing will increase more and more, the Wait level you will get at Perfstat & AWR show you incredibility.

Tuning at SQL or PL/SQL level is always the best method.

I believe, Zoning at Solaris have been a best way to decrease Oracle license or if you've got App and DB at one server.

Report message to a moderator

Previous Topic:	Wait event problem
Next Topic:	DBMS_STATS running slow.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:04:40 CST 2024