摘要:
阅读全文
posted @
2009-07-16 22:33 donnie 阅读(298) |
评论 (0) |
编辑 收藏
http://www.oracle.com/technology/global/cn/products/timesten/index.html
posted @
2009-06-22 16:34 donnie 阅读(207) |
评论 (0) |
编辑 收藏
http://r.book118.com/files/article/html/19/19931/index.htm
posted @
2009-06-12 12:55 donnie 阅读(185) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-06-12 12:06 donnie 阅读(321) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-06-12 11:46 donnie 阅读(195) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-06-12 11:45 donnie 阅读(179) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-12 22:31 donnie 阅读(230) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-12 17:21 donnie 阅读(206) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-12 17:13 donnie 阅读(4575) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-12 16:53 donnie 阅读(195) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-12 16:49 donnie 阅读(181) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-12 16:46 donnie 阅读(173) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-08 12:06 donnie 阅读(286) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-08 12:05 donnie 阅读(3778) |
评论 (2) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-06 22:45 donnie 阅读(608) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-05 23:06 donnie 阅读(900) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-05 22:55 donnie 阅读(225) |
评论 (1) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-05 22:31 donnie 阅读(144) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-05 22:27 donnie 阅读(102) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-05-05 22:23 donnie 阅读(145) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 17:48 donnie 阅读(2781) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 17:03 donnie 阅读(248) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 15:12 donnie 阅读(341) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 15:09 donnie 阅读(135) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 14:41 donnie 阅读(353) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 11:48 donnie 阅读(988) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-28 11:32 donnie 阅读(1009) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-24 21:43 donnie 阅读(235) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-24 21:43 donnie 阅读(438) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-24 11:39 donnie 阅读(282) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-24 10:54 donnie 阅读(252) |
评论 (0) |
编辑 收藏
巧用虚拟股权留住人心
天津B公司:虚拟股份制
虚拟股权激励方案设计
posted @
2009-04-23 11:25 donnie 阅读(138) |
评论 (0) |
编辑 收藏
http://www.hadoop.org/
The Apache Hadoop project develops open-source software for reliable, scalable, distributed computing, including:
- Hadoop Core, our flagship sub-project, provides a distributed filesystem (HDFS) and support for the MapReduce distributed computing metaphor.
- HBase builds on Hadoop Core to provide a scalable, distributed database.
- Pig is a high-level data-flow language and execution framework for parallel computation. It is built on top of Hadoop Core.
- ZooKeeper is a highly available and reliable coordination system. Distributed applications use ZooKeeper to store and mediate updates for critical shared state.
- Hive is a data warehouse infrastructure built on Hadoop Core that provides data summarization, adhoc querying and analysis of datasets.
posted @
2009-04-17 15:20 donnie 阅读(136) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-17 11:02 donnie 阅读(353) |
评论 (0) |
编辑 收藏
http://www.hadoop.org/
The Apache Hadoop project develops open-source software for reliable, scalable, distributed computing, including:
- Hadoop Core, our flagship sub-project, provides a distributed filesystem (HDFS) and support for the MapReduce distributed computing metaphor.
- HBase builds on Hadoop Core to provide a scalable, distributed database.
- Pig is a high-level data-flow language and execution framework for parallel computation. It is built on top of Hadoop Core.
- ZooKeeper is a highly available and reliable coordination system. Distributed applications use ZooKeeper to store and mediate updates for critical shared state.
- Hive is a data warehouse infrastructure built on Hadoop Core that provides data summarization, adhoc querying and analysis of datasets.
posted @
2009-04-17 10:32 donnie 阅读(131) |
评论 (0) |
编辑 收藏
http://rdc.taobao.com/blog/dw/archives/286
posted @
2009-04-17 10:27 donnie 阅读(168) |
评论 (0) |
编辑 收藏
http://www.hadoop.org/
http://cn.hadoop.org/
posted @
2009-04-17 10:26 donnie 阅读(149) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-13 21:15 donnie 阅读(130) |
评论 (0) |
编辑 收藏
A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'
from: http://tkyte.blogspot.com/
posted @
2009-04-06 17:03 donnie 阅读(111) |
评论 (0) |
编辑 收藏
select to_date('Mon Jan 21 13:25:47 2008', 'dy mon dd hh24:mi:ss yyyy') from dual
Ora-01846: not a valid day of the week
出现的是中文的字符日期,如下:星期五 12月 19 13:53:15 2008
是字符集的问题,解决:
alter session set nls_date_language = 'American'
posted @
2009-04-06 16:00 donnie 阅读(1128) |
评论 (0) |
编辑 收藏
摘要:
阅读全文
posted @
2009-04-06 11:50 donnie 阅读(152) |
评论 (0) |
编辑 收藏
http://v.youku.com/v_playlist/f2076316o1p28.html
posted @
2009-04-04 18:26 donnie 阅读(114) |
评论 (0) |
编辑 收藏
http://edu.136z.com/DataBase/32042.html
目录
一、 前言... 4
二、 思路... 4
三、 vmstat脚本及步骤... 4
1. 安装statspack. 4
2. 创建stats$vmstat表... 4
3. 创建vmstat目录... 6
4. 创建get_vmstat.ksh脚本... 6
5. 创建run_vmstat.ksh脚本... 8
6. 创建crontab作业,定时执行run_vmstat.ksh脚本... 9
7. 分析数据... 9
1) 异常报告... 9
2) 每小时趋势报告... 13
3) 周趋势报告... 14
4) 长期趋势报告... 14
四、 使用Excel生成趋势图... 15
五、 参考资料... 15
posted @
2009-04-02 10:46 donnie 阅读(129) |
评论 (0) |
编辑 收藏
改用传统的pfile方式启动,具体pfile的内容可从spfile文件中copy,或者从数据库的警告日志文件中获取。
posted @
2009-03-30 22:32 donnie 阅读(219) |
评论 (0) |
编辑 收藏
在oracle中,NULL与NULL既不相等,也不完全不相等。SQL Server与Sybase中,NULL等于NULL.
--REF: oracle expert....
scott@ORCL> select * from dual where null=null;
未选定行
scott@ORCL> select * from dual where null <> null;
未选定行
scott@ORCL> select * from dual where null is null;
D
-
X
posted @
2009-03-27 22:47 donnie 阅读(113) |
评论 (0) |
编辑 收藏
scott@ORCL> select count(*) from t;
COUNT(*)
----------
28
scott@ORCL> begin
2 for x in (select * from t)
3 loop
4 insert into t values (x.username,x.user_id,x.created);
5 end loop;
6 end;
7 /
PL/SQL 过程已成功完成。
scott@ORCL> select count(*) from t;
COUNT(*)
----------
56
posted @
2009-03-26 23:18 donnie 阅读(118) |
评论 (0) |
编辑 收藏
SET SERVEROUTPUT ON;
DECLARE
stock_price NUMBER := 9.73;
net_earnings NUMBER := 0;
pe_ratio NUMBER;
BEGIN
-- Calculation might cause division-by-zero error.
pe_ratio := stock_price / net_earnings;
dbms_output.put_line('Price/earnings ratio = ' || pe_ratio);
EXCEPTION -- exception handlers begin
-- Only one of the WHEN blocks is executed.
WHEN ZERO_DIVIDE THEN -- handles 'division by zero' error
dbms_output.put_line('Company must have had zero earnings.');
pe_ratio := null;
WHEN OTHERS THEN -- handles all other errors
dbms_output.put_line('Some other kind of error occurred.');
pe_ratio := null;
END; -- exception handlers and block end here
/
ref : http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/appdev.101/b10807/07_errs.htm
posted @
2009-03-25 10:52 donnie 阅读(95) |
评论 (0) |
编辑 收藏
scott@ORCL> connect / as sysdba
已连接。
sys@ORCL> grant execute on dbms_flashback to scott;
授权成功。
sys@ORCL> connect scott/tiger
已连接。
scott@ORCL> variable SCN number
scott@ORCL> exec :scn := sys.dbms_flashback.get_system_change_number
PL/SQL 过程已成功完成。
scott@ORCL> print scn
SCN
----------
762534
scott@ORCL> select count(*) from emp;
COUNT(*)
----------
14
scott@ORCL> delete from emp;
已删除14行。
scott@ORCL> select count(*) from emp;
COUNT(*)
----------
0
scott@ORCL> select count(*) from emp AS OF SCN :scn;
COUNT(*)
----------
14
scott@ORCL> commit;
提交完成。
scott@ORCL> select *
2 from (select count(*) from emp),
3 (select count(*) from emp as of scn :scn)
4 /
COUNT(*) COUNT(*)
---------- ----------
0 14
scott@ORCL> select *
2 from (select count(*) from emp),
3 (select count(*) from emp as of scn :scn)
4 /
COUNT(*) COUNT(*)
---------- ----------
0 14
scott@ORCL> alter table emp enable row movement;
表已更改。
scott@ORCL> flashback table emp to scn :scn;
闪回完成。
scott@ORCL> select *
2 from (select count(*) from emp),
3 (select count(*) from emp as of scn :scn)
4 /
COUNT(*) COUNT(*)
---------- ----------
14 14
scott@ORCL>
posted @
2009-03-24 22:58 donnie 阅读(302) |
评论 (1) |
编辑 收藏
scott@ORCL> drop table t;
表已删除。
scott@ORCL>
scott@ORCL> create table t
2 as
3 select *
4 from all_users;
表已创建。
scott@ORCL>
scott@ORCL> variable x refcursor
scott@ORCL>
scott@ORCL> begin
2 open :x for select * from t;
3 end;
4 /
PL/SQL 过程已成功完成。
scott@ORCL> delete from t;
已删除28行。
scott@ORCL>
scott@ORCL> commit;
提交完成。
scott@ORCL>
scott@ORCL> print x
USERNAME USER_ID CREATED
------------------------------ ---------- --------------
BI 60 13-3月 -09
PM 59 13-3月 -09
SH 58 13-3月 -09
IX 57 13-3月 -09
OE 56 13-3月 -09
HR 55 13-3月 -09
SCOTT 54 30-8月 -05
MGMT_VIEW 53 30-8月 -05
MDDATA 50 30-8月 -05
SYSMAN 51 30-8月 -05
MDSYS 46 30-8月 -05
SI_INFORMTN_SCHEMA 45 30-8月 -05
ORDPLUGINS 44 30-8月 -05
ORDSYS 43 30-8月 -05
此处 open 不复制任何数据,只是在你获取数据时它才从表中读数据。
posted @
2009-03-24 22:46 donnie 阅读(121) |
评论 (0) |
编辑 收藏