Skip to main content


Showing posts from July, 2009


How to Setup Auditing
Do the following to set up auditing on your database:

1. Modify the "init.ora" file, usually located in the "$ORACLE_HOME/dbs"
directory to enable the AUDIT_TRAIL parameter and stop/start the instance to
make the parameter effective.

AUDIT_TRAIL can be set to one of the following four values:

--> DB/TRUE enables systemwide auditing where audited records are written to
the database audit trail, the SYS.AUD$ table
--> OS enables systemwide auditing where audited records are written to the
operating system's audit trail

--> DB_EXTENDED enables systemwide auditing as DB/TRUE does; in addition, it
populates the SQLBIND and SQLTEXT CLOB columns of the SYS.AUD$ table

DB_EXTENDED can be used starting with 10g only. More informations can be found in
Note 249438.1 - 10G New Value DB_EXTENDED for the AUDIT_TRAIL Parameter

--> NONE/FALSE disables auditing. This is the default value.


2. If yo…

DB Health Check

Table of Contents

1. Introduction
2. Parameter file
3. Controlfiles
4. Redolog files
5. Archiving
6. Datafiles
6.1 Autoextend
6.2 Location
7. Tablespaces
7.1 SYSTEM Tablespace
7.2 SYSAUX Tablespace
7.3 Locally vs Dictionary Managed Tablespaces
7.4 Temporary Tablespace
7.5 Tablespace Fragmentation
8. Objects
8.1 Number of Extents
8.2 Next extent
8.3 Indexes
9. AUTO vs MANUAL undo
9.1 AUTO Undo
9.2 Manual undo
10. Memory Management
10.1 Pre-Oracle 9i
10.2 Oracle 9i
10.3 Oracle 10g
10.4 Oracle 11g
11. Logging & Tracing
11.1 Alert File
11.2 Max_dump_file_size
11.3 User and core dump size parameters
11.4 Audit files
11.5 Sqlnet

1. Introduction
This article explains how to perform a health check on the database. General
guidelines are given on what areas to investigate to get a better overview on
how the database is working and evolving. These guidelines will reveal common
issues regarding configuration as well as problems that may occur in the future.

The areas investigated here are mostly b…