10M temp TS? You must have quite a nicely controlled working environment, Jared! ;)
But your example does bring up a question: For TEMP and RBS LMTs, does the Goldilocks Rule (128K/4M/128M uniform extents, post version 7.x) follow? I had created my TEMP and RBS with 1MB uniform before knowing about Goldilocks and the infamous "How to Stop Defragmenting and Start Living" white paper. And that paper is a little vague about TEMP and RBS LMTs, other than to say that there should be between 1024 and 4096 extents in each. Thoughts? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com] > Sent: Wednesday, November 06, 2002 3:35 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Convert TEMP tablespace from datafiles to tempfiles > > > create temporary tablespace temp2 > tempfile '/u01/oradata/dv01/temp2.dbf' size 10m > extent management local uniform size 128k; > > HTH > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
