随笔分类 -  Oracle - 优化/结构

What's blocking my lock?
摘要:If you've ever gotten a phone call from an annoyed user whose transaction just won't go through, or from a developer who can't understand why her application sessions are blocking each other, you know how useful it can be to identify not just whose lock is doing the blocking, but what ob 阅读全文

posted @ 2012-03-17 22:21 生活不是用来挥霍的

不完全归纳设置isolation level为transaction level的两点影响
摘要:不完全归纳设置isolation level为transaction level的两点影响:1. 在设置了isolation level为transaction level的session执行两次同一个query的中间,即使有在其他session更新并提交了该query相关表的数据,这两次query所查出的结果仍然相同,直到当前session发出commit或rollback完成一个transaction后,在其他session提交了的修改才会在当前session中反映出来。2. 如果session A更新某表的一行且未提交,设置为transaction level的session B更新同一 阅读全文

posted @ 2012-03-16 00:12 生活不是用来挥霍的

ORA-13600, QSM-00775, ORA-06512 when running DBMS_ADVISOR
摘要:Error DescriptionWhen using DBMS_ADVISOR on a table in SYS or SYSTEM schema, the following errors returned.ORA-13600: error encountered in AdvisorQSM-00794: the statement can not be stored due to a violation of the invalid table reference filterBelow is an example.SQL> conn system/sConnected.SQL& 阅读全文

posted @ 2012-03-11 21:24 生活不是用来挥霍的