Statspack in Brief
Database Statistics Statspack is different from BSTAT/ESTAT Statspack collects more data, including high-resource SQL It precalculates many ratios such as cache hit ratios, rates and transaction statistics It uses permanent tables owned by PERFSTAT user to store performance stats It separates data collection from report generation It makes data collection easy to automate using either…