·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
7.View space taken by each object in the
·Database Tools for DBAs and
1. Database schema browser.
3.Guggi SQL Editor – SQL editor outside
the Guggi for Oracle application.
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
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.
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
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
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
·Add, delete, and update data (in a table) using a simple grid
·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
·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
·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.