Sooner or later, every DBA will need to address how to manage storage capacity in their databases. Nearly every database needs more storage as time goes on, and without attention, the database will fill up, and new data/inserts can’t happen. It’s been my experience that bad space mangement is the root cause of a high [...]

As an implementer of commercial and open source database monitoring tools I find DatabaseRX has capabilities that clearly differentiate it from the rest of the market:

Scalability - hundreds of databases and instances can be added with trivial monitoring overhead, due in part to a highly normalized data model, message based architecture and modular design (loader,analyzer,notifier).
Security [...]

Alert Log Monitoring DatabaseRX

I was recently asked if I had any metrics on an individual tables growth over time. I immediately thought of the DBMS_SPACE package’s OBJECT_GROWTH_TREND procedure. Here’s a quick snippet of my findings:

SQL> select * from table(dbms_space.OBJECT_GROWTH_TREND(’PROD_SCHEMA’,'BIG_TABLE’,'TABLE’));

TIMEPOINT [...]