Oracle on Windows and Password Expiry

If you are running Oracle on Windows and are using a Windows domain account subject to password expiry you need to remember a few follow up tasks after your password has been changed.

• Make sure any Windows scheduled tasks have the new password. You should only need to change one scheduled task and all get the change
• Go into EM/DBConsole preferences and enter the new password for each preferred credential. This includes the Listener, Host, Database Instance, and Agent.

ClearTrace

Saw an interesting article on this tool that runs  top of SQL Profiler. It aggregates trace data for easier analysis.

http://www.scalesql.com/cleartrace/download.aspx