Over the years, as I used to read various Oracle white papers I observed two things.
1) They were often PDFs prefixed with the acronym “twp”, which I assume (without confirmation) stands for “technical white paper”
2) They were often hard to find more than once
Typically I hence would either bookmark them, or download them, which simply ended up shifting the “find the file” problem to my own PC with its shambles of file organisation.
So I bit the bullet and tried to catalog the white papers (now we call them “technical briefs”) here on the blog mainly so that I can find them again, but hopefully this page might help you as well.
Explain the Explain Plan – Oracle
Oracle MAA Best Practices for Oracle Cloud Backups
Understanding Optimizer Statistics with Oracle Database 12c
Optimizer with Oracle Database 12c
Using Oracle Database Resource Manager
Parallel Execution with Oracle Database
Best Practices for Gathering Optimizer Statistics with Oracle …
When to Use Oracle Database In-Memory
White paper: Oracle XML DB in Oracle Database
Oracle Advanced Security Transparent Data Encryption Best …
Oracle Database In-Memory with Oracle Database 19c
Upgrade and Migrate to Oracle Database 19c
Oracle Database 10g: Building GIS Applications
Oracle Database Backup To Cloud: Amazon Simple Storage …
Oracle Database 11g Workspace Manager Overview
Zero Data Loss Recovery Appliance – Oracle
Understanding Optimizer Statistics – Oracle
Oracle Database Vault DBA Administrative Best Practices
Oracle Database 10G SQL Model Clause
Integrating Hadoop Data with Oracle Parallel Processing
Oracle Database Auditing: Performance Guidelines
Hadoop and NoSQL Technologies and the Oracle Database
Database Vault Best Practices – Oracle
And some PDFs from the MAA page, brought to my attention from a reader (see comment below)
Oracle Database 19c and later
Maximum Availability Architecture (MAA) – On-Premises HA Reference Architectures (PPT)
White Paper: Oracle Maximum Availability Architecture 19c Overview
OOW 2019 Presentation: Maximum Availability Architecture – Best Practices for Oracle Database 19c
OOW 2019 Presentation: Oracle MAA for Oracle Database, Exadata, and the Cloud
Oracle Maximum Availability Architecture (MAA) GoldenGate Hub
Oracle Database Migration with an Oracle GoldenGate Hub Configuration
Oracle Multitenant MAA Best Practices
Application Continuity for the Oracle Database
Continuous Availability – Application Checklist for Continuous Service for MAA Solutions
Maximum Availability Architecture Best Practices for Database Consolidation
Oracle Database 12c & 12c Release 2
Oracle Database In-Memory, High Availability Best Practices
Preventing, Detecting, and Repairing Block Corruption – Oracle Database 12c
Role Transition Best Practices: Data Guard and Active Data Guard
Full-Stack Role Transitions – Oracle DBFS and Data Guard
Full-Stack Role Transitions – Oracle ACFS and Data Guard
Best Practices for Data Guard and Active Data Guard Redo Apply Performance
Best Practices for Asynchronous Redo Transport – Data Guard and Active Data Guard
Best Practices for Synchronous Redo Transport – Data Guard and Active Data Guard
Best Practices for Automatic Resolution of Outages to Resume Data Guard Zero Data Loss Protection
Oracle Active Data Guard Far Sync – Zero Data Loss at Any Distance
Database Rolling Upgrade using Data Guard
Automated Database Upgrades using Oracle Active Data Guard and DBMS_ROLLING
Converting to Transparent Data Encryption with Oracle Data Guard using Fast Offline Conversion
Oracle GoldenGate Performance Best Practices
Oracle GoldenGate With Oracle Real Application Clusters Configuration
Transparent Role Transitions with Oracle Data Guard and Oracle GoldenGate
Oracle Global Data Services (GDS) MAA Best Practices
Oracle Sharding MAA Best Practices
Oracle Database 11g
Preventing, Detecting, and Repairing Block Corruption: Oracle Database 11g
Database Cloning using Oracle Sun ZFS Storage Appliance and Oracle Data Guard
Database Cloning using Oracle Sun ZFS Storage Appliance and Oracle Recovery Manager
Oracle GoldenGate Performance Best Practices
Oracle GoldenGate With Oracle Real Application Clusters Configuration
Transparent Role Transitions with Oracle Data Guard and Oracle GoldenGate
Best Practices for Data Guard and Active Data Guard Redo Apply Performance
Best Practices for Asynchronous Redo Transport – Data Guard and Active Data Guard
Best Practices for Synchronous Redo Transport – Data Guard and Active Data Guard
Best Practices for Automatic Resolution of Outages to Resume Data Guard Zero Data Loss Protection
Role Transition Best Practices: Data Guard and Active Data Guard
Full-Stack Role Transitions – Oracle ACFS and Data Guard
Client Failover Best Practices for Data Guard 11g Release 2
Database Rolling Upgrade using Data Guard
Active Data Guard 11g Best Practices (includes best practices for Redo Apply)
Configuring Oracle TopLink Applications with Oracle Active Data Guard
Configuring Oracle Business Intelligence Enterprise Edition Server with Oracle Active Data Guard
Rapid Oracle RAC One Node Standby Deployment: Oracle Database 11g Release 2
Converting to Transparent Data Encryption with Oracle Data Guard using Fast Offline Conversion
SQL Apply Best Practices – Data Guard 11g
Extended Datatype Support using SQL Apply
Database Upgrade Using Transportable Tablespaces: Oracle Database 11g
Platform Migration Using Transportable Tablespaces: Oracle Database 11g
Seems like a good use case for APEX with a faceted search.
Holy cow, you put together a long list. Thanks, this will definitely be useful for others as well.
This page has a lot of links, although only for MAA TWPs: https://www.oracle.com/database/technologies/high-availability/oracle-database-maa-best-practices.html
Thanks. Excellent resource