Oracle Price Lists
Oracle官方网站发布了其软件与服务的参考报价:http://www.oracle.com/corporate/pricing/pricelists.html
就一个字:贵。企业版数据库每CPU高达40,000$,RAC组件也达到20,000$/CPU,这样要是组建一套双节点,每节点4CPU的RAC系统,则高达480,000$,好几千万几百万RMB啊,比强盗这个有前途的职业有钱途多了^_^
使用CSSCAN执行字符集转换健康检查
CSSCAN(Character Set Scanner utility)是Oracle提供的一个用于检查字符集转换过程中可能会出现的数据丢失或者损坏的情况。也可以单独的扫描某些表某些列能否进行字符集转换,并且能够并行扫描以加快扫描速度。
1.创建相关数据字典
SYS@NING>@$Oracle_home\rdbms\admin\csminst.sql
SYS@NING>spool off
该脚本会创建一个叫csmig的用户。
Oracle 2007财年第四季度同比增长27%
Oracle今天公布了其2007财年第四季度(2007年5月31日结束)的报表,显示了强劲的增长,GAAP每股收益达0.31美元,同比增长27%。值得关注的是,其中新的许可证销售增长达到了17%(数据库和中间件增长18%,应用软件增长13%)。看来Oracle10G的推广算是大获成功。随着Oracle11g发布在即,Oracle能否继续获得高速增长,11g的普及速度和程度应该是至关重要。让我们一起期待Oracle11g的面市^_^
下面是oracle的官方新闻:
Oracle Corporation (NASDAQ: ORCL) today announced that fiscal 2007 Q4 GAAP earnings per share were up 27% to $0.31, compared to the same quarter last year. Fourth quarter GAAP revenues were up 20% to $5.8 billion, while quarterly GAAP net income was up 23% to $1.6 billion. Total GAAP software revenues were up 19% to $4.8 billion. GAAP new license revenues were up 17% with GAAP database and middleware new license revenues up 18% and GAAP applications new license revenues up 13%. GAAP services revenues were up 26% to $1.1 billion compared to the same quarter last year.
BI方面,前两天Oracle发布了Oracle Business Intelligence Standard Edition One,该套件包含了 dashboards, reporting, ad hoc query,analysis, 以及ETL等功能,旨为中小企业提供BI解决方案。Oracle声明该套件主要针对Windows平台并且license低至每用户1000刀,矛头直指微软势头正旺的SQL Server 2005 BI。
Oracle Business Intelligence SE One is generally available for the Microsoft Windows platform and is priced at $1,000 per named user (minimum of five users, maximum of 50 users). Terms, conditions, and restrictions apply. Migration to the Oracle Business Intelligence Suite EE for growth beyond 50 users is also available.
解决Oracle Analytic Workspace Manager错误一例
在Oracle网站上下载了Analytic Workspace Manager 10.2.0.3.0A,准备测试一下Oracle OLAP选件。但是打开AWM并且连接到本机的版本为10.2.0.3的Oracle数据库,只是每次点击具体的Schema,都会造成AWM异常退出,并且在bin目录下生成一个错误日志文件: