This study compares the effort of managing Oracle Database 10g Release 2 to the effort of accomplishing equivalent tasks in Microsoft SQL Server 2005. Edison Group has previously published a series of manageability studies comparing the major RDBMS products in terms of their aility to manage and adm

(Carolyn A. April) As it is with the other enterprise-software players, the SMB market is in Oracle’s sights. And like its rivals, Oracle is turning to the channel to increase the sales footprint needed to reach this segment of the market. The Redwood Shores, Calif., company recently began allowing

A foreign key means that values in one table must also appear in another table.

(Mark Brunelli) One of the biggest Oracle user conferences of the year — Collaborate ’06 — kicks off later this month in Nashville. The conference, which this year represents the combined efforts of the Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and the Quest

(James F. Koopmann) Detection of which tables or indexes are being accessed the most will allow you to fine tune memory structures and access methodologies. Let’s take a look at Oracle’s segment level statistics and determine which objects are being accessed the most by our applications.

(Vincent Chan) Data availability is an important factor to the success of any businesses. In a distributed environment, Oracle Streams improves data availability and accessibility by sharing and replicating information to multiple sites quickly and reliably. Oracle Streams was introduced in Oracle 9

A complete high availability and disaster recovery strategy requires dependable data backup, restore, and recovery procedures. Oracle Recovery Manager (RMAN), a command-line and Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and recovering your Oracle databa

Oracle VP Ted Farrell recently spoke to SYS-CON in an exclusive recorded interview about the company’s emerging AJAX strategy.

(Steve Callan) One feature often times overlooked by developers is PL/SQL’s ability to allow overloading. As in other programming languages, overloading occurs when a program uses the same name for a function or procedure, and the way the program differentiates which version being called is based on

(Jagadish Chatarji) In this series of articles, we shall concentrate on working with file input/output using Oracle PL/SQL packages. Even though I start with simple examples in the first article of this series, I shall introduce you (in my upcoming articles) to the power of the most advanced techniq