Re: Oracle Net remote buffer product?

> I was wondering if there is some product that works with Oracle Net
> (or should I call if SqlNet given the V7) that would act as a data
> buffer at the remote location so that as laptop1 drags the data across
> the network, laptop2 (which is essentially requesting the same data)
> would get the data from a local buffer. The product would have to be
> transparent to the DL process.

There is already a data buffer at the remote location. It is called the remote database's Buffer Cache. If the data is queried enough, it will be in the Buffer Cache in that remote db.  

> Other than a product such as this, any other ideas given the
> constraints that we cannot not change the application?

Why do people insist on not being able to change anything, but needing a solution to their problem? My solution would be to tune your distributed query. That would most likely reap the largest benefits. Have you tuned this query?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"