Forums: Oracle Database Administration

Understanding Oracle Recovery Manager (RMAN) Oracle Recovery Manager (RMAN) is basically an automated data backup procedure. In businesses of all...

Partitioning a Table in Oracle Below is the procedure of partitioning a table in oracle. 1) Identify the table creation script that you want to...

The job of the Oracle DBA is not an easy one. There are several aspects to the job and it takes skill and knowledge to now how to implement security,...

The oracle optimizer choose the best plan and execute the query according the plan. It is common to hear that my table has indexes but why oracle...

Monitoring of Flashback Database with Data Dictionary Views V$FLASHBACK_DATABASE_LOG, GV$FLASHBACK_DATABASE_LOG (for RAC) - displays information...

Recently I needed to change a standard edition database to Enterprise Edition. Here are the steps I followed from documentation Since the same...

DBMS_STATS.GATHER_SCHEMA_STATS In Oracle Database when there is something called Cost Based Optimizer (CBO) which other than doing many things...

One of most imortant structures of Oracle Architectures is the Oracle Latching mechanism. from my experiance I have seen that a major portion of...

Let's see current value of O7_DICTIONARY_ACCESSIBILITY . SQL> show parameter O7_ NAME TYPE VALUE...

We all know that in certain recovery situations we need to use backup control files.And after the recovery, Oracle requires a RESETLOGS operation...

With parameter sqlfile=file_name you can easily get DDL from dumpfile. Following is the steps. 1.Create directory where dump resides. create...

Oracle DBA Basic Terms for Beginners In order to become a fully fledged DBA, you need to have an understanding of the fundamental concepts. This...

Below is the detailed example. The rule is if in the table a column is included as a primary or unique key and the column is not included in the...

Aix Command list in alphabetical order. Command | Parameter | Description bootlist | -m normal <dev1> <dev2> | Alters the list of boot devices...

Oracle Online Redefinition mechanism provides a significant increase in availability compared to traditional methods of redefining tables that...

Introduction This document gives you a detailed flow of how to backup the database in a 24x7 operation and use it for cloning a Development or...

Many one think about index skip scan as wrong one and mistakenly think it as index is not used. But in fact skip scan is efficient enough when...

In three ways we can achieved. 1)From Oracle Universal Installer: In OUI select installed products and click on list and expand, you will see a...

Oracle Security over a Network Oracle databases and technology were originally designed to work over a network and distribution of applications...

The primary purpose of partition is to improve performance of queries. But doing partition over a table or index does not merely serve performance...