10M? Hardly. That was just a test script to make sure the syntax was correct. 10m just happens to be created very quickly.
The sort_area_size equal or be a multiple of your TEMP extent size. Jared On Thursday 07 November 2002 09:18, Jesse, Rich wrote: > 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: Jared Still 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).
