1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
TOra - Toolkit for Oracle
=========================
Copyright (C) 2003-2005 Quest Software, Inc (http://www.quest.com/)
Portions Copyright (C) 2005 Other Contributors
For information about license see the LICENSE file. It is distributed under GPL
which basically means that any derivatory work must be released under an open
source license as well.
TOra is supported for running with an Oracle 8.1.7 client installation. It also
probably works with any 8.x and 9.x client installation, but this is unsupported.
It can access any Oracle version from 7.x and upwards. The only supported server
versions are 7.3.x and 8.1.x though. Oracle 8.0.x and 9.x is NOT supported
although they probably work. (10g has been verified to work fine on Linux)
Toolkit for Oracle is a program for Oracle developers and administrators. The
features that are available so far is (As of version 1.2):
* Handles multiple connections
* Support Oracle & MySQL
* Advanced SQL Worksheet
* Explain plan
* PL/SQL auto indentation
* Statement statistics
* Error location indication
* SQL syntax highlighting
* Code completion
* Visualization of result
* PL/SQL block parsing
* Statement statistics comparison
* Schema browser
* Table & view editing
* References & dependencies
* Reverse engeneering of objects
* Tab & tree based browsing
* Object & data filtering
* PL/SQL Editor/Debugger
* Breakpoints
* Watches
* Line stepping
* SQL Output viewing
* Structure tree parsing
* Server tuning
* Server overview
* Tuning charts
* Wait state analyzer
* I/O by tablespace & file
* Performance indicators
* Server statistics
* Parameter editor (P-file editor)
* Security manager
* Storage manager with object & extent viewer
* Session manager
* Rollback manager with snapshot too old detection
* SGA and long operations trace
* Current session information
* PL/SQL profiler
* Explain plan browser
* Statistics manager
* DBMS alert tool
* Invalid object browser
* SQL Output viewer
* Database/schema comparison and search
* Extract schema objects to SQL script
* Easily extendable
* Possible to add support for new or older Oracle versions without programming.
* SQL template help
* Full UNICODE support
* Printing of any list, text or chart
For installation instructions se the file INSTALL.
TOra is developed by a community of Open Source developers. The original
(pre 1.3.15) development was done by Henrik Johnson of Quest Software, Inc.
The homepage for the TOra project is http://tora.sourceforge.net. If you
encounter problems you can find both mailinglists and bugtracking tools
from this page.
Oracle is copyright of Oracle Corporation.
Supplying patches to TOra
=========================
Even though TOra is an open source GPL project it is also a commercial
project for the Windows platform. Both these projects are compiled
from the same codebase. Therefore any patches that are to be accepted
by me into the project must adhere to one of the following three
conditions.
1. The code given is public domain without any associated copyright.
2. The copyright of the code given is assigned to Quest Software, Inc.
3. The code is licensed under LGPL and part of a separate library.
Since most patches are a few lines of code which are part of files
which have an assigned copyright at the top of the files if nothing
else is specified the second alternative is assumed (Because the files
in question does have a copyright at the top of them and nobody
bothered changing them).
This policy will be changing as soon as the product is ported to a
GPL'd version of Qt for Windows, at which time contributors will
retain copyright to their own contributions to the project, guaranteeing
that it will remain free.
|