Oracle 10g Database Administrator: Implementation and Administration

, by Powell, Gavin; McCullough-Dieter, Carol

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9781418836658 | 1418836656
Cover: Paperback
Copyright: 6/21/2006

Rent

(Recommended)

$5.14

Term

Due

Price

Semester

Dec 13

$5.14

Quarter

Aug 16

$5.14

Short Term

Jul 4

$5.14

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy Used

Usually Ships in 3-5 Business Days

$99.04
Buy New

In Stock Usually Ships in 24 Hours.

$7.52

Oracle 10g: Database Administrator: Implementation and Administration (DBA1) uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This real-world approach, combined with topics ranging from initialization parameters and table space storage to data integrity, constraints, and user profiles, provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-041). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions.

Preface

xiii

Oracle Architecture Overview

(34)

Introduction to Oracle 10g Architecture

(8)

Key Components of the Oracle 10g

(3)

Running the Database

(4)

Some Optional Additions to Oracle 10g

(1)

Introduction to ORACLASS Database

(1)

Overview of Oracle 10g Installation Options

(4)

Comparing Server-Side Installation Options

(2)

Comparing Client-Side Installation Options

(1)

The Oracle Universal Installer

(3)

Oracle Home

(2)

Description of Optimal Flexible Architecture (OFA)

(3)

Directory Structure Standards

(2)

File Naming Standards

(1)

Installing Oracle Software

(8)

Chapter Summary

(1)

Review Questions

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

(2)

Hands-on Assignments

(1)

Case Project

(2)

Tools and Architecture

(52)

Overview of DBA Tools

(3)

Configuring Oracle Net Services to Connect to the Database

(17)

Overview of Oracle Net Services Architecture

(3)

Network Naming Methods

(1)

Step-By-Step Configuration of Oracle Net Services Using Net Manager

(6)

TNS Configuration Files

(1)

Working with the Listener

(2)

Using the Net Configuration Assistant

(1)

Using SQL *Plus, SQL *Plus Worksheet, and iSQL *Plus

(4)

Oracle Instance Architecture

(7)

Shared and Dedicated Server Processes

(3)

Background Processes

(2)

Memory Components

(2)

Introducing Enterprise Manager

(17)

Running the Enterprise Manager Console

(2)

Viewing the Features of Enterprise Manager

(10)

The Database Control Interface

(4)

Chapter Summary

(1)

Review Questions

(1)

