dblink sdo_geometry_geometry wiki_dblink sybase(3)

Online index rebuilds - The ability to rebuild anOracle index while it is being updated.

Export transportable tablespaces - This provides theability to transfer encapsulated tablespaces betweendatabases.

Materialized Views - This is a powerful tool toallow for the pre-summarization of aggregate data(averages, counts, sums) and pre-join tables together.Materialized views are especially useful in low-updatedatabases and data warehouses.This is available in Oracle SEO as of release 10.1.

Bitmap indexes - Bitmaps are a unique indexingstructure for fast combinations of low-cardinality datacolumns. Bitmap indexes are especially powerful for datawarehouses and low-update databases. Bitmap indexcan only be used with Oracle Enterprise Edition (EE),not Standard Edition. Hence, STAR transformationqueries are impossible on Oracle SE and SEO.

Oracle Parallel Query (OPQ) - Parallel query is adivide-and conquer approach whereby SymmetricMultiprocessing (SMP) and Massively Parallel Processors(MPP) can get super-fast response time for large-tablefull-table scans

Parallel DML - This is the ability to performdatabase changes (inserts, updates, deletes) inparallel.

Parallel index rebuilding - This allows large Oracleindexes to be rebuilt in a fraction of the time requiredby a single CPU system.

Parallel index scans - This feature allows forparallel fast full-index scans and multi-block reads ofindex data blocks.

Parallel backup & recovery - This allows Oracle RMANbackups to be parallelized for super-fast backups oflarge databases.

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/jisuanjixue/article-48346-3.html