Skip to content
December 18, 2015 / doganay

RESTORE TABLE STATICTICS USING ASOF

exec DBMS_STATS.UNLOCK_TABLE_STATS  (ownname=>'OWNER1', tabname=>'TABLE1');
exec DBMS_STATS.RESTORE_TABLE_STATS (ownname=>'OWNER1', tabname=>'TABLE1',
                                     as_of_timestamp=>TO_TIMESTAMP('18.12.2015 10:54:00.000000','dd.mm.yyyy hh24:mi:ss.ff'));
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: