OraFAQ Forum: Server Administration » Tablespace alert script that will ignore autoextend

Home » RDBMS Server » Server Administration » Tablespace alert script that will ignore autoextend

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace alert script that will ignore autoextend [message #221641]

Tue, 27 February 2007 21:35

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi,

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?

Thanks.

Report message to a moderator

Re: Tablespace alert script that will ignore autoextend [message #221747 is a reply to message #221641]

Wed, 28 February 2007 05:06

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:45:27 CST 2024