模拟cursor pin S如下:
SQL>CREATE TABLE MYTEST AS SELECT OBJECT_NAME FROM USER_OBJECTS WHERE ROWNUM <= 4;
SQL>SETTIMING ON;
DECLARE lv_name VARCHAR2(45) :='';
Begin
FOR i IN 1..100000 LOOP
SELECTOBJECT_NAME INTO lv_name FROM MYTEST WHERE ROWNUM = 1;
End loop;
end;
/
一个会话执行了6秒,同时开4个会话执行这个过程。
多个会话同时访问同一个块,cusorpin S