Oracle Magazine, July/August 2019
Database Developer and DBA ETL ment the SQL_ ID can be used to interrogate the database to determine the runtime statistics For the problematic SQL statement run earlier Listing 6 shows how to get the runtime statistics by locating the SQL_ ID from V SQLSTATS Listing 6 Obtaining estimated versus actual statistics for a known SQL_ ID ORACLE MAGAZINE JULY AUGUST 2019 150 SQL select sql_ id sql_ text from v sqlstats 2 where sql_ text like extract year SQL_ ID SQL_ TEXT 1afzpsbuadkbs select sql_ id sql_ text from v sqlstats where sql_ text like ex tract year ct38j4c0rbhnj select e department_ id sum salary from employees e j ob_ history j where e employee_ id j employee_ id and extract year from e hire_ date 1985 and j end_ date j start_ date 1 and j start_ date e hire_ date group by e department_ id SQL select 2 from table dbms_ xplan display_ cursor sql_ id cx025dqycvcmy format ALLSTATS LAST PLAN_ TABLE_ OUTPUT
You must have JavaScript enabled to view digital editions.