DBMS_STATS.GATHER spend long time processing?
Experts in DBA:
I submit this query on sql developer, but as processing was taken/spending long time I kill process, ..could it commited any percent in the database?
query:
begin DBMS_STATS.GATHER_SCHEMA_STATS (ownname =>
'proddta',estimate_percent => 1);end;
SELECT tablespace_name, table_name, num_rows FROM user_tables
ORDER BY num_rows desc, table_name;
great thanks