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: Drop empty table and lms flush message acks

Re: Drop empty table and lms flush message acks

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 31 Jul 2006 08:42:38 -0700
Message-ID: <1154360558.770542@bubbleator.drizzle.com>


mirfalk wrote:
> Hi everybody,
>
> I'm working on oracle 10g+cluster+ASM and I'm facing a strange and
> unexpected behaviour.
>
> I'm trying to drop an empty (but big), table and after one hour and an
> half the drop statement is still there waiting to be completed.
>
> There are no locks currently active on that table and the session
> executing the statement is spending most of the time waiting for "lms
> flush message acks".
>
> The table is NOLOGGING and it's size is about 20000 Mb.
>
> The devices managed by ASM are not so fast (20M/s) but this doesn't
> seems to be the problem. I've got the sensation that the two sides of
> the cluster do not agree about the storage management.
>
> Any Idea?
>
> TIA
> A.D.

Drop table with or without PURGE? Have you looked in the recyclebin?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jul 31 2006 - 10:42:38 CDT

Original text of this message

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