Oracle9i DBA 101 [Paperback]

Marlene Theriault (Author), Rachel Carmichael (Author), James Viscusi (Author)

Book Description

Publication Date: June 25, 2002 | ISBN-10: 0072224746 | ISBN-13: 978-0072224740 | Edition: 1

Your Oracle career starts here! Ideal for those new to Oracle technology, this introductory guide explains in easy-to-follow detail the day-to-day duties of a database administrator (DBA), as well as essential database installation, monitoring, and managing techniques. The book covers all the new features of Oracle9i. From the exclusive publisher of Oracle Press books.

Editorial Reviews

From the Back Cover

Become a Proficient Oracle Database Administrator

Oracle9i DBA 101 explains, step-by-step, how to effectively administer an Oracle database. You'll get coverage of the key Oracle9i new features as well as details on the daily responsibilities of a DBA and tips on how to successfully accomplish those tasks. From the exclusive publishers of Oracle Press books, this is the ideal resource for the aspiring Oracle database administrator.

• Install and configure a high-performance Oracle database
• Look at a database using DBA_ views and V$ views
• Implement security measures to protect data
• Monitor and tune the database
• Run and support Oracle tools and software
• Maintain a high-availability database
• Keep the server running at peak performance
• Perform backup and recovery procedures

About the Author

Marlene Theriault has been an Oracle DBA for over 17 ears and has worked with Oracle products since version 2.0 of the Oracle RDBMS. She has been published in magazines and conference proceedings throughout the world. Ms. Theriault received the "Best User Presentation" award at EOUG 1999, "Outstanding Speaker" at EDO'98, and the "Distinguished Speaker" award for presentations at both ECO'95 and ECO'96. She coauthored Oracle Security with William Heney (O'Reilly and Associates, 1998); The Oracle8i DBA Handbook with Kevin Loney (Oracle Press, 2000); and Oracle DBA 101 with Rachel Carmichael and James Viscusi (Oracle Press, 2000). She is chair of the MAOP DBA SIG and authors an "Ask The DBA" column for the MAOP newsletter. Ms. Theriault is an avid recreational walker (Volksmarching) and has done at least one 6-mile walk in each of the 50 United States. Marlene can be reached at [e-mail].

Rachel Carmichael has been an Oracle DBA for over nine ears. She chairs the DBA Special Interest Group for the New ork Oracle Users Group, is both Chauncey and OCP certified, and has presented at various international and national conferences, including the ECO all-day DBA seminar for the past three years. She coauthored the Oracle Press book, Oracle SQL and PL/SQL Annotated Archives, 1998, with Kevin Loney, and this Oracle Press book, Oracle DBA 101, 2000, with Marlene Theriault and James Viscusi.

James Viscusi has been working with relational database products for over 10 years and specifically with Oracle the last six years. He currently works with Oracle Corporation in the Support Division Center of Expertise, in particular working with customers experiencing performance problems. He has presented at several conferences worldwide including Oracle Open World, IOUG-A, and UKOUG. Mr. Viscusi is also a husband and father of two children and volunteers as an Emergency Medical Technician when he can find the time.

Product Details

• Paperback: 550 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (June 25, 2002)
• Language: English
• ISBN-10: 0072224746
• ISBN-13: 978-0072224740
• Product Dimensions: 9 x 7.4 x 1.2 inches
• Shipping Weight: 2.1 pounds
• Average Customer Review: 3.3 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #1,742,031 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

6 of 6 people found the following review helpful:

5.0 out of 5 stars Don't miss out because title is misunderstood...., September 11, 2006

By 

PPW "PPW" (Atlanta, Ga, United States) - See all my reviews

This review is from: Oracle9i DBA 101 (Paperback)

Upon reading the reviews of this book, I can understand how some have mistaken what the book was truly meant for based on its title. The book should be titled more along the lines of "Your First Job Working As a DBA: 101" or "Your Job as an Oracle DBA from Jr. to Sr. Is This the Job for You ?", you get the point.

In the section of the book titled "Getting Started", the authors explain how this book developed from a workshop called "DBA 101: A Refresher Course", and they had been DBA's since 1991. It was designed to help others who were DBA's. The 9i certification course consists of four exams and uses four books. Those books teach Oracle and prepare you for the certifications. They cover being an Oracle Certified Database Administrator (Jr. DBA) to an Oracle Certified Professional (Sr. DBA). You may be studying for the individual exams after you completed the course and have no experience or you may be attempting to apply for a job as a Jr. DBA, which are few and far between, you need to understand what is going to be expected of you. If you have a job as a Jr. DBA, you may need a refresher on what you need to work on in order to become a Sr. DBA. Whether your skill set is entry level or intermediate, this book does an excellent job of taking the important information from ALL FOUR books and consolidating it into one book that describes the job duties of a Jr. or Sr.DBA.

This is NOT a study guide for the exams nor is it for anyone trying to learn Oracle. It answers the question of what a DBA really does and all of the duties you should be aware of that you need to gear up for if you are new and looking for a DBA position. Only real life experience can truly prepare you for what really goes on day to day in the life of a DBA. That's where this book comes in handy. This book is EXTREMELY useful only AFTER you have taken the Oracle course or have some experience. Use it to get a jumpstart as to what will be expected of you to know when you get that first job so you can get a head start and hopefully advance more quickly. It answers the questions that an aspiring DBA has and it provides you with a refresher course if you are a DBA so you can improve upon your skills.

Take note that Oracle does make changes to its software so you want to do research on different procedures as this book was written in 2002. However, as for the topics it covers it is GREAT ! !

2 of 2 people found the following review helpful:

2.0 out of 5 stars Heavily padded, but some good basics, May 25, 2004

By A Customer

Amazon Verified Purchase

This review is from: Oracle9i DBA 101 (Paperback)

Rather tedious reading because of so much obvious padding to get the page count up to 500... I would estimate that there are 200 pages of real content here. There is a long explanation of what actions the trigger on a gun initiate, in order to be sure we understand what an Oracle "Trigger" is through a long analogy. This is a typical example of where a text is padded out to a paragraph to explain a concept that could have been done in a sentence. Authors should respect the reader's time and attention. Some of the coverage is very thin and the seams show on the revision for the 9i. We I reviewed the book and noted the highlighted passages, I realized how thin in content this actually was.

Still a good first read for a new DBA, but the Wessler or Dawes or even Ault are better, more detailed and ultimately more useful.

4 of 5 people found the following review helpful:

1.0 out of 5 stars Not for beginners, September 15, 2003

By A Customer

This review is from: Oracle9i DBA 101 (Paperback)

As a programmer with experience in MS SQL Serer, this book appealed as a first introduction to Oracle. Unfortunately, too much space has been dedicated to complicated and unnecessary detail. For example, early chapters go to great detail of setting up the SQL Plus utility, interesting, but frequently I found myself skipping page after page that I didn't need as a beginner and there's no way I would remember. As a beginners' book, it's disappointing to find installation of the database pushed all the way back to chapter 7, and with that the chapter starts by saying that a full coverage of installations is beyond the scope of this book! If installing the database is not important for beginners, what is? Final word, this book isn't for beginners.