Four year gap? No, had just been self-hosting for a while

I had been self-hosting this site at code.circayou.com for a number of years, and actually forgot about this (free) WordPress.com version until recently. I stopped self-hosting because I wasn’t doing much with the site, and had started saving code-snippets to private gists so didn’t really need to use this format going forward. However, since I’ve re-discovered this site, I’ll probably start bringing in some “classic” posts from the self-hosting days and use this concept to provide exposition to my gists as needed.

(because you care, I can tell)

Identify full table scans in Oracle

Tags

Oracle

I used to have a good query that I was happy with to do this, but I apparently lost it. Here’s some queries I’ve cobbled together today to identify full table scans and check their SQL…and determine that a maybe some new indexes might be in order based on real world queries…

select * from v$sql_plan where operation = ‘TABLE ACCESS’ and options = ‘FULL’
AND timestamp > sysdate – .01
order by TIME

and use the hash value to get the SQL:

select * from v$sql
where HASH_VALUE = {hash value of a result}

Task Scheduler error “Action failed to start”

Tags

windows

Interesting point in the Windows Server 2008 Task Scheduler that tripped me up (thanks to http://www.arcomit.co.uk/support/kb.aspx?kbid=000058 for pointing out the problem to me). Don’t include quotes in the Start In: value for your task, even if the path contains spaces. If there are spaces, the Program/Script: value must be surrounded by quotes, but the Start In: value has to be free of quotes…weird.