Active Session History (ASH)

Application Continuity (AC)

Application design

    affinity

    Automatic Segment Space Management (ASSM)

    change deployment

    COMMIT statement

        block transfers

        commit cleanout

        interested transactions list (ITL)

        log writer (LGWR)

    concurrency inserts

        B-tree index

        database events

        hash-partitioned index

        leaf block contention

        reverse-key index

        right-hand index growth contention

        software driven access

        table partitioning

    execution plan inefficiently

    freelists

    full table scan

    of index

    inter-instance parallel scan

    localized access

        performance issues

        resolve options

    long pending transactions

    pipes

    sequence cache

        instance failure

        lock event

        with ORDER

        in RAC database

        uncached performance

        value retrieval

    small table updates

    TRUNCATE or DROP command

        global tempporary tables (GTTs)

        library cache locks

        object_id

ASM Cluster File System (ACFS)

    creation

    guidelines

    Oracle ASM and Oracle ACFS

    Oracle RAC Home (ASMCA)

        acfs_script

        ACSMCA menu

        database home

        Oracle database home volume

Automatic Database Diagnostic Monitor (ADDM)

Automatic Storage Management (ASM)

    architecture

        ACFS and Oracle ADVM

        configurations

        Flex Clusters

        networks

        node 4 connects

    ASMCMD and Oracle 10gR1

    ASM instances

        11gR2 ASM and 12cR1 standard ASM

        creation and ownership

        dependency prior-Oracle 11gR2

        listener

        Oracle 12c Flex ASM

        startup and shutdown

    block devices

    clients and relocation

    configuration

        conversion method

        network and private interconnects share

    disk group

    OCR and voting disk

        GI installation

        high-redundancy diskgroup

        new ASM diskgroup

        voting disk files

    Oracle data files

    read failure groups

    rebalance operation

    SCRUB feature

    SQL commands and V$ ASM views

    storage limit

    storage structure

        ASMCMD utility

        ASMLib

        configure ASMLib and create ASM disks

        ASM diskgroups

        download and install ASMLib packages

        file system structure

Automatic Storage Management (ASM). See ASM Cluster File System (ACFS)

AWR reports. See Automatic Database Diagnostic Monitor (ADDM)

Block Change Tracking (BCT)

Cache fusion, RAC

    BL resources and locks

    buffer header structures

    CDB

    database block

    GRD

    locking scheme

    processing scheme

        block transfer

        global cache lock conversion

        LMS process

        mechanics

Checklist for upgrades

    cluster compatibilty

    flexibility and restrictions

    Oracle software backups

    Oracle variables, unsetting

    OUI launch

    validationg node (server)

Cluster Health Monitor (CHM)

Cluster Ready Service (CRS)

Clusterware Control (CRSCTL)

Clusterware downgrade

    forcing upgrades

    initiating procedure

    Oracle 12c RDBMS software installation

Clusterware stack

    12cR1

        ASM and clusterware

        CRS stack

        GPnP profile

        high availability cluster service stack

        levels of processing

        Oracle cluster registry (OCR)

        Oracle high availability services daemon (OHASD)

        Oracle stack

        Clusterware processes

        software stack

        startup sequence

        storage components, Oracle

        voting disk (VD)

    management

        CHM

        crsctl command

        CRS resources

        crs_stat –t command

        node addition

        OCR and voting disk

        Oracle management

        removal of node

        start up and stop

        tools and utilities

        troubleshoot, start up failuresSee (see Start-Up Failures troubleshoot)

        utilities

Critical patch update (CPU)

CRS Stack

    cluster time synchronization service

    clusterware agent processes

    CRSD

    CSS

        agent

        monitor

    event management (EVM)

    ONS

    Oracle ASM

Current block wait events

Database clustering architecture

Database Configuration Assistant (DBCA)

Database connection (RAC with VIPs)

Database scalability

    considerations

    Flex Cluster

    load balancing works

    overview

    scale-up method

Database upgrade

    advantages of DBUA

    compatibility matrix

    DBUA database

    downgrade

    manual deployment

        command prompt

        pre-upgrade

    parallel upgrade utility

    post upgrade

    pre-upgrade tool

    using DBUA

        database selection

        operation selection

        prerequisite checks

DBCA’s Creation

    identification screen

    node selection

    placement

    template screen

Dell PowerVault Modular Disk Storage Manager (MDSM)

Dynamic Resource Mastering (DRM)

    AWR reports

    changes in release 12c

    elapsed times

    GRD freeze

    overview

    parameters

    stages

    troubleshooting

    undo segments

E-Business Suite (EBS) Applications

Fast Application Notification (FAN)

