Oracle SQL Parsing Flow Diagram(SQL 解析流程图)

原创 2011年07月22日 13:56:08

       在MOS 上有一篇介绍SQL 解析流程图的文档,参考[ID32895.1]。 截取主要部分内容如下:

               Thisarticle show the parsing mechanism as a flow diagram. Its main purpose is toshow the difference between a 'soft' and a 'hard' parse. It is intended to givea feel of how parsing operates to make explanation of parsing activity easier.






1. A cursor is an address on the client that points tothe memory location of a SQL statement on the server. Multiple-client cursors may point at the same address on the server.


2. Remember that 'Client' and'Server' sides may reside on the same machine - in which caseClient/Server is a logical distinction.


3. If a cursor is open, then thestatement will be in the sql_area, so no parsing is necessary. This iswhy locks may remain when a client is terminated abnormally (such as a PCClient being turned off without closing open cursors).


4. SESSION_CACHED_CURSORS is the initialisation parameterthat specifies how many cursors to hold open for a particular session. The opencursor request will still be sent to the server but it will not be executedonce a matching cursor is found in the session cursor cache.


5. HOLD_CURSOR is an precompiler parameter that specifiesthat an individual cursor should be held open.


6. Both the soft and hard parseregister as a parse in tkprof. Hashing the current statement updates theparse count.



7. Soft parse avoids many of thesteps taken during the parse phase for a particular statement. Initialsyntactic and semantic checks are made and then the statement is hashed andcompared with hashed statements in the SQL area. If amatch is found, then existing information is used and relatively expensivesteps (such as query optimization etc.) areavoided.


8. The 10053 event is only invoked during a hard parse.


Oracle 10053 事件








DBA1 群:62697716(满);   DBA2 群:62697977(满)  DBA3 群:62697850(满) 

DBA 超级群:63306533(满);  DBA4 群: 83829929  DBA5群: 142216823   

DBA6 群:158654907  聊天 群:40132017   聊天2群:69087192



软件工程之数据流程图(DFD Data Flow Diagram)

一、什么是数据流图 数据流图是一种图形化的系统模型,它在一张图中展示信息系统的数据流向——即系统的输入与输出数据分别是什么,数据从哪里来并最终流向何处,以及数据存储在什么地方。 数据流图的基本...

数据流程图(Data flow diagram)

A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information...
  • Koupoo
  • Koupoo
  • 2012年07月10日 10:02
  • 1041

x264 h264_find_frame_end flow diagram

  • 2014年03月11日 15:45
  • 76KB
  • 下载

CAS (4) —— CAS浏览器SSO访问顺序图详解(CAS Web Flow Diagram by Example)

文章转载自: CAS (4) —— CAS浏览器SSO访问顺序图详解(CAS Web Flow D...

DIA: 使用Diagram Designer快速绘制流程图、UML等图形

目前比较流行的UML建模工具包括Visio、Rational Rose、PowerDesigner、EA等,基本上都是企业级的软件,功能强大,我只用过Visio,所以就不对它们的特点或者异同多加介绍。...

高效程序员秘籍(7):使用Diagram Designer快速绘制流程图、UML等图形

高效程序员秘籍(7):使用Diagram Designer快速绘制流程图、UML等图形   目前比较流行的UML建模工具包括Visio、Rational Rose、PowerDesigner、E...

IDEA activiBPM导入流程图之后 Diagram乱码

idea 安转activiti插件后,编辑流程图发现保存后中文乱码,并且idea的字符集(Settings—>Editor—>File Encodings)已经设置为UTF-8,流程图中中文仍然是乱码...


活动图(activity diagram,动态图)是阐明了业务用例实现的工作流程。 业务用例模型中的活动图       业务用例工作流程说明了业务为向所服务的业务主角提供其所需的价值而...
您举报文章:Oracle SQL Parsing Flow Diagram(SQL 解析流程图)