Oracle Database Concepts 10g Release 1

Oracle Database Concepts, 10g Release 1 (10.1). Part No. B10743-01. Copyright 1993, 2003 Oracle Corporation. All rights reserved.

More PDF Content

Oracle Database Concepts 10g Release 1
What Is Oracle?
Introduction to the Oracle Database
Oracle Database Architecture… 1-1
Overview of Oracle Grid Architecture – XXX… 1-2
Oracle Technologies that Enable the Grid… 1-4
Managing the Grid… 1-6
Overview of Application Architecture… 1-7
Client/Server Architecture… 1-7
Multitier Architecture: Application Servers… 1-8
Overview of Physical Database Structures… 1-8
Datafiles… 1-8
Control Files… 1-9
Redo Log Files… 1-9
Archive Log Files… 1-10
Parameter Files… 1-10
Alert and Trace Log Files… 1-10
Backup Files… 1-11
Overview of Logical Database Structures… 1-11
Tablespaces… 1-11
Oracle Data Blocks… 1-12
Extents… 1-12
Segments… 1-12
Overview of Schemas and Common Schema Objects… 1-14
Tables… 1-14
Indexes… 1-14
Views… 1-14
Clusters… 1-15
Synonyms… 1-15
Overview of the Oracle Data Dictionary… 1-15
Overview of the Oracle Instance… 1-16
Real Application Clusters: Multiple Instance Systems… 1-16
Instance Memory Structures… 1-16
System Global Area… 1-16
Program Global Area… 1-17
Oracle Background Processes… 1-18
Process Architecture… 1-18
Overview of Accessing the Database… 1-19
Network Connections… 1-19
Starting Up the Database… 1-20
How Oracle Works… 1-20
Overview of Oracle Utilities… 1-21
Oracle Database Features… 1-21
Overview of Scalability and Performance Features… 1-22
Concurrency… 1-22
Read Consistency… 1-23
Locking Mechanisms… 1-24
Quiesce Database… 1-25
Real Application Clusters… 1-25
Overview of Manageability Features… 1-26
Self-Managing Database… 1-26
Oracle Enterprise Manager… 1-26
SQL*Plus… 1-27
Automatic Storage Management… 1-27
The Scheduler… 1-27
Database Resource Manager… 1-27
Overview of Database Backup and Recovery Features… 1-28
Types of Failures… 1-28
Structures Used for Recovery… 1-29
Overview of High Availability Features… 1-31
Overview of Business Intelligence Features… 1-32
Data Warehousing… 1-32
Extraction, Transformation, and Loading (ETL)… 1-32
Materialized Views… 1-32
Bitmap Indexes in Data Warehousing… 1-32
Table Compression… 1-33
Parallel Execution… 1-33
Analytic SQL… 1-33
OLAP Capabilities… 1-33
Data Mining… 1-34
Partitioning… 1-34
Overview of Content Management Features… 1-35
XML in Oracle… 1-35
LOBs… 1-35
Oracle Text… 1-35
Oracle Ultra Search… 1-35
Oracle interMedia… 1-36
Oracle Spatial… 1-36
Overview of Security Features… 1-36
Security Mechanisms… 1-37
Overview of Data Integrity and Triggers… 1-37
Integrity Constraints… 1-38
Keys… 1-38
Triggers… 1-39
Overview of Information Integration Features… 1-39
Distributed SQL… 1-39
Oracle Streams… 1-40
Oracle Transparent Gateways and Generic Connectivity… 1-42
Oracle Database Application Development… 1-42
Overview of Oracle SQL… 1-43
SQL Statements… 1-43
Overview of PL/SQL… 1-44
PL/SQL Program Units… 1-45
Overview of Java… 1-45
Overview of Application Programming Languages (APIs)… 1-46
Overview of Transactions… 1-47
Commit and Undo Transactions… 1-48
Savepoints… 1-48
Overview of Datatypes… 1-48
Overview of Globalization… 1-49

Download Oracle Database Concepts 10g Release 1 pdf from download.oracle.com, 732 pages, 7408.64KB.
Related Books

One Response to “Oracle Database Concepts 10g Release 1”

  1. lifting bez skalpela on June 5th, 2013 at 8:23 am

    I just subscribed to your RSS feed, not sure if I did it precisely though? Fine article by the way.

Leave a Reply