Books for you

Oracle Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Databases and Instances 33
Deploying Physical Components 38
Instance Memory and Processes 48
The Data Dictionary 54
3. Installing and Running Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Installing Oracle 56
Creating a Database 59
Configuring Oracle Net 63
viii | Table of Contents
Starting Up the Database 68
Shutting Down the Database 69
Accessing a Database 70
Oracle at Work 77
4. Oracle Data Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Datatypes 82
Basic Data Structures 90
Additional Data Structures 98
Extended Logic for Data 100
Data Design 102
Constraints 104
Triggers 107
Query Optimization 108
Understanding the Execution Plan 118
SQL Advisors 120
Data Dictionary Tables 120
5. Managing Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


Pages:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25