Skip to content





Author Archives Jonathan Lewis

Useful blog

Browsing around over the weeend, I came across this blog.
I didn’t spend much time reading through the material, but at first sight I got the impression that a number of the articles might be useful to people who were starting to experiment with RAC systems  and could do with some step by step guidance when [...]

Posted 05 October 2008 § Uncategorized ‡ Comments Off °

Let’s Pretend

Here’s a summary of a question that appeared on the Oracle Forum some time ago:
I had been seeing frequent log file switching (resulting in “checkpoint not complete” reports) at night when some export dumps have to occur simultaneously, so I increased my redo log file sizes from 5MB to 10MB.
I now have a user who [...]

Posted 05 October 2008 § Uncategorized ‡ Comments Off °

Advert - Chris Date

I’ve just been sent an email about an event in Edinburgh next month, featuring Chris Date in a two-day seminar titled “A Relational Approach to SQL” - plus a half-day forum on the third day.
The event is organised by the e-Science Institute, with assistance from Oracle. Thanks for the assistence from Oracle, the cost to [...]

Posted 04 October 2008 § Uncategorized ‡ Comments Off °

Burleson BS 2

It’s been over a year now since Don Burleson published his “biased test cases” article. He removed it from his website after I had pointed out that his behaviour was likely to damage his reputation more than it would damage mine - at which point I deleted all the associated comments from my blog. Sadly, [...]

Posted 02 October 2008 § Uncategorized ‡ Comments Off °

Upgrades

I posted a summary of page hits a little while ago when the WordPress statistics hit 750,000 page views, and commented at the time that a couple of the most popular items seemed to be related to the types of issue you get when you upgrade to 10g.
Well, it occurred to me this morning to [...]

Posted 02 October 2008 § Uncategorized ‡ Comments Off °

XMLDB

I don’t really have anything to do with XMLDB (beyond the fact that it’s an application built in an Oracle database, of course, and subject to tuning and bugs just like any other application), so it was nice to get an email last night from Marco Gralike telling me that the next release of XMLDB [...]

Posted 02 October 2008 § Uncategorized ‡ Comments Off °

Analysing Statspack (10)

[Back to part 9]
The following question appeared some time ago on the Oracle Forum:

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time [...]

Posted 01 October 2008 § Uncategorized ‡ Comments Off °

BlogRoll

You may have noticed that I keep my blogroll quite short - I have a few names on there more or less permanently, and have a few “guest” slots that I change from time to time.
At present, Cary Millsap isn’t on the list - though he has been one of the “guest” names in the [...]

Posted 01 October 2008 § Uncategorized ‡ Comments Off °

Burleson BS 1

If you make use of the blogroll I’ve got at the right of this page, you’ve probably visited Greg Rahn’s blog a few times. If so, you may have noticed that Don Burleson has decided to pitch in and throw some mud around because he feels threatened by Greg’s choice of example in a posting about [...]

Posted 30 September 2008 § Uncategorized ‡ Comments Off °

Index Analysis 2

Shortly after I published the previous post, I received an email from an old client who reminded me of a problem he had had with empty index blocks, the solution we had used (which was a coalesce) and an update on how things had changed in the latest releases of Oracle.
Strangely, I was sure I [...]

Posted 29 September 2008 § Uncategorized ‡ Comments Off °