DBASupportOracle Flashback Version Query--Trick or Trap
Learn how to use Oracles Flashback Version Query to not only see past data at a particular point in time but also to see how it changed over time.
Oracle 11g Data Guard: Grid Control Management
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.
Oracles Flashback Query TIMESTAMP or SCN?
Oracles 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.
Monitoring Databases
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.
Oracles Flashback Query--Should you unset _in_memory_undo?
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.
Configuring Data Guard Broker
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.
VMware and Oracle Setup Examples - Part 2
This installment of "VMware and Oracle Setup Examples" covers installing Oracle Enterprise Linux, connecting Windows to Windows and connections in general.
VMware and Oracle Setup Examples
With VMware at your disposal, there is practically no reason you cannot gain experience on all of the major operating systems supported by Oracle.
Oracle 11g Data Guard: Building a Physical Standby Database
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.
Revisiting Oracle Passwords
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.
Oracle on Windows, Revisited
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.
Oracle Flash What is it?
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.
DBASupport NewsOracle's pipeline delivers many new products
While the release of Fusion Middleware 11g is the big news today, the company has recently released other products as well.
Oracle Advanced Security Encrypts Oracle Applications Data
Oracle today announced that Oracle Advanced Security, an option to Oracle Database 11g Enterprise Edition, transparently encrypts all application data stored in an Oracle Database tablespace.
System.Data.OracleClient Update
After carefully considering all the options and talking to our customers, partners, and MVPs it was decided to deprecate OracleClient as a part of our ADO.NET roadmap.
Set Up Enterprise Job Scheduling with Oracle 11g
By combining the resource manager and Scheduler, this book explains how to automate business processes, and helps manage and monitor those jobs efficiently and effectively thus boosting database performance.
