RE: Temp space for sorting?

I have a database with a table of 21 GB in size. I understand that for sorting it is recommended to have 2 or 3 times for temp dbspace. My question is should I use a very large file system, using the PSORT_DBTEMP environment parameter, or allocate at least 64 GB to a temp dbspace? What are the positives/negatives of both options? And to further complicate the issue, there may be over 200 users trying to run queries that require at least 350 MEG and up to 1.15 GB of space. How I know this is that I am currently using a file system for temp space. Are there any other settings/changes I can make? The instance is a 7.31UD8 version. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " **************************************

Knox, Ernest wrote: > I have a database with a table of 21 GB in size. I understand that for sorting > it is recommended to have 2 or 3 times for temp dbspace. My question is should > I use a very large file system, using the PSORT_DBTEMP environment parameter, > or allocate at least 64 GB to a temp dbspace? What are the positives/negatives > of both options? And to further complicate the issue, there may be over 200 > users trying to run queries that require at least 350 MEG and up to 1.15 GB of > space. How I know this is that I am currently using a file system for temp > space. Are there any other settings/changes I can make? The instance is a > 7.31UD8 version. > Using 3 or more filesystems on independent structures is the fastest. Using 3-6 temp dbspaces is easiest to manage. Art S. Kagel > Thanks, >