*Or “can I use result_cache to cache for 1 minute/day/hour/day/week/month”
There is already a plethora of excellent resources on the new 11g result_cache functionality, notably:
Oracle Database Concepts Manual
oracle-developer.net - pl/sql function result cache
oracle-developer.net - query result cache
Including a couple of interesting angles on things here:
At Pythian - RC Enqueue, RC Latches, Does 11g result cache scale [...]
Post 11g upgrade, one of the first things I noticed was in the AWR reports.
In the Instance Efficiency Percentages, the “Parse CPU to Parse Elapsd %” was a less than impressive “0.00″. I’ve become accustomed to this being low in reports here, but not that low .
This has been confirmed as a new bug [...]
Still looking good.
CPU on the new box is hovering under the 20% mark having been habitually > 80% on the old kit. But it could be a quite time for the business so we will have to compare the metrics that we capture as a proxy for “business activity”.
Best news is that we were getting [...]
Production database was upgraded to 11g over the weekend: 9i -> 11g, SE -> EE, Windows -> Linux.
This is the first application in this client’s company to upgrade.
Seems to have gone well given that I was not called over the weekend.
As ever though, the only true test is going live and I would be [...]
(or my database emails have stopped working)
Wotcha.
Here’s the background:
We’re in the latter stages of preparing for a production upgrade to 11g (2 weeks to go).
Best practice would say that we should have a stable database by now and very high confidence factor, but the truth is that the production upgrade coincides with a new [...]
The other day, on my commute, I was reading this report in the Telegraph - about The Large Hadron Collider at CERN (I also see Doug was there a-visiting not so long ago).
In the article, the main thing that caught by eye was this:
The Large Hadron Collider (LHC) will produce close to one per cent [...]
It seems commonsense to most database specialists that, for data-centric applications where the application does not need to be database independent*, for logic that is close to your data - data logic - and data-intensive operations, it’s likely to be more efficient for that to be in the database, to be quicker in the database, [...]
I’m feeling flat today and apologise for the sensationalist headline.
I also apologise for another one of this useless opinion-based posts. There are far too many of opinions in this site, not to mention far too many posts on things requiring further investigation which never gets done, and not nearly enough concise, factual posts which give anyone any [...]
Outsourcing small projects or using some management strapline like “flexible demand-driven development model”, it never works.
This is the Nth place I’ve worked where they’ve decided that to be able to supply the non-linear development needs of the business, the next solution to try is to outsource individual projects to “strategic development partners”.
In my experience, this solution is [...]