信息发布→ 登录 注册 退出

oracle SQL解析步骤小结

发布时间:2026-01-11

点击量:
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共享区
标签:# privileges  # cache  # library  # data  # br  # searched  # dictionary  # syntax  # verified  # statement  # verify  # oracle  # relevant  # security  # table  # column  # definitions  # 检查表  # 字段名  # 放在  # 解析步骤  # SQL  
在线客服
服务热线

服务热线

4008888355

微信咨询
二维码
返回顶部
×二维码

截屏,微信识别二维码

打开微信

微信号已复制,请打开微信添加咨询详情!