YouaremaintainingtheSALESdatabaseforeSoftCorporation.Yo

单项选择题

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？（）

单项选择题 YouarecreatingaSQLTuningSettoallowagroupofSQLstatementstobepassedintotheSQLTuningAdvisor.WhichpackageswillyouusetocreatetheSQLTuningSet？（）

单项选择题 Youcreateatableinyourdatabasethatcontains50，000rowsapproximately.Thequeriesperformedonthetablearecomplexandperformedonthetablefrequently.Whichadvisorhelpsyouachievethebestperformanceofdatabaseforqueriesbyrecommendingtheappropriateindexes？（）

1z0-043