Oracle Magazine, July/August 2019
Database Developer and DBA ETL the SQL tuning process so how does a developer get access to it V SQL_ PLAN is the performance view shown in Listing 3 that exposes the true execution plan that was used and this can be queried for the plan of a SQL statement identified by its SQL_ ID and CHILD_ NUMBER values Listing 3 The V SQL_ PLAN performance view holding execution plans for each SQL statement in the library cache ORACLE MAGAZINE JULY AUGUST 2019 140 SQL desc V SQL_ PLAN Name Null Type ADDRESS RAW 8 HASH_ VALUE NUMBER SQL_ ID VARCHAR2 13 PLAN_ HASH_ VALUE NUMBER FULL_ PLAN_ HASH_ VALUE NUMBER CHILD_ ADDRESS RAW 8 CHILD_ NUMBER NUMBER TIMESTAMP DATE OPERATION VARCHAR2 30 OPTIONS VARCHAR2 30 OBJECT_ NODE VARCHAR2 40 OBJECT NUMBER OBJECT_ OWNER VARCHAR2 128
You must have JavaScript enabled to view digital editions.