(Steven Feuerstein) In my second article on PL/SQL enhancements in Oracle Database 10g, I will explore the new capability of using the FORALL statement with nonconsecutive driving indexes. While this might at first sound fairly esoteric, it is actually a key enhancement to the FORALL statement that

Oracle Web Services are facilities have been greatly enhanced for the Oracle9iAS delivery. They are based on the W3C SOAP Note as enhanced by the W3C SOAP with Attachments note. SOAP (Simple Object Access Protocol) was defined to address a number of objectives. In brief, these objectives were to

(Shahid Hafeez) This script will generate INDEX CREATION script for all table foreign keys when they are part of primary keys. This is usefull when you need to generate index for reference columns especially for DW applications. (script)

(Jim Czuprynski) Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server’s CPU resources effectively for application user groups and during different resource demand periods. This article provides a brief overview of how DRM works and then delve

(Wim Coekaerts) Version 1 was released about a year ago and is still the current major release number. The main goal of OCFS was to provide a replacement for raw devices. It was not designed as a general-purpose cluster filesystem, nor was it designed to store nondatabase files. By database files, I

(Jared Still) Data encryption is a hot topic these days. This is hardly a new subject, but has received and increasing amount of attention, largely due to ecommerce. Protecting credit card numbers, medical data and other sensitive information has become more important than ever before, and on a lar

(Chris Lawson) Database Administrators, or DBAs, perform a wide variety of tasks – some exciting, and others more routine. At most companies, the DBA doesn’t have the option to pick and choose which tasks to perform. Typically, all the DBAs have to “pitch-in” and work on a wide variety of tasks, so

(James Holmes) One major benefit of the Struts framework is its built-in interface for performing data validations on incoming form data. If any validations fail, the application redisplays the HTML form so that the invalid data can be corrected. Otherwise, processing continues. The Struts framework

(Brian Keating) When an oracle instance starts up, it allocates a set amount of shared memory, to be used for its SGA. This area of shared memory is known as the "shared memory segment" of the instance. (In rare cases, an instance may actually have to create multiple shared memory segments, if the i

(Jim Czuprynski) During a recent code review of our production databases’ stored procedures and packages, I took the time to convert the objects from the deprecated (but still serviceable) USERENV function to its Oracle 9i replacement, SYS_CONTEXT. The conversion was relatively painless, of course,