Hello Team(s) Please be advised that a brand new type of tablespace monitor has been deployed for HBC. https://observer.datapipe.com/Check/277878.aspx https://observer.datapipe.com/Check/277733.aspx The way this works is via a cron job. Every ½ hour, a cron job will run that compute the space usage on all tablespaces in the Db. # Datapipe tablespace monitor 00,30 * * * * /home/oracle/dpmon/refresh_tablespace_chart.sh EMREP &> /dev/null 00,30 * * * * /home/oracle/dpmon/refresh_tablespace_chart.sh BCDAGPRD &> /dev/null These cron scripts will update a table in the dp_adm schema and generate a text report. [oracle@dnjoradbprd02 dpmon]$ cat /var/log/oracle/*tables* SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 8 14:09:38 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> PL/SQL procedure successfully completed. SQL> TABLESPACE_NAME CONTENTS PCT_USED ------------------------------ --------- ---------- SYSTEM PERMANENT 1.03664448 SYSAUX PERMANENT 2.12860209 UNDOTBS1 UNDO .358390979 TEMP TEMPORARY 5.85632603 USERS PERMANENT .003051759 TOOLS PERMANENT .003051759 INDX PERMANENT .003051759 AGILE_DATA1 PERMANENT 24.6475337 AGILE_INDX1 PERMANENT 9.45301507 AGILE_DATA2 PERMANENT 9.68056187 AGILE_INDX2 PERMANENT 2.14977367 TABLESPACE_NAME CONTENTS PCT_USED ------------------------------ --------- ---------- AGILE_DATA3 PERMANENT 14.1899177 AGILE_INDX3 PERMANENT 10.4030659 AGILE_DATA4 PERMANENT 1.58596114 AGILE_INDX4 PERMANENT .631523433 UNDO UNDO .006866458 DATAPIPE PERMANENT .003242494 17 rows selected. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 8 14:00:01 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> PL/SQL procedure successfully completed. SQL> TABLESPACE_NAME CONTENTS PCT_USED ------------------------------ --------- ---------- SYSTEM PERMANENT 2.77671946 SYSAUX PERMANENT 3.75480831 UNDOTBS1 UNDO .576591767 TEMP TEMPORARY .152587963 USERS PERMANENT .004005434 MGMT_ECM_DEPOT_TS PERMANENT .43773672 MGMT_TABLESPACE PERMANENT 10.9256796 MGMT_AD4J_TS PERMANENT .004959109 DATAPIPE PERMANENT .003242494 9 rows selected. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options The observer check will log in every 5 minutes or so and query . ARE THERE ANY (MORE THAN 0) tablespaces with usage over 85%. If the answer is 0 then OK. If the answer is > 0 then alarm. When an alarm goes off, we will need to review the report in /var/log/oracle to determine which tablespace(s) are in space condition. Continuserve wants Datapipe DBA to add or expand datafile when > 85% and notify them by ticket. This should make it into the SEAP when those are completed. The samples listed above have only a few tablespaces, but some of these DBs have more than 100, so this method is much more efficient than any others until HBC converts to EM7 (if ever) -Todd