Basically, LOBs (Large Objects) are designed to support large unstructured data such as text, graphic images, still video clips, full motion video, and sound waveforms. A typical employee record may be a few hundred bytes, but even small amounts of multimedia data can be thousands of times larger. O

(Kevin Conlon) Use of parallel operations with Oracle Database is well known, with the feature first having arrived in version 7.1. The ability to execute SQL statements in parallel on traditional UNIX-based symmetric multiprocessor (SMP) architectures greatly increased utilization of the server

(James Koopmann) Within Oracle 10g we are given the opportunity to move operating system files without ever ‘physically’ logging into the operating system itself. This in itself provides us, as DBAs, many options when doing common database administrative tasks that we will typically do. These tasks

(James Koopmann) Within Oracle 10g we are given the opportunity to move operating system files without ever ‘physically’ logging into the operating system itself. This in itself provides us, as DBAs, many options when doing common database administrative tasks that we will typically do. These ta

(Susan Foster) Oracle applications have specific terminology. A sample of terms a user must comprehend before navigating or setting up Oracle E-Business Suite 11i will be discussed below. (R)

(Shankar Govindan) Cloning is a process that most DBA’s are aware of that needs to be done often to keep the production database from being vandalized by then developers and UAT’s. A production database needs to be cloned to test or development or training databases, so that the Application developm

(Sushil Kumar) Oracle’s director of product management for database manageability explains the strategic importance of the self-managing capabilities of Oracle Database 10g.

(Arup Nanda) Virtual Private Database (VPD), also known as Fine Grained Access Control, provides powerful row-level security capabilities. Introduced in Oracle8i, it has become widely popular and can be found in a variety of applications ranging from education software to financial services.

(Kim Floss) In my last column, I focused on one of Oracle Database 10g’s quick wins for DBAs—using the new SQL Tuning Advisor to quickly tune poorly performing SQL statements—and touched only briefly on the new built-in diagnostic engine, Automatic Database Diagnostic Monitor (ADDM), which helps you

Most folks agree that Oracle Corp. is a force to be reckoned with in the business intelligence (BI) space. After all, Oracle provides a stable of BI tools, and, thanks to its vaunted Oracle 9i database, also has a very strong data warehousing story.