Re: Deleting old job run entries in OEM 10g

From: Ravi Madabhushanam <ravi.madabhushanam_at_gmail.com>
Date: Wed, 24 May 2006 06:53:17 +0530
Message-ID: <f2f282d10605231823x49aff88bxca8ae21b5ea53c0c@mail.gmail.com>

Hi ,
Thank you very much for your response.
I have few doubts in your script.
1. how would i know the OEM version of my repository. the databases i'm monitoring are of 10g. and the db version is 9.0.1.5 2. regarding the tables you have mentioned , are they from sysman schema or any thing else.
actually i haven't found the tables u have mentioned in dba_objects. 1* select object_name,owner from dba_objects where object_name like 'SMP%' SQL> /

OBJECT_NAME                    OWNER


------------------------------ ------------------------------

SMP_EMD_AVAIL_OBJ              SYSMAN
SMP_EMD_COL_DEF                SYSMAN
SMP_EMD_COL_DEF_ARRAY          SYSMAN
SMP_EMD_COL_DEF_ARRAY_ARRAY    SYSMAN
SMP_EMD_DBSITEMAP_OBJ          SYSMAN
SMP_EMD_DELETE_REC             SYSMAN
SMP_EMD_DELETE_REC_ARRAY       SYSMAN
SMP_EMD_DISK_OBJ               SYSMAN
SMP_EMD_EMAIL_DATA             SYSMAN
SMP_EMD_ERR_MSGS               SYSMAN
SMP_EMD_GATEWAYS_DATA          SYSMAN

SMP_EMD_GATEWAY_DATA           SYSMAN
SMP_EMD_HOST_CONFIG_OBJ        SYSMAN
SMP_EMD_INDX_NVPAIR            SYSMAN
SMP_EMD_INDX_NVPAIR_ARRAY      SYSMAN
SMP_EMD_INTEGER_ARRAY          SYSMAN
SMP_EMD_INTEGER_ARRAY_ARRAY    SYSMAN
SMP_EMD_KEY_DETAIL_ARRAY       SYSMAN
SMP_EMD_KEY_DETAIL_OBJ         SYSMAN
SMP_EMD_LOAD_OBJ               SYSMAN
SMP_EMD_LSNR_GEN_STATUS_OBJ    SYSMAN
SMP_EMD_LSNR_LOAD_RESP_OBJ     SYSMAN

SMP_EMD_MEMORY_OBJ             SYSMAN
SMP_EMD_NOTIFICATION           SYSMAN
SMP_EMD_NVPAIR                 SYSMAN
SMP_EMD_NVPAIR_ARRAY           SYSMAN
SMP_EMD_OSMSITEMAP_OBJ         SYSMAN
SMP_EMD_PAGING_OBJ             SYSMAN
SMP_EMD_RULE_DESCRIPTION       SYSMAN
SMP_EMD_RULE_DESCRIPTIONS      SYSMAN
SMP_EMD_RULE_METRIC            SYSMAN
SMP_EMD_RULE_METRICS           SYSMAN
SMP_EMD_RULE_TARGET            SYSMAN

SMP_EMD_RULE_TARGETS           SYSMAN
SMP_EMD_STRING_ARRAY           SYSMAN
SMP_EMD_STRING_ARRAY_ARRAY     SYSMAN
SMP_EMD_TARGET_OBJ             SYSMAN
SMP_EMD_TARGET_OBJ_ARRAY       SYSMAN
SMP_EMD_TARGET_REC             SYSMAN
SMP_EMD_TARGET_REC_ARRAY       SYSMAN
SMP_EMD_TIME_SERIES_ARRAY      SYSMAN
SMP_EMD_TIME_SERIES_OBJ        SYSMAN
SMP_EMD_TOP_PROCS_ARRAY        SYSMAN
SMP_EMD_TOP_PROCS_OBJ          SYSMAN

44 rows selected.

are there any oracle supplied packages related to OEM. i couldn't find any information of the same in docs. please direct to some resources regarding this.

Thanks,

Ravi.M
--

http://www.freelists.org/webpage/oracle-l Received on Tue May 23 2006 - 20:23:17 CDT