SQL Performance (MOSC)

MOSC Banner

DBMS_STATS.GATHER spend long time processing

edited Jun 6, 2014 12:00PM in SQL Performance (MOSC) 3 commentsAnswered

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

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