Skip to Content
0
Jun 17, 2009 at 09:08 PM

List of Statistics Locked Tables ?

1056 Views

Hi ...Experts...

we locked few tables statistics for some NOTE implmentation.

We have locked using the below commands for your quicker understanding.

EX----


Commands we used to lock

execute DBMS_STATS.UNLOCK_TABLE_STATS('SAPP10','FAGLFLEXA');

Command we used to unlock

execute DBMS_STATS.LOCK_TABLE_STATS('SAPP10','FAGLFLEXA');

EX----


Requirement :

We want to know complete list of tables in the system for which statitics are locked?

Can we get this info any how ??

Rgds