SUSE LINUX Enterprise Server 9 Administrators Handbook

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

daemons

     CRSD

     CSS

     EVMD

     OCSSD 2nd

data blocks

Data Definition Language (DDL) 2nd

data dictionary cache

Data Encryption Standard algorithm (DES)

Data Guard 2nd

     archiving 2nd

     Broker improvements

         ADD DATABASE command

         CREATE CONFIGURATION command 2nd

         DISABLE DATABASE command

         EDIT CONFIGURATION command

         EDIT DATABASE command

         EDIT INSTANCE command 2nd

         ENABLE DATABASE command

         FAILOVER command 2nd

         GUI enhancements 2nd 3rd 4th 5th 6th

         RAC database support 2nd

         REMOVE DATABASE command

         SHOW command

         SWITCHOVER command

     configuration management 2nd

     DB_UNIQUE_NAME initialization parameter 2nd

     Flashback Database 2nd 3rd 4th 5th 6th

     flashback database support 2nd

     goals of

     logical databases, patching 2nd 3rd 4th 5th 6th

     logical standby improvements

         commands and views 2nd 3rd

         PREPARE TO SWITCHOVER command 2nd

         redo log file support

         SQL Apply rolling database upgrades 2nd

         SQL Apply service support 2nd

         zero outage for instantiation 2nd 3rd 4th

     new features

         asynchronous redo transmission

         automatic failover 2nd

         Flashback Database across switchovers

         redo apply failover

         SQL Apply 2nd

     physical databases, patching 2nd 3rd 4th 5th

     RAC (Real Application Clusters) installation

     Real Time Apply 2nd 3rd

     redo transmission authentication and encryption 2nd

     role-based destinations 2nd 3rd 4th

     STARTUP command 2nd

Data Manipulation Language (DML) 2nd

Data Pump 2nd 3rd 4th 5th 6th 7th

     AQ (Advanced Queuing)

     command-line parameters 2nd

     command-line support

     DATA_PUMP_DIR directory object

     DBMS_DATAPUMP engine

     DPAPI (Direct Path API)

     dump-file sets

     Enterprise Manager support

     expdp (export) client 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

         full-export mode

         new features

         sample application 2nd 3rd 4th 5th 6th 7th

         schema-export mode

         table-export mode

         tablespace-export mode

         transportable-tablespace-export mode

     external clients

     External Table Services API

     external table support 2nd 3rd 4th 5th 6th

     impdp (import) client 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

         full-import mode

         new features

         sample application 2nd 3rd 4th 5th 6th 7th

         schema-import mode

         table-import mode

         tablespace-import mode

         transportable-tablespace-import mode

     interactive-mode parameters

     Metadata API

     new features/enhancements 2nd

     operation precedence 2nd

     process flow 2nd 3rd

     SQL Loader client

     tracing 2nd

     views 2nd

data segments

DATA_PUMP_DIR directory object

DATA_PUMP_DIR directory objects

DATA_PUMP_DIR environment variable

Database Administration screen (10g iSQL*Plus workspace)

database blocks

database buffer cache

Database Configuration Assistance (DBCA)

     ASM (Automatic Storage Management) configuration

Database Configuration Assistant [See DBCA]

Database Configuration Assistant (DBCA) 2nd 3rd

Database Control (OEM)

     concurrency-related wait information 2nd

     example 2nd 3rd 4th

     general database and host information 2nd

     home page 2nd

     host and database wait information 2nd

     host performance CPU drill-down details 2nd

     host performance memory drill-down details

     host performance summary 2nd

     SQL Tuning Advisor 2nd 3rd

     Top SQL 2nd

     tuned execution plans

Database Performance page (OEM)

database Point-In-Time Recovery (DBPITR)

database scheduler 2nd

database statistics [See statistics]

Database Upgrade Assistant [See DBUA]

Database Writer process (DBWn)

database-specific resources

database_role keywords

