Sign in  |  Register
Advanced search
Publication Cover

CITATION

Malcher, Michelle. Oracle Database Administration for Microsoft SQL Server DBAs. US: McGraw-Hill Osborne Media, 2010.

Oracle Database Administration for Microsoft SQL Server DBAs

Authors: Michelle Malcher

Published:  September 2010

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