On Jun 11, 2:57 am, 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.
The usual course of action is to set up a different session and to
find out what the original setting is waiting for.
You'll need to find out the session, and query v$session_waits and v
$session_event to see what is exactly happening. Maybe you also need v
$lock: you can't drop a table when someone is running a query on it as
this will result in a lock on the corresponding datadictionary record.
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jun 11 2007 - 04:13:30 CDT