Exam Review Questions---Oracle Database 10g Administration (#1Z0-042)

(2)

Hands-on Assignments

(2)

Case Project

(1)

Creating an Oracle Instance

(50)

Steps for Creating a Database

(1)

Overview of Prerequisites for Creating a Database

(1)

Choosing Configuration

(14)

Database Type

(1)

Database Management Tool

(1)

DBA Authentication Methods

(4)

Storage Management Methods

(1)

File Management Methods

(3)

Set the Initialization Parameters

100

(4)

Creating a Database

104

(18)

Create a New Database Using the Database Configuration Assistant

105

(13)

Creating a Database Manually

118

(4)

Starting and Stopping the Instance and Database

122

(3)

Managing Text and Binary (Server) Parameter Files

125

(1)

The Alert Log and Trace Files

126

(2)

Expanding OFA Just a Little More

126

(2)

Chapter Summary

128

(2)

Review Questions

130

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

131

(2)

Hands-on Assignments

133

(2)

Case Project

135

(2)

Oracle Physical Architecture and Data Dictionary Views

137

(62)

Tablespaces and Datafiles

138

(3)

Advanced Database Architectures

141

(4)

Oracle Managed Files (OMF)

142

(1)

Partitioning

142

(1)

Replication

142

(1)

Standby (Failover) Databases

143

(1)

Grid Computing, Oracle RAC and ASM

144

(1)

The Control File

145

(10)

Managing and Multiplexing the Control Files

146

(4)

Using OMF to Manage Control Files

150

(1)

Creating a New Control File

151

(3)

Viewing Control File Data

154

(1)

Online Redo Log Files and Archive Log Files

155

(21)

The Purpose of Redo Log Files

158

(1)

The Structure of Redo Log Files

159

(1)

Introducing Redo Log File Management

160

(1)

Log Switches and Checkpoints

161

(2)

Duplexing and Other Maintenance

163

(10)

Using OMF to Manage Online Redo Log Files

173

(2)

Viewing Redo Log Information

175

(1)

The Data Dictionary

176

(11)

Looking at Data Dictionary Components

176

(3)

Using Data Dictionary Views

179

(6)

Useful Dynamic Performance Views

185

(1)

Examining Table Structure Using SQL *Plus and iSQL *Plus

186

(1)

Chapter Summary

187

(2)

Review Questions

189

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

190

(5)

Hands-on Assignments

195

(2)

Case Projects

197

(2)

Basic Storage Concepts and Settings

199

(52)

Introduction to Storage Structures

200

(22)

Logical Structure Versus Physical Structure

200

(5)

Tablespaces and Datafiles

205

(11)

Segment Types and Their Uses

216

(2)

Temporary Tablespace

218

(2)

Tablespaces with Nonstandard Data Block Size

220

(2)

Configuring and Viewing Storage

222

(9)

Changing the Size, Storage Settings, and Status

222

(7)

Querying the Data Dictionary for Storage Data

229

(2)

Overview of Undo Data

231

(8)

Implementing Automatic Undo Management

232

(3)

Monitoring Undo

235

(4)

Overview of Diagnostic (Trace) Files

239

(5)

Chapter Summary

244

(1)

Review Questions

245

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

246

(1)

Hands-on Assignments

247

(2)

Case Projects

249

(2)

The Basics of Querying a Database

251

(40)

Introduction to Queries

252

(10)

Different Types of Queries

252

(3)

Oracle SQL Functions and Pseudocolumns

255

(2)

What is NULL?

257

(2)

The DUAL Table and More on Pseudocolumns

259

(2)

The DISTINCT Clause

261

(1)

The SELECT Statement

262

(3)

Filtering, Sorting, and Summarizing (Aggregations) Queries

265

(8)

Filtering Queries with the WHERE Clause

265

(4)

Sorting Queries with the ORDER BY Clause

269

(2)

Aggregating Queries with the GROUP BY Clause

271

(2)

Advanced Queries

273

(13)

Joins

273

(5)

Subqueries

278

(2)

Other Specialized Queries

280

(6)

Chapter Summary

286

(2)

Review Questions

288

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

288

(1)

Hands-on Assignments

288

(1)

Case Project

289

(2)

Basic Table Management

291

(66)

Introduction to Table Structures

293

(13)

Setting Block Space Usage

295

(4)

Storage Methods

299

(3)

Row Structure and the ROWID

302

(4)

Creating Tables

306

(26)

Columns and Datatypes

307

(5)

Creating Relational Tables

312

(5)

Creating Temporary Tables

317

(3)

Creating VARRAYs and Nested Tables

320

(5)

Creating Object Tables

325

(2)

Creating Partitioned Tables

327

(5)

Viewing Database Object Attributes

332

(14)

Viewing Object Metadata in SQL *Plus

332

(4)

Viewing Object Metadata in the Console

336

(1)

Viewing Object Metadata in the Database Control

337

(9)

Chapter Summary

346

(2)

Review Questions

348

(2)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

350

(2)

Hands-on Assignments

352

(3)

Case Project

355

(2)

Advanced Table Management

357

(38)

Advanced Table Structures

358

(9)

Tables with LOB Columns

358

(2)

LOB Storage

360

(4)

Index-Organized Tables

364

(3)

Overview of Table Management

367

(16)

Analyzing a Table

368

(2)

Adjusting Table Storage Structure

370

(3)

Redefining Tables Online

373

(4)

Dropping, Adding, or Modifying a Column in a Table

377

(3)

Truncating and Dropping a Table

380

(3)

Making Other More Specialized Table Changes

383

(2)

Table Flashback Recovery

383

(1)

Transparent Table Encryption

384

(1)

Querying Data Dictionary Views for Tables and Other Objects

385

(2)

Chapter Summary

387

(1)

Review Questions

388

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

389

(2)

Hands-on Assignments

391

(2)

Case Project

393

(2)

Constraints, Indexes, and Other Specialized Objects

395

(70)

What are Constraints?

396

(22)

Types of Integrity Constraints

397

(2)

How To Create and Maintain Integrity Constraints

399

(6)

Working with Constraints

405

(11)

Data Dictionary Information on Constraints

416

(2)

What are Indexes?

418

(27)

Types and Uses of Indexes

421

(17)

Managing Indexes

438

(3)

Data Dictionary Information on Indexes

441

(4)

Other Specialized Database Objects

445

(6)

Views

445

(3)

Sequences

448

(1)

Synonyms

449

(1)

Data Dictionary Information on Views, Sequences, and Synonyms

450

(1)

Chapter Summary

451

(2)

Review Questions

453

(2)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

455

(5)

Hands-on Assignments

460

(3)

Case Projects

463

(2)

Basic Data Management

465

(20)

Introduction to Basic Data Management

465

(6)

What are DML and DDL?

467

(1)

What is a Transaction?

468

(3)

Using DML Statements

471

(5)

The INSERT Statement (Adding New Data)

471

(4)

The UPDATE Statement (Changing Existing Data)

475

(1)

The DELETE Statement (Delete Existing Data)

476

(1)

Controlling Transactions

476

(3)

The COMMIT Statement

477

(1)

The ROLLBACK Statement

477

(1)

The SAVEPOINT Statement

477

(1)

SET TRANSACTION Statement

477

(1)

The LOCK TABLE Statement

478

(1)

Directory Objects

479

(3)

Chapter Summary

482

(1)

Review Questions

482

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

483

(1)

Hands-on Assignments

484

(1)

Case Project

484

(1)

Advanced Data Management

485

(30)

Introduction to Advanced Data Management

486

(1)

Coding SQL into Programs with PL/SQL

487

(15)

Blocks, Exception Trapping, and Anonymous Blocks

487

(3)

Named Blocks and Packages

490

(5)

Triggers and Events Firing Triggers

495

(1)

PL/SQL Variables and Datatypes

496

(1)

What Is a Cursor?

497

(2)

PL/SQL Programming Control Structures

499

(3)

Bulk Imports and Exports Using Data Pump

502

(3)

Exporting Using Data Pump

503

(1)

Importing Using Data Pump

504

(1)

Bulk Data Loads with SQL *Loader

505

(7)

Direct Versus Conventional Path Loads

505

(2)

SQL Loader Input Data Files

507

(1)

The SQL Loader Control File

507

(3)

The Parameter File

510

(2)

Chapter Summary

512

(1)

Review Questions

512

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

513

(1)

Hands-on Assignments

514

(1)

Case Project

514

(1)

Security Management

515

(86)

Users and Resource Control

516

(10)

Creating New Users

517

(5)

Modifying User Settings with the ALTER USER Statement

522

(2)

Removing Users

524

(2)

Introduction to Profiles

526

(11)

Creating Profiles

527

(2)

Managing Passwords

529

(6)

Controlling Resource Usage

535

(2)

Dropping a Profile

537

(1)

Obtaining User, Profile, Password, and Resource Data

537

(7)

System and Object Privileges

544

(3)

Identifying System Privileges

544

(2)

Using Object Privileges

546

(1)

Managing System and Object Privileges

547

(12)

Granting and Revoking System Privileges

547

(5)

Granting and Revoking Object Privileges

552

(7)

Description of Auditing Capabilities

559

(7)

Database Roles

566

(5)

How to Use Roles

566

(2)

Using Predefined Roles

568

(3)

Creating and Modifying Roles

571

(8)

Creating and Assigning Privileges to a Role

572

(1)

Assigning Roles to Users and to Other Roles

572

(4)

Limiting Availability and Removing Roles

576

(3)

Data Dictionary Information about Roles

579

(1)

Roles in the Enterprise Manager Console

580

(6)

Chapter Summary

586

(1)

Review Questions

587

(3)

Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)

