Adding Oracle Parameters

Posted on 2008-11-04
Last Modified: 2013-12-19
Oracle9i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE      Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

I am trying to add some oracle parameters on my PR3 system and this is what I am getting:
SQL> show parameter spfile;

 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------

spfile                               string      %ORACLE_HOME%\DATABASE\SPFILE%


SQL> alter system set _eliminate_common_subexp =false scope=spfile;
alter system set _eliminate_common_subexp =false scope=spfile

ERROR at line 1:
ORA-00911: invalid character

I believe it does not like the underscore at the start of this parameter _eliminate_common_subexp.   I believe what I need to do is go back to the INIT.ORA type parameter file
SQL> create pfile from spfile;
Manually add all the Oracle Initialization Parameter with underscores (example: _eliminate_common_subexp, _optimizer_join_sel_sanity_check, _optimizer_or_expansion) to the  INIT.ORA  and than create the SPFILE again.

SQL> create spfile from pfile;
Or is there another way of adding these parameters to the SPILE ?
Thanks for your time

I also tried:

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



Question by:algotube
    LVL 10

    Accepted Solution

    you sure that's the correct hidden parameter

    _eliminate_common_subexpr     (you're missing an R at the end)

    Author Closing Comment

    Oh my God dbmullen. I was following a consultant solution and just trusted it was right....... Thank you for pointing that out.....  

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now