Database Tuning (MOSC)

MOSC Banner

best practice to update statistics Data warehouse

RDBMS 12c Rac

Hello

I would like to know what is the best way to gather statistics is a data Warehouse database some tables are static others no, currently we gather stats using the following command, however takes a very long time:


set timing on

set serveroutput on

begin

DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>NULL,estimate_percent=>95, cascade=>TRUE);

end;

/

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