Anand:
This is one of four queries in a script I call my
'space_critical'
script. Every night, an automated process scans
all the DBs that
I am responsible for, and sends me an e-mail if
there is a problem,
such as not enough space in a tablespace for a table to
add an
another extent.
When I get this e-mail, I log in to this database with
a maintenance
ID, and run 'space_critical'. The entire report
shows space by
tablespace, by datafile, and by 'troubled
object'. Trouble Objects
are tables, indexes, whatever, that cannot allocate
another extent.
My script also creates a script in the /tmp directory
that will
change the next_extent size to a number that will fit
in the
remaining space. This is useful when the vendor
is late delivering
the disk you need.
I published this script last year to www.searchDatabase.com.
The
script can be found at http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci778766,00.html.
I hope you find it useful.
Cheers,
Mike
|
- RE: Win2000/8.1.7.3.0/SQL John Kanagaraj
- Re: Win2000/8.1.7.3.0/SQL Peter . McLarty
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL Reardon, Bruce (CALBBAY)
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL Straub, Dan
- RE: Win2000/8.1.7.3.0/SQL John Kanagaraj
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- Re: Win2000/8.1.7.3.0/SQL Jared Still
- RE: Win2000/8.1.7.3.0/SQL Straub, Dan
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL Jared . Still
- Re: Win2000/8.1.7.3.0/SQL Chaim . Katz
- RE: Win2000/8.1.7.3.0/SQL Straub, Dan
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)
- RE: Win2000/8.1.7.3.0/SQL John Kanagaraj
- RE: Win2000/8.1.7.3.0/SQL John Kanagaraj
- RE: Win2000/8.1.7.3.0/SQL Vergara, Michael (TEM)