Re: RecordCount

From: rs <info_at_bytelife.com>
Date: Sun, 22 Dec 2002 16:29:46 +0100
Message-ID: <3e05dbfe$0$11528$7a0f4ed3_at_energis-news-env>

Hello Pascal,

IF it's really big and involves a full table-scan: select sid,username

      ,to_char(start_time,'hh24:mi') strt
      ,sofar ,totalwork
      ,elapsed_seconds,time_remaining
      ,units,OPname

from V$SESSION_LONGOPS
order by time_remaining ;

Usually works on full table-scans of large tables. You can also write to longops in your PL/sql source.

--
Good luck,
     Roelof Schierbeek

R.Schierbeek, DBA
e-mail: info_at_nSpammbytelife.com
www   : www.bytelife.com
sql   : www.bytelife.com/sql4dba.htm

ZigZag <zigzag_at_Krosoft.fr> schreef in atuvjt$bp$1_at_s1.read.news.oleane.net...


> Hello,


> How can i know,  during execution, the state of a big query with the

> percent of execution or row number

>

> Pascal

Received on Sun Dec 22 2002 - 16:29:46 CET