Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\log\log_indexes.sql
Rem drv: <create type="indexes"/> Rem Rem $Header: log_indexes.sql 29-jun-2005.01:48:27 gsbhatia Exp $ Rem Rem log_indexes.sql Rem Rem Copyright (c) 2002, 2005, Oracle. All rights reserved. Rem Rem NAME Rem log_indexes.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 gsbhatia 06/26/05 - New repmgr header impl Rem jsadras 05/02/05 - add index on time Rem gsbhatia 02/13/05 - updating repmgr header Rem gsbhatia 02/09/05 - updating repmgr header Rem gsbhatia 02/07/05 - updating repmgr header Rem scgrover 02/01/05 - compress indexes Rem ktlaw 01/11/05 - add repmgr header Rem aholser 10/15/03 - add err index Rem aholser 06/09/03 - rearrange index Rem edemembe 10/14/02 - edemembe_add_perf_scripts_020918 Rem edemembe 10/09/02 - Rem edemembe 09/20/02 - Created Rem rem rem Indexes for MGMT_SYSTEM_ERROR_LOG rem CREATE INDEX MGMT_SYSTEM_ERROR_LOG_01 ON MGMT_SYSTEM_ERROR_LOG (module_name, log_level, occur_date) COMPRESS 2; rem rem Indexes for MGMT_SYSTEM_PERFORMANCE_LOG rem CREATE INDEX MGMT_SYSTEM_PERF_LOG_IDX_01 ON MGMT_SYSTEM_PERFORMANCE_LOG (job_name, time, name) COMPRESS 3; rem rem Indexes for MGMT_SYSTEM_PERFORMANCE_LOG rem CREATE INDEX MGMT_SYSTEM_PERF_LOG_IDX_02 ON MGMT_SYSTEM_PERFORMANCE_LOG (time) ;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de