Archive Daily Archives: November 21, 2008
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 MoreExplain 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 MoreOracle 9i Multi Master Advance Replication setup, testing and troubleshooting
Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication testing two machines are being used. There will be two databases on the two different machines i.e. a) Master1 (Master definition Site) This site will be used for the administration of the Replication setup. b) […]
Read More