My Oracle Support Banner

Statistics Best Practices: How to Backup and Restore Statistics (Doc ID 464939.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document provides simplified instructions on how to backup statistics so they can be restored in future.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Backup Optimizer Statistics
 Checklist
 1. Create a statistics table in the <OWNER> schema
 2a. Transfer the statistics to this table
 Transferring statistics from multiple tables
 Transferring statistics for a complete user schema
 2b. Transfer SYSTEM statistics to this table
 Transferring SYSTEM statistics
 Gather new statistics
 Restore statistics
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.