The Multifunctioning DBA:

March, 2009

March 31, 2009  4:36 PM

Perfstat Cron Jobs

Colin Smith Colin Smith Profile: Colin Smith

Here is the update on changing the perfstat statspack job that I spoke of earlier. The question was how can I get statspacks to run every 15 minutes during OLTP and every 2 hours during batch. My thought is a Cron Job that will run the SQL for you. Just make a connection to the DB using SQLPLUS and...

March 31, 2009  3:57 PM

Sybase Learning Continued

Colin Smith Colin Smith Profile: Colin Smith

Today I came back into the office after having a week off. It is always hard to come back into the office but it is nice to get back into the swing of things as well. When I arrived I found some new Sybase books sitting on my desk. Now I know that my company is not going to send me to another class...

March 30, 2009  9:57 PM


Colin Smith Colin Smith Profile: Colin Smith

So I have people ask me all the time how I can get so much done in a day. I have to be honest with you, I do not really do that much. This is because I write scripts to do anything and everything for me if I have to do it more than once I script it. If I think something...

March 30, 2009  9:41 PM

Changing Perfstat Job

Colin Smith Colin Smith Profile: Colin Smith

I got a question about how I would change the Prefstat Statspack job in Oracle to run at 15 minute increments during the day when OLTP transactions are occurring and then change it to run only onve every hour during off hours while batch is running. Since the user already had the PL\SQL to change...

March 26, 2009  5:20 PM

Free Space or Mount Points

Colin Smith Colin Smith Profile: Colin Smith

I had a question about getting free space of mount points on a windows server. The user had some Exchange servers with a huge chunk of san disk attached. Then he mounted drive letters into empty folders on that disk. This gave him multiple mount points on that one volume. Now he wants to be able to...

March 25, 2009  6:08 PM

Interview Update

Colin Smith Colin Smith Profile: Colin Smith

I had told you that I had an interview with a company here in the valley and I just wanted to let you know what happened with that. The job description online talked about Windows and Exchange Administration. The title was Network Analyst and that sounded strange to me. The title did not fit the...

March 25, 2009  6:01 PM

Customer Service Rant Cont.

Colin Smith Colin Smith Profile: Colin Smith

Back on the 17th I posted a rant about customer service. I was having a problem with a warranty company. I am not going to name the company or the Electronics store that sold me the warranty. After that...

March 19, 2009  4:25 PM


Colin Smith Colin Smith Profile: Colin Smith

Everyone, I was just informed about a great contest that ITKE is doing for some free Xbox systems. They are literally handing out three systems. Please check this out, get involved with the community here, show off your skills and get some free bling. Even if you have an Xbox or do not play...

March 19, 2009  2:37 PM

Oracle Upgrade Cont.

Colin Smith Colin Smith Profile: Colin Smith

I have completed the Oracle Upgrade on our test system and then rolled back to Oracle 9 and upgraded the DB again to This process was pretty straightforward. The company whose application uses this Database has some useful tools to utilize during the upgrade process. One gives you the...

March 18, 2009  7:58 PM

Powershell VS VBScript

Colin Smith Colin Smith Profile: Colin Smith

My wife works for a large company as an accountant for a company here in Phoenix and she called me one day asking if I could put a script together that would do some file manipulation and combine multiple files into one. I said no problem. You tell me what you need and I can do it in Powershell....

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: