随笔分类 -  ocp_AWR

053-24
摘要：Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that 阅读全文
posted @ 2018-01-05 17:43 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
053-11
摘要：View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric? A. Oracle 阅读全文
posted @ 2017-12-20 16:54 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
053-2
摘要：You plan to have a larger moving window size for the default system-defined moving window baselinebecause you want to use the adaptive threshold.Which 阅读全文
posted @ 2017-12-18 17:10 巴啦啦大魔王 阅读(173) 评论(0) 推荐(0)
053-1
摘要：1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new S 阅读全文
posted @ 2017-12-18 17:04 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-49
摘要：View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:SQL> SELECT reason,met 阅读全文
posted @ 2017-12-07 11:35 巴啦啦大魔王 阅读(77) 评论(0) 推荐(0)
052-47
摘要：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)
052-46
摘要：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 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
052-45
摘要：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)
052-44
摘要：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)
052-43
摘要：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)
052-2
摘要：Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A. All AWR tables belong to the SYSTEM schemaB. The AWR cont 阅读全文
posted @ 2017-11-30 18:27 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0)