一、创建测试表
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1139068/