unable to see plsql code sql_id in v$session
Hello,
I have below result from v$sql and this sql is running for past 30 mints
3vnq6r9cm2pcf
begin for j in 1..1000000 loop for i in ascii('a')..ascii('z') loop insert into t4 values(j,i); commit; end loop; end loop; end;
However when I use below ,it gives no result - not sure why it';s no captured in v$session
SQL> select sid from v$session where sql_id='3vnq6r9cm2pcf';
no rows selected
Best regards,
Vishal