Miscellaneous Articles

DBA

AutoNumber And Identity Functionality - Implement AutoNumber or Identity column behaviour in Oracle.

Basic Enterprise Manager Troubleshooting - The first things to check out when the web-based Enterprise Manager console stops working.

Basic Security Measures for Oracle - This article presents some basic steps to increase the security of your Oracle database servers.

Cost Based Optimizer (CBO) And Database Statistics - Lists the available mechanisms for gathering database statistics that are used by the cost based optimizer.

Deadlocks - This article shows the steps necessary to identify the offending application code when a deadlock is detected.

Detect And Correct Corruption - Learn the different methods of detecting and correcting table block corruption.

Direct and Asynchronous I/O - Take advantage of the performance advantages associated with Direct and Asynchronous I/O.

Dbvisit Replicate Installation on Oracle Linux 5 and 6 - This article describes the installation and configuration of Dbvisit Replicate with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Reporting Installation on Oracle Linux 5 and 6 - This article describes the installation and configuration of Dbvisit Reporting with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Standby Installation on Oracle Linux 5 and 6 - This article briefly describes the installation and usage of Dbvisit Standby with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Granular Control of Optimizer Features (OPTIMIZER_FEATURES_ENABLE, _FIX_CONTROL, V$SYSTEM_FIX_CONTROL and V$SESSION_FIX_CONTROL) - Enable and disable specific optimizer features and bug fixes in Oracle 10.2.0.2 and above.

Heterogeneous Services - Generic Connectivity - Query non-Oracle datasources using ODBC.

Identifying Host Names and IP Addresses - This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.

Incrementally Updated Backups : Rolling Forward Image Copies Using RMAN - Speed up backup and recovery time by rolling your image copy backups forward using incremental backups.

Killing Oracle Sessions - Kill Oracle sessions from SQL, NT and UNIX.

Manually Cloning an Existing Oracle Database Installation on Linux - This article describes the steps necessary to manually clone an existing Oracle database installation to a new Linux server.

Learning to be an Oracle Database Administrator (DBA) - My thoughts on the most efficient way to learn to be an Oracle Database Administrator (DBA).

Manual Oracle Uninstall - Having trouble removing all Oracle software using the OUI Try these methods.

Materialized Views in Oracle - Use materialized views (snapshots) to replicate data to a remote database.

Measuring Storage Performance For Oracle Systems - This article outlines two easy ways to test the performance of your storage systems using utilities provided by Oracle.

Oracle Certification : Frequently Asked Questions (OCA, OCP, OCE, OCM) - My personal opinions when answering questions about Oracle Certification.

Naming Conventions - Some of the typical naming conventions used for objects in Designer and the database.