1. Introduction Real application testing is a powerful features of Oracle which has been introduced in 11g first and then it was back ported to other version including oracle 9i . In our Eaga specific scenario we have oracle 9.2.0.7 EBS database and we have 11g database with OEM grid cntrol . The real advantage […]
Read MoreIntroduction This document is helping us to install Oracle Diag patch using “adpatch” utility . Oracle Diagnostic patch is one of pwerfull features of Oracle E-business Suit . Pre-Requisites • Oracle E-Business Suite Diagnostics can only be installed on a minimum of E-Business Suite 11.5.4 or above with FND.D and AD.G installed. • The latest Oracle E-Business […]
Read MoreIntroduction The database upgradation process for 11G is same as other version of oracle , Either using DBUA or manually. I followed the manual process to accomplish the task. . Prerequisites i). Apply ATG rollup patch 6 5903765 In my case instances was not updated to ATG roll up patch 6 , so I have […]
Read MoreIntroduction This document provides a complete, up-to-date description of Oracle iSetup Minipack 11i.AZ.H (5140723). The main focus of iSetup is to help migrate functional setups from one E-Business Suite instance to another. During migration, setups can be extracted selectively using filters on setup attributes. Extracted setup data can be optionally transformed before loading into target […]
Read MoreWe all know that the proper way to add a custom top directory to your E-Business Suite instance is through the ${APPL_TOP}/admin/topfile.txt (Note 216589.1). By adding an entry to that file, AutoConfig will:1) Create the environment variable for you 2) Put it into the context file 3) Update various commonly missed files (formservlet.ini, for example). […]
Read MoreIn order to get better performace of the database , we usually schedule Apps Gather schema . Oracle provide very important tool/script to verify the CBO stats . bde_last_analyzed.sql :-verifies the CBO statistics in the data dictionary for all tables, indexes, and partitions. It also validates the statistics on tables and indexes owned by ‘SYS’. This […]
Read MoreOne of the most usefull tool which require for both DBAs and Developers to use it effectively to avoid the performance problem of Custom Code specailly in ERP database as well as any database. We should make best use of it. An execution plan is a list of steps that Oracle will follow in order to execute a SQL […]
Read MoreIn my last post i did not cover about this tool(CSA) , i found this tool is very interseting and trying to share some of the points. Performance issues and other problems can arise if your computer is not optimally configured. To enable the diagnosis (and prevention) of such problems, the Client System Analyzer allows […]
Read MorePerformance issue is one of the most frustrating things in any application . Being a DBA if anything regarding to perfomrace, it comes to us . It is one of the critical task for DBA to make sure that Application is performing as per end users expectation. It is really very complicated to reslove those […]
Read MoreAWR is an enhancement/upgradation of statspack, which help us to tune the database. Oracle Database 10g uses a scheduled job, GATHER_STATS_JOB, to collect AWR statistics. This job is created, and enabled automatically when you create a new Oracle database under Oracle Database 10g. GATHER_STATS_JOB, to collect AWR statistics every 1 hour . We can disable […]
Read More