MADHAN APPS DBA

Best Practices for Performance for Concurrent Managers in E-Business Suite ============================================================== This Document contains 5 topics 1. Generic Tips 2. Transaction Manager (TM). 3. Parallel Concurrent Processing (PCP) Environment. 4. Tuning Output Post Processor (OPP). 5. Concurrent Processing Server Tuning. Generic Tips 1) Sleep Seconds - is the number of seconds your Concurrent manager waits between checking the list of pending concurrent requests (concurrent requests waiting to be started). A manager only sleeps if there are no runnable jobs in the queue. Tip: During peak time, when the number of requests submitted is expected to be high, Set the sleep time to a reasonable wait time(e.g. 30 seconds) dependent on the average run time and to prevent backlog. Otherwise set the sleep time to a high number (e.g. 2 minutes). This avoids constant polls to check for new requests. 2) Increase the cache size (number of requests cached)

What is the main difference between Lock , Block and Deadlock in oracle database: Answer : The Meaning of lock is : ======================== Lock is a done by database when any connection access a same piece of data concurrently. One connection need to access Piece of data . The Meaning of Block : ====================== It occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access. SQL knows that once the blocking process finishes the resource will be available and so the blocked process will wait (until it times out), but it won’t be killed. The Meaning of Deadlock : ========================= Deadlock occurs when one connection is blocked and waiting for a second to complete its work, and this situation is again with another process as it waiting for first connection to release the lock. Hence deadlock occurs. Example : i have 2 processes. P1 &

Useful Metalink Doc id for Oracle Apps and Core DBA : ============================================= R11i / R12: Component Version In Oracle Applications (Doc ID 1327288.1) How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen (Doc ID 119319.1) How To Set Concurrent Program To Run Exclusively From A Custom Manager (Doc ID 2268941.1) How to Create a Custom Concurrent Manager (Doc ID 170524.1) Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1) How to Recover from a Lost or Deleted Datafile with Different Scenarios (Doc ID 198640.1) How To Change Log Archive Destination While the Database Is Open When the Archive Destination Is Full (Doc ID 160446.1) 12.2 E-Business Suite Applications DBA Steps To Create, Update or Rebuild The Central Inventory For Oracle Applications (Doc ID 1588609.1) E-Business Suite - ADOP Basic Usage Training Videos [Video] (Doc ID 2103131.1) How to Change IP Address in an Oracle Applicatio

Gather Schema Statistics R12.1/R12.2: ==================================================== What is Gather Schema Statistics? Gather Schema Statistics program generates statistics that quantify the data distribution and storage characteristics of tables, columns, indexes, and partitions. The cost-based optimization (CBO) uses these statistics to calculate the selectivity of prediction and to estimate the cost of each execution plan. Why Run the Gather Schema Statistics? When Data is update, insert, delete in table of user end Like (Technical User ,Finance User ,Ect) It become necessary to run the Gather Schema Statistics It’s recommended to Run GSS in Weekly Once or twice. How to run Gather Schema Statistics? Login application with sysadmin user Submit Request Window Navigate to: Concurrent > Requests Enter the parameters This can be run for specific schemas by specifying the schema name or enter ‘ALL’ to gather statistics for every schema in the database Submit the Gather

Oracle E-Business Suite Release 12.2.8 Readme (Doc ID 2393248.1): ======================================================== Section 1: Preparation Section 2: Obsolete Products in Release 12.2.8 Section 3: Upgrade Database to 11.2.0.4 or higher Section 4: Apply Required Database Patches and Update Database Initialization Parameters 4.1 Apply Required Database Patches 4.2 Set Database Parameter (Conditional) Section 5: Apply Consolidated Seed Table Upgrade Patch (Required) Section 6: Apply the Latest AD and TXK Delta Release Update Packs Section 7: Perform Pre-Update Steps (Conditional) Section 8: Apply Oracle E-Business Suite 12.2.8 Release Update Pack 8.1 Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.8 Release Update Pack 8.2 Path B — Existing Customers (Release 12.2.2, 12.2.3, 12.2.4, 12.2.5, 12.2.6 or 12.2.7) upgrading to Oracle E-Business Suite 12.2.8 Release Update Pack Section 9: Post-Update Steps Section 10: Apply Additional Critical

Oracle Database Exam Codes : -------------------------------------------------------------------------- Oracle Database 11gR2 : Oracle Database 11g: Administration II | 1Z0-053 Upgrade Oracle9i/10g to Oracle Database 11g OCP | 1Z0-034 Oracle Database 11g: New Features for Administrators | 1Z0-050 Oracle Database 11g: Administration I | 1Z0-052 Oracle Database 11g: Performance Tuning | 1Z0-054 Oracle Database 11g: Program with PL/SQL | 1Z0-144 Oracle Database 12cR1 : ================== Upgrade to Oracle Database 12c | 1Z0-060 Oracle Database 12c: SQL Fundamentals (retiring November 30, 2019) | 1Z0-061 Oracle Database 12c Administration | 1Z0-062 Oracle Database 12c: Advanced Administration | 1Z0-063 Oracle Database 12c: Performance Management and Tuning | 1Z0-064 Oracle Database 12c: Data Guard Administration | 1Z0-066 Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP | 1Z0-067 Oracle Database 12c: RAC and Grid Infrastructure Administration | 1Z0-068 Oracle Database 12c