Blog Detail

[Oracle Database] e-DBA

http://e-dba.blogspot.com/

Teaching Oracle Database Administration Skill, Learning Oracle DBA Skill For Free, Free Tutorial

Added on: Jan 31st, 2009
Country: Singapore
Language: English

Author: edba
Listed in: Computers eLearning
Tags: sql oracle database dba oracle database oracle dba

Recent Posts

How To Integrate SQLPLUS Command Within Shell Scripts

Posted on Friday December 18th, 2009 at 00:55 in scripts, sqlplus

If you want to keep one scripts that consists of SQLPlus connection following is the method to do it.sqlplus -s '/as sysdba' <<>SELECT SYSDATE FROM DUAL;SELECT banner FROM v\$version;SELECT COUNT(*) FROM v\$session WHERE username like 'SYS%'...
Oracle Ditch Hewlett-Packard for Sun

Posted on Tuesday September 15th, 2009 at 21:56

Oracle Corp has ended a high-profile computer-building partnership with Hewlett-Packard Co as Oracle prepares to acquire Sun Microsystems Inc, a rival of HP.Sun, the world's No. 4 server maker, and Oracle have jointly developed a second-generation ve...
Tunneling

Posted on Monday June 1st, 2009 at 22:39

Following is the command to perform tunnelingC:\Program Files\PuTTY\plink -ssh -l oracle -L 10000:172.20.10.110:1521 172.20.10.111plink -ssh -l -L ::...
Oracle Buys Sun

Posted on Monday April 20th, 2009 at 08:42

Last week my article about Oracle building Data Machine. I have gut feeling that Oracle will takeover Sun. That is because Oracle have been trying very hard to build their own OS by offering Oracle Enterprise Linux. Work together with HP, but now loo...
Netezza Claimed 100x Faster Than Oracle Exadata

Posted on Thursday April 16th, 2009 at 11:50 in netezza, oracle exadata

According to Oracle website:The HP Oracle Database Machine is a complete system, including software, servers, networking and storage designed to run multi-terabyte data warehouses at least 10x faster than conventional data warehouse systems. At the h...
Undo Data Introduction

Posted on Wednesday April 1st, 2009 at 04:19 in undo data

What is Undo DataWhen a transaction modifies data, Oracle Database copies the original data before modifying it. The original copy of the modified data is called undo data. Saving this information is necessary for the following reasons:- To undo any ...