When your enterprise environment contains several different operating systems and database versions, it is best to have tools that work across scopes. We have already mentioned scripting as well as using DBMS_SCHEDULER and PL/SQL. There are also several software packages that offer GUI interfaces for real-time monitoring capability.
Oracle has a product called Grid Control (GC); it is the Enterprise Manager for the Enterprise. You can install a standalone version of Enterprise Manager in each database (called Database Control) or use GC with a centralized repository for all of your Oracle products. Grid Control is a free product from Oracle, the Management Packs have an additional license cost. Most customers purchase the DIAGNOSTICS & TUNING to take advantage of the extensive performance tuning features found in the Automatic Workload Repository, and not just for the OEM Interface.
The trade-off is a superb enterprise-wide tool,...