Fast Connect Failover (FCF)

Fibre Channel (FC)

Foreground (FG) process

Global Cache Service (GCS)

Global Resource Directory (GRD)

Global resource types

    buffer lock resource

    non-BL resource

Grid Infrastructure (GI) installation

High availability (HA), Oracle RAC

    Application Continuity (AC)

    considerations

    database connection

    FCF

    multi-tier applications

    planned downtime

    prevention methods

    recovery methods

    SLAs

    TAF

    unplanned downtime

Instance caging

    deployment of

        a 16-CPU/core box

        SQL statement

Internet Protocol (IP)

Lock Manager Server (LMS) process

Locks and Deadlocks

    deadlocks

        between two sessions

        information identification

        LMD trace file analysis

        locks of trace files

        trace file structure

    DES lock handler

        ASM specific CI

        CI resources

        DFS lock

        GRD resources

        lock type identification

        RAC processes

        resources, CI enqueue

        sequence value and resources

        SV resources

    enqueue contention

        ges_blocking_locks

        high water mark (HW)

        HW enqueue

        and modes of TM

        and modes of TX

        resources

        TM enqueue

        TM resources

        TX enqueue

    enqueue statistics

        methods of

        production problem

    hanganalyze

    and library cache pins

        exclusive mode

        gv$ views

        LB and NB resources

        resources

        troubleshooting, contention

    and resources

        global cache services (GCS)

        in GRD

        instances

    SGA memory allocation

        global resource types

        locking scheme

        modes

        pluggable databases (12c)

        for RAC

        resource name

        structure

        views

    troubleshooting

        blocked locks

        ges_blocking_locks

        gv$ges_blocking_enqueue

    v$wait_chains

Media management library (MML)

Multipath device configuration

Network

    cluster interconnect

        high availability IP (HAIP)

        ifconfig command

        network configuration

        oifcfg command

    configuration for Oracle RAC and Clusterware

        adapter

        hardware

        hostname specification

        IP address establishment

        name resolution

        network inetrface specification

        in OS

        public network

        redundant private network

        specification in grid infrastructure

        usage of GNS

        verification of

    configuration in Clusterware

        private

        public network

        SCAN VIP and SCAN Listener

    failover

    GC lost block issue

        algorithm

        AWR reports

        logic

        memory starvation

    jumbo frames

        fragmentation and reassembly

        ifconfig command

        8K transfer without

        maximum transmission unit (MTU)

        packet dump analysis: MTU=1500

        packet dump analysis: MTU=9000

    Kernel parameters

    layers

        clusterware processes

        kernel function

        stack of functions

    load balancing and failover

        HAIP

        highly available VIP

        Linux bonding

    measurement tools

        in Linux Platform

        lperf tool

        Netstat

        ping command

        RAC packets

        from Solaris OS

        traceroute

    protocols

        address resolution protocol (ARP)

        function execution stack of UDP

        InfiniBand

        Ipv4 vs. IPv6

        reliable datagram socket

        relinking protocol library

        stateful (TCP/IP)

        UDP (stateless)

    second network

    subnetting

        IP address range

    types

        backup

        network packets

        public

    VIPs

Network Area Storage (NAS)

Network interface cards (NICs)

Node evictions

    causes and factors

    crucial informations

    debugging

        active node (scan/verify)

        generic information

        node extracts

        node information

        warning message

    rebootless stop/fencing

Non-RAC vs. RAC database

Optimizing RAC environment

    database design and plan

        instance caging See (see Instance caging)

        policy-managed See (see Policy-Managed database)

    extended distance (strech) clusters

        advantages of

        disadvantages of

        operations of

        RAC cluster

        setup/configuration

    installation and setup

        for Linux

        Solaris (SPARC)

        Windows

    node evictions See (see Node evictions)

    performance tuning See Also (see also Performance tuning)

    server pools

        attach, DBCA

        creation and management of

        in Oracle Enterprise Manager Cloud Control

        system-defined

        user-defined

    setup and configuration

        and management in enterprise manager

        Oracle Enterprise Manager Cloud Control 12c

        OUI

    shared vs. non-shared Oracle homes

        cons

        installation of

        and mixed environment

        node settings

        pros

    small- vs. large-scale cluster

    Split-Brain

        conditions of

        in Oracle RAC Cluster

Oracle Cluster Registry (OCR)

Oracle Flex clusters

    architecture

        connection

        hub-and–spoke topology

        Leaf nodes

    configuration

        CRSCTL

        existing cluster mode

        OUI

    scalability and availability

Oracle Parallel Server (OPS)

