摘要:
閱讀全文
http://www.oracle.com/technology/global/cn/products/timesten/index.html
http://r.book118.com/files/article/html/19/19931/index.htm
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
posted @
2009-05-12 17:13 donnie 閱讀(4650) |
評(píng)論 (0) |
編輯 收藏
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
posted @
2009-05-08 12:05 donnie 閱讀(3815) |
評(píng)論 (2) |
編輯 收藏
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
posted @
2009-04-28 17:48 donnie 閱讀(2795) |
評(píng)論 (0) |
編輯 收藏
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
posted @
2009-04-28 11:48 donnie 閱讀(1011) |
評(píng)論 (0) |
編輯 收藏
摘要:
閱讀全文
posted @
2009-04-28 11:32 donnie 閱讀(1034) |
評(píng)論 (0) |
編輯 收藏
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
摘要:
閱讀全文
巧用虛擬股權(quán)留住人心
天津B公司:虛擬股份制
虛擬股權(quán)激勵(lì)方案設(shè)計(jì)
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.
摘要:
閱讀全文
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.
http://rdc.taobao.com/blog/dw/archives/286
http://www.hadoop.org/
http://cn.hadoop.org/
摘要:
閱讀全文
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/
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
出現(xiàn)的是中文的字符日期,如下:星期五 12月 19 13:53:15 2008
是字符集的問題,解決:
alter session set nls_date_language = 'American'
posted @
2009-04-06 16:00 donnie 閱讀(1144) |
評(píng)論 (0) |
編輯 收藏
摘要:
閱讀全文
http://v.youku.com/v_playlist/f2076316o1p28.html
http://edu.136z.com/DataBase/32042.html
目錄
一、 前言... 4
二、 思路... 4
三、 vmstat腳本及步驟... 4
1. 安裝statspack. 4
2. 創(chuàng)建stats$vmstat表... 4
3. 創(chuàng)建vmstat目錄... 6
4. 創(chuàng)建get_vmstat.ksh腳本... 6
5. 創(chuàng)建run_vmstat.ksh腳本... 8
6. 創(chuàng)建crontab作業(yè),定時(shí)執(zhí)行run_vmstat.ksh腳本... 9
7. 分析數(shù)據(jù)... 9
1) 異常報(bào)告... 9
2) 每小時(shí)趨勢報(bào)告... 13
3) 周趨勢報(bào)告... 14
4) 長期趨勢報(bào)告... 14
四、 使用Excel生成趨勢圖... 15
五、 參考資料... 15
改用傳統(tǒng)的pfile方式啟動(dòng),具體pfile的內(nèi)容可從spfile文件中copy,或者從數(shù)據(jù)庫的警告日志文件中獲取。
在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

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
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
scott@ORCL> connect / as sysdba
已連接。
sys@ORCL> grant execute on dbms_flashback to scott;

授權(quán)成功。

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>
scott@ORCL> drop table t;

表已刪除。

scott@ORCL>
scott@ORCL> create table t
2 as
3 select *
4 from all_users;

表已創(chuàng)建。

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 不復(fù)制任何數(shù)據(jù),只是在你獲取數(shù)據(jù)時(shí)它才從表中讀數(shù)據(jù)。
http://blogs.sun.com/chrisoliver/entry/javafx_vs_actionscript_performance
demo: https://openjfx.dev.java.net/
sudo passwd root;
This solution worked perfectly for me:
http://www.insecure.ws/2008/10/20/vm...nd-kernel-2627
add this patch:
vmware-update-2.6.27-5.5.7-2
$sudo apt-get install scim scim-modules-socket scim-modules-table scim-pinyin scim-tables-zh scim-gtk2-immodule scim-qtimm
$sudo im-switch -s scim
重新啟動(dòng)Xwindow完成。按 Ctrl + 空格 鍵激活輸入法。
sudo apt-get install linux-restricted-modules-2.6.27-11-server
sudo apt-get install linux-headers-server
sudo apt-get install linux-image-server linux-server
--it works.
sudo apt-get install pidgin
——————————————————————
pidgin是一個(gè)多協(xié)議的聊天工具,只要你有對(duì)應(yīng)的帳戶,就可以同時(shí)和幾個(gè)帳戶下的好友同時(shí)聊。
按提示添加帳戶就行了。
系統(tǒng)-系統(tǒng)管理-軟件源,choose chinese site to get higher speed.
http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_xp
posted @
2009-03-17 16:40 donnie 閱讀(7816) |
評(píng)論 (1) |
編輯 收藏