RE: Deleting old job run entries in OEM 10g

One more thing - this is for a 9.2.0.6 OEM repository.

Dave
-------------------------------------
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri@xxxxxxxxxx>
-------------------------------------
 
"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: Herring Dave - dherri
> Sent: Monday, June 05, 2006 8:06 AM
> To: 'ravi.madabhushanam@xxxxxxxxx'; Reardon, Bruce (CALBBAY); Oracle-
> L@xxxxxxxxxxxxx
> Subject: RE: Deleting old job run entries in OEM 10g
> 
> 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@xxxxxxxxxx>
> -------------------------------------
> 
> "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@xxxxxxxxxxxxx [mailto:oracle-l-
> bounce@xxxxxxxxxxxxx]
> > On Behalf Of Ravi Madabhushanam
> > Sent: Tuesday, May 23, 2006 8:23 PM
> > To: Reardon, Bruce (CALBBAY); Oracle-L@xxxxxxxxxxxxx
> > 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


Other related posts: