Oracle Database Development Guide
FreeOracle Database 12c development best practices and performance guide
FreeFree tier
About Oracle Database Development Guide
A comprehensive guide for Oracle Database development, covering design fundamentals (performance, scalability, extensibility, security, availability, portability, diagnosability), advanced features (SQL analytic functions, materialized views, partitioning, temporal validity), and performance optimization tools (SQL Trace, EXPLAIN PLAN, ADDM, advisors). Includes in-depth coverage of client result cache, statement caching, database resident connection pooling (DRCP), runtime connection load balancing, and other scalability features. Part of the Oracle Database 12c documentation set.
Key Features
Design guidance for performance, scalability, extensibility, security, availability, portability, and diagnosability
Performance tools: SQL Trace, EXPLAIN PLAN, DBMS_APPLICATION_INFO, ADDM, advisors
Client result cache with deployment-time settings and validation methods
Statement caching and OCI client statement cache auto-tuning
Database Resident Connection Pool (DRCP) configuration and best practices
Runtime connection load balancing for OCI, OCCI, and JDBC
Advanced SQL features: analytic functions, materialized views, partitioning, temporal validity
Query change notification and instrumentation support
Pros & Cons
Pros
- Comprehensive and authoritative, directly from Oracle
- Covers both design principles and practical implementation details
- Includes specific configuration examples and best practices
- Free and open access as part of Oracle documentation
- Covers advanced performance features like DRCP and result cache
Cons
- Targeted at Oracle Database 12c, may not cover newer versions
- Not an interactive tool; requires manual study and application
- Assumes familiarity with SQL and database concepts
- Lacks hands-on tutorials or labs
Best For
Learning Oracle Database application design and developmentPerformance tuning and scalability optimization of Oracle databasesReference for implementing secure and available database applicationsUnderstanding and configuring client result cache and connection poolingDatabase development for OLTP and data warehousing environments
FAQ
What topics does the Oracle Database Development Guide cover?
The guide covers design basics (performance, scalability, extensibility, security, availability, portability, diagnosability), performance and scalability tools (SQL Trace, EXPLAIN PLAN, ADDM, advisors), client result cache, statement caching, database resident connection pool, runtime connection load balancing, and advanced SQL features like analytic functions, materialized views, partitioning, and temporal validity.
Is the Development Guide specific to a particular Oracle Database version?
Yes, this guide is for Oracle Database 12c Release 1 (12.1.0.1 and 12.1.0.2).
Does the guide include configuration examples?
Yes, it includes detailed configuration parameters, deployment-time settings, and best practices for features like DRCP, client result cache, and connection load balancing.