Re: Fetch table names from query

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 24 May 2008 14:59:35 +0200
Message-ID: <e6b3a$48381137$524b5c40$12912@cache6.tilbu1.nb.home.nl>

Álvaro G. Vicario wrote:
> Dan Blum escribió:

>>> This is horrifying. Obsolete data is defined by an SLA with the customer
>>> not by whether it is accessed.

>

>> I think he means he wants to identify obsolete data in his results cache,
>> so he can refresh it from the database, not delete data from the 
>> database.

>
> Er... Yes, that's it. I can't even understand what Morgan means. A
> results cache must not be such a bad idea if many major DBMS implement
> it in recent versions, including Oracle itself.
>
>

>> However, I agree that this is not a wonderful idea, as it is essentially
>> recreating Oracle functionality. If results caching is that critical,
>> I would suggest running 11g, which implements it.

>
> However, the database server runs 10g. If I tell the customer that in
> order to run an auxiliary web reports application they need to buy a
> licence for 11g, upgrade their server, check that all existing apps
> (functions, stored procedures, ERP, several custom Oracle Forms
> utilities, online orders web site, backup system...) do not break... I'd
> say they won't be amused.
>

Consider Web cache (which you probably have, but not installed/activated?)

-- 

Regards,
Frank van Bortel

Received on Sat May 24 2008 - 07:59:35 CDT