Re: Standby database as reporting server

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 19 Dec 2005 16:09:53 GMT
Message-ID: <lXApf.43094$6e1.427@newssvr14.news.prodigy.com>

Dino Hsu wrote:
[...]
>
> The concept is to offload operational reporting from the transaction
> databases by using a standby database as the reporting server. My
> knowledge is that Oracle has standby database for quite some time (a
> long way ahead actually, standby -> cluster -> grid), but I am not sure
> whether Oracle uses this standby db server as reporting server or do
> any OLAP on it.

Oracle Data Guard Logical Standby (Enterprise Edition), in many circumstances, can do a fine job of handling reporting activity against a primary "transactional" database.

-Mark Bole Received on Mon Dec 19 2005 - 10:09:53 CST