Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Long running operations, v$session_longops

Long running operations, v$session_longops

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 4 Jan 2007 13:47:41 +0200
Message-ID: <6e49b6d00701040347x2aa80fe9i247a9c64d1ab8e3@mail.gmail.com>


At the end of the last year there were a few questions about long running operations. I was inspired by these questions to write an article describing longops.
It can be found in http://www.gplivna.eu/papers/v$session_longops.htm

Main facts highlighted there are as follows (first two are probably commonly known, but 3) and 4) are usually targets of questions):

  1. Not all operations that are running longer than 6 seconds are considered as long operations. Built-in long operation types are strongly defined although increasing with every new Oracle version.
  2. There are some other criteria to show the particular operation type in v$session_longops.
  3. Long operations of particular kind can be very different i.e. they can actually do many more things behind the scenes and one cannot find out that just looking at long operation.
  4. Oracle considers long operations as linear operations (each unit of work takes the same amount of time) therefore estimated completion time can be inaccurate in case the real process is not linear.

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 04 2007 - 05:47:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US