I can’t imagine that this would be useful in a well managed system, but if you find yourself with a “raw” log file that is not in the dictionary, you can at least extract the SCN range it encompasses using…
Category: Operating Systems
Converting ASCII to binary
This is pretty useless, but I know some people like this kind of thing 🙂 10:11:42 oracle@emgrid01 ~ >echo “if you can read this you are a geek” | xxd -b | awk ‘{printf(“%s %s %s %s %s %s “,$2,$3,$4,$5,$6,$7)}…
Creative ways to do simple things
I always like exercises such as this, especially for interview questions. In an interview, I am never looking for the correct answer as often as I am how the question is answered, and how creative the person is. For example,…
Using awk to extract bind variable values from a trace file
While troubleshooting a high CPU utilization problem recently, I found that half the sessions using a given database service were using a high amount of CPU, while the other were using a normal amount. Since I knew they were each…
ipcrm not removing SGA shared memory segment
Today, I had an issue I had seen before, but I can never remember how I fix it. As such, I wanted to document it here. Although rare, periodically an abnormally terminated instance will leave behind a shared memory segment.…
Loop through and print directory size
Set objShell = CreateObject(“WScript.Shell”) Set objFSO = CreateObject(“Scripting.FileSystemObject”) Set objFolder = objFSO.GetFolder(“C:\”) Set colSubfolders = objFolder.Subfolders For Each objSubfolder in colSubfolders on error resume next Wscript.Echo objSubfolder.Name, objSubfolder.Size Next
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…
Using awk with group by functionality
You can use the following example if you need to total numbers over a group in a given file. We first show our sample file… 14:30:57 oracle@emgrid01 ~ >cat list.txt steve:61 steve:14 becky:57 steve:19 jenna:69 stephen:57 maddie:54 jenna:53 abby:41 jenna:21…