rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9780072229806

Portable DBA Oracle

by
  • ISBN13:

    9780072229806

  • ISBN10:

    0072229802

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2004-11-22
  • Publisher: McGraw-Hill Education
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $52.00 Save up to $0.05
  • Buy New
    $51.95
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-3 BUSINESS DAYS

Summary

This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command.

Author Biography

Robert Freeman has been an Oracle DBA for almost 15 years. He currently lives in Chicago, where he works for TUSC as a management consultant. Robert presents at Oracle-related user groups such as IOUG-A and the UKOUG on a regular basis. He is the author of three other best-selling Oracle Press titles, Oracle Database 10g New Features, Oracle 9i RMAN Backup & Recovery, and Oracle9i New Features. Robert is the father of five teenagers, husband of a wife who is incredible, and the owner of a moody cat. In his spare time he works on getting his third-degree black belt in tae kwon do and sits at the edge of local runways with a sign that says "Will DBA for blocks of flight time."

Table of Contents

Acknowledgments xix
Introduction xxi
DBA Cheat Sheet
1(28)
Database Creation and-Management
29(28)
Introduction to Oracle Database Creation
30(17)
Creating a Database: Prerequisites
30(1)
Creating a Database: The create database Command
31(2)
Creating a Database: Security Issues
33(1)
Creating a Database: Recommended Practices
34(1)
The create database Command: Examples
35(1)
Creating a Database Manually: A Checklist
36(8)
Creating a Database: Error Resolution Table
44(2)
Other Typical Errors Associated with the create database Command
46(1)
The alter database Command
47(8)
Functions of the alter database Command
47(1)
Common Tasks Accomplished with alter database
48(5)
Error Messages Associated with the alter database Command
53(2)
Removing Your Oracle Database
55(2)
Rollback/Undo Segments, Control Files, and Redo Logs
57(28)
Oracle Undo
58(13)
Automated Undo Management
58(4)
Manual Rollback Segment Administration
62(4)
Monitoring Rollback Segments and Automated Undo
66(2)
Oracle Errors Associated with Rollback Segments and Automated Undo
68(3)
Control File Administration
71(7)
Control File Backups
72(1)
Moving the Control File
72(1)
Restoring the Control File
73(1)
Renaming the Database
74(2)
Oracle Errors Associated with Control Files
76(2)
Online Redo Log Administration
78(7)
The Basics of Online Redo Logs
78(1)
Creating New Redo Log Groups
79(1)
Creating New Redo Log Members
80(1)
Dropping an Online Redo Log Group
80(1)
Dropping an Online Redo Log Group Member
81(1)
Resizing Online Redo Logs
81(1)
Clearing an Online Redo Log
81(1)
Monitoring Online Redo Logs
81(1)
Archived Redo Logs
82(1)
Oracle Errors Associated with Online Redo Logs
82(3)
Tablespaces
85(18)
About Oracle Tablespaces
86(4)
The Oracle Tablespace
86(3)
Temporary Tablespaces
89(1)
Undo Tablespaces
90(1)
Creating Tablespaces
90(5)
extent_management_clause
91(1)
segment_management_clause
92(1)
Security Requirements
92(1)
About OMF
93(1)
create tablespace Examples
94(1)
Altering Tablespaces
95(2)
Security Requirements
96(1)
alter tablespace Examples
96(1)
Dropping Tablespaces
97(1)
Security Requirements
98(1)
drop tablespace Examples
98(1)
Tablespace Data Dictionary Information
98(1)
Tablespace-Related Errors
99(1)
Tablespace Naming Standards
100(1)
Datafile Naming Standards
101(2)
Tables
103(38)
Oracle Data Types
104(8)
Notes on Various Data Types
107(5)
Table Types
112(2)
Relational Tables
113(1)
Temporary Tables
113(1)
External Tables
113(1)
Index-Organized Tables
113(1)
Constraints
114(1)
Table Attributes
114(1)
Parallel Processing
115(1)
Partitioning
116(1)
Other Table-Related Features
116(1)
Creating Tables
117(11)
Security Requirements
117(4)
Sizing Tables Assigned to a Locally Managed Tablespace
121(1)
Examples of Using the create table Command
121(7)
Altering Tables
128(8)
Security Requirements
128(1)
Altering Nonpartitioned Table Examples
129(5)
Altering Partitioned Tables
134(2)
Dropping Tables
136(1)
Security Requirements
136(1)
Examples
136(1)
Table-Related Data Dictionary Information
137(1)
Table-Related Errors
138(1)
Table-Related Recommended Standards
139(2)
Indexes
141(24)
Indexing Overview
142(11)
Oracle Index Types
142(4)
Miscellaneous Index Features
146(7)
Creating Indexes
153(4)
Security Requirements
153(1)
Examples Using the create index Command
153(4)
Altering Indexes
157(4)
Security Requirements
158(1)
Nonpartitioned alter index Examples
158(2)
Examples Using the Partitioned alter index Commands
160(1)
Dropping Indexes
161(1)
Security Requirements
161(1)
Drop Index Example
162(1)
Index-Related Data Dictionary Information
162(1)
Index-Related Errors
162(1)
Recommended Standards
163(2)
Index Location Standards
164(1)
Index Naming Standards
164(1)
Views
165(10)
Updateable Views
166(2)
Other View Considerations
168(1)
Security Benefits of Views
168(1)
View Triggers
168(1)
Creating Views
169(2)
Security Requirements
169(1)
Examples of Using the create view Command
169(2)
Altering Views
171(1)
Security Requirements
171(1)
alter view Examples
171(1)
Dropping Views
172(1)
Security Requirements
172(1)
drop view Examples
172(1)
View-Related Data Dictionary Information
172(1)
View-Related Errors
173(1)
View-Related Recommended Standards
173(2)
Clusters
175(8)
Cluster Performance
176(1)
Creating Clusters
177(1)
Security Requirements
177(1)
create cluster Examples
177(1)
Altering Clusters
178(1)
Security Requirements
179(1)
Examples of Using the alter cluster Command
179(1)
Dropping Clusters
179(1)
Security Requirements
179(1)
drop cluster Example
179(1)
Cluster-Related Data Dictionary Information
180(1)
Cluster-Related Errors
180(3)
Sequences and Synonyms
183(12)
Sequences
184(5)
All About Sequences
184(1)
Creating Sequences
184(2)
Altering Sequences
186(2)
Dropping Sequences
188(1)
Sequence-Related Data Dictionary Information
188(1)
Sequence-Related Errors
188(1)
Sequence-Related Recommended Standards
189(1)
Synonyms
189(6)
Creating Synonyms
189(3)
Altering Synonyms
192(1)
Dropping Synonyms
192(1)
Synonym-Related Data Dictionary Information
193(1)
Synonym-Related Errors
193(1)
Synonym-Related Recommended Standards
193(2)
Users, Profiles, Roles, and Grants
195(24)
Administration of Users
196(4)
Creating Users
197(1)
Altering Users
197(1)
Dropping Users
198(1)
User-Related Data Dictionary Information
199(1)
User-Related Errors
199(1)
User-Related Recommended Standards
200(1)
Administration of Profiles
200(5)
Creating Profiles
202(1)
Altering Profiles
203(1)
Dropping Profiles
204(1)
Profile-Related Data Dictionary Information
204(1)
Profile-Related Errors
205(1)
Administration of System and Object Privileges
205(10)
Object Grants
205(1)
System Grants
206(4)
Using the with admin option Clause
210(1)
Using the with grant option Clause
211(1)
Public Grants
211(1)
Granting Privileges
211(2)
Revoking Privileges
213(1)
System and Object Privileges Data Dictionary Information
213(1)
System and Object Privileges-Related Errors
214(1)
System and Object Privileges-Related Recommended Standards
215(1)
Administration of Roles
215(4)
Common Oracle-Provided Roles
216(1)
Creating Roles
216(1)
Altering Roles
217(1)
Dropping Roles
217(1)
Role-Related Data Dictionary Information
218(1)
Role-Related Errors
218(1)
Miscellaneous Administrative Features
219(34)
Oracle Export Utility
220(4)
The exp Utility Command Line
220(2)
exp Utility Examples
222(2)
Oracle Import Utility
224(4)
The imp Utility Command Line
224(2)
imp Utility Examples
226(2)
Oracle Data Pump (Oracle Database 10g)
228(11)
Oracle Data Pump Export
228(5)
Oracle Data Pump Import
233(4)
Oracle Data Pump Interactive Mode
237(1)
Data Pump Export: Interactive Mode Parameters
238(1)
Oracle Backups
239(5)
Oracle Database Cold Backups
240(1)
Oracle Database Hot Backups
241(2)
Other Oracle Backups
243(1)
Database Recovery
244(9)
Recovering from a Manual Cold Backup (In NOARCHIVELOG Mode)
244(1)
Recovering from a Manual Cold Backup (In ARCHIVELOG Mode)
245(1)
Recovering from an RMAN Cold Backup (NOARCHIVELOG Mode)
245(1)
Recovering from an RMAN Cold Backup (In ARCHIVELOG Mode)
245(1)
Recovering from a Manual Hot Backup
245(2)
Recovering from an RMAN Hot Backup
247(1)
Incomplete Database Recovery
248(1)
Database Control File Recovery
249(4)
The Optimizer
253(28)
Optimizer Modes
254(1)
Rule Based Optimizer (RBO)
254(1)
Cost Based Optimizer (CBO)
254(1)
SQL Tuning
255(1)
Reduce the Work
255(1)
Balance the Work
255(1)
Fine-Tune the Work
255(1)
Identifying Poor SQL
256(2)
V$SQL View
256(1)
SQL Trace
256(1)
Statspack
257(1)
Automatic Database Diagnostic Monitor
257(1)
Tuning Advisors
258(1)
Optimizer Statistics
258(9)
analyze Command
258(1)
dbms_stats Package
259(8)
Automatic Statistics Gathering
267(1)
Execution Plans
267(2)
Access Paths
267(1)
Joins
268(1)
Optimizer Hints
269(5)
Specifying Hints
269(1)
Optimizer Mode Hints
270(1)
Access Path Hints
270(2)
Join Hints
272(1)
Parallel Hints
272(1)
Miscellaneous Hints
273(1)
explain plan Command
274(3)
Running explain plan
274(1)
Displaying explain plan Output
275(1)
Interpreting explain plan Output
275(1)
dbms_xplan Package
276(1)
Plan Stability
277(4)
Creating Outlines
278(1)
Using Outlines
278(1)
Moving Outlines
279(1)
Managing Outlines
279(2)
Miscellaneous Commands
281(26)
The alter system Command
282(6)
Security Requirements
282(1)
alter system Examples
282(4)
alter system-Related Data Dictionary Information
286(1)
alter system-Related Errors
286(2)
The alter session Command
288(5)
Security Requirements
288(1)
Examples of Using the alter session Command
288(4)
alter session-Related Data Dictionary Information
292(1)
alter session-Related Errors
292(1)
The create directory/drop directory Commands
293(2)
Security Requirements
293(1)
create directory Examples
293(1)
drop directory Example
293(1)
create directory-- /drop directory-Related Data Dictionary Information
294(1)
create directory-- /drop directory-Related Errors
294(1)
The comment Command
295(1)
Security Requirements
295(1)
comment Examples
295(1)
comment-Related Data Dictionary Information
296(1)
comment-Related Errors
296(1)
The lock table Command
296(2)
Security Requirements
296(1)
lock table Examples
297(1)
lock table-Related Data Dictionary Information
297(1)
lock table-Related Errors
298(1)
The purge Command
298(2)
Security Requirements
298(1)
purge Examples
298(1)
purge-Related Data Dictionary Information
299(1)
purge-Related Errors
300(1)
The rename Command
300(1)
Security Requirements
300(1)
rename Examples
300(1)
rename-Related Data Dictionary Information
301(1)
rename-Related Errors
301(1)
The set constraints Command
301(1)
Security Requirements
301(1)
set constraints Examples
301(1)
set constraints-Related Data Dictionary Information
302(1)
set constraints-Related Errors
302(1)
The set transaction Command
302(2)
Security Requirements
303(1)
set transaction Examples
303(1)
set transaction-Related Errors
303(1)
The create database link/drop database link Commands
304(3)
Security Requirements
304(1)
create database link/drop database link Examples
304(1)
create database link-/drop database link-Related Data Dictionary Information
305(1)
create database link-Related Errors
306(1)
Built-in Functions
307(28)
Introducing Oracle Built-in Functions
308(27)
Single-Row Functions
308(7)
Aggregate Functions
315(1)
Analytic Functions
316(2)
Object Reference Functions
318(1)
Model Functions
318(1)
Examples of Commonly Used Functions
318(17)
DML Commands
335(38)
The select Command
336(20)
Security Requirements
336(1)
Common Elements in a select Command
336(5)
Other Elements in a select Command
341(14)
select Command-Related Error Messages
355(1)
The insert Command
356(5)
Security Requirements
356(1)
Specifics of the insert Command
356(4)
insert Command-Related Error Messages
360(1)
The update Command
361(3)
Security Requirements
361(1)
Specifics of the update Command
361(1)
update Command Examples
362(1)
update Command-Related Error Messages
363(1)
The delete Command
364(2)
Security Requirements
364(1)
Specifics of the delete Command
364(1)
delete Command Examples
365(1)
delete Command-Related Error Messages
365(1)
The merge Command
366(2)
Security Requirements
366(1)
Specifics of the merge Command
366(1)
merge Command Examples
366(1)
merge Command-Related Error Messages
367(1)
The commit Command
368(1)
Security Requirements
368(1)
commit Command Examples
368(1)
The savepoint Command
368(1)
The rollback Command
368(1)
Security Requirements
368(1)
rollback Command Examples
369(1)
The truncate Command
369(1)
Security Requirements
369(1)
Specifics of the truncate Command
369(1)
truncate Command Examples
370(1)
truncate Command-Related Error Messages
370(1)
Writing Readable DML Statements
370(3)
A Initialization Parameters
373(38)
Parameter Files
374(1)
Initialization Parameter File
374(1)
Server Parameter Files
374(1)
Displaying Parameter Values
375(2)
show parameter
375(1)
V$System_PARAMETER
376(1)
V$PARAMETER
376(1)
V$PARAMETER2
376(1)
V$SPPARAMETER
376(1)
The Parameters
377(34)
B Data Dictionary Views
411(24)
USER_, ALL_, and DBA_
412(1)
DBA_ View
412(12)
Miscellaneous Views
424(1)
V$ Views
425(10)
C Oracle SQL Syntax
435(144)
Index 579

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program