多项选择题
Which three statements correctly describe the features of the I/O calibration process？（）
A. Only one I/O calibration process can run at a time
B. It automates the resource allocation for the Automated Maintenance Tasks
C. It improves the performance of the performance-critical sessions while running
D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system
E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE
相关考题
-
单项选择题
Examine the parameter setting in your database: Which statement is correct about the database?（）
A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup -
单项选择题
You run the SQL Tuning Advisor （STA） to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement，which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile？（）
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan. -
单项选择题
You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?（）
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
