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 |