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




Oracle LazyDBA home page