Live and learn. New with Oracle 11. However, this will still result in an ORA-00054, only quicker. I'm not sure that it will resolve the situation since the original (unconnected) server session isn't the one with the ddl_lock issue. It's problem is that it can't connect to its client. You still need to kill that session on the server. On Wed, Mar 23, 2011 at 12:17 PM, Taral Desai <taral.desai@xxxxxxxxx> wrote: > * > * > alter sesion set ddl_lock_timeout > > On Tue, Mar 22, 2011 at 8:26 PM, Mani <manips2002@xxxxxxxxx> wrote: > >> ORA-00054 > > > > > -- > Thanks & Regards, > Taral Desai >