Home » RDBMS Server » Server Administration » Hard Parsing
Hard Parsing [message #200460] Tue, 31 October 2006 00:29 Go to next message
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 Go to previous message
Frank Naude
Messages: 4502
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.
Previous Topic: unable to connect to second database on same machine
Next Topic: utl_encode package body location on server
Goto Forum:
  


Current Time: Mon Dec 05 21:34:40 CST 2016

Total time taken to generate the page: 0.08964 seconds