(Kimberly Floss) With databases approaching the double-digit terabyte range increasingly common these days, Oracle DBAs can spend a fair amount of time shuttling vast amounts of data as part of their daily operations. If we’re not trying to keep a complete physical backup current for disaster re

(James F. Koopmann) Quest Software has a Knowledge Xpert called as set of over 1,000 PL/SQL functions, procedures and packages that are ready for you to view and implement into your system. This code base provides code modules that can help you in your day to day PL/SQL tasks, provide knowledgea

(Scott Stephens) Oracle’s Heterogeneous Services layer is a way for an Oracle database server to access data on external, non-Oracle databases transparently using Oracle. For example, you can configure Heterogeneous Services and SQL*Net to access a Microsoft Access database through ODBC or OLE DB.

(Alexander Bubernak) Wait event tuning has become very popular in recent years. Many DBAs are moving away from the cumbersome Ratio approach of tuning and using wait events. Ratio tuning has been proven unreliable in general and it can lead to a hit or miss way of troubleshooting and fixing problems

(Ravinder Bhalla) One of the most powerful features in Oracle 9i and above is the MERGE statement, which lets a single SQL statement either conditionally insert or update a table by selecting rows from another table. If the row already exists, an update is performed; otherwise, an insert is performe

(Steve Callan) Pro*C is another one of those tools or features from Oracle that keeps a low profile, quietly waiting its turn for you to use it when the need arises. With a little searching on various Oracle-related Web sites, you can read about how others have used Pro*C to greatly reduce processin

(Sean Dillon) The introduction of the Extensible Markup Language (XML) raised questions. How would we share XML if my documents looked different from yours? How could we make XML documents human-readable? How could we store these documents and expect to have any kind of performance when we queried t

(KK Mookhey) An organization’s database is the crown jewel of its IT infrastructure and a prime target for most attackers. Consequently, auditors must verify that all necessary security measures have been implemented on database systems to ensure the security of this prime information asset. Oracle

This document lists considerations when using XA in a RAC environment, the recommended solutions for both Oracle9i and Oracle Database 10g. (pdf)

(Clint Boulton) Oracle defended its title as the top database software maker in 2004, a year that saw the market grow 11.6 percent to $14.9 billion as businesses filled out unmet database management needs.