cancel
Showing results for 
Search instead for 
Did you mean: 

DB_FILE_MULTIBLOCK_READ_COUNT not set in Oracle10g

Former Member
0 Kudos

Hello,

Do you know what means the parameter DB_FILE_MULTIBLOCK_READ_COUNT not to be set?

In the part Performing Post-Upgrade Tasks from the Upgrade Guide I read

"Make sure that the following database parameters, if set, are removed;"

And in one other note "Especially ensure that db_file_multiblock_read_count is NOT set."

How can I remove the parameter? It has the Default Value : 8

Thanks in advance.

Many regards,

Ruzica

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ruzica,

So we're at the next step!

Well, this parameter was recommended for Oracle 8.x & 9.x (OSS note 124361), but for Oracle 10g is obsolete.

Follow note 830576, and adjust your DB parameters as recommended there.

Best Regards,

JC LLanes.

Former Member
0 Kudos

Hi Juan,

I've finished the upgrade successfully, but I left some undone things some interim patches and this parameter.

I did everything like in the note 830576 for all DB parameters, except for DB_FILE_MULTIBLOCK_READ_COUNT .

I don't know how I <b>to NOT set it</b>.

Now I use spfile. Should I do:

sql>create pfile from spfile;

then change the init.ora by removeing this parameter and

sql>create spfile from pfile;

How did you unset the db_file_multiblock_read_count?

Many regards,

Ruzica

Former Member
0 Kudos

Hi Ruzica,

You can delete parameter entries from the SPFILE using the following command: SQL>ALTER SYSTEM RESET <parameter_name> scope = spfile sid = '*';

You can find all the needed info about SPFILE at note 601157 (it's about 9i, but the use is identical with 10g).

Best Regards,

JC Llanes.

Former Member
0 Kudos

Hi Juan,

I did:

SQL> show parameter DB_FILE_MULTIBLOCK_READ_COUNT;

NAME TYPE VALUE

-


-


-


db_file_multiblock_read_count integer 8

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 2046820352 bytes

Fixed Size 2057992 bytes

Variable Size 771754232 bytes

Database Buffers 1258291200 bytes

Redo Buffers 14716928 bytes

Database mounted.

Database opened.

SQL> show parameter DB_FILE_MULTIBLOCK_READ_COUNT;

NAME TYPE VALUE

-


-


-


db_file_multiblock_read_count integer <b>128</b>

SQL>

Now the parameter has value 128?!?!?

Did you do the same?

Thanks,

Ruzica

Former Member
0 Kudos

I forgot first:

ALTER SYSTEM RESET DB_FILE_MULTIBLOCK_READ_COUNT scope = spfile SID='*';

Former Member
0 Kudos

Hi,

Yes, that's correct. You don't have to fix it to a value (and that's why you RESET it), the server assign it dynamically at DB start.

Regards,

JC Llanes.

Former Member
0 Kudos

Hi,

THANKS Juan,

Regards,

Ruzica

Answers (0)