script

This tag is associated with 4 posts

Paranoid SQL Execution on Postgres

Posted by Jeremy ⋅ July 6, 2021 ⋅ 1 Comment

Suppose that you want to be completely over-the-top paranoid about making sure that when you execute some particular SQL statement on your Postgres database, you’re doing it in the safest and least risky way? For example, suppose it’s the production database behind your successful startup’s main commercial website. If anything even causes queries to block/pause … Continue reading →

November/December Highlights

Posted by Jeremy ⋅ January 2, 2014 ⋅ 1 Comment

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over beers – justifying hotel and … Continue reading →

Replicating Tanel’s Script Library

Posted by Jeremy ⋅ November 27, 2013 ⋅ 1 Comment

Tanel does offer a zip file with all of his scripts. The zip seems up-to-date now; I started doing this alternative technique awhile ago when the zip file didn’t seem to get updated as quickly as the raw scripts directory. Please remember that as Tanel says on his own website, “always proofread the scripts and … Continue reading →

Delete Archived Logs from Standby

Posted by Jeremy ⋅ November 18, 2013 ⋅ 4 Comments

This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system. (Specifically, a RAC/thread aware script.) There are a few scripts published: Emre Baransel [2009, single-thread only, uses alert … Continue reading →