Database Tuning (MOSC)

MOSC Banner

need clarifiaction stats transferred

edited Jul 4, 2013 9:38PM in Database Tuning (MOSC) 2 commentsAnswered ✓
 Hi All,
how to identify if the statistics transferred from one schema to another are consistent ?

i used the below method to transfer stats but still i can see the last analyzed column of the tables in imported schema has the old value,

Version : 11.2.0.3
O/S: Linux 

EXEC DBMS_STATS.CREATE_STAT_TABLE ( 'user2','TEST');

EXEC DBMS_STATS.EXPORT_SCHEMA_STATS ( 'user2','TEST');

export and import of table TEST from user2 to user1,

SQL> conn user1/*****
Connected.


SQL> UPDATE TEST SET c5 = 'user1';

9588918 rows updated.

SQL> commit;

Commit complete.

SQL> EXEC DBMS_STATS.IMPORT_SCHEMA_STATS ( 'user1', 'TEST' );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center