Enhancement for the Toad session browser based on the LONG OPS tab (4325832)

Enhancement request for Toad for Oracle session browser, the LONG OPS Tab shows not only current session's LONG OPS information, it includes all past historical session LONG OPS with the same SID.

Here are the recommendations:

SELECT SID, decode(totalwork, 0, 0, round(100 * sofar/totalwork, 2)) "Percent",
message "Message", start_time, elapsed_seconds, time_remaining
from v$Session_longops where (sid = :b1 or sid = :b2)
and start_time >= :parent_sid_logon_time ORDER BY SID;

or

SELECT SID, decode(totalwork, 0, 0, round(100 * sofar/totalwork, 2)) "Percent",
message "Message", start_time, elapsed_seconds, time_remaining
from v$Session_longops where (sid = :b1 or sid = :b2)
and start_time >= SYSDATE - (:Parent_last_call_et / 3600 / 24)
ORDER BY SID;

In the Session Browser, the LONGOPS tab shows all long operations for a given SID and Serial number, regardless of logon time.
This means that the longops relate to a given SID number e.g. an SID number from the previous day.
As the SID numbers are reused, this can cause confusion.

WORKAROUND
It's true that SIDs are reused, but  they are matching up by SID and Serial number.
Serial numbers are NOT reused, so anything displayed in the longops tab should actually be from one of the selected sessions on the top half of the screen.

STATUS
Enhancement request ST57619 has been submitted to Development for consideration in a future release of TOAD for Oracle.