Monthly Archives: September 2008

Truncate to half hour intervals.

A client wanted a trigger on a table to monitor the inserts performed in half hour formats. They wanted to run a counter rather than a full table recording the inserts, though the other means would have been simpler. Here’s … Continue reading

Posted in Oracle | Tagged , , , , , , , , , , , , , , , , , , , | Comments Off

Using Mtail.

Mtail for windows is an excellent program to allow you to see the alert log (or others) in real time.

Posted in Oracle | Tagged , , , , , , , , , , , , , , , , | Comments Off

Oracle and Virus Scanners.

For those who have windows database’s crashing regularly, it could be something as simple as a virus scanner.

Posted in Oracle | Tagged , , , , , , , , , , , , , , , , , , , | Comments Off