Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    Architecture Oracle Instance BGD Process + Memory Area

    Uploaded by

    mahi5061
    The document discusses key components of an Oracle database instance including the system global area (SGA), redo log buffer, and control files. It also covers database writer (DBWR) concepts for writing modified data to disk, redo and undo entries for logging and rolling back transactions, checkpoints for database consistency, recovery processes, and shutdown modes for Oracle instances. The document appears to provide an overview of Oracle database architecture, memory structures, transaction logging, recovery fundamentals, and database administration.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Architecture Oracle Instance BGD Process + Memory Area

    Uploaded by

    mahi5061
    46 views52 pages
    The document discusses key components of an Oracle database instance including the system global area (SGA), redo log buffer, and control files. It also covers database writer (DBWR) concepts for writing modified data to disk, redo and undo entries for logging and rolling back transactions, checkpoints for database consistency, recovery processes, and shutdown modes for Oracle instances. The document appears to provide an overview of Oracle database architecture, memory structures, transaction logging, recovery fundamentals, and database administration.

    Original Description:

    oracle over

    Original Title

    Oracle Overview

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses key components of an Oracle database instance including the system global area (SGA), redo log buffer, and control files. It also covers database writer (DBWR) concepts for writing modified data to disk, redo and undo entries for logging and rolling back transactions, checkpoints for database consistency, recovery processes, and shutdown modes for Oracle instances. The document appears to provide an overview of Oracle database architecture, memory structures, transaction logging, recovery fundamentals, and database administration.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    46 views52 pages

    Architecture Oracle Instance BGD Process + Memory Area

    Uploaded by

    mahi5061
    The document discusses key components of an Oracle database instance including the system global area (SGA), redo log buffer, and control files. It also covers database writer (DBWR) concepts for writing modified data to disk, redo and undo entries for logging and rolling back transactions, checkpoints for database consistency, recovery processes, and shutdown modes for Oracle instances. The document appears to provide an overview of Oracle database architecture, memory structures, transaction logging, recovery fundamentals, and database administration.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 52

    Architecture

    Memory Area

    Oracle Instance= BGD Process + Memory Area

    1 SGA+ Database buffer cache


    2 Shared Pool
    Shared SQL Area
    Row Cache
    3 Redo Log Buffer

    Command: Show sga

    Writing of Modified DataFigure

    DBWR Concepts

    Logging of ModificationsFigure

    Redo Entries

    Undo Entries

    Log Switch

    Important info:

    Control Files:

    Checkpoints

    Database Recovery

    Archiving

    Other BGD Process

    Oracle Directories and Files on SAP SystemsFigure

    workprocess connection to Oracle

    Note

    Net Services

    Database Administration Tools

    Administrating Oracle Instances

    The following shutdown modes are possible:

    Unit 2:
    Backup, Restore, and Recovery

    You might also like