单选题
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？（）
单选题查看答案