My Oracle Support Banner

Confused when trying to set the parameter '_bug18418984_ges_vbfreelists' (Doc ID 2724570.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

 

- Can see the fix 18418984 after applying the fix for 31904500

[diaeesd3qa:/orahome/app/oracle/product/11.2/dbs]$ opatch lsinv -bugs_fixed |
grep 18418984
18418984   24438247  Tue Sep 26 11:53:10 KST 2017   HIGH LATCH FREE WITH
DISTRIBUTED TXN DESPITE FIX

- But can't set the parameter like below.

--With pfile
ORA-01078: Failures in processing system parameters
LRM-00101: Unknown parameter name '_bug18418984_ges_vbfreelists'

--With spfile
SQL> alter system set "_bug18418984_ges_vbfreelists"=0 ;
alter system set "_bug18418984_ges_vbfreelists"=0
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL> alter system set "_bug18418984_ges_vbfreelists"=0 scope=spfile;
alter system set "_bug18418984_ges_vbfreelists"=0 scope=spfile
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

 Note both 18418984 31904500 are unpublished bugs.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.