« 《深入浅出Oracle》的购买途径 |
Blog首页
| Windows Xp重新安装备忘 »
见识了一次Oracle9i标准版
说起来,学习Oracle这么多年,还从来没有安装过Oracle的标准版(Oracle Standard Edition),前几天,帮一个朋友诊断数据库问题,发现居然是一个标准版,活生生的标准版啊!
这是我第一次看到标准版的Oracle数据库,记录一下:
[oracle@st ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.0.1.0.0 - Production on Mon Jul 24 10:40:25 2006
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.0.1.0.0 - Production JServer Release 9.0.1.0.0 - Production
SQL> select * from v$version;
BANNER ---------------------------------------------------------------- Oracle9i Release 9.0.1.0.0 - Production PL/SQL Release 9.0.1.0.0 - Production CORE 9.0.1.0.0 Production TNS for Linux: Version 9.0.1.0.0 - Production NLSRTL Version 9.0.1.0.0 - Production
|
看一下Oracle的标准版支持的选件,为True的还真不多:
SQL> set linesize 120 SQL> col value for a5 SQL> select * from v$option where value='TRUE';
PARAMETER VALUE ---------------------------------------------------------------- ----- Objects TRUE Connection multiplexing TRUE Connection pooling TRUE Proxy authentication/authorization TRUE OLAP Window Functions TRUE Parallel load TRUE Instead-of triggers TRUE Database queuing TRUE
8 rows selected.
|
高级复制都是不支持的。以下是全部选件列表:
SQL> select * from v$option order by value;
PARAMETER VALUE ---------------------------------------------------------------- ----- Partitioning FALSE Real Application Clusters FALSE Advanced replication FALSE Parallel backup and recovery FALSE Incremental backup and recovery FALSE Bit-mapped indexes FALSE Parallel execution FALSE Point-in-time tablespace recovery FALSE Fine-grained access control FALSE Spatial FALSE Database resource manager FALSE
PARAMETER VALUE ---------------------------------------------------------------- ----- Materialized view warehouse refresh FALSE Materialized view rewrite FALSE Managed Standby FALSE Coalesce Index FALSE Online Index Build FALSE Plan Stability FALSE Function-based indexes FALSE Enterprise User Security FALSE Application Role FALSE Fine-grained Auditing FALSE Block Media Recovery FALSE
PARAMETER VALUE ---------------------------------------------------------------- ----- Java FALSE Duplexed backups FALSE Sample Scan FALSE Fast-Start Fault Recovery FALSE Transparent Application Failover FALSE Export transportable tablespaces FALSE Visual Information Retrieval FALSE Objects TRUE Connection multiplexing TRUE Connection pooling TRUE Proxy authentication/authorization TRUE
PARAMETER VALUE ---------------------------------------------------------------- ----- OLAP Window Functions TRUE Parallel load TRUE Instead-of triggers TRUE Database queuing TRUE
37 rows selected.
|
其实对于很多客户标准版也是足够的,只不过在国内很多商业应用都是未经授权的,所以企业版才被滥用吧。
历史上的今天...
>>
2020-07-27文章:
>>
2018-07-27文章:
>>
2015-07-27文章:
>>
2009-07-27文章:
>>
2005-07-27文章:
>>
2004-07-27文章:
By eygle on 2006-07-27 15:04 |
Comments (2) |
FAQ | 842 |
Oracle9i
虽然你的网站里很多东东我还看不懂,都是你一个人做的吗?如果是的话你就太厉害了!佩服。
谢谢,这个网站是我一个人做的:)