Oracle

Single-column Primary Keys and Histograms in Oracle

Does a single-column primary key need a histogram? That may not be as silly of a …

Trouble with Oracle's DBA_TABLESPACE_USAGE_METRICS For The UNDO Tablespace

Changes in the way Oracle sets the flag value for the UNDO tablespace in version 12.x …

Oracle's Automatic Memory Management and the SPFILE

With Oracle's Automatic Memory Management the spfile is updated with some interesting …

IBM Db2 Query Optimization Using AI

IBM’s machine learning is being used to improve the performance of analytical …

Oracle's Interesting Treatment of IN-LISTS

Whether it's a bug or by design Oracle's 1000-element in-list restriction isn't always …

Is UNION The Best Choice When Joining Result Sets?

Handling Disaster Recovery When Using Oracle Managed Files

Choosing Between Oracle's Bitmap and Function-based Indexes

Oracle provides two ways to create an index that can reliably be used with nulls; a …

Improvements in Oracle's Join Elimination

A GUI Might Not Be An Oracle DBA's Best Friend

Oracle DBAs should know how Oracle behaves and should also be able to address issues …

Hybrid Histograms in Oracle 18

iOracle version 12 introduced the hybrid histogram as a performance improvement. Learn …

Oracle OEM Agent 13c and Perl

Perl can sometimes 'misbehave' with the Oracle Enterprise Manager (OEM) agent for …

Oracle Network Encryption

Oracle provides a method of encrypting networked database connections, with a few …

Tuning Oracle Queries with an Optimizer Trace

Sometimes the obvious isn't when it comes to query performance; that's when event 10053 …

Oracle's LOCAL_TEMP_TABLESPACE

Oracle has provided a new setting, local_temp_tablespace, for RAC installations. …