Wissem El Khlifi

Author

I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the database. SQL plan management helps preserving efficient execution plans and evaluates every changed plan. Plan changes can be due to the system change (Database upgrade, changes in database parameters, changes in optimizer parameters, changes in optimizer statistics, system configuration, etc… Continue Reading →

11g, Database Administration, Oracle Database

Read Data Guard Physical Standby Database Best Practices – Part I In this second part we will setup the standby database and enable Fast Start Fail Over. Standby Database Creation Start the standby database instance in NOMOUNT start up mode: SQL> startup nomount pfile=initdg2.ora; Now that the configuration of the standby server is complete, let’s perform the duplication from the… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration, Oracle Database

Introduction Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases. Oracle Data Guard maintains one or many secondary databases as alternatives to the primary production database. Data Guard Architecture Oracle Data Guard supports both physical standby and logical standby sites. Physical Standby: When the primary database transactions generate redo… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration, Oracle Database

Introduction: Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources. Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts. These components can be easily added to the Oracle Restart using the crsctl add command. In this… Continue Reading →

11g, Database Administration, Oracle Cloud, Oracle Database