Posts

Oracle stale stats

Select multiple rows from dual (connect by)

Manual Logmine

12.2 OID standalone server VirtualHost configuation

Function based indexes and or expansion.

Custom logo images in 12c/13c OEM Cloud Control

Ash data summary by partition

Inject hints using manual SQL profiles

Force OR Expansion (OR bind IS NULL condition)

APEX substitution strings

SET_AUDIT_TRAIL_LOCATION tablespace move & capacity calculation