Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

  Oracle DBA Made Simple
Oracle database administration techniques


Mike Ault
ISBN: 0-9740716-5-X
201 Pages

 

- Order now from the publisher and get 40% off!

Only $19.95

 

 


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.

 
Key Features

* Learn System Planning.

* Employ Backup & recovery.

* Understand Oracle RDBMS Architecture.

* See Layout & Fragmentation.

 

About the Author:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

 

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

 

 

 

 

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks