A

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]

ACCEPT_SQL_PROFILE function
Access Advisor [See SQL Access Advisor]
access control 2nd
access path analysis
     SQL Tuning Advisor
accessing
     RMAN (Recovery Manager) 2nd
ACTION colummn (V$ACTIVE_SESSION_HISTORY)
Active Session History [See ASH]
Active Session History (ASH)
ADD ALIAS clause (ALTER DISKGROUP command)
ADD DATABASE command
ADD DIRECTORY clause (ALTER DISKGROUP command)
ADD DISK clause (ALTER DISKGROUP command) 2nd
Add Standby Database wizard
ADD_SQLSET_REFERENCE function
ADD_SQLWKLD_REF function
ADD_SQLWKLD_STATEMENT function
Additional Information findings (ADDM) 2nd
ADDM (Automatic Database Diagnostic Monitor) 2nd 3rd 4th
     accessing from OEM 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
    ADDM reports, analyzing
         Additional Information findings 2nd
         cross-verification from advisor views 2nd
         expected I/O response time
         idle events 2nd 3rd
         session management 2nd
         SQL statements consuming significant time 2nd 3rd 4th 5th
         SQL statements waiting for locks 2nd
     addmrpt.sql script 2nd 3rd 4th
     ASH data 2nd
     cases when ADDM analysis is not done
     DBMS_ADVISOR package 2nd 3rd 4th
     goal of 2nd
     new features 2nd
     non-problematic areas 2nd
     problem areas handled by 2nd
     recommendations 2nd 3rd
     rules
     views 2nd 3rd 4th
         DBA_ADVISOR_ACTIONS
         DBA_ADVISOR_FINDINGS 2nd
         DBA_ADVISOR_LOG
         DBA_ADVISOR_RATIONALE
         DBA_ADVISOR_RECOMMENDATIONS
ADDM Main page (OEM) 2nd
addmrpt.sql script 2nd 3rd 4th
administrator privileges
     granting 2nd
     revoking
Advanced Queuing (AQ)
Advisor Central 2nd
advisors 2nd 3rd 4th
     ADDM (Automatic Database Diagnostic Monitor) 2nd
         accessing from OEM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
         Additional Information findings 2nd
         addmrpt.sql script 2nd 3rd 4th
         ASH data 2nd
         cases when ADDM analysis is not done
         cross-verification from advisor views 2nd
         DBMS_ADVISOR package 2nd 3rd 4th
         expected I/O response time
         goal of 2nd
         idle events 2nd 3rd
         new features 2nd
         non-problematic areas 2nd
         problem areas handled by 2nd
         recommendations 2nd 3rd
         rules
         session management 2nd
         SQL statements consuming significant time 2nd 3rd 4th 5th
         SQL statements waiting for locks 2nd
         views 2nd 3rd 4th
     Segment Advisor 2nd
         invoking from OEM 2nd 3rd
         invoking from PL/SQL 2nd
         reviewing results of 2nd
     SQL Access Advisor 2nd 3rd 4th 5th
         APIs 2nd 3rd 4th 5th
         DBMS_ADVISOR package 2nd 3rd 4th 5th
         inputs 2nd
         materialized views
         new features
         OEM interface 2nd 3rd 4th 5th 6th 7th 8th
         potential pitfalls 2nd
         steps for use
     SQL Tuning Advisor 2nd 3rd 4th 5th 6th 7th
         access path analysis
         APIs 2nd 3rd 4th 5th 6th 7th
         Automatic Tuning Optimizer 2nd 3rd 4th
         DBMS_SQLTUNE package 2nd 3rd 4th 5th
         inputs 2nd
         OEM interface 2nd 3rd 4th
         potential pitfalls 2nd
         SQL profiling
         SQL structure analysis
         statistics analysis
         STS (SQL tuning sets) 2nd 3rd
     Undo Advisor 2nd 3rd 4th 5th
