Home » RDBMS Server » Server Administration » Tablespace alert script that will ignore autoextend
Tablespace alert script that will ignore autoextend [message #221641] Tue, 27 February 2007 21:35 Go to next message
Messages: 48
Registered: December 2005
Location: Penang, Malaysia


We are running on Oracle database 10g and would like to configure a script to check constantly on the tablespace. We will be alerted with any tablespace with >90% usage. However with autoextend features, our existing script will report an alert even the tablespace are able to extend.

Is there any scripts to ignore tablespace which are still able to autoextend?

Re: Tablespace alert script that will ignore autoextend [message #221747 is a reply to message #221641] Wed, 28 February 2007 05:06 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Edit your script and filter out/exclude the datafiles that are autoextensible to be YES.
scott@9i > select file_name,autoextensible from dba_data_files;

FILE_NAME                                                              AUT
---------------------------------------------------------------------- ---
/u01/app/oracle/oradata/mutation/system01.dbf                          YES
/u01/app/oracle/oradata/mutation/undotbs01.dbf                         YES
/u01/app/oracle/oradata/mutation/indx01.dbf                            YES
/u01/app/oracle/oradata/mutation/tools01.dbf                           YES
/u01/app/oracle/oradata/mutation/users01.dbf                           NO
/u01/app/oracle/oradata/mutation/test.dbf                              NO
/u01/app/oracle/oradata/mutation/xdb01.dbf                             YES

7 rows selected.

Previous Topic: Oracle OS Question: SolarisX86 or RH Linux?
Next Topic: ORA-28009 ORA-01031: insufficient privileges
Goto Forum:

Current Time: Thu Aug 17 10:45:04 CDT 2017

Total time taken to generate the page: 0.74222 seconds