| 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: Temporary Tablespace Design
Hi Chris,
Yes there may be 'rules' like this, but realistically who has 64GB to spend on disk space? I have one huge table similar to what you describe. My temp tablespace is 20GB only because I have the disk. Maybe you can take the route of determining how large your largest index would be on this table and size it from that? Of course that doesn't help with any long running processes that cause large sorts, but it's a place to start.
HTH
Lisa Rutland Koivu
Oracle Database Administrator
lkoivu_at_qode.com
NeoMedia
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com <http://www.neom.com> www.paperclick.com <http://www.paperclick.com> www.qode.com <http://www.qode.com>
Enter Your PaperClick Code Here!
-----Original Message-----
From: CC Harvest [mailto:ccharvest_at_yahoo.com]
Sent: Thursday, April 12, 2001 4:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Temporary Tablespace Design
What's your experience about the temporary table design? I read Michael Ault's Orcale8 Administartion and Management , it says "For Cost-based optimization, it should be 4 times of the largest table". I have a table of 60 Million records, and it costs 16GB, should I have a 64GB temp tablespace(I don't think so, though it's a 100GB database, and I have a 300GB of diskspace).
Thanks for your advice.
Chris
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC HarvestReceived on Thu Apr 12 2001 - 06:55:25 CDT
INET: ccharvest_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
 |
 |