Blog

5 min read

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.

4 min read

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.

7 min read

Oracle Backfill Performance

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

11 min read

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.

11 min read

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.

21 min read

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.