Hi,
I am runing a query through out the night.. how
can I know when the query is done.
Printable View
Hi,
I am runing a query through out the night.. how
can I know when the query is done.
Could we get a little more explanation?
If you want to know how long one specific query took in a sqlplus script, use:
SQL> set timing on
SQL> select count(*) CNT from myTable;
CNT
-----------
12
Elapsed: 00:00:00.1
SQL>
Hi,
actually I am trying to create a table using couple of views.
SQL> create table mytable as select * from myview.
and I am trying to figure out how long did it take to create
mytable.
thanks,