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