Students learn the benefits of Oracle 11g powerful extended PL/SQL functionality by exploring and utilizing advanced Oracle-supplied packages, procedures, REF cursors, extended interface methods, ...

This article explores the internals of Oracle9i indexing; reviews the standard b-tree index, index-only tables, and how these indexes may increase the speed of Oracle SQL queries.

Nearly one year after introducing the X9M, Oracle has teamed up with Advanced Micro Devices Inc. to leverage the chipmaker’s EPYC processor and extend the capabilities of its enterprise database.

DB Optimizer 2.0 takes SQL tuning beyond standard hint injections and SQL rewrites by offering advanced features such as Index Analysis and VST diagrams. With the new DB Optimizer 2.0, "we have ...

Available as a separately licensed option for Oracle Database 11g Enterprise Edition, Advanced Compression is a way of writing data to disk so that it takes up less space ...