Documentation: Aqua Data Studio 4.7		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. Informix   VII. PostgreSQL   VIII. MySQL   Character sets   Registering Servers   I. MSDE 2000   II. SQL Express 2005   III. PostgreSQL SSL   Application   I. Browser & Scripting    II. Visual Editing   III. SQL History   IV. Shortcut Toolbar   V. Options   VI. Settings   Query Window   I. Basics   II. Shortcut Keys   III. Toolbar   IV. Server Side Comments   V. SQL Automation   VI. Variable Binding   VII. Results   VIII. Save Results   IX. Auto-completion   X. SQL Formatter   XI. Permissions   XII. Parameterized   Visual Explain Plan   I. Basics   II. Explain Plan   III. Explain Diagram   IV. Whiteboard   Procedure Editor   Tools   I. Table Data Editor   II. Script Generator   III. ER Diagram   IV. Query Builder   V. Import Tool   VI. Export Tool   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

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

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