newbie webmaster

Free ebook Oracle-Oracle Administration and Architecture.pdf, download it at http://www.free-itebooks.com.
Here is the table of content :
Preface
Profile xvii
Related Information xix
Typographic Conventions xx
Introduction
Objectives I-2
   Oracle8i Enterprise Edition I-3
   Database Administrator Tasks I-5
   Course Schedule I-6
Lesson 1: Oracle Architectural Components
   Objectives 1-2
   Overview 1-3
   Oracle Database Files 1-5
   Other Key Files 1-6
   Oracle Instance 1-7
   Processing a SQL Statement 1-9
   Connecting to a Database 1-10
   Processing a Query 1-12
   The Shared Pool 1-14
   Database Buffer Cache 1-16
   Program Global Area 1-17
   Processing a DML Statement 1-19
   Redo Log Buffer 1-21
   Rollback Segment 1-22
   COMMIT Processing 1-23
   Log Writer 1-25
   Other Instance Processes 1-26
   Database Writer 1-27
   SMON: System Monitor 1-28
   PMON: Process Monitor 1-30
   Archiving 1-31
   Summary 1-33
Lesson 2: Getting Started with the Oracle Server
   Objectives 2-2
   Overview 2-3
   Oracle Universal Installer 2-4
   Validating Privileged Users 2-8
   Oracle Enterprise Manager 2-15
   Summary 2-30
Lesson 3: Managing an Oracle Instance
   Objectives 3-2
   Overview 3-3
   Stages in Startup and Shutdown 3-10
   Starting Up the Instance 3-13
   Changing Database Availability 3-16
   Opening a Database in Read-Only Mode 3-17
   Shutting Down 3-18
   Getting and Setting Parameter Values 3-22
   Managing Sessions 3-29
   Summary 3-36
Lesson 4: Creating a Database
   Objectives 4-2
   Overview 4-3
   Preparing the Operating System 4-4
   Creating a Database 4-10
   Using the Database Configuration Assistant 4-11
   Creating a Database Manually 4-15
   Summary 4-29
Lesson 5: Creating Data Dictionary Views and Standard Packages
   Objectives 5-2
   Overview 5-3
   Data Dictionary Overview 5-4
   Data Dictionary Contents 5-5
   Base Tables and Data Dictionary Views 5-6
   How the Data Dictionary Is Used 5-7
   Data Dictionary View Categories 5-8
   Data Dictionary Examples 5-10
   Dynamic Performance Views 5-11
   Stored Program Units 5-12
   Stored PL/SQL Program Units 5-14
   Packages 5-16
   Executing a PL/SQL Program Unit 5-17
   Package Specification and Body 5-18
   Oracle-Supplied Packages 5-19
   Obtaining Information 5-20
   Troubleshooting 5-22
   Constructing the Data Dictionary 5-23
   Administrative Scripts 5-25
   Built-in Package Example 5-27
   Triggers 5-29
   Parts of a Trigger 5-31
   Trigger Example 5-33
   Summary 5-34
Lesson 6: Maintaining the Control File
   Objectives 6-2
   The Use of the Control File 6-3
   Control File Contents 6-4
   Multiplexing the Control File 6-6
   Guidelines for Control Files 6-7
   Obtaining Information About the Control File 6-9
   Summary 6-11
Lesson 7: Maintaining Redo Log Files
   Objectives 7-2
   Overview 7-3
   Using Online Redo Files 7-4
   LGWR, Log Switches, and Checkpoints 7-6
   Archiving Redo Log Files 7-8
   Obtaining Log and Archive Information 7-11
   Controlling Log Switches and Checkpoints 7-18
   Multiplexing and Maintaining Members and Groups 7-21
   Relocating or Renaming Online Redo Log Files 7-24
   Dropping Online Redo Log Groups and Members 7-26
   Planning Online Redo Logs 7-30
   Troubleshooting 7-32
   Using LogMiner 7-33
   Summary 7-40
Lesson 8: Managing Tablespaces and Data Files
   Objectives 8-2
   Overview 8-3
   Database Storage Hierarchy 8-4
   SYSTEM and Non-SYSTEM Tablespaces 8-7
   Creating Tablespaces 8-8
   Space Management in Tablespaces 8-12
   Locally Managed Tablespaces 8-13
   Temporary Tablespace 8-15
   Changing the Storage Settings 8-18
   Taking Tablespaces Offline or Online 8-20
   Read-Only Tablespaces 8-23
   Dropping Tablespaces 8-26
   Resizing a Tablespace 8-29
   Enabling Automatic Resizing of Data Files 8-30
   Manually Resizing Data Files 8-33
   Adding Data Files to a Tablespace 8-34
   Moving Data Files 8-36
   Data Dictionary Information 8-39
   Guidelines 8-40
   Summary 8-42
