Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deleting old job run entries in OEM 10g

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US