Re: Can DB_FILE_MULTIBLOCK_READ_COUNT be changed live?

From: Andrew Allen <andrew.allen_at_handleman.com>
Date: Thu, 13 Feb 2003 17:59:18 GMT
Message-ID: <3E4BCFEA.8080608@handleman.com>

Rhugga wrote:
>
> I am using DBArtisan for Oracle management and it seems that the
> DB_FILE_MULTIBLOCK_READ_COUNT setting can be changed and active
> immediately while the database is up, without bouncing the instance. I
> was under the impression all init.ora params in Oracle 8i needed an
> instance restart.
>

Direct from v$parameter (8.0.6):

                                            Is      Session    System 
   Is       Is
Parameter                           Value  Default Modifiable Modifiable 

Modified Adjusted

=================================== ====== ======= ========== ========== 
======== ========
db_file_multiblock_read_count       8      FALSE   TRUE       IMMEDIATE 

  FALSE FALSE Shows that in can be changed online for session of system.

--
Andrew Allen

Received on Thu Feb 13 2003 - 11:59:18 CST