BN.com Gift Guide

Oracle DBA Interactive Workbook

Overview


  • Hands-on learning system that's fast, easy and web-charged!
  • FREE Access to Interactive Oracle DBA Training Web Site
  • Experience Oracle database administration-now!
  • No Oracle DBA experience necessary
  • Introduces core Oracle DBA topics
  • Real-life labs and "Test Your ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (14) from $1.99   
  • Used (14) from $1.99   
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 14 (2 pages)
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2009

Feedback rating:

(11083)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Acceptable
A tradition of southern quality and service. All books guaranteed at the Atlanta Book Company. Our mailers are 100% recyclable.

Ships from: Atlanta, GA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2010

Feedback rating:

(4057)

Condition: Very Good
Book shows a small amount of wear - very good condition. Selection as wide as the Mississippi.

Ships from: St Louis, MO

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(7753)

Condition: Good
Light shelving wear with minimal damage to cover and bindings. Pages show minor use. Help save a tree. Buy all your used books from Green Earth Books. Read. Recycle and Reuse.

Ships from: Portland, OR

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2014

Feedback rating:

(4184)

Condition: Very Good
This copy shows very minor wear. Free State Books. Never settle for less.

Ships from: Halethorpe, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(7741)

Condition: Like New
Straight spine with no creases. Cover has no damage and pages show little wear. With pride from Motor City. All books guaranteed. Best Service, Best Prices.

Ships from: Brownstown, MI

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2014

Feedback rating:

(2774)

Condition: Acceptable
Biggest little used bookstore in the world.

Ships from: Reno, NV

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2010

Feedback rating:

(5751)

Condition: Good
This book has a light amount of wear to the pages, cover and binding. Blue Cloud Books ??? Hot deals from the land of the sun.

Ships from: Phoenix, AZ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.55
Seller since 2014

Feedback rating:

(4)

Condition: Good
2000-12-21 Paperback Good Expedited shipping is available for this item!

Ships from: Burbank, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.99
Seller since 2006

Feedback rating:

(1187)

Condition: Good
2000-12-21 Paperback Good We ship everyday and offer PRIORITY SHIPPING.

Ships from: malone, NY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.99
Seller since 2006

Feedback rating:

(1187)

Condition: Very Good
2000-12-21 Paperback Very Good We ship everyday and offer PRIORITY SHIPPING.

Ships from: malone, NY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 2
Showing 1 – 10 of 14 (2 pages)
Close
Sort by
Sending request ...

Overview


  • Hands-on learning system that's fast, easy and web-charged!
  • FREE Access to Interactive Oracle DBA Training Web Site
  • Experience Oracle database administration-now!
  • No Oracle DBA experience necessary
  • Introduces core Oracle DBA topics
  • Real-life labs and "Test Your Thinking" Q&As

Foreword by Dr. Arthur M. Langer.

Experience Oracle database administration now! This integrated book-and-Web learning solution teaches core Oracle DBA skills you need, hands-on, through real-world labs, exercises, Q&As, and a Web-based training site. You'll experience aspects of day-to-day Oracle database administration, including managing the database and its physical layout, ensuring security and data integrity, providing for backups, and more. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, discover new interactive Q&As, and get book updates.

Every Prentice Hall Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:

  • "Test Your Thinking" solutions and explanations
  • Author's Corner: A multipurpose area for author notes and errata
  • Additional self-review questions with instant feedback
  • An exclusive Virtual Study Lounge where you can interact with other learners!

Experience the skills you need! Melanie Caffrey and Douglas Scherer are experienced Oracle database professionals who together have taught hundreds of students in Oracle database technology. Benefit from their combined knowledge and ehands-on, through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" exercises lead you to a practiced understanding of the subject.

  • 100s of activities cover real-world tasks that really matter!
  • Dozens of self-review questions and answers solidify your understanding!


Read More Show Less

Editorial Reviews

