resource configuration

[Sri]

Erman,

we have 2 nodes,1 application node and 1 db node

Our server configuration

64Gb ram and 4 cpu's

SQL> !cat /proc/cpuinfo|grep -i processor|wc -l
4

process 800
sessions 1224

Our max capacity in datasource is 500.How many connections can we configure with this configuration?can you give us some idea

Thank you

[ErmanArslansOracleBlog]

you can have max 1224 sessions
From 1 apps node's FMW, you can max open 500 connections to the database.
800-500=300 -> this  300 will be left for the under connections which are non-FMW. (for ex: Toad, conc managers etc..)

If you have 2 app nodes. This means you have 2 datasources.

If each of them has max 500 connections, then you may be reaching to the maximum..
I don't know your load but I recommend you to increase your process count to some value around 1000 and 1500. After restart your db. Sessions will be automatically derived by your processes value.. So you don't need to set sessions parameter. Also ensure your DB tier OS is configured to handle this setting.. (I mean semaphore counts, open files limit and process limit)

[Sri]

Thanks erman

How to calculate how much memory and cpu is required to handle number of sessions/processes

[ErmanArslansOracleBlog]

It depends on the environment.
as for db , we have sga and pga. So processes on db tier, maps and use SGA but they also use pga, which is  a process memory.
All the server processes have their own memories, as well.
for ex: OS uses memory to handle all the LOCAL=NO processes that are coming from the application to the database.

So it depends on your workload, data type, application design and type.
Start with a value , monitor it then increase or decrease it.
OS tools, EM and AWR are your tools for monitoring and checking..

As for apps tier, we have heaps.
FMW java heaps.
So, you configure these heaps and managed servers according to your use count. We also have concurrent managers and programs running on the apps nodes..
Again, it depends on the usage and env characteristics.

[Sri]

Thank you very much for prompt updates erman.I understand and can you please give any reference note id or doc or any post which you have written for reference

[ErmanArslansOracleBlog]

You can read my book:

Practial Oracle E-Business Suite

Chapter 13: Oracle E-Business Suite 12.2 Performance Recommendations

http://www.apress.com/br/book/9781484214237

https://www.amazon.com/Practical-Oracle-Business-Suite-Implementation/dp/1484214234

[Sri]

Thanks erman