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
[EMAIL PROTECTED]
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>
P a p e r C l i c k . c o m <http://www.paperclick.com/home.htm>
Enter Your PaperClick Code Here!
-----Original Message-----
From: CC Harvest [mailto:[EMAIL PROTECTED]]
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
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CC Harvest
INET: [EMAIL PROTECTED]
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: [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).
