Oracle DB 10gR2 preconisation parameters for Oracle EBS 11i

[latifa]

Hi Erman,

Do you know where can I find documentation on: 10gR2 DB preconisation parameters for Oracle EBS 11i ?

I found in DB init.ora:
optimizer_features_enable       = 9.2.0
optimizer_mode                  = choose

it's a bit tricky ...

Thank in advance for your reply.

Regards

Latifa

[ErmanArslansOracleBlog]

Hi Latifa,

The following document is what you are looking for:
Database Initialization Parameters for Oracle Applications Release 11i (Doc ID 216205.1)

Check Section 2.4: Release-Specific Database Initialization Parameters for 10gR2 (10.2.X)

[latifa]

Hi Erman.

Thank you very much.
I am already using it ...

Regards,
Latifa

[ErmanArslansOracleBlog]

So, that document is all that you need to follow.
There is no recommended parameters, there is mandatory parameters as given in that document.
Recommendation for init.ora parameters differs according to the environment.
Without knowing the environment, a recommendation for a parameter may lead you wrong.
One needs to know the environment and be able do the sizing accordingly.

On the other hand, the following parameters that you have given are unrelated, they are obsoleted..

optimizer_features_enable       = 9.2.0
optimizer_mode                  = choose

[latifa]

Hi Erman,

which quind of informations we need to know in order to put right values of parameters ?
How can we analyse performance problem ?

Thank you in advance for your advices.

Regards,
Latifa

[ErmanArslansOracleBlog]

Hi Latifa,

you need to know how oracle database works. You need to know it generally, but you need to get into the details when necessary, as well..

You need to know your application environment characteristics. In your case, this environment is EBS. Lots of reporting activity is going on? or lots of batch works are going on? Lots of users operating concurrently? etc..
You need to know the characteristics of your platform. For Exadata, we do some things, for other platforms we do other things..

The parameters and parameter tuning is in generally based on 3 things.
processing (CPU), Memory and IO. (ofcourse there are other init parameters which indirectly controls recovery and other stuff, but I m just giving you the basics)

In processing tier, we see parameters like parallelization related parameters. (parallelization is also related with IO)
In memory, we are acutally tuning the sga and pga in general
For IO, we actually don't do lots of thing, as we configure our IO Subsystem and in-db IO paths(indexes and so on)
There is also an OS layer tuning as welll. OS should perform well, when we (Oracle) want something from it.

So, this is a long story.
I don't know how well your Core Dba knowledge is.
I suggest you to read the definitions of the parameters, read some performance tuning articles, understand your environment characteristics, understand what your OS+Machine can do and then do your parameter tuning accordingly.

I almost forgot.. Read my book!
I have a Chapter dedicated to Performance and I m talking about all these parameters there.

Here is the link -> https://www.amazon.co.uk/Practical-Oracle-E-Business-Suite-Implementation/dp/1484214234

[ErmanArslansOracleBlog]

Take a look at this note.. This note seems good , may be a good start.
Where to Find Information About Performance Related Features (Doc ID 1361401.1)

[latifa]

Hi Erman,

Thank you very much for your advices.

I bought your book but I should find time to read it :) very good book, even we could installal EBS 12.2.4 directly on RAC rather than migrating to form a standalone. Any way I will study it ... inchallah

Regards,
Latifa

[latifa]

Very good Note for staring  ... Thank you very much :)

[ErmanArslansOracleBlog]

Good news Latifa :)

Keep going then..