alter table emp compress

Auto DOP

    calibration

        CALIBRATION_TIME value

        DBA_RSRC_IO_CALIBRATE

        DBMS_RESOURCE_MANAGER

        execution plan

        IN PROGRESS status

        latency

        parallel_min_time_threshold

        PL/SQL block

        RESOURCE_IO_CALIBRATE$

        serial execution time

        tkprof output

        V$IO_CALIBRATE_STATUS result

        V$IO_CALIBRATION_STATUS

    DEGREE setting

    INSTANCES setting

    _parallel_cluster_cache_policy parameter

    parallel_degree_policy settings

    _parallel_statement_queueing

Automatic Storage Management (ASM)

Auto Service Request (ASR)

Basic compression

Bloom filters

Celladmin

    acknowledged and unacknowledged alerts

    alert history

    cell configuration check

    cellsrvstat

    disk controller battery

    firmware revisions

    functionality and metrics

    learn cycle

    statistics categories

    user account

Cell manager cancel work request

Cell manager closing cell

Cell manager discovering disks

Cell manager opening cell

CELLSRV

Cell wait events

    cell-related events

    idle class/other class

        cell smart flash unkeep

        rarely reported cell wait events

    system I/O events

        cell smart incremental backup

        cell smart restore from backup

        cell startup and shutdown wait events

    triggering events

    user I/O events

        cell list of blocks physically read

        cell multiblock physical read

        cell single-block physical read

        cell smart file creation

        cell smart index scan event

        cell smart table scan event

        cell statistics gather

Cell worker idle

Cell worker online completion

Cell worker retry

Clustering Factor

Compression

    basic compression

    HCC (see Hybrid Columnar Compression (HCC))

    loading data

        load times and data volumes

        results

    OLTP

    query process

        execution plan

        execution times

        results

    ratios

        actual observed

        DBMS_COMPRESSION.GET_COMPRESSION_RATIO procedure

        estimated

    updates

        basic-level compression

        elapsed time

        increasing table size

Compression Units (CUs)

    bitmap

    header

    initial data organization

    layout

Database Machine Administrator (DMA)

    resources

    responsibilities

Database server tools

data file init write event

DBA_HIST_ACTIVE_SESS_HISTORY view

db file scattered read

db file sequential read event

dbID

DBMS_COMPRESSION.GET_COMPRESSION_RATIO procedure

dbUniqueName

Degree of parallelism (DOP)

direct path read event

DISPLAY_CURSOR function

Energy Storage Module (ESM)

ERP system

    database creation

    data migration

    env file

    environment configuration

    Grid Infrastructure Oracle Home

    MOS

    SCAN listener

Exadata

    bloom filter

        advantage

        bloom_fltr_ex.sql script

        definition

        offload processing

        query execution

        SYS_OP_BLOOM_FILTER function

    Column Projection

    configuration

    database layer

    data warehouse

    definition

    effective monitoring strategy

    expansion racks

    GV$SQL and GV$SQLSTATS

        database layer processing time

        global information output

        HTML reports

        index access

        offload efficiency

        parallel execution

        plan-level monitoring data

        session-level execution monitoring data

        SQL Plan window

        traditional consistent-read processing

    initial baseline

    offloading function

        agg_smart_scan_ex.sql script

        COUNT() query

        multi-row function

        offloadable_fn_tbl.sql script

        single-row function

    OLTP

    Predicate Filtering

    raw storage

    real-time SQL monitoring reports

        duration

        Duration column

        I/O window

        OEM 12c

        plan providing time

        session ID

        SQL ID

        wait statistics

    Smart Flash Cache

    Smart Scan

        autotrace

        CPU cycles

        execution

        full table scan

        index range scan

        io_cell_offload_eligible_bytes

        no_smart_scan_ex.sql script

        operators

        optimization

        TABLE ACCESS STORAGE FULL operation

        V$SQL view

    storage cells (see Storage cells)

    virtual columns

        smart_scan_virt_ex.sql

        TOTAL_COMP column

        TTL_COMP skip

First-in, first-out (FIFO) queue

Grid Infrastructure Oracle Home

Hybrid Columnar Compression (HCC)

    ARCHIVE

        EMP table

        GET_COMPRESSION_TYPE

        HIGH compression rate

        LOW compression rate

    Compression Units

    Data Guard

    Exadata storage

    options

    QUERY

        EMP table

        HIGH compression rate

        LOW compression rate

INDEX RANGE SCAN

INDEX UNIQUE SCAN

InfiniBand network

In-memory_parallel execution

Interested Transaction List (ITL)

Inter-process communication (IPC)

I/O-per-second (IOPS) rate

Kernel Data Scan (KDS)

Least-Recently-Used algorithm

Metrics and counters

My Oracle Support (MOS)

NO_STATEMENT_QUEUING hint

objectNumber attribute

Offloading function

    agg_smart_scan_ex.sql script

    COUNT() query

    multi-row function

    offloadable_fn_tbl.sql script

    single-row function

