Hi all
We have Oracle 11g installed on windows server 12. We have altered system to have sql_trace = true which is shown correctly as true in the
v$parameter
Still we dont' find any rows for the long running operations. We use the following sql.
SELECT s.SID,s.serial# serial,s.username,s.machine,s.program,ROUND(sl.elapsed_seconds/60) || ':' ||MOD(sl.elapsed_seconds,60) elapsed,ROUND(sl.time_remaining/60) || ':' ||MOD(sl.time_remaining,60) remaining
,ROUND(sl.sofar/sl.totalwork*100, 2) progress_pct FROM v$session s,v$session_longops sl WHERE s.SID = sl.SID AND s.serial# = sl.serial#
and s.status = 'ACTIVE' and s.username <> 'SYSTEM' and sl.elapsed_seconds > 1 ORDER BY 6 DESC;
Sql works but dont show any result. We made cross join sql also returning say more than 100000 rows and taking about 30 seconds. Still that is not shown in the above sql result.
If you can provide some purposely slowing down the sql to test it ->would be still better.
Pl advise as to where is the mistake.
Thanks in advance
Suresh Bansal