databases [See also installation]

     database and binary cloning 2nd

         common steps 2nd 3rd

         OEM (Oracle Enterprise Manager) 2nd 3rd

     database-specific resources

     databases instances, identifying 2nd

     Flashback Database 2nd 3rd

         automatic extension

         configuring 2nd 3rd 4th

         Data Guard 2nd 3rd 4th 5th 6th

         flashback logs 2nd

         initialization parameters 2nd

         managing 2nd 3rd 4th

         RVWR (recover writer)

         sample flashback operation 2nd 3rd 4th 5th 6th 7th 8th 9th

         troubleshooting 2nd 3rd

         V$FLASHBACK_DATABASE_LOG 2nd

         V$FLASHBACK_DATABASE_STAT 2nd

     flashback database support 2nd

    global database changes

         flashback technology 2nd

     logical standby databases

         logical standby commands and views 2nd 3rd

         PREPARE TO SWITCHOVER command 2nd

         redo log file support

         SQL Apply rolling database upgrades 2nd

         SQL Apply service support 2nd

         zero outage for instantiation 2nd 3rd 4th

     migrating from 8i or 9i 2nd

     paching 2nd

    patching

         logical databases 2nd 3rd 4th 5th 6th

         physical databases 2nd 3rd 4th 5th

    RAC

         Broker support for RAC databases 2nd

     removing 2nd 3rd 4th

     scaling for expansion 2nd

    target databases, unregistering

         RMAN (Recovery Manager) 2nd

    upgrading

         RMAN (Recovery Manager) 2nd

         rolling database upgrades 2nd

         statistics collection

DB_CACHE_SIZE parameter

DB_FLASHBACK_RETENTION_TARGET initialization parameter

DB_nK_CACHE_SIZE parameter (italic n)

DB_RECOVERY_FILE_DEST initialization parameter

DB_RECOVERY_FILE_DEST parameter

DB_RECOVERY_FILE_DEST_SIZE initialization parameter

DB_RECOVERY_FILE_DEST_SIZE parameter

DB_UNIQUE_NAME (+ASM) parameter

DB_UNIQUE_NAME initialization parameter 2nd 3rd 4th

DBA_ views

DBA_ADVISOR_ACTIONS view

DBA_ADVISOR_FINDINGS view 2nd

DBA_ADVISOR_LOG view

DBA_ADVISOR_RATIONALE view

DBA_ADVISOR_RECOMMENDATIONS view

DBA_DATAPUMP_JOBS view

DBA_DATAPUMP_SESSIONS view

DBA_HIGH_WATER_MARK_STATISTICS view

DBA_HIST_DATABASE_INSTANCE view

DBA_HIST_JAVA_POOL_ADVICE view

DBA_HIST_SEG_STAT view

DBA_HIST_SNAPSHOT view

DBA_HIST_WR_CONTROL view

DBA_STREAMS_ADMINISTRATOR view

DBCA

     XML DB installation 2nd

DBCA (Database Configuration Assistance)

     ASM (Automatic Storage Management) configuration

DBCA (Database Configuration Assistant) 2nd 3rd 4th 5th 6th 7th

     creation options

     database content

     database credentials

     database file options

     database identification

     database storage

     database templates

     initialization parameters

     management options

     recovery configuration

     storage options

     tracing 2nd

DBMS_ADVISOR package 2nd 3rd 4th 5th 6th 7th

     ADDM-specific functions and procedures 2nd 3rd 4th

     cross-checking results 2nd

     functions and procedures 2nd

     implementation scripts 2nd

     sample code listing 2nd

DBMS_DATAPUMP engine

DBMS_DATAPUMP package [See Data Pump]

DBMS_FILE_TRANSFER package

DBMS_RESOURCE_MANAGER 2nd

DBMS_SCHEDULER 2nd

DBMS_SQLTUNE package 2nd 3rd 4th 5th

     errors 2nd

     functions and procedures 2nd

     sample code listing 2nd

DBMS_STATS command

DBMS_STREAMS_AUTH package 2nd 3rd

DBMS_WORKLOAD_REPOSITORY command 2nd

DBMS_WORKLOAD_REPOSITORY package 2nd

     creating snapshots 2nd

     deleting snapshots

     modifying AWR settings 2nd

