Oracle 12c Upgrade: 18 – ADR and Network Enhancements

Card Set Information

Author:
Tralala
ID:
297510
Filename:
Oracle 12c Upgrade: 18 – ADR and Network Enhancements
Updated:
2015-03-04 02:13:44
Tags:
ADR Network Enhancements
Folders:
Oracle 12c Upgrade
Description:
Oracle 12c Upgrade: 18 – ADR and Network 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. All which parameter will log all DDL changes?
    enable_ddl_logging=true
  2. When enable_ddl_logging=true, where is the data logged?
    • In 11g Alert Log
    • In 12c to an exclusive log.xml in $ADR_HOME/home/ddl
  3. What is required to use enable_ddl_logging?
    License the Oracle Change Management Pack
  4. What can be used to format the DDL logging log.xml into more a readable format
    The show log command in adrci
  5. If an error deemed not important enough for the alert log is generated, where does it go?
    The Debug Log
  6. Where is the Debug log written?
    $ADR_HOME/log/debug
  7. In what format is the Debug log?
    Same as the alert log
  8. What is Oracle Network Compression?
    • A way of increasing performance in a system constrained by bandwidth
    • Requires Oracle Advanced Compression Option
  9. Where is Oracle Network Compression configured?
    In sqlnet.ora
  10. What the the parameters for Oracle Network Compression?
    • SQLNET.COMPRESSION (OFF(def)|ON)
    • SQLNET.COMPRESSION_LEVELS (LOW(def)|HIGH)
    • SQLNET.COMPRESSION_THRESHOLD 1024 bytes
  11. What does SQLNET.COMPRESSION_THRESHOLD do?
    Defines the size of data before compression is applied
  12. What is SDU size?
    • Session Data Unit
    • Size of packets transmitted over the network.
  13. What is the recommended size of the SDU?
    70 bytes bigger than the common message size
  14. How is the SDU size configured?
    • In sqlnet.ora
    • SQLNET.DEFAULT_SDU_SIZE
  15. What is the default and max size of the SDU?
    • 8K
    • 2M

What would you like to do?

Home > Flashcards > Print Preview