Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop empty table and lms flush message acks
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.orgReceived on Mon Jul 31 2006 - 10:42:38 CDT