Oracle Database Administration for Microsoft SQL Server DBAs

Michelle Malcher

_______________________________________________________________________________

Introduction

Shows experienced SQL Server DBAs how to work seamlessly with the Oracle Database in a mixed-database environment
Author is an Oracle ACE and on the Board of the Independent Oracle User Group (IOUG)
Oracle DBAs are typically paid more--a strong incentive for SQL Server DBAs to learn Oracle skills

About the book

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

About the author

Michelle Malcher, Oracle ACE, is a senior database administrator with more than 11 years' experience in database development, design, and administration. She is a contributing author to Oracle Database 11g: A Beginner's Guide and to the IOUG Best Practices Tip Booklet. Michelle is on the Board of the Independent Oracle User Group (IOUG).

Table of contents

Chapter 1: The Database Administrator; Chapter 2: Oracle Internals; Chapter 3: Oracle Installation; Chapter 4: Database Definitions and Setup; Chapter 5: DBA Tools; Chapter 6: Database Backup, Restore, and Recovery; Chapter 7: Database Maintenance; Chapter 8: Performance and Tuning; Chapter 9: PL/SQL; Chapter 10: High-Availability Architecture; Appendix; Index