How To Export The AWR Repository
Published: Thu, 09/27/18
Last week I asked the question: “What do you do with the AWR data?”Here are some of the responses I received:Some DBAs leave the AWR data to age out…
Diana Robete
database advise, step by step guides, how to emails
What Do You Do With The AWR Data?
Published: Thu, 09/20/18
How do you use your AWR data or Statspack data? Do you retain it longer than the default retention? Do you save it somewhere else? Do you review it…
Why The Child Cursor Is Not Reused: ROLL_INVALID_MISMATCH
Published: Thu, 09/06/18
While investigating a performance problem, have you ever wondered why a parent cursor has many child cursors associated with it?This was me last…
3 Things You Want To Know About SET FEEDBACK Command
Published: Thu, 08/30/18
If you ever wrote an SQL script, then you are familiar with the SET FEEDBACK SQLPlus command.What most of us use this command for is, to set it to the…
How To Drop Database Links In Another Schema
Published: Thu, 08/23/18
You know that you cannot drop a database link in a different schema, by prefi ing the database link with the owner’s name.Which means the following…
18c Up And Running In 30 Minutes
Published: Thu, 08/09/18
The fact that 18c is available on prem is old news already. You might have thought to install 18c and start discovering the new capabilities.And then,…
18c Available On Premises. What’s The Next Step?
Published: Thu, 07/26/18
Summer is on. Some of you might be on vacation, some of you might be working. DBAParadise took some time off, to recharge the batteries, and now is…
Which Histogram Will Oracle Pick?
Published: Thu, 06/14/18
Have you ever wondered how does Oracle determine what type of histograms to create?As of 12c there are 4 types of histograms. Are you familiar with…
Intro To Histograms. Three Basic Questions Answered.
Published: Thu, 06/07/18
As a DBA, one day or another you will come across histograms.Either you will need to implement/delete/gather histograms to fi a performance…
What Is Index Clustering Factor?
Published: Thu, 05/31/18
Have you heard other DBAs talking about the clustering factor of an inde, and saying that if the clustering factor is a certain value or percentage,…