Now I know of us out there have Oracle running on Windows servers. One of the problems I have often been asked is how to do tasks on a Window’s Server but then email results or logs. Well here is a very simple script that can help you out. This script does require you to [...]

[Read more →]

As you all know, thecheapdba has been running Oracle’s Enterprise Linux (with support).
A little while ago I decided to install Oracle 11g. My Enterprise Linux system was running Oracle 10g and so I decided to remove my 10g instance in start up an 11g instance. All of this went along just fine. Well, yesterday I [...]

[Read more →]

I came across a nice little tool today out on metalink.oracle.com entitled “Oracle Performance Diagnostic Guide”. This little gem will walk you through Query Tunning, Hang/Locking issues, and a Slow Database. There is a wealth of information here if you are not familiar with these issues.

The specifics to find on metalink.oracle.com:
Subject: Oracle Performance Diagnostic [...]

[Read more →]