Rampant Oracle In-Focus Series
Only $19.95
Written by one the world's top 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
SAN: 2 5 5 - 1 3 1 4
