SQL Performance (MOSC)

MOSC Banner

Lock Schema Statistics

edited Feb 16, 2017 11:59AM in SQL Performance (MOSC) 4 commentsAnswered

When i lock a gather schema statistics with "dbms_stats.lock_schema_stats"... where or how can i see that the schema is locked (and not that the tables are locked, that is done by the sql below)?

This is for tables:

select owner, table_name, stattype_locked

from dba_tab_statistics

where stattype_locked is not null;

What about Schema? How can i know that was because a schema lock and not because a table lock?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center