Claudio, Thanks for the info. It sounds like Oracle's recommended solution worked for you. I'm worried about the folks who said it didn't and was curious if anyone else had found the extent > max_io_size solution didn't work. Oh well, once things calm back down on that QA box we will take the time to try this. In the meantime, a "low" value for hash_mutliblock_io_count is getting us around the issue.
Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of claudio > cutelli > Sent: Friday, February 08, 2002 9:08 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 > Error > > > When i had this problem i put initial and next extent size of temporary > tablespace > equal or greater than MAX_IO_SIZE. > > Example: With MAX_IO_SIZE= 128K > the default storage for the initial and next extent > must be >= (128 * 1024) = 131072 bytes. > > MAX_IO_SIZE is an Operating system dependant parameter. > > you can find MAX_IO_SIZE putting db_file_multiblock_read_count = > 1000000 and > than > trace a full table scan, look in the trace and find the third > field in wait: > db file scattered read to find > number of bd_block read for any I/O operation. > > Ciao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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).
