Re: v$sql - when information is updated

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 26 Jul 2007 01:37:25 -0400
Message-ID: <iicga31pfb6il2t6hemsl3kh2h8nuitneb@4ax.com>

On Wed, 25 Jul 2007 15:09:17 -0700, zigzagdna_at_yahoo.com wrote:

>If I am running a sql statement which takes long time (several
>miutes). Will information in v$Sql (such as elapsed_time, cpu_time,
>rows_processed ....updated as statement is executed or information is
>updated only after statement has been executed completely.

Try reading up on v$session_longops
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Jul 26 2007 - 00:37:25 CDT