The tool comes with following major features:
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, materiali
Tutorial Details:
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).
View latches, locks, waits and instance / SGA/ Session statistics.
View library cache and control files.
View input / output statistics.
View Backup statistics.
View Oracle Parameters.
View free space by tablespace and datafile.
View space taken by each object in the database.
Database Tools for DBAs and Developers.
Database schema browser.
SQL Editor.
Guggi SQL Editor – SQL editor outside the Guggi-Oracle application.
PL/SQL Editor.
Reports of database objects.
Reverse engineer database objects.
Search objects in the database.
Performance statistical analysis of data such as min, max, standard
deviation, variance, standard error, Kurtosis, skewness.
Analyze Manager – analyze tables and indexes.
Invalid Objects Manager – view invalid objects and compile them.
Rollback Segment Manager – manage rollback segments, view active
segments and their properties, view current SQL on segments.
Sessions Manager – view current database sessions.
SQL Stats Manager – analyze SQL in the database – hot tables, top
bugger gets, top disk reads etc.
User/Schema Role Manager – manager security in the database.
View linked data – view data in tables linked by primary key and
foreign key relationships.
View Image – download BLOBs from the database. View image BLOBs.
Upload Binary Data – Save BLOBs in the database (any binary data).
Network Tools – ftp files back and forth from an FTP server. Will add
others such as telnet, ping, rexec.
Scientific Calculator – quick on the fly calculations.
SQL*Plus – Open SQL*Plus window.
Read
Tutorial at: Click here to view the tutorial
Rate Tutorial: Guggi Oracle is a database visualization tool for Oracle.
View Tutorial: Guggi Oracle is a database visualization tool for Oracle.
Related
Tutorials:
Integrating Databases
Integrating Databases |
SQLJ: The 'open
sesame' of Java database applications
SQLJ: The 'open
sesame' of Java database applications |
Java is here to stay (JavaWorld / January 2000 / by John Rommel)
Java is here to stay (JavaWorld / January 2000 / by John Rommel) |
Java tools reign
supreme - JavaWorld celebrates the
leading Java tools
Java tools reign
supreme - JavaWorld celebrates the
leading Java tools |
Make the Java-Oracle9i
connection
Make the Java-Oracle9i
connection |
SQL Database Access with DBTags
SQL Database Access with DBTags
In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav |
Using CachedRowSet to Transfer JDBC Query Results Between Classes
Using CachedRowSet to Transfer JDBC Query Results Between Classes
The Java Database Connectivity (JDBC) API provides developers with an interface to a SQL database server, such as MySQL or Oracle. Central to any JDBC application is the java.sql.ResultS |
JForumFusion
About jForumFusion
JForumFusion is a platform independent discussion board program.
|
IberAgents
Introduction
IberAgents is a web application framework that enables the creation of SOAP-interoperable components in Java, with life cycle management and remote configuration. Development started in 2001; we now have a mature, solid open-source platform |
First Step towards JDBC
This article introduce you with JDBC and shows you how to create a database application to access the databases. |
Accessing Databases Using Java and JDBC
This article will show how a Java Application, Applet or Servlet can access data stored in relational databases using the JDBC API. |
Service Orchestration - Cornerstone for Building Service-Oriented Architecture
This Web Cast explains the Service-Oriented Architecture (SOA). Service-oriented architecture is rapidly becoming the cornerstone for enterprise infrastructure, bringing cost reductions and increasing IT and business responsiveness. |
Oracle answers on Linux
The world's business software giant offers answers to the 10 most frequently asked questions about Linux. |
Understanding the Benefits of Implementing Oracle RAC on Sun Cluster Software (pdf)
This Sun BluePrints OnLine article is the complete second chapter of the book, "Creating Highly Available Database Solutions: Oracle Real Application Clusters (RAC) and Sun Cluster 3.x Software." This documents targets an intermediate audience. |
Application Servers Available in Market. Web Servers. J2EE server.
Application Servers Available in Market. Web Servers. J2EE server.
Application Servers Available in Market
Before we go into the grater details of the EJB let's look at some of the EJB Application Servers available in the market. Application |
First Step towards JDBC!
First Step towards JDBC!
First Step towards JDBC
Introduction
T his article introduce you with JDBC and shows you how to create a database application to access the databases. For the shake of simplicity, in very first example Access database and |
Introduction to the JDBC
Introduction to the JDBC
Introduction to the JDBC
Introduction
T his article introduce you with JDBC and shows you how to our search engine with database.
What is JDBC?
J ava Database Connectivity or JDBC for short is set of Java API's that |
DB Solo - Database development and management tool
DB Solo is a powerful database development and management tool for developers
and DBAs. DB Solo has an intuitive user interface that allows you to explore
and manage your database objects as well as execute your own ad-hoc queries.
|
JLAN Server v3.5 - Database Filesystems
*JLAN Server* is a high performance Java based file server supporting Windows file sharing (SMB/CIFS), NFS and FTP protocols.
|
DB Visual Architect for Eclipse
DB Visual Architect for Eclipse (DBVA-EC) is a full featured Object Relational Mapping (ORM) plugin for Eclipse that provides the industry\'s best round-trip code engineering support with Java. |
|
|
|