Oracle Database

• Oracle Database - Query optimizer
  • Oracle Database - Execution/Query Plan
    • Oracle Database - Explain Plan
    • Oracle Database - Autotrace
    • ...
  • Operation
    • Join operation
    • Oracle Database - (Access|Scan) (Paths|Method)
  • Oracle Database - Hints
  • Oracle Database - Optimizer Statistics
    • Oracle Database - Table and columns - Optimizer Statistics

• 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
  • What is the data type of NULL ?
  • I hate Null
• Oracle - Date Datatype
• Oracle Database - Globalization (Localization, NLS parameter)
• Oracle - Data type Conversion

• Oracle Database - Latches (System Lock)
• Oracle Database - PL/SQL - Bind Variable

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

• Oracle Database - Data Pump

• Oracle Database - Installation
• Oracle Database - Data Dictionary
• Oracle Database - User, Security
• Oracle Database - Initialization Parameters (INIT.ORA)
• Oracle Database - Entreprise Manager
• Oracle - Import/Export
• Backup
• DBCA
• Oracle Database and Hardware
• Oracle Database - Locks
• How to find the version informations of the Database ?

• Oracle Database - High Water Mark (HWM)
• Oracle Database - Space
• Oracle Database - TableSpace
• Oracle Database - Memory
• Ressource Manager
• Oracle Database - SQL Parallel Execution

• Oracle Database - Xml

• SQL Plus
  • SQLPLUS - Variable
  • SQLPlus - Environment Configuration
  • Oracle Database - SQLPlus - Formatting SQL*Plus Reports
  • SQLPlus - Useful Command
  • ...

• Oracle Database - Cascade
• Error Ora
• PlSql
• Procedure Stockee Java
• Trigger
• Oracle Database - Alter System Statement

• Pivot Statement
• Oracle Database - Table Function (Pipelined)
• Bulk

• Oracle Database - Star Transformation
• Data Modeling - Key (Identifier)

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
  • Methodology for Defining the Analytic Workspace

• Oracle Database - Performance
• Oracle Database - Integrity Constraint
• ORACLE - Streams / Change Data Capture

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