oracle SQL解析步骤小结

前端之家收集整理的这篇文章主要介绍了oracle SQL解析步骤小结前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

1 The Syntax of the sql statement is verified. sql的语法检查 2 The data dictionary is searched to verify table and column definitions. 从数据字典检查表名和字段名 3 The data dictionary is searched to verify security privileges on relevant objects. 从数据字典中检查权限 4 Parse locks are acquired on the relevant objects. 解析相关对象的锁 5 The optimal execution plan is determined. 选在执行计划运行sql 6 The statement is loaded into the shared sql area (also known as the library cache) in the shared pool of the system global area (SGA). 执行后sql语句放在SGA的sql共享区

猜你在找的Oracle相关文章