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…
Month: December 2011
ASM device structure
Today, we had an issue where the asmlib disk label was removed from a disk at some point in the past. When we added new storage and issued oracleasm scan disks , the disk was “cleaned”, rendering it unavailable on…
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,…
Additional cursor trace information in 11.2.0
Oracle has added a lot of additional trace output in the 10046 optimizer trace files. As I have posted previously, I find the output in these files to be useful not only for troubleshooting performance issues, but also understanding the…
Posting GV$SESSION_LONGOPS from a user procedure
The GV$SESSION_LONGOPS view can save you if you are nervous about how much time a long running operation has remaining, and are asked for an update from someone in a higher “zip code”. Oracle posts an entry to this memory…
Which transaction is being rolled back?
This morning, we had an issue in a development database where we couldn’t drop an UNDO tablespace as a transaction was currently using it. We saw nothing in the GV$TRANSACTION view, so we knew it must be rolling back a…