« 《深入浅出Oracle》的购买途径 |
Blog首页
| Windows Xp重新安装备忘 »
见识了一次Oracle9i标准版
作者：
eygle |【转载时请务必以超链接形式标明文章
原始出处和作者信息及
本声明】
链接：
http://www.eygle.com/archives/2006/07/oracle9i_standard_edition.html
说起来，学习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.
|
其实对于很多客户标准版也是足够的，只不过在国内很多商业应用都是未经授权的，所以企业版才被滥用吧。
By eygle on 2006-07-27 15:04 |
Comments (2) |
Posted to
FAQ | Edit |Pageviews:
网上相关主题:
虽然你的网站里很多东东我还看不懂，都是你一个人做的吗？如果是的话你就太厉害了！佩服。
Posted by: 阿飞 at January 18, 2007 9:39 PM
Posted by: eygle at January 19, 2007 8:56 AM
发表留言:
