دانلود کتاب اوراکل-دانلود کتاب oracle-Oracle 11g For Dummies

Introduction ................................................................. 1
About This Book ..............................................................................................1
Who Are You? ..................................................................................................2
What’s in This Book .......................................................................................2
Part I: You Don’t Have to Go to Delphi to Know Oracle....................2
Part II: Implementing Oracle on Your Own .........................................3
Part III: Caring for an Oracle Database ................................................3
Part IV: Inspecting Advanced Oracle Technologies ..........................3
Part V: The Part of Tens ........................................................................3
Icons in This Book ...........................................................................................4
Where to Go from Here ..................................................................................4
Part I: You Don’t Have to Go to Delphi to Know Oracle .... 5
Chapter 1: A Pragmatic Introduction to Oracle. . . . . . . . . . . . . . . . . . . . .7
Introducing a New Kind of Database Management .....................................7
Pooling Resources with Grid Computing .....................................................8
Anticipating Technology and Development Trends ...................................9
Meeting Oracle in the Real World ..................................................................9
Making the Oracle Decision .........................................................................10
Chapter 2: Understanding Oracle Database Architecture . . . . . . . . . .13
Defi ning Databases and Instances ...............................................................13
Deconstructing the Oracle Architecture ....................................................14
Walking Down Oracle Memory Structures .................................................15
Trotting around the System Global Area ....................................................15
Shared pool ...........................................................................................16
Database buffer cache .........................................................................18
Redo log buffer .....................................................................................21
Large pool .............................................................................................22
Java pool ...............................................................................................23
Program Global Area .....................................................................................23
Managing Memory .........................................................................................24
Managing memory automatically .....................................................24
Following the Oracle Processes ...................................................................26
Background processes ........................................................................27
User and server processes .................................................................28
Getting into Physical Structures ..................................................................30

Getting Physical with Files ...........................................................................30
Data fi les: Where the data meets the disk ........................................31
Control fi les ..........................................................................................32
Redo log fi les ........................................................................................33
Moving to the archives........................................................................35
Server and initialization parameter fi les ...........................................36
Applying Some Logical Structures ..............................................................37
Tablespaces ..........................................................................................38
Segments ...............................................................................................39
Extents ...................................................................................................40
Oracle blocks ........................................................................................41
Chapter 3: Preparing to Implement Oracle in the Real World . . . . . . .43
Understanding Oracle Database Deployment Methodology ...................44
Client-server applications ...................................................................44
Muli-tier applications ..........................................................................45
Component confi gurations .................................................................48
Checking on the Requirements ....................................................................49
User and directory requirements ......................................................50
Hardware requirements .....................................................................53
Software requirements ........................................................................55
Storage requirements .........................................................................56
Other requirements ............................................................................58
Part II: Implementing Oracle on Your Own ................... 61
Chapter 4: Creating an Oracle Database . . . . . . . . . . . . . . . . . . . . . . . . .63
Feeling at Home in Your Environment ........................................................63
Finding the Oracle software owner ...................................................64
Oracle versions ....................................................................................65
Getting to home base .........................................................................65
ORACLE_BASE .....................................................................................66
ORACLE_HOME ...................................................................................66
ORACLE_SID ........................................................................................67
PATH .....................................................................................................67
Sticking with the Oracle Universal Installer and oraenv .........................68
Confi guring an Instance ...............................................................................70
Using PFILE and SPFILES .....................................................................70
Setting parameters in the pfi le and spfi le .........................................71
Creating Your Oracle Database ...................................................................74
Bossing the Database Confi guration Assistant (DBCA) ............................74
Taking database control ....................................................................75
Taking the DBCA steps ........................................................................76
Sharing (a) memory .............................................................................86
Feeling the Post-Confi guration Glow ...........................................................87