Oracle Database

Optimizer - the motor of Oracle

• SQL Engine - Query Optimizer (Query Optimization)
  • Sql Engine - (Physical|Execution) Plan
    • Oracle Database - Explain Plan
    • Oracle Database - Autotrace
    • …
  • Operation
    • Join operation
    • SQL Engine - (Access|Scan) (Paths|Method)
  • Oracle Database - Hints
  • Oracle Database - Optimizer Statistics
    • Oracle Database - Statistics - Table

Data Type

• Oracle Database - Bytes or Characters for VARCHAR2 and CHAR
• Oracle Database - Datatype difference between VARCHAR2 and CHAR
• Oracle Database - Character Set Functions : CONVERT, UNISTR
• Oracle Database Is Function (IsDate, )
• Oracle Database - Null value (Missing Value)
• Oracle - Date Datatype
• Oracle Database - Globalization (Localization, NLS parameter)
• Oracle Database - Data type Conversion

Properties of a database application

Scalable

• Concurrency - Latches (System Lock)
• How you can use a bind variable in SQLPlus

Debugging

• DBMS_APPLICATION_INFO to manage long-running operation
• PL/SQL - Debug.f for debugging application
• Oracle - SQL_TRACE
• Oracle Database - Auditing

Utilities

• Oracle Database - Data Pump - (Export|Import) Utilities

Installation, Administration, Security

• Oracle Database - Installation
• Oracle Database - Data Dictionary
• Oracle Database - User, Security
• Oracle Database - (Initialization|System) Parameters
• Oracle Database - Entreprise Manager
• Oracle Database - Export Utility (exp)
• Backup
• DBCA
• Oracle Database and Hardware
• Oracle Database - Locks
• How to find the version informations of the Database ?

Ressource, Space

• Oracle Database - High Water Mark (HWM) - boundary between used and unused space
• Oracle Database - Space (Size)
• Oracle Database - TableSpace
• Oracle Database - Memory
• Ressource Manager
• Oracle Database - SQL Parallel Execution

Load

• Oracle Database - Xml External Table

SqlPlus

• SqlPlus - SqlPlus Command
  • SQL Plus - Variable
  • SQL Plus - Startup Script
  • SQL Plus - Formatting Reports
  • SQL Plus - Special Characters
  • …

Sql, PlSql

• Oracle Database - Cascade
• Error Ora
• PL/SQL - (Procedure Language|PL) SQL
• Procedure Stockee Java
• Oracle Database - Trigger

DataWarehouse PlSql Statement

• Oracle Database - (Pivot|Unpivot) Statement
• Oracle Database - Table Function (Pipelined)
• Data Processing - (Batch|Bulk) Processing

Modeling

• Oracle Database - Star Transformation
• Logical Data Modeling - Key

Summary Management and precompute operations

Materialized Views and Query Rewrite are parts of a feature known as Summary Management that has been included in the database since Oracle 8i.

• Oracle Database - Materialized Views (ROLAP) and Cubes (MOLAP) comparison (Pre Compute Operations)
  • Oracle Database - Materialized view (Snapshot) and Database Oracle - Query Rewrite
  • Oracle Olap with Analytic Workspace
• Methodology
  • Oracle Database - Methodology for Designing and Building Materialized Views
  • Oracle OLAP - Methodology for Defining the Analytic Workspace

Performance

• Oracle Database - Performance
• Oracle Database - (Integrity) Constraints
• ORACLE - Streams / Change Data Capture

Others

• A Common Business Problem : Messages (AQ)
• Oracle Database - The effect of ArraySize on Logical I/O
• Green/Grid Computing
• Oracle Database - Sample Schemas
• Glossary
• Oracle Database - shared server architecture