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;
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
Click Here to Expand Forum to Full Width