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
正确答案
答案解析
相似试题
(多选题)
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
(单选题)
While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish?()
(单选题)
While creating a job class using the DBMS_SCHEDULER package, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?()
(多选题)
Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode?()
(单选题)
Which statement is true while creating subplans using Resource Manager?()
(多选题)
Which three pieces of information are considered while deciding the size of the undo tablespace in your database?()
(单选题)
You want to create a temporary table while executing a procedure in a form. Which statement is true?()
(多选题)
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()
(单选题)
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()