Posts

Pull bind values from v$SQL_MONITOR - including timestamp

column low/high values - adding timestamp

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

Utl_raw.cast_to_date & column low/high values

Deadlock while writing to audit trail

ORA-46268: Conflicting operation on audit table(s)

dbms_xplan.display errors

Basic index compression - identify candidates and estimate prefix length

Session Longops with ETA.

Filter by date range based on PK id.