单项选择题
You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()
A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.
点击查看答案
相关考题
-
单项选择题
Whilerunninglongrunningqueries,youreceivetheSnapshottooolderror.WhichadvisorcanhelpyoutoavoidtheSnapshottooolderror?()
A. Memory Advisor
B. Segment Advisor
C. Undo Advisor
D. SQL Tuning Advisor -
单项选择题
WhichcomponentdoestheSQLTuningAdvisorNOTanalyzefortheSQLstatements?()
A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area -
单项选择题
Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedonthetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor?()
A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR
