RE: Tablespace free space monitoring, including AUTOEXTEND

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>, <adar666@xxxxxxxxxxxx>
  • Date: Wed, 14 Jul 2010 15:25:33 -0400

Here is one written to run in EM_grid as a job.  (the double %%), but
you could easily modify it for Sqlplus etc.   It mails a message if a
new file is needed.

 

It works on either 2K or 8K blocksizes (which determine the max datafile
size).   You can modify for other block sizes, and you can tell it when
to send the email.

 

For instance for 8K blocksize, it will send a message whenever all the
datafiles in a tablespace are over 30Gbs, (you supply the number in the
case statement for v_datafile_size).

 

 

As for 'available disk space', we monitor that separately, the sysadmins
actually monitor it, and I believe they use various tools such as
foglight.

Joel Patterson 
Database Administrator 
904 727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Wednesday, July 14, 2010 11:35 AM
To: adar666@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Tablespace free space monitoring, including AUTOEXTEND

 

On Tue, Jul 13, 2010 at 11:00 PM, Yechiel Adar <adar666@xxxxxxxxxxxx>
wrote:

One of the main problems of this kind of scripts is that they do not
check the actual available disk space for auto extend.
You can have a definition that show that you have 32 GB available, with
auto extend, but you gave only 10 GB on the disk.


That could be remedied should someone be ambitious enough
to write the Java SP to get that info.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2010