CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

DBMS_STATS.GATHER spend long time processing?

edited May 30, 2014 3:59AM in CNC, DB and Operating System - JDE1 (MOSC) 6 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