摘要:   閱讀全文 http://www.oracle.com/technology/global/cn/products/timesten/index.html http://r.book118.com/files/article/html/19/19931/index.htm      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文      摘要:   閱讀全文 巧用虛擬股權(quán)留住人心
天津Ｂ公司：虛擬股份制 
虛擬股權(quán)激勵方案設(shè)計

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'
     摘要:   閱讀全文 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è)，定時執(zhí)行run_vmstat.ksh腳本... 9

7.       分析數(shù)據(jù)... 9

1)    異常報告... 9

2)    每小時趨勢報告... 13

3)    周趨勢報告... 14

4)    長期趨勢報告... 14

四、       使用Excel生成趨勢圖... 15

五、       參考資料... 15
 改用傳統(tǒng)的pfile方式啟動，具體pfile的內(nèi)容可從spfile文件中copy，或者從數(shù)據(jù)庫的警告日志文件中獲取。

在oracle中，NULL與NULL既不相等，也不完全不相等。SQL Server與Sybase中，NULL等于NULL.
--REF: oracle expert....

 

ref : http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/appdev.101/b10807/07_errs.htm 此處 open 不復(fù)制任何數(shù)據(jù)，只是在你獲取數(shù)據(jù)時它才從表中讀數(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
重新啟動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是一個多協(xié)議的聊天工具，只要你有對應(yīng)的帳戶，就可以同時和幾個帳戶下的好友同時聊。
 按提示添加帳戶就行了。
系統(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 需以sysdba身份連接才能安裝。
1，cd [oracle_home]\rdbms\admin;
2,run  @spcreate.sql;
按提示輸入必要的信息。
如果輸入錯誤或者取消了安裝，下次安裝前需要先執(zhí)行 spdrop.sql刪除用戶和已安裝的視圖。
－－SPCPKG complete. Please check spcpkg.lis for any errors. 1，cd  [oracle_home]\rdbms\admin;
2, run  @utlxplan;
3, create public synonym plan_table to public; --no need to run in oracle10,oracle default
4, grant all on plan_table to public;--no need to run in oracle10,oracle default, here public can be any user;
----create role plustrace and grant it to user
1, cd [oracle_home]\sqlplus\admin;
2, conn sqlplus as sysdba;
3, run @plustrce;
4, grant plustrace to public;
---test
 1, conn sqlplus with user scott;
1.1, set autotrace on; 
 2, run : select * from dual;
 3, show stat info;
--1.1 可選項： set autotrace off: 不生成報告，默認(rèn)；
                           set autotrace on explain: 報告只顯示優(yōu)化器執(zhí)行路徑；
                           set autotrace on statistics: 報告只顯示sql語句執(zhí)行統(tǒng)計信息；
                           set autotrace on: 報告顯示優(yōu)化器執(zhí)行路徑，sql語句統(tǒng)計信息；
                            set autotrace traceonly: 報告顯示優(yōu)化器執(zhí)行路徑，sql語句統(tǒng)計信息，不顯示查詢輸出；

                          
ref：oracle 9i、10g編程藝術(shù)。

                         


ref：oracle 9i、10g編程藝術(shù)。
   sqlplus允許建立一個login.sql，通過設(shè)置環(huán)境變量SQLPATH，指向文件所在目錄，每次啟動sqlplus都會執(zhí)行這個腳本。
login.sql例子：

 

define _editor: sqlplus默認(rèn)的編輯器；
set serveroutput on size 1000000：默認(rèn)打開DBMS_OUTPUT,將緩沖區(qū)設(shè)置盡可能大；
現(xiàn)象：
sys@ORCL> grant select on v$session to scott;
grant select on v$session to scott
                *
第 1 行出現(xiàn)錯誤:
ORA-02030: 只能從固定的表/視圖查詢

解決：
 grant select on v_$session to  scott;
  HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\FlashPlayer\SafeVersions]
將"9.0"，“10.0” 項刪除，重新安裝。