Benefits
Oracle Debugger: The Oracle SQL Debugger has been designed to help with testing and debugging of SQL functions and procedures for Oracle.
Compare Tools: There is a full-featured set of compare tools for comparing files, directories, clipboard history, tabs, sql query results and database schemas.
SQL (History) Archive: The SQL History Archive can automatically store every query run (over days, months and years) and can be searched and filtered later for easy reuse of queries. This archive is also extremely useful for auditing purposes (Sarbanes-Oxley Compliance).
Oracle Database Administrator Tools
Oracle Instance Manager: Provides manageability of the Oracle instance allowing the user to view and modify server parameters. Including the monitoring and backup of the Oracle controlfile.
Oracle Storage Manager: Provides manageability of the Oracle tablespaces and datafiles. Allowing a user to visualize and maintained storage. Including object and file IO statistics.
Oracle Rollback Manager: Provides the monitoring and maintenance for rollback segments, including current statements, transactions and execution plans.
Oracle Log Manager: Provides manageability of Redo Logs and Archive Logs. Allows users to create and manage redo logs including monitoring archive logs.
Oracle Security Manager: Provides manageability of users, roles and profiles. Allowing the user to manage permissions, roles and security of the Oracle database.
Oracle Session Manager: Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
Oracle SGA Manager: Provides manageability of the Oracle SGA area, including SQL Area, Lib Cache, Lib Cache Stats and a summary of the SGA. Allowing users to also pin and unpin code.
Oracle Server Statistics: Provides a summary of statistics for the Oracle instance, waits and latches.
|