没有合适的资源?快使用搜索试试~ 我知道了~
Oracle9i手册 Oracle9i手册 有研究或探讨或开源的请加群:37424970 二群:49278157 或联系本人MSN或邮箱:zhuseahui@yahoo.com.cn Oracle9i手册
资源详情
资源评论
资源推荐
Oracle9i Database Administration
Fundamentals I
Volume 1 • Student Guide
D11321GC11
Production 1.1
December 2001
D34286
Authors
Marie St. Gelais
S Matt Taylor Jr
Technical Reviewers
Paulo Barqueira
Charles Fabrie
Lilian Hobbs
Dominique Jeunot
Donna Keesling
Simon Law
Howard Ostrow
Ashesh Parekh
Gabriela Stanescu
Publisher
John B Dawson
Copyright © Oracle Corporation, 2001. All rights reserved.
This documentation contains proprietary information of Oracle Corporation. It is
provided under a license agreement containing restrictions on use and disclosure
and is also protected by copyright law. Reverse engineering of the software is
prohibited. If this documentation is delivered to a U.S. Government Agency of the
Department of Defense, then it is delivered with Restricted Rights and the
following legend is applicable:
Restricted Rights Legend
Use, duplication or disclosure by the Government is subject to restrictions for
commercial computer software and shall be deemed to be Restricted Rights
software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS
252.227-7013, Rights in Technical Data and Computer Software (October 1988).
This material or any portion of it may not be copied in any form or by any means
without the express prior written permission of Oracle Corporation. Any other
copying is a violation of copyright law and may result in civil and/or criminal
penalties.
If this documentation is delivered to a U.S. Government Agency not within the
Department of Defense, then it is delivered with “Restricted Rights,” as defined in
FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).
The information in this document is subject to change without notice. If you find
any problems in the documentation, please report them in writing to Education
Products, Oracle Corporation, 500 Oracle Parkway, Box SB-6, Redwood Shores,
CA 94065. Oracle Corporation does not warrant that this document is error-free.
SQL*Loader, SQL*Net, SQL*Plus, Net8, Oracle Call Interface, Oracle7, Oracle8,
Oracle 8i, Developer/2000, Developer/2000 Forms, Designer/2000, Oracle
Enterprise Manager, Oracle Parallel Server, PL/SQL, Pro*C, Pro*C/C++, and
Trusted Oracle are trademarks or registered trademarks of Oracle Corporation.
All other products or company names are used for identification purposes only,
and may be trademarks of their respective owners.
Preface
I Introduction
Course Objectives I-2
Oracle9i Enterprise Edition I-3
Tasks of a Database Administrator I-4
1 Oracle Architectural Components
Objectives 1-2
Overview of Primary Components 1-3
Oracle Server 1-5
Oracle Instance 1-6
Establishing a Connection and Creating a Session 1-7
Oracle Database 1-9
Physical Structure 1-10
Memory Structure 1-11
System Global Area 1-12
Shared Pool 1-15
Library Cache 1-16
Data Dictionary Cache 1-17
Database Buffer Cache 1-18
Redo Log Buffer 1-21
Large Pool 1-22
Java Pool 1-24
Program Global Area 1-25
Process Structure 1-28
User Process 1-29
Server Process 1-30
Background Processes 1-31
Database Writer (DBWn) 1-32
Log Writer (LGWR) 1-33
System Monitor (SMON) 1-34
Process Monitor (PMON) 1-35
Checkpoint (CKPT) 1-36
Archiver (ARCn) 1-37
Logical Structure 1-39
Processing SQL Statements 1-42
Summary 1-44
Practice 1 Overview 1-45
Contents
iii
2 Getting Started with the Oracle Server
Objectives 2-2
Database Administration Tools 2-3
Oracle Universal Installer 2-4
Starting the Universal Installer 2-5
Non-Interactive Installation Using Response Files 2-6
Oracle Database Configuration Assistant 2-9
Database Administrator Users 2-10
SQL*Plus 2-11
Oracle Enterprise Manager 2-12
Oracle Enterprise Manager – Architecture 2-13
Console 2-15
Summary 2-17
Practice 2 Overview 2-18
3 Managing an Oracle Instance
Objectives 3-2
Initialization Parameter Files 3-3
PFILE initSID.ora 3-6
Creating a PFILE 3-7
PFILE Example 3-8
SPFILE spfileSID.ora 3-9
Creating an SPFILE 3-10
SPFILE Example 3-13
STARTUP Command Behavior 3-14
Modifying Parameters in SPFILE 3-15
Starting Up a Database NOMOUNT 3-19
Starting Up a Database MOUNT 3-20
Starting Up a Database OPEN 3-21
STARTUP Command 3-22
ALTER DATABASE Command 3-25
Opening a Database in Restricted Mode 3-26
Opening a Database in Read-Only Mode 3-29
Shutting Down the Database 3-31
Shutdown Options 3-32
Monitoring an Instance Using Diagnostic Files 3-36
Alert Log File 3-37
Background Trace Files 3-39
User Trace File 3-40
iv
Enabling or Disabling User Tracing 3-41
Summary 3-43
Practice 3 Overview 3-44
4 Creating a Database
Objectives 4-2
Managing and Organizing a Database 4-3
Optimal Flexible Architecture (OFA) 4-4
Oracle Software and File Locations 4-5
Creation Prerequisites 4-6
Authentication Methods for Database Administrators 4-7
Using Password File Authentication 4-8
Creating a Database 4-10
Operating System Environment 4-11
Database Configuration Assistant 4-12
Create a Database Using Database Configuration Assistant 4-13
Creating a Database Manually 4-17
Creating the Database 4-20
Creating a Database Using Oracle Managed Files (OMF) 4-23
Troubleshooting 4-27
After Database Creation 4-28
Summary 4-29
Practice 4 Overview 4-30
5 Using Data Dictionary and Dynamic Performance Views
Objectives 5-2
Built-In Database Objects 5-3
Data Dictionary 5-4
Base Tables and Data Dictionary Views 5-5
Creating Data Dictionary Views 5-6
Data Dictionary Contents 5-7
How the Data Dictionary is Used 5-8
Data Dictionary View Categories 5-9
Data Dictionary Examples 5-11
Dynamic Performance Tables 5-12
Dynamic Performance Table Examples 5-13
Administrative Scripts Naming Conventions 5-15
Summary 5-16
Practice 5 Overview 5-17
v
剩余491页未读,继续阅读
zhuseahui
- 粉丝: 63
- 资源: 419
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0