Estimating a SQL stmt execution time

From: <vfoster2_at_aol.com>
Date: Sat, 02 May 1998 12:04:59 -0600
Message-ID: <6ifjnr$efq$1@nnrp1.dejanews.com>

Is there any way to get Oracle to tell you how long a SQL stmt will run, either from SQL*Plus or Power Builder. I need this to tell users in a message box that "This statement will that x number of minutes to execute, do you wish to continue?"

Any input appreciated.

Vicky D. Foster,
Oracle DBA,
Manager, Database Services

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat May 02 1998 - 13:04:59 CDT