oracle concepts 目录重温学习

上一篇 / 下一篇 2008-01-23 10:05:02 / 个人分类：学习

This document contains:ITPUB个人空间cE5hV hrHW

Part I: What Is Oracle?
0d ^:kJN&^Yfn hxT0

Chapter 1, "Introduction to the Oracle Server"
9[~6kd:{ i-F0This chapter provides an overview of the concepts and features you need forITPUB个人空间6Sb#m V,N|e-g
understanding the Oracle data server. You should read this overview before using
0K0jyBY0the detailed information in the remainder of this manual.
%NpANyc0

Part II: Database StructuresITPUB个人空间p'c)o3Q*u,^mbxG

Chapter 2, "Data Blocks, Extents, and Segments"
/K1g;Xr%l$O4Y1j/fl|0This chapter discusses how data is stored and how storage space is allocated for
.TIk S?kER|0and consumed by various objects within an Oracle database.
7Y{1qQ l0^.g6jz"n R k2n`0

Chapter 3, "Tablespaces, Datafiles, and Control Files"
0}X,M O S0This chapter discusses how physical storage space in an Oracle database is dividedITPUB个人空间2gpg\/O
into logical divisions called tablespaces. It also discusses the physical operating
&K6Gp+YtI-`0system files associated with tablespaces (datafiles) and files used in recoveryITPUB个人空间R@'b gF-A _ F3lE K
(control files).
Prc7l/AN0

Chapter 4, "The Data Dictionary"
1\(AB)P2S|M0This chapter describes the data dictionary, which is a set of reference tables andITPUB个人空间-p_)l+`!I Go?H[ U
views that contain read-only information about an Oracle database.ITPUB个人空间2Y\%W Kb@
xxxvITPUB个人空间M:e[M?n{

Part III: The Oracle InstanceITPUB个人空间5{L| Y'qm)]z

Chapter 5, "Database and Instance Startup and Shutdown"ITPUB个人空间D)EDrX
This chapter describes an Oracle instance and explains how the databaseITPUB个人空间mLX.`Q]+L-r;m8O
administrator can control the accessibility of an Oracle database system.
U8Rmq la DF0

Chapter 6, "Application Architecture"
)lE`c+w4WS4R4B2_W0This chapter discusses distributed processing environments in which the OracleITPUB个人空间/U9aD2Krf?H&f7Z#?
data server can operate.
j*I u["^c3|^0

Chapter 7, "Memory Architecture"ITPUB个人空间y3} O![{{`9x
This chapter describes the memory structures used by an Oracle database system.ITPUB个人空间3K7Ftypb

Chapter 8, "Process Architecture"ITPUB个人空间+u:CD0Yt*\ m5G
This chapter describes the process architecture of an Oracle instance and theITPUB个人空间p[s0YRH&o#RG
different process configurations available for Oracle.
P A"pmt Q!U0

Chapter 9, "Database Resource Management"ITPUB个人空间;no6J6dA+wv:N%P5Q
This chapter describes how the Database Resource Manager can be used to control
c@R{en:v0resource use.
Z1T!I Kx5C0

Part IV: DataITPUB个人空间;b{#LZ2u!s

Chapter 10, "Schema Objects"ITPUB个人空间:T3H!f8Z;C7w
This chapter describes the database objects that can be created in the domain of a
4zFt'U#B \m5C!S0specific user (a schema), including tables, views, numeric sequences, andITPUB个人空间3O6t,|wlt6XVh/w
synonyms. Optional structures that make data retrieval more efficient, includingITPUB个人空间2z&HB?jQO;Hr:Ge-]
indexes, materialized views, dimensions, and clusters, are also described.
:Z.S'l:U2cT `6~0

Chapter 11, "Partitioned Tables and Indexes"ITPUB个人空间s'x9T2Q7Y
This chapter describes how partitioning can be used to split large tables and indexes
9SaV]*NiJs0into more manageable pieces.
?w~-UPRz(I%A"H._0

Chapter 12, "Native Datatypes"ITPUB个人空间Tl;h c:n
This chapter describes the types of relational data that can be stored in an OracleITPUB个人空间Z1BTj'j,x#B?~S
database table, such as fixed- and variable-length character strings, numbers, dates,
C5bSm,ZUq0and binary large objects (BLOBs).
? zQ2esx0xxxvi
}%L.\1yC3\4Os'Z-G-L0

Chapter 13, "Object Datatypes and Object Views"
h d ~*p\]7H0This chapter gives an overview of the object extensions that Oracle provides.ITPUB个人空间^ h:w!h"`c0r

Part V: Data Access
WU#[Mj MWW0

Chapter 14, "SQL, PL/SQL, and Java"
z}C2\n?K.E0This chapter briefly describes SQL (Structured Query Language), the language used
&q6JWx,iZp-b$Z0to communicate with Oracle, as well as PL/SQL, the Oracle procedural language
-P8c!J4D |w0extension to SQL. It also discusses the procedural language constructs called
kiLRlb-Uh2s3t0procedures, functions, and packages, which are PL/SQL program units that areITPUB个人空间E4xty)@
stored in the database.ITPUB个人空间+y#qOC0WU8G9e L

Chapter 15, "Dependencies Among Schema Objects"
rQ1\ }1{3KLW.\B0This chapter explains how Oracle manages the dependencies for objects such as
procedures, packages, triggers, and views.ITPUB个人空间Q{y'G _ Q0A

Chapter 16, "Transaction Management"ITPUB个人空间5R$E9\1m:vS{4E~y
This chapter defines the concept of transactions and explains the SQL statements
F1VHFb4e,xF0used to control them. Transactions are logical units of work that are run together asITPUB个人空间P(c:@O{db
a unit.ITPUB个人空间+R0UKL X7o

Chapter 17, "Triggers"ITPUB个人空间U.Nh/sN4un
This chapter discusses triggers, which are procedures written in PL/SQL, Java, or C
&`@)f _'?S^:H"j1k0that run implicitly whenever a table or view is modified or when some user actions
5{f,v ^M{0or database system actions occur.
F`n(^"jMknR0

Part VI: Parallel SQL and Direct-Path INSERT
6H["[Z{w0

Chapter 18, "Parallel Execution of SQL Statements"
u.?%oSQ`1Iqc0This chapter describes parallel execution of SQL statements (queries, DML, andITPUB个人空间Q}Sf^
DDL statements) and explains the rules for parallelizing SQL statements.ITPUB个人空间`3U0[5z:k;WW5r'W

Chapter 19, "Direct-Path INSERT"
1D?:? u?0k\0This chapter describes the Oracle direct-path INSERT feature for serial or parallel
VdW|yw0inserts, and the NOLOGGING clause.ITPUB个人空间tQo%fJ6?c
xxxvii
g$m1Dy5S3}h&_0

Part VII: Data Protection
Y pO3`pho["e0

Chapter 20, "Data Concurrency and Consistency"ITPUB个人空间#b6~ A?&K]'O}
This chapter explains how Oracle provides concurrent access to and maintains theITPUB个人空间M/M7E$J|"g4zX
accuracy of shared information in a multiuser environment. It describes the
mf\L.X)\&n/o0automatic mechanisms that Oracle uses to guarantee that the concurrent operations
n9J:Z8a)OC0of multiple users do not interfere with each other.ITPUB个人空间 N^U3i [&k!Q9L

Chapter 21, "Data Integrity"ITPUB个人空间Oe#| _p3W _*v%Rb
This chapter discusses data integrity and the declarative integrity constraints that
EJXt-@9zU0you can use to enforce data integrity.
$WND od9u0

Chapter 22, "Controlling Database Access"
/]+{J~*s~fr0This chapter describes how to control user access to data and database resources.
;EIM.[Y!k W:W-q0

Chapter 23, "Privileges, Roles, and Security Policies"
l3uT Om_0This chapter discusses security at the system and schema object levels.ITPUB个人空间(|C/AIsR7l*pg

Chapter 24, "Auditing"
#n2o9~t0Ba?$N0This chapter discusses how the Oracle auditing feature tracks database activity.ITPUB个人空间s0w(P,qkR6LCB

争取这几天有空时间重新看下oracle concepts documents 加深理解