Online Documentation for SQL Management Studio for Oracle

Using services


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

 

 

Database Management - Services

 

 

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.

 

 

Backup Database

Creates backup copies of your Oracle databases.

 

Restore Database

Restores Oracle databases from previously created backups.

 

Advanced Statistics

Collects various statistics as an aid to improve the performance.