If you use Oracle Enterprise Edition, you can create some "Resource
Consumer Group" and create some "Resource plans", and configure the
limit of the bandwidth of the CPU usage for a certain "Resource
Consumer"...that use this stored function.

Regards.

-----Original Message-----
From: Mujeeb
[mailto:oracledba-ezmlmshield-x27042414.[Email address protected]
Sent: sexta-feira, 28 de Setembro de 2007 16:58
To: LazyDBA Discussion
Subject: CPU utilization 96% for Application



Hi,



I have a stored function which executed once time taken is 31 milli
seconds.

But when executed parallely ( 50 executions at one time parallelly) ,it
is
taking about 300ms and CPU utilization is 96%.



Using TKPROF identified queries, But little we could improve at SQL
level,

Any suggestion to improve performance at db level to reduce cpu usage ?







Thanks & Regards

Mujeeb





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






Oracle LazyDBA home page