Modern Oracle DBA

Concurrent Processing using the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests. Post-processing actions are actions taken on concurrent request output. Example of a post-processing action is that used in Concurrent Processing support of XML Publisher. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the OPP to apply the XML Publisher template and create the final output. Tuning for Output post processor 1.Increase the number of Output Post Processor as follows:  Logon to Applications with "System Administrator" responsibility  Navigate to Concurrent -> Manager -> Define  Query for "Output Post Processor"  Click on "Work Shifts" and Increase the number of processes. (If you have 2 processes then make them 4 if require

Concurrent manager log file location: Concurrent manager log files are located under $APPLCSF and $APPSLOG home [oracle@VIS ~]$cd $APPLCSF [oracle@VIS conc]$pwd /apps/applmgr/fs_ne/inst/VIS/logs/appl/conc [oracle@VIS conc]$cd log/ [oracle@VIS log]$pwd /apps/applmgr/fs_ne/inst/VIS/logs/appl/conc/log [oracle@VIS log]$ Internal concurrent manager log file: [oracle@VIS log]$ls -lrt *$TWO_TASK* Standard manager log file: [oracle@VIS log]$ls -lrt w*.mgr Conflict resolution manager log file: [oracle@VIS log]$ ls -lrt c*.mgr Output post processer log file: [oracle@VIS log]$ps -ef |grep OPP Concurrent program related some basic SQL queries How to find concurrent program status? SQL> select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=’1234567’; How to find concurrent request output and log file location? SQL> select LOGFILE_NAME, OUTFILE_NAME from fnd_concurrent_requests where request_id

Adadmin (Ad administration): It’s performance the maintenance tasks for Oracle E-business suite. AD Administration Main Menu 1. Generate Applications Files menu 2. Maintain Applications Files menu 3. Compile/Reload Applications Database Entities menu 4. Maintain Applications Database Entities menu 5. Change Maintenance Mode 6. Exit AD Administration 1. Generate Applications Files menu 1. Generate message files 2. Generate form files 3. Generate report files 4. Generate graphics files 5. Generate product JAR files 6. Return to Main Menu 2-Maintain Applications Files 1. Relink Applications programs 2. Create Applications environment file 3. Copy files to destinations 4. Convert character set 5. Maintain snapshot information 6. Check for missing files 7. Return to Main Menu 3-Compile/Reload Applications Database Entitie 1. Compile APPS schema 2. Compile menu information 3. Compile flexfields 4. Reload J