Home Home Screenshots Download Documentation Contact Licensing Licensing

Documentation: Aqua Data Studio 6.0 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Sybase IQ
  VII. Informix
  VIII. PostgreSQL
  IX. MySQL
  Memory Configuration
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser and Scripting
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Key Mappings
  VI. Custom Keymap Profiles
  VII. Options
  VIII. Settings
  Query Window
  I. Basics
  II. Toolbar
  III. Server Side Comments
  IV. SQL Automation
  V. Variable Binding
  VI. Results
  VII. Save Results
  VIII. Auto-completion
  IX. SQL Formatter
  X. Permissions
  XI. Parameterized
  Editors
  I. SQL Editor
  II. Text Editor
  III. HTML Editor
  IV. XML Editor
  V. Regular Expressions
  Image Viewer
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure/Package Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool
  VII. Execution Monitor
  Difference Tools
  I. Schema Diff
  II. Tab Diff
  III. Directory Diff
  IV. File Diff
  V. Copy History Diff
  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
  SQL Server DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
  V. SQL Agent Manager
  Sybase DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
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.


Toolbar Operations -

Refresh : Will refresh all tabs in the instance manager from the database
Edit Server Parameter: Edit the value of the currently selected parameter
Backup Controlfile: Backup the Oracle Controlfile
Find: Find tool to search the grid of the current tab
Find Next: Find the next instance of the previous find

General Tab - Provides a summary of the Oracle instance

DB Name: Name of the database
Instance Name: Name of the instance
Host Name: Hostname of the server
Version: Version of the Oracle instance
Startup Time: Date and time of when the server was last started
Uptime: The duration the server has been running
Restricted Mode: Specifies whether instance is in restricted mode
Archive Log Mode: Specifies whether archive log is enabled
Banner: Instance banner information from v$version

Instance Manager
Controlfile Tab - Provides Oracle controlfile information

Oracle Controlefile
Oracle Parameters Tab - Oracle instance parameters

Option: Name of the parameter
Setting: Value of the parameter
Default: Indicates whether the parameter is set to the default value or the parameter value was specified in the parameter file.
Description: Description of the parameter
Session Modifiable: Indicates whether the parameter can be changed with ALTER SESSION
System Modifiable: Indicates whether the parameter can be changed with the ALTER SYSTEM and the change takes effect immediately
Deferred: Indicates whether the parameter can be changed with the ALTER SYSTEM and the change effect is deferred

Oracle Parameters
Hidden Parameters Tab - Oracle instance hidden parameters

Same as Oracle parameters.
Oracle Hidden Parameters
NLS Parameters Tab - Provides Globalization (National Language) Support parameters.

Scope: Specifies the scope of the parameter with values of DATABASE, INSTANCE or SESSION.
Parameter: The name of the NLS parameter.
Value: The value of the NLS parameter.

Oracle NLS Parameters
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved