oracle sql performance tuning
Aircraft Motor Performance 0.2
Aircraft Motor Performance is a powerful program that makes it quick and easy to calculate propeller thrust and power required for electric power systems for R/C aircraft. more>> Aircraft Motor Performance 0.2 is a powerful program that makes it quick and easy to calculate propeller thrust and power required for electric power systems for R/C aircraft.
Enhancements:
- Added motor pop-up menu that is initialized via motors.txt, a text file that must be co-located with the application.
- Added volts per cell to battery configuration.
- Added 500 mA load to speed control when use B.E.C is selected.
- Added auto calculate check box.
Color Oracle for Mac 1.1.1
Color Oracle applies a full screen color filter to art you are designing. more>> Color Oracle takes the guesswork out of designing for color blindness by showing you in real time what people with common color vision impairments will see. Color Oracle applies a full screen color filter to art you are designing independently of the software that you are using. Eight percent of all males are affected by color vision impairement make sure that your graphical work is readable by the widest possible audience.
Seeing is believing! Instantaneously identify and correct problem colors in your art using Color Oracles system-wide menu accessible in any program.
New:
Color Oracle 1.1.1 fixes a few bugs on all platforms (25 February 2008).
Color Oracle 1.1 now runs on Windows and Linux (20 February 2008).<<less
Oracle SQL Developer 1.5.4.59.40
Graphical tool that enhances productivity and simplifies database development tasks. more>>
Graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.
SQL Developer can connect to any Oracle Database version 9.2.0.1 and later. We support SQL Developer running on Windows, Linux and Mac OS X.
Oracle SQL Developer enhances productivity and simplifies ...Oracle SQL Developer is a powerful graphical application that enhancesPerformance Co-Pilot 2.5.0
Performance Co-Pilot - Toolbox for distributed systems or processes more>>
PCP metric streams can be viewed graphically in real-time, logged to an archive, or processed by an inference engine for automating operational decisions.
Enhancements:
- These PCP packages for MacOS X, contain porting modifications not found is SGIs original source code release - details are available at http://reliable.sourceforge.net
- This distribution of PCP 2.5.0 also includes PCPMon 1.3.4, used for graphically monitoring metric streams in real-time.
Adobe InDesign Long Document Performance Updater 2.0.2
Resolves InDesign 2.0.2 slow text recomposing issues. more>>
Oracle JDeveloper 11.1.1
Oracle JDeveloper - a J2EE and XML development environment with end-to-end support for developing applications and Web services more>>
We spent more time than ever in this release listening carefully to what our users need in order to make them more productive. We also embarked on an intensive design and usability review by an external company.
The result of these efforts is a huge leap forward in the speed in which developers can create, assemble, and reuse components to build rich, interactive applications that are highly performant and easy to maintain.
Enhanced use experience
There have been many updates throughout the product to make working with JDeveloper a pleasant experience. These improvements are not restricted to a particular type of development, but have been applied consistently to all areas of the design time.
Enhanced navigator: The Application Navigator has been enhanced to organize your application the way you want. New categories make it easier for you to find what you are looking for. Collapsible panels put common elements of your application within easy reach. Files that make up a composite node are conveniently exposed by simply clicking on the composite node.
Improved Component Palette: The component palette now features collapsible panels and divider sections to organize related components. A quick search field is provided to help locate components. You can now add commonly-used components to your Favorites list for easier access later, and another panel keeps track of your recently used components.
New Property Inspector: The Property Inspector has been redesigned with a new, user-friendly layout. Property categories have been used consistently throughout the product to make using the Property Inspector more predictable.
Application Overview: The new Application Overview window provides a convenient listing of all the sources for your application, grouped into helpful categories. From here, you can get a sense of the overall status of your application (which sources are incomplete, which have errors, etc) too. The Application Overview also functions as a way for you to learn about the various kinds of components you may use in your application, and easily launch wizards to create them.
File List: The File List makes it easier than ever to locate source files that are part of your project. You can search by file name, file extension, status, date modified and more.
Updated appearance: The JDeveloper development environment has been updated with a brand-new look.
Integrated modeless editors: Many editors for components have been converted to integrated modeless editors. These appear in the editor area along with the other editors, and allow for much more productive navigation.
Contextual linking: Contextual linking is the concept that as you are working on something, you should be able to easily get to relevant related resources. For example, as you are working on defining a page flow for databound pages, you should be able to easily get to the page definition of those pages. This concept is now employed wherever it makes sense in the development environment.
Resource Catalog
The Resource Catalog is your window onto the many disparate resources your application may need to consume. It allows you to define connections to the resource providers, and drag-and-drop those resources into your application as needed. The resource catalog provides a search tool to search all the defined repositories in a single action.
Connections can be created for the following types of resource repositories:
Application server
Database
File system
UDDI Registry
URL adapter
WebDAV
New diagramming framework
The internal diagramming framework used to build the UML tools in JDeveloper, the Page Flow diagrams, and other visual editors has been re-architected to be more flexible for internal consumers.
Java Coding and Agile Development
New code generators
New generators have been added for generating equals and hashcode and to simplify generating fields and properties with getters and setters and to generate constructor from fields
Updated JUnit 4.0 support
JDeveloper now generates unit tests using JUnit 4 annotations. The integrated runner has been updated to support JUnit 4, including new instructions, such as @ignore.
New profilers
The new profilers leverage JVMTI and therefore run on any certified Java VM. Oracles OJVM is no longer required for profiling.
CPU Profiler
Memory Profiler
XML Compare
Comparing of XML files is now done using an XML-aware algorithm. In previous releases compare was done using a line algorithm with no understanding of the syntax of the file content. XML is used extensively within JDeveloper (projects, diagrams, ADF artifacts) and the characteristics of the file content will be understood by the tool.
For example if an XML elements attributes are reordered the compare tool will not mark that as a change - the attributes (name and value) are the same, but in different positions.
The compare tool is used by all the version control extensions to compare file content with previous versions. Compare is also used by the local history feature to compare content between saved points.
Enhanced Merge Conflict Resolution for Subversion and CVS
JDeveloper now provides an enhanced XML-aware interactive GUI to browse and update unresolvable conflicts reported during the merge process.
Apple Xsan Tuner 1.0
Apple Xsan Tuner - Test data & video transfer of san networks more>>
Use Xsan Tuner to see if your SAN can handle planned workloads before you put it into production use. An Xsan Tuning Guide is provided along with the application to help understand the Xsan Tuner results as well as provide configuration suggestions to optimize your SAN performance.
SDE for Oracle JDeveloper (Community Edition) 1.1
SDE for Oracle JDeveloper (Community Edition) is a simple to use, yet sophisticated UML CASE tool/plug-in tightly integrated. more>>
SDE for Oracle JDeveloper (Community Edition) 1.1 is a simple to use, yet sophisticated UML CASE tool/plug-in tightly integrated. This UML CASE tool supports full software development lifecycle - analysis, design, implementation, testing and deployment. This UML tool helps you build quality applications faster, better and cheaper. You can draw all types of UML diagrams in JDeveloper, generate Java code, reverse engineer Java code to class diagrams and generate documentation.
Other UML Modeling Tools / UML Plug-ins: Java Platform (Windows/Linux/Mac OS X):
- SDE for Oracle JDeveloper
- SDE for IBM WebSphere (WSAD)
- SDE for Borland JBuilder
- SDE for IntelliJ IDEA
- SDE for Eclipse
- SDE for NetBeans
- SDE for Sun ONE
Major Features:
- The latest UML support (use case diagram, sequence diagram, collaboration diagram, object diagram, class diagram, statechart/state diagram, activity diagram, component diagram, deployment diagram)
- Use case modeling (use case description, scheduling...)
- Textual analysis for identifying candidate classes, use cases, actors, flow of events...
- Business Workflow diagram
- CRC Card diagram
- Reverse engineering - code to model, code to diagram (Java to UML models, Java to UML diagram)
- Instant Reverse for XML, XML Schema, Dot NET dll/exe, C++, CORBA IDL
- Code Generation - generate code, model to code, diagram to code (UML to code, UML model to Java)
- Incremental round-trip engineering
- Automatic synchronization between source code and diagrams
- Plug-in and template
- Automatic diagram layout - rearrange classes and connectors in UML diagrams in different styles
- Import/export XMI
- Import Rational Rose
- Export diagrams to SVG, PNG, JPG
- Microsoft Visio Integration - draw UML diagrams with MS Visio shapes
- Report generator for generating UML documentation to HTML or PDF
- Version control
- Multilingual support
Spymac Tunes 1.0
Spymac Tunes - free iTunes integration for Spymac more>>
The iTunes integration is no longer a Club-only feature, Spymac Tunes allows any Spymac member to automatically update what song they are listening to.
Lucy Tuning 1.0a1
Lucy Tuning is a highly-efficient, high-quality utility which can visualise the topology and hear the structure of musical harmony. more>>
Lucy Tuning 1.0a1 is a highly-efficient, high-quality utility which can visualise the topology and hear the structure of musical harmony. This application displays and sounds musical pitches. Chords in C may be selected and notes added or removed to visual and appreciate the structure of all meantone tuning systems. Of interest to students, musicians, artists, systems analysts.
to emulate Japanese, Indonesian, Chinese, Indian, Arabic (makam) and any conceivable tuning ... used with this very specific meantone tuning system. This enables users to progress beyond theOracle Berkeley DB Java Edition 3.3.82
High performance transactional storage engine. more>> High performance transactional storage engine.
Oracle Berkeley DB Java Edition is a high performance, transactional storage engine written entirely in Java. Like the highly successful Berkeley DB product, Berkeley DB Java Edition executes in the address space of the application, without the overhead of client/server communication.
It stores data in the applications native format, so no runtime data translation is required. Berkeley DB Java Edition supports full ACID transactions and recovery. It provides an easy-to-use, programmatic interface, allowing developers to store and retrieve information quickly, simply and reliably.
Main features:
- Local, in-process data storage.
- Schema-neutral, application native data storage.
- Keyed and sequential data retrieval.
- Easy-to-use Java Collections API.
- Persistence API for accessing Java objects.
- Single process, multi-threading model.
- Record level locking for high concurrency.
- Support for secondary indexes.
- In-memory, on disk or both.
- Configurable background cleaner threads re-organize data and optimize disk use.
- Full ACID compliance.
- Selectable isolation levels and durability guarantees, configurable on a per-transaction basis.
- Managed transactions using the Java Transaction API (JTA).
- J2EE application server integration using J2EE Connector Architecture(JCA).
- Provides support for monitoring, auditing and administration using the Java Management Extensions (JMX).
- Catastrophic and routine failure recovery modes.
- Timeout based deadlock detection.
- Hot and cold backups, log file compaction, and full database dumps.
- 100% pure Java for portability and ease of development.
- Single JAR file - easy to install, runs in the same JVM as the application.
- Java 1.4.2 or later Standard Edition JVM required.
- Programmatic administration and management-zero human administration.
- API for routine administrative functions.
- Small footprint 772KB.
- Scalable to terabytes of data, millions of records.
- Source code, test suite included.
System requirements:
-
Enhancements
- Fix a bug that somtimes causes two log cleaner threads (when multiple threads are configured or multiple app threads call Environment.cleanLog) to select the same file to clean. This can result in two attempts to delete the log file after cleaning. The second attempt causes an exception to be traced repeatedly, but no other side effect. The problem is transient and goes away if the Environment is closed and re-opened. An example of the exception is below. The symptom is that this exception occurs repeatedly, and the file is not present.
- Fix a bug that could cause a LogFileNotFoundException when using an XAEnvironment, if a prepared transaction is not ended prior to a crash and then the prepared transaction is aborted after recovering from a crash. [#17022] (3.3.79)
- Fix a bug that prevented deferred-write record deletions from being made durable by Database.sync, if a crash occurs after Database.sync but prior to the next checkpoint. Under rare circumstances this could also result in a LogFileNotFoundException later when accessing the deleted entry. [#16864] (3.3.78)
- Fix a bug that prevents log cleaning from functioning properly when a temporary DB (DatabaseConfig.setTemporary) is large enough to overflow the JE cache. Also fix a bug that could in rare cirumstances cause an endless loop while performing log cleaning. [#16928] (3.3.78)
- Fix a bug that caused an infinite loop under certain timing dependent circumstances when using EnvironmentConfig.setSharedCache(true). This bug was reported in two different forum posts. Thanks to Kevin Jackson and Vyacheslav Lukianov for reporting it! [#16882] (3.3.78)
- Improve output of partial information in DatabaseEntry.toString. Thanks to archie172 for reporting this on OTN. [#16929] (3.3.78)
- Fix a bug in SecondaryCursor.dup that required the cursor to be initialized. This method, like Cursor.dup, may now be called whether the cursor is initialized or not. Thanks to archie172 for reporting this on OTN. [#16930] (3.3.78)
- Fix a bug that caused NullPointerException when opening an XAEnvironment under certain circumstances, when prepared but uncommitted transactions are present in the JE log and must be replayed during recovery. This bug was reported on the OTN forum by Matthieu Bentot -- thank you Matthieu! An example of the stack trace is below.
- Fix a bug that caused LogFileNotFoundException in rare circumstances for an Environment having one or more Databases configured for duplicates (or one or more SecondaryIndexes with MANY_TO_XXX relationships). The bug only occurs when a single secondary/duplicate key value is associated with a large number of records/entities; specifically, the sub-Btree for a single duplicate key value must have at least 3 levels. [#16712] (3.3.76)
- Fix a bug that caused BufferOverflowException while writing transactional records. This could occur if multiple threads were writing to an environment while using the same Transaction. [#17204]
- Direct Persistence Layer (DPL), Collections and Bind packages - Fix a bug that causes the EvolveStats returned by EntityStore.evolve to contain zeros, even when entities are evolved and written, when no EvolveListener is configured. Thanks to jhalex on OTN for reporting this. [#17024] (3.3.78)
SQuirrel SQL Client 2.5
SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database more>>
The minimum version of Java supported is 1.5.x as of SQuirreL version 2.4. See the Old Versions page for versions of SQuirreL that will work with older versions of Java. SQuirreLs functionality may be extended through the use of plugins.
Main features:
Object Tree of Session window
- Right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts.
SQL Editor with code completion popup (ctrl+space) open
- Code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions.
SQL Editor with tools popup menu (ctrl+t) shown
- With the tools popup any editor function can be located with only a single short cut: ctrl+t
- Additionally, the list can be searched incrementally with just a few keystrokes.
SQL Editor with bookmark selection popup (ctrl+j) shown
- Bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements.
Abbreviations and auto corrections dialog
- This feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type sf which will expand to SELECT * FROM.
Editing of SQL results.
- The result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree.
Graph: Charts of tables and their relations.
- To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the Add to graph menu. Graph manipulation functions can be accessed by using the right-click context popup menu.
Graph: Scaling and distributing tables on configurable page sizes to prepare for printing
- Use the right-click context popup menu to switch to the scaling and printing mode.
Enhancements:
- Enhancements
- New plugins provide enhanced capabilities:
- DB2 Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives DB2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- H2 Plugin: Indexes and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives H2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving H2-specific information about them.
- PostgreSQL Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives PostgreSQL-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- Sybase Plugin: Allows the user to reverse engineer to the source code for Views and Stored Procedures displayed in the object tree.
- Added better support for executing large scripts so that SQuirreL remains responsive to UI interaction, as well as providing much faster execution.
- Added custom statement tokenizer framework to allow plugins to control how statements are tokenized.
- Drop tables, Delete Records and Copy Tables features now will order the tables according to Foreign Key dependencies instead of alphabetically by name.
- Oracle Plugin now supports executing create statements for triggers, stored procedures and functions using "/" just as is done in SQL-Plus. Also "@" can now be used to indicate a file to be parsed and executed while running another script in SQL Editor.
- SQL History Dialog allows for searching previously executed statements by regular expression.
- Many bug fixes
Navicat Oracle Lite 8.1.2
Navicat Oracle Lite offers users a useful and user-friendly Database administration tool for Oracle. more>>
Navicat Oracle Lite 8.1.2 offers users a useful and user-friendly Database administration tool for Oracle. It works with any Oracle Database Server from version 8i or above, and supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to Oracle.
Benefits:
- Latest Oracle Versions Support: Navicat for Oracle a powerful Oracle Database Server administration and development tool. Highlights of supported features:
-
- Support of Oracle versions 8.1.7 or above
- Support of Multiple Connections to local or remote Oracle Server
- Support of Unicode / Character Set
- Support of Triggers and Foreign Keys
- Support of Views and Stored Procedures creation
- Support of Oracle Objects like Directory, Synonym and Materialized View
- Additional Connection Options
-
- Native Connection Options: Navicat for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode and alias entry from a tnsnames.ora file in TNS mode.
- Other Connection Options: You can set the role for user to connect with Default, SYSOPER or SYSDBA system privilege. Besides, you can pass control of user authentication to the operating system by means of OS authentication option.
- Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.
- Comprehensive Management of Oracle objects
-
- Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, triggers and privileges: With Table Designer the basic Navicat for Oracle tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, triggers, privileges and much more.
- Support of tablespace, package, sequence, synonym, trigger, type and more: Navicat allows you to create, edit and drop directories, tablespaces, publice database links, public synonyms, database links, indexes, materialized views, materialized view logs, packages, sequences, synonyms, triggesr and more.
- SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
- Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
- View Schema / Table Structure: Present the schema / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
- Diversified Import and Export Competence
-
- Import data up to 5 most popular formats including XLS, CSV, TXT, DBF and XML: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
- Export Data to different file formats: TXT, CSV, DBF and XML: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
- Powerful Data Manipulation Tools
-
- Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
- Data and Structure Synchronization: You can transfer data from one Oracle schema to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target schema can be on the same server as the source or on another server.
- Support of Data Transfer between local / remote Oracle schemas: Transfer tables/views/stored procedures/functions/sequences from one Oracle schema to another, or to a plain text file.
- Create Schedule for Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Data Transfer, Data Synchronization, Import and Export.
- Powerful Security Management
-
- Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, delete, edit users / roles, and grant privileges on the selected schemas, tables / views, fields and stored procedures.
- Well-Designed Visual Builder / Editor
-
- Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
- Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
- Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
- More great features
-
- Virtual Grouping: Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure/Function and Schedule.
- Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and/or modify the properties of Oracle servers.
- SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
- Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
- Oracle Objects Management
- Support Oracle servers 8i or above
- Create/drop schemas
- Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions
- Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
- Managing tablespaces, public database links and public synonyms
- Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
- Support of physical attributes
- Support of character set and unicode
- Connection Management and Navigation
- Multiple local/remote Oracle server connections
- Support of Basic Connection
- Support of TNS Connection
- Connection to Oracle server through SSH
- Data Viewer and Editor
- Grid view
- TEXT, Hex and BLOB/BFile viewer/editor
- Copying and pasting selected records
- Customize display formats
- Incremental search, sorting and formatting table grid
- Ability to show/hide ROWID
- Ability to set number of records showing on each page
- SQL Processing
- Ability to create parameter queries
- Multiple SQL editors with syntax highlighted feature
- Ability to preview SQL before execution
- Server Security and Maintenance Services
- Visual user manager to administer users, roles and privileges
- Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics
- Other Useful Features
- Empty/truncate tables
- Backing up schema/table to SQL script
- Executing SQL script
- Create table/view shortcut on desktop
- Support of docking/tab windows
- Ability to run profile from command line
- Log files: keep track on the actions that have been performed in Navicat
- Ability to copy Connection Information into Clipboard
- Improvements: Improved the stability when running a query.
- Bug Fixes: Some windows size and position were not saved after closed.
- Mac OS X 10.3 Panther, 10.4 Tiger or 10.5 Leopard
- Universal Binary
area shows you SQL representation of the oracle objects you are creating. This ability allows ... , Variables or Status icon to show and/or modify the properties of Oracle servers. SQL ConsoleLicense:Freeware
Eclipse SQL 3.5.0 RC8
A thin SQL client that allows you to query and browse any JDBC compliant database more>>
Eclipse SQL 3.5.0 RC8 provides you with a professional and useful thin SQL client which can allow you to query and browse any JDBC compliant database.
Eclipse SQL Explorer supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases. Eclipse SQL started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of the SQuirreL SQL project.
Major Features:
- Oracle Specific Features;
- Query Execution Explain Plan
- Function, JavaSource, Package, Procedure, Sequence and Trigger Nodes
- Session, User, Job, Top SQL and Parameter info for database node
- Source, Info, DDL and XML tabs for most of the nodes
- DB2 Specific Features:
- Query Execution Explain Plan
- Triggers Node in Database Structure View
- Trigger Source Displayed in Database Detail View
- MySQL Specific Features:
- Create Table Script Action
- Logs, Processes, Status, Variables and TableStatus detail tabs
Enhancements:
- Added preference to control sorting of column names in db structure view (feature #2663329, bug #1611426)
- Fixed problem that double click in file search results does not select found line in SQLEditor
- Added preference to show session name in SQL editor title too (feature #2638982)
- Fixed #2687620, general solution triggered from SQLite bug
- Fixed auto completion using table alias (Patch #2643772 by seekforth)
- Some internal changes (Patches #2637474,#2633721,#2633365,#2633298 by joco01)
- New action Generate Insert Statement (Patch #2695812, part of feature #1590278 by a_lazar)
- Fixed #1200935, missing foreign key in create table script (Patch #2708377 by sishi)
- Fixed #2709713, added new preference Log SQL Info Messages to check for SQLWarnings which displays raise info or print messages from stored routines
- Show server info node as root node in db structure view
- Added apache derby plugin (Patch #1612294)
- Internal cleanup for, removed deprecated sources
Silverwolfs SQL Query 2.2.0
Silverwolfs SQL Query - Connect to mysql database & display records more>>
Note: ODBC Support only functions in the windows version at this time.
Main features:
- Run Any SQL Query
- Server Address Book
- Export Records to CSV
- Save Queries as .SQL files
- recent query list
- Column Type Detection
- multi line sql queries
Enhancements:
- Bug Fixes in ODBC Server Entry Screen.
