For those of you who enjoy singing hymns in church, I find God Rest You Merry, Gentlemen to be an enjoyable hymn to sing and research. Here are some things I learned about the song. There should be a comma between the words “merry” and “gentlemen.” It is an unfortunate consequence of the pace of [...]
As my good friend and brother Fred approaches his wedding day, I thought I’d publish this word of warning to him, or any man who is considering this endeavor.
If you are an Oracle programmer, then you’ve probably encountered the ORA-00054: resource busy and acquire with NOWAIT specified exception when attempting to truncate a table. When this happens during the day, you can usually just wait a few minutes (or go and commit your other open sessions…), but what about when you are truncating tables as part of a script which runs overnight? Are you tired of being woken up so you can simply rerun the script?
Well check out this script, then! It is a very simple PL/SQL procedure which accepts 1 or 2 arguments.
I haven’t ‘blogged’ for a long time. At least not regularly. But tonight my wife actually suggested it. This is a strange occurrence because we get so little time together anyway. I used to write my blogs on a laptop while riding a bus to work, but my new job is only good for listening [...]
Have you ever wanted to see your Oracle output or log files open in your custom text editor instead of an IE window? I use Notepad++ (FREE) for text editing. Every time I open an output file or log file which is text it opens in IE. This is undesirable for a couple of reasons: [...]
