On 6/24/07, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> Ujang
>
> > now, i'm not checking the 10053 trace. by OFE=817, the
> > v$session_longops give none of information, so i could not
> > monitor hows the jobs was done.... :(
>
> I'm not sure what you are looking in v$session_longops... But since the
> view does not provide execution plans it is useless for your specific
> problem.
>
I usually monitor the progress of long running SQL on that view.
when set OFE to 9.2.0 or higher, i can still monitor through that view.
but when OFE=817, it couldn't show me any progress
--
regards
ujang
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jun 24 2007 - 05:12:30 CDT
