Re: v$sql - when information is updated

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.

varies by version.

if memory serves, v9 and below - at completion. v10 and above - every 3 seconds.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------