Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook.  With decades of experience using Oracle, Mike Ault shares secrets for Oracle database management and DBA techniques.

About the Author:

Table of Contents:

 

System Planning  Resource and Capacity Planning  Resource Specification for Oracle  Optimal Flexible Architecture (OFA)  Minimum OFA Configuration  Oracle Structures and How They Affect Installation  Executables  Data Files  Redo Logs  Control Files  Exports  Archive Logs  LOB Storage  BFILE Storage  Disk Striping, Shadowing, RAID, and Other Topics  Disk Striping  Disk Shadowing or Mirroring  RAID—Redundant Arrays of Inexpensive Disks  New Technologies  Optical Disk Systems  Tape Systems  RAM Drives (Random Access Memory)  Backup & recovery  Backups  Cold Backups  Hot Backups  Example Documentation Procedure for NT Online Backup and Recovery Scripts  Imports/Exports  Limitations on export/import:  Exports  IMPORT  Archive Logs  Backup Methodologies  NT or UNIX System Backup  Import/Export  Archive Logging  Recovery Types  Oracle Enterprise Backup Utility  Oracle RECOVERY MANAGER FACILITY  DB_VERIFY UTILITY  The following example shows how to get on-line help:  The DBMS_REPAIR Utility  DBMS_REPAIR Enumeration Types  DBMS_REPAIR Exceptions  DBMS_REPAIR Procedures  CHECK_OBJECT  DUMP_ORPHAN_KEYS  FIX_CORRUPT_BLOCKS  REBUILD_FREELISTS  SKIP_CORRUPT_BLOCKS  Oracle RDBMS Architecture  Background Processes  Datafiles  Rollback Segments  Redo log files  Control files  Initialization File  The Undocumented Initialization Parameters (“_”)  The Initialization File Event Settings  System Global Area  SGA  Modifying the INIT.ORA  Allocating And Caching Memory  Use of the Default Pool  Use of The KEEP Pool  Use of the RECYCLE Pool  Tuning the Three Pools  Shared Pool  Putting it All In Perspective  What to Pin  The Shared Pool and MTS  Large Pool Sizing  A Matter Of Hashing  Disk IO and the Shared Pool  Monitoring Library and Data Dictionary Caches

Managing the Database   Find USER locking others/Kill problem USER  Methods of Murder  Killing From the Oracle Side  Killing From the Operating System Side  Creating and starting the database  Database Creation  Re-creation of a Database  Database Startup and Shutdown  Startup  Shutdown  Tuning Responsibilities  Step : Tune the Business Rules  Step : Tune the Data Design  Step : Tune the Application Design  Step : Tune the Logical Structure of the Database  Step : Tune Database Operations  Step : Tune the Access Paths  Step : Tune Memory Allocation  Step : Tune Resource Contention  Step : Tune the Underlying Platform(s)    Layout & Fragmentation   Tablespace Segments & Free Space  Tables & Indexes/Partitioning  The V$ views  How are they used?  The Optimizers & the Analyze Command  The Parallel Query Option  Parallel query settings  Problems In Parallel Query Usage  Security  Users  Altering Users  Dropping Users  Grants  System Privileges  Object Privileges  Column Privileges  View Grants  Other Grants  Revoking Grants  Use Of Roles  Creating Roles  Setting Roles  Special Roles  OSOPER And OSDBA  CONNECT, RESOURCE, And DBA Roles  Export/Import Roles  Using PROFILES  Profiles and Resource Limits  Altering Profiles  Profiles and Passwords  Managing CPU Utilization for in Oracle  Creating a Resource Plan  Restricting Access by Rows in Oracle  Policy Usage  DBMS_RLS Package