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: OEM Events

RE: OEM Events

From: Weaver, Walt <wweaver_at_rightnow.com>
Date: Tue, 15 Apr 2003 16:58:50 -0800
Message-ID: <F001.00582138.20030415165850@fatcity.com>


Or, present another 40gb from the EMC, leave the phone off the hook, and let everybody call Steve.

Works here. :>)

--Walt Weaver
  Bozeman, Montana

> -----Original Message-----
> From: Orr, Steve
> Sent: Tuesday, April 15, 2003 4:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OEM Events
>
>
> Yeah, see the "How to Stop Living and Start Defragmenting
> Files" whitepaper.
>
> -----Original Message-----
> Sent: Tuesday, April 15, 2003 3:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> why not just set autoextend on, throw a few more drives into
> the array,
> leave the phone off the hook and take a month off?
>
> :P
>
> Brad O.
>
> -----Original Message-----
> Sent: Tuesday, April 15, 2003 2:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I like to set all objects to maxextents unlimited.
>
> It's silly to crash an app because of some arbitrary limit
> that has little meaning. If you don't like that many extents,
> you can always fix it later.
>
> Beats having unplanned downtime. :)
>
> Jared
>
>
>
>
>
>
> Hemant K Chitale <hkchital_at_singnet.com.sg>
> Sent by: root_at_fatcity.com
> 04/15/2003 09:28 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: OEM Events
>
>
>
> Once a day is good enough if you have set the right thresholds --
> among the other monitoring scripts that I have are :
>
> tablespace with less than 20% free space on current datafile sizes
> [irrespective of the maxbytes of the datafile],
>
> segments with extents > 25% of max_extents [yes, this is a really low
> threshold]
>
> segments with next_extent > 25% of largest free extent in the
> tablespace.
>
> Run by custom SQL scripts, called by CRON from a monitoring server.
>
> Hemant
>
> At 11:19 AM 14-04-03 -0800, you wrote:
> >How often do YOU check these limits (tablespace utilisation, and "max
> >extents")?
> >
> >Once per day, somewhat less than every 10 minutes.
> >
> >Jared
> >
> >
> >
> >
> >
> >
> >"Mark Leith" <mark_at_cool-tools.co.uk>
> >Sent by: root_at_fatcity.com
> > 04/14/2003 08:53 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE: OEM Events
> >
> >
> >Sunny,
> >
> >There is a whitepaper that I found available from:
> >
> >www.csis.gvsu.edu/GeneralInfo/Oracle/em.920/a96675.pdf
> >
> >This is the "Oracle Enterprise Manager Event Test Reference Manual
> Release
> >9.2.0" document..
> >
> >I note two things in this document. For the "Tablespace
> Full" event, it's
> >"Recommended Frequency" is 30 seconds (!), though it
> contradicts itself
> by
> >saying:
> >
> >"Note: Running the Tablespace Full event test may be a
> resource-intensive
> >operation.
> >Therefore, Oracle recommends running the Tablespace Full event test
> during
> >off-peak periods."
> >
> >It says the same thing with the "Maximum Extents" event as
> well, stating
> >the
> >"Recommended Frequency" as 10 minutes (you can take that one back at
> >least),
> >whilst still stating:
> >
> >"Note: Running the Maximum Extents event test may be a
> resource-intensive
> >operation. Therefore, Oracle recommends running the Maximum
> Extents event
> >test during off-peak periods."
> >
> >One last thing to consider, with all of these events set at 5 minute
> >intervals - do they all the checks execute at the same time?
> How about
> >monitoring the monitor, to see what kind of resources it really is
> chewing
> >up? I wonder if you will start to see large spikes on five minute
> >intervals
> >;)
> >
> >Here's one for the list:
> >
> >How often do YOU check these limits (tablespace utilisation, and "max
> >extents")?
> >
> >Regards
> >
> >Mark
> >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author:
> > INET: Jared.Still_at_radisys.com
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> Hemant K Chitale
> My personal web site is : http://hkchital.tripod.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hemant K Chitale
> INET: hkchital_at_singnet.com.sg
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Odland, Brad
> INET: Brad.Odland_at_qtiworld.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Orr, Steve
> INET: sorr_at_rightnow.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Apr 15 2003 - 19:58:50 CDT

Original text of this message

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