Re: status when running an long run insert query

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 26 Jun 2001 23:00:15 +0100
Message-ID: <9hb0kc$6us$1@news.chatlink.com>

check out v$session_longops - its not guaranteed but your session might appear there

hth

--
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
"frank12345" <fluo_at_stirlingdouglas.com> wrote in message
news:5025b594.0106260822.75f7b24_at_posting.google.com...


> Hi Guys,

>

> Could you guys give me some hints for following question?

> How to check how many rows have been processed while running a long

> run insert query?

> I want to monitor the increasing row number.

>

> Thank you in advance.

>

> Frank

Received on Tue Jun 26 2001 - 17:00:15 CDT