Oracle 8I Administration and Management,9780471354536

Oracle 8I Administration and Management

by
Edition: CD
ISBN13: 9780471354536
ISBN10: 0471354538
Format: Paperback
Pub. Date: 1999-08-01
Publisher(s): John Wiley & Sons Inc
Availability: This title is currently not available.
List Price: $59.99

Rent Book

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

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

If you rely on instant access to critical information on an Oracle database, then you must become familiar with every aspect of this system. From the initial installation and day-to-day maintenance to critical backup, recovery, and disaster recovery procedures, this completely updated book and CD-ROM provide you with the necessary tools to run a fast, efficient, and reliable Oracle database. The book is loaded with practical case examples and real-world scenarios. With its in-depth coverage of Oracle8i, you2ll discover new object-oriented extensions that allow real-world modeling using the power of the relational engine. The book covers all new Oracle8i commands, packages, and database features, including the management of resource plans, temporary tables, locally managed tablespaces, and row-level security, along with from-the-trenches coverage of earlier versions of Oracle. Packed with tips and techniques, this book will help you: Administer the Oracle database using system features and third-party tools Administer database subjects Setup and administer users Use racle-provided packages, procedures, and utilities Monitor the database and fix any problems Tune the database for optimum efficiency Manage distributed databases Use the latest Oracle8i object extensions The CD-ROM includes: All of the scripts from the book Lite and demo versions of administration software Useful management aids Michael Ault (Alpharetta, GA) is a senior consultant for DMR Consulting Group, where he is the Associate Director for the Oracle Practice. He is also the systems operator for RevealNet2s DBAPipeline forum. His articles appear regularly in Oracle Internals and Select.

Author Biography

Michael Ault is the Corporate Technical Officer of DBMentors International, which he founded after 4 years as the Associate Director for the Oracle Practice at DMR Consulting Group.

Table of Contents

