Home » RDBMS Server » Performance Tuning » SLOW TABLE DROPS
SLOW TABLE DROPS [message #65881] Thu, 20 January 2005 17:56 Go to next message
Harry ronis
Messages: 1
Registered: January 2005
Junior Member
running Oracle on an aix Operating System.
Table creation updates etc running OK.
TABLE DROPS are SLOW, 30000 row table takes 6 secs
to drop.
Any reason for this?
Re: SLOW TABLE DROPS [message #65886 is a reply to message #65881] Thu, 20 January 2005 23:29 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

The solution is to migrate to LOCALLY MANAGED tablespaces.

If you cannot, and require a workaround, see Metalink Note: 68836.1 - How To Efficiently Drop A Table With Many Extents.

Best regards.

Previous Topic: 9i . suddenly started running slow
Next Topic: What if index using index is not sufficient
Goto Forum:

Current Time: Sat Mar 02 17:02:37 CST 2024