Oracle辅导:OracleExpress版本的数据库选件
接触了一个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
Bitmapped indexes /FALSE
Parallel backup and recovery /FALSE
Parallel execution /FALSE
Pointintime tablespace recovery /FALSE
Finegrained 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
FastStart Fault Recovery /FALSE
Duplexed backups /FALSE
Oracle辅导:OracleExpress版本的数据库选件
Java /FALSEPARAMETER /VALUE
Block Media Recovery /FALSE
Finegrained 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
Insteadof 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的数据库功能选件。
页:
[1]