Rem drv: <create type="post_creation" params="EM_REPOS_USER" pos="basic/basic_post_creation.sql-"/>
Rem
Rem $Header: admin_post_creation.sql 14-jul-2005.02:04:23 gsbhatia Exp $
Rem
Rem admin_post_creation.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      admin_post_creation.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    scgrover    07/07/05 - add extended sql trace 
Rem    gsbhatia    07/03/05 - New repmgr header impl 
Rem    jsadras     06/22/05 - add pin plsql 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    scgrover    01/10/05 - add compress index logging cat 
Rem    rzazueta    10/29/03 - Add register_loggin_module call 
Rem    rpinnama    07/11/03 - Move setting versions to end of creation
Rem    edemembe    07/01/03 - Adding partition support
Rem    rpinnama    02/27/03 - Get repository user name
Rem    rpinnama    03/17/03 - DBMS job submission moved to admin_dbms_jobs
Rem    rpatti      02/12/03 - change rep. to the correct version
Rem    sgrover     01/23/03 - remove rebuild entries
Rem    sgrover     01/20/03 - fix analyze
Rem    sgrover     01/14/03 - change 1 day time
Rem    sgrover     01/10/03 - add tables to rebuild
Rem    rpinnama    10/18/02 - add loggign modules
Rem    rpinnama    10/15/02 - Fix register_logging_module API
Rem    rpinnama    10/14/02 - Use log registration API
Rem    mbhoopat    09/26/02 - Add version entry for core
Rem    aholser     05/31/02 - create performance name entry.
Rem    rpinnama    05/16/02 - rpinnama_reorg_rep_scripts_2
Rem    rpinnama    05/16/02 - Created
Rem


Rem
Rem  Default index rebuild schedule
Rem

INSERT INTO MGMT_REBUILD_INDEXES (table_name, interval, table_type)
VALUES ('MGMT_SYSTEM_PERFORMANCE_LOG', 30, NULL);

COMMIT;

--
-- Submit job to analyze the tables once a day at 3:10am.
--
REM  Submit job to analyze the tables once a day.
BEGIN
  mgmt_log.register_logging_module ('MAINT','General Maintenance');

  mgmt_log.register_logging_module ('MAINT SCHEMA ANALYSIS','EM Schema Analysis');

  mgmt_log.register_logging_module ('MAINT INDEX REBUILDS','EM Index Rebuilds');

  mgmt_log.register_logging_module ('MAINT COLLECT SEG SIZES','Collect Segment Sizes');

  mgmt_log.register_logging_module ('MAINT EXEC DBMS JOB PROCS','Execute DBMS Job Processes');

  mgmt_log.register_logging_module ('ANALYZE',
                                    'Maintenance (Analysis)',
                                    'emd_maintenance.analyze_emd_schema');

  mgmt_log.register_logging_module ('MAINT PIN PLSQL','EM Pin PL/SQL Blocks');
  
  mgmt_log.register_logging_module ('ANALYZE OBJECTS WITHOUT STATS',
                                    'Maintenance (Analysis), Objects without Statistics') ;

  COMMIT;
END;
/

@@&&EM_SQL_ROOT/core/v102020/admin_data_upgrade.sql