| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent! Taking a Long Time to drop Tables
The truncate will also take a long time
if the number of extents is very high
for the segment.
---
Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Tuesday, December 19, 2000 3:07 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent! Taking a Long Time to drop Tables
Agree, but why truncate take less time - if not use reuse storage clause it should drop all extents also.
Alex Hillman
-----Original Message-----
From: Adams, Matthew (GEA, 088130) [ mailto:MATT.ADAMS_at_appl.ge.com
<mailto:MATT.ADAMS_at_appl.ge.com> ]
Sent: Tuesday, December 19, 2000 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent! Taking a Long Time to drop Tables
If the number of extents in the table is very large, then dropping the table will take a long time due to the recursive SQL necessary to manage the data dictionary.
> -----Original Message-----
> From: Larry Taylor [ mailto:ltaylor_at_iq.com <mailto:ltaylor_at_iq.com> ]
> Sent: Tuesday, December 19, 2000 2:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Urgent! Taking a Long Time to drop Tables
>
>
> Hi all,
>
> Does anyone out there have any suggestions as to
> why it would take 12 minutes to drop tables.
> Where should I look first?
Received on Tue Dec 19 2000 - 14:29:32 CST
 |
 |