Drop empty table and lms flush message acks

From: mirfalk <mirfalk_at_yahoo.it>
Date: 31 Jul 2006 01:50:31 -0700
Message-ID: <1154335831.750886.190110@i3g2000cwc.googlegroups.com>

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. Received on Mon Jul 31 2006 - 03:50:31 CDT