May be somebody can correct me , if i am wrong ...

Jr,
if you find the similar LITERAL statements in the Library Cache and getting excuted more frequently... Ofcourse they will be re-parsed every time( Hope i am not wrong here ) they are getting executed.

I think we have Three Options.

1. Possible chnage the application code to use the BIND variables.

2. if the step 1 is not possible for all Literal statements.
use CURSOR_SHARING=FORCE ( Here Oracle will reuse the literal statements and no parsing is allwowed here )

3. And Only you have couple of statements left and they are still literal statements , why cant we pin them..

Corrections are very much appreciated,