Displaying posts categorized under

Technical

Windows 10 Icon Removal and PERSONAL.XLSB Movement

I had a rather productive afternoon on my computer. If anyone needs help with these items, please contact me and I’ll help you. Long story short, here is what I accomplished: I can’t stand the Windows 10 upgrade icon in the system tray (lower right). I had removed it before by uninstalling and hiding a […]

Use Dropbox to Protect and Share Your Files and Access Anywhere

A neighbor brought to me a common problem the other day. Another neighbor of ours was working on a document for school, is convinced she saved it numerous times – yet now she cannot find it. There could be a few reasons this happens. One possible reason is that she never really saved her changes. […]

A Little Fun for Today

As an I.T. professional, I get some, um, shall I say random questions from time to time. This one came this morning on my IM. (Instant Messenger) Coworker: STUPID QUESTION TIME- is there a way top make my keyboard silent? Me: Tap it three times on the left, then three times on the right, then […]

Steve Jobs’ Final Wish

I don’t know a lot about Steve Jobs. I watched Pirates of Silicon Valley and have bought a few iPods. I had never met the man: so how do I propose to know his last wish?

Avoid ORA-00054: resource busy and acquire with NOWAIT specified on Truncate

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.