Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DB_FILE_MULTIBLOCK_READ_COUNT dynamic?

DB_FILE_MULTIBLOCK_READ_COUNT dynamic?

From: Axel Schlueter <schluete_at_deneb.informatik.uni-hannover.de>
Date: 1996/12/02
Message-ID: <SCHLUETE.96Dec2094720@deneb.informatik.uni-hannover.de>#1/1

Hi experts,

I have a question concerning the INIT.ORA Parameter DB_FILE_MULTIBLOCK_READ_COUNT (DFMRC). In an announcement for Version 7.3, ORACLE said that this parameter would be dynamic, i.e. you could change it using the ALTER SYSTEM command.
Now, I'm using Version 7.3.2 on Solaris 2.4, but I don't find any documentation about this feature. There's no ALTER SYSTEM SET DB_FILE_MULTIBLOCK_READ_COUNT in the SQL reference, nothing in the server administration guide or the READMEs. The migration guide lists all dynamic INIT.ORA paramters --- no DFMRC there.
But I can use the command
ALTER SYSTEM SET DB_FILE_MULTIBLOCK_READ_COUNT = 16 The value is changed in V$PARAMETER and the whole thing seems to work.

Any ideas if dynamic DFMRC does not belong to the production release? Any experiences with different versions/OS?

Any help appreciated.

TIA Axel Schlueter
schluete_at_informatik.uni-hannover.de
Universitaet Hannover, Germany Received on Mon Dec 02 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US