Re: DDL & long-running query

Hi John,
 Maybe sometimes query fail,maybe ddl have to wait.I think it's depend on what type of ddl.
 Here is a test case:
SQL> select count(*) from t; - full table scan big table t

On another session
 SQL>remove t to t_temp;
 table renamed.

You can do many tests.

Thanks.

Steven
a new DBA Received on Tue May 10 2005 - 22:26:39 CDT