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]

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