Lesson 9: Storage Structure and Relationships
   Objectives 9-2
   Overview 9-3
   Types of Segments 9-4
   Storage Clause Precedence 9-8
   Extent Allocation and Deallocation 9-9
   Used and Free Extents 9-10
   Using Block Space Utilization Parameters 9-11
   Obtaining Information About Storage Structures 9-16
   Querying DBA_SEGMENTS 9-17
   Querying DBA_EXTENTS 9-18
   Querying DBA_FREE_SPACE 9-19
   Planning the Location of Segments 9-20
   Summary 9-22
Lesson 10: Managing Rollback Segments
   Objectives 10-2
   Overview 10-3
   Rollback Segments 10-4
   Using Rollback Segments with Transactions 10-8
   Creating Rollback Segments 10-12
   Maintaining Rollback Segments 10-18
   Obtaining Rollback Segment Information 10-26
   Planning Rollback Segments 10-32
   Troubleshooting Rollback Segment Problems 10-34
   Summary 10-40
Lesson 11: Managing Tables
   Objectives 11-2
   Overview 11-3
   Oracle Data Types 11-7
   Creating a Table 11-17
   Controlling Space Used by Tables 11-25
   Retrieving Table Information 11-41
   Summary 11-47
Lesson 12: Managing Indexes
   Objectives 12-2
   Overview 12-3
   Creating Indexes 12-12
   Reorganizing Indexes 12-22
   Dropping Indexes 12-29
   Obtaining Index Information 12-31
   Summary 12-33
Lesson 13: Maintaining Data Integrity
   Objectives 13-2
   Overview 13-3
   Integrity Constraints 13-5
   Implementing Constraints 13-14
   Maintaining Constraints 13-19
   Getting Constraint Information 13-26
   Summary 13-29
Lesson 14: Loading Data
   Objectives 14-2
   Overview 14-3
   Loading Data Using Direct-Load Insert 14-5
   Loading Data Using SQL*Loader 14-8
   Direct Path Loading 14-28
   Summary 14-29
Lesson 15: Reorganizing Data
   Objectives 15-2
   Overview 15-3
   Transportable Tablespaces 15-23
   Transporting a Tablespace 15-25
   Exporting and Importing Metadata 15-26
   Transporting a Tablespace 15-28
   Transportable Tablespace Uses 15-29
   Transportable Tablespaces and Schema Objects 15-30
   Checking the Transport Set 15-31
   Summary 15-32
Lesson 16: Managing Password Security and Resources
   Objectives 16-2
   Overview 16-3
   Administering Passwords 16-5
   Altering and Dropping a Profile 16-20
   Controlling Usage of Resources 16-24
   Viewing Password and Resource Limits Information 16-31
   Summary 16-33
Lesson 17: Managing Users
   Objectives 17-2
   Overview 17-3
   Creating New Database Users 17-6
   Altering and Dropping Database Users 17-14
   Dropping Users 17-17
   Monitoring Information About Users 17-18
   Summary 17-20
Lesson 18: Managing Privileges
   Objectives 18-2
   Overview 18-3
   System Privileges 18-4
   Granting System Privileges 18-6
   Password File Authentication 18-9
   Displaying System Privileges 18-11
   Revoking System Privileges 18-14
   Object Privileges 18-17
   Granting Object Privileges 18-18
   Displaying Object Privileges 18-20
   Revoking Object Privileges 18-21
   Auditing Guidelines 18-25
   Using Database Auditing 18-29
   Viewing Auditing Results 18-36
   Summary 18-37
Lesson 19: Managing Roles
   Objectives 19-2
   Overview 19-3
   Creating and Modifying Roles 19-5
   Assigning Roles 19-11
   Controlling Availability of Roles 19-13
   Displaying Role Information 19-22
   Using Fine-Grained Access Control 19-23
   Summary 19-25
