Skip to Content
author's profile photo Former Member
Former Member

doubt to set /reset Oracle Parameters in 12c

Hello Team,

We have executed the oracle parameter script for 12c to check the missing parameter and the parameter requires to be deleted from the oracle database.

the details taken as per the note 1888485 - Database Parameter for 12.1.0.2

parameters

_advanced_index_compression_options

heat_map

Please let me know how to check whether Advanced Compression License is enabled or not

if not, can we set heat_map parameter alone.

Parameter

db_files - Currently the value set to 200, Do we need to set to >=11 or can we leave it as it is (200)

for most of the parameters

for example When i tried to delete the db_file_multiblock_read_count , i am getting the below error.

SQL> show parameter db_file_multiblock_read_count

NAME TYPE VALUE

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

db_file_multiblock_read_count integer 128

SQL> alter system reset db_file_multiblock_read_count scope =spfile;

alter system reset db_file_multiblock_read_count scope =spfile

*

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

SQL> alter system reset db_file_multiblock_read_count scope=spfile sid='*';

alter system reset db_file_multiblock_read_count scope=spfile sid='*'

*

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

When i list out show parameter, i could see the parameter exists

Please let me know how to reset these parameter mentioned in the note

Regards

Subb

pastedImage_0.png (20.5 kB)
pastedImage_1.png (19.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 10, 2016 at 10:33 PM

    If the database is licensed through SAP then the compression is part of that.

    105047 - Support for Oracle functions in the SAP environment

    Regarding the parameters, it is very clear from the script output.

    The parameter db_file_multiblock_read_count is not an issue. You are trying to reset a parameter which is not set and the system throws the error.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2016 at 11:26 AM

    Hello Subb,

    Q1) Compression Licensing

    A1) See note: 2254866 - Using Oracle Database 12c Automatic Data Optimization with SAP NetWeaver.


    Q2) db_files

    A2) You really are taking this too literally. ">=11" means a value greater than or equal to 11. As your value = 200 you are fine.


    Q3) db_file_multiblock_read_count

    A3) The error is quite simply telling you that the parameter isn't set in the spfile (correct). You see the parameter with a value of 128 as it is being automatically calculated as opposed to being explicitly set in the spfile. You have nothing to change.


    KR,


    Amerjit



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 12, 2016 at 12:18 PM

    Hello ,

    set the parameter in pfile and create the spfile. I hope you got the answer from Regan about the license.

    Thanks,

    BM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.