模擬cache buffers chains與library cache pin等待事件
一、建立測試表
JZH@ORCL>create table test (id int,name varchar2(30));
Table created.
二、插入資料
JZH@ORCL>create table test (id int,name varchar2(30));
Table created.
二、插入資料
JZH@ORCL>insert into test values(1,'AAAA');
1 row created.
三、查詢資料
1 row created.
三、查詢資料
JZH@ORCL>select rowid,id,name from test;
ROWID ID NAME
------------------ ---------- ------------------------------
AAAMlkAAFAAAAAXAAA 1 AAAA
四、執行匿名塊
會話一:
JZH@ORCL>declare
2 id number;
3 begin
4 for i in 1..10000000 loop
5 select id into id from test where rowid='AAAMlkAAFAAAAAXAAA';
6 end loop;
7 end;
8 /
會話二也執行一次:
JZH@ORCL>declare
2 id number;
3 begin
4 for i in 1..10000000 loop
5 select id into id from test where rowid='AAAMlkAAFAAAAAXAAA';
6 end loop;
7 end;
8 /
五、查詢v$session等待事件
SYS@ORCL>select sid,event,p1raw from v$session where wait_class<>'Idle';
SID EVENT P1RAW
---------- ---------------------------------------------------------------- ----------------
144 latch: library cache 00000000A55E9E30
154 latch: cache buffers chains 00000000A8AF2500
159 SQL*Net message to client 0000000062657100
等待事件出來了、下一步深入研究這兩個等待事件!
ROWID ID NAME
------------------ ---------- ------------------------------
AAAMlkAAFAAAAAXAAA 1 AAAA
四、執行匿名塊
會話一:
JZH@ORCL>declare
2 id number;
3 begin
4 for i in 1..10000000 loop
5 select id into id from test where rowid='AAAMlkAAFAAAAAXAAA';
6 end loop;
7 end;
8 /
會話二也執行一次:
JZH@ORCL>declare
2 id number;
3 begin
4 for i in 1..10000000 loop
5 select id into id from test where rowid='AAAMlkAAFAAAAAXAAA';
6 end loop;
7 end;
8 /
五、查詢v$session等待事件
SYS@ORCL>select sid,event,p1raw from v$session where wait_class<>'Idle';
SID EVENT P1RAW
---------- ---------------------------------------------------------------- ----------------
144 latch: library cache 00000000A55E9E30
154 latch: cache buffers chains 00000000A8AF2500
159 SQL*Net message to client 0000000062657100
等待事件出來了、下一步深入研究這兩個等待事件!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-1139068/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- library cache pin等待事件的模擬事件
- 【等待事件】library cache pin事件
- 等待事件--library cache pin事件
- library cache pin 等待事件事件
- ORACLE等待事件latch: cache buffers chainsOracle事件AI
- 等待事件_cache_buffers_chains_latch事件AI
- 解決library cache pin等待事件事件
- enq:Library cache lock/pin等待事件ENQ事件
- cache buffers chains and cache buffers lru chainsAI
- library cache pin等待分析
- cache buffers chains vs cache buffers lru chainAI
- 等待模擬-library cache 軟解析
- 處理 latch_cache_buffers_chains等待事件一例AI事件
- 定位Library Cache pin,Library Cache lock等待的解決方法
- 查詢Library Cache Pin等待原因
- latch: cache buffers chainsAI
- LIBRARY CACHE LOCK 等待事件事件
- 'cursor:mutex ..'/ 'cursor:pin ..'/ 'library cache:mutex ..'型別的等待事件Mutex型別事件
- 分析解決因”library cache pin”等待
- latch:cache buffers chains案例AI
- 等待事件_cache_buffers_lru_chain_latch事件AI
- latch:library cache lock等待事件事件
- 等待模擬-library cache shared pool 硬解析
- zt_library cache pin和lock等待分析
- Library Cache Pin 及 Library Cache Lock分析
- library cache lock和library cache pin理解
- latch: cache buffers chains-熱塊的簡單模擬實驗AI
- 用於排查cache buffers chainsAI
- Cache Buffers chains,存在共享模式?AI模式
- 等待模擬-cache buffer chainAI
- buffer cache實驗6-latch:cache buffers lru chainsAI
- 深入理解latch: cache buffers chainsAI
- Trouble shooting latch: cache buffers chainsAI
- 模擬library cahe lock/pin等待事件以及問題定位事件
- 11G資料庫之library cache lock及library cache pin模擬結合hanganalyze定位資料庫
- library cache lock和cursor: pin S wait on X等待AI
- library cache pin和library cache lock的診斷分析
- library cache lock和library cache pin區別總結