High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

How to set hidden parameter in Oracle

Dear experts,

I'm trying to set hidden parameter in Oracle 12.2 Production Environment


alter system set '_min_undosegs_for_parallel_fptr'=0 scope=both;

ORA-00922:...

SQL> alter system set "_min_undosegs_for_parallel_fptr" = 0 scope=both;

alter system set "_min_undosegs_for_parallel_fptr" = 0 scope=both

ORA-02065


alter system set "_min_undosegs_for_parallel_fptr"=0 scope=spfile;

ORA-02065:

SQL> show parameter pfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string path to spfile


How could I set this parameter in Primary and Standby?


Thanks,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center