Oracle 10g Database Administrator: Implementation and Administration,9781418836658

Oracle 10g Database Administrator: Implementation and Administration

by ;
Edition: 2nd
ISBN13: 9781418836658
ISBN10: 1418836656
Format: Paperback
Pub. Date: 2006-06-21
Publisher(s): Cengage Learning
  • Free Shipping Icon

    Free Shipping On All Orders!*

    Free economy shipping applies to all orders shipped to residential addresses. Orders shipped to campus receive free standard shipping. Free shipping offers do not apply to Marketplace items.

  • Buyback Icon We Buy This Book Back!
    In-Store Credit: $0.53
    Check/Direct Deposit: $0.50
    PayPal: $0.50
List Price: $138.95

Buy New

In Stock Usually Ships in 24-48 Hours
$27.74
Add to Cart

Buy Used

In Stock
$104.21
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $1.16

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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.

Table of Contents

Preface xiii
Oracle Architecture Overview
1(34)
Introduction to Oracle 10g Architecture
2(8)
Key Components of the Oracle 10g
2(3)
Running the Database
5(4)
Some Optional Additions to Oracle 10g
9(1)
Introduction to ORACLASS Database
10(1)
Overview of Oracle 10g Installation Options
11(4)
Comparing Server-Side Installation Options
12(2)
Comparing Client-Side Installation Options
14(1)
The Oracle Universal Installer
15(3)
Oracle Home
16(2)
Description of Optimal Flexible Architecture (OFA)
18(3)
Directory Structure Standards
18(2)
File Naming Standards
20(1)
Installing Oracle Software
21(8)
Chapter Summary
29(1)
Review Questions
30(1)
Exam Review Questions---Oracle Database 10g: Administration (#1Z0-042)
31(2)
Hands-on Assignments
33(1)
Case Project
33(2)
Tools and Architecture
35(52)
Overview of DBA Tools
36(3)
Configuring Oracle Net Services to Connect to the Database
39(17)
Overview of Oracle Net Services Architecture
39(3)
Network Naming Methods
42(1)
Step-By-Step Configuration of Oracle Net Services Using Net Manager
43(6)
TNS Configuration Files
49(1)
Working with the Listener
50(2)
Using the Net Configuration Assistant
52(1)
Using SQL *Plus, SQL *Plus Worksheet, and iSQL *Plus
52(4)
Oracle Instance Architecture
56(7)
Shared and Dedicated Server Processes
56(3)
Background Processes
59(2)
Memory Components
61(2)
Introducing Enterprise Manager
63(17)
Running the Enterprise Manager Console
64(2)
Viewing the Features of Enterprise Manager
66(10)
The Database Control Interface
76(4)
Chapter Summary
80(1)
Review Questions
81(1)
Exam Review Questions---Oracle Database 10g Administration (#1Z0-042)
82(2)
Hands-on Assignments
84(2)
Case Project
86(1)
Creating an Oracle Instance
87(50)
Steps for Creating a Database
88(1)
Overview of Prerequisites for Creating a Database
89(1)
Choosing Configuration
90(14)
Database Type
91(1)
Database Management Tool
92(1)
DBA Authentication Methods
92(4)
Storage Management Methods
96(1)
File Management Methods
97(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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.