How To Get Historical Row Count In a Table?
March 12, 2022Have you been in a situation where you had to prove the row count in a table has changed or… Continue Reading
Tag: dbms_stats
Online Stats in Action
November 26, 2020In my last blog post I introduced you to Online Stats and Real Time Stats.Today I will show you, in… Continue Reading
Online Stats vs Real-time Stats
November 12, 2020Are you aware of these new terminologies, real-time stats and online stats? Or are these new to you? Maybe you… Continue Reading
Two Occupants That Affect The Most SYSAUX Tablespace Size
July 25, 2020Is you SYSAUX tablespace running out of space? Are you wondering what is causing the tablespace growth? Normally you would… Continue Reading
How To Compare Current Stats With Stats From History?
November 29, 2017Imagine this. You get a call. A specific SQL statement is running slow today, and the statement was running fine… Continue Reading
4 Things To Know About Statistics History
November 22, 2017By default, whenever new statistics are gathered in the database, the existing statistics are backed up in the data dictionary.… Continue Reading
What Type Of Stats To Gather (Bonus Script)
November 15, 2017How do you gather statistics in your database? Do you gather statistics randomly when you remember, or do you gather… Continue Reading
How Are Statistics Gathered In The Database?
November 8, 2017Do you gather statistics regularly for your databases? Do you gather statistics explicitly, with your own script, or do you… Continue Reading