Re: Deleting old job run entries in OEM 10g
- From: "Ravi Madabhushanam" <ravi.madabhushanam@xxxxxxxxx>
- To: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 24 May 2006 06:53:17 +0530
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