OLTP compression

Online Transaction Processing (OLTP)

Oracle Customer Support (OCS)

Oracle Enterprise Manager (OEM)

parallel_min_time_threshold parameter

Parallel processing

    DOP

    in-memory parallel execution

    I/O calibration

    Oracle 11.2.0.x

    V$SQL_MONITOR view

Parallel query

    Auto DOP (see Auto DOP)

    average salary results

    control issues

    degree of parallelism (DOP)

    GV$SQL_MONITOR

    in-memory parallel execution

    parallel_adaptive_multi_user parameter

    parallel_degree_policy

    parallel_servers_target

    queue

    settings

    sql_exec_id

    V$SQL_MONITOR

parallel_servers_target setting

Performance metrics

    black boxes

    counters

        AWR reports

        cache layer

        cell CPU usage

        cell num fast response sessions

        chained rows

        commit cache

        data layer

        dynamic counters

        efficiency

        flash cache

        index layer

        INDEX RANGE SCAN

        index scans

        IO uncompressed bytes

        minscn optimization

        passthru mode

        physical IO bytes

        Smart Scan activity

        SQL statement

        tkprof report

        txn layer

        V$SQL and GV$SQL

    Smart Scans

Predicate Filtering

Real Application Clusters (RAC)

Recovery Manager (RMAN)

Serial Attached SCSI (SAS)

Single Client Access Name (SCAN) listener

SizeArr Values and resulting storage allocations

Smart Flash Cache

    ALTER INDEX command

    ALTER TABLE command

    CellCLI

    CELL_FLASH_CACHE setting

    CELLSRV

    CREATE TABLE statement

    DEFAULT setting

    disk

        ASM

        CREATE DISKGROUP command

        flash disk group

        HIGH redundancy

        NORMAL redundancy

        sid

    Energy Storage Module (ESM)

    Exadata

    hints

    KEEP setting

    Log

    monitoring

        database server tools

        storage server tools (see Storage server tools)

    NONE setting

    non-Exadata systems

    nonvolatile memory

    per-cell caching mechanism

    Sun Flash PCIe cards

Smart Scans

STATEMENT_QUEING hint

Storage Appliance for Grid Environments (SAGE)

Storage cell monitor

    administrative commands

    celladmin (see Celladmin)

    cellcli interface

    cellcli utility

    cell metric names

    cellmonitor account

    DATA_MYEXA1 disk group

    DBFS disk group

    dcli

    DESCRIBE command

    disk groups

    /etc/hosts file

    Exadata configuration

    flash disks

    Flash Log

    grid disks

    LIST commands

    LIST FLASHCACHE ATTRIBUTES ALL command

    operating-system management

    performance metrics

    physical drives

    recovery disk group

    slice sizes

    Smart Flash Cache

    Smart I/O metrics

    Smart Scans

    ssh command

    storage cell operation

    transaction process

    “wrapper” script

Storage cells

    command-line

        CellCLI and cellsrvstat

        collection interval

        cumulative values

        disk failures/firmware mismatches

        error metrics

        metric history

        rate metrics

        Smart Flash Cache

    OEM 12c

    O/S metrics

        ASM storage

        CPU report format

        device report

        extended report

        iostat utility

Storage index

    anti-index

    vs. B-tree index

    cell maintenance

    cumulative metric

        data skipped

        definition

        false positives

        I/O savings

    data clustering

    data distribution

        Exadata reports

        partition

        schema owner

        table size

    execution plans

    index segments

    key data location

    memory-resident structures

    NULL searches

    NULL values

    rebuild

    Smart Scan

storage_index_ex.sql script

storage_index_part_ex.sql script

Storage-reconfiguration process

    archived files and directories

    ASM

    ASR

    calibrate process

    cell alerts

    cellinit.ora file

    clean system—one

    cpio utility

    DBM cluster database

    deploy11203.sh script

    destructive process

    disk groups

    errors

    Exadata configuration

    Exadata system

    GRID Infrastructure

    GRID software

    high capacity disks

    InfiniBand connectivity

    new logical storage partitions

    OEM agents

    oracle kernel

    “oracle” O/S user home

    original storage configuration

    passwordless ssh connectivity

    pending and completed tasks

    recovery storage

    reset “oracle” O/S password

    SCAN listener

    scripts and configuration files

    server name

    storage array parameter

    tar command

    V$ASM_DISKGROUP

Storage server tools

    CELL_FLASH_CACHE

    excluding metrics

    LIST FLASHCACHECONTENT command

    LIST METRICCURRENT statement

    logfile and badfile

    metrics and descriptions

    object_id values

    output script

    query writing

SYS_OP_BLOOM_FILTER function

TABLE ACCESS BY INDEX ROWID

TABLE ACCESS STORAGE FULL

tableSpaceNumber attribute

TALENT_CD

Time-consuming trial-and-error process

V$MYSTAT query

V$SQLFN_METADATA view

V$SQL_MONITOR view

Wait events. See also Cell wait event