Re: Oracle tablespace thresholds

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Wed, 14 Jun 2006 12:51:03 GMT
Message-ID: <J0up1D.64q@igsrsparc2.er.usgs.gov>

Teresa wrote:
> Hello
>
> I have oracle 10G on solaris and I would like to put in place some kind
> of thresholds for the tablespaces when they reach a percentage an alert
> would be generated.
> Does anyone have some kind of script etc that would like to share?
>
> Many Thanks
> Teresa
>

The easiest way is to use Enterprise Manager to define the Metrics for tablespace alerts (and others).

On the command line, you can use the DBMS_SERVER_ALERT.SET_THRESHOLD procedure. You should be able to find more information in the Oracle docs, specifically the PL/SQL Packages and Types Reference.

HTH,Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Wed Jun 14 2006 - 07:51:03 CDT