哪种操作需要哪种类型的library cache lock / library cache pin?
来源:互联网 发布:猫 益生菌 知乎 编辑:程序博客网 时间:2024/05/31 18:46
如下摘自:
How to Analyze Library Cache Timeout with Associated: ORA-04021 'timeout occurred while waiting to lock object %s%s%s%s%s.' Errors (文档 ID 1486712.1)
How to Analyze Library Cache Timeout with Associated: ORA-04021 'timeout occurred while waiting to lock object %s%s%s%s%s.' Errors (文档 ID 1486712.1)
Which lock/pin mode is required for which type of action? All DDL operations (For example, when a package is recompiled, when a grant is given on an object, a truncate on a table, etc.)require a exclusive lock and pin on the object that needs to be processed.The DDL cursors themselves require a null lock (localisation job in library cache) and an exclusive pin when executing. All operations that use an objects (e.g. when a view is used, when a procedure is executed, etc.) require a null lock and shared pin on those objects.This is also applicable for all dependent objects (e.g. view based on another view, package using another package or view). Query and DML cursors requires a null lock and shared pin when executing.The locks/pins are held for the duration of the SQL statement, and released at the end of it.
0 0
- 哪种操作需要哪种类型的library cache lock / library cache pin?
- library cache pin/lock
- library cache pin和library cache lock
- library cache lock和library cache pin
- library cache —— library cache pin、library cache lock
- library cache pin和lock的区别
- Library cache的PIN与LOCK
- library cache pin和lock的区别
- library cache pin/lock的简单解决办法
- library cache pin &lock 模拟
- Library cache lock/pin详解
- Oracle Library Cache Lock/Pin
- Library cache lock/pin详解
- library cache pin和library cache lock(转)
- library cache pin/library cache lock案例一则
- oracle library cache pin、library cache lock原理分析。
- library cache pin和library cache lock分析
- Library cache lock and library cache pin waits
- sscanf 其实很强大
- 获得tm或者anydesk的id发送到服务器
- 第七周项目2建立链队算法库
- 支持swift3.0的开源库
- 怎么把word转成markdown
- 哪种操作需要哪种类型的library cache lock / library cache pin?
- 贝叶斯概率矩阵分解理解
- 安卓dialog主题
- Xcode中类文件后面的M,A,?等符号,Xcode使用Git的符号表示的意思
- mybatis常用查询技巧1
- 《从零开始学Swift》学习笔记(Day 36)——静态方法
- SSH MVC的关系
- 第七周 建立链队算法库
- 正则表达式的优先级