sid from request id

==============SID from Request sid ============================

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID

session long ops

select SID,SERIAL#,SQL_ID,SQL_HASH_VALUE,TOTALWORK,SOFAR,TIME_REMAINING from v$session_longops where sid in (4892) and nvl(totalwork,0) <> nvl(sofar,0)


Session wait

select s.sid,s.serial#,s.sql_id,s.row_wait_file#,s.row_wait_obj#,o.object_name,s.event,s.seconds_in_wait,s.blocking_Session
from v$session s, dba_objects o
where s.row_wait_obj# = o.object_id(+)  and s.sid=5294;

Last analyzed :

col index_owner for a20
col table_owner for a20
col index_name for a30
col table_name for a30
col column_name for a30
select index_owner,index_name,table_name,table_owner,column_name,column_position
from dba_ind_columns where table_name=upper('OKC_K_LINES_B_N5') order by 2;


 set autot trace exp