Pravin wrote:do any datafiles have AUTOEXTEND enabled?
Can i get the alert, if the tablespace used size reached to 80%.
Because i handles 25 Databases, going to each databases and checking the tablespace size is really painfull.
Is there any third party free tool available to check the tablespace size OR can we do it in database itself...pls help
Trung Hieu wrote:You need to be a bit careful with your licence here. I think that you need Enterprise Edition (plus the Diagnostic Pack?) to use the full OEM functionality. If you have only Standard Edition, sure you can configure the thresholds with dbms_server_alert, but you have to write an alert handler yourself.
Hi,you can use Oracle Enterprise Managerment to do that
Login -> Server -> Tablespace -> edit ->Thresholds
or you can reference
why should i use while there's something Oracle gave me for free too . :)Are you sure it is for free?