Booknews
Teaches core Oracle DBA skills with real-world labs, exercises, questions, and a Web-based training site. Covers day-to-day aspects of Oracle database administration, including managing the database and its physical layout, ensuring security and data integrity, and providing for backups. Also outlines Oracle networking, logical and physical backup, and application and SQL optimization. Caffrey teaches introductory courses in SQL and Oracle Server at Columbia University. Scherer is an Oracle consultant. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780130157423
  • Publisher: Prentice Hall
  • Publication date: 12/11/2000
  • Series: Interactive Workbook Series
  • Pages: 486
  • Product dimensions: 7.00 (w) x 9.40 (h) x 1.20 (d)

Meet the Author

Melanie Caffrey: Before entering the world of Oracle and database technology in general, Melanie Caffrey was a researcher, first for the academic world in Colorado, then for the corporate world in New York. The desire to explore a new career path led her to Columbia University's Computer Technology and Applications (CTA) Program, which ultimately changed her life. Shortly before finishing at Columbia, she began developing applications using SAP technology with an Oracle database. Additionally, she enjoys spending a semester or two, here and there, teaching the class that is the foundation for this book and, occasionally, introductory courses in SQL and the Oracle Server, to the students at Columbia University's CTA program.

Douglas Scherer: Douglas Scherer (Chauncey and OCP certified) is president of Core Paradigm (www.coreparadigm.com); providing consulting, guidance, and formal training solutions primarily to Oracle users. He is a frequent speaker at conferences and user group meetings internationally and has appeared in Visions of the New Millennium, a series seen on PBS and its affiliates. Mr. Scherer's 12 years of IT and database experience has spanned analysis, design, implementation, database management, and project management. He is lead author of Oracle 8i Tops and Techniques, contributing editor to the Oracle Designer Handbook, 2nd edition, and has articles in Oracle Magazine. Mr. Scherer is an instructor in Columbia University's CTA program and for three years held the position of Chair of the Database Track.

Read More Show Less

Read an Excerpt

PREFACE:

Introduction

The Oracle DBA Interactive Workbook presents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book.

This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. After working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator.

Who this book is for

This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplement the Introduction to Oracle Database Administration class in the Database Track at Columbia University's ComputerTechnology and Applications (CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class.

The student body entering the CTA program range from those who have years of experience in the IT field but no experience with Oracle, to those with absolutely no experience in IT and even no experience with PCs. The Introduction to Oracle Database Administration class is offered as an elective in the fourth and final term of the CTA program's curriculum. So, while it is geared for beginners with little or no previous experience with Oracle database administration, it is expected that the reader will have some experience working with an Oracle database. The reader should be comfortable with relational database concepts as well as SQL. If you are unfamiliar with any of these subjects, refer to the Oracle SQL Interactive Workbook in the Prentice Hall Oracle Interactive Workbook series.

What you'll need

There are software as well as knowledge requirements necessary to complete the exercise sections of the workbook.

Software

  • Oracle 7.3.4, 8.0, or 8i.
  • Access to the WWW.

Note that prior to beginning the workbook labs, you should already have installed the Oracle Server software (it will make it easier to get through the labs if you do not install the default database, however) and the Net8 or SQL*Net components. Since the instructions vary greatly depending on the platform, you should consult your Oracle documentation (Installation Guide and Getting Started) for installation information.

Oracle 7.3.4, 8.0, or 8i

You can use either Oracle Standard Edition or Oracle Enterprise Edition. Since you will be performing actions that may affect other databases, you should not work through the tasks in this book in an environment where there are critical data, programs, etc.!

Since Oracle frequently improves and changes its products, new versions are released all the time. However, the concepts covered in this book are fundamental to the Oracle RDBMS (hereafter called the Oracle Server) and are unlikely to change significantly in the near future. Even if your version of the database is slightly different than the one listed here, you should still be able to make use of this book.

The tasks and descriptions represent core issues of Oracle Server architecture and are therefore universal to all three versions of the Oracle Server. There are occasional notes to point out a specific issue regarding a specific version.

Additionally, you should be familiar with SQL*Plus, the tool supplied with the database to interact with it in a command-line fashion.

Access to the WWW

