Re: v$sql - when information is updated

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 26 Jul 2007 16:29:24 -0000
Message-ID: <1185467364.050988.221430@m37g2000prh.googlegroups.com>

On Jul 25, 6:09 pm, zigzag..._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.

The time spent (elapsed and CPU) will be updated, but the executions column will not.

Regards,

Steve Received on Thu Jul 26 2007 - 11:29:24 CDT