Oracle OCP 9i to 11g Intelligent Infrastructure Enhancements

Card Set Information

Author:
Tralala
ID:
207994
Filename:
Oracle OCP 9i to 11g Intelligent Infrastructure Enhancements
Updated:
2014-06-04 03:13:02
Tags:
Oracle OCP 9i 11g Intelligent Infrastructure Enhancements
Folders:

Description:
Oracle OCP 9i to 11g Intelligent Infrastructure 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. What does AWR do?
    • Collects database performance statistics
    • Access and usage of Database segments
    • Time model stats based on usage for activities in V$SYS_TIME_MODEL
    • Some system stats
    • High load SQL
    • ASH stats representing recent session activity
  2. What are the possible values for the init parameter STATISTICS_LEVEL?
    • BASIC
    • TYPICAL
    • ALL
  3. Which values for STATISTICS_LEVEL will not collect stats for the AWR?
    BASIC
  4. By default, how often are AWR snapshots generated?
    60mins
  5. By default, how long snapshot data retained by the AWR
    8 days
  6. Which tool automatically analyzes snapshot data produced by AWR?
    Automatic Database Diagnostic Monitor (ADDM)
  7. Which package used to manage AWR snapshots?
    DBMS_WORKLOAD_REPOSITORY
  8. Which view shows active database session activity sampled once every second?
    v$ACTIVE_SESSION_HISTORY
  9. How are AWR scripts generated?
    • EM
    • script: ?rdbmsadminawrrpt.sql
  10. What is an Oracle Baseline?
    • Performance from a specific time period.
    • Used for comparison to similar periods to troubleshoot performance issues
  11. How long are Oracle baselines retained by default?
    Indefinitely
  12. What types of baselines are there?
    • Fixed
    • Moving Window
  13. What data does a Moving Window baseline use?
    All the data in the AWR retention period
  14. What are Fixed baselines useful for?
    Tracking performance changes over extended periods of time
  15. What is the default size the system-defined moving window?
    The current AWR retention period...8 days
  16. How is the AWR retention period extended?
    DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(    retention => XXXX) where xx is secs
  17. How are baselines created in the future?
    Using baseline templates
  18. How can baselines created in the future be defined?
    Single and repeating
  19. What are the adaptive thresholds?
    • High 5 in 100 expected to exceed the value
    • Very High 1 in 100 expected to exceed the value
    • Severe 1 in 1000 expected to exceed the value
    • Extreme 1 in 1000 expected to exceed the value
  20. How is a baseline template created?
    DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE
  21. How is a baseline dropped?
    DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE
  22. How is a baseline created?
    DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE
  23. What are the three default Automated Maintenance Tasks?
    • Automatic Optimizer Statistics Collection
    • Automatic Segment Advisor
    • Automatic SQL Tuning Advisor
  24. What does Automatic Optimizer Statistics Collection do?
    Collects stats for objects without stats or stale stats
  25. What does Automatic Segment Advisor do?
    Identifies segments that have space for reclamation
  26. What does Automatic SQL Tuning Advisor do?
    Examines high load SQL and makes recommendations
  27. By default, when does the Predefined Maintenance Window run?
    • Mon-Fri 22.00 to 02.00
    • Sat-Sun 06.00 to 02.00
  28. Which background process manages jobs in the Maintenance Window?
    Autotask Background Process (ABP)
  29. Which feature manages CPU and IO?
    Resource Manager
  30. Which process starts Autotask Background Process (ABP)
    MMON
  31. Which view contains a history of Maintenance Window runs?
    DBA_AUTOTASK_TASK
  32. How is a Maintenance Window Automated task disabled?
    DBMS_AUTO_TASK_ADMIN.DISABLE
  33. How is a Maintenance Window Automated task enabled?
    DBMS_AUTO_TASK_ADMIN.ENABLE
  34. Which feature manages resource allocation among database sessions?
    Resource Manager
  35. What are the three elements of DRM?
    • Resource Consumer Groups
    • Resource Plan
    • Resource Plan Directive
  36. What is a Resource Plan Directive?
    A set of limits for CPU and IO consumption for a consumer group
  37. What are the possible actions that the resource manager can take when a Resource Plan Directive is exceeded?
    • The session is switched to another consumer group SWITCH_GROUP
    • The session is killed KILL_SESSION
    • The sessions current SQL is aborted CANCEL_SQL
  38. What are the three criteria used in making determining the switch in resource manager? What is the default limit?
    • SWITCH_TIME - CPU seconds
    • SWITCH_IO_MEGABYTES - IO in MB
    • SWITCH_IO_REQS - IO Requests
    • Default is UNLIMITED
  39. What is SWITCH_ESTIMATE in resource manager? What is it's default?
    • If TRUE, the database estimates the execution time BEFORE the call is made and the session is moved to the SWITCH_GROUP BEFORE the call
    • Default FALSE
  40. What is SWITCH_FOR_CALL in resource manager? What is it's default?
    • A session is returned to its original group once the call is complete.
    • Default NULL
  41. Which procedure is used to create a Scheduler Program?
    DBMS_SCHEDULER.CREATE_PROGRAM
  42. In a Scheduler Program, what parameter defines the sort of program and what are these sorts?
    program_type - PLSQL Block, OS EXE, PLSQL Procedure
  43. Which procedure is used to remove a Scheduler Program?
    DBMS_SCHEDULER.DROP_PROGRAM
  44. Which view is used to display information about Scheduler Programs?
    DBA_SCHEDULER_PROGRAMS
  45. Which procedure is used to create a Scheduler Schedule?
    DBMS_SCHEDULER.CREATE_SCHEDULE
  46. In DBMS_SCHEDULER.CREATE_SCHEDULE what are the possible date parameters?
    • start_date
    • repeat_interval
    • end_date
  47. Which view is used to display information about Scheduler Schedules?
    DBA_SCHEDULER_SCHEDULES
  48. What procedure is used to create a job?
    DBMS_SCHEDULER.CREATE_JOB
  49. What procedure is used to stop a running job?
    DBMS_SCHEDULER.STOP_JOB
  50. What procedure is used to run a running job manually?
    DBMS_SCHEDULER.RUN_JOB
  51. Which view is used to display information about Scheduler Jobs?
    DBA_SCHEDULER_JOBS
  52. Which view is used to set a Scheduler Attribute?
    DBMS_SCHEDULER.SET_ATTRIBUTE
  53. Which procedure is used to create a Scheduler Job Class?
    DBMS_SCHEDULER.CREATE_JOB_CLASS
  54. Which procedure is used to create a Scheduler Windows?
    DBMS_SCHEDULER.CREATE_WINDOW
  55. Which procedure is used to enable a Scheduler Windows?
    DBMS_SCHEDULER.OPEN_WINDOW
  56. Which procedure is used to end a Scheduler Windows?
    DBMS_SCHEDULER.CLOSE_WINDOW
  57. Which procedure is used to create a Scheduler Windows Group?
    DBMS_SCHEDULER.CREATE_WINDOW
  58. Which view show Job runs, job state changes, job failures?
    DBA_SCHEDULER_JOB_LOG
  59. Which view show details from DBA_SCHEDULER_JOB_LOG
    DBA_SCHEDULER_JOB_RUN_DETAILS:
  60. Which procedure changes the Baseline Window Size
    DBMS_WORKLOAD_REPOSITORY.modify_baseline_window_size(    window_size => 20);
  61. Which view shows the current AWR retention?
    DBA_HIST_WR_CONTROL
  62. Which procedure gives an indication into the capability of system storage?
    DBMS_RESOURCE_MANAGER.CALIBRATE_IO
  63. What are the possible options for the parameter FILESYSTEMIO_OPTIONS?
    • ASYNCH
    • DIRECTIO
    • SETALL
    • NONE
  64. To use CALIBRATE_IO, what must Timed Statistics be set to?
    TRUE
  65. How must the datafiles be accessed in CALIBRATE_IO?
    Asynchronously
  66. What must FILESYSTEMIO_OPTIONS be set to for CALIBRATE_IO?
    ASYNCH or SETALL
  67. Which view contains the results of an IO_CALIBRATION?
    DBA_RSRC_IO_CALIBRATE
  68. DBMS_RESOURCE_MANAGER.calibrate_io requires two inputs, what are they?
    • num_physical_disks
    • max_latency
  69. Which view show the running status of an IO_CALIBRATE?
    V$IO_CALIBRATION_STATUS
  70. What are the two types of adaptive threshold?
    • Percentage of maximum
    • Significance level
  71. Which procedure creates a single baseline?
    DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE
  72. Which procedure creates a baseline template?
    DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE
  73. Which procedure removed a baseline template?
    DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE_TEMPLATE
  74. With which procedure can the size of the Default Moving Window Baseline be changed?
    MODIFY_WINDOW_BASELINE_SIZE
  75. What are the four setting of Baseline Metric Thresholds?
    • Threshold Type
    • Critical
    • Warning
    • Occurrences
  76. What are the possible options for JOB STYLE when creating a job?
    • LIGHTWEIGHT
    • REGULAR
  77. What must Lightweight jobs be based on?
    A program object, PLSQL or STORED_PROCEDURE
  78. Which kind of jobs are not schema objects?
    Lightweight
  79. Which types of jobs cannot have privilges granted on them?
    Lightweight Jobs
  80. What kind of metrics support Significance Level Thresholds?
    Basic
  81. For which metrics can Significance Level and Fixed Value thresholds be set?
    All
  82. What tasks are performed by ABP process?
    • Creating jobs for each maintenance task
    • Storing execution history in SYSAUX
    • Prioritizing maintenance tasks
  83. How is a baseline set to never expire?
    Set the EXPIRATION parameter of CREATE_BASELINE_TEMPLATE to NULL
  84. What is the default value of EXPIRATION parameter of CREATE_BASELINE_TEMPLATE?
    NULL - Never expire
  85. Which view shows execution history for automated maintenance tasks?
    DBA_AUTOTASK_TASK
  86. What are the two baseline types?
    Fixed and Moving
  87. How is a fixed baseline defined?
    • DBMS_WORKLOAD_REPOSITORY.create_baseline
    • start and end times or snap_ids
    • baseline_name
    • expiration (Null Never)
  88. How is a baseline template defined?
    • DBMS_WORKLOAD_REPOSITORY.create_baseline
    • start and end times in furture
    • baseline_name
    • template name
    • expiration (Null Never)
    • scheduling information
  89. Which view shows baselines from the past?
    DBA_HIST_BASELINE
  90. How is snapshot retention time changed?
    • BEGIN
    • DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
    • retention => 43200); --30 days in Secs
    • END;
  91. How is a window baseline size changed?
    • BEGIN
    • DBMS_WORKLOAD_REPOSITORY.modify_baseline_window_size(
    • window_size => 30);
    • END;/

What would you like to do?

Home > Flashcards > Print Preview