After yet another post by someone whose database has crashed without running in archivelog mode and without having multiplexed redo logs, it makes me think it’s about time Oracle changed the default installation to include both these things.
Over the last few versions, Oracle have consistently made the database easier to install and use, but they [...]
I’m a big fan of the Oracle documentation, but sometimes things go astray. A recent question by Aman Sharm about SQL sharing critera highlighted this…
In the 8iR3 manual, the decision process for finding matching SQL is listed as:
The text string of an issued statement is hashed. If the hash value is the same as a [...]
If you are reading this it means my blog has been upgraded to the latest release of WordPress (2.5.1).
Cheers
Tim…
I was standing in HMV the other day, trying to convince myself not to buy a Nintendo WII with WII Fit and SuperMario Kart, when I noticed the film Sky Blue was being sold for £5. I’d been toying with the idea of buying this for some time, but a reduction of $15 pounds forced [...]
I went to see Street Kings at the weekend. In summary, good cops, bad cops and cops that don’t know if they are good or bad.
Keanu Reeves is OK. Forest Whitaker if very over the top, with a few scenes of frantic head wobbling. Not sure what to make of him.
It was OK, but it [...]
I’ve just posted an article on SecureFiles in Oracle 11g. It looks like Oracle have done a pretty good job of improving LOBs in 11g. Depending on the LOB contents, and provided you can cope with the processing overhead, you can certainly save some serious space using the compression and deduplication options. Anyone who’s used [...]
My quest to read the Discworld series continues:
Lords and Ladies - This book starts where Witches Abroad finished. This time the witches have to prevent elves returning to the Discworld. Love, marriage, death and elves. What more could you want.
Men at Arms - I keep reading these books and saying, “This one is [...]
I spent yesterday looking at the Tablespace Encryption feature in Oracle 11g. If you’ve used the Transparent Data Encryption (TDE) feature in 10g release 2, you’ll see this is more of the same. The difference here is eveything in the tablespace is encrypted, rather than having to decide on a column-by-column basis. Just create the [...]
There’s some good stuff out on the net today:
Tom is back and talking about the level of skills in the IT industry. I think we all share his pain.
Mary Ann Davidson has a great piece on security. This links in nicely with what Tom was saying, in so far as it relates to [...]
I’ve spent the last few weeks in discussion with Vodafone about what I believe is a scandalous bill for roaming data charges. Vodafone agreed to reduce the bill by 25%, but this still represents daylight robbery.
Fast forward a few weeks and the BBC’s Watchdog program highlighted several cases similar to mine, where people had been [...]