摘要：
For PL/SQL1)Create Directory Where BLOB resides.create or replace directory temp as '/oradata2'; -- if the directory name you created not qoted, then ... 阅读全文
摘要：
Here’s an example of a slightly less common data deadlock graph (dumped from 11gR2, in this case):[Transaction Deadlock]The following deadlock is not ... 阅读全文
摘要：
from https://jonathanlewis.wordpress.com/2011/08/29/deadlock-2/Here’s a deadlock graph the appeared on Oracle-L and OTN a couple of days ago.Deadlock ... 阅读全文
摘要：
from https://jonathanlewis.wordpress.com/2013/03/20/lock-bug/Here’s an oddity that I ran into a little while ago while trying to prepare a sample trac... 阅读全文
摘要：
from https://jonathanlewis.wordpress.com/category/oracle/locks/deadlocks/Here’s a lovely effect looking at v$lock (on 11.2.0.4)12345678910111213141516... 阅读全文
摘要：
from http://jonathanlewis.wordpress.com/2013/04/13/deadlocks/Here’s a deadlock graph that might cause a little confusion:Deadlock graph: ---------Bloc... 阅读全文
摘要：
转自http://blog.itpub.net/15415488/viewspace-631260通常情况下，dead lock是由应用的不合理造成，应该由PD解决，而非DBA。但何时为非通常情况呢？今天遇到一个case，即为非通常情况。而他的通常的标志即为：在trc文件里的deadlock gra... 阅读全文