单项选择题
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
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
