2014年01月_数据我最大

01月

转载 How Oracle Locking Works - Second

How Oracle Locking WorksWhen a Lock is NOT a Lock!In the last installment of this series "100 Thing you Probably Didn't Know About Oracle" you learned how Oracle locks the rows of a table.

2014-01-16 18:41:16 880

转载 How Oracle Locking Works - First

When a transaction updates a row, it puts a lock so that no one can update the same row until it commits. When another transaction issues an update to the same row, it waits until the first one eith

2014-01-16 17:36:39 769

转载 100 Things You Probably Didn't Know About Oracle Database

100 Things You Probably Didn't Know About Oracle DatabaseRecently, while delivering a presentation on Cache Fusion at New York Oracle Users Group (www.nyoug.org), the regional user group where I h

2014-01-16 17:34:21 894

原创工作中常用语句

As always, I will highly appreciate if you could drop me a line telling me your feedback – good, bad and anything in between.

2014-01-16 17:28:26 651

转载 Understanding Row Identifiers(ROWID)

Each row in an Oracle database has a unique row identifier, or rowid.A ROWID is an 18-digit number that is represented as a base-64 number.ROWID is used internally by the Oracle database to access the

2014-01-16 17:26:15 612

转载索引

Suppose you want to locate a particular book in a library. Does it make sense to look through every book in the library until you find the one you want? Of course not; you use the library’s catalo

2014-01-05 22:18:13 627

原创对随机变量的理解

随机变量是其值随机会而定的变量，正如随机事件其发生与否随机会而定一样，一个随机试验有多种可能的结果，每一个结果出现都有一定的概率。随机变量是试验结果的函数，和普通函数不同的是，试验前，我们无法预知它将取何值，一旦试验之后，结果就确定了。对于一个随机试验，我们往往关心的是与所研究的特定问题有关的某个或某些量，而这些量就是随机变量。随机事件是从静态的观点来研究随机现象，而随机变量则是一种动态的

2014-01-03 20:18:55 2103

原创 Linux下SQL Developer 4.0 安装

一、Oracle SQL Developer 3.2.2 选择Linux RPM版本下载 http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html1、安装sqldeveloper， rpm -ivh sqldeveloper-3.2.20.09.87-1.noarch

2014-01-02 10:46:00 1668

原创 Telling INIT to go to single user mode. init: rc main process (4483) killed by TERM signal

Running the command 'shutdown now' in RHEL6 resulting the system to boot to single user modeTelling INIT to go to single user mode.init: rc main process (4483) killed by TERM signal.One m

2014-01-01 18:31:05 10585