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
The place where DBAs grow
Did you ever get an email or a phone call from a developer telling you they are getting an error… Continue Reading
Last week I asked the question: “What do you do with the AWR data?” Here are some of the responses… Continue Reading
How do you use your AWR data or Statspack data? Do you retain it longer than the default retention? Do… Continue Reading
While investigating a performance problem, have you ever wondered why a parent cursor has many child cursors associated with it?… Continue Reading
If you ever wrote an SQL script, then you are familiar with the SET FEEDBACK SQLPlus command. What most of… Continue Reading
You know that you cannot drop a database link in a different schema, by prefixing the database link with the… Continue Reading
The fact that 18c is available on prem is old news already. You might have thought to install 18c and… Continue Reading
Summer is on. Some of you might be on vacation, some of you might be working. DBAParadise took some time… Continue Reading
Have you ever wondered how does Oracle determine what type of histograms to create? As of 12c there are 4… Continue Reading