We were in a situation very recently to run SQL Tuning Advisor against a bunch of SQL statements that appeared in the AWR’s ADDM recommendations report. The initial effort to launch SQL Tuning Advisor...
Why should you version your models?
By versioning your models that you have created with Toad® Data Modeler you can keep track of model changes just like you do with your application code. If you need...
Log file space/switch waits Log file space/switch waits occur when a redo log entry cannot be made. A redo log cannot be written to when: there is no free space in the redo log buffer, or
it is i...
