What Can Be Configured?

Some items that can be configured in an Oracle database are the following:

  • Components of the database that affect the allocation of system processes, such as:

    SQL*Net
    Multi-Threaded Server (MTS)
    Parallel Query
    Parallel Server

  • The layout and sizes of physical storage

  • The sizing of database objects, such as:

    Tables
    Indexes
    Rollback segments
    Sort areas
    Temporary tablespaces
    Redo logs
    Partition tables
    Index-only tables

  • The amount and allocation of memory, such as:

    Database buffers
    Redo log buffers
    Shared pool

Get Oracle Database Administration: The Essential Refe 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.

Start your free trial