How to get the SQL details for Particular SID

select sid, serial#, username, status, sql_id, program from v$session where sid = 198;

select sql_text from v$sql where ADDRESS =<SQL ID>;

To get to know the ETA for query.

select sid, serial#, sofar, totalwork, start_time, time_remaining, username from v$session_longops where sql_id = '<SQL ID>';




Happy Learning..!!
Cheers..!!