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.

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.


相关考题:

”You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would

7. If I _______ you,l_______ take an umbrella with me.A. was ; shouldB. was ; wouldC. were ; willD. were ; would

Ifyoudon’tliketoswim,you_____aswellstayathome.A)shouldB)mayC)canD)would

"You _________ finish your homework before the dinner." said mother. A.shouldB.have toC.mustD.would

企业信息安全策略必须通过循环的修正才能进一步完善,这个循环是:()A、Plan->Do->Action->CheckB、Do->Plan->Action->CheckC、Plan->Do->Check->ActionD、Do->Action->Check->Plan

Inyourdatabase,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting?() A.Theoptimizerstatisticsarecollectedautomatically.B.Onlythetimedoperatingsystem(OS)statisticsandplanexecutionstatisticsarecollected.C.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.D.ThesnapshotsfortheAutomaticWorkloadRepository(AWR)arenotgeneratedautomatically.E.SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE.

inyourdatabaseinstance,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting() A.Optimizerstatisticsarecollectedautomatically.B.Onlytimedoperatingsystem(OS)statisticsandplanexecutionstatisticsarecollected.C.ThesnapshotsfortheAutomaticWorkloadRepository(AWR)arenotgeneratedautomatically.D.SnapshotscannotbecollectedmanuallybyusingtheDBMS_WORKLOAD_REPOSITORYpackage.E.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.

YouworkasadatabaseadministratorforSupportcenter.cn.YouhavesettheretentionperiodforAutomaticRepository(AWR)statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics?()A.useenterprisemanagerB.useDBMS_SQLpackageC.useDBMS_AWRpackageD.usePRVT_WORKLOADpackageE.querytheAWRsnapshotrepositoryobjectsF.useDBMS_WORKLOAD_REPOSITORYpackage

Thefollowingcommandisexecutedtocreatethebaselinetemplate:SQLEXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=TO_TIESTAMP(SYSDATE+2),END_TIME=TO_TIMESTAMP(SYSDATE+10),BASELINE_NAME=’Mybase4’,TEMPLATE_NAME=’Mytemp4’,EXPIRATION=NULL);Whichstatementistrueabouttheeffectoftheabovecommand?()A.Itcreatesabaselinetemplatethatneverexpires.B.Itproducesanerrorbecausenosnapshotinformationisprovidedtocreatethebaseline.C.ItcreatesabaselinetemplatethatexpiresaftertheAutomaticWorkloadRepository(AWR)retentionperiod.D.ItcreatesarepeatingbaselinetemplatethatrepeatsaftertheAutomaticWorkloadRepository (AWR)retentionperiod.

“You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would