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
"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