statistics ⁽²⁾

If you have a database where querying against v$ Performance views is painful, consider gathering Fixed Object Stats. Fixed objects are the 700+ X$ tables that feed a lot of these system and performance views. Fixed Object Stats are _not_ gathered by the default stats…

Ever had a customer asking about the growth of a table? Or suspect an execution plan change might be because of an influx of data into a table? Well you are in luck (maybe!). Oracle 10g and 11g have a months worth of historical statistics…