Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux. This is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

Advertisements

Effectively query your Oracle alert log via External Tables – Oracle 9i‏

There is nothing new about the concept of querying text files as "tables" using the Oracle External Tables functionality. Going further, a lot of you are probably already querying your Oracle alert log this way. If you did a quick search on Google, you will find tons of results on this subject but what you … Continue reading Effectively query your Oracle alert log via External Tables – Oracle 9i‏