7/02
Learn how to use Oracle’s Flashback Version Query to not only see past data at a particular point in time but also to see how it changed over time. 6/25
This article - the third in this ongoing series - demonstrates how to extend an existing Data Guard Broker configuration into an Oracle 10g Enterprise Manager Grid Control environment as well as how to configure the appropriate level of data protection between Oracle 11g primary and standby databases.
6/24
Steve Callan recently attended a three day Performance Optimization for Developers – SQL and PL/SQL
class. This article is a review of the training provided by Hotsos.
6/18
Oracle’s Flashback Query(SQL-driven) makes use of both TIMESTAMP and SCN--but which should you use? It just may be a matter of preference but requires some thoughtful considerations.
6/10
Monitoring tools range from the expensive variety to homegrown, simplistic shell scripted type. Before pursuing one or more approaches, identify what it is you want to monitor, how that information should be surfaced, and by what means you want to capture events.
6/04
The benefits of Oracle's Flashback Query are well documented--but with minor nuances of parameters such as _in_memory_undo, how much should you really buy into them? James Koopmann takes a deeper look at the _in_memory_undo parameter and how it effects flashback query.
5/28
Oracle Database 11g offers several enhancements to the Oracle Data Guard feature set that helps an Oracle DBA to manage a complex, multi-database disaster recovery environment. This article explores how to set up Data Guard Broker for simpler configuration, monitoring and maintenance of Oracle 11g primary and standby databases.
5/27
This installment of " VMware and Oracle Setup Examples" covers installing Oracle Enterprise Linux, connecting Windows to Windows and connections in general.
5/19
James Koopmann examines the typical errors within an Oracle UNDO tablespace, by
breaking the UNDO mechanism, and demystifying the occurrence of errors.
5/13
With VMware at your disposal, there is practically no reason you cannot gain experience on all of the major operating systems supported by Oracle.
5/07
Not
every database is automatically created using Oracle’s Automatic UNDO
Management. Here is a step by step approach to setup UNDO tablespaces for
Oracle’s flashback technology.
4/29
Oracle Database 11g expands disaster recovery features dramatically to include the capability to keep a standby database open for read-only queries
while still accepting change vectors from the primary database. Jim Czuprynski explains how to set up a standby database environment using Oracle 11g's new Recovery Manager features.
4/22
Some common reasons a DBA might want to view plaintext passwords are the use of legacy applications, relatively high personnel turnover, and poor password management/documentation in the first place. Learn how to find those passwords using an Oracle password cracker.
4/08
This article revisits a series written around five years ago regarding running an Oracle database on Windows. There have been quite a few changes--but one aspect that has not changed is Oracle Corporation's commitment to making the RDBMS not only run, but also run well, on the Windows platform.
4/02
James Koopmann travels down the road of system failure, human error and unforeseeable data corruption, looking to both Oracle's Flashback technology and Oracle's flash backup and recovery features for protection in this volatile environment. The first article in this series discusses what the Flashback technology and flash backup and recovery features are.
