Chapter 11. Managing Database Resources

ORACLE DATABASE 11g: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Managing Memory

    • Implementing Automatic Memory Management

    • Manually configure SGA parameters

    • Configuring automatic PGA memory management

  • Space Management

    • Managing resumable space allocation

    • Describe the concepts of transportable tablespaces and databases

    • Reclaim wasted space from tables and indexes by using the segment shrink functionality

  • Managing Resources

    • Understand the Database Resource Manager

    • Create and use Database Resource Manager Components

Managing Database Resources

In this chapter, we will discuss how to most effectively manage memory, space, and resources. ...

Get OCP: Oracle Database 11g Administrator Certified Professional Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.