OCP 15 Diagnosability Enhancements

Card Set Information

Author:
Tralala
ID:
213635
Filename:
OCP 15 Diagnosability Enhancements
Updated:
2013-04-15 09:31:17
Tags:
OCP 15 Diagnosability Enhancements
Folders:

Description:
OCP 15 Diagnosability 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. When viewing a Health Monitor report, which output column indicates whether the health check was runmanually or in reaction to a critical error?
    The run_mode column
  2. Which Health Monitor check should you use to verify that all database files are accessible and consistent?
    DB Structure Integrity Check
  3. What does an incident status of Tracking indicate?
    The DBA is currently working on the incident, and the incident should remain in the ADR.
  4. When using Custom Packaging to package incidents, what additional information can you include in your incident package?
    Additional problems or incidents, trace files, external files, and other diagnostic information, such as SQL test cases
  5. In V$DIAG_INFO, which ADR location name specifies the path to the trace file associated with the current session?
    Default Trace File
  6. In V$DIAG_INFO, which ADR location name specifies the location of the alert log stored in XML format?
    Diag Alert
  7. In Oracle 11g, how long are incident and dump files kept by default?
    For one month
  8. In V$DIAG_INFO, which ADR location name specifies the location where the text alert log, background process trace files, and foreground process trace files are stored?
    Diag Trace
  9. Which Health Monitor check should you use to check for logical undo corruptions and attempt to repair them?
    Undo Segment Integrity Check
  10. Does the Data Block Integrity Check Health Monitor check detect both interblock and intrablock corruption?
    No, only intrablock corruption
  11. What does an incident status of Collecting indicate?
    Diagnostic data is currently being collected for the incident.
  12. Which command-line utility can you use to view diagnostic data in the ADR, view contents of the alert log file, and package incident and problem information?
    The ADRCI command-line utility
  13. What information is included for a full incident package zip file?
    All incident information and data
  14. Which component must you install when installing Oracle 11g, if you want to automatically package and upload incidents using Support Workbench?
    Oracle Configuration Manager
  15. What uniquely identifies a problem in the ADR?
    The problem ID
  16. In Oracle 11g, how long is incident metadata stored in the ADR by default?
    For one year
  17. What does an incident status of Ready indicate?
    All diagnostic data for the incident has been collected, and the incident is ready to be uploaded to Oracle Support.
  18. Will a problem likely have multiple incidents or will an incident likely have multiple problems?
    A problem will likely have multiple incidents.
  19. If you do not specify a value for the DIAGNOSTIC_DEST initialization parameter and the ORACLE_BASE environment variable is set, to what value is DIAGNOSTIC_DEST set at startup?
    $ORACLE_BASE
  20. Which Health Monitor check scans the redo logs and archive logs to check for archive log or redo corruption?
    Redo Integrity Check
  21. What is checked if you run a DB Structure Integrity Check using Health Monitor and the database is in NOMOUNT mode?
    Only the control file
  22. If you do not specify a value for the DIAGNOSTIC_DEST initialization parameter and the ORACLE_BASE environment variable is not set, to what value is DIAGNOSTIC_DEST set at startup?
    $ORACLE_HOME\log
  23. What information is included for an incremental incident package zip file?
    Only the incident diagnostic information that changed since the last time you packaged the incident
  24. When using EM Support Workbench, for what purpose might you manually run a health check?
    To gather additional diagnostic data associated with a problem
  25. Which type of incident packaging should you use if you want to add other diagnostic data, such as SQL test cases, or remove sensitive data?
    Custom packaging
  26. Which Health Monitor check should you use to verify the integrity of dictionary objects?
    Dictionary Integrity Check
  27. When viewing a Health Monitor report, what is true if a value of REACTIVE is displayed for the run_mode column?
    The health check was performed automatically because a critical error was encountered.
  28. What uniquely identifies an incident in the ADR?
    The incident ID
  29. Which Health Monitor check is used to check for disk image block corruptions, such as checksum failures and intrablock corruption?
    Data Block Integrity Check

What would you like to do?

Home > Flashcards > Print Preview