SQL Profiles in the Data Dictionary

Published 19 August 08 09:40 | Striving for Optimal Performance
In the paper SQL Profiles (page 22) I described the data dictionary tables where the hints belonging to SQL profiles are stored. For example, with the following query it is possible to display the hints associate to the SQL profile named opt_estimate. SQL> SELECT attr_val 2 FROM sys.sqlprof$ p, sys.sqlprof$attr a 3 [...]

Lesen Sie den vollständigen Eintrag unter http://antognini.ch/2008/08/sql-profiles-in-data-dictionary/

Abgelegt unter: , , ,