You will need access to the Internet and the WWW so that you can access the companion Web site for this book through--

...
Read More Show Less

Table of Contents

About the Authors xiii
Foreword xv
Acknowledgments xvii
Introduction xxi
Chapter 1 The Database Administrator's Job 1
LAB 1.1 The Role of the Oracle DBA 2
1.1.1 Understand About Becoming a DBA 3
1.1.2 Understand the Role of the DBA 3
LAB 1.2 Sources for Oracle DBA Help 6
1.2.1 Prepare for Tasks 8
1.2.2 Find Oracle Help 9
Chapter 1 Test Your Thinking 13
Chapter 2 Creating Your Database 15
LAB 2.1 OFA Basics 16
2.1.1 Identify your ORACLE_BASE Location 17
2.1.2 Identify your ORACLE_HOME Directory 18
2.1.3 Identify and Configure your Admin Directory 19
2.1.4 Identify the Location for your Database Files 20
LAB 2.2 Creating and Configuring an Oracle Database 25
2.2.1 Edit the Instance Configuration File 28
2.2.2 Write Scripts to Create the Database 34
2.2.3 Create the Database Using the Create Scripts 39
2.2.4 Test Database Viability 44
2.2.5 Set the ROLLBACK_SEGMENTS Parameter 46
2.2.6 Review the Scripts That Create the Data Dictionary 47
Chapter 2 Test Your Thinking 56
Chapter 3 Oracle Networking: Configuring Basic Net8/SQL*NET Components 57
LAB 3.1 Setting up Network Configuration Files 58
3.1.1 Manually Configure the tnsnames.ora File 58
3.1.2 Manually Configure the listener.ora File 62
LAB 3.2 Managing the Oracle Listener 67
3.2.1 Start and Stop the Listener 68
3.2.2 Issue Other Listener Commands 70
3.2.3 Perform a Loopback Test 71
LAB 3.3 Configuring the Multi-Threaded Server 76
3.3.1 Configure and View Information about the MTS Environment 76
Chapter 3 Test Your Thinking 81
Chapter 4 Tablespaces 83
LAB 4.1 Tablespaces: Logical Areas of Storage 85
4.1.1 What a Tablespace is 87
4.1.2 What a Tablespace is Used For 87
LAB 4.2 How Tablespaces Relate to the Oracle Database and How to Manipulate Them 91
4.2.1 Understand The Relationship of Tablespaces to Physical Files 93
4.2.2 Create a Tablespace 94
4.2.3 Delete a Tablespace 95
Chapter 4 Test Your Thinking 102
Chapter 5 Segments and Extents 103
LAB 5.1 Segments 104
5.1.1 Define a Segment 104
5.1.2 Identify Common Segment Types 105
LAB 5.2 Extents 111
5.2.1 Define an Extent 111
5.2.2 Understand Segment and Extent Parameters 113
5.2.3 Understand Free Space 115
Chapter 5 Test Your Thinking 127
Chapter 6 Data Blocks 129
LAB 6.1 Units of Storage Called Data Blocks 130
6.1.1 Define a Block 130
6.1.2 Understand the Makeup of a Block 134
6.1.3 Recognize the Physical Record Format 135
LAB 6.2 Block-Level Storage Parameters 145
6.2.1 Understand Block-Level Storage Parameters 145
6.2.2 Understand Row Migration and Row Chaining 149
6.2.3 Understand Free Lists 151
Chapter 6 Test Your Thinking 156
Chapter 7 Redo Logs 157
LAB 7.1 Redo Logs 158
7.1.1 Understand Why Redo Logs Are Important 158
7.1.2 Understand How LGWR Writes To Redo Logs 161
LAB 7.2 Recovering Data with Redo Logs 170
7.2.1 Understand How Redo Logs Are Used In Recovering Lost Data 170
Chapter 7 Test Your Thinking 178
Chapter 8 Datafiles 179
LAB 8.1 Datafiles 180
8.1.1 Understand Datafiles 180
8.1.2 Understand the Relationship between Datafiles and an Instance 182
LAB 8.2 Manipulating Your Datafiles 189
8.2.1 Create, Manipulate, and Delete a Datafile 189
Chapter 8 Test Your Thinking 199
Chapter 9 User Creation 201
LAB 9.1 Creating and Manipulating Users 202
9.1.1 Create and Manipulate Users 202
Chapter 9 Test Your Thinking 215
Chapter 10 Privilege and Resource Groups 217
LAB 10.1 Creating and Manipulating Privileges 218
10.1.1 Create and Manipulate Privileges 218
LAB 10.2 Creating and Manipulating Roles 230
10.2.1 Create and Manipulate Roles 230
LAB 10.3 Creating and Manipulating Profiles 237
10.3.1 Create and Manipulate Profiles 237
Chapter 10 Test Your Thinking 249
Chapter 11 Auditing 251
LAB 11.1 Auditing Sessions, Auditing Database Actions, and Auditing Objects 252
11.1.1 Audit Sessions, Audit Database Actions, and Audit Objects 252
Chapter 11 Test Your Thinking 269
Chapter 12 Rollback Segments 271
LAB 12.1 Rollback Segment Management 272
12.1.1 Configure and Maintain Rollback Segments 272
Chapter 12 Test Your Thinking 294
Chapter 13 Locking 295
LAB 13.1 Locking and Data Consistency and Concurrency 296
13.1.1 Create, Review, and Eliminate Locks 296
Chapter 13 Test Your Thinking 310
Chapter 14 Logical Backup and Recovery 311
LAB 14.1 Backup and Recovery Using the Import and Export Utilities 312
14.1.1 Perform a Logical Backup Using the Export Utility 312
14.1.2 Perform a Logical Recovery Using the Import Utility 315
Chapter 14 Test Your Thinking 325
Chapter 15 Physical Backup and Recovery 327
LAB 15.1 Backup and Recovery Using Archivelog Mode 328
15.1.1 Perform a Physical Backup and Perform Different Types of Archiving 328
15.1.2 Simulate a Media Failure 338
15.1.3 Perform a Complete Offline Recovery 341
15.1.4 Perform a Complete Online Recovery 344
Chapter 15 Test Your Thinking 364
Chapter 16 Application and SQL Optimization 365
LAB 16.1 Using the Autotrace Command and TKPROF Utility 366
16.1.1 Set up SQL*Plus's AUTOTRACE Utility 373
16.1.2 Determine the Optimizer Mode 374
16.1.3 Analyze Tables and Indexes 375
16.1.4 Interpret the Output of the Execution Plan 376
16.1.5 Use the TKPROF Utility 377
Chapter 16 Test Your Thinking 401
Chapter 17 Database Tuning and Optimization 403
LAB 17.1 Optimizing the Use of Memory and Disk Resources 404
17.1.1 Gather Performance Statistics 404
17.1.2 Monitor and Enhance Memory Usage 407
17.1.3 Determine I/O Distribution and Level of Contention 413
17.1.4 Analyze Performance Statistics 414
Chapter 17 Test Your Thinking 425
Appendix A Answers to Self-Review Questions 427
Appendix B Recommended Reading List 439
Appendix C Raid Synopsis 441
Appendix D Environment Settings to Remember 443
Index 449
Read More Show Less

