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]

table statistics

table-export mode (expdp)

table-import mode (impdp)

tables

     AUX_STATS$ 2nd

    dropping

         Flashback Drop 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

     external table support (Data Pump) 2nd 3rd

     Flashback Table 2nd

         automatic undo

         configuring 2nd

         dropped tables

         sample flashback operation 2nd 3rd 4th 5th 6th 7th

         SYS_TEMP_FBT

         table-dependent objects

         troubleshooting 2nd 3rd 4th

     FTSes (full table scans) 2nd

     monitoring 2nd

     RAC (Real Application Clusters)

     SYS_TEMP_FBT

     table statistics

     WRH$ tables

     WRI$ tables

     WRM$ tables

tablespace Point-In-Time Recovery (TSPITR)

tablespace-export mode (expdp)

tablespace-import mode (impdp)

tablespaces

    ASSM (automatic segment-space management)

         dictionary-managed tablespaces 2nd

         locally managed tablespaces

     BFTs (BigFile tablespaces) 2nd 3rd

     cross-platform transportable tablespaces 2nd

     locally managed

     PENDING OFFLINE mode

     RAC (Real Application Clusters)

     renaming 2nd

    switching

         errors

     SYSAUX 2nd 3rd

         creating

     TTGs (temporary tablespace groups) 2nd

tags (RMAN)

target databases, unregistering

     RMAN (Recovery Manager) 2nd

templates

     disk-group templates 2nd

         adding

         definition of

         dropping

temporary segments 2nd 3rd

temporary tablespace groups (TTGs) 2nd

third-party cluster management 2nd

threshold alerts

thresholds

Time and Wait model 2nd 3rd 4th 5th 6th 7th

time-model statistics 2nd

TIME_WAITED colummn (V$ACTIVE_SESSION_HISTORY)

timeout levels

     changing

TIMESTAMP column (COL_USAGE$)

tnsnames.ora file 2nd 3rd 4th

tools

     STATSPACK 2nd 3rd 4th 5th 6th

         extending

         limitations of 2nd

         service time 2nd 3rd

         snapshots

         wait time

TRACE initialization parameter 2nd

tracing

     CBO (Cost Based Optimizer) 2nd 3rd

     Data Pump 2nd

     DBCA (Database Configuration Assistant) 2nd

     enabling

     SQL profiles 2nd 3rd 4th

transactions

     flashback transaction query 2nd

         sample flashback operation 2nd 3rd 4th 5th 6th

transportable-tablespace-export mode (expdp)

transportable-tablespace-import mode (impdp)

Triple-DES encryption

troubleshooting

     ASM (Automatic Storage Management) connections 2nd

     CRS (Cluster Ready Services) 2nd

     Flashback Database 2nd 3rd

     Flashback Drop 2nd

     Flashback Table 2nd 3rd 4th

     flashback versions query 2nd

TSPITR (tablespace Point-In-Time Recovery)

TTGs (temporary tablespace groups) 2nd

tuning [See performance tuning]

Tuning Advisor [See SQL Tuning Advisor]