OCP 10 Performance Enhancements

Card Set Information

Author:
Tralala
ID:
213629
Filename:
OCP 10 Performance Enhancements
Updated:
2014-05-14 12:23:45
Tags:
OCP 10 Performance Enhancements
Folders:

Description:
OCP 10 Performance Enhancements
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. Which argument of the INSERT_FINDING_DIRECTIVE allows you to specify a particular finding type to exclude from the ADDM analysis report?
    The finding argument
  2. When using the INSERT_FINDING_DIRECTIVE procedure, what is the result of specifying NULL for the TASK_NAME argument?
    The directive will be for all ADDM tasks that are created after the procedure call.
  3. To which value should you set the MEMORY_TARGET initialization parameter?
    The sum of the values of the SGA_TARGET and PGA_AGGREGATE target parameters
  4. If MEMORY_TARGET is set to a 600M, SGA_TARGET is set to 320M, and PGA_AGGREGATE_TARGET is not set, to what value is PGA_AGGREGATE_TARGET set?
    280M (MEMORY_TARGET - SGA_TARGET)
  5. To what value does MEMORY_TARGET default if it is not set?
    A zero value
  6. When Automatic Memory Management is activated, which four SGA memory parameters are not tuned automatically, but can be modified without shutting down the instance?
    DB_KEEP_CACHE_SIZE, DB_RECYCLE_CACHE_SIZE, DB_nK_CACHE_SIZE, and SGA_TARGET
  7. If you gather statistics on a table using GATHER_TABLE_STATS, specifying a GRANULARITY value of AUTO, and the INCREMENTAL value for the partitioned table is set to TRUE, will the entire table be scanned?
    No, only new partitions and modified partitions will be scanned.
  8. What is the result of calling the CREATE_EXTENDED_STATS function of the DBMS_STATS package to create a column group?
    A virtual hidden column is created in the table
  9. When does the optimizer recognize current statistics?
    Immediately after they are captured and stored in the data dictionary
  10. If MEMORY_TARGET is set to a nonzero value, what does the SGA_TARGET parameter represent?
    The minimum size of the SGA
  11. Before gathering statistics for a table using GATHER_TABLE_STATS, which action should you take to ensure the statistics are stored in a pending state and not published?
    Call the SET_TABLE_PREFS procedure of the DBMS_STATS package, passing it a PUBLISH option of FALSE.
  12. What does the value of the MEMORY_TARGET initialization parameter represent?
    The total amount of memory that can be allocated to SGA and PGA memory structures
  13. If MEMORY_TARGET is not set, to what value does MEMORY_MAX_TARGET default?
    A zero value
  14. Which built-in package can you use to help manage ADDM?
    The DBMS_ADDM package
  15. Which procedure of the DBMS_ADDM package should you use to view an ADDM analysis report?
    The GET_REPORT procedure
  16. After gathering pending statistics, which initialization parameter can you set to TRUE to force the optimizer to use pending statistics instead of current statistics?
    The OPTIMIZER_USE_PENDING_STATS initialization parameter
  17. When generating multicolumn statistics, which function of the DBMS_STATS package do you use to create the column group?
    The CREATE_EXTENDED_STATS function
  18. When gathering statistics for a table in Oracle 11g, which type of statistics allow you to indicate to the optimizer the selectivity of a function used as a SELECT statement predicate?
    Expression statistics
  19. Which procedure of the DBMS_ADDM package should you use to schedule an ADDM analysis for a specific database?
    The ANALYZE_DB procedure
  20. When gathering statistics using the GATHER_TABLE_STATS procedure, to which value does the INCREMENTAL value of a partitioned table default?
    FALSE
  21. By default, when does the optimizer recognize pending statistics?
    After they are published using the DBMS_STAT.PUBLISH_PENDING_STATS procedure
  22. With Oracle 11g, which option for the GATHER_*_STATS procedures allows you to specify a percentage threshold at which statistics are considered stale?
    The STALE_PERCENT option
  23. With Oracle 11g, which option for the GATHER_TABLE_STATS procedure allows you to specify that statistics on partitioned tables should be gathered incrementally and avoid capturing statistics for partitions that have had few modifications?
    The INCREMENTAL option
  24. When Automatic Memory Management is activated, which two SGA memory parameters are static and cannot be modified without shutting down the instance?
    • LOG_BUFFER
    • SGA_MAX_SIZE
  25. What is the result of using the SET_TABLE_PREFS procedure to set the PUBLISH option for a specific table to FALSE?
    The next statistics captured for the table using GATHER_TABLE_STATS will be pending statistics.
  26. In which location are pending statistics stored?
    In the data dictionary
  27. After testing gathered pending statistics, which procedure of the DBMS_STATS package can you use to publish the statistics as current statistics?
    The PUBLISH_PENDING_STATS procedure
  28. For what purpose would you use the INSERT_FINDING_DIRECTIVE procedure of the DBMS_ADDM package?
    To limit ADDM reporting to specific finding types
  29. For what purpose would you use the INSERT_SEGMENT_DIRECTIVE procedure of the DBMS_ADDM package?
    To suppress ADDM reporting for a specific schema, segment, subsegment, or object
  30. When gathering statistics in Oracle 11g, which type of statistics allow you to indicate to the optimizer that two table columns specified in a WHERE clause are highly correlated?
    Multicolumn statistics
  31. If you omit the PUBLISH option when calling the GATHER_TABLE_STATS procedure of the DBMS_STATS package, are the statistics captured pending or current by default?
    Current
  32. If MEMORY_MAX_TARGET is set to a value greater than zero, to what value can MEMORY_TARGET be increased?
    The value of MEMORY_MAX_TARGET
  33. If MEMORY_TARGET is set to a nonzero value, how does Oracle allocate memory to SGA and PGA structures?
    It automatically resizes the SGA and PGA as needed.
  34. Which parameter, when set, prevents the use of the MEMORY_TARGET and MEMORY_MAX_TARGET initialization parameters?
    The LOCK_SGA parameter
  35. In Oracle 11g, which two types of extended statistics can you gather?
    Multicolumn and expression statistics
  36. Which function of the DBMS_STATS package can you use to compare pending and current statistics?
    The DIFF_TABLE_STATS function
  37. Which status value must a task have to successfully create a directive for it using the INSERT_FINDING_DIRECTIVE procedure?
    The INITIAL status

What would you like to do?

Home > Flashcards > Print Preview