Daily Archives Wednesday, November 2008

Two New (to Me) iPhone Apps

This blog continues to draw iPhone traffic, so here comes an iPhone post to keep you interested.
I installed two new iPhone apps today.
I Can Has Cheezburger
As I probably mentioned in the past, I tend to install apps, test them for a while, then remove them. Very few stick with me for very long.

Today, I found [...]

Result_cache blocking

Had a result_cache problem today.
If you didn’t know it already, DBA_HIST_ACTIVE_SESS_HISTORY is a real boon for getting a very good idea of a) when the problem started and b) how wide the impact was.
300 session were backing up on a latch free wait. Turns out the latch was the “Result Cache: Latch”.
The blocking session was doing [...]

Data quality is not a one-off

In my Blog post on End-to-end data quality I mentioned the desirability of fixing bad data at source. This certainly attracted comment both here and on other blogs for example
One point to keep in mind about fixing bad data on the source; it is just that, fixing DATA. We are not fixing bad applications [...]