New Features in Oracle Database 10g Release 2


Oracle Database 10g Release 2 promises quite a few additions for SQL tuning. For example, the OEM has been enhanced to provide a better user experience and to expose more powerful features of the SQL Access Advisor. Recommendation and action implementation statuses are now available. In addition, SQL Access Advisor will be able to recommend function-based indexes. SQL profiles have also been enhanced to match SQL text with literal values by normalizing them into bind variables. As well, SQL profiles and SQL tuning sets are transportable across databases so you can easily test production scenarios in development instances.



    Oracle Database 10g Insider Solutions
    SUSE LINUX Enterprise Server 9 Administrators Handbook
    ISBN: 672327910
    EAN: 2147483647
    Year: 2006
    Pages: 214

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net