| 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: Too many extents....
Still 30 minutes is bad with this size and with LMT. Try to increase your
uniform extent size of your tablespace and try again. Besides emc storage
is much slower then Hitachi 9600 series storage.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Sat, 28 Jun 2003 11:29:18 -0800
Scads of extents in a dictionary managed tablespace...BAD!
In a dictionary managed tablespace with default storage of 104K/104K (I
didn't know this until way later / too late), I created a table (without
specifying storage) and loaded that thing up. It was taking up 7.5 GB
on disk when complete. Then later, when his new home was ready, I used
'alter table move' to put him there, followed by altering the source
tablespace offline and dropping it. On an HP N-class machine with 8
processors and 16 GB RAM and a very healthy EMC symm for storage, it
took almost 4 hours for Oracle to deallocate those 65,000 + extents,
coalesce and release the tablespace.
The same operation (move table, drop tablespace, etc.) took less than
30 minutes when going from/to LMTs with uniform of 50M.
Maybe later I'll try the original mess up with tiny extents / big table
in an LMT just for fun!
NOTICE BY ZALE CORPORATION This message, as well as any attached document, contains information from Zale Corporation that is proprietary, confidential and/or privileged. The information is intended only for the use of the addressee named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of this message or its attachments is strictly prohibited, and may be unlawful. If you have received this message in error, please delete all electronic copies of this message and its attachments, if any, destroy any hard copies you may have created, without disclosing the contents, and notify the sender immediately. Unintended transmission does not constitute waiver of any privilege.
Unless expressly stated otherwise, nothing contained in this message should be construed as a digital or electronic signature, nor is it intended to reflect an intention to make an agreement by electronic means.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Jun 28 2003 - 17:54:32 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |