怎么查看Oracle安装包版本,如何查看Oracle版本及安装了哪些选项

如何查看Oracle版本及安装了哪些选项？ 系统环境： 1、操作系统：Windows 2000 2、数据库：　Oracle 8i R2 (8.1.6) for NT 企业版 3、安装路径：C:/ORACLE 说明： 1、查看数据库版本 SQL> select banner from sys.v_$version; BANNER ---------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production CORE 8.1.6.0.0 Production TNS for 32-bit Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production 2、查看安装了哪些选项 SQL> col PARAMETER format a60 SQL> col VALUE format a10 SQL> select * from sys.v_$option; PARAMETER VALUE ------------------------------------------------------------ ---------- Partitioning TRUE Objects TRUE Parallel Server 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 execution TRUE Parallel load TRUE Point-in-time tablespace recovery TRUE Fine-grained access control TRUE N-Tier authentication/authorization TRUE Function-based indexes TRUE Plan Stability TRUE Online Index Build TRUE Coalesce Index TRUE Managed Standby TRUE Materialized view rewrite TRUE PARAMETER VALUE ------------------------------------------------------------ ---------- Materialized view warehouse refresh TRUE Database resource manager TRUE Spatial TRUE Visual Information Retrieval TRUE Export transportable tablespaces TRUE Transparent Application Failover TRUE Fast-Start Fault Recovery TRUE Sample Scan TRUE Duplexed backups TRUE Java FALSE OLAP Window Functions TRUE 已选择33行。 SQL> set head off feed off pages 0 serveroutput on SQL> begin 2 dbms_output.put_line('Port String: '||dbms_utility.port_string); 3 end; 4 / Port String: IBMPC/WIN_NT-8.1.0