Re: two instance -- one database

  • From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • To: Mark.Brady@xxxxxxxxxxxxxxxxx
  • Date: Wed, 24 Sep 2008 10:14:54 -0500

Hmm. If they are straight views to the database, I fail to see how this
protects Database A from bad queries as the bulk of the work will be done on
Database A anyway. If they are using materialized views, or streams, or
Logical Standby, or any other form of replication, I would probably agree
with them.

Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd


On Wed, Sep 24, 2008 at 10:07 AM, Brady, Mark
<Mark.Brady@xxxxxxxxxxxxxxxxx>wrote:

>  I have a friend (no really, this isn't some lame way of telling you about
> me but trying to hide that by … )
>
>
> I have a friend, and at his company they have an Oracle database with
> tables and data. We'll call it Database A and they have another Database B
> that has views across dblinks to each of the tables in Database A. The data
> team says that this protects Database A from bad queries.
>
> So can anyone think of any possible benefit from this arrangement? Will
> administration be easier, queries faster, performance more predictable?
> Anything?
>
>
> >>> This e-mail and any attachments are confidential, may contain legal, 
> >>> professional or other privileged information, and are intended solely for 
> >>> the addressee.  If you are not the intended recipient, do not use the 
> >>> information in this e-mail in any way, delete this e-mail and notify the 
> >>> sender. CEG-IP1
>
>

Other related posts: