单项选择题

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

单项选择题YoufindpocketsofemptyspaceintheUSER_DATAtablespaceduetoalotofDMLoperationsontheobjectsintheUSER_DATAtablespace.Thepocketsofemptyspacesaretoosmalltobereusedindividually.Thisisleadingtowastageofspace.Youdecidetoperformtheshrinkoperationtoreclaimthewastedspace.WhichadvisorwillyouusetodeterminetheobjectsintheUSER_DATAtablespacethataregoodcandidatesfortheshrinkoperation？（）

A. SQL Tuning Advisor
B. SQL Access Advisor
C. Undo Advisor
D. Segment Advisor

单项选择题YouaremaintainingtheSALESdatabaseforeSoftCorporation.YouhavenotconfiguredASMMonthedatabase.YouwanttoknowwhatsizeoftheSGAwillprovidethebestperformance.WhichadvisorwouldyouusetodeterminethesuitablesizeoftheSGA？（）

A. SQL Tuning Advisor
B. Undo Advisor
C. ADDM
D. Memory Advisor