Oracle SQL Parsing Flow Diagram(SQL 解析流程图)
来源:互联网 发布:远程控制家里mac电脑 编辑:程序博客网 时间:2024/05/22 01:53
在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 事件
http://blog.csdn.net/xujinyang/article/details/6831396
- Oracle SQL Parsing Flow Diagram(SQL 解析流程图)
- Oracle SQL Parsing Flow Diagram(SQL 解析流程图)
- 数据流程图(Data flow diagram)
- parsing sql
- Oracle sql执行流程图 SQL执行过程
- 软件工程之数据流程图(DFD Data Flow Diagram)
- oracle SQL解析步骤
- oracle sql 解析过程
- oracle sql 解析过程
- Oracle SQL软硬解析
- PFD - Process Flow Diagram
- Wifidog Flow Diagram
- ORACLE SQL解析流程详解
- Oracle sql执行计划解析
- ORACLE 4 SQL语句解析
- oracle sql语句解析过程
- Oracle sql解析过程详解
- 数据可视化 —— 数据流图(Data Flow Diagram)
- Oracle Library cache 内部机制 说明
- Android SAX解析实例教程
- Oracle 高 Version counts 问题说明
- 花生壳已经激活了,但是在诊断显示“花生壳未激活,设置A记录”如何处理
- 分享前端网站模板,HTML5的响应式设计模板
- Oracle SQL Parsing Flow Diagram(SQL 解析流程图)
- 用树形结构分配权限
- Oracle自定义聚集函数
- 近两个月内,国内电子商务公司纷纷裁员
- Android SAX解析xml文件
- Python的Django的配置过程
- Oracle Namespace 说明
- cPanel安装ecshop的问题
- Oracle 查看 Shared Pool 信息的相关脚本