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
Tag: stats
Gather Stats: The Script That Keeps Your Users Happy
October 30, 2014How can a script keep the users of the database happy? Well, up-to-date stats on the database=good performance, and the reverse… Continue Reading
Gather Stats – All The Information You Need To Know At First
October 22, 2014What information related to statistics do you need to know when you look at the database. Below are the questions… Continue Reading
Gather Stats – The Job That Keeps Stats Up-To-Date
October 16, 2014What are optimizer statistics, which one is the default statistics collection job, how do I disable it and why would… Continue Reading