1、獲得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