How to find the table where statistics are locked in Oracle

Statistics played in key role in Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the Oracle table involved in the SQL queries. You may want to lock statistics in an Oracle table in some cases, for example There could be many more cases where we want to lock statistics …

How to find the table where statistics are locked in Oracle Read More »