When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?()
A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
B The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
C The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
D The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
正确答案
答案解析
相似试题
(单选题)
What happens when you run the SQL Tuning Advisor with limited scope?()
(单选题)
Which statement is true when you run the SQL Tuning Advisor with limited scope?()
(单选题)
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
(单选题)
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()
(单选题)
When creating a SQL tuning set,which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?()
(多选题)
What happens when you run the SQL Tuning Advisor with limited scope?()
(单选题)
When a repeating timer expires,().
(多选题)
When does a transaction complete?()
(单选题)
You want the size of the tablespace to increase when it is full. Which option would you use?()