Hi
I'm trying to define a new "session Query" that shows long running operations.
My problem is that the columns seem to be sorted randomly. My select clause is:
SELECT s.sid,
s.serial#,
l.opname,
l.target,
l.target_desc,
l.sofar,
l.totalwork,
l.units,
l.time_remaining,
l.elapsed_seconds,
s.sql_address,
s.sql_hash_value,
s.sql_id,
s.sql_trace
FROM v$session s,
v$session_longops l
WHERE s.username IS NOT NULL AND l.sid = s.sid AND l.serial# = l.serial# AND s.status = 'ACTIVE'
ORDER BY s.logon_time,
s.sid
but the column order shown is:
sid,
serial#,
totalwork,
sql_hash_value,
opname,
target,
target_desc,
sofar,
units,
time_remaining,
elapsed_seconds,
sql_address,
sql_id,
sql_trace
What am I doing wrong??
Best Regards
Rasmus
I'm trying to define a new "session Query" that shows long running operations.
My problem is that the columns seem to be sorted randomly. My select clause is:
SELECT s.sid,
s.serial#,
l.opname,
l.target,
l.target_desc,
l.sofar,
l.totalwork,
l.units,
l.time_remaining,
l.elapsed_seconds,
s.sql_address,
s.sql_hash_value,
s.sql_id,
s.sql_trace
FROM v$session s,
v$session_longops l
WHERE s.username IS NOT NULL AND l.sid = s.sid AND l.serial# = l.serial# AND s.status = 'ACTIVE'
ORDER BY s.logon_time,
s.sid
but the column order shown is:
sid,
serial#,
totalwork,
sql_hash_value,
opname,
target,
target_desc,
sofar,
units,
time_remaining,
elapsed_seconds,
sql_address,
sql_id,
sql_trace
What am I doing wrong??
Best Regards
Rasmus
