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
3 Things You Want To Know About SET FEEDBACK Command
August 29, 2018If you ever wrote an SQL script, then you are familiar with the SET FEEDBACK SQLPlus command. What most of… Continue Reading
How To Drop Database Links In Another Schema
August 22, 2018You know that you cannot drop a database link in a different schema, by prefixing the database link with the… Continue Reading
18c Up And Running In 30 Minutes
August 8, 2018The fact that 18c is available on prem is old news already. You might have thought to install 18c and… Continue Reading
18c Available On Premises. What’s The Next Step?
July 25, 2018Summer is on. Some of you might be on vacation, some of you might be working. DBAParadise took some time… Continue Reading
Which Histogram Will Oracle Pick?
June 13, 2018Have you ever wondered how does Oracle determine what type of histograms to create? As of 12c there are 4… Continue Reading
Intro To Histograms. Three Basic Questions Answered.
June 6, 2018As a DBA, one day or another you will come across histograms. Either you will need to implement/delete/gather histograms to… Continue Reading