Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to estimate total execution time of a query...?

OraFighterDec 11 2012 — edited Dec 14 2012
How can I calculate total execution time of a query .

Example :
   select * from table1  ; -- table size is 100GB. 

  OR

   exec DBMS_STATS.GATHER_SHEMA_STATS('USER1', estimate_percent => 15);
statistics gathering not finished even after 2hrs...

is there any way to calculate total time it will take to run..I mean an approximate time.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2013
Added on Dec 11 2012
12 comments
49,346 views