Initially，fortheAutomaticWorkloadRepository（AWR）statistics，theretentionperiodissetto7days，thecollectionintervalissetto30minutesandthecollectionlevelissettoTypicalinyourproductiondatabase.YouhavebeenusingtheMemoryAdvisorforthelastthreemonthstogeneraterecommendationsfortuningmemorycomponents.However，whenyouobservetheMemoryAdvisoronaFriday，youfindthatthestatisticsareavailableonlyfortwodays，ThursdayandFriday，ofthatweek.Whatwouldhavecausedthestatisticstoberemoved？（）
Initially，fortheAutomaticWorkloadRepository（AWR）statistics，theretentionperiodissetto7days，thecollectionintervalissetto30minutesandthecollectionlevelissettoTypicalinyourproductiondatabase.YouhavebeenusingtheMemoryAdvisorforthelastthreemonthstogeneraterecommendationsfortuningmemorycomponents.However，whenyouobservetheMemoryAdvisoronaFriday，youfindthatthestatisticsareavailableonlyfortwodays，ThursdayandFriday，ofthatweek.Whatwouldhavecausedthestatisticstoberemoved？（）
相关考题：
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
Which statements are true regarding the system－defined moving window baseline in Oracle Database 11g?() A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default with the window size being equal to the AWR retention time.D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?() A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Decrease the expiration time for the baseline.
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.() A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance？（）A.runSegmentAdvisorB.runSQLTuningAdvisorontopSQLstatementsC.runtheAutomaticWorkloadRepository（AWR）reportD.runtheAutomaticDatabaseDiagnosticMonitor（ADDM）ontopSQLstatements
WhichtwostatementsaretrueabouttheAutomaticWorkloadRepository(AWR)() A.AllAWRtablesbelongtotheSYSTEMschema.B.TheAWRcontainssystemwidetracingandlogginginformation.C.ThesnapshotscollectedbytheAWRareaccessiblethroughdatadictionaryviews.D.ThesnapshotscollectedbytheAWRareusedbyself-tuningcomponentsinthedatabase.
在oracle数据库中,关于数据库ADDM说法正确的两项是()。 A.ADDM的分析结果存储在AWR报告中B.如果需要，ADDM调用其他顾问，但不提供顾问建议C.ADDM运行在mmon自动采集AWR快照之后D.ADDM分析只提供诊断信息，但不提供建议E.ADDM分析需要最近的4个AWR快照
［A］creatively ［B］originally ［C］authentically ［D］initially