Tag: Database

In this RAC Bootcamp presentation, we will at the considerations and procedures for optimizing database and application performance in a RAC environment. Starting with a deeper understanding of some of the background processes, we will progress to RAC related wait events and what they mean. Armed with this information, we will look at RAC specific…

In this RAC Bootcamp presentation, we will at the considerations and procedures for optimizing database and application performance in a RAC environment. Starting with a deeper understanding of some of the background processes, we will progress to RAC related wait events and what they mean. Armed with this information, we will look at RAC specific…

The first release of a new database version results in a flurry of books and articles, with most authors working off a beta release of "Release 1", and wary users waiting for "Release 2". We are now in this situation with Oracle Database 11gR1 in place and 11gR2 being rolled out. As a result, the…

If you enjoy solving a difficult technical puzzle, then working on a system plagued by free buffer waits should get your adrenaline pumping! The free buffer waits event is intriguing because it takes a combination of database writer, IO subsystem, SQL, buffer cache configuration, and server process activity to manifest. Understanding this wait event is…

If you enjoy solving a difficult technical puzzle, then working on a system plagued by free buffer waits should get your adrenaline pumping! The free buffer waits event is intriguing because it takes a combination of database writer, IO subsystem, SQL, buffer cache configuration, and server process activity to manifest. Understanding this wait event is…

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…