今天接触了一个Oracle10g Express Edition的数据库,这是第一次见识Express的生产版本。
其Banner信息如下:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
查看了一下Express版本的数据库选件,发现大部分都是False的:
SQL> select * from v$option order by value;
PARAMETER VALUE
-------------------------------------------------- --------------------
Partitioning FALSE
Export transportable tablespaces FALSE
Backup Encryption FALSE
Transparent Data Encryption FALSE
Data Mining Scoring Engine FALSE
Flashback Database FALSE
Flashback Table FALSE
Block Change Tracking FALSE
File Mapping FALSE
Streams Capture FALSE
Online Redefinition FALSE
PARAMETER VALUE
-------------------------------------------------- --------------------
Data Mining FALSE
Trial Recovery FALSE
Real Application Clusters FALSE
Advanced replication FALSE
Bit-mapped indexes FALSE
Parallel backup and recovery FALSE
Parallel execution FALSE
Point-in-time tablespace recovery FALSE
Fine-grained access control FALSE
Change Data Capture FALSE
Online Index Build FALSE
PARAMETER VALUE
-------------------------------------------------- --------------------
Coalesce Index FALSE
Managed Standby FALSE
Materialized view rewrite FALSE
Materialized view warehouse refresh FALSE
Database resource manager FALSE
Spatial FALSE
Visual Information Retrieval FALSE
Unused Block Compression FALSE
Fast-Start Fault Recovery FALSE
Duplexed backups FALSE
Java FALSE
PARAMETER VALUE
-------------------------------------------------- --------------------
Block Media Recovery FALSE
Fine-grained Auditing FALSE
Application Role FALSE
Enterprise User Security FALSE
Oracle Data Guard FALSE
Oracle Label Security FALSE
OLAP FALSE
Table compression FALSE
Join index FALSE
Parallel load TRUE
Plan Stability TRUE
PARAMETER VALUE
-------------------------------------------------- --------------------
Sample Scan TRUE
Instead-of triggers TRUE
Incremental backup and recovery TRUE
Objects TRUE
Connection pooling TRUE
Connection multiplexing TRUE
Proxy authentication/authorization TRUE
OLAP Window Functions TRUE
Transparent Application Failover TRUE
Database queuing TRUE
54 rows selected.
以上输出中,仅有12个为True的数据库功能选件。