alerts 2nd 3rd 4th
     clearing 2nd
     metrics 2nd 3rd
         non-threshold alerts
         sending to third-party tools 2nd
         server-generated alerts
         stateless alerts
         threshold alerts
     setup 2nd
aliases
     ASM files 2nd
ALL clause (ALTER DISKGROUP command)
ALL_ views
ALL_LOGFILES keyword
ALL_ROLES keyword
allocating resources
     segment management 2nd 3rd
ALTER DATABASE ARCHIVELOG command 2nd
ALTER DATABASE BEGIN BACKUP command
ALTER DATABASE END BACKUP command
ALTER DATABASE START LOGICAL STANDBY APPLY command
     SKIP FAILED TRANSACTION clause
ALTER DISKGROU command
ALTER DISKGROUP command 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
ALTER TEMPLATE clause (ALTER DISKGROUP command)
ALTER_SQL_PROFILE function
ANALYZE command
     COMPUTE STATISTICS option
analyzing
    ADDM reports
         SQL statements consuming significant time 2nd 3rd 4th 5th
         SQL statements waiting for locks 2nd
     statistics 2nd
APIs
     SQL Access Advisor and 2nd 3rd 4th 5th
     SQL Tuning Advisor and 2nd 3rd 4th 5th 6th 7th
application partitioning
AQ (Advanced Queuing)
archive logs
archive_source keywords
Archiver processes (ARCn)
archiving
     Data Guard 2nd
ARCn (Archiver processes)
ASH
     ADDM (Automatic Database Diagnostic Monitor) 2nd
ASH (Active Session History) 2nd
     buffer contents, dumping 2nd 3rd
     displaying 2nd
     documentation
     fixed-size circular buffers 2nd
     hidden parameters
     limitations 2nd
     OEM Database Control 2nd
     session-state information 2nd 3rd 4th
     spot analysis example 2nd 3rd 4th 5th
     V$ACTIVE_SESSION_HISTORY 2nd 3rd
     V$ACTIVE_WAIT_HISTORY
     V$SESSION_WAIT 2nd
     WRH$_ACTIVE_SESSION_HISTORY 2nd
ASM (Automatic Storage Management) 2nd 3rd 4th 5th
    ASM files
         aliases 2nd
         definition of
         filenames
     configuration 2nd 3rd 4th
         DBCA (Database Configuration Assistance)
         initialization parameters 2nd
         remote connections
         startup/shutdown commands 2nd
    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
     failure groups
     improvements and new features 2nd
     installations on Linux
     managing with RAC 2nd
     maximum file size 2nd
    migration
         ASM to non-ASM migration 2nd 3rd
         non-ASM to ASM migration 2nd 3rd
     multiple Oracle instances 2nd
     operational limits
     prerequisites 2nd
     RAC environments
         discovering ASM instances in 2nd
         VIP timeouts and VIP failure 2nd 3rd
     startup/shutdown commands 2nd
     troubleshooting connections 2nd
     when to use 2nd
ASM command-line interface (ASMCMD)
ASM files
     aliases 2nd
     definition of
     filenames
ASM_DISKGROUPS (NULL) parameter
ASM_DISKSTRING (NULL) parameter
ASM_POWER_LIMIT (1) parameter
ASMB process
ASMCMD (ASM command-line interface)
ASMM (Automatic Shared Memory Management) 2nd 3rd 4th 5th
     auto-tuned SGA parameters
     automated maintenance tasks 2nd
     converting manual memory-managed databases to 2nd
     initialization parameters 2nd 3rd 4th 5th
     Memory Advisor 2nd 3rd
     memory management tips 2nd 3rd
     new features 2nd
     scaling for database expansion 2nd
     SGA sizing 2nd
     SGA_MAX_SIZE 2nd
     SGA_TARGET 2nd