Installation of Oracle
1(58)
Things to Consider before Installation
1(3)
Optimal Flexible Architecture (OFA)
2(1)
Minimum OFA Configuration
3(1)
Oracle Structures and How They Affect Installation
4(3)
Executables
4(1)
Data Files
5(1)
Redo Logs
5(1)
Control Files
5(1)
Export Files
6(1)
Archive Logs
6(1)
LOB Storage
6(1)
BFILE Storage
6(1)
Oracle and Disk Usage
7(5)
How Many Is Enough?
7(1)
One Area (Surely You Jest)
7(1)
Two Areas (Just Barely Adequate)
7(1)
Three Areas (Nearly There)
7(1)
Four Areas (Just about Right)
8(1)
Five Areas (Shoehorn Required)
8(1)
Six Areas (Almost Enough)
8(1)
Seven Areas (Oracle Nirvana)
9(1)
Disk Striping, Shadowing, RAID, and Other Topics
9(1)
Disk Striping
9(1)
Disk Shadowing or Mirroring
10(1)
RAID---Redundant Arrays of Inexpensive Disks
10(1)
New Technologies
11(1)
Optical Disk Systems
11(1)
Tape Systems
11(1)
RAM Drives (Random Access Memory)
11(1)
System Considerations
12(1)
What Is an SGA and How Does It Apply to Me?
12(1)
What Is a PGA and How Does It Apply to Me?
13(1)
Some System-specific Notes
13(4)
VMS-Specific Notes
13(1)
Memory Requirements
14(1)
VMS SYSGEN Parameters
14(1)
UNIX-Specific Notes
14(1)
Data Files
14(1)
System Global Area (SGA)
14(1)
Rollback Segments
15(1)
RAW Devices
15(1)
Archives
16(1)
Installation Guidelines
17(14)
Generic Installation Issues
17(1)
Disk Space Availability
17(1)
The Oracle DBA Account
18(1)
Training
18(1)
Disk Layout
19(2)
Database-Specific Topics
21(1)
Number and Size of Database Tablespaces, File Placement, Number of Potential Applications
21(2)
SGA Issues
23(1)
Number of Users---Administrative, Developer, and Application
24(1)
Number and Placement of Control Files
25(1)
Number and Placement of Redo Logs
25(1)
Number and Placement of Rollback Segments
26(1)
Will the Tools Be Linked Single-task or Independent (Two-task)?
27(2)
Will This Database Be Shared between Multiple Instances?
29(1)
Will This Database Be Distributed?
29(2)
Installation Guidelines for VMS
31(16)
A Generic VMS Installation Procedure
32(9)
Installation of Oracle on UNIX
41(4)
Installation of Oracle on Windows NT 4.0
45(2)
Updating Oracle
47(12)
Migrating to Oracle8
47(1)
Prepare to Migrate
48(1)
Test the Migration Process
49(1)
Test the Migrated Test Instance
49(1)
Protect Your Retreat Path
49(1)
Take Flight! (or Fall Off the Cliff...): Migrate the Source Database
50(1)
The Three Ts: Tune, Tweak, and Test the New Database
50(1)
What Next?
50(1)
A Detailed Look at the MIG
50(3)
Pitfalls to Avoid
53(1)
Summary
54(1)
Problems with 8i Migration and Block Size
54(2)
Using the dbfmig Utility
56(3)
Administration of ORACLE (After the Bloom Is Off the Rose...)
59(78)
Generic Tools Available to All DBAs
61(5)
SQL: The Standard RDBMS Language
61(1)
SQL*Plus: An Oracle Extension to Standard SQL
62(1)
SVRMGR: A Database Administrator's Toolset
63(1)
Monitor
64(1)
Changes under Oracle8
64(1)
Operation of SVRMGR
64(1)
PL/SQL: Procedural-level Standard Query Language
65(1)
Administration of the Database
66(1)
The CREATE Command
66(1)
The STORAGE Clause
66(1)
Database Creation, Alteration, and Deletion
67(33)
Database Creation
67(9)
Alteration of Databases
76(2)
Re-creation of a Database
78(8)
Database Startup and Shutdown
86(1)
Startup
87(1)
Shutdown
88(2)
Killing Oracle User Processes
90(1)
Methods of Murder
90(1)
Killing from the Oracle Side
90(2)
Killing from the Operating System Side
92(2)
Database Deletion
94(1)
Changing the ``dbname'' for a Database
94(1)
Other Database Administration Tasks
95(1)
Addition of Log Groups and Log Member Files
95(2)
Dropping Log Files
97(1)
Addition of Rollback Segments
97(2)
Altering a Rollback Segment
99(1)
Dropping a Rollback Segment
99(1)
Moving Database Files
99(1)
Use of the ALTER SYSTEM Command
100(2)
ALTER SYSTEM Command Format
100(1)
A Detailed Look at ARCHIVE LOG Clauses
101(1)
The Init<sid>. Ora (Initialization File) Parameters
102(33)
The Undocumented Initialization Parameters (``*'')
114(12)
The Initialization File Event Settings
126(9)
Further DBA Reading
135(1)
Summary
136(1)
Tablespace Administration
137(30)
Tablespace Creation
137(3)
Keywords and Parameters
137(3)
Sizing of Tablespaces
140(1)
Alteration of Tablespaces
140(6)
Keywords and Parameters
141(5)
Deletion of Tablespaces
146(1)
Re-creating Tablespaces
146(4)
Periodic Tablespace Maintenance
150(17)
Consolidation of Extents
151(1)
Use of Export and Import
151(1)
Use of Events (pre-7.3) or Commands (7.3)
151(10)
Making a Tablespace Read Only
161(1)
Use of READ_ONLY_OPEN_DELAYED with Read-only Tablespaces
162(2)
Using Transportable Tablespaces
164(3)
Administration of Relational Database Tables
167(62)
The Concept of rowids in Oracle7 and Oracle8
167(1)
Oracle7 rowid Format
168(1)
Relational Table Administration
168(15)
Large Object Datatypes
170(1)
Creation of Relational Tables
171(1)
An Example of a Table Naming Convention
171(1)
An Example of the Creation of Simple Relational Tables
172(5)
Providing a Cascade Update Functionality
177(1)
Enforcing a Cascade Update
177(1)
The Cascade Update Procedures
178(4)
The Final Piece: The Trigger
182(1)
Deferred Constraints
183(45)
A Sample Constraint Naming Convention
184(1)
Example of Using LOB Datatypes in Relational Tables
185(5)
Example of the Creation of Partitioned Tables
190(1)
Using Subpartitioning
191(1)
Using Oracle8i Temporary Tables
192(2)
Creation of an Index-only Table
194(1)
Sizing an Oracle8 Nonclustered Table
195(1)
Calculate the Total Block Header Size
196(1)
Calculate the Available Data Space per Data Block
196(1)
Calculate the Space Used per Row
197(2)
Calculate the Total Number of Rows That Will Fit in a Data Block
199(1)
Calculate the Total Blocks Required
199(1)
The Oracle7 CREATE TABLE Command Format
199(4)
Oracle7 Table Sizing
203(1)
You Have a Test Database Available
203(3)
You Don't Have a Test Database
206(1)
Table Alteration
207(2)
Adding Columns
209(1)
Modifying Column Definitions
209(1)
Datatypes and Sizes
209(1)
Default Values
209(1)
Integrity Constraints
209(1)
Allocation of Extents
210(1)
LOB Columns
210(1)
Nested Table Columns
210(1)
Scoped REFs
210(1)
Modifying Table Partitions
210(6)
Altering a Table's Subpartitions
216(2)
Dropping Table Columns
218(1)
Table Statistics and Validity: The ANALYZE Command
219(1)
Collecting Statistics
220(1)
Deletion of a Table's Data
221(1)
The DELETE Command
221(2)
The TRUNCATE TABLE Command
223(1)
Dropping a Table
223(1)
Rebuilding Tables
223(5)
Summary
228(1)
Administration of Oracle8i Object Tables
229(40)
The rowid Concept in Oracle8i
229(1)
The Concept of Object Identifiers (OID) in Oracle8i
230(1)
Oracle8i Object Types
231(6)
The Incomplete Type
232(1)
The Varray Type
233(1)
The Nested Table Type
233(2)
Object Types
235(2)
Creation of Object Tables
237(1)
Object Table CREATE Command Definition
237(1)
Example of a Conversion from Oracle7 to Oracle8i
238(21)
A Concrete Example
238(20)
Summary
258(1)
Example of an Index-only Table
259(1)
Sizing an Oracle8 Nonclustered Table
260(8)
A Simple Example of Sizing
261(1)
Calculate the Total Block Header Size
261(1)
Calculate the Available Data Space per Data Block
261(1)
Calculate the Space Used per Row
262(2)
Calculate the Total Number of Rows That Will Fit into a Data Block
264(1)
Calculate the Total Blocks Required
264(1)
A More Complex Sizing Example
265(3)
Table Alteration and Truncation
268(1)
Summary
268(1)
Administration of Indexes
269(26)
Creation of Indexes
270(14)
B-tree and Indexes
271(1)
Indexes and Their Usage
271(2)
Use of Normal Unique and Nonunique Indexes
273(2)
Bitmapped Index Usage
275(2)
Single predicate on a low-cardinality attribute
277(1)
Single predicate on a high-cardinality attribute
277(1)
Multiple predicates on low-cardinality attributes
278(1)
Multiple predicates on both high-cardinality and low-cardinality attributes
278(1)
An Example of the Creation of a Partitioned Index
278(2)
Using Function-based Indexes
280(2)
Using Reverse Key Indexes
282(1)
Using DOMAIN Type Indexes
283(1)
Estimating an Index's Size
283(1)
Analyzing Indexes
284(2)
Alteration of Indexes
286(3)
Rebuilding Indexes
289(5)
Dropping Indexes
294(1)
The DROP INDEX Command
294(1)
Summary
294(1)
Administration of Other Database Objects
295(74)
Administration of Synonyms
295(2)
Creation of Synonyms
295(1)
Alteration of Synonyms
296(1)
Dropping Synonyms
296(1)
Re-creating Synonyms
296(1)
Administration of Sequences
297(7)
Creation of Sequences
297(4)
Alteration of Sequences
301(1)
Dropping a Sequence
301(1)
Use of Sequences
302(1)
Uses
302(1)
Restrictions
302(1)
Sequences and Import, Export, and SQLLOADER
302(1)
IMPORT Scenario
303(1)
Administration of Database Links
304(4)
Creation of Database Links
304(4)
Alteration of Database Links
308(1)
Dropping Database Links
308(1)
Administration of Views
308(8)
Creation of Views
308(2)
Partition Views
310(1)
Converting a Partition View into a Partitioned Table
311(1)
Object Views
312(1)
Example Views
313(2)
Alteration of Views
315(1)
Dropping Views
315(1)
Administration of Materialized View Logs in Oracle8i
316(1)
Creation of a Materialized View Log
316(1)
Altering a Materialized View Log
316(1)
Dropping a Materialized View Log
317(1)
Administration of Materialized Views (Snapshots) in Oracle8i
317(6)
Creating a Materialized View or Snapshot
318(3)
Altering a Materialized View or Snapshot
321(1)
Dropping a Materialized View
321(1)
Refreshing Materialized Views
321(1)
Snapshot Usage
322(1)
Administration of Triggers In Oracle8i
323(10)
Creation of Database Triggers
323(4)
Conditional Predicates
327(1)
LOB Trigger Limitations
327(1)
Triggers and Mutating Tables
327(1)
Use of Conditional Predicates
328(4)
Alteration of Triggers
332(1)
Dropping a Trigger
332(1)
Administration of Functions and Procedures
333(5)
Why Use Functions and Procedures?
333(1)
Creation of Functions and Procedures
334(1)
CREATE FUNCTION Command
334(1)
CREATE PROCEDURE Command
335(1)
Alteration of Procedures and Functions
336(1)
Dropping Procedures or Functions
337(1)
Administration of Packages
338(5)
Creation of Packages
339(2)
Creation of the Package Body
341(1)
Alteration of the Package
342(1)
Dropping a Package
343(1)
Administration of Schemas
343(1)
Creation of Schemas
343(1)
Administration of Library Objects
344(1)
Example of the Use of CREATE LIBRARY
344(1)
Altering Libraries
345(1)
Dropping a Library
345(1)
Administration of Directories
345(2)
Example of the Use of the CREATE DIRECTORY Command
346(1)
Altering Directories
346(1)
Dropping Oracle8 Directories
346(1)
Administration of the Java Objects
347(8)
Using LoadJava
347(2)
Examples
349(1)
Checking Upload Results
350(2)
Using DropJava
352(1)
Examples
353(1)
Using CREATE Java
353(1)
Creation of a Java Object
353(1)
Use of the Java Object
354(1)
Altering Java Objects
354(1)
Dropping Java Objects
355(1)
Memory and Java Objects
355(1)
Administration of the DIMENSION Objects
355(3)
Creation of DIMENSION Objects
355(2)
Altering DIMENSION Objects
357(1)
Dropping DIMENSIONS
357(1)
Administration of the OUTLINE Objects
358(2)
Creation of a OUTLINE objects
358(1)
Altering a OUTLINE
359(1)
Dropping an OUTLINE
360(1)
Administration of the CONTEXT Objects
360(2)
Creating a CONTEXT Objects
360(2)
Altering CONTEXT Objects
362(1)
Dropping CONTEXT Objects
362(1)
Administration of the OPERATOR Objects
362(3)
Creation of an OPERATOR Objects
362(2)
Altering OPERATOR Objects
364(1)
Dropping OPERATOR Objects
364(1)
The STORAGE Clause
365(1)
Definitions for the STORAGE Parameters
365(1)
The High-water Mark
366(1)
Further DBA Reading
366(1)
Summary
367(2)
Administration of Table Clusters
369(10)
Creation of Clusters
370(1)
Estimating Space Required by Clusters
371(5)
Calculate Total Block Header Size and Space Available for Table Data
372(1)
Calculate Space Required by a Row
372(1)
Calculate Total Average Row Size
373(1)
Calculate Average Cluster Block Size
374(1)
Calculate Total Number of Blocks
375(1)
Space Requirements for Clustered Tables in Use
375(1)
Estimating Space Required by HASH Clusters
376(1)
Alteration of Clusters
376(1)
Dropping a Cluster
377(1)
Declustering Tables
377(1)
Summary
378(1)
User and Security Administration
379(80)
Administration of Users
379(5)
Creating Users
379(4)
Altering Users
383(1)
Dropping Users
383(1)
Administration of Security
384(13)
User Grants and Privileges
384(1)
System Privileges
385(7)
Object Privileges
392(3)
Column Privileges
395(1)
Revoking Grants
396(1)
Use of Roles
397(12)
Creating Roles
397(1)
Grants to Roles
398(2)
Setting Roles
400(1)
Special Roles
401(1)
OSOPER and OSDBA
401(1)
Internal Roles in Oracle8 and Oracle8i
402(7)
Auditing the Database
409(15)
Enabling and Disabling Auditing
410(3)
Using Statement Auditing
413(1)
Using Privilege Auditing
413(1)
Using Object Auditing
414(1)
Managing the Audit Trail
414(2)
Viewing Audit Trail Information
416(7)
Auditing by Database Triggers
423(1)
Managing Resources with Profiles
424(10)
Creation of Profiles
424(2)
Profiles and Resource Limits
426(2)
Altering Profiles
428(1)
Profiles and Passwords
429(5)
Oracle Resource Groups
434(17)
Creating a Resource Plan
434(7)
DBMS_RESOURCE_MANAGER Package
441(1)
DBMS_RESOURCE_MANAGER Procedure Syntax
442(6)
DBMS_RESOURCE_MANAGER_PRIVS Package
448(1)
DBMS_RESOURCE_MANAGER_PRIVS Procedure Syntax
449(2)
Managing Row Level Access
451(7)
Policy Usage
455(1)
DBMS_RLS Package
456(2)
Further DBA Reading
458(1)
Summary
458(1)
Monitoring Database Tables, Indexes, Clusters, Snapshots, and Objects
459(86)
Using the Oracle8 and Oracle8i Data Dictionary
460(1)
Using the Views and Dynamic Performance Tables to Monitor Tables, Clusters, Snapshots, Types, and Indexes
461(63)
Monitoring Tables with the V$ and DBA_Views
461(1)
Monitoring Ownership, Placement, and Clustering
462(3)
Monitoring Size of Tables
465(5)
Monitoring Table Statistics
470(3)
Monitoring Table Types (Partition, Nested, IOT)
473(4)
Monitoring Table Columns
477(19)
Monitoring Table Column Statistics
496(2)
Monitoring Table Subpartions
498(1)
Monitoring Subpartition Statistics
499(2)
Monitoring Nested Tables
501(2)
Using the V$ and DB_Views for Monitoring Indexes
503(3)
Monitoring Index Statistics
506(4)
Monitoring Partitioned Indexes
510(4)
Monitoring Functional Indexes
514(2)
Monitoring Domain Indexes
516(1)
Monitoring Clusters Using DBA_and V_$ Views
516(3)
Monitoring Cluster Storage Statistics
519(1)
Monitoring Cluster Statistics
520(2)
Monitoring Cluster Hash Expressions
522(1)
Monitoring of Snapshots and Snapshot Logs (Materialized Views) Using DBA_and V Type Views
522(2)
Monitoring Oracle8 Types, Collections, Methods, and Operators
524(18)
Monitoring Types
525(3)
Monitoring Type Collections
528(1)
Monitoring Type Methods
529(1)
Monitoring Type REFs
530(2)
Monitoring Operators
532(1)
Monitoring Dimensions
533(5)
Monitoring Outlines
538(2)
Monitoring Outline Hints
540(2)
Further DBA Reading
542(1)
Summary
543(2)
Monitoring Users and Other Database Objects
545(74)
Using the V$ and DBA Views for Monitoring Users
545(25)
Monitoring User Setup
546(7)
Monitoring User Roles
553(1)
Monitoring User Profiles
554(2)
Monitoring User Consumer Groups and Plans
556(7)
Monitoring User Table and Column Grants
563(5)
Monitoring Currently Logged-in User Processes
568(2)
Using the V$ and DB_Views to Monitor Tablespaces
570(9)
Monitoring Tablespace Free Space and Fragmentation
570(4)
Monitoring Tablespace Autoextend Settings
574(1)
Monitoring Tablespace Data Files
575(3)
Monitoring Tablespace Extent Mapping
578(1)
Using the V$ and DB_Views for Monitoring Sequences
579(3)
Monitoring Synonyms Using the V$ and DBA_ Views
582(1)
Monitoring Database Links Using V$ and DBA_ Views
583(2)
Monitoring Database Rollback Segments Using V$ and DBA_Views
585(16)
Monitoring Rollback Usage and Statistics
585(3)
Monitoring Rollback Current Usage
588(2)
Monitoring Rollback Transaction Size
590(1)
Monitoring Deferred Rollback Segments
591(1)
Monitoring Redo Activity with V$ and DBA_ Views
592(1)
Monitoring Redo Log Status
592(2)
Monitoring Redo Log Switches
594(1)
Monitoring Redo Statistics
595(4)
Monitoring Directories and Libraries
599(1)
Monitoring Directories
599(1)
Monitoring Libraries
600(1)
Monitoring Control Files and Initialization Parameters
601(7)
Monitoring Control Files
602(2)
Monitoring Database Initialization Parameters
604(2)
Monitoring Undocumented Initialization Parameters
606(2)
Monitoring Locks and Latches
608(5)
Monitoring Sessions Waiting for Locks
608(1)
Monitoring Sessions Causing Blocked Locks
609(1)
Monitoring DDL and DML Locks
610(2)
Monitoring Internal Locks
612(1)
Monitoring Events
613(2)
Monitoring Other Database Objects
615(2)
Monitoring for Invalid Objects
615(2)
Monitoring Multiple Databases
617(1)
Summary
618(1)
Tuning Oracle Applications
619(64)
Benefits of Application Tuning
619(1)
Parts of the Process
620(2)
Phase 1
620(1)
Phase 2
621(1)
Phase 3
621(1)
Tuning Steps
622(36)
Proper Specification of System or Business Rules
622(1)
Proper Logical Design
623(1)
Normalization
623(1)
Denormalization
623(1)
Functional Mapping
624(1)
Proper Physical Design
624(1)
Sizing
624(1)
Use of a Test Database
625(1)
Key Sizing Parameters
626(1)
Table Placement
626(1)
Table Striping
627(2)
Tuning of Application Query Statements
629(1)
Use of tkprof to Tune Statements
629(7)
Use of tkprof
636(2)
The EXPLAIN option of tkprof
638(1)
Tkprof Statistics
639(1)
Tkprof Sample Tuning Session
639(15)
Oracle7 and Oracle8 Optimizers and ANALYZE
654(4)
Other Application Tuning Tips
658(9)
Use of Standalone EXPLAIN PLAN
658(5)
Use of the UTLSIDXS Utility
663(4)
Using Hints in Oracle7 and Oracle8 to Force Behavior
667(2)
Tuning Rollback Segments
669(8)
Snapshot Too Old
673(4)
Redo Log Tuning
677(3)
Redo Log Sizing
677(3)
Further DBA Reading
680(1)
Summary
681(2)
Database Internals Tuning
683(92)
Steps to Internals Tuning
683(2)
The UTLBSTAT and UTLESTAT Scripts and Their Use
685(14)
Use of UTLESTAT/UTLBSTAT
685(1)
The UTLBSTAT/UTLESTAT Script Reports
685(14)
Other Tools for Internals Tuning
699(69)
Tools for Tuning Memory Contention
699(1)
Tuning the Shared Pool
700(2)
Advanced Tuning of the Shared Pool
702(17)
Large Pool Sizing
719(2)
A Matter of Hashing
721(3)
Disk I / O and the Shared Pool
724(2)
Monitoring Library and Data Dictionary Caches
726(3)
In Summary
729(1)
Tuning the BUFFER CACHE
730(1)
Classic DB Block Buffer Tuning
730(12)
Tuning the Multipart Oracle8 Buffer Cache
742(2)
Tools for Tuning I / O Contention
744(20)
Tools for Additional Tuning Concerns
764(1)
Sorts, Free Lists, Checkpoints, and Processes
764(1)
Tuning Oracle Sorts
764(2)
Reducing Free List Contention
766(1)
Tuning Checkpoints
767(1)
Tuning LGWR
767(1)
Tuning DBWR
768(1)
New Oracle Tuning Options
768(6)
Use of Histograms
768(1)
New Types of Joins
769(1)
Multitier Statement Tuning
770(1)
Push Processing to the Server, Pull Results Back
770(1)
Using Views
770(1)
Using PL / SQL Encapsulation
771(1)
Using Views to Prebuild Queries
772(1)
Use of MTS
772(1)
Use PL / SQL Blocks, Procedures, and Functions on Both the Server and Client
773(1)
Further DBA Reading
774(1)
Summary
774(1)
Managing in a Distributed Environment
775(52)
Management in a ``Shared'' Environment
775(8)
Initialization Parameters for a Shared Database
776(1)
Initialization Parameters That Must Match in All Shared Instances
776(5)
Initialization Parameters That Must Be Different
781(1)
Initialization Parameters That Can Be the Same or Different
781(1)
New Oracle8 Parameters
782(1)
Use of SQLDBA or SVRMGR
783(1)
Basic Procedure for Creating a Shared Oracle Database
784(3)
Porting an Existing System to Parallel Server
787(17)
Other Options
787(1)
Standby Database
787(1)
Master-Master Replication
788(1)
Full Database Copy
788(1)
Parallel Server
788(1)
Benefits of Parallel Server
789(1)
Problems with Parallel Server
790(1)
The Application to Be Ported
791(2)
Application Activities
793(1)
Requirements for Parallel Server: How Does the Application Measure Up?
794(2)
Steps to Convert to Parallel Server
796(1)
A Closer Look at These Easy Steps
796(1)
Porting the Example Application
797(4)
Determining Lock Granularity
801(2)
Setting Other GC_* Parameters
803(1)
A Note on Free Lists
803(1)
Defining the Initialization Files
803(1)
Adding Redo Threads and Rollback Segments
804(1)
Starting Up the Other Instances
804(1)
References
804(1)
Distributed Database Management
804(8)
Use of SQL*NET and NET8
806(2)
Use of the COPY Command
808(1)
Use of SQL*NET/TCP/IP
808(4)
Distributed Database Initialization Parameters
812(1)
Oracle Data Replication Features
812(5)
The Use of Two-phase Commit
813(1)
What Is a Two-phase Commit?
813(2)
Examples of a Distributed Transaction
815(2)
Client/Server Relational Databases
817(1)
Benefits of Client/Server
817(1)
Replication and Advanced Replication
818(1)
Use of the Multithreaded Server
818(7)
MTS_DISPATCHERS
820(1)
Setting the Initial Number of Dispatcher Processes
820(1)
Modifying Server Processes
821(1)
Adding and Removing Dispatcher Processes
822(1)
Connecting to the Multithreaded Server
822(1)
Monitoring Average Wait Time
823(1)
Increasing the Number of Servers/Dispatchers
824(1)
Additional DBA Reading
825(1)
Summary
826(1)
Backup and Recovery Procedures for Oracle
827(98)
Backups
827(33)
Cold Backups
828(2)
Hot Backups
830(28)
Example of Documentation Procedure for NT On-line Backup and Recovery Scripts
858(1)
Backup
859(1)
Recovery
859(1)
Imports/Exports
860(3)
EXPORT
861(1)
IMPORT
862(1)
Archive Logs
863(1)
Backup Methodologies
864(3)
VMS or UNIX System Backup
865(1)
Import/Export
865(1)
Archive Logging
866(1)
Recovery Types
866(1)
A Sample Set of Recovery Procedures
867(2)
Disk Setup Information
867(1)
General Discussion
867(2)
Detailed Procedures
869(34)
Recovery of the Full Database Using Export Files
869(19)
Procedure for Recovery Using Hot or Cold Backups
888(1)
Procedures for Recovery from Individual Disk (or Array) Lost
888(15)
Oracle7 Enterprise Backup Utility
903(3)
Registering a DB in EBU
904(1)
Restoration of Databases Using EBU
905(1)
Oracle8 Recovery Manager Facility
906(6)
Installing the RMAN Catalog
908(2)
Incomplete Restore Scenario
910(2)
BD_VERIFY Utility
912(1)
The DBMS_REPAIR Utility
913(10)
DBMS_REPAIR Enumeration Types
914(1)
DBMS_REPAIR Exceptions
914(1)
DBMS_REPAIR Procedures
915(1)
ADMIN_TABLES
915(3)
CHECK_OBJECT
918(2)
DUMP_ORPHAN_KEYS
920(1)
FIX_CORRUPT_BLOCKS
920(1)
REBUILD_FREELISTS
921(1)
SKIP_CORRUPT_BLOCKS
922(1)
DBA Suggested Reading
923(1)
Summary
923(2)
What's on the CD-ROM 925(42)
Index 967

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.