PL/SQL (MOSC)

MOSC Banner

unable to see plsql code sql_id in v$session

edited Feb 16, 2016 4:07AM in PL/SQL (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center