alf 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
&
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 paramete
This is sort of true. Steve's test will tell you what
you can currently achieve based on your current
system. File system and/or kernel restrictions may
limit what is actually possible on the platform.
eg a stock-standard newfs on Solaris will typically
limit you to 256k; playing with maxcontig
ive db_file_multiblock_read_count
> for my setup is 25.
>
> Ironically, I had set it to 26...
>
> Thanks everyone!
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>
> -Original Message-
> Sent: Friday, January 18, 2002
: Friday, January 18, 2002 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: max_io_size
Patrice,
You can determine this for yourself with a script:
http://www.ixora.com.au/scripts/io_opt.htm
The script is at the bottom of the page.
It's a pretty simple test, yo
égion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 18, 2002 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: max_io_size
Patrice,
You can determine this for yourself with a script:
http://www.ixora.com.au/scripts/io_opt
Patrice,
You can determine this for yourself with a script:
http://www.ixora.com.au/scripts/io_opt.htm
The script is at the bottom of the page.
It's a pretty simple test, you can easily do it manually as well.
Jared
"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/18
Ross,
IMHO Depends on Your IO subsystem. I am on HP 11.0 and
XP 256 and ORACLE 816 (ALL 64 BIT) and ORACLE gets
data in 1M chunk of data in one IO call while all the
others being the same except storage being AUTORAID we
are getting 256 MB chunks.
Steve Admas has a script and some goodies on this
Patrice - I was unable to catch my sys admin before he left. I went to
Google and did a search for max_io_size and received several interesting
links. In one document it was referred to as the "operating system's maximum
I/O size". On the Tru64, that is a very large number, so I suspect that you
a
oracle still does 64K read afaik.
so, 64K divided by block size, ceteris paribus
-Original Message-
Sent: Friday, January 18, 2002 2:56 PM
To: Multiple recipients of list ORACLE-L
Where can I find information on this parameter on the Tru64 UNIX platform?
I did a scan of the manuals fo
10 matches
Mail list logo
