When tuning multiple SQL statements, the SQL Tuning Advisor does not recognize interdependencies between the SQL solves SQL performance problems by identifying problems with individual SQL statements, such as a poorly performing optimizer plan or the mistaken use of certain SQL structures.
By default, ADDM runs proactively once every hour, and it analyzes key statistics gathered by the Automatic Workload Repository (AWR) over the last hour to identify any performance problems, including high-load SQL performance problems are identified by ADDM, they are displayed as ADDM findings in the Automatic Database Diagnostic Monitor (ADDM) page. ADDM provides recommendations with each ADDM finding. When a high-load SQL statement is identified, ADDM will give appropriate recommendations, such as running the SQL Tuning Advisor on the SQL statement, and tuning can begin as described in Tuning SQL Statements.
Buradaki örnekler sizlere yalnızca aradığınız sözcük ve ifadeyi çevirmede yardımcı olmak için verilmiştir. Örnekler bizim tarafımızdan seçilmiş veya teyit edilmiş değildir. Mevcut örnekler uygunsuz bir dil içeriyor olabilir. Potansiyel olarak hassas, uygunsuz veya günlük konuşma dili çeviriler genellikle kırmızı ya da turuncu renkle işaretlenir.