Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Author: Dallas Willett
Browse Blog Categories

Oracle Secure Backups to S3 on 10g

If you are trying to install the Oracle Secure Backup Cloud Module for Amazon S3 on your Oracle 10g database, one thing you’ll notice right away is that you need version 1.5 or higher of the JDK.

Dallas Willett | November 2, 2011

Move SPFILE from ASM to File System

The following is an example of how to move your SPFILE from ASM to your file system or vice versa.

Dallas Willett | July 20, 2011

Oracle Backfill Performance

Most of us have had the need to backfill some data at one point or another.

Dallas Willett | May 5, 2011

Real Application Testing

The two main scripts we created to do this were called test.sql and tune.sql. The contents of those scripts comprise the rest of this blog post.

Dallas Willett | April 6, 2011

Implementing COUNT(DISTINCT) with Fast Refresh Materialized Views

Last week when we talked about how to implement a fast refresh materialized view with a MAX aggregate function. This week we will tackle another restriction on fast refresh materialized views. We will work through an example on how to modify a materialized view that includes a COUNT(DISTINCT) in order to get it to fast refresh.

Dallas Willett | December 24, 2010

How to “MAX” out your Fast Refresh Materialized Views

With a very simple materialized view that contains an aggregate function like MAX, Oracle can perform a fast refresh of the materialized view. However, once we start adding some complexity to the materialized view query, Oracle starts to either error out on the fast refresh, or will disallow the creation of the fast refresh materialized view in the first place.

Dallas Willett | December 10, 2010

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS