单项选择题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）
A. SQL Tuning Advisor
B. Undo Advisor
C. ADDM
D. Memory Advisor
点击查看答案
相关考题
-
单项选择题
You accepted the recommended SQL Profile by executing the following code： DECLARE sqlprofile_name varchar2（30）； BEGIN sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name => ’my_task’， profile_name => ’my_profile’）； END； Which advisor will analyze this profile？（）
A. SQL Access Advisor
B. Undo Advisor
C. Segment Advisor
D. SQL Tuning Advisor -
单项选择题
YouarecreatingaSQLTuningSettoallowagroupofSQLstatementstobepassedintotheSQLTuningAdvisor.WhichpackageswillyouusetocreatetheSQLTuningSet？（）
A. DBMS_WORKLOAD_REPOSITORY
B. DBMS_RESOURCE_MANAGER
C. DBMS_SQLTUNE
D. DBMS_ADVISOR -
单项选择题
Youcreateatableinyourdatabasethatcontains50，000rowsapproximately.Thequeriesperformedonthetablearecomplexandperformedonthetablefrequently.Whichadvisorhelpsyouachievethebestperformanceofdatabaseforqueriesbyrecommendingtheappropriateindexes？（）
A.SQL Access Advisor
B. Memory Advisor
C.SQL Tuning Advisor
D. Segment Advisor
