Contact:
info@impact-sol.com
1. What do I do if I don't find an answer to my question or encounter a bug or have an enhancement request?"
2. When I start the application, I get a PopMenu control error "Run-time error 429: Active X component can’t create object". Why is that?"
3.
The application returns a maximum of 100 records when a table is queried or a SQL statement is executed. How do I retrieve more records?
4. I
am connected to multiple databases or schemas. How do I switch between
connections?
5. The
main screen shows only 16 objects. How do I see the remaining objects?
6. What
does the Statistics feature of the application?
7. When I select a feature / tool from Database and DBA option from the main menu, I get an error message “table not found”. Why is that?"
8. I
have closed the connection to the database, and now I want to reconnect. How
do I do that?
9. The
login screen shows many ways to connect to Oracle. What do they stand for?
10.
How
many simultaneous connections does the tool support?
11.
What do the various tools do?
12. How
do I login as an Operating System authenticated user?
13. How
do I login as SYSDBA or SYSADMIN?
14. How
do I switch between connection?
15.
How
do I scroll through the records returned by a SQL query?
16.
Is Guggi for Oracle free?
17.
I am in SQL Editor (or PL/SQL editor) and I want to see the details of a table (or some other object such as view, procedure). I don't want to go to Schema Browser everytime. Is there a short cut to see object details?
18.
How
do I adjust the left side display window on the Schema Browser?
19.
How do I set
the language of the main menu list?
20.
I clicked on a tool within Guggi for Oracle and I get the message "Table or View does not exist". What does this mean?
21.
How do I read data from
DBA% views.
22.
How
is SQL history different from SQLEditor session buffer?
23.
I was running a query and my computer system crashed. The SQL was a long statement and I forgot to save it. Is the statement lost forever and can I retrieve it?
24.
What is Guggi SQL Editor?
25.
Can
I execute some long running statements in the background?
26.
Is
Guggi Oracle a developer tool or a data administration tool?
1.
What do I do if I don't find an answer to my question or encounter a
bug or have an enhancement request?
Please
fill out the feedback form on Contact page, or send an email to info@impact-sol.com.
Your question will be answered in 24 hours.
2.
When I start the application, I get a PopMenu control error
"Run-time error 429: Active X component can’t create object".
Why is that?
This
error occurs because a dll called SSubTmr6.dll is missing from the registry.
In order to register the dll, download the file from
http://www.impact-sol.com/download/SSubTmr6.dll
and
save it on your local drive. Open
a DOS / Command window, and go to the location where you saved the file.
Then issue the following command:
regsvr32
SSubTmr6.dll
Try
opening the application again, and Guggi for Oracle should open this time.
3.
The application returns a maximum of 100 records when a table is queried or a
SQL statement is executed. How do I retrieve more records?
The
application as a default returns first 100 records. You can change this by
Selecting Tools from the menu bar, select Set Records, and enter the number of
records to be retrieved. Enter zero to return all records or simply click on
“Return All Records”. The setting is displayed at the bottom of the
application. It is not recommended to return all records from a large table.
4.
I am connected to multiple databases or schemas. How do I switch between
connections?
Just (left) click on the button at the bottom of the screen displaying the
connection. Alternatively, select the connection from the drop down box
located in the top toolbar.
5.
The main screen shows only 16 objects. How do I see the remaining objects?
Click on the “book” icon (on the toolbar below the connection icon)
and you will additional objects. Click on it again and you will be returned to
the previous screen.
6.
What does the Statistics feature of the application?
The Statistics tool calculates tstics of data in database tables. You can
use this tool to calculate min, max, avg, std dev etc. of data in a database
column that has a numeric datatype. Many more statistical calculations and
functions will be added here. This functionality should not be confused with
database statistics generated by using the Analyze command.
7.
When I select a feature / tool from Database and DBA option from the main
menu, I get an error message “table not found”. Why is that?
Database and DBA menu option is for those users who are logged into Oracle
with DBA privileges, or have access to underlying System objects. Some tools
from the Tools option such as Rollback Segments Manager, SQL Stats manager
etc. may show the same error message.
8.
I have closed the connection to the database, and now I want to reconnect. How
do I do that?
When a new database connection is opened, a button appears at the bottom
of the screen. This button is disabled when the connection is closed.
Right-click on the button with closed database connection, and select
reconnect. The connection will be re-established and the database browser will
open up.
9.
The login screen shows many ways to connect to Oracle. What do they stand for?
A connection driver is needed to connect to Oracle. Several companies make
connection drivers. The application currently supports OLEDB by Microsoft,
OLEDB by Oracle, and ODBC drivers (which can be from any company). These
drivers are most widely used in the industry, and are known to provide stable
connections.
OLEDB for Oracle by Microsoft is a part of MDAC kit provided for free by
Microsoft. OLEDB for Oracle is installed when Oracle Client is installed. In
order for the drivers mentioned above to work, Oracle Runtime client
installation which installs SQL*Net is required.
10.
How many simultaneous connections does the tool support?
The tool is set up to support 20 simultaneous connections. If you want
more connections then it is recommended that a new instance of the application
be started.
11. What do the various
tools do?
A brief description of the tools is as follows:
Rollback Segment Manager: Displays the active transactions and the SQL running
on a given rollback segment. Create a new rollback segment if the database is
not operating in the AUM model.
Analyze Manager: Analyze all the underlying objects such as tables and
indexes.
Invalid Objects Manager: View all the invalid objects in the database or a
given schema. Recompile invalid objects.
Sessions Manager: View active sessions on the database and see what SQL these
sessions are executing.
SQL Stats Manager: Analyze the top (worst) SQL in terms of buffer gets, disk
reads, executions etc. View hot tables.
Latches, Locks and Waits: View the instance statistics, Waits, Latches and
Locks. Useful if you want to analyze database contention and gather
information on waits, locks and latches.
Free Space: Determine free space in the database. Free space can be analyzed
for a given tablespace or a given data file.
Space by Object: Determine the space taken by different objects.
View Linked Data: View the data stored in tables that are linked by
referential integrity (primary and foreign key relationships)
Statistical Analysis: Perform statistics on numeric data stored in database
tables
Set Records: Set the number of records returned by the query or while viewing
the data in a table, synonym or view.
User/Schema Role Manager: Manage user privileges, roles etc.
Reverse Engineer: Extract the DDL and PL/SQL of existing objects in the
database.
Reports: Generate printable reports of metadata.
More
tools have been added ....
Please contact info@impact-sol.com if
you want to know how to use the features of Guggi.
12.
How
do I login as an Operating System authenticated user?
In
the User Name login box, enter "/". Leave the password box blank.
Enter the TNS name or the DSN if using ODBC. Click OK. Guggi and Oracle will
authenticate the user at the OS level.
13.
How
do I login as SYSDBA or SYSADMIN?
Logging
in as SYSDBA or SYSADMIN is supported via ODBC version 9.2 or higher. OLEDB
does not support logging in as SYSDBA or SYSADMIN. Oracle recommends that
users should use SYSTEM account to carry out DBA activities and not use the
SYS account.
14.
How
do I switch between connection?
You
can switch between connections for an existing window such as SQL*Editor,
Sessions Manager etc. by clicking on the rightmost-button on the top toolbar
(change connections) and selecting the connection.
15.
How do I scroll through the records returned by a SQL query?
In the SQL Editor in the toolbar above the grid, click on the down arrows.
The first down arrow will return 25 records and the second down arrow will
return all the records. Click on the stop button to stop retrieval of records.
16. Is Guggi for Oracle free?
Guggi for Oracle is free to use for a limited time. You can download it for
a free 30 -day trial period. But it is extremely affordable. The product comes with tons of features not found in
competing products. The goal is to develop an affordable, robust and
feature-rich product.
17.
I am in SQL Editor (or PL/SQL editor) and I want to see the details of a table
(or some other object such as view, procedure). I don't want to go to Schema
Browser everytime. Is there a short cut to see object details?
Yes. In order to see object details, place the cursor over the object
(table name, for example) and press ctrl-Q. A window displaying object details
will open up.
18.
How do I adjust the left side display window on the Schema Browser?
Size of windows on the schema browser are set using Application Options.
Click on View -->Application options -->Schema Browser -->Item and
set the window size.
19. How
do I set the language of the main menu list?
Guggi supports English, French, German and Spanish in the main menu bar.
The language can be set using Application options. Click on View
-->Application options -->Start Up -->Item and set the application
language.
20.
I clicked on a tool within Guggi for Oracle and I get the message "Table or
View does not exist". What does this mean?
This simply means that that the user you are logged in as does not have
access to the underlying data dictionary views. Contact your DBA to grant you
access to these views.
21. How do I read
data from DBA% views.
The application is set to read both the ALL% and DBA% views. This can be
set using Appliction options. Click on View -->Application options
-->Start Up -->Item and select "Use DBA% views instead of ALL%
views".
22.
How is SQL history different from SQLEditor session buffer?
Version 1.4.7 of Guggi Oracle has the ability to save executed SQL
statements in the buffer of SQLEditor window. You can retrieve the SQL
statement by clicking the right arrow or left arrow keys on the SQLEditor
toolbar. The number of SQL statement to be saved in the buffer are set by the
user via Application Options.
Click on View -->Application options -->SQLEditor -->Item
Once the user closes the SQLEditor window, the buffer for the window is
cleared and all the SQL statements are removed from the buffer. However, all
the SQL statements are saved in SQL History and can be retrieved by clicking
on the appropriate button in the SQL Editor toolbar.
23.
I was running a query and my computer system crashed. The SQL was a long
statement and I forgot to save it. Is the statement lost forever and can I
retrieve it?
Every statement that is executed is saved in SQL history. You can retrieve
the statement by clicking on SQL history window (from SQLEditor window) and
selecting the first statement that shows up. This is was the most reent
statement before the system crash.
24. What is Guggi SQL Editor?
Guggi SQL Editor is a stand alone application that runs outside the main
Guggi Oracle application. The application is useful if you want to run only
SQL queries. Also, you can run long queries in Guggi SQL Editor and still be
able to use other features of Guggi Oracle.
25.
Can I execute some long running statements in the background?
Yes. THe DML statements (delete, insert and update) are executed in the
background from SQL Editor.
26.
Is Guggi Oracle a developer tool or a data administration tool?
Both. Guggi Oracle is being developed as a universal tool that can support
the needs of a database developer, DBA or data analyst.
