OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

Chapter 14. Securing the Oracle Listener, Diagnostic Sources, and Memory

ORACLE DATABASE 10G: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Securing the Oracle Listener

  • Secure the listener.

  • Remove default EXTPROC entry and add a separate listener to handle external procedure calls.

• Diagnostic Sources

  • Use the alert log and database trace files for diagnostic purposes.

  • View alerts using Enterprise Manager.

  • Control the size and location of trace files.

• Monitoring and Managing Memory

  • Implement Automatic Shared Memory Management.

  • Manually configure SGA parameters for various memory components in the SGA.

  • Use Automatic PGA Memory Management.

NOTE

Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. ...