DBPITR (database Point-In-Time Recovery)

DBUA (Database Upgrade Assistant) 2nd

     Oracle 9i physical logical configuration 2nd 3rd 4th 5th

     Oracle 9i physical standby configuration 2nd 3rd 4th 5th

     silent mode

     upgrade paths for standby environments 2nd

DBWn (Database Writer process)

DDL (Data Definition Language) 2nd

DDL_WAIT_FOR_LOCKS initialization parameter

DEFINE command 2nd 3rd

     _DATE variable

     _PRIVILEGE variable

     _USER variable

DELETE ALIAS clause (ALTER DISKGROUP command)

DELETE_SQLWKLD function

DELETE_SQLWKLD_REF function

DELETE_SQLWKLD_STATEMENT function

DELETE_TASK function

deleting [See dropping]

     AWR (Automatic Workload Repository) snapshots

     flashback logs

dependencies (AWR) 2nd 3rd

DES (Data Encryption Standard algorithm)

destinations

     role-based destinations 2nd 3rd 4th

dictionaries

     dictionary statistics

dictionary statistics

dictionary-managed tablespaces

     ASSM (automatic segment-space management) 2nd

Direct Path API (DPAPI

directories

     disk groups 2nd

     ORACLE_HOME/bin

     ORACLE_HOME/hostname_sid

     ORACLE_HOME/sysman

DIRECTORY parameter

disable command

DISABLE DATABASE command

disabling

     ASSM (automatic segment-space management)

     Flashback Drop 2nd

disaster recovery

disk drives [See also ASM (Automatic Storage Management)]

    disk groups

         adding disks to 2nd

         checking internal consistency of 2nd

         creating 2nd

         definition of

         directory structure 2nd

         disk-group templates 2nd 3rd

         dropping 2nd

         dropping disks from 2nd

         failure groups

         mounting 2nd

         rebalancing 2nd

         redundancy

         resizing disks in 2nd

disk groups

     adding disks to 2nd

     checking internal consistency of 2nd

     creating 2nd

     definition of

     directory structure 2nd

     disk-group templates 2nd

         adding

         definition of

         dropping

     dropping 2nd

     dropping disks from 2nd

     failure groups

     mounting 2nd

     rebalancing 2nd

     redundancy

     resizing disks in 2nd

disk-group templates 2nd

     adding

     definition of

     dropping

disk-space management [See ASM (Automatic Storage Management)]

DISMOUNT clause (ALTER DISKGROUP command)

displaying

     session-state information 2nd

DML (Data Manipulation Language) 2nd

documentation

     RMAN (Recovery Manager) 2nd

downgrade option (ocrconfig command)

downstream capture (streams) 2nd

DPAPI (Direct Path API)

dpexp (Data Pump Export)

dpimp (Data Pump Import)

dr0inst.sql script

drivers

     Oracle Data Pump driver

     Oracle Loader driver

DROP DATABASE command

DROP DIRECTORY clause (ALTER DISKGROUP command)

DROP DISK clause (ALTER DISKGROUP command) 2nd

DROP DISKGROUP command 2nd

DROP FILE clause (ALTER DISKGROUP command)

DROP TABLE command

DROP TABLESPACE command

DROP TEMPLATE clause (ALTER DISKGROUP command)

DROP USER command

DROP_BASELINE command

DROP_BASELINE function 2nd 3rd

DROP_SNAPSHOT_RANGE command

DROP_SNAPSHOT_RANGE function 2nd

DROP_SQL_PROFILE function

DROP_SQLSET function

DROP_SQLSET_REFERENCE function

DROP_TUNING_TASK function

dropping

     ASM file aliases

     baselines 2nd 3rd 4th

     disk groups 2nd

     disk-group templates

     disks from disk groups 2nd

     files

     snapshots

    tables

         Flashback Drop 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

dump-file sets

dumping

     ASH buffer contents 2nd 3rd

DUPLICATE command

DURATION keyword (BACKUP command)

Dynamic performance views [See V$ views]

dynamic sampling 2nd 3rd 4th