DROP TABLE always takes long time.

What would cause all DROP TABLE commands, even on the simplest of tables, those with no indexes, rows, or constraints, to take an inordinately long time?

For example:

	CREATE TABLE mytable (
		name	VARCHAR2(10),
		qty	NUMBER(9,0)
	);

takes about 2 seconds. But

        DROP TABLE MYTABLE; takes 3.5 minutes;

There is nobody else accessing the take so it shoudn't be a locking problem.

The session wait event is usually RDBMS IPC REPLY.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!