SQL Parsing Flow Diagram

SQL Parsing Flow Diagram
========================
 
 Statement 
 Submitted
 |
 Is it in an open cursor?--------------YES----V   
 |                                            |  
 NO                                           |   
 |                                            |
 Is SESSION_CACHED_CURSORS = Value            |  
 and cursor in Server Side ------------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)--&gt ---------
 |                                       |         |
 NO                                      | EXECUTE |
 |                                       |         |
 PARSE STATEMENT ('Hard' Parse)---------&gt ---------

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11088128/viewspace-703604/，如需轉載，請註明出處，否則將追究法律責任。