Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!wn13feed!worldnet.att.net!128.230.129.106!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: elapsed times for current queries X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <401EC82F.E661DFA6@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: Mime-Version: 1.0 Date: Mon, 2 Feb 2004 21:59:11 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 29 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253490 If the query has been running for quite a while, then V$SESSION_LONGOPS will show you the elapsed time along with the estimated time remaining. HTH, Brian Richard Kuhler wrote: > > Is there a way to get the elapsed times for all currently running > queries? V$SQL.ELAPSED_TIME won't work because it's only updated when a > query finishes. V$SESSION.LAST_CALL_ET won't work because it's only > reset at the start of a PL/SQL call (not for each statement). > > Any ideas? > > -- > Richard Kuhler -- =================================================================== Brian Peasland dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"