(Amar Kumar Padhi) Databases are often taxed by applying SQL statements to enormous tables. One such activity is when we add a new NOT NULL column with default value in a huge transaction table. By ‘huge’ I mean the number of records. I will discuss the addition of a new column with default valu

(Jonathan Lewis) What is the most important component of the Oracle Database engine? My vote goes to the optimizer. Everything the database does is SQL, and every piece of SQL has to be translated into something that can work efficiently. Whatever you do with your data, the optimizer gets involved.

(Steve Callan) Did you know that Oracle’s “Scott” schema is slated for the bone yard? How many thousands of people have learned SQL, SQL*Plus, and PL/SQL on the back of poor old Scott? I would venture to say that the current generation of Oracle DBAs and developers are all familiar with the Scott sc

The latest release of Oracle Database 10 g contains new and improved functionality that directly benefits Business Intelligence & Data Warehousing applications. Here’s our top ten list of new features.

When you process an index-by table in PL/SQL, there are times when you cannot be sure of the indices that exist on the table, so you can’t use the most obvious form of the FOR loop to loop through values.

(Miladin Modrakovic) This document describes Oracle utility called oradebug. This tool is primarily used by Oracle worldwide customer support. With oradebug utility you can literally see the database engine. The oradebug is especially useful when things go very bad – e.g. the database just stops,

Get started, by registering today for the Oracle Database 10g New Features for Administrators beta exam and get recognized for your competency with the newest advancements in Oracle Database technology. By earning this credential, professionals demonstrate proficiency in the new features of Oracle D

Oracle has posted patches for its E-Business Suite and Applications 11.0 software to fix multiple, critical SQL vulnerabilities.

(Vishnu Bhavaraju) In Oracle8i, DBAs want to know how fast the tablespaces in their databases are growing so that they can plan for additional disk space. At the time of database/tablespace creation, DBAs use their best estimates to allocate optimal size to the tablespaces, but often need to resize

(Elizabeth Montalbano and Barbara Darrow) Oracle plans to meld Business Activity Monitoring functionality into a new release of its J2EE-based application server this summer. BAM drills down into systems to troubleshoot problems in business workflows and builds on the Business Process Execution