Who Is Holding The Lock On The Table?
October 10, 2018Did you ever get an email or a phone call from a developer telling you they are getting an error… Continue Reading
Tag: DBA
What Can You Use DBMS_UTILITY.EXPAND_SQL_TEXT For?
October 3, 2018Have you ever worked through a tuning exercise (I’d like to call them exercises instead of problems), where the SQL… Continue Reading
How To Export The AWR Repository
September 26, 2018Last week I asked the question: “What do you do with the AWR data?” Here are some of the responses… Continue Reading
What Do You Do With The AWR Data?
September 19, 2018How do you use your AWR data or Statspack data? Do you retain it longer than the default retention? Do… Continue Reading
Why The Child Cursor Is Not Reused: ROLL_INVALID_MISMATCH
September 5, 2018While investigating a performance problem, have you ever wondered why a parent cursor has many child cursors associated with it?… Continue Reading
Display Any Execution Plan With Ease
April 11, 2018Ever wondered how to display the execution plan of a SQL Statement quickly? Are you dreading the question “What is… Continue Reading
What Should You Do With SQL Plan Directive Changes in 12.1?
March 14, 2018Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used… Continue Reading
What Are SQL Plan Directives?
March 7, 2018If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading
What Is The Relationship Between SCNs and DB Links?
January 24, 2018Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised… Continue Reading
So You Think You Can Gather Stats?
December 6, 2017I have covered lots of topics on Oracle Optimizer Statistics. I’d like to summarize everything you learned, or reviewed in… Continue Reading