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 NOTE : ----- 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. Example: -----

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 futur