State of processes and sessions parameters after clone.

After doing post clone of Oracle EBS 11i/R12, the processes and sessions parameters are re-set to default. That is processes=200 and sessions=300.

In particular to R12.1 instance, 200 number of processes are not enough for a single user to submit a few requests.  The requests will throw errors which are not related to "max processes reached". You may find it on alert_log, but if you are monitoring concurrent managers and it's logs then, I bet you won't find anything related to max processes.

It must be a practice to increase the processes and sessions parameters on a newly cloned EBS or set as equal as to that of the source EBS.

Otherwise, concurrent managers will keep you on running on toe and you won't get any clue until, you saw the alert log.

No comments:

Post a Comment

Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)

 SPACE MANAGEMENT :: 1. Table space usuage: ============== SELECT tablespaces.tablespace_name,          allocated.total_alloc allocated_mb, ...