Lesson 20: Using National Language Support
   Objectives 20-2
   Overview 20-3
   Choosing a Database and a National Character Set 20-5
   Specifying Language-Dependent Behavior 20-11
   NLS Parameters and SQL Functions 20-19
   NLS Parameters in SQL Functions 20-22
   Linguistic Index Support 20-26
   Importing and Loading Data Using NLS 20-27
   Obtaining Information About NLS Settings 20-28
   Summary 20-33
Appendix A: Practices
   Environment A-2
   Practice 1: Oracle Architectural Components A-3
   Practice 2: Getting Started With Oracle A-5
   Practice 3: Managing an Oracle Instance A-6
   Practice 4: Creating a Database A-8
   Practice 5: Creating Data Dictionary Views and Standard Packages A-9
   Practice 6: Maintaining the Control File A-10
   Practice 7: Maintaining Redo Log Files A-11
   Practice 8: Managing Tablespaces and Data Files A-12
   Practice 9: Storage Structure and Relationships A-13
   Practice 10: Managing Rollback Segments A-14
   Practice 11: Managing Tables A-15
   Practice 12: Managing Indexes A-17
   Practice 13: Maintaining Data Integrity A-19
   Practice 14: Loading Data A-20
   Practice 15: Reorganizing Data A-21
   Practice 16: Managing Password Security A-22
   Practice 17: Managing Users A-23
   Practice 18: Managing Privileges A-24
   Practice 19: Managing Roles A-25
   Practice 20: Using National Language Support A-26
Appendix B: Hints
   Practice 1: Oracle Architectural Components B-2
   Practice 2: Getting Started With Oracle B-3
   Practice 3: Managing an Oracle Instance B-4
   Practice 4: Creating a Database B-7
   Practice 5: Creating Data Dictionary Views and Standard Packages B-8
   Practice 6: Maintaining the Control File B-9
   Practice 7: Maintaining Redo Log Files B-10
   Practice 8: Managing Tablespaces and Data Files B-12
   Practice 9: Storage Structure and Relationships B-14
   Practice 10: Managing Rollback Segments B-16
   Practice 11: Managing Tables B-18
   Practice 12: Managing Indexes B-20
   Practice 13: Maintaining Data Integrity B-22
   Practice 14: Loading Data B-23
   Practice 15: Reorganizing Data B-25
   Practice 16: Managing Password Security B-26
   Practice 17: Managing Users B-27
   Practice 18: Managing Privileges B-28
   Practice 19: Managing Roles B-29
   Practice 20: Using National Language Support B-30
Appendix C: Practice Solutions for SQL*Plus
   Practice 1 Solutions C-2
   Practice 2 Solutions C-4
   Practice 3 Solutions C-7
   Practice 4 Solutions C-16
   Practice 5 Solutions C-20
   Practice 6 Solutions C-24
   Practice 7 Solutions C-27
   Practice 8 Solutions C-33
   Practice 9 Solutions C-40
   Practice 10 Solutions C-46
   Practice 11 Solutions C-54
   Practice 12 Solutions C-59
   Practice 13 Solution C-63
   Practice 14 Solutions C-69
   Practice 15 Solutions C-75
   Practice 16 Soltuions C-80
   Practice 17 Solutions C-84
   Practice 18 Solutions C-87
   Practice 19 Solutions C-92
   Practice 20 Solutions C-95
Appendix D: Practice Solutions for Oracle Enterprise Manager
   Practice 1 Solutions D-2
   Practice 2 Solutions D-3
   Practice 3 Solutions D-4
   Practice 4 Solutions D-8
   Practice 5 Solutions D-9
   Practice 6 Solutions D-10
   Practice 7 Solutions D-12
   Practice 8 Solutions D-19
   Practice 9 Solutions D-25
   Practice 10 Solutions D-26
   Practice 11 Solutions D-37
   Practice 12 Solutions D-42
   Practice 13 Solutions D-47
   Practice 14 Solutions D-49
   Practice 15 Soltuions D-52
   Practice 16 Solutions D-59
   Practice 17 Solutions D-64
   Practice 18 Solutions D-71
   Practice 19 Solutions D-76
   Practice 20 Solutions D-80
Appendix E: Certification Test: Sample Questions
   Oracle Certified Professional (OCP) Program: Oracle Certified
   Database Administrator Track E-2
   Oracle Database Administration: Sample Test E-3
   Oracle Backup and Recovery Sample Test E-5
Answers E-8
Registering for an OCP Test E-9