Jim Czuprynski

Synopsis. Oracle Database 11g’s new SecureFiles storage capabilities extend the flexibility and capacity of Large Objects (LOBs). This article – the next in this three-part series – explores how to migrate most efficiently from BasicFiles to SecureFiles storage, how to measure the relative storage efficiency of SecureFile vs. BasicFile LOBs, and how to utilize the […]

Large Objects (LOBs): A Brief History Lesson The first time I encountered an application that required a binary large object (BLOB) was literally a millennium ago. In 1999, our IT organization at the American Medical Association (AMA) in Chicago, Illinois was tasked with upgrading that organization’s seventy-plus mainframe applications into four client server applications. I […]

Synopsis. Oracle Database 10g offered two new Flashback features- Flashback Versions Query and Flashback Transaction Query – that allowed an authorized user to see all versions of any changes made to one or more rows in a table, as well as the capability to view the entire transaction associated with any row change, based on […]

Synopsis. Oracle Database 10g offered five new Flashback features: Flashback Versions Query, Flashback Transaction Query, Flashback Drop, Flashback Table, and Flashback Database. Oracle Database 11gR1 offers an intriguing new Flashback feature – Flashback Data Archives – that allows an Oracle DBA to preserve a record of all changes to any table for a definite period […]

Synopsis. Oracle Database 10g introduced the Automatic Database Diagnostic Monitor (ADDM) feature set as part of the Diagnostic Pack, and it’s proved to be a flexible scalpel for pruning away nonrelated issues during both reactive and proactive instance performance tuning. This article illustrates how Oracle Database 11gR1 has expanded ADDM to encompass Real Application Clusters […]

Synopsis. At the heart of any SQL statement optimizing engine is the capability to determine the least expensive and most effective access path to the statement’s target data. Bind variables help limit the number of SQL statement cursors that need to be stored in the Library Cache to return similar result sets. This article discusses […]

Synopsis. Oracle Database 11gR1 offers several new performance enhancements that limit “round trips” between database server, application servers, and applications when the identical data is required to answer queries, provide lookup data, or return deterministic values from a function. The final article in this series explores how the latest release of Oracle extends the ability […]

Synopsis. Oracle Database 11gR1 offers several new performance enhancements that limit “round trips” between database server, application servers, and applications when the identical data is required to answer queries, provide lookup data, or return deterministic values from a function. This article – the first in this series – delves into how the result set from […]

Synopsis. Oracle Database 11gR1’s new Database Replay (DBR) features allow an Oracle DBA the capability to capture a workload from an Oracle 10gR2 database environment and then replay that same workload against an Oracle 11gR1 database environment to analyze how the transition to the new Oracle database release will impact overall system’s performance. The final […]

Synopsis. Oracle Database 11gR1 offers the ability to capture applications’ workloads in a production environment and then replay that workload against a test environment to determine the impact of proposed system, database or application modifications on database performance. This article – the second in this series – demonstrates how Oracle 11g Database Replay can be […]

Synopsis. Oracle DBAs have long wished to be able to capture applications’ workloads in a production environment and then replay that workload against a test environment to determine the impact of proposed database or application changes on database performance. Oracle Database 11gR1’s new Database Replay feature enables an Oracle DBA to capture, massage, and then […]

Synopsis. Oracle Database 11gR1 offers a new tool set, SQL Plan Management (SPM), that lets any Oracle DBA capture and preserve the most efficient execution plans for any SQL statement. The final article in this series illustrates how to use SPM to limit unexpected regression of existing SQL statement performance before those statements first encounter […]