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] cache data dictionary cache CANCEL_TASK function CANCEL_TUNING_TASK function Cannot flashback data file # no flashback log data (error) capturing baselines 2nd cardinality CBO (Cost Based Optimizer) 2nd CATALOG mode (RMAN) catnoqm.sql script catqm.sql script CBO (Cost Based Optimizer) 2nd capabilities 2nd 3rd 4th 5th cardinality 2nd COL_USAGE$ view 2nd 3rd column statistics column usage 2nd compared to RBO (Rule Based Optimizer) 2nd 3rd 4th COMPUTE versus ESTIMATE 2nd cost definition of 2nd dictionary statistics dynamic sampling 2nd 3rd 4th frequency of statistic collection histograms 2nd 3rd 4th 5th creating downsides 2nd viewing initialization parameters 2nd 3rd 4th 5th 6th 7th new features 2nd result sets selectivity 2nd SQL profiles 2nd 3rd 4th 5th compared to outlines tracing 2nd 3rd 4th system statistics 2nd 3rd 4th 5th 6th AUX_STATS$ table 2nd RAC environments table and index monitoring 2nd table statistics tracing 2nd 3rd centralized job control Change Password screen (10g iSQL*Plus workspace) Change Tracking Writer processes (CTWR) change-tracking files 2nd channels (RMAN) CHECK clause (ALTER DISKGROUP command) checking checking internal consistency of disk groups 2nd checklists, installation 2nd Checkpoint process (CKPT) CKPT (Checkpoint process) clauses [See commands] clearing alerts 2nd client processes CLIENT_ID colummn (V$ACTIVE_SESSION_HISTORY) cloning databases 2nd common steps 2nd 3rd OEM (Oracle Enterprise Manager) 2nd 3rd cluster interconnect 2nd Cluster Ready Services [See CLS] 2nd [See RAC (Real Application Clusters)] Cluster Verification Utility (CVU) clusters [See RAC (Real Application Clusters)] CMAN (Connection Manager) code listings ADDM (Automatic Database Diagnostic Monitor) accessing from OEM additional information cross-verification from advisor views 2nd DBA_ADVISOR_FINDINGS view 2nd idle events 2nd PL/SQL section 2nd printing ADDM rask reports running reports with SQL*Plus 2nd 3rd session mangement 2nd SQL statements consuming significant time 2nd 3rd SQL statements waiting for locks 2nd ASH (Active Session History) buffers, dumping 2nd 3rd session-state information spot analysis 2nd 3rd 4th AWR (Automatic Workload Repository) awrrpt.sql script report CREATE_BASELINE function CREATE_SNAPSHOT function DROP_BASELINE function DROP_SNAPSHOT_RANGE function MODIFY_SNAPSHOT_SETTINGS function report headings 2nd V$SYSAUX_OCCUPANTS view awrddrpi.sql script 2nd 3rd awrddrpt.sql script 2nd 3rd 4th awrrpt.sql script 2nd awrrpti.sql script 2nd 3rd CBO (Cost Based Optimizer) 10052 event trace file 2nd AUX_STATS$ system statistics 2nd initialization parameters 2nd 3rd 4th 5th 6th SQL profile trace 2nd 3rd 4th DBMS_ADVISOR package cross-checking results 2nd example 2nd implementation scripts 2nd DBMS_SQLTUNE package errors 2nd example 2nd OEM installation EMCA installation script 2nd emctl command 2nd OEM control, checking status of performance tuning event histogram for SQL*Net events file-wise read response histogram OEM Database Control 2nd 3rd V$FILE_HISTOGRAM view 2nd V$OSSTAT snapshot 2nd V$SERVICE_EVENT snapshot 2nd V$SERVICE_STATS snapshot V$SERVICE_WAIT_CLASS snapshot 2nd V$SESSION view V$SYS_TIME_MODEL snapshot 2nd V$SYSTEM_WAIT_CLASS snapshot 2nd Wait event histograms for database reads 2nd RMAN (Recovery Manager) backup pieces 2nd change-tracking files 2nd incrementally updated backup 2nd 3rd 4th 5th sample backup session 2nd 3rd 4th SGA_TARGET tuning SNAP_IDs statistics COL_USAGE$ view 2nd 3rd cold backups collecting statistics 2nd 3rd timeouts, preventing collecting statistics during database upgrades recommendations 2nd column statistics columns column statistics comamnds DROP DISKGROUP 2nd 2nd [See specific command names] [See also DBMS_SQLTUNE package; functions and procedures] ADD DATABASE ALTER DATABASE ARCHIVELOG 2nd ALTER DATABASE START LOGICAL STANDBY APPLY SKIP FAILED TRANSACTION clause ALTER DISKGROU ALTER DISKGROUP 2nd 3rd ADD ALIAS clause ADD DIRECTORY clause ADD DISK clause 2nd ALL clause ALTER TEMPLATE clause CHECK clause DELETE ALIAS clause DISMOUNT clause DROP DIRECTORY clause DROP DISK clause 2nd DROP FILE clause DROP TEMPLATE clause MOUNT clause NOREPAIR clause REBALANCE clause 2nd RENAME ALIAS clause RENAME DIRECTORY clause RESIZE clause 2nd ANALYZE COMMIT TO SWITCHOVER 2nd CREATE CONFIGURATION 2nd CREATE DISK GROUP 2nd CREATE TABLESPACE CREATE TABLESPACE SYSAUX DBMS_STATS DEFINE 2nd 3rd _DATE variable _PRIVILEGE variable _USER variable disable DISABLE DATABASE dpexp (Data Pump Export) dpimp (Data Pump Import) DROP DATABASE DROP TABLE DROP TABLESPACE DROP USER EDIT CONFIGURATION EDIT DATABASE EDIT INSTANCE 2nd emctl 2nd enable ENABLE DATABASE EXPLAIN PLAN 2nd FAILOVER 2nd FLASHBACK DATABASE 2nd 3rd FLASHBACK TABLE 2nd 3rd FLASHBACK TABLE .. TO BEFORE DROP FLASHBACK_TRANSACTION_QUERY 2nd 3rd LOCK_SCHEMA_STATS LOCK_TABLE_STATS lsnrctl ocrcheck ocrconfig 2nd ocrdump ORADEBUG PREPARE TO SWITCHOVER 2nd PURGE relocate REMOVE DATABASE RESETLOGS 2nd 3rd 4th SET SERVEROUTPUT SET SQLROMPT command 2nd SET XQUERY SHOW SHUTDOWN ABORT SHUTDOWN IMMEDIATE SHUTDOWN NORMAL SHUTDOWN TRANSACTIONAL SPOOL 2nd 3rd STARTUP 2nd STARTUP FORCE STARTUP MOUNT 2nd STARTUP NOMOUNT STARTUP OPEN SWITCHOVER UPGRADE CATALOG VERSION_BETWEEN VERSIONS_BETWEEN 2nd XQUERY COMMIT TO SWITCHOVER command 2nd companion CD installation 2nd COMPLEX_VIEW_MERGING initialization parameter compressed backups COMPRESSED keyword (BACKUP command) COMPRESSION initialization parameter COMPUTE option (object statistics) 2nd COMPUTE STATISTICS option (ANALYZE command) computing grid characteristics of 2nd compared to electricity grid consumer's point of view 2nd producer's point of view 2nd components of 2nd definition of 2nd EGA (Enterprise Grid Alliance) enterprise grid computing hardware independence high availability history of 2nd managing 2nd 3rd performance profiled resource usage provisioning resiliency self-healing virtualization 2nd 3rd configuration [See installation] ASM (Automatic Storage Management) 2nd 3rd 4th DBCA (Database Configuration Assistance) initialization parameters 2nd remote connections startup/shutdown commands 2nd Flashback Database 2nd 3rd 4th Flashback Table 2nd Configure Backup Settings screen (OEM) Configure Recovery Catalog Settings (OEM) Configure Recovery Settings screen (OEM) CONNECT TARGET command Connection Manager (CMAN) consistency of disk groups, checking 2nd ConText [See Oracle Text] CONTEXT option (SET XQUERY command) controls 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 converting manual memory-managed databases to ASMM 2nd COPY command cost 2nd [See also CBO (Cost Based Optimizer)] definition of 2nd Cost Based Optimizer [See CBO] crawlers CREATE CONFIGURATION command 2nd CREATE DISK GROUP command 2nd CREATE TABLE AS SELECTÉ command CREATE TABLE command MONITORING keyword CREATE TABLESPACE command CREATE TABLESPACE SYSAUX command CREATE_BASELINE command 2nd CREATE_BASELINE function 2nd 3rd CREATE_FILE function CREATE_SNAPSHOT function 2nd 3rd CREATE_SQLSET function CREATE_SQLWKLD function CREATE_TASK function 2nd CREATE_TUNING_TASK function cross-checking statistics 2nd cross-platform transportable tablespaces 2nd cross-verifying ADDM reports 2nd 2nd 3rd 4th [See RAC (Real Application Clusters)] CRSD daemon database-specific resources EVMD daemon Fujitsu clustering installing 2nd 3rd 4th 5th 6th 7th 8th 9th OCR (Oracle Cluster Registry) OCSSD daemon 2nd troubleshooting 2nd Veritas CRSD daemon CSS (Cluster Synchronization Services) configuring 2nd 3rd CSS daemon CTWR (Change Tracking Writer processes) CURRENT_BLOCK# colummn (V$ACTIVE_SESSION_HISTORY) CURRENT_FILE# colummn (V$ACTIVE_SESSION_HISTORY) CURRENT_OBJ# colummn (V$ACTIVE_SESSION_HISTORY) custom installation OEM 2nd 3rd alerts 2nd 3rd 4th EM2Go 2nd installation process 2nd 3rd 4th 5th metric-thresholds management 2nd Oracle management agents, controlling 2nd preinstallation requirements 2nd Oracle Text 2nd 3rd manual installation 2nd Oracle Spatial installation 2nd Oracle UltraSearch installation 2nd search issues RAC (Real Application Clusters) 2nd Data Guard manual installation 2nd 3rd 4th RMAN (Recovery Manager) 2nd 3rd 4th backup pieces database upgrades 2nd target databases, unregistering 2nd unused block compression XML DB 2nd DBCA 2nd listener configuration on non-standard ports manual installation 2nd removing 2nd timeout levels XQuery support 2nd customizing AWR (Automatic Workload Repository) 2nd DBMS_WORKLOAD_REPOSITORY package 2nd 3rd 4th 5th 6th 7th dependencies 2nd 3rd emergency purging OEM (Oracle Enterprise Manager) 2nd suggested settings 2nd metrics 2nd CVU (Cluster Verification Utility) |