Q. What happens if you don't give cache size while defining Concurrent Manager ?
Lets first understand what is cache size in Concurrent Manager. When Manager picks
request from FND CONCURRENT REQUESTS Queues, it will pick up number of requests defined
by cache size in one shot & will work on them before going to sleep. So in my views if
you don't define cache size while defining CM then it will take default value 1, i.e.
picking up one request per cycle.
Thanks to vish for pointing out that answer to above Q's copied
from pervious Q's. If you find any disperancy do mail me.
Q. How many ORACLE HOME are Oracle Apps and whats significance of each ?
There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and
One in Database Tier.
ORACLE_HOME 1 : On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports
& discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.
ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is used by
Web Listener & contains Apache.
ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.
Q. Where is HTML Cache stored in Oracle Apps Server ?
Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions
you might find it in $OA_HTML/_pages
Q. Where is plssql cache stored in Oracle Apps ?
Usually two type of cache session & plssql stored under
$IAS_ORACLE_HOME/Apache/modplsql/cache