RE: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 Error

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
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]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: elkinsl_at_flash.net

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: ListGuru_at_fatcity.com (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).