Preface

Introduction

The Oracle DBA Interactive Workbook presents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book.

This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. After working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator.

Who this book is for

This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplement the Introduction to Oracle Database Administration class in the Database Track at Columbia University's Computer Technology and Applications(CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class.

The student body entering the CTA program range from those who have years of experience in the IT field but no experience with Oracle, to those with absolutely no experience in IT and even no experience with PCs. The Introduction to Oracle Database Administration class is offered as an elective in the fourth and final term of the CTA program's curriculum. So, while it is geared for beginners with little or no previous experience with Oracle database administration, it is expected that the reader will have some experience working with an Oracle database. The reader should be comfortable with relational database concepts as well as SQL. If you are unfamiliar with any of these subjects, refer to the Oracle SQL Interactive Workbook in the Prentice Hall Oracle Interactive Workbook series.

What you'll need

There are software as well as knowledge requirements necessary to complete the exercise sections of the workbook.

Software

  • Oracle 7.3.4, 8.0, or 8i.
  • Access to the WWW.

Note that prior to beginning the workbook labs, you should already have installed the Oracle Server software (it will make it easier to get through the labs if you do not install the default database, however) and the Net8 or SQL*Net components. Since the instructions vary greatly depending on the platform, you should consult your Oracle documentation (Installation Guide and Getting Started) for installation information.

