摘要：
Data Recovery AdvisorReducing down time by eliminating confusion:Data FailuresData Failure:ExamplesNot accessible components,for example:Missing data files at the OS levelIncorrect access permissionsOffline tablespace,and so onPhysical corruptions,such as block checksum failures or invalid block hea 阅读全文
摘要：
oracle 10g、11g能够做到恢复指定的、被破坏的块.ObjectivesAfter completing this lesson,you should be able to :Detect and repair database corruptionHandle block corruptionSet up Automatic Diagnostic RepositoryRun health checksData Recovery AdvisorFast detection,analysis,and repair of failuresMinimizing disruptions for 阅读全文
摘要：
SQL Performance Analyzer : OverviewTarget users:DBAs,QAs,application developersHelps predict the impact of system changes on SQL workload response time.Builds different versions of SQL workload performance (that is,SQL execution plans and execution statistics)Executes SQL serially(concurrency not ho 阅读全文
摘要：
SQL Access Advisor:OverviewTypical SQL Access Advisor SessionWorkload SourceRecommendation OptionsReviewing Recommendations 阅读全文
摘要：
Using the SQL Tuning AdvisorUse the SQL Tuning Advisor to analyze SQL statements and obtain performance recommedationsSources for SQL Tuning Advisor to analyze:Top Activety:Analyzes the top SQL statements currently activeSQL Tuning Set:Analyzes a set of SQL statements you provideHistorical SQL(AWR): 阅读全文