DBMS_STATS.GATHER what happend if kill the process?
Experts in DBA:
My scenario: submit this query on sql developer, but as processing was taken/spending long time I kill process
My question: could it commited any percent in the database?, ..as I kill the process I want to know if change something on DB
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