Keegy United States - OraStory: Loader

Loader

It’s been years and years since I worked regularly with SQL*Loader-based feeds. There are loads of tips and tricks regarding formats, encodings, character sets, etc. I had forgotten nearly everything that I could ever have claimed to know in this area, all aged out of my personal buffer cac...

Bury

OraStory — Before yesterday

0 Votes vote

Learning

Earlier this month I attended Tanel Poder’s course “Advanced Oracle Troubleshooting for DBAs and Performance Engineers”. It was good – definitely worthwhile, lots of useful information and really puts into perspective those scripts of his, like LatchProf, LatchProfX, WaitP...

Bury

OraStory — October 28

0 Votes vote

Metalink headlines

When I was thinking about whether to go on Tanel Poder’s course, I read the testimonials and there’s a great piece of advice from Tanel via Coskan Gundogar: I asked him how do you learn all these interesting stuff. He gave me a perfect clue. Sign up for metalink headlines mailing lis...

Bury

OraStory — September 16

0 Votes vote

Data modelling in the modern world

I first read Robyn Sands’s article on the importance of a good data model back when it was published in May. However, the comments have since moved on and taken a life of their own – a sure sign of a great post – with some excellent points and poignant observations on the freque...

Bury

OraStory — August 06

0 Votes vote

Gotcha: Application Contexts

This is one of those feature behaviours which isn’t surprising, but you probably wouldn’t think about it unless you saw it. The flop: I make heavy use of application contexts in flexible, variable input, dynamically-built queries (one of the options mentioned in this asktom thread for...

Bury

OraStory — July 14

0 Votes vote

Documentation in need of confidence booster

Some people put a lot of weight on what the Oracle documentation says. It is a hugely significant resource. But there are some documentation bugs / errors. I was answering a character set posting on the OTN forums and when providing some links to the doco, I noticed this documentational crisis of...

Bury

OraStory — July 05