Rem
Rem $Header: cmpupend.sql 24-apr-2007.18:58:45 cdilling Exp $
Rem
Rem cmpupend.sql
Rem
Rem Copyright (c) 2006, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      cmpupend.sql - CoMPonent UPgrade END script
Rem
Rem    DESCRIPTION
Rem      Final component upgrade actions
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    cdilling    04/18/07 - add timestamp for gather_stats
Rem    rburns      12/07/06 - move gather_stats
Rem    cdilling    12/14/06 - add RDBMS identifier
Rem    rburns      07/19/06 - move final actions to catupend.sql 
Rem    rburns      05/22/06 - parallel upgrade 
Rem    rburns      05/22/06 - Created
Rem

set serveroutput off
set errorlogging on identifier 'STATS';

Rem =====================================================================
Rem Collect optimizer stats for all SERVER component schemas
Rem =====================================================================

SELECT dbms_registry_sys.time_stamp('STATS_BGN') as timestamp from dual;

execute dbms_registry_sys.gather_stats(null);