All posts by Rajat

Real Application Testing Oracle

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 More

Oracle 11i Diagnostic Tools Installation

Introduction 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 More

Database Upgradation from 10.2.0.3 to 11.1.0.7 in Oracle E-Business Suite 11.5.10.2

Introduction 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 More

Isetup to Transfer Setup from One instance to another

Introduction 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 More

Latest Patchset TXK.S Bug Removes Izu_top and Custom Top From Context File

 We 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 More

Verify CBO stats and Database initalization parameters for 11i

In 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 More

Explain Plan In Oracle

One 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 More

Client System Analyzer for Oracle E-Business Suit

In 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 More

Oracle E-business Suit Network Utilities

Performance 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 More

AWR (Advance workload Repository)Report in Oracle 10G

AWR 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
1 2 3