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 8.1.7.4 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: 4565
Registered: April 1998
Senior Member
Hi,

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.

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


Current Time: Sat Sep 19 02:03:26 CDT 2020