Oracle Magazine, July/August 2019
Database Developer and DBA ETL Id Operation Name Str E Rows A Rows A Time Buffers OMem 1Mem Used Mem 0 SELECT STATEMENT 1 5 0001 12 1 HASH GROUP BY 1 1 5 0001 12 1200K 1200K 897K 0 2 HASH JOIN 1 1 6 0001 12 1572K 1572K 959K 0 3 TABLE ACCESS FULL JOB_ HISTORY 1 1 10 0001 6 4 TABLE ACCESS FULL EMPLOYEES 1 1 107 0001 6 ORACLE MAGAZINE JULY AUGUST 2019 151 Predicate Information identified by operation id 2 access E EMPLOYEE_ ID J EMPLOYEE_ ID filter J START_ DATE E HIRE_ DATE 3 filter J END_ DATE INTERNAL_ FUNCTION J START_ DATE 1 4 filter EXTRACT YEAR FROM INTERNAL_ FUNCTION E HIRE_ DATE 1985 Note this is an adaptive plan Even richer functionality is available with the Real Time SQL Monitoring facility in the optional Oracle Tuning Pack for Oracle Database Enterprise Edition The same information that can be obtained from DBMS_ XPLAN DISPLAY_ CURSOR can be extracted and presented in graphical form with Oracle Enterprise Manager or via the DBMS_ SQL_ MONITOR REPORT_ SQL_ MONITOR package For SQL statements that run for more than 10
You must have JavaScript enabled to view digital editions.