Tabla de Contenidos: “…EXPLAIN PLAN May Be MisleadingDisplaying Output from the Cursor Cache; Displaying Execution Plans from the AWR; Understanding Operations; What an Operation Does; How Operations Interact; Operation 0: SELECT STATEMENT; Operation 1: SORT AGGREGATE; Operation 2: TABLE ACCESS FULL; Operation 3: HASH JOIN; Operations 4 and 5: TABLE FULL SCANs; How Operations Interact Wrap Up; How Long Do Operations Take?; Summary; Chapter 4: The Runtime Engine; Collecting Operation Level Runtime Data; The GATHER_PLAN_STATISTICS Hint; Setting STATISTICS_LEVEL=ALL; Enabling SQL Tracing…”