Seth Miller

Technical ramblings of an IT guy

Category: IT

Tablespace Size Report Script (updated)

I actually found it a little difficult to find a good sql script for reporting tablespace size so I took one that was almost there which I believe came from Oracle-Base and modified it to fit my needs. Feel free to comment or modify. Update: I’ve made significant changes to this script including a header […]

Monitor NFS I/O

We use RMAN to backup to an NFS share. I was having some very lengthy RMAN backup times during certain time periods and the storage team was not able to correlate the slow downs to anything useful so I decided to monitor the NFS shares. I looked at the OS Watcher logs for information about […]

How Far Back Can I Flashback My Database To?

Flashback Database Here is a useful query to find out the current limit of flashback database. Change the ‘US/Central’ to your local time zone to convert the time zone your database is in to your local time zone. The first column is the earliest point in time you can flashback the database to. The second […]

Oracleasmlib Not Necessary

Not only is it not necessary, but it may not even be available. This is in fact exactly what I discovered recently when I installed the Oracle Linux 6u3 and tried to install Clusterware on it. There are three packages that one would normally install as part of ASM: oracleasm-$( uname -r ) # Kernel […]

Oracle OpenWorld 2012

I was about to board a plane to return home to Minneapolis from San Francisco but since my flight is delayed for another hour I will share some thoughts about my week. Today concludes day seven of my second attendance of Oracle OpenWorld. It was bigger and better than ever. Oracle and the sponsors spare […]

CRSSTATM: Fun with Awk

If you are not familiar with “awk” (actually “gawk” in Linux), you are missing out a very powerful and versatile interpretive language. It looks cumbersome at first but once you get a grasp of the basic concepts, it is quite simple. The authors (who very unoriginally used the first letters of their surnames to come […]

Oracle OSWatcher: Enterprise Wide Install Tips

I recently finished setting up a two node 11gR1 Oracle RAC cluster. One of the last steps was to run RACCHECK to see if anything was missed. A lot of recommendations came up, including setting up OSWatcher. Setting this up has not been a standard practice for us but I have used it for troubleshooting […]

Invest In Your People

A Guide for Retaining Skilled Professionals Companies hire new employees every day. The reactions employees have to negative work experiences are unpredictable. Some employees will be thankful to have a job and accept anything that happens while others may immediately decide that this isn’t the right place for them and continue to look for another […]

Find Instances and Listeners in Linux

I created this script to make it very easy to see which instances and listeners are running on my server. I mostly use it to make sure everything is down when patching in RAC. Stick it in your profile script, or better yet your /etc/bashrc so all users have access to it. function pl { […]


I’ve been reading about the products my company produces. I see a lot of pictures around the building of cool looking stuff, but up until recently I had no idea how it works. I also hear a lot of medical technology language that I’m not sure what function it has on the human body. So, […]