Oracle9i Database Administrator II: Backup/Recovery and Network Administration

by Morris-Murphy, Lannes

• ISBN13: 9780619159023
• ISBN10: 0619159022
• Edition: 1st
• Format: Paperback
• Copyright: 2003-10-03
• Publisher: Course Technology

Summary

Drills down key tools and techniques for Oracle database backup, recovery and network administration and prepares readers for passing the Oracle certification exam #1Z0-032.

Table of Contents

Preface	xv
Backup and Recovery Overview	1	(22)
The Current Challenge in the Janice Credit Union Database	2	(1)
Oracle9i Database	2	(5)
Physical Structure	2	(2)
Logical Structure	4	(2)
Relationships Between the Physical and Logical Structures	6	(1)
Oracle9i Instances	7	(3)
Background Processes	7	(2)
Memory Structures	9	(1)
Initialization File (Init.ora)	10	(1)
Backup and Recovery	11	(5)
Key Elements in Backup and Recovery	12	(1)
Tuning Instance Recovery	12	(2)
Types of Failure	14	(1)
Backup and Recovery Strategy Factors	15	(1)
Testing a Strategy	15	(1)
Chapter Summary	16	(1)
Syntax Guide	17	(1)
Review Questions	17	(2)
Hands-on Assignments	19	(2)
Assignment 1-1 Determine the Size of a Tablespace	19	(1)
Assignment 1-2 Determine the Location of Files	20	(1)
Assignment 1-3 Work with Control Files	20	(1)
Assignment 1-4 Work with the Show Parameters Command	20	(1)
Assignment 1-5 Find the Value of a Parameter	21	(1)
Assignment 1-6 Change a Parameter	21	(1)
Case Projects	21	(2)
Case 1-1 Create a pfile	21	(1)
Case 1-2 Format a pfile	21	(2)
Archiving	23	(48)
The Current Challenge in the Janice Credit Union Database	24	(1)
Notes About Dual Coverage Within this Chapter	24	(1)
NoarChivelog Mode	24	(6)
Advantages and Disadvantages of Noarchivelog Mode	25	(1)
Verifying Archive Mode	26	(1)
Verification Through SQL*Plus	27	(3)
Archivelog Mode	30	(27)
How Many Redo Log Files Do You Need?	32	(1)
Advantages and Disadvantages of Archivelog Mode	32	(1)
Changing Archive Mode	33	(10)
Manual Archiving	43	(7)
Automatic Archiving	50	(7)
Archiving Parameters	57	(5)
Destination Parameters	58	(1)
Log_Archive_Dest_N Parameter	59	(1)
Destination Availability	59	(2)
Filename Parameter	61	(1)
Chapter Summary	62	(1)
Syntax Guide	63	(1)
Review Questions	64	(3)
Hands-on Assignments	67	(3)
Assignment 2-1 Performing Manual Archiving with SQL *Plus	67	(1)
Assignment 2-2 Enabling Automatic Archiving Through SQL *Plus	68	(1)
Assignment 2-3 Placing a Database in Noarchivelog Mode Through SQL *Plus	68	(1)
Assignment 2-4 Placing a Database in Archivelog Mode Using the Enterprise Manager Console	68	(1)
Assignment 2-5 Enabling Automatic Archiving Using the Enterprise Manager Console	69	(1)
Assignment 2-6 Changing a Database to Noarchivelog Mode Using the Enterprise Manager Console	69	(1)
Assignment 2-7 Enabling Automatic Archiving for the Current Instance Using the Enterprise Manager Console	69	(1)
Assignment 2-8 Modifying the Initialization File	69	(1)
Case Projects	70	(1)
Case 2-1 Determining Which Mode to Use	70	(1)
Case 2-2 Adding Steps to the Manual	70	(1)
User-Managed Backups	71	(26)
The Current Challenge in the Janice Credit Union Database	72	(1)
Set Up Your Computer for the Chapter	72	(1)
Notes About Dual Coverage Within this Chapter	72	(1)
Performing a Cold Backup of a Closed Database	73	(4)
Locating the Database Data Files	73	(1)
Performing a Cold Backup	74	(3)
Hot Backup of an Open Database	77	(6)
Special Considerations for Backing Up a Tablespace	78	(1)
Performing a Hot Backup	79	(4)
Control File Backups	83	(2)
Using DBVERIFY to Analyze Data Blocks	85	(3)
Chapter Summary	88	(1)
Syntax Guide	88	(1)
Review Questions	89	(3)
Hands-on Assignments	92	(2)
Assignment 3-1 Determining Backup Mode	92	(1)
Assignment 3-2 Locating Database Files	92	(1)
Assignment 3-3 Creating a Cold Backup of a Closed Database	92	(1)
Assignment 3-4 Creating a Script File to Perform a Cold Backup of a Whole Database	93	(1)
Assignment 3-5 Executing a Script File to Perform a Cold Backup of a Whole Database	93	(1)
Assignment 3-6 Identifying Tablespaces and Associated Data Files	93	(1)
Assignment 3-7 Backing Up a Tablespace From an Open Database	94	(1)
Assignment 3-8 Verifying Data Block Integrity with DBVERIFY	94	(1)
Case Projects	94	(3)
Case 3-1 Scripts Used to Back Up Databases	94	(1)
Case 3-2 Procedures Used with Backups	95	(2)
User-Managed Complete Recovery	97	(34)
The Current Challenge in the Janice Credit Union Database	98	(1)
Set Up Your Computer for the Chapter	98	(1)
Notes About Dual Coverage in This Chapter	98	(1)
Database Recovery	98	(1)
Noarchivelog Recovery	99	(6)
Data Loss	99	(1)
Restoring All Files	100	(1)
The Janice Credit Union Database	100	(5)
Archivelog Recovery	105	(1)
Recovering the System Tablespace for an Archivelog Database	105	(6)
Opening the Database Before Recovery	111	(3)
Moving or Renaming Data Files	114	(2)
Recovering a Control File	116	(6)
Steps to Recover the Control File with a Mirrored Copy	116	(1)
Steps to Recreate A Control File	117	(5)
Recovering a Read-Only Tablespace	122	(1)
Chapter Summary	122	(1)
Syntax Guide	123	(1)
Review Questions	124	(2)
Hands-on Assignments	126	(3)
Assignment 4-1 Changing the Location of a Tablespace	126	(1)
Assignment 4-2 Restoring a Data File for a Database in Noarchivelog Mode	126	(1)
Assignment 4-3 Recovering a Data File for a Database in Archivelog Mode	126	(1)
Assignment 4-4 Recovering a Read-Only Tablespace	127	(1)
Assignment 4-5 Restore a Control File Using a Mirrored Copy	127	(1)
Assignment 4-6 Recreating a Control File from a Trace File	128	(1)
Assignment 4-7 Recovering a Read-Only Tablespace for a Noarchivelog Mode Database	128	(1)
Assignment 4-8 Restoring a Control File for a Noarchivelog Mode Database	129	(1)
Case Projects	129	(2)
Case 4-1 Accessing a Database	129	(1)
Case 4-2 Modifying the Procedure Manual	130	(1)
User-Managed Incomplete Recovery	131	(32)
The Current Challenge in the Janice Credit Union Database	132	(1)
Set Up Your Computer for the Chapter	132	(1)
Notes About Dual Coverage Within the Chapter	132	(1)
Incomplete Recovery	133	(4)
Options for an Incomplete Recovery	133	(2)
Finding the SCN	135	(1)
Steps During an Incomplete Recovery	136	(1)
Cancel-Based Recovery	137	(2)
Time-Based Recovery	139	(3)
Change-Based Recovery	142	(11)
LogMiner	144	(8)
Performing a Change-Based Recovery	152	(1)
Chapter Summary	153	(1)
Syntax Guide	154	(1)
Review Questions	155	(2)
Hands-on Assignments	157	(4)
Assignment 5-1 Determining the SCN Range of the Online Redo Log Files	157	(1)
Assignment 5-2 Performing a Change-Based Recovery	157	(1)
Assignment 5-3 Performing a Cancel-Based Recovery	158	(1)
Assignment 5-4 Performing a Time-Based Recovery	158	(1)
Assignment 5-5 Using LogMiner to Identify a Specific DML Operation	159	(1)
Assignment 5-6 Using Results of a LogMiner Session to Undo a DML Operation	159	(1)
Assignment 5-7 Using LogMiner to Locate DDL Operations	160	(1)
Assignment 5-8 Performing a Change-Based Recovery Based on an SCN Obtained through LogMiner	160	(1)
Case Projects	161	(2)
Case 5-1 Table Does Not Exist	161	(1)
Case 5-2 Identify Recovery Steps	161	(2)
Overview of Recovery Manager	163	(20)
The Current Challenge in the Janice Credit Union Database	164	(1)
Set Up Your Computer for the Chapter	164	(1)
Notes about Dual Coverage in this Chapter	164	(1)
Rman Features	165	(1)
Rman Components	165	(2)
Rman Executable	167	(5)
Starting Rman Without Specifying Parameters	168	(2)
Starting Rman Parameters	170	(2)
Rman Repository	172	(2)
Control File	173	(1)
Recovery Catalog	174	(1)
Channel Allocation	174	(1)
Chapter Summary	175	(1)
Syntax Guide	176	(1)
Review Questions	177	(2)
Hands-on Assignments	179	(2)
Assignment 6-1 Opening Rman Without Initial Target Database Connection	179	(1)
Assignment 6-2 Displaying Rman Configuration Settings	179	(1)
Assignment 6-3 Clearing Rman Configuration Settings	180	(1)
Assignment 6-4 Determining Rman Repository Location	180	(1)
Assignment 6-5 Automating Backup of Target Database Control File	180	(1)
Assignment 6-6 Specifying the Number of Copies for the Control File and Data Files	180	(1)
Case Projects	181	(2)
Case 6-1 Recovery Manager, User-Managed Operations	181	(1)
Case 6-2 Automating Rman Access	181	(2)
Performing Backup Operations with Recovery Manager	183	(38)
The Current Challenge in the Janice Credit Union Database	184	(1)
Set Up Your Computer for the Chapter	184	(1)
Notes About Dual Coverage Within this Chapter	184	(1)
Basic Rman Backup Features	185	(1)
Backing Up Only Changed Data Blocks	185	(1)
Backup Levels	185	(1)
Report Command	186	(2)
Command to Back Up a Tablespace	188	(15)
Rman Command Types	189	(1)
Allocate Command	189	(1)
Backup Command	190	(2)
Performing a Full Backup of a Tablespace with Rman---the Command-Line Approach	192	(2)
Performing a Full Backup of a Tablespace with Rman---the Enterprise Manager Approach	194	(9)
Incremental Backup	203	(6)
Recovery Implications of Incremental Backup Procedures for Janice Credit Union	205	(1)
The Use of the SCN in Incremental Backups	205	(1)
The Backup Command in Action---the Command-Line Approach	206	(1)
The Backup Command in Action---the GUI Approach	207	(2)
Creating Image Copies Using the Copy Command	209	(2)
Chapter Summary	211	(1)
Syntax Guide	212	(2)
Review Questions	214	(2)
Hands-on Assignments	216	(3)
Assignment 7-1 Identifying Data Files and Tablespaces	217	(1)
Assignment 7-2 Identifying Datafiles Meeting Specific Backup Criteria	217	(1)
Assignment 7-3 Creating a Level 0 Backup of a Data File	217	(1)
Assignment 7-4 Creating a Level 0 Backup of a Database	217	(1)
Assignment 7-5 Creating a Level 2 Differential Backup of a Database	218	(1)
Assignment 7-6 Creating a Level 2 Cumulative Backup	218	(1)
Assignment 7-7 Creating a Full Backup of a Database	218	(1)
Assignment 7-8 Creating a Full Backup of the System Tablespace	218	(1)
Assignment 7-9 Creating a Full Backup of all Archived Redo Log Files	218	(1)
Assignment 7-10 Creating an Image Copy of a Control File	219	(1)
Case Projects	219	(2)
Case 7-1 Developing a Backup Strategy	219	(1)
Case 7-2 Procedure Manual	219	(2)
Complete Recovery with Recovery Manager	221	(38)
The Current Challenge in the Janice Credit Union Database	222	(1)
Set Up Your Computer for the Chapter	222	(1)
Notes About Dual Coverage Within this Chapter	222	(1)
Basic Recovery Steps with Rman	223	(1)
Why Using Rman Is the Preferred Backup Method	223	(1)
Recovery of a Database in Noarchivelog Mode	224	(15)
Backing up a Noarchivelog Mode Database---Command-Line Approach	224	(3)
Restoring a Noarchivelog Mode Database---Command-Line Approach	227	(2)
Backing Up a Database in Noarchivelog Mode---GUI Approach	229	(5)
Restoring a Database in Noarchivelog Mode---GUI Approach	234	(5)
Recovering a Database in Archivelog Mode	239	(4)
Backing up an Archivelog Mode Database	240	(1)
Recovering a Database in Archivelog Mode---Command-Line Approach	241	(2)
Recovering a Database in Archivelog Mode---GUI Approach	243	(3)
Moving Data Files to a New Location	246	(5)
Moving Data Files---Command-Line Approach	247	(2)
Moving Data Files---GUI Approach	249	(2)
Chapter Summary	251	(1)
Syntax Guide	252	(1)
Review Questions	252	(2)
Hands-on Assignments	254	(2)
Assignment 8-1 Backing Up an Archivelog Database Using Multiple Channels	254	(1)
Assignment 8-2 Recovering an Archivelog Database Using Two Channels	254	(1)
Assignment 8-3 Recovering a Tablespace for an Archivelog Database	255	(1)
Assignment 8-4 Recovering a Database After Media Failure	255	(1)
Assignment 8-5 Recovering a Noarchivelog Database	256	(1)
Assignment 8-6 Moving a Data File Through Rman	256	(1)
Case Projects	256	(3)
Case 8-1 Recovery Strategy	256	(1)
Case 8-2 Procedure Manual	257	(2)
Incomplete Recovery with Recovery Manager	259	(40)
The Current Challenge in the Janice Credit Union Database	260	(1)
Set Up Your Computer for the Chapter	260	(1)
Notes About Dual Coverage Within this Chapter	260	(1)
Incomplete Recovery	261	(1)
Time-Based Incomplete Recovery	262	(14)
Performing a Time-Based Incomplete Recovery---the Command-Line Approach	263	(6)
Performing a Time-Based Incomplete Recovery---the GUI Approach	269	(7)
Sequence-Based Incomplete Recovery	276	(5)
Performing a Sequence-Based Incomplete Recovery---the Command-Line Approach	277	(3)
Performing a Sequence-Based Incomplete Recovery---a GUI Approach	280	(1)
Change-Based Incomplete Recovery	281	(8)
Performing a Change-Based Incomplete Recovery---a Command-Line Approach	281	(3)
Performing a Change-Based Incomplete Recovery---the GUI Approach	284	(5)
Chapter Summary	289	(1)
Syntax Guide	290	(1)
Review Questions	290	(2)
Hands-on Assignments	292	(5)
Assignment 9-1 Performing a Time-Based Recovery Through Rman	292	(1)
Assignment 9-2 Identifying the Current Online Redo Log File	293	(1)
Assignment 9-3 Performing a Sequence-Based Recovery After a User Error Occurs	293	(1)
Assignment 9-4 Performing a Sequence-Based Recovery After a Redo Log File Is Lost	294	(1)
Assignment 9-5 Using LogMiner to Determine the Time for DML Operations	295	(1)
Assignment 9-6 Using LogMiner to Determine the Time for DDL Operations	295	(1)
Assignment 9-7 Performing an Incomplete Recovery Based on a Time Value Obtained Through LogMiner	296	(1)
Assignment 9-8 Performing an Incomplete Recovery Based on an SCN Obtained Through LogMiner	296	(1)
Case Projects	297	(2)
Case 9-1 Determining a Recovery Strategy	297	(1)
Case 9-2 Creating an Incomplete Recovery Procedure List	297	(2)
Recovery Manager Maintenance	299	(22)
The Current Challenge in the Janice Credit Union Database	300	(1)
Set Up Your Computer for the Chapter	300	(1)
Notes About Dual Coverage Within this Chapter	300	(1)
Maintaining Backup Set and Image Copy References	300	(6)
Cross-Checking Backup Sets and Image Copies	301	(1)
Deleting Repository References	302	(1)
Changing the Status of Backup Sets and Image Copies	303	(3)
Adding Operating System Backups to the Repository	306	(1)
Defining a Retention Policy	307	(6)
Changing Rman Retention Policy: A Command-Line Approach	308	(1)
Changing Rman Retention Policy: A GUI Approach	309	(4)
Chapter Summary	313	(1)
Syntax Guide	314	(1)
Review Questions	315	(1)
Hands-on Assignments	316	(2)
Assignment 10-1 Listing the Current Status of a Backup Set	316	(1)
Assignment 10-2 Performing a Cross-Check of a Backup Set	317	(1)
Assignment 10-3 Adding a File Copied by the Operating System to the Rman Repository	317	(1)
Assignment 10-4 Changing the Status of an Image Copy	317	(1)
Assignment 10-5 Deleting Information from the Rman Repository	318	(1)
Assignment 10-6 Specifying a Retention Policy in Rman	318	(1)
Case Projects	318	(3)
Case 10-1 User-Managed Processes Versus Recovery Manager	318	(1)
Case 10-2 Procedure Manual	319	(2)
Recovery Catalog	321	(34)
The Current Challenge at Janice Credit Union	322	(1)
Set Up Your Computer for the Chapter	322	(1)
Notes About Dual Coverage in this Chapter	322	(1)
Creating the Recovery Catalog and Registering the Database	322	(11)
Using the Command-Line Approach to Create the Recovery Catalog and Register a Target Database	323	(3)
Using the GUI Approach to Create the Recovery Catalog and Register a Target Database	326	(7)
Creating and Executing an Rman Script	333	(5)
Creating and Executing an Rman Script---Command-Line Approach	333	(2)
Creating and Executing an Rman Script---GUI Approach	335	(3)
Updating the Recovery Catalog	338	(4)
Resynchronizing the Recovery Catalog	338	(1)
Resynchronizing the Recovery Catalog---Command-Line Approach	339	(1)
Resynchronizing the Recovery Catalog---GUI Approach	339	(3)
Resetting the Recovery Catalog	342	(6)
Resetting the Recovery Catalog---Command-Line Approach	343	(1)
Resetting the Recovery Catalog---GUI Approach	344	(1)
Viewing the Contents of the Recovery Catalog	345	(2)
Backup and Recovery of the Recovery Catalog Database	347	(1)
Chapter Summary	348	(1)
Syntax Guide	349	(1)
Review Questions	350	(2)
Hands-on Assignments	352	(2)
Assignment 11-1 Creating and Storing an Rman Script	352	(1)
Assignment 11-2 Executing a Stored Rman Script	352	(1)
Assignment 11-3 Changing the Incarnation of the Target Database	352	(1)
Assignment 11-4 Resynchronizing the Recovery Catalog	353	(1)
Assignment 11-5 Viewing a Previous Incarnation	353	(1)
Assignment 11-6 Viewing the Contents of a Stored Script	353	(1)
Case Projects	354	(1)
Case 11-1 Developing Rman Backup Scripts	354	(1)
Case 11-2 Procedure Manual	354	(1)
Loading and Transporting Data	355	(48)
The Current Challenge in the Janice Credit Union Database	356	(1)
Set Up Your Computer for the Chapter	356	(1)
Notes About Dual Coverage Within this Chapter	357	(1)
The Export Utility	357	(12)
Exporting Data	358	(1)
Using the Export Utility---Command-Line Approach	359	(6)
Using the Export Utility---GUI Approach	365	(4)
The Import Utility	369	(13)
Using the Import Utility---Command-Line Approach	371	(5)
Using the Import Utility---GUI Approach	376	(6)
Backup and Recovery of the Recovery Catalog	382	(1)
SQL *Loader	383	(4)
The Control File	383	(1)
The Input File	383	(1)
The Log Files	383	(4)
Loading Methods	387	(8)
Loading Data with SQL *Loader---Command-Line Approach	388	(3)
Loading Data with SQL *Loader---GUI Approach	391	(4)
Chapter Summary	395	(1)
Syntax Guide	396	(1)
Review Questions	396	(2)
Hands-on Assignments	398	(3)
Assignment 12-1 Interactively Exporting Data Using the Direct-Path Approach	398	(1)
Assignment 12-2 Interactively Importing Data Using the Direct-Path Approach	399	(1)
Assignment 12-3 Using a Parameter File to Export Data Using the Export Utility	399	(1)
Assignment 12-4 Using a Parameter File to Import Data	399	(1)
Assignment 12-5 Correcting Data Load Errors	400	(1)
Assignment 12-6 Replacing Data Using SQL *Loader	400	(1)
Case Projects	401	(2)
Case 12-1 Developing a Logical and Physical Backup Strategy for the Recovery Catalog	401	(1)
Case 12-2 Procedure Manual	401	(2)
Network Administration and Server-Side Configuration	403	(34)
The Current Challenge in the Janice Credit Union Database	404	(1)
Set Up Your Computer for the Chapter	404	(1)
Notes About Dual Coverage Within this Chapter	404	(1)
Networking Overview	405	(1)
Layered Architecture	406	(3)
Single-Tier Architecture	406	(1)
Two-Tier Architecture	407	(1)
N-Tier Architecture	408	(1)
Architecture Implementation	409	(1)
Oracle Net Services	409	(2)
Oracle Net	409	(1)
Oracle Net Listener	409	(1)
Oracle Connection Manager	410	(1)
Networking Tools	411	(1)
Oracle Advanced Security	411	(1)
Data Encryption	412	(1)
User Authentication	412	(1)
Single Sign-On	412	(1)
Communication Architecture	412	(3)
Oracle Communications Stack	412	(1)
Client Requests and the Oracle Communications Stack	413	(2)
Server Configuration	415	(1)
Listener Configuration	415	(2)
The Listener.ora File	416	(1)
The Sid_List_Listener Section of Listener.ora	417	(1)
Configuring a Listener Through Net Manager	417	(3)
Making Changes to an Existing Listener with Net Manager	420	(1)
Controlling the Listener Through the Listener Control Utility	421	(7)
Listener Operation Controls	422	(2)
Parameter Changes Through the Listener Control Utility	424	(3)
Deleting a Listener	427	(1)
Dynamic Registration of Services	428	(1)
Chapter Summary	429	(1)
Syntax Guide	430	(1)
Review Questions	430	(2)
Hands-on Assignments	432	(2)
Assignment 13-1 Creating a Listener	432	(1)
Assignment 13-2 Stopping and Starting a Listener	432	(1)
Assignment 13-3 Changing the Configuration of a Listener	433	(1)
Assignment 13-4 Enabling Logging Through the Listener Control Utility	433	(1)
Assignment 13-5 Changing the Logging Status Using Net Manager	433	(1)
Assignment 13-6 Deleting a Listener	434	(1)
Case Projects	434	(3)
Case 13-1 Identifying Appropriate Network Architecture	434	(1)
Case 13-2 Increasing Security	435	(2)
Client-Side Configuration	437	(26)
The Current Challenge in the Janice Credit Union Database	438	(1)
Set Up Your Computer for the Chapter	438	(1)
Notes About Dual Coverage Within this Chapter	438	(1)
Name Resolution Methods	438	(3)
Host Naming	439	(1)
Directory Naming	440	(1)
Local Naming	440	(1)
Name Resolution Order	441	(4)
Sqlnet.ora File Contents	441	(1)
Modifying the Sqlnet.ora File	442	(3)
Configuring the Client for Local Naming	445	(6)
Modifying a Tnsnames.ora File	445	(4)
Tnsnames.ora File Syntax	449	(2)
Configuring the Client to Use Host Naming	451	(1)
Troubleshooting a Database Network Connection	452	(3)
Chapter Summary	455	(1)
Syntax Guide	456	(1)
Review Questions	456	(2)
Hands-on Assignments	458	(3)
Assignment 14-1 Creating a Tnsnames.ora File	458	(1)
Assignment 14-2 Specifying Multiple Name Resolution Methods	458	(1)
Assignment 14-3 Using Net Manager to Change the Resolution Order	459	(1)
Assignment 14-4 Using the Oracle Net Configuration Assistant to Test a Listener Connection	459	(1)
Assignment 14-5 Using the PING Utility	459	(1)
Assignment 14-6 Using the TNSPING Utility	460	(1)
Assignment 14-7 Tracing Client-Side Connection Information	460	(1)
Assignment 14-8 Tracing Client-Side Connection Information	460	(1)
Case Projects	461	(2)
Case 14-1 Identifying a Name Resolution Strategy	461	(1)
Case 14-2 Troubleshooting the Oracle9i Network	461	(2)
Oracle Shared Server	463	(24)
The Current Challenge in the Janice Credit Union Database	464	(1)
Set Up Your Computer for the Chapter	464	(1)
Notes About Dual Coverage in this Chapter	464	(1)
Server Processes	464	(2)
Configuring the Shared Server	466	(7)
Configuring the Oracle Shared Server---GUI Approach	466	(5)
Configuring the Oracle Shared Server---Manual Approach	471	(2)
Initialization Parameters	473	(1)
Tuning the Oracle Shared Server	474	(2)
Using Views	474	(1)
Performing Calculations	475	(1)
Dynamically Changing Shared Server Parameters	476	(1)
Chapter Summary	477	(1)
Syntax Guide	478	(2)
Review Questions	480	(2)
Hands-on Assignments	482	(3)
Assignment 15-1 Configuring the Oracle Shared Server	482	(1)
Assignment 15-2 Changing Parameter Values Through the Database Configuration Assistant	482	(1)
Assignment 15-3 Changing a Parameter Value in the Init.ora File	482	(1)
Assignment 15-4 Inserting a Shared Server Parameter into the Init.ora File	483	(1)
Assignment 15-5 Adjusting the Number of Dispatchers	483	(1)
Assignment 15-6 Manually Changing the Init.ora File to Configure the Database for Dedicated Server Processing	483	(1)
Assignment 15-7 Dispatcher Configuration	484	(1)
Assignment 15-8 Using the Listener Control Utility (Isnrctl) for Dispatcher Information	484	(1)
Case Projects	485	(2)
Case 15-1 Determining the Initial Settings for the Oracle Shared Server	485	(1)
Case 15-2 Monitoring Routine	485	(2)
Glossary	487	(4)
Index	491