22 lines
336 B
SQL
22 lines
336 B
SQL
@@saveset
|
|
set serveroutput on size 1000000
|
|
|
|
declare
|
|
curr_sqlhash number;
|
|
|
|
sqlhashes sys.
|
|
|
|
begin
|
|
for i in 1..50 loop
|
|
select sql_hash_value into curr_sqlhash
|
|
from v$session where sid = &1;
|
|
|
|
dbms_output.put_line(to_char(curr_sqlhash));
|
|
|
|
dbms_lock.sleep(0.1);
|
|
end loop;
|
|
end;
|
|
/
|
|
|
|
@@loadset
|