1、oracle账号获得library cache Latch
(1)在父游标的名柄没有找到SQL语句的文本:select * from gyj_t1 where id=1;
2、释放library cache Latch
3、获得shared pool Latch
5、 重新获取library cache Latch (oracle 11g:library cache mutex)
7、 释放library cache Latch(oracle 11g:library cache mutex)
8、获取library cache lock —-》保护父游标的名柄(SQL语句文本,父游标H0的地址)
9、释放library cache lock Latch
10、获取library cache Pin Latch
12、释放library cache Pin Latch (oracle 11g:cursor mutex)
13、获取library cache lock Latch
14、获取library cache lock —-》保护子游标的名柄(子游标H0的地址)
15、释放library cache lock Latch
16、获取library cache Pin Latch
18、释放library cache Pin Latch
19、获取library cache Pin Latch
21、释放library cache Pin Latch