Previous Topic: Method: SET_STATS_RLSNext Topic: Method: ENABLE_DEBUG

Database Statistics Reference Guide › Package Detail › Methods › Method: LOCK_STATS

Method: LOCK_STATS

Locks or unlocks statistics on all temporary tables that start with the prefix 'TMP' and all permanent tables that start with the prefix 'WGN'.

The Boolean argument p_lock is False to unlock the statistics and True to lock them.

PROCEDURE LOCK_STATS(p_lock in Boolean);