Statement 


 Submitted


 |


 Is it in an open cursor?--------------YES----V   


 |                                            |  


 NO                                           |   


 |                                            |


 Is SESSION_CACHED_CURSORS = Value            |  


 and cursor in           --------------YES----V   In these 3 cases we  


 Session Cursor cache?                        |   know that the cursor has 


 |                                            |   already been parsed, so 


 NO                                           |   re-parsing is


 |                                            |   unnecessary.


 Is HOLD_CURSOR=Y                             |


 and cursor in           --------------YES----V      


 Held cursor cache?                           |       


 |                                            |       


 NO                                           |        


 |                                            |              ^


 OPEN A CURSOR                                |  CLIENT SIDE |       


 |                                            | -------------|


 Statement is Hashed and compared             |  SERVER SIDE | 


 with the Hashed value in the sql area        |              V


 |                                            V


 Is it in sql area? --YES-(Soft Parse)--> ---------


 |                                       |         |


 NO                                      | EXECUTE |


 |                                       |         |


 PARSE STATEMENT ('Hard' Parse)---------> ---------

55_021217_1193060434.jpg