Oracle 7.3.4, 8.0, or 8i

You can use either Oracle Standard Edition or Oracle Enterprise Edition. Since you will be performing actions that may affect other databases, you should not work through the tasks in this book in an environment where there are critical data, programs, etc.!

Since Oracle frequently improves and changes its products, new versions are released all the time. However, the concepts covered in this book are fundamental to the Oracle RDBMS (hereafter called the Oracle Server) and are unlikely to change significantly in the near future. Even if your version of the database is slightly different than the one listed here, you should still be able to make use of this book.

The tasks and descriptions represent core issues of Oracle Server architecture and are therefore universal to all three versions of the Oracle Server. There are occasional notes to point out a specific issue regarding a specific version.

Additionally, you should be familiar with SQL*Plus, the tool supplied with the database to interact with it in a command-line fashion.

Access to the WWW

You will need access to the Internet and the WWW so that you can access the companion Web site for this book through—

http://www.phptr.com/scherer

Here you will find the files that are necessary for completing the exercises.

Knowledge

To complete the exercises, you should be familiar with relational database concepts and understand what an Entity Relationship Diagram is. You should also be comfortable using SQL to access and manipulate database objects such as tables, constraints, sequences, and so on.

If you are not familiar or comfortable with these subjects, then it is recommended that you refer to the Oracle SQL Interactive Workbook in the Prentice Hall Oracle Interactive Workbook series.

You should also feel comfortable working in your operating system's command-line environment.

How this Book Is Organized

The intent of this workbook is to teach you about Oracle database administration by presenting you with a series of tasks and challenges, followed by detailed solutions to those challenges. At times, an individual task acts as a complete unit of work, while other tasks are developed through a series of simple actions. Each chapter has a series of labs that introduce topics. The labs are composed of tasks, which are typical to the daily work of a database administrator. Beyond the labs, topics are further explored through questions and answers. What follows is the common layout of the chapters:

Chapter Objectives
A list of subjects the chapter will cover.
Chapter Text
An overview of chapter subjects.
Lab Objectives
A list of subjects the lab will cover.
Lab Text
An introduction to the lab subject, occasionally including steps that prepare the Oracle Server for the exercises.
Exercises
Questions that require hands-on interaction with the Oracle Server. The exercises will guide you through learning the subject introduced in the lab text.
Exercise Answers
Answers and discussion of the exercise subject.
Self-Review Questions
Multiple-choice questions to review lab material.
Test Your Thinking
Project questions to supplement the lab material.

Depending on the bread exercises.

The exercises are not meant to be closed-book quizzes to test your knowledge. On the contrary, they are intended to act as your guide and walk you through a task. You are encouraged to flip back and forth from the question section to the answer section so that, if need be, you can read the discussions as you go along.

The chapters and their exercises must be completed in sequence as the material in later chapters builds on what is presented earlier.

Chapter 1, "The Database Administrator's Job," introduces you to the world of database administration.

Chapter 2, "Creating Your Database," walks you through the steps of manually creating your own database.

Chapter 3, "Oracle Networking: Configuring Basic Net8/SQL*Net Components," guides you through setting up the components necessary for remote users to connect to your database over a network.

Chapter 4, "Tablespaces," teaches you how to create and manipulate tablespaces, and introduces you to logical storage constructs.

Chapter 5, "Segments and Extents," provides a more in-depth look at these higher level logical storage constructs, which were introduced in Chapter 4.

Chapter 6, "Data Blocks," examines data blocks, the smallest unit of Oracle storage.

