RE: OEM Events

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).