on 04-27-2007 11:29 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.