In the last blog post, How To Find the SQL_ID of a SQL Statement, we talked about finding the SQL_ID of statements that were run in the past, or by other users. Today I’ll show you two tricks to get …
Have you ever been in a situation where a user comes to you and says “My report is running slow” or “My query used to run fast, and now it’s slow”? If you are a DBA, you most likely have! …
For most tuning exercises, the tuning happens at the SQL Statement level. When a user complains about a report being slow, you as a DBA, have to first identify the SQL Statement and then the execution plan. Today’s post is …