Oracle Magazine, May/June 2019
Database Developer and DBA ETL statements that are the cause of poor response times for those business functions Now that the SQL statements have been identified I recommend performing one extra step before diving into tuning techniques and that is to expand the SQL text Expanding a SQL statement reveals what the database will truly be running when it is presented with the text of that SQL statement For example if I have a simple query ORACLE MAGAZINE MAY JUNE 2019 113 SQL select from EMP_ LIST it is only through my prior knowledge that I created a synonym via SQL create synonym EMP_ LIST as SCOTT EMP that I know that I am actually querying the SCOTT EMP table Rather than taking each referenced object in the SQL statement and digging into the data dictionary to see if that object is a synonym or a view and recursively continuing that process until all objects are resolved I can use the supplied DBMS_ UTILITY database package to expand a SQL statement to reveal what the database will ultimately see Listing 2 uses the above query as an example Listing 2 Expanding the SQL text of a statement SQL variable c clob SQL begin 2 dbms_ utility expand_ sql_ text 3 select from EMP_ LIST c
You must have JavaScript enabled to view digital editions.
