Similarly, APPROX_MEDIAN and APPROX_PERCENTILE are life-savers for financial reporting:
SET LONG 1000000 SELECT DBMS_ADDM.REAL_TIME_ADDM_REPORT(240) FROM DUAL;
In 12.2, you can materialize frequently used expressions. If your financial reports frequently calculate COMMISSION * SALES , you can designate this expression as an "In-Memory Virtual Column." Oracle will pre-calculate and store the result in the In-Memory Column Store (IMCS), turning a CPU-intensive calculation into a simple retrieval operation.
SELECT INST_ID, SID, SQL_ID, EVENT, BLOCKING_SESSION_STATUS FROM GV$SESSION WHERE STATE = 'WAITING' AND BLOCKING_SESSION IS NOT NULL;
In 12c Release 2, you can allocate