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.