Fight Table Proliferation
If your users and developers have resource privileges on the database, you will find that you are constantly having to play "table janitor." It's funny how tables named temp_XXX are never really temporary and how tables that were going to hang around for "just a coupla' days" become institutionalized as part of your database.
What we need is a tool that will allow the DBA to monitor the tables in a database, know what should be there and what shouldn't be there, and notify the DBA when certain tables should be removed.
This is a situation that is quite common to UNIX system administrators. Any time that you have a community of users who are utilizing common resources, you have to deal with resource hogs. While many users ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
