RE: two instance -- one database

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-l