Oracle Data Guard can be an integral part of a disaster recovery plan and can be used to protect against planned and unplanned downtimes. Data Guard standby databases can also be used to support production functions such as reporting, querying, and testing, while in a standby role. This presentation will discuss Oracle Data Guard architecture.…

Oracle Data Guard can be an integral part of a disaster recovery plan and can be used to protect against planned and unplanned downtimes. Data Guard standby databases can also be used to support production functions such as reporting, querying, and testing, while in a standby role. This presentation will discuss Oracle Data Guard architecture.…

Do you ever wonder why there is an “undo” tablespace and “redo” logs instead of “undo” logs and a “redo” tablespace? Do you want to know when these are written to and what they are used for? What about those memory structures? There are “areas”, “pools”, “caches”, and “queues”… how are they different? And when…

Do you ever wonder why there is an “undo” tablespace and “redo” logs instead of “undo” logs and a “redo” tablespace? Do you want to know when these are written to and what they are used for? What about those memory structures? There are “areas”, “pools”, “caches”, and “queues”… how are they different? And when…

Billy Cripe, Author, Blogger and Man in Kilt returns to talk about Enterprise 2.0 information architecture. Designing systems that understand context as well as information flow are critical to realizing the promise and benefit of E2.0. Before systems can be wired together you must understand the overlap and intersection of people, systems and information. Without…

Billy Cripe, Author, Blogger and Man in Kilt returns to talk about Enterprise 2.0 information architecture. Designing systems that understand context as well as information flow are critical to realizing the promise and benefit of E2.0. Before systems can be wired together you must understand the overlap and intersection of people, systems and information. Without…

We all know that optimizer stats are vital for the optimizer to produce efficent plans. Histograms provide the optimizer with even more detailed knowledge on the data. But what about the SQL statements that transform the data in predicates, e.g. UPPER() or NVL()? The optimizer can't make an intelligent decision in those cases. In Oracle…

We all know that optimizer stats are vital for the optimizer to produce efficent plans. Histograms provide the optimizer with even more detailed knowledge on the data. But what about the SQL statements that transform the data in predicates, e.g. UPPER() or NVL()? The optimizer can't make an intelligent decision in those cases. In Oracle…

Collecting Optimizer Statistics is always a double-edged sword - it might force the optimizer to generate new plans which could be better or worse than the existing plan. But you can't stop stats collection too; since that could definitely result in poor plans. So what can you do? In Oracle 11g, you can force stats…

There has been an explosion of IT applications in recent years. This presents a major challenge for companies with regards to IT investments in hardware for databases. This can be dedicated database hardware for a specific set of applications, shared database hardware across all disparate applications within the organization, or a mix of both. This…