Re: Oracle Net remote buffer product?

Brian,
I can't change any of the application because these are considered to be medical devices regulated by the FDA. I would love to be able to change the apps, but one mistake could mean that somebody in a hospital gets blood from an AIDS donor. Changes therefor are rare because of the extreme change control process and validation requirements.

How can there be a shared buffer at the remote location? I was not aware that SQLNet did any buffering that could be shared across multiple sessions.
Again, the situation is a single database server at a central location with multiple laptops connecting over a leased line from a remote location. Each laptop has it's own Oracle database and uses a database link "create link ..." to download data from the central database. Each laptop will be downloading the same data. Each laptop will need to be re-downloaded a couple of times a week as new data in the central(master) database becomes available.

In case your interested, The central database contains blood donor information including information about which donors should not be accepted because of some problem like they have HIV or Hepatitis or West Nile Virus or they just donated yesterday and are already running a pint low. After the donor information is loaded onto the laptops, the laptops are take out on the road on blood drives.

Thanks!
Mike

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F54BE8C.8D5B5FBF_at_remove_spam.peasland.com>...
> > 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"
Received on Fri Sep 05 2003 - 21:10:04 CDT