Bu Blogda Ara

10 Mayıs 2012 Perşembe

Lock and Unlock table statistics


--Control stats lock type of table.
SELECT stattype_locked FROM dba_tab_statistics WHERE table_name = 'WRR$_REPLAY_UC_GRAPH_EXT' and owner = 'SYS';

--lock statistics
exec dbms_stats.lock_table_stats('SYS', 'WRR$_REPLAY_UC_GRAPH_EXT');

--unlock statistics
exec dbms_stats.unlock_table_stats('SYS', 'WRR$_REPLAY_UC_GRAPH_EXT');

Hiç yorum yok:

Yorum Gönderme