Oracle RAC

    benefits

    cache fusion

        data block

        data blocks

        disk ping

        DRM

        GCS

        global cache coherency

        interconnect

        multiple-node RAC database

        reconfiguration

        STONITH

    cost of ownership

    database clustering architecture

    database scalability

        considerations

        overview

        scale-up method

    database services

    factors

    high availability

        considerations

        multi-tier applications

        planned downtime

        prevention methods

        RAID

        recovery methods

        SLAs

        unplanned downtime

    scale-out method

    single-node-achieve HA

    Yu, Kai

Oracle RAC. See See Real Application Cluster (RAC)

Oracle Universal Installer (OUI)

    Cluster nodes

    Grid Infrastructure installation

    installation steps

Parallel execution (PX)

    concurrent union processing (12c)

    DML in RAC

    index in RAC

    operational details

    partition-wise join

    query operations

    in RAC

        and cache fusion

        debugging

        inter-instance execution

        intra instance parallelism

        and parallelism features See (see Parallelism features)

        PEMS

        server allocation

        server palcements See (see PX server placements)

        traffic measurements

    server processes in single instance

    server sets

    in single instance

    SQL execution plan

Parallelism

    AutoDOP

        disadvantages in production database

        I/O calibration

        parallel_degree_policy

        SQL statement

    best database backup strategies

    configure standby RAC database

    critical statement queues (12c)

    database backup/restore operation

    database restore procedure (RAC to single-instance)

    grouping statement queue execution (12c)

    instance/crash recovery

        crash recovery

        instance recovery

        parallel recovery

        prime objective

    in-memory

        algorithm directives

        enabledisable

    prioritizing statement queues (12c)

        consumer groups

        OTHER_GROUPS

        queuing scheme

    PX statement queuing

    statement queue timeout (12c)

    statement queuing

        parallel_degree_policy

        PX server

Parallel recovery

    back up and restore archive logs

    instance/crash recovery internals

    monitor and view instance recovery details

Patch set upgrades (PSU)

Performance tuning, 3 A’s

    cluster cache coherency link

    cluster performance

    database server family

    features in OEM12cR2

    resource and SQL summary

    stargate of Oracle RAC

Pluggable databases (PDBs)

    architecture

        CDB

        connect (CDB root and PDBs)

        DBCA

    EBS

    RAC nodes

        database services

        net services names

        Oracle RAC-based CDB

Policy-Managed databases

    DB configuration

    deployment of

    migrate from Admin-Managed to

    upgrading a

    very-large-scale cluster deployment

Program Global Area (PGA)

Public network

    attribute

    resources

    VIP address

    VIP resource

PX server placements

    costing

    instance_group

    parallel_force_local

    parallel_instance_group

    services

        configuration

        po service

RAC 12c

    12cR1

        12cR1

        ASM, ACFS and ADVM

        CHM enhancemennts

        global data services

        listener registration

        miscellaneous

        NFS exports

        online resource attribute modification

        OUI

        policy-based management and administration

        public networks

        run automatically

        shared GNS

        shared password files

        transaction idempotence

        valid node checking

        Windows domain

    deprecated and desupported features

    features

    Flex ASM

        architecture

        clients and relocation

        configuration

        disk group

        Flex Clusters

        read failure groups

        rebalance operation

        SCRUB feature

        storage limits

    PDBs

        architecture

        EBS

        RAC nodes

    What-if command Evaluation

RAC 12c. See See Oracle Flex clusters

RAC database optimization See Also See also Cache fusion, RAC

    ASH reports

    AWR reports

    DRM

        changes in release 12c

        elapsed times

        GRD freeze

        overview

        parameters

        stages

        troubleshooting

        undo segments

    gc buffer busy acquire/release

        block type and possible issues

        gc buffer busy events

        single-instance counterparts

        table blocks

        unique indexes

    performance analysis

        eliminate network as root cause

        generic analysis

        identify object

        problem instances

        questions

        receiving side

        SQL statement

        wait distribution

    placeholder wait events

    sending-side analysis

        AWR report

        block types served

        formula

        GCS log flush sync

        LMS process

        LMS processing mechanics

        receiving side metrics

        sending-side metrics

    wait events

        busy events

        CR block congested/current block congested

        CR block transfer

        gc cr grant 2-way and gc current grant 2-way

        GC current block

RAC Environment management. See See Optimizing RAC environment

RAC One Node

    benefits of

    binary deployment

        location specification

        selection of node

        software installation

    Cloud Control 12c management

        availability of database

        database relocation

        EM12c reports

        online database relocation

        vs. third-party cold failover

    database deployment

        DBCA creation process

        parameters specific

        prerequisites

    database management

        cluster reboots

        configuration verification

        omotion utility

        online relocation status

        relocation online

        start command

        stop command

        unplanned node

    and standard RAC conversion

        scaling down

        scaling up

    upgrading to 11.2.0.2 or higher

