Month: September 2010

awk silliness

This one-liner will print every other character in upper case. oracle@emgrid01 ~ >echo “the quick brown fox jumped over the lazy dog” | awk -F “” ‘{for (i=1; i

instr() in awk

If you have a long command line string, as you may find with java processes with a lot of properties, what is below will allow you to print those “columns” with a certain value as delimited by a space in…

Who is the big load on my server?!

What is below will show SQL statements for a given window (the last four days in the example below) that are tightly correlated with load average on a server. In general, a statistical correlation greater than 60 means there is…