Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Note 830576 - Parameter recommendations for Oracle 10g

As per SAP Note 830576 - Parameter recommendations for Oracle 10g, I have tried to change the value for

parameter "db_file_multiblock_read_count".

In sql prompt it shows:

SQL> show parameter DB_FILE_MULTIBLOCK_READ_COUNT

NAME TYPE VALUE

-


-


-


db_file_multiblock_read_count integer 128

and in brtools it shows:

58 - db_file_multiblock_read_count both no * yes 128

But I got the following error, when i tried to set it null

1 * Parameter description (desc) ..... [db block to be read each IO]

2 * Parameter type (type) ............ [integer]

3 * Current parameter value (parval) . [128]

4 * Value in spfile (spfval) ......... []

5 # New parameter value (value) ...... [null]

6 - Scope for new value (scope) ...... [both]

7 # Database instance (instance) ..... []

8 ~ Comment on update (comment) ...... []

9 - SQL command (command) ............ [alter system reset db_file_multiblock_read_count scope = spfile sid = '*'; alter system reset db_file_multiblock_read_count scope = memory sid = 'MBD']

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2008-08-14 18.19.22

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2008-08-14 18.19.23

BR0301E SQL error -32010 at location BrSqlExecute-1, SQL statement:

'/* BRSPACE / alter system reset db_file_multiblock_read_count scope = spfile sid = '''

ORA-32010: cannot find entry to delete in SPFILE

BR1017E Execution of SQL statement 'alter system reset db_file_multiblock_read_count scope = spfile sid = '*'; alter system reset db_file_multiblock_read_count scope = memory sid = 'MBD'' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2008-08-14 18.19.23

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Kinldy let me know, what could me wrong.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question