Hard Parsing [message #200460] |
Tue, 31 October 2006 00:29 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
Dear Sir I execute the following query
SELECT NAME, VALUE
FROM V$SYSSTAT
WHERE NAME IN ('parse time cpu', 'parse time elapsed',
'parse count (hard)', 'CPU used by this session' );
NAME VALUE
---------------------------------------------------------------- ----------
CPU used by this session 0
parse time cpu 0
parse time elapsed 0
parse count (hard) 461305
Please look at parse count (hard) which is at higher size
My observations are Application is not using bind variables
and i also check that cursor_sharing=EXACT so the statements with slight differences are not sharing exectution plans
Should i change it to Force or Similar?
Would it be beneficial to reduce hard parsing ultimately causing impact on performance?
thanx in advance
|
|
|
Re: Hard Parsing [message #200657 is a reply to message #200460] |
Tue, 31 October 2006 14:39 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
First try to get the application to use bind variables. If you cannot, benchmark the app with different CURSOR_SHARING settings to see which one works best for you.
|
|
|