摘要：
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of t 阅读全文
摘要：
Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_ 阅读全文
摘要：
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.The ADDM requires at least four AWR snapshots for 阅读全文
摘要：
Which statement is true about the Manageability Monitor (MMON) background process?A.It transfers statistics from memory to disk at regular intervals.B 阅读全文
摘要：
Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be 阅读全文
摘要：
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?A.Optimizer statistics ar 阅读全文
摘要：
Examine the command:SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');Which statement describes the effect of the above command?A 阅读全文
摘要：
You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on 阅读全文