Jim Czuprynski

Synopsis. Oracle 10g’s new Secure Backup features offer the capability to insure that all Recovery Manager (RMAN) backups are created and maintained in a secure fashion without the need for a potentially expensive and cumbersome media management layer (MML). This article – the first in this series – provides an overview of Oracle Secured Backup […]

Synopsis. Oracle 10gR2 includes some security features that have been long-overdue: the ability to encrypt DataPump Export dump sets and Recovery Manager (RMAN) backup sets. This article – the fourth and final in this series – discusses and illustrates how any Oracle DBA with a reasonable level of experience can implement this unprecedented level of […]

Synopsis. Oracle 10g dramatically improves the overall security of the data that’s stored within the Oracle database. This article – the third in this series – reviews how Oracle 10gR2 protects against an intruder’s efforts to view the data stored within a database’s physical files by implementing the impressive features of Transparent Data Encryption (TDE). […]

Synopsis. Oracle 10gR2 enhances and expands data security with new row-level security features that ensure a user can only view, add, or modify data based on specific virtual private database (VPD) rulesets. This article – the second in this series – discusses how these new features improve upon those in prior releases and demonstrates how […]

Synopsis. Oracle 10g extends the original fine-grained auditing (FGA) features that Oracle 9iR2 introduced, including expanded capacity to audit for specific events based on statements issued, the columns that a SQL statement has accessed, and even the subset of data that the statement is affecting. This article – the first in an ongoing series on […]

Synopsis. Oracle 10g Release 2 (10gR2) has improved the effectiveness and speed of materialized view refreshes, something especially important as data warehouses and data mart environments become increasingly complex and mission-critical requirements for all enterprises. This article – the last in this series – demonstrates how to utilize the new Partition Change Tracking (PCT) features […]

Synopsis. Oracle 10g Release 2 (10gR2) has improved the effectiveness and speed of materialized view refreshes, something that is becoming especially important in increasingly complex data warehouses and data mart environments. This article – the first in a series – demonstrates several new features of materialized views in Oracle 10gR2, including enhancements to join-only materialized […]

Synopsis. Oracle 10g Release 2 (10gR2) has improved significantly the methodology for tracking performance metrics within the database. This article – the last in this series – demonstrates how to implement adaptive thresholds and use their metrics to effectively detect significant performance threshold violations while tuning out the “noise” from false positives. In the prior […]

Synopsis. Oracle 10g Release 2 (10gR2) has improved significantly the methodology for tracking performance metrics within the database. This article – the first in this series – discusses how adaptive thresholds are designed to improve the detection of threshold violations, including the ability to discern a false positive from a true warning. I first started […]

Synopsis. Oracle 10g Release 2 (10gR2) augments the capabilities of Transportable Tablespaces to provide the ultimate in data availability: the capability to store and retrieve multiple versions of any tablespace’s data. The final article in this series discusses how to utilize these new features to create a data “jukebox,” as well as how to transport […]

Synopsis. Oracle 10g Release 1 (10gR1) adds several new features in the arena of Transportable Tablespaces. This article – the first in this series – demonstrates how these new features enable the transfer of data between databases on different servers across platform boundaries regardless of those platforms’ operating systems. One of the bigger challenges just […]

Synopsis. Oracle 10g Release 1 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. The final article in this series illustrates how an Oracle DBA can […]