V$SQLAREA stats.

From: <mleith_at_bradmark.co.uk>
Date: Fri, 5 May 2000 16:08:41 +0100
Message-Id: <10488.105065@fatcity.com>

Hey people,

NT 4=2E0 sp6, Oracle 8=2E0=2E4

When querying V$SQLAREA, if i fire of this statement :

select sql_text, sorts, executions, disk_reads, buffer_gets from v$sqlarea order by buffer_gets;

When do the stats columns get updated? Say i have a 10 minute long=20= transaction running, and i fire this off half way through, will the stats be=20= up to date?

TIA Mark Leith
Bradmark UK Ltd
Tel: +44 1905 757 500
Fax: +44 1905 757 550
www=2Ebradmark=2Ecom
Work: mleith_at_bradmark=2Eco=2Euk
Personal: live_wire4001_at_yahoo=2Eco=2Euk
Yahoo Pager: live_wire4001 Received on Fri May 05 2000 - 10:08:41 CDT