The Multifunctioning DBA:

Database Administration


March 30, 2009  9:41 PM

Changing Perfstat Job



Posted by: Colin Smith
Database, Database Administration, Oracle, Perfstat, Statspack

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 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...


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: