Oracle Database Administration for Microsoft SQL Server DBAs (Oracle Press) [Paperback]

Michelle Malcher (Author)

Book Description

Publication Date: September 1, 2010 | Series: Oracle Press

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

Editorial Reviews

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).

Product Details

• Paperback: 352 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (September 1, 2010)
• Language: English
• ISBN-10: 0071744312
• ISBN-13: 978-0071744317
• Product Dimensions: 9 x 7.3 x 0.7 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #1,109,695 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 6 people found the following review helpful:

5.0 out of 5 stars Practical and Useful, October 22, 2010

By 

Alex Kuznetsov - See all my reviews

This review is from: Oracle Database Administration for Microsoft SQL Server DBAs (Oracle Press) (Paperback)

Working in mixed database environments is a very interesting challenge, both for DBAs and developers. If we already have experience with SQL Server, and need to work with Oracle, our SQL Server experience may be an advantage - we already have a good handle on what an RDBMS should do (backups, restores, etc.). On the other hand, our experience and common patterns with SQL Server may cause us to make mistakes on Oracle, because its internals and best practices are not the same.

I have read a book named "Oracle Database Administration for Microsoft SQL Server DBAs", and I really liked it. The book's goal is to introduce Oracle to SQL Server data professionals, to explain similarities and differences between these two very common RDBMS. This book is filled with practical, real life information, necessary to perform daily activities of a production DBA. The book can really prevent us from missteps when we try to use Oracle as if it were SQL Server. It has the following chapters:

* Oracle Internals - I was especially fascinated by the description of transaction process flow, which is different in Oracle
* Oracle Installation, which also describes a few useful Linux commands, and connectivity
* Database Definitions and Setup (databases and schemas have different meanings)
* DBA Tools
* Database Backup, Restore, and Recovery
* Database Maintenance
* Performance and Tuning
* PL/SQL (which is VERY different from T-SQL)
* High Availability Architecture

Overall, this is a must-read book for any SQL Server professional intending to improve their Oracle skills.

1.0 out of 5 stars Very far from SQL Server and Oracle concepts, October 23, 2011

By 

A. Taveras "A Taveras" (Columbia,MD USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database Administration for Microsoft SQL Server DBAs (Oracle Press) (Paperback)

This book merely regurgitates the freely available documentation from Oracle and MS SQL Server. However, this book is even worse since its space limitations means that the author is forced to be even more cryptic than the already difficult to understand product documentation. I could not find anything useful in this book - the book doesn't explain anything. Nothing at all. Aren't books like these supposed to simplify concepts for nonexperts or beginners? You think you will find a chart explaining orcl and sql svr concepts? No. Forget about this book.