Which three statements are true about Automatic Workload Repository (AWR)?()A. All AWR tables belong to the SYSTEM schema.B. The AWR data is stored in memory and in the database.C. The snapshots collected by AWR are used by the self-tuning components in t

题目
Which three statements are true about Automatic Workload Repository (AWR)?()

A. All AWR tables belong to the SYSTEM schema.

B. The AWR data is stored in memory and in the database.

C. The snapshots collected by AWR are used by the self-tuning components in the database

D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.

相似考题

1.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

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

3.YouworkasadatabaseadministratorforSupportcenter.cn.YouhavesettheretentionperiodforAutomaticRepository（AWR）statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics？（）A.useenterprisemanagerB.useDBMS_SQLpackageC.useDBMS_AWRpackageD.usePRVT_WORKLOADpackageE.querytheAWRsnapshotrepositoryobjectsF.useDBMS_WORKLOAD_REPOSITORYpackage

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

更多“Which three statements are true about Automatic Workload Repository (AWR)?() ”相关问题

  • 第1题：

    Thefollowingcommandisexecutedtocreatethebaselinetemplate：SQL>EXECUTEDBMS_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.


    参考答案：A

  • 第2题：

    YouworkasadatabaseadministratorforCertkiller.com.YouhavesettheretentionperiodforAutomaticRepository（AWR）statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics？（）

    A.useenterprisemanager

    B.useDBMS_SQLpackage

    C.useDBMS_AWRpackage

    D.usePRVT_WORKLOADpackage

    E.querytheAWRsnapshotrepositoryobjects

    F.useDBMS_WORKLOAD_REPOSITORYpackage


    参考答案：A, F

  • 第3题：

    Despite the wonderful acting and well-developed plot the _________ movie could not hold our attention.

    A) three-hours B) three-hour

    C) three-hours’ D) three-hour’s

     

     


    选B

     用破折号连接的作形容词不用复数.

  • 第4题：

    Youhavecreatedabaselinemetric，DISK_IO_BL，forthediskI/OmetricsinyourPRODdatabaseandyouhavebeengettingnotificationswheneverthedatabaseperformancedegrades.YouoptimizethedatabaseI/Otogaintheperformanceandyoudecidetoremovethebaselinemetrics.WhichmethodwouldyouusetoremovetheDISK_IO_BLbaselinemetrics？（）

    A.Thebaseline，oncecreated，cannotberemoved.

    B.DisablethebaselinemetricsintheDatabaseControlManageMetricspage.

    C.Thebaselinewillbeautomaticallyremovedoncethedatabaseperformancehasbeenoptimized.

    D.DropthebaselinemetricsbyusingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINEprocedure.


    参考答案：D

  • 第5题：

    oracle数据库中STATISTICS_LEVEL参数被设置为BASIC,此设置的影响?()

    A.只有操作系统的时间和执行计划执行的统计信息被收集

    B.手动无法执行DBMS_WORKLOAD_REPOSITORY生成snapshot

    C.数据库自动收集需要表的统计信息为优化器使用

    D.awr资料库的snapshot不会自动生成

    E.优化器自动收集统计信息


    参考答案：D

  • 第6题：

    Which functionality is required within an IP router that is situated at the boundary of an IPv4 network and an IPv6 network to allow communication between IPv6－ only and IPv4 － only nodes?()

    A. Autoconfiguration

    B. Automatic 6to4 Tunnel

    C. Automatic 6to4 Relay

    D. Network Address Translator - Protocol Translator (NAT - PT)

    E. Intrasite Automatic T unnel Address Protocol (ISATAP)


    参考答案：D

相关内容