How to Export and Import Database Statistics

Step by Step Export of Database Statistics


1. Log onto the database



sqlplus '/ as sysdba'

2. Create a table to hold the exported statistics.



SQL> exec DBMS_STATS.CREATE_STAT_TABLE('','','
For example; exec DBMS_STATS.CREATE_STAT_TABLE('MYUSER','MYSTATSTABLE','MYTABLESPACE');



3. Export the database statistics



SQL> exec dbms_stats.EXPORT_DATABASE_STATS('','','');

For example; exec dbms_stats.EXPORT_DATABASE_STATS('MYSTATSTABLE','MYRELEASE2','MYUSER');



Step by Step Import of Database Statistics

1. Log onto the database



sqlplus '/ as sysdba'

2. Import the database statistics



SQL> exec dbms_stats.IMPORT_DATABASE_STATS('','','');

For example; exec dbms_stats.IMPORT_DATABASE_STATS('MYSTATSTABLE','MYRELEASE2','MYUSER');