Dick
V$session_longops has a column elapsed_seconds and a sid column
HTH
John
-Original Message-
Sent: 15 November 2002 18:59
To: Multiple recipients of list ORACLE-L
Quick question, Does anyone know of a location in the V$ tables where the
elapsed time of the current query is
V$session_longops only store info for create index, etc, not query.
Oracle use buffer_gets/500 as estimated time, you can get it at v$sql, v$sqlarea
-Original Message-
Sent: Monday, November 18, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L
Dick
V$session_longops has a column
Quick question, Does anyone know of a location in the V$ tables where the
elapsed time of the current query is stored??
Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051