Rem drv:
Rem
Rem $Header: trace_post_creation.sql 03-aug-2006.23:02:29 sthiruna Exp $
Rem
Rem trace_post_creation.sql
Rem
Rem Copyright (c) 2004, 2006, Oracle. All rights reserved.
Rem
Rem NAME
Rem trace_post_creation.sql -
Rem
Rem DESCRIPTION
Rem
Rem
Rem NOTES
Rem
Rem
Rem MODIFIED (MM/DD/YY)
Rem sthiruna 07/31/06 - Copying 10.2.0.3 Config Standard changes from
Rem EMCORE_MAIN_LINUX
Rem niramach 02/27/06 - Add create context for Compliance evaluation .
Rem rmarripa 08/18/05 - disable logging by default
Rem dsahrawa 08/17/05 - add jobs context
Rem gsbhatia 07/03/05 - New repmgr header impl
Rem jsadras 03/04/05 - add purge policy
Rem skini 01/20/05 - Add context for blackouts
Rem snakai 01/10/05 - add SVCTESTAVAIL context
Rem ktlaw 01/11/05 - add repmgr header
Rem jsadras 08/17/04 - add repocollection
Rem jsadras 02/26/04 - jsadras_trace_create
Rem jsadras 02/26/04 - Seed Data
Rem jsadras 02/26/04 - Created
Rem
prompt Inserting seed data
BEGIN
emdw_log.create_context('DEFAULT') ;
emdw_log.create_context('TRACER') ;
emdw_log.create_context('LOADER') ;
emdw_log.create_context('NOTIFICATION') ;
emdw_log.create_context('REPOCOLLECTION') ;
emdw_log.create_context(MGMT_JOB_ENGINE.MODULE_NAME);
emdw_log.create_context(MGMT_BLACKOUT_ENGINE.MODULE_NAME);
emdw_log.create_context(MGMT_GENSVC_AVAIL.EMDW_LOG_CTX) ;
emdw_log.create_context(MGMT_CONFIG_STD.G_EMDW_LOG_CTX) ;
COMMIT ;
END ;
/
BEGIN
EM_PURGE.add_purge_policy('EMDW_TRACE',
EM_PURGE.G_POLICY_TYPE_SYSTEM,
'EMDW_LOG.PURGE',
24,
NULL, -- No rollup procedure
'Purge policy for trace data',
EM_PURGE.G_RETENTION_GROUP_SYSTEM,
EM_PURGE.G_POLICY_EXEC_GROUP_DEFAULT,
EM_PURGE.G_POLICY_NOT_CONFIGURABLE
);
END ;
/