eygle.com   eygle.com
eygle.com  
 

« July 26, 2006 | Blog首页 | July 28, 2006 »



July 27, 2006

见识了一次Oracle9i标准版

作者:eygle

出处:http://blog.eygle.com

说起来,学习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.

其实对于很多客户标准版也是足够的,只不过在国内很多商业应用都是未经授权的,所以企业版才被滥用吧。

 

Posted by eygle at 3:04 PM | Comments (2) | TrackBack


《深入浅出Oracle》的购买途径

作者:eygle

出处:http://blog.eygle.com

这几天,不断有朋友在MSN上闻询购买《深入浅出Oracle》一书的方法,而此前China-Pub的 短暂断货也给大家带来了不便,今天我将本书的购买方式总结一下:

1.ITPUB购买
大家可以登录 http://book.itpub.net  购买,但是由于时间差异,书可能尚未抵达广州,到达广州之后大家就可以从ITPUB购买了。   

2.通过网上书店购买
China-Pub图书购买链接:
http://www.china-pub.com/computers/common/info.asp?id=31128

这本书目前在销售排行上已经排在了第一位,昨天还排在 第二位。   

在Dearbook上的购买链接(此前Dearbook曾做过专题宣传):  

http://www.dearbook.com.cn/book/110471 

华储网的购买及宣传链接:
http://www.huachu.com.cn/2006/Oracle.html  

今天本书还出现在华储网的宣传首页,截图留念如下 

3.在北京的朋友可以到我这里取书
上班时间可以到,三元桥 佳程广场 这里拿书
下班时间或周末,可以到 北四环 亚运村小营(华堂商场对面)拿书 

来时请提前预约,电话:6493 7293 

HFO.in.HuaChu

购买本书的朋友,也可以阅读以下文章,接受本书服务:

http://www.eygle.com/archives/2006/07/head_first_oracle_script.html


Posted by eygle at 3:01 PM | Comments (3) | TrackBack



CopyRight © 2004-2008 eygle.com, All rights reserved.