Re: two instance -- one database
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: Mark.Brady@xxxxxxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Sep 2008 18:29:01 +0100
Only if the views are materialized views, and probably then only if
they are snapshots (complete refresh) On the plus side for your
friends they'll likely be able to point to a higher number of sub
optimal plans coming from the remote db as compared with having a
different schema in the same db.
On 24/09/2008, 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
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
