Re: 8.1.7 v$session_longops garbage

cbo wrote:
>
> hello,
>
> i have a problem on a 8.1.7 / Windows 2003 Server
> and i cannot find any bug attached to these symptoms :
>
> when i read the v$session_longops for an SQL*Plus session, all is ok
> but for ODBC session, the select returns garbage
>
> when displaying session details from the Entreprise Manager (i click
> then on "long operations")... the same problem occurs
>
> any help greatly appreciated !
> Christian

Just add:

where time_remaining > 0

to get the stuff that's still outstanding

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------