Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reporting database

Re: Reporting database

From: <>
Date: Tue, 06 Feb 2001 12:27:44 -0800
Message-ID: <>

A large client that I worked with last year had a very high volume OLTP system and they implemented Quest's SharePlex for a reporting database. It worked well for them. Oracle's current method of replication could never have approached the speed they needed and it would have added overhead to an already overburdened production system. SharePlex reads from log files. You can control what tables are replicated and it's advisable to only replicate the ones you need to ensure that your reporting instance keeps up with the changes to the production database. I believe that Oracle9i will have a similar option to replicate based on log files. Also, I would assume with 9i's clusters, you could designate one or more clusters as reporting instances and others as OLTP instances.

Marc Perkowitz
MTP Systems Consulting

In a message dated 2/6/2001 6:55:17 AM Central Standard Time, writes:

<< How are you all creating reporting databases? We currently have an OLTP  database and we wish to create a reporting database from it. As I see it,  we have the following options:  

  1. Create the reporting database as a Standby database. I don't think that this will work since the database must be up and not in standby mode.
  2. Use Oracle replication. I have heard it is cumbersome and has trouble keeping up with lots of transactions.
  3. Snapshots/materialized views.
  4. Beef up our current machine so that it can handle OLTP transactions and reports.
  5. Since we are using a BMC disk array, we could break the mirror periodically and mount the disks on a new machine.
  6. Other 3rd party replication products.
  7. We could probably use some type of import/exports.

 How are the rest of you doing it? Are there any other options that I  forgot?  

 Tom >>

Please see the official ORACLE-L FAQ:


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 06 2001 - 14:27:44 CST

Original text of this message