Jim Czuprynski

Combining Schedules and Creating Event-Driven Jobs Synopsis. Oracle 10g Release 1 (10gR1) added a new and powerful scheduling tool – aptly named the Scheduler – that significantly augments an Oracle DBA’s abilities to schedule and control just about any type of frequently repeating task from within an Oracle 10g database. This article – the first […]

Synopsis. Oracle 10g’s Automatic Storage Management (ASM) features offer powerful tools to Oracle DBAs to create and manage a robust, flexible, scalable file storage system ready for access by any existing Oracle database instance. This article – the third and final in this series – navigates the myriad ASM file naming conventions and templates, provides […]

Synopsis. Oracle 10g’s Automatic Storage Management (ASM) features offer powerful tools to Oracle DBAs to create and manage a robust, flexible, scalable file storage system ready for access by any existing Oracle database instance. This article — the second in this series — provides a simple yet practical demonstration of setting up an ASM instance […]

Synopsis. Oracle 10g’s new Automatic Storage Management (ASM) features allow an Oracle DBA to take advantage of a robust, flexible, scalable file storage system that any Oracle database instance can access. This article – the first in this series — provides a high-level overview of the ASM architecture, and should be helpful to any DBA […]

Synopsis. Oracle 10g’s daunting array of new features like extended FLASHBACK technology, Automated Storage Management, and Grid Computing sometimes overshadow the more mundane — yet no less impressive! – improvements to its logical storage capabilities. This article illustrates several enhancements to Oracle’s already robust logical storage structures, including the SYSAUX tablespace, BIGFILE tablespaces, tablespace groups, […]

Synopsis. Oracle 10g has extended the already robust features of Structured Query Language (SQL) with a plethora of intriguing new capabilities. This article – the final in this series – reviews the new features that Oracle 10g provides for advanced data modeling and inter-row calculations via the new MODEL clause. The previous article in this […]

Synopsis. Oracle 10g has extended the already robust features of Structured Query Language (SQL) with a plethora of intriguing new capabilities. This article – the second in this series – reviews the new capabilities Oracle 10g provides that, in concert with analytical functions, permit the creation of “densified” output with a few simple queries. The […]

Synopsis. Oracle 10g extends many of the already robust features of Structured Query Language (SQL). This article the first of a series illustrates some of the more intriguing new features of SQL within Oracle, including upgrades to the MERGE command, enhancements to hierarchical query capabilities, and improvements to query and access methods for nested tables. […]

Synopsis. Oracle 10g has added over fifty new PL/SQL packages and enhanced many of the existing packages, thus expanding the Oracle DBA’s toolkit once again. New capabilities include the ability to transfer files between servers, more robust e-mail features, improved compilation utilities, and character conversion utilities. This article – the final one in this series […]

Synopsis. With the addition of over fifty new PL/SQL packages as well as enhancements to a majority of existing DBMS packages, Oracle 10g has added a plethora of new tools to every Oracle DBA’s tool belt. This article – the first is a series — explores some of the more intriguing packages and illustrates their […]

Synopsis. Oracle 10g’s new DataPump is designed as the eventual replacement for the Oracle Import and Export utilities. This article – the second and final in this series – focuses on using the DataPump’s features in real-world scenarios, including creation of custom DataPump jobs with DBMS_DATAPUMP. The previous article in this series identified some of […]

Synopsis. Oracle 10g’s new DataPump utility is designed as the eventual replacement for the original Oracle Import and Export utilities. This article – the first in a series – provides an overview of the DataPump’s suite of tools for extracting, transforming, and loading data within an Oracle database. Oracle’s Import and Export utilities offer a […]