Gartner 2006 Worldwide RDBMS Market Share Reports 47.1% Share for Oracle

Worldwide RDBMS total software revenue totaled $15.2 billion in 2006, a 14.2 percent increase from 2005 revenue of $13.3 billion, according to Gartner, Inc

The overall RDBMS market continued to be dominated by the top-tier vendors Oracle, IBM, and Microsoft which accounted for 85.6 percent of worldwide RDBMS revenue. Out of which Oracle alone contributes 47.1 percent.

To learn more, read the press release from Gartner.

Oracle 11g

On July 11, 2007, in a live launch event from New York City, Oracle unveiled Oracle Database 11g—the next generation of enterprise information management that will help you innovate faster through better business insight.

For more information please visit http://www.oracle.com/technology/products/database/oracle11g/index.html

Oracle 10g Scheduler Overview

Automation is key process to reduce IT operating expense. An effective scheduler should have features that can automate business process with manual intervention and be easily mange/monitor the scheduled jobs. Scheduler was introduced in Oracle 10g and has exciting features. Few are listed below.

• Build into database. No extra license fee.
  
• DBA has Control over when and what to execute.
• Platform independent (Management is similar across platform).
• Can be exported using IMP/EXP utility.
• Can execute Shell scripts, PL/SQL block, PL/SQL or Java stored procedures.
• It can be accessed/controlled from enterprise manager (EM) or through DBMS_SCHEDULER API.
• Can schedule the job based on time and also on event.
  

For more information please visit
http://www.oracle.com/technology/products/database/scheduler/index.html

SELECT … FOR UPDATE Enhancement

Selecting a record for update that is already locked causes the current session to hang indefinitely until the lock is released. If this situation is unacceptable the NOWAIT keyword can be used to instantly return an error if the record is locked. Oracle 9i, feature allows us to specify maximum time before it shoots error message. This also reduces the change of indefinite locking.

Example:
Select * from emp where eno=1235 for update wait 15;