C


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)



Oracle Database 10g Insider Solutions
SUSE LINUX Enterprise Server 9 Administrators Handbook
ISBN: 672327910
EAN: 2147483647
Year: 2006
Pages: 214

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net