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

Rollback Manager - Provides the monitoring and maintenance or rollback segments, including current statements, transactions and execution plans. Toolbar Operations - Refresh : Will refresh all tabs in the rollback manager from the database Create Rollback Segment: Create a new rollback segment Edit Rollback Segment: Edit selected rollback segment Drop Rollback Segment: Drop selected rollback segment Rollback Segment Properties: View properties of selected rollback segment Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds" General Tab - Provides a list of available rollback segments Segment: Name of the rollback segment Owner: Owner of the rollback segment Tablespace: Name of the tablespace containing the rollback segment Status: Rollback segment status Transactions: Number of active transactions Initial: Initial extent size Next: Secondary extent size PCT Increase: Percent increase for extent size Current: Size of the rollback segment Optimal: Optimal size of the rollback segment Used: Current size of active extents, averaged over time Extents: Number of extents in the rollback segment Current: Current extent Block: Current block Gets: Number of header gets Waits: Number of header waits Hit Rate: (Gets-Waits)*100/Gets USN: ID number of the rollback segment Transaction Users Tab - Provides a list of active transactions on the selected rollback segment Rollback Seg: ID number of the rollback segment Session ID: Session identifier Serial #: Session serial number OS User: Operating System client user name Oracle User: Oracle username Start Time: Starting time of the operation Status: Status of the session Current Statement Tab - The current SQL statement on the select transaction. Open Cursors Tab - Provides a list of open cursors on the session ID of the selected transaction SQL: SQL Text for the open cursor Last Loaded: Time at which the query plan was loaded into the library cache

Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact

Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved