RE: two instance -- one database
Date: Thu, 25 Sep 2008 08:32:23 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE092E6@EXCNYSM0A1AJ.nysemail.nyenet>
John,
That's why I asked him to test it to see if it was an issue. It used to be an issue but I was unsure if it was resolved or not.
As always, I suggested testing testing testing.
Tom
-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj_at_gmail.com]
Sent: Wednesday, September 24, 2008 9:34 PM
To: Mercadante, Thomas F (LABOR); Mark.Brady_at_constellation.com; oracle-l
Subject: Re: two instance -- one database
Tom,
Imho, generally, pushing filter predicates over dblink does occur in newer versions (>8i) as long as you don't have local tables involved (as in this case).
John
On 9/24/08, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante_at_labor.state.ny.us> wrote:
> Mark,
>
>
>
> Have you tested a multi-table join across the database link?
>
> Pick two very large tables.
>
> Create a query and run it on the source database with timing turned
on.
>
> Run the same query on the remote database and compare the timings.
>
>
>
> This used to be a very big issue. The "where" clause used to be
> executed locally which means that all data from both tables was
brought
> across the database link and joined locally. A very bad arrangement.
>
>
>
> I agree with Tim Gorman. It accomplishes nothing and adds complexity
at
> your personal cost. You will be tuning this arrangement forever.
>
>
> Tom
>
>
>
> ________________________________
>
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Brady, Mark
> Sent: Wednesday, September 24, 2008 11:07 AM
> To: oracle-l
> Subject: two instance -- one database
>
>
>
> 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
>
-- Sent from Gmail for mobile | mobile.google.com John Kanagaraj <>< http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 25 2008 - 07:32:23 CDT