Database Tuning (MOSC)

MOSC Banner

Reparse versus parse

edited Feb 28, 2020 6:18PM in Database Tuning (MOSC) 10 commentsAnswered

Hello,

I have a question on the reparse versus parse (soft or hard parses I assume), and if someone please explain under what circumstances a sql gets reparsed, and wonder if a reparse could be soft parse or hard parse.

I read some oracle documents taking about about avoid reparsing.  However, I have a hard time to understand exactly what constitute a reparse, and what's the difference between a parse and reparse, where soft parse is fine but reparse is not.  There must be a difference.  If I have a cursor open/close inside a loop, and I can see it will get reparsed every time since the cursor is closed.  But if the cursor is still in library cache and the open/close is not inside a loop, why it needs to be reparsed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center