Skip to Content
0
Oct 12, 2011 at 09:25 AM

ORA-02095: specified initialization parameter cannot be modified

1428 Views

Hello All,

I am not able to set the below parameter.

USE_INDIRECT_DATA_BUFFERS=TRUE

When I issue the command:

alter system set USE_INDIRECT_DATA_BUFFERS=TRUE scope=BOTH;

I get an error saying:

ORA-02095: specified initialization parameter cannot be modified

But, i was able to set the parameter with this command

alter system set USE_INDIRECT_DATA_BUFFERS=TRUE scope=spfile;

However, upon checking with the command

SQL> show parameter USE_INDIRECT_DATA_BUFFERS

NAME TYPE VALUE

-


-


-


use_indirect_data_buffers boolean FALSE

Please help.

Thanks and Regards,

Ankit Mishra