Database Administration (MOSC)

MOSC Banner

Removing underscore / hidden parameter from spfile in 19c

Hi

We have a couple of 19c databases that for some reasons have a bunch of underscore / hidden parameters

We are trying to remove those. Here is an example here

alter system reset "_always_anti_join" scope=spfile sid='*';

System altered.

But when we did the show parameter or executed select name from v$parameter we are still seeing this parameter in there

We even bounced the database but it did not help at all. We are still seeing this parameter in the v$parameter file view and also using show parameter

How can we completely remove these hidden / undescore parameters from the database?

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