Speeding-up Export/Import schema stats

From: Deepak Sharma <"Deepak>
Date: Tue, 19 Jul 2016 06:17:34 +0000 (UTC)
Message-ID: <771769026.1538459.1468909054251.JavaMail.yahoo_at_mail.yahoo.com>

Since parallel is not an option in the export_schema_stats or import_schema_stats proc, what could be other ways to speed it up?  DB version is 11.2.0.4, btw.

Using something as below had no effect on the job - it didn't go parallel. Guessing that DEGREE applies to gather rather than export stats.

DECLARE
        p_user varchar2(32);
BEGIN

        p_user := 'TEST';
        DBMS_STATS.SET_SCHEMA_PREFS(p_user, 'DEGREE','6');
        DBMS_STATS.EXPORT_SCHEMA_STATS(p_user,'STATS_TABLE',NULL,p_user);

END; Just some additional info; as per trace, most of the waits during export phase are "db file sequential read" on "HISTGRM$"

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 19 2016 - 08:17:34 CEST