select sid,q.sql_id,sql_text
from v$session s, v$sql q
where sid in (1169,49141)
and (
   q.sql_id = s.sql_id or
   q.sql_id = s.prev_sql_id);

--------------------------------------------------------------------------------
      1169 g2vf53xt32r1j
select owner,object_name,object_type,status,to_char(created, 'DD-MON-YYYY HH24:M
I:SS') from dba_objects where object_name like upper('%krsc_staff_profs%') order
 by owner,object_name



select sid,q.sql_id,sql_text
from v$session s, v$sql q
where sid in (1156,44885)
and (
   q.sql_id = s.sql_id or
   q.sql_id = s.prev_sql_id);

      1156 3xxanv0sr0g5r
select owner,object_name,object_type,status,to_char(created, 'DD-MON-YYYY HH24:M
I:SS') from dba_objects where object_name like upper('%KRSC_STAFF_PROFS%') order
 by owner,object_name