The Multifunctioning DBA:

Oracle


March 19, 2009  2:37 PM

Oracle Upgrade Cont.



Posted by: Colin Smith
Database, Database Administration, Oracle

I have completed the Oracle Upgrade on our test system and then rolled back to Oracle 9 and upgraded the DB again to 10.2.0.4. 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...

February 27, 2009  2:34 PM

Oracle Upgrade



Posted by: Colin Smith
Database, Database Administration, Oracle

I did my Oracle upgraded yesterday and overall I think that it went pretty well. We are still testing but so far so good. The process was not too bad. First you need to create a new $ORACLE_HOME as two Oracle installations can not be in the same $ORACLE_HOME. Then install the media. I did run into...


February 25, 2009  4:58 PM

Oracle Upgrade



Posted by: Colin Smith
Database, Database Administration, Oracle

It looks like I might get the chance to upgrade one of our Test oracle systems today. I will be moving from 9.2.0 to 10.2. This should be interesting as I am still pretty new to Unix and to Oracle. I am looking forward to this and it really looks pretty straight forward. Looks like I will have to...


February 2, 2009  4:18 PM

Oracle Statspack Help



Posted by: Colin Smith
Database, Oracle, Statspack

Recently I received an email from Ram. It said the following:

I am ram,I have a question regarding development DBA.I need to Optimize SQL and...


January 22, 2009  5:24 PM

Putty Connection Manager Tool



Posted by: Colin Smith
Linux, Oracle, Sybase, Unix

If you are working in Unix or Linux you are most likely using some tool to connect via ssh to that server for your session. Putty is a free tool that manages this very nicely. Many of you are already using Putty I am sure. If you are I did find a Putty Connection Manager that is really very nice....


October 21, 2008  8:54 PM

Modify Perfstat Statspack Job in Oracle 920



Posted by: Colin Smith
Database, DBA, Oracle

Today I was tasked to change the statspack job to get a snapshot every 15 minutes instead of once every hour. These statspack snapshots are something that Oracle does in order for a DBA to look at historical performance data. The idea in making this change is that a lot can change in one hour so we...


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: