demo09.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 15 行

select tch, file#, dbablk, DUMMY
  from x$bh, (select dummy from dual)
 where obj = (select data_object_id
                from dba_objects
               where object_name = 'DUAL'
                 and data_object_id is not null)
/
exec dbms_lock.sleep(3.2);
/
exec dbms_lock.sleep(3.2);
/
exec dbms_lock.sleep(3.2);
/