Unlock Statistic Document For Free

Answer: The only way to release a lock on an Oracle table is to kill the session that is holding the lock, or wait for the transaction to complete. See my related notes on finding Oracle locked_objects and killing_Oracle sessions.

DBMS_STATS provides a mechanism for you to view and modify optimizer statistics gathered for database objects. The statistics can reside in two different locations: The dictionary. A table created in the user's schema for this purpose.

Some time due to performance issues or on-demand business impact or auto-enable statistics by job scheduler or very rarely data changes in the table, we lock statistics on specific tables, in that case, we cannot execute gather statics on a table along with dependent objects of a table.

Do one of the following: To enable the automated task, execute the following PL/SQL block: BEGIN DBMS_AUTO_TASK_ADMIN.ENABLE ( client_name => 'auto optimizer stats collection' , operation => NULL , window_name => NULL ); END; / To disable the automated task, execute the following PL/SQL block:

To unlock statistics: Start SQL*Plus and connect to the database as the oe user. Unlock the statistics on oe. orders . For example, execute the following PL/SQL program: ... Connect to the database as the hr user. Unlock the statistics in the hr schema. For example, execute the following PL/SQL program:

So, the column ?stattype_locked? value is showing ?ALL?, that means statistics is locked for that table. Solution Description: The table statistics can be locked from the further update by using dbms_stats package. This will help to restrict from automatic statistics updation.

Unlock Objects On the Applications page, expand the application. From the Actions menu, to the right of the cube name, click Inspect. Select Locks. From the Display menu, select Objects. Select the object you want to unlock and click Unlock .