DBA Hub

📋Steps in this guide1/1

Lock/unlock statistics

--- Lock  statistics

oracle configurationintermediate
by OracleDba
17 views
1

Lock/unlock statistics

--- Lock  statistics -- Unlock statistics --- check stats status:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
EXEC DBMS_STATS.lock_schema_stats('SCOTT');
EXEC DBMS_STATS.lock_table_stats('SCOTT', 'TEST');
EXEC DBMS_STATS.lock_partition_stats('SCOTT', 'TEST', 'TEST_JAN2016');
EXEC DBMS_STATS.unlock_schema_stats('SCOTT');
EXEC DBMS_STATS.unlock_table_stats('SCOTT', 'TEST');
EXEC DBMS_STATS.unlock_partition_stats('SCOTT', 'TEST', 'TEST_JAN2016');
SELECT stattype_locked FROM dba_tab_statistics WHERE table_name = 'TEST' and owner = 'SCOTT';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!