simple Q on dbms_stat ...does it lock a table ?? or no ??
does dbms_gather stats used for gather stats on a table or schema level locks the table or schema ??? or can things be queryed against emp table when running the cmd....lets just say we have over 10 million rows on emp table...
usin the followin cmd..
sql> execute DBMS_STATS.GATHER_TABLE_STATS('SCOTT','EMP');
any links for the info would be great as well...
Edited by: user630084 on Jan 23, 2009 4:53 PM