Tag: Database

In this session we explore the promise of near linear scalability that Oracle RAC makes. We investigate several common problems in detail and present solutions that are transparent to the application. Cache fusion contention, write-write contention, application partitioning and indexing are some of the topics discussed.

In this session we explore the promise of near linear scalability that Oracle RAC makes. We investigate several common problems in detail and present solutions that are transparent to the application. Cache fusion contention, write-write contention, application partitioning and indexing are some of the topics discussed.

In memory database option is the most significant new feature in 12c database. It has the ability to make problems disappear with a single switch. It's as close as possible to fast=true parameter everyone is looking for.Question is, how to you find which tables need this feature the most. How do you find the tables…

In memory database option is the most significant new feature in 12c database. It has the ability to make problems disappear with a single switch. It's as close as possible to fast=true parameter everyone is looking for.Question is, how to you find which tables need this feature the most. How do you find the tables…

A case study of an a-typical SSD implementation.  We were able to make use of our existing SAN by adding a flash storage tier.  We will discuss the problem and how the problem was addressed.  Plenty of charts/stats to highlight a very impressive result.  This is a real world implementation in our highly available production…

A case study of an a-typical SSD implementation.  We were able to make use of our existing SAN by adding a flash storage tier.  We will discuss the problem and how the problem was addressed.  Plenty of charts/stats to highlight a very impressive result.  This is a real world implementation in our highly available production…

Database SHRINKING VS. TABLE REDEFINTION Shrinking. Just what is it? When was shrinking introduced? What components are needed? Table Redefinition. What is it? Time to change columns. What components are needed? Define the need. What are the symptoms? Is application down time possible or needed? A look at a simple shrink. Make sure you have…

Database SHRINKING VS. TABLE REDEFINTION Shrinking. Just what is it? When was shrinking introduced? What components are needed? Table Redefinition. What is it? Time to change columns. What components are needed? Define the need. What are the symptoms? Is application down time possible or needed? A look at a simple shrink. Make sure you have…

Database SHRINKING VS. TABLE REDEFINTION Shrinking. Just what is it? When was shrinking introduced? What components are needed? Table Redefinition. What is it? Time to change columns. What components are needed? Define the need. What are the symptoms? Is application down time possible or needed? A look at a simple shrink. Make sure you have…

Database Shrinking - Advanced Shrinking, a summary. Just what is it? Why do we need it? Is there another way? Looking at the Advisor. The relationship to shrinks. How and when is this run? How do I access the output? Making sense of the output? A look at your tablespaces. Using a home-grown script. Privileges…