Oracle 10g中, 查询数据字典中 v$option 确定数据库的选件产品是否安装;
SQL> col value format a10;
SQL> select * from v$option;
PARAMETER VALUE
--------------------------------------------- ----------
Partitioning TRUE
Objects TRUE
Real Application Clusters FALSE
Advanced replication TRUE
Bit-mapped indexes TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
PARAMETER VALUE
--------------------------------------------- ----------
Parallel e