ASSM (automatic segment-space management) 2nd
     data blocks
     data segments
     dictionary-managed tablespaces 2nd
     disabling
     enabling
     extents
     HWM (high-water mark)
     index segments
     LMT (locally managed tablespaces)
     new features 2nd
     Segment Advisor 2nd
         invoking from OEM 2nd 3rd
         invoking from PL/SQL 2nd
         reviewing results of 2nd
     segment resource allocation 2nd 3rd
     segment-shrink operations 2nd 3rd 4th
     temporary segments 2nd 3rd
asynchronous redo transmission
ATTACH keyword
audits
     FGA (fine-grained auditing)
authentication
     redo transmission authentication and encryption 2nd
AUTO EXTEND initialization parameter 2nd
auto-tuned SGA parameters
automated maintenance tasks 2nd
automatic alerts 2nd
     clearing 2nd
     setup 2nd
Automatic Database Diagnostic Monitor [See ADDM]
Automatic Database Diagnostic Monitor (ADDM) 2nd
automatic extension
     Flashback Database
automatic failover 2nd
automatic segment-space management [See ASSM]
Automatic Shared Memory Management [See ASMM]
automatic SQL tuning 2nd 3rd 4th
automatic statistics collection 2nd
    AWR snapshots
         creating
         dropping
         frequency of 2nd
         retention period
     base statistics
     baselines
         creating
         dropping
     metrics 2nd
         thresholds
     operating-system statistics
     session statistics 2nd
     statistics levels 2nd
     system statistics 2nd
     time-model statistics 2nd
     wait events 2nd
Automatic Storage Management [See ASM]
Automatic Storage Management (ASM) 2nd
Automatic Tuning Optimizer 2nd 3rd 4th
automatic undo
     Flashback Table
automatic undo management 2nd
     advantages of 2nd
     AUTO EXTEND initialization parameter 2nd
     guaranteeing undo availability 2nd 3rd
     new features 2nd
     OEM (Oracle Enterprise Manager) 2nd
     RAC (real application clusters) 2nd
     redo log file sizings 2nd
     resumable space allocation 2nd
     tips 2nd
     Undo Advisor 2nd 3rd 4th 5th
     undo data 2nd
     UNDO_MANAGEMENT initialization parameter
     UNDO_RETENTION initialization parameter 2nd
Automatic Workload Repository [See AWR]
Automatic Workload Repository (AWR) 2nd
AUX_STATS$ table 2nd
AWR
     reports, generating
         awrddrpt.sql script 2nd 3rd 4th 5th
         awrrpt.sql script 2nd 3rd 4th 5th 6th
         awrrpti.sql script 2nd 3rd
         awrsqrpi.sql script 2nd 3rd 4th
    snapshots
         creating
         dropping
         frequency of 2nd
         retention period
AWR (Automatic Workload Repository) 2nd 3rd 4th 5th [See also ASH (Active Session History)]
     baselines 2nd
         capturing 2nd
         dropping 2nd 3rd
     buffers
     collections 2nd 3rd
     compared to STATSPACK 2nd
     customizing with OEM 2nd
     DBMS_WORKLOAD_REPOSITORY package 2nd
         creating snapshots 2nd
         deleting snapshots
         modifying AWR settings 2nd
     dependencies 2nd 3rd
     emergency purging
     licensing information
     memory requirements
     new features 2nd
     overheads
    snapshots
         accessing 2nd 3rd
         creating 2nd
         deleting
     storage and reporting 2nd 3rd 4th 5th
     suggested settings 2nd
     views 2nd 3rd
     WRH$ tables
     WRI$ tables
     WRM$ tables
AWR Snapshot page (OEM)
AWR_REPORT_HTML function
AWR_REPORT_TEXT function
awrddrpt.sql script 2nd 3rd 4th 5th
awrinfo.sql script
awrinput.sql script
awrrpt.sql script 2nd 3rd 4th 5th 6th 7th 8th
awrrpti.sql script 2nd 3rd 4th