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: resize datafile contention

Re: resize datafile contention

From: Ben <balvey_at_comcast.net>
Date: Tue, 16 Oct 2007 04:24:07 -0700
Message-ID: <1192533847.006684.117950@k35g2000prh.googlegroups.com>


On Oct 16, 7:20 am, Ben <bal..._at_comcast.net> wrote:
> On Oct 16, 4:06 am, csn..._at_gmail.com wrote:
>
> > To the OP, yes it does sound like fet$/uet$ contention, and there is
> > nothing you can do except be patient and wait, in the knowledge that
> > you are getting rid of the problem, slowly but surely as you move to
> > LMT.
>
> well, it only took about 2.5 hours to drop the tablespace. Then guess
> what, the OS still doesn't see the space. great.

Also, I forgot to ask. Any idea why I see the contention with inserts while I'm doing a resize or coalesce and I don't see the contention when I'm doing an 'ALTER TABLESPACE ... DROP'? Received on Tue Oct 16 2007 - 06:24:07 CDT

Original text of this message

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