Re: What could be wrong with my DB if "drop table" hangs forever?

On 11 Jun, 01:57, Ron Schnell <schn..._at_gmail.com> wrote:
> Oracle 10g:
> I create a small table with:
> create table foo (bar number(10), bletch varchar(32));
> Insert one row:
> insert into table foo (bar, bletch) values (25, 'test');
> Then try to drop it:
> drop table foo;
>
> The command hangs forever (1 hour so far). I'm looking for areas to
> check for trouble (undo tablespace?). Any pointers to scripts I could
> use (as sysdba, if required) would be great.

In addition to Sybrand's answer, it may be worth monitoring the alert log too.

HTH -g Received on Mon Jun 11 2007 - 07:44:29 CDT