Re: init.ora parameters

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 8 Jul 1999 16:18:41 +0100
Message-ID: <931447467.8249.2.nnrp-06.9e984b29@news.demon.co.uk>

If your O/S supports vector reads as the O/S level then this parameter allows Oracle to use the feature.

This can allow some platforms to do 32 blocks as the db_file_multiblock_read_count irrespective of block size, and ignoring the normal 64K (max_phys_iosize) value.

Test it by setting event 10046 at level 8, and seeing how big parameter 3 gets on tablescan reads.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

eric_peterson_at_maurices.inrg.com wrote in message <7m2c53$chb$1_at_nnrp1.deja.com>...
>I am currently on 7.3.3.6 and have come across a parameter in which I
>have been unable to find information on. The parameter resides in the
>init.ora and is USE_READV. By default, it is set to FALSE. Does
>anyone know what this parameter does when it is set to TRUE? Any
>information would be helpful. Thank you in advance.
>
>Thank you and have a great day!
>
>Tx
>Eric Peterson
>Programmer/Analyst DBA
>Maurices Inc.
>eric_peterson_at_maurices.inrg.com
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jul 08 1999 - 10:18:41 CDT