590

(8)

Hands-on Assignments

598

(1)

Case Project

599

(2)

Performance Monitoring

601

(34)

Introduction to Performance Monitoring

603

(2)

Different Tools for Performance Monitoring

603

(2)

Statistics

605

(12)

The Importance of Statistics

605

(1)

Gathering Statistics Manually

606

(2)

Automated Statistics Gathering

608

(9)

Performance Metrics

617

(3)

Changing Performance Metric Parameters

619

(1)

Searching for Invalidated Objects

620

(1)

Lock Conflicts

621

(10)

How to Detect Lock Conflicts

622

(4)

Resolving Lock Conflicts

626

(4)

What is a Deadlock?

630

(1)

Chapter Summary

631

(1)

Review Questions

631

(2)

Exam Review Questions---Oracle Database 10g: Administration (#1Z1-042)

633

(1)

Hands-on Assignments

633

(1)

Case Projects

634

(1)

Proactive Maintenance

635

(42)

What is Proactive Maintenance?

636

(1)

Advice Performance Tools

636

(28)

The Different Tuning and Diagnostic Advisors

639

(25)

Baseline Metrics

664

(9)

What are Baseline Metrics?

665

(6)

Changing Baseline Metrics

671

(2)

Chapter Summary

673

Review Questions

373

(301)

Exam Review Questions---Oracle Database 10g: Administration (#1Z1-042)

674

(1)

Hands-on Assignments

675

(1)

Case Project

675

(2)

Backup and Recovery

677

(32)

Introduction to Backup and Recovery

678

(14)

What is Backup?

678

(1)

What is Restoration?

678

(2)

What is Recovery?

680

(1)

Methods of Backup and Recovery

681

(1)

Tools for Backup and Recovery

682

(1)

Types of Failure

683

(1)

Backup Strategy

684

(8)

Configuring a Database for Possible Recovery

692

(3)

Setting the Database in Archive Log Mode

692

(2)

Checkpoints, Redo Logs, Archive Logs, and Fast Starts

694

(1)

Sacrificing Recoverability for Performance

695

(1)

Flash Recovery and Backups

695

(5)

The MTTR (Mean Time To Recovery) Advisor

696

(4)

Database Backup

700

(4)

Cold Backups

700

(1)

Hot Backups

701

(3)

Database Recovery

704

(2)

Chapter Summary

706

(1)

Review Questions

706

(1)

Exam Review Questions---Oracle Database 10g: Administration (#1Z1-042)

707

(1)

Hands-on Assignments

708

(1)

Case Project

708

(1)

Appendix A

709

(4)

Glossary

713

(14)

Index

727

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Oracle 10g Database Administrator: Implementation and Administration

Summary

Table of Contents

Supplemental Materials