GUGGI for ORACLE - Tool For DBAs and Developers

 

 

 
 
 
 
 
 
 
 
 
 
 

Features: Guggi for Oracle

 



        Browse the database for 31 different types of objects such as table, view, synonym, function, index, trigger, sequence, constraints, clusters, schema, tablespace, procedure, package, java class, materialized view, database link, type, rollback segment, directory, operator, library, queue, java data, java source, java resource, context, consumer group, index type and job. 

 

        Create database objects such as table, constraint, database link, directory, index, sequence, synonym, advanced queues, library, consumer group, rollback segments etc. through a simple user interface. 

 

        DBA features (besides performing DDL). 

 

 

1.      View latches, locks, waits and instance / SGA/ Session statistics. 

2.      View library cache and control files. 

3.      View input / output statistics. 

4.       View Backup statistics. 

5.      View Oracle Parameters. 

6.       View free space by tablespace and datafile. 

7.      View space taken by each object in the database. 

 

        Database Tools for DBAs and Developers. 

 

1.       Database schema browser. 

2.      SQL Editor. 

3.      Guggi SQL Editor SQL editor outside the Guggi for Oracle application. 

4.      PL/SQL Editor. 

5.      Reports of database objects.   

6.      Reverse engineer database objects.   

7.      Search objects in the database.   

8.      Performance statistical analysis of data such as min, max, standard deviation, variance, standard error, Kurtosis,  skewness.   

9.      Analyze Manager analyze tables and indexes.   

10.   Invalid Objects Manager view invalid objects and compile them.   

11.  Rollback Segment Manager manage rollback segments, view active segments and their properties, view current SQL on segments.   

12.   Sessions Manager view current database sessions.   

13.  SQL Stats Manager analyze SQL in the database hot tables, top bugger gets, top disk reads etc.   

14.  User/Schema Role Manager manager security in the database.   

15.  View linked data view data in tables linked by primary key and foreign key relationships.   

16.  View Image download BLOBs from the database.  View image BLOBs.   

17.  Upload Binary Data Save BLOBs in the database (any binary data).   

18.    Network Tools ftp files back and forth from an FTP server.  Will add others such as telnet, ping, rexec.   

19.  Scientific Calculator quick on the fly calculations.   

20.      SQL*Plus Open SQL*Plus window. 

 

        Manipulate objects such drop, delete, disable constraints, enable constraints, rollback segment online/offline, commit pending area in consumer groups etc.  

 

        Tab through the properties of database objects. 

 

         Filter the table and view data. 

 

        Add, delete, and update data (in a table) using a simple grid interface. 

 

        Read the PL/SQL code behind views, materialized views, procedures, packages, functions, triggers, and types.

 

        Generate the script for tables, indexes etc. 

 

         Reverse engineer objects from an exiting database. 

 

        Set the maximum number of records to be returned by a query or when you scroll the data in a table. 

 

        A simple and easy to use SQL editor to run queries and generate explain plans. 

 

        A simple and easy to use PL/SQL editor to write and compile your PL/SQL code. Easily check the error messages and fix them. 

 

        Export data from an existing table or a query in csv, tab delimited or user-defined delimited format. Export the data to Excel. Export the table data as insert statements. 

 

        Run individual SQL statements or run a script with multiple statements in the SQL Editor. 

 

         Debug the PL/SQL code (future enhancement). 

 

        Open a new schema browser or SQL Editor by right-clicking on the button at the bottom of the screen. 

 

        Open the window for an already established database connection by clicking on the appropriate button located at the bottom of the application. 

 

        Reconnect a closed connection by using right-click on the button at the bottom of the screen. 

 

        Quickly check the system info of your local computer. 

 

        Easily comment, uncomment text, change case (lower, upper, init cap), change background color, justify (center, left, right) text, wrap text, change font, redo/undo etc. 

 

        Text formatter to color  code key words for easy readability under development. 

        Execute stored procedures and packages. 

 

        Object browser window to quickly determine the tables and columns available when writing stored procedures or SQL queries. 

 

        Refresh the screen to get latest information about database objects. 

 

        View DBMS output in the SQL Editor window. 

 

        Change user password. 

 

        Multiple ways to connect to Oracle - OLEDB and ODBC.  Connect as SYSDBA or SYSOPER. 

 


Oracle is a registered trademark of Oracle Corporation. DB2 is a registered trademark of IBM Corporation.

© 2006  Impact Solutions LLC
All Rights Reserved.

About Us | Products | Services | Downloads | Buy Now | Clients | Testimonials | Careers | Contact Us
Guggi for Oracle:: Download | Features | Screenshots | FAQ | Change Log | User Guide