Online Documentation for SQL Management Studio for Oracle

Using services


SQL Studio integrated features provide easy way to run all native Oracle services which are intended for database maintenance. The following services and server tools are available:

 

To run a service, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard with this template.

 

To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.

 

Database Management - Services

 

 

 

 

Backup Database

Creates backup copies of your Oracle databases.

 

Restore Database

Restores Oracle databases from previously created backups.

 

Gathering Statistics

Collects various statistics as an aid to improve the performance.