Ravi,
Sorry for me jumping in a little late (I'm about 2140 emails behind on
this list), but we use the following to cleanup job history after 2
weeks:
EXEC dbms_oem.PurgeJobs(sysdate - 14, 0);
A similar procedure is used for Event history:
EXEC dbms_oem.PurgeEvents(sysdate - 14, 0);
See metalink note 199479.1 for more details.
HTH!
Dave
-------------------------------------
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri@(protected)>
-------------------------------------
"When I come home from work and see those little noses pressed against
the windowpane, then I know I am a success" - Paul Faulkner
> -----Original Message-----
> From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]
> On Behalf Of Ravi Madabhushanam
> Sent: Tuesday, May 23, 2006 8:23 PM
> To: Reardon, Bruce (CALBBAY); Oracle-L@(protected)
> Subject: 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
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank You.
****************************************************************************
--
http://www.freelists.org/webpage/oracle-l
