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]

OBJ# column (COL_USAGE$)

object partitioning

object statistics [See also system statistics]

     column statistics

     COMPUTE option 2nd

     dictionary statistics

     dynamic sampling 2nd 3rd 4th

     ESTIMATE option 2nd

     frequency of collection

     locking down

     table statistics

OCOPY command

OCR (Oracle Cluster Registry) 2nd 3rd 4th

ocrcheck command

ocrconfig command 2nd

ocrdump command

OCSSD daemon 2nd

OEM 2nd 3rd

     (Oracle Enterprise Manager)

     accesssing ADDM (Automatic Database Diagnostic Monitor) from 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

         ADDM Main page 2nd

         Advisor Central 2nd

         AWR Snapshot page

         Database Performance page

         performance finding details 2nd 3rd 4th

         SQL details for PL/SQL block 2nd 3rd

     alerts 2nd

         clearing 2nd

         setup 2nd

     ASH (Active Session History), obtaining 2nd

     AWR (Automatic Workload Repository), customizing 2nd

     database cloning 2nd 3rd

     EM2Go 2nd

     installation process 2nd 3rd 4th 5th

         emctl command 2nd

         Enterprise Manager Configuration Assistant (EMCA) installation script 2nd

         OEM control, checking status of 2nd

     Memory Advisor 2nd

     metric-thresholds management 2nd

    metrics

         definition of

         metric-thresholds management 2nd

     Oracle management agents, controlling 2nd

     preinstallation requirements 2nd

     Segment Advisor, invoking 2nd 3rd

    SQL Access Advisor OEM interface

         input screen 2nd 3rd 4th 5th

         recommendation details 2nd

         results screen 2nd

     SQL Tuning Advisor OEM interface

         Preserved Snapshot Sets

         results screen

         Schedule Advisor 2nd

         Snapshots

         SQL Tuning Sets

         Top SQL

OEM (Oracle Enterprise Manager)

     automatic undo management 2nd

     performance tuning 2nd 3rd

         advisors 2nd

         alerts 2nd

         configuration changes

         metrics 2nd

         OEM Database Control 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th

OEM control, checking status of 2nd

OEM Database Control

     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

OFA (Optimal Flexible Architecture) 2nd

offline backups

OiD (Oracle internet Directory) Server

ONLINE_LOGFILE keyword

opatch utility 2nd 3rd

operating-system statistics

Optimal Flexible Architecture (OFA) 2nd

Optimizer [See CBO (Cost Based Optimizer)]

OPTIMIZER_DYN_SMP_BLKS initialization parameter

OPTIMIZER_DYNAMIC_SAMPLING initialization parameter

OPTIMIZER_MAX_PERMUTATIONS initialization parameter

OPTIMIZER_MAX_PERMUTATIONS parameter

OPTIMIZER_MODE initialization parameter 2nd

OPTIMIZER_SEARCH_LIMIT initialization parameter

OPTIMIZER_SEARCH_LIMIT parameter

OQO (Oracle Query Optimizer) [See CBO (Cost Based Optimizer)]

ORA-01455 error

ORA-15021 error

ORA-15055 error

ORA-17203 error

ORA-27041 error

ORA-38701 error

ORA-38729 error

ORA-38753 error

Oracle 8i, migrating databases from 2nd

Oracle 9i

     logical standby configuration 2nd 3rd 4th 5th

     physical standby configuration 2nd 3rd 4th 5th

Oracle 9i, migrating databases from 2nd

Oracle Applications 11i 2nd

Oracle Cluster Registry (OCR) 2nd 3rd 4th

Oracle Clusterware

Oracle Data Pump [See Data Pump]

Oracle Data Pump driver

Oracle Database 10g Backup and Recovery Advanced User's Guide

Oracle Database 10g Backup and Recovery Basics

Oracle Database 10g installation [See installation]

Oracle Database 10g Licensing

Oracle Database 10g Recovery Manager Quick Start Guide

Oracle Database 10g Recovery Manager Reference

Oracle Database 10g Security Guide

Oracle E-Business Suite 2nd

Oracle Enterprise Manager [See OEM]

Oracle Enterprise Manager (OEM)

Oracle Enterprise Manager Grid Control Installation and Basic Configuration 10g

Oracle internet Directory (OiD) Server

Oracle Java Virtual Machine (OracleJVM)

Oracle Label Security

Oracle Loader driver

Oracle management agents

     controlling 2nd

Oracle MetaLink

Oracle Name Server

Oracle processes

Oracle Query Optimizer (OQO) [See CBO (Cost Based Optimizer)]

Oracle software

     removing 2nd

Oracle Spatial

     installation 2nd

Oracle Streams

     architecture 2nd

     DBMS_STREAMS_AUTH package 2nd 3rd

     downstream capture 2nd

     stream propagation enhancements 2nd

     streams administrator 2nd 3rd

     streams pool 2nd

     streams-enhanced RAC support 2nd

Oracle Text 2nd 3rd

     manual installation 2nd

     Oracle Spatial installation 2nd

     Oracle UltraSearch installation 2nd

     search issues

Oracle UltraSearch

     installation 2nd

Oracle Universal Installer (OUI) [See installation]

Oracle Wait Interface 2nd 3rd 4th

ORACLE_HOME

     adding nodes to 2nd 3rd 4th

     installing 2nd

     removing nodes from 2nd 3rd 4th

ORACLE_HOME/bin directory

ORACLE_HOME/hostname_sid directory

ORACLE_HOME/sysman directory

OracleJVM (Oracle Java Virtual Machine)

ORADEBUG command

ORBn processes

ORDERING option (SET XQUERY command)

ordinst.sql script

OUI (Oracle Universal Installer) [See installation]

outlines

     compared to SQL profiles