Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs

by Michelle Malcher
Released October 2010
Publisher(s): McGraw Hill Computing
ISBN: 9780071744300

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Apply Your SQL Server DBA Skills to Oracle Database Administration

Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide.

  • Install and configure Oracle Database on Windows or Linux systems
  • Administer and monitor databases from Oracle Enterprise Manager
  • Implement robust security using roles, permissions, and privileges
  • Back up and restore databases with Oracle Recovery Manager
  • Use the Oracle cost-based optimizer to tune performance
  • Write, debug, and execute PL/SQL queries using Oracle SQL Developer
  • Maximize availability with Oracle Real Application Clusters
  • Build standby and failover servers using Oracle Data Guard

Table of contents

  1. Cover Page
  2. Oracle Database Administration for Microsoft® SQL Server® DBAs
  3. Copyright Page
  4. Dedication
  5. Contents
  6. Acknowledgments
  7. Introduction
  8. 1 The Database Administrator
    1. General DBA Skills
    2. Where Do DBAs Belong in an Organization?
    3. Database Installation Planning
    4. Leveraging Skills
    5. Database Migrations
    6. Summary
  9. 2 Oracle Internals
    1. Memory Structures
      1. Oracle Memory Parameters
      2. Sizing the SGA and PGA
    2. Where Are the master, msdb, and tempdb Databases?
      1. System-level Information
      2. Data Dictionary Views
      3. Jobs and Schedules
      4. Templates and Temporary Tables
    3. Services and Processes
    4. sp_configure Options and Parameters
      1. Viewing and Setting Parameters
      2. Getting Started with Some Parameters
    5. Undo, Redo, and Logs
      1. Transaction Logs Versus Redo Logs
      2. Undo and Beyond
    6. Summary
  10. 3 Oracle Installation
    1. Operating Systems
      1. Windows Setup
      2. Useful Linux/Unix Commands
      3. Linux Setup
    2. Storage Requirements
      1. Disk Storage
      2. Storage Management with ASM
      3. Oracle Files
      4. Oracle Database Components
    3. Oracle Software Installation
      1. Using a Response File
      2. Removing Software
      3. Upgrading the Database
      4. Applying Patches
    4. Summary
  11. 4 Database Definitions and Setup
    1. Servers, Databases, Instances, and Schemas
    2. SQL Server Setup Versus Oracle Setup
    3. Creating Databases
      1. Using the DBCA
      2. Duplicating Databases with Templates and Scripts
      3. Creating the Listener
      4. Choosing a Character Set
    4. Security
      1. Permissions for the Server
      2. Permissions for Schemas
      3. DBA Roles and Responsibilities Revisited
    5. Summary
  12. 5 DBA Tools
    1. Overview of Tools for Typical Database Tasks
    2. Oracle Enterprise Manager
      1. OEM Navigation
      2. Storage Management
      3. Database Configuration
      4. Oracle Scheduler
      5. Statistics and Resource Management
      6. Security
      7. Enterprise Manager Configuration
    3. SQL*Plus
    4. SQL Developer
    5. Client Connections
      1. Client Connection Configuration
      2. JDBC Connections
      3. Aliases
    6. My Oracle Support
    7. Summary
  13. 6 Database Backup, Restore, and Recovery
    1. Backing Up Databases
      1. Backup Strategies
      2. Backup and Restore Commands
      3. RMAN Configuration for Backups
      4. Backup Options
      5. Backup Examples
      6. OEM Backup Jobs
    2. Restoring and Recovering Databases
      1. What Can Go Wrong?
      2. Restore and Recover Options
      3. Data Recovery Advisor
      4. Copying the Database
    3. Managing Backups
      1. Viewing Backups
      2. Purging Obsolete Files
    4. Backing Up and Restoring Objects
      1. Copying Objects at the Table and Schema Level
      2. Using Data Pump
    5. Protecting Users from Users
      1. Recycle Bin
      2. Flashback
    6. Summary
  14. 7 Database Maintenance
    1. Maintenance Tasks
    2. Consistency Checks
    3. Health Checks
    4. Update Statistics
      1. System Statistics
      2. Object Statistics
    5. Object Maintenance
      1. Index Rebuild
      2. Table Reorganization
      3. Invalid Objects
      4. Grants
      5. Synonyms
    6. Job Scheduling
      1. Creating a Job in Oracle Scheduler
      2. Using DBMS_SCHEDULER
      3. Setting Up System and User Jobs
    7. File Maintenance
      1. Shrinking and Resizing Files
      2. Tablespace Monitoring
      3. Error Logs, Alert Logs, and Trace Files
    8. Summary
  15. 8 Performance and Tuning
    1. Better-Performing Systems
    2. Indexes
      1. Index Monitoring
      2. Index Types
    3. Locking
    4. Current Activity Views
      1. Current Sessions
      2. Activity Monitors
      3. Waits
    5. SQL Plans
      1. Viewing Explain Plans
      2. Tuning Using Explain Plans
    6. Automatic Workload Repository
      1. AWR Reports
      2. Active Session History View
      3. Library Cache for SQL Statements
    7. Summary
  16. 9 PL/SQL
    1. Database Coding Practices
    2. Packages and Package Bodies
    3. Triggers
    4. Updates and Conditions
    5. Transactions
      1. Beginning a Transaction
      2. Defining Commits
      3. Cursor Processing
      4. Processing with FORALL
    6. Functions
    7. Debugging Procedures and Unit Testing
    8. Error Handling
      1. Error Handling Packages
      2. Standard Error Messages
    9. Using DBMS Packages
    10. Summary
  17. 10 High-Availability Architecture
    1. Options for High Availability
    2. Clustering with RAC
      1. Configuring RAC
      2. Testing RAC
      3. Setting Up Client Failover
      4. Setting Up RAC Listeners
      5. Patching RAC
      6. Deploying RAC
      7. Configuring and Monitoring RAC Instances
    3. Primary and Standby Databases
      1. Using Active Standby Databases
      2. Setting Up a Standby Database
    4. ASM in an RAC Environment
      1. Managing ASM Disk Groups
      2. Viewing ASM Information
    5. Streams and Advanced Replication
      1. Oracle Streams
      2. Advanced Replication
    6. Summary
  18. Appendix
  19. Index

Product information

  • Title: Oracle Database Administration for Microsoft SQL Server DBAs
  • Author(s): Michelle Malcher
  • Release date: October 2010
  • Publisher(s): McGraw Hill Computing
  • ISBN: 9780071744300