Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What could be wrong with my DB if "drop table" hangs forever?

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

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: Mon, 11 Jun 2007 17:14:20 -0000
Message-ID: <1181582060.849826.241690@w5g2000hsg.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US