JamesKoopmann.com header image 4

Entries from September 2007

VBScript for Sending Email

September 26th, 2007 · No Comments

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 →]

Tags: Oracle

Oracle 10g 11g on Enterprise Linux - watch out!

September 25th, 2007 · No Comments

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 →]

Tags: Oracle

Oracle Performance Diagnostic Guide

September 20th, 2007 · 3 Comments

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 →]

Tags: Oracle