Skip to Content
avatar image
Former Member

Database parameter

Hi all,

We have done the following database parameter changes

SQL> show parameter _securefiles_concurrency_estimate

NAME TYPE VALUE

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

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

_securefiles_concurrency_estimate integer 50

SQL> show parameter _simple_view_merging

NAME TYPE VALUE

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

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

_simple_view_merging boolean FALSE

We have also applied latest SBP after that changes  Entire performance has

been downgraded.

Please suggest.

Regards,

MS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 14, 2013 at 03:33 PM

    Hi,

    What is the Oracle release and version?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2013 at 02:08 AM

    hi MS,

    Please have a look at this SAP Note.

    Note 1431798 - Oracle 11.2.0: Database Parameter Settings

    Regards,

    Add comment
    10|10000 characters needed characters exceeded