RAC operations

    database management and instances

    failover

        application continuity (12c)

        connect string

        error avoidance, FCF

        FAN events

        fast connection failover (FCF)

        proactive connection management

        session

        transaction guard (12c)

        transparent application failover

        WebLogic Active GridLink

    massive data changes

    miscellaneous

        filesystem caching

        memory starvation

        in platforms

        process priority

        SGA size

    parameter file management

    password file management

    performance metrics collection

    policy managed databases

    services

        calculation and propagation, metrics

        clusterware

        database connection

        Service goals

        guidelines

        instances

        load balancing goals

        LREG process

        memory monitor (MMON)

        Service metrics

        Oracle Database version

        process monitor (PMON)

        runtime failover

        SCAN listener

        in second network

        SOLRAC

        srvctl

    single client access name (SCAN)

        connection request

        connect string

        database initialization parameter

        EZConnect syntax

        failover attributes

        global database services (12c)

        guidelines for listeners

        IP address

        listener in second network (12c)

        VIP listeners

    single client access name (SCAN);GDS listeners

    tablespaces

        extent caching

        guidelines

        temp files

    VIPs, listeners (management)

    workload management

        application affinity

        databases

        distribution

Real Application Cluster (RAC)

    architecture

    background processes

    components

        architecture

        grid infrastructure

    hardware requirements

        cluster nodes

        hardware architecture

        network configuration

        NICs

        OCR

        servers

        verification and audit tools

Real Application Clusters (RAC)

    advantages

    OCR recovery

        ASM diskgroup

        backups

        cluster resources function

        commands

        rebuild

    OEM Cloud Control 12c

        backup_setting_backup_set screen

        backup_setting_device screen

        manage current backup

        perform recovery

        policy tab

        recovery settings screen

        schedule backup

        screen

Real Application Clusters (RAC). See See Parallelism; Recovery Manager (RMAN)

Recovery Manager (RMAN)

    connection workflow

    key benefits

    MML

    multiple channels configuration

        parallelism for load balancing

        persistent multichannel configuration

        runtime (one-time) multichannel configuration

    non-RAC vs. RAC database

    online database backup and recovery operations

    redo and archive logs-shared location

    snapshot control file configuration

Redundant Array of Inexpensive Disks (RAID)

    levels

    RAC database

    RAID 1+0 and RAID 0+1

    storage product terminologies

Runtime (one-time) multichannel configuration

Server process. See See Foreground (FG) process

Service Level Agreements (SLAs)

Shared storage

    architecture and I/O operations

        database architecture

        database background processes

        DBWR process

        OCR and voting disk

        OLTP-type database

        RAC database

        random read/sequential read

        SCN

    multipath device configuration

    Oracle Flex Cluster

    RAID configuration

        levels

        RAC database

        RAID 1+0 and RAID 0+1

        storage product terminologies

    set ownership of devices

    storage protocols

        FC switch fabric topology

        I/O paths

        iSCSI storage deployment

        network protocols

        SCSI, FC, and IP protocols

        WWNs

    storage, system administrator and DBA

    Yu, Kai

Shared storage. See See Automatic Storage Management (ASM)

Small Computer System Interface (SCSI)

Solid State Drives (SSD)

Start-Up Failures troubleshoot

    cluster resources

    clusterware exclusive mode

    command output

    component and resource debugging

        cluvfy failure

        default trace

        OS level tracing

    CSSD issues

    daemon command

    diagnose, debug, trace clusterware and RAC issues

    error messages

    grid infrastructure

        alert log file

        CRSD log file

        log file creation

        ocssd.log

        OS logs

        unified directory

    has/crs auto start

    ocrcheck command

    OCR issues

    ohasd startup

    tools and utilities

        configuration audit tool

        diagnostic collection tool

        health check with CVU

        oratop utility

        RACcheck

        real time RAC database monitoring

        screen shot of oratop

Storage Area Network(SAN)

System Change Number (SCN)

System Global Area (SGA)

Transparent Application Failover (TAF)

Upgrading clusterware and database

    configuration

        pre-upgrade checklist See (see Checklist for upgrades)

    database See (see Database upgrade)

    initiating an Oracle

        batch selection

        cluster health monitor (CHM)

        GI node selection

        installation option screenshot

        location specification

        management repository, GI

        product installation

        progress bar

        root script execution

        rootupgrade script execution

        .sh script

    post tasks

        12c cluster

        downgrade See (see Clusterware downgrade)

What-if command Evaluation