8.1.7 v$session_longops garbage
cbo
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
DA Morgan
'Garbage' is not a particularly useful phrase if you are looking
for help. How much more would have cost to post it? ;-)
But I'd look for a character set mismatch as one possibility.
--
Puget Sound Oracle Users Group
Matthias Hoys
"cbo" <c...@noname.nonet> wrote in message
news:44fdb9ed$0$1808$636a...@news.free.fr...
I have the same problem with Enterprise Manager 9.2, but never found a
solution. I think it's mostly related to queries who have finished but where
the session is still alive.
Sybrand Bakker
wrote:
>But I'd look for a character set mismatch as one possibility.
Don't think so. v$session_longops has always contained garbage,
especially when the query was no longer running.
--
Sybrand Bakker, Senior Oracle DBA
Connor McDonald
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_...@yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------