Re: two instance -- one database

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_at_constellation.com>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
>
>

--
http://www.freelists.org/webpage/oracle-l