SQL Performance (MOSC)

MOSC Banner

DBMS_STATS.GATHER what happend if kill the process?

edited Jun 3, 2014 9:54AM in SQL Performance (MOSC) 7 commentsAnswered

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

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