Originally posted by anandkl
I have gone through all this process and found out that the sql are getting invalidated and resulting in 'HARD PARSE', so i want a solution to avoid this 'HARD PARSE'

regards
anandkl
then solution is as suggested by Pando.. Use bind variables, use procedures,... pin frequently used objects