How to view the Oracle version and what options are installed __oracle

How to view the Oracle version and what options are installed.


System environment:
1, operating system: Windows 2000
2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, Installation path: c:/oracle

Description

1. View database version
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, see what options are installed
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 rows have been selected.



Sql> set head off feed out 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