Online Documentation for SQL Manager for Oracle
SQL Manager for Oracle provides graphical interface for a number of database maintenance operations. The following services are available in SQL Manager:
Allows you to get and modify all information on configuration parameters for the current Oracle instance and current session.
Allows you to view all the essential statistics on the specified database — system statistics, statistics on sessions (including hit ratio, information on locks and processes), statistics on storage, wait events, latches etc.
Allows you to profile existing PL/SQL applications and identify performance bottlenecks.
Allows you to collect, delete and import/export the statistics on specified objects for optimizer, as an aid to improve the performance.
Makes possible to process trace files and create transient kernel reports.
Creates backup copies of your databases.
Restores your databases from previously created backups.
Restores data to a certain state.
Allows you to create, schedule and run single or recurring execution of tasks in the database.
A useful tool for truncating table and cluster data in the specified database.
Allows you to look up invalid objects in the specified schema and recompile them using their definition.
A wizard used to disable and enable the constraints of different types.
To obtain detailed information concerning specific Oracle database maintenance services, refer to the official server documentation.