摘要：
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 阅读全文
posted @ 2017-12-07 11:26
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_ 阅读全文
posted @ 2017-12-07 11:16
巴啦啦大魔王
阅读(95)
评论(0)
推荐(0)
摘要：
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.The ADDM requires at least four AWR snapshots for 阅读全文
posted @ 2017-12-07 11:06
巴啦啦大魔王
阅读(92)
评论(0)
推荐(0)
摘要：
Which statement is true about the Manageability Monitor (MMON) background process?A.It transfers statistics from memory to disk at regular intervals.B 阅读全文
posted @ 2017-12-07 10:58
巴啦啦大魔王
阅读(73)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-07 10:53
巴啦啦大魔王
阅读(88)
评论(0)
推荐(0)
摘要：
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?A.Optimizer statistics ar 阅读全文
posted @ 2017-12-07 10:48
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Examine the command:SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');Which statement describes the effect of the above command?A 阅读全文
posted @ 2017-12-07 10:44
巴啦啦大魔王
阅读(106)
评论(0)
推荐(0)
摘要：
You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on 阅读全文
posted @ 2017-12-07 10:22
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
浙公网安备 33010602011771号