Re: Deleting old job run entries in OEM 10g

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


Other related posts: