Run the SQL Access Advisor
Run the Memory Advisor for the sga.
Run the Memory Advisor for the pga.
Run the Memory Advisor for the shared pool.
Run the Memory Advisor for the buffer cache
第1题:
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components?()
第2题:
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()
第3题:
A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?()
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
第4题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第5题:
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()
第6题:
You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()
第7题:
Which statement is true about the Manageability Monitor (MMON) background proces()
第8题:
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()
第9题:
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()
第10题:
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()