Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When does Oracle decide it's dealing with 'long ops' ?
As the documentation states: "This view displays the status of various
operations that run for longer than 6
seconds (in absolute time). These operations currently include many
backup and
recovery functions, statistics gathering, and query execution, and more
operations
are added for every Oracle release."
You can also set rows in this view using the procedure
dbms_application_info.set_session_longops.
Received on Tue Jun 07 2005 - 07:23:05 CDT