RelationalDBDesign RelationalDBDesign


Oracle Instance  «Prev  Next»

Oracle Shared Pool Tuning - Quiz

Each question is worth one point. Select the best answer for each question.
 
1. What is one way you can minimize the reparsing of SQL statements?
Please select the best answer.
  A. Make all SQL use literal variables
  B. Write SQL statements to execute correlated subqueries
  C. Try to write all SQL so that it can be shared by multiple tasks.
  D. Try to make all SQL execute through ODBC

2. Preventing SQL reloads is a tuning strategy you would use for which area of the SGA?
Please select the best answer.
  A. Session memory
  B. The library cache
  C. The redo log buffer
  D. The data dictionary cache

3. A low pin hit ratio indicates that you should:
Please select the best answer.
  A. Increase the db_block_size parameter
  B. Flush the library cache of non-reusable SQL statements
  C. Increase the number of packages pinned in the shared pool
  D. Increase the shared_pool_size init.ora parameter

4. Cached cursors on the server can result in:
Please select the best answer.
  A. More memory usage in the PGA
  B. More memory usage in the UGA
  C. Memory being freed up in the SGA
  D. Memory being freed up in the UGA
Score =
Correct answers: