Mastering Oracle 11g Reference Partition: Step‑by‑Step Experiments and Insights

This article walks through Oracle 11g's Reference Partition feature, demonstrating table creation, handling ORA‑14652 errors, inserting data, and analyzing partition alignment between master and detail tables to reveal performance and management benefits.

11gOracleReference Partition

0 likes · 10 min read

Mastering Oracle 11g Reference Partition: Step‑by‑Step Experiments and Insights

ITPUB

Jun 29, 2016 · Databases

Why Oracle 11g Uses Direct Path Reads for Full Table Scans and How to Tune Them

The article explains how Oracle 11g may bypass the buffer cache with direct path reads during full table scans, lists common causes such as large sorts, hash joins, and parallel queries, and shows how hidden parameters like _serial_direct_read can be adjusted to improve performance.

10g11gDirect Path Read

0 likes · 4 min read

Why Oracle 11g Uses Direct Path Reads for Full Table Scans and How to Tune Them

dbaplus Community

Nov 3, 2015 · Databases

Should You Upgrade Oracle 10gR2 to 11g? Pros, Cons, and Practical Tips

A community discussion weighs the benefits and drawbacks of upgrading Oracle 10gR2 to 11g, sharing real‑world experiences, technical pitfalls like ORA‑24247, alternative viewpoints, and guidance for DBAs deciding whether the upgrade is worth the effort.

10g11gDBA

0 likes · 8 min read

Should You Upgrade Oracle 10gR2 to 11g? Pros, Cons, and Practical Tips