Jim Czuprynski

Synopsis. Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article – the final in a series – focuses on new functionalities provided by the Data Guard and LogMiner tool suites. The previous article in this series delved […]

Synopsis. Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article – part three of a series – concentrates on the expanded capabilities of the logical Flashback command set. The previous article in this series discussed how two […]

Synopsis. Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article – part two of a series – explores one of the most intriguing new features of Oracle 10g: Flashback Backup and Recovery. The previous article in this […]

Synopsis. Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, especially in the arena of disaster recovery. This article – the first in a series – concentrates on several new features available for backup, restoration, and recovery of Oracle databases, especially when using Oracle Recovery Manager (RMAN). If you […]

Synopsis. Oracle 10g’s new DBMS_SCHEDULER package offers significant advanced features over its predecessor, DBMS_JOB, that any reasonably skilled Oracle DBA can use to insure that sufficient resources will always be available for processing complex business requirements. This article – the final in a three-part series – provides some practical examples of how the new Scheduler […]

Synopsis. Oracle 10g’s new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the second in a series – provides practical examples of using the Oracle Scheduler’s new functionalities, including a discussion of transitioning from DBMS_JOB to DBMS_SCHEDULER. Basic Scheduling: A Scenario The previous article provided a broad overview […]

Synopsis. Oracle 10g’s new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the first in a series – provides an overview of the new functionalities that the Oracle Scheduler provides for DBAs. One of my first tasks I was assigned as a newly-minted DBA was to help one […]

Synopsis. Oracle 8.1.6 offered a new format for tablespace storage management – locally-managed tablespaces – that offers significant improvements in tablespace performance and free space management. Oracle 9i Release 2 improved upon segment storage in locally-managed tablespaces with the Automatic Segment Storage Management option. This article delves into the advantages of using locally-managed tablespaces over […]

Synopsis. Oracle 9i offers the ability to pass data to a PL/SQL function in the form of a cursor variable. When this feature is paired with the concept of the table function, the resulting PL/SQL code increases significantly in flexibility and scalability. This article builds upon the author’s previous article on table functions and provides […]

Synopsis. Oracle 8i offered the CAST function, which allows a PL/SQL collection to be processed as if it was a normal table. When CAST is paired with table functions, it becomes even more powerful as a data manipulation toolset. This article provides a brief technical explanation of CAST and table functions as well as some […]

Synopsis. When an Oracle database suddenly becomes unavailable, the immediate reaction is to do something — right now! — to solve the problem, which sometimes makes the problem worse. This article discusses some examples of when it’s really best to stop and think before proceeding. Military veterans I have spoken with have often described their […]

Synopsis. 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 final article builds upon the concepts in the two previous articles, including the construction of more complex resource plans, monitoring DRM utilization, and […]