Chapter 7, "Redo Logs," teaches you the basics of how redo logs operate and how they are written to.

Chapter 8, "Datafiles," describes how to view information about and manipulate datafiles.

Chapter 9, "User Creation," teaches you how to create and alter user accounts.

Chapter 10, "Privilege and Resource Groups," introduces you to the concepts and effects of privileges, roles, and resource limits and shows you how to assign them to user accounts.

Chapter 11, "Auditing," examines Oracle's mechanism for recording different types of database activity for purposes of maintaining database security and/or keeping records of billable activity.

Chapter 12, "Rollback Segments," presents a study of the use and operation of rollback segments and how they provide an Oracle database with read-consistency and "undo" information.

Chapter 13, "Locking," guides you through exercises that demonstrate the importance of Oracle locking mechanisms and introduces you to the concepts of data "consistency" and "concurrency."

Chapter 14, "Logical Backup and Recovery," covers logical data backups and recoveries using the Oracle-provided import (IMP) and export (EXP) utilities.

Chapter 15, "Physical Backup and Recovery," teaches you about different types of database failures, walks you through a simulation of a physical database failure and recovery, and explains the importance of archiving your redo log files.

Chapter 16, "Application and SQL Optimization," provides a look at optimizing standalone and application SQL code through Oracle-provided facilities such as AUTOTRACE, SQLTRACE, and TKPROF.

Chapter 17, "Database Tuning and Optimization," presents an introductory look at the other side of tuning an Oracle database by showing you how to gather information about and, if necessary, tune your memory and disk I/O through the use of the Oracle-provided utilities, UTLBTAT.SQL and UTLESTAT.SQL.

About the companion web site

The companion Web site is located at

http://www.phptr.com/scherer

Here you will find two very important items:

  1. Files you will downl for specific tasks in the workbook.
  2. Answers to the Test Your Thinking questions.

Also, check the Web site for periodically updated information about the book.

IMPORTANT notes about COMPLETING THE exercises
  • Complete the chapters and exercises in the order they're given. If the labs, exercises, and steps are not done in their proper sequence, you may have to start from the first chapter and work your way back into the material. This is similar to performing these tasks in a real-world environment. Database administration is less forgiving than application coding. In database administration, you cannot simply recompile your code and try the application again. If you leave out a step, you may lose a portion of the database in a way that is unrecoverable—losing your work. The only exception to this is Chapter 3, "Oracle Networking: Configuring Basic Net8/SQL*Net Components," which can be completed after all of the other chapters.
  • In Chapter 2, you will learn about the command SHUTDOWN IMMEDIATE. After successfully completing Chapter 2, you should, from then on perform a SHUTDOWN IMMEDIATE on your database before rebooting or shutting down your computer.
  • For Chapters 2, 3, 13, 15, and 17, you should allocate enough time to finish from beginning to end. It can take from 45 minutes to a couple of hours to complete the exercises in each chapter. The other chapters will flow better if you complete them in one sitting, but it is not as critical to your database if you are unable to do so.
  • Check off the steps as you complete them. The most frequent error students make in the CTA course is not following each step insignificant it seems. Learn to walk before you run. If you think there's a better way to accomplish an activity, don't try it out until you've completed the entire Oracle DBA Interactive Workbook. Some of the steps are in the text and some are explicitly in the exercises. If you check off each step as you go along, you will be more inclined to perform each task, and will have a way to trace whether you've missed a step if you run into trouble.
  • The questions require you to think like an Oracle DBA. For example, you may be asked to look into an Oracle-provided script and report what you think it will do based on the information in the script. In another example, you may perform an exercise to make the database freeze. You're then asked to figure out what the problem is and what the next step should be to fix the problem, based on the knowledge that you've gained by that point in the book. Of course, the solution is given to you, but do your best to consider the problem before reading the provided answer. In either case, make your solution to the problem fall within the scope of the problem set in the chapter. This will be good practice for your work as a DBA, when you will be required to stay focused under pressure.
  • For those completing the tasks in Windows, you should have administrative rights to the machine where the database is located.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)