A look at Parsing and Sharing of Cursors

Parsing is the first stage in processing a SQL statement – the other two being Execute and Fetch stages. Parse once – execute many is a very important performance tuning goal. What does parsing involve Syntax check – is the SQL statement syntactically correct Semantic check – is the SQL statement meaningful or semantically correct. […]

Solving a 10g Bind Variable Peeking problem by granting and revoking privileges

The Cost Based optimizer peeks at the values of user-defined bind variables on the first invocation of a cursor. Based on this, the optimizer determines the selectivity of the WHERE clause condition as if literals have been used instead of bind variables. On subsequent invocations of the cursor, no bind peeking takes place, and the […]

Add A Knowledge Base Question !

hard parse

A look at Parsing and Sharing of Cursors

Solving a 10g Bind Variable Peeking problem by granting and revoking privileges

Add A Knowledge Base Question !