When does the operating system timestamp of the Oracle datafile get updated ? Normally, it is seen to happen at instance shutdown, but can it happen in between when the instance is running ? Under what conditions ?
The OS timestamp does not change every time the DBWR process writes to the datafile in Windows NT - when does the timestamp actually change in a Windows NT environment ?
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…