On Jun 11, 8:44 am, gazzag <gar..._at_jamms.org> wrote:
> 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
I have seen similar behavior in 10gR1 when change tracking was
enabled. Was change tracking was disabled all issues went away.
Unfortunatelly, I never had the time to revisit the issue, but it may
be worth checking.
Received on Mon Jun 11 2007 - 12:14:20 CDT
