Caché Monitor 1.64

Free Caché Monitor screenshot fileWorks with Windows Vista5 stars award!
Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like: Advanced SQL Query Editor,Cache-SQL Syntax highlighting,SQL Code completion,SQL History buffer for executed SQL commands,SQL Code formatting,Graphical SQL execution plan and more.
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion allows you to type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense). Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as `.` or `,` in an SELECT list. After typing the keyword ON in a JOIN clause, Cache Monitor displays foreign key join suggestion
Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ("Format SQL"). The also supports of course: Undo/Redo and Search and Replace.
With Hyperlink navigation you can simple navigate from the editor to Tables metadata. When you presses the CTRL key and hovers the mouse cursor over a certain code element, the element is changed to a hyperlink. When you holds the CTRL key and clicks on the hyperlink, the "go to Tables metadata" action is performed.
Type : Freeware » EULA
OS Support : Windows All + Vista
Date stamp / Size : Nov, 25. 2006 / 8878 kBytes
Asked : Java Runtime Environment 6.0 (JRE 6.0)
Users' value : - Write a Review
Download Caché Monitor fileNo active image buttonImage of Caché Monitor
Update history of Caché Monitor
v1.64 (April, 19. 2012)
Fixes some bugs and clarified the import and export handling. Please see Readme for details
v1.60 (June, 11. 2010)
The new release can use simultaneous different driver versions. To make it easier for the user Caché Monitor comes with 4 configured Caché Driver
v0.58 (October, 27. 2009)
Sql script variable substitution supports the definition of complex default values. And some more fixes
v0.55 (October, 11. 2009)
New Version with better SQL Code format.In Caché Monitor 0.55 the function Reformat Code is working with special InterSystems Caché keywords like %ID.
v0.54 (July, 21. 2009)
The new main feature in Cache Monitor 0.54 is the profiling of sql statements. Specifically for SQL analysis InterSystems added in Caché 2008.1 the %SYSTEM.PTools.SQLStats class and measures lines of code,global references, times run and duration of run e.g. These information are used in Caché Monitor 0.54 to implement the Profiling feature.
v0.52 (June, 15. 2009)
Cache Monitor 0.52 with powerful export to write text files (CSV), XML, HTML or SQL. All tables can be exported into a directory with a single command
v0.51 (April, 2. 2009)
Cache Monitor 0.51 with faster startup and more filter functions available from the context menu.
v0.41 (December, 5. 2008)
V 0.41:
* Workaround for Nullpointer on apple maschine
* The default user and password is set for the default connection from Caché Monitor to Caché at localhost
* If execution plan parsing fails, the html version is displayed --> see forum message for more details
* For backward compatibility is this version compiled with Java 5
What that means? You can run Caché Monitor with Java 5 but also using Java 6. Please use the right (jdk5) driver!
* Better support for big sql script files
* Changed separator from "GO" to ";"
* New SQL Formatter and SQL Parser
* Runtime/Execution information is displayed on the message panel
* Some minor bug fixes
v0.40 (May, 25. 2008)
V 0.40:
Query Analyzer
- Executing stored procedures with CALL no longe raise exception if the resultset is bigger than 99 rows and the option "block fetch" is used.
- Better code complition in some situations

Server Navigator / Table Browser
- Max Rows and Max Chars can now be configured. Max Rows limit the rows fetched from server. Max Chars limit the size of charfields fetched from server

V 0.39:
This Version is a minor release for better support for Caché 2008.1
and his JDBC Driver. Use Java Runtime Environment 6!! AND Caché JDBC Driver for Java 6 !!
v0.38 (February, 2. 2008)
V 0.38:
Query Analyzer
- The selected commit mode is now stored in query analyzer.
Distribution permissions for Caché Monitor
The freeware version of Cache Monitor can be freely distributed over the internet in an unchanged form
Featured Caché Monitor 1.60 Vista Files

...Priodata Query Plan is a front-end...views to investigate SQL execution performance in...SQL view) and the...complete SQL statement and its...execution plan (taken from V$SQL_PLAN)....together with the execution plan, improving analysis....queries and joins. Query Plan really improves...the process of tuning Oracle applications. This...

...Query Master is a...fast multi-threaded SQL and PL/SQL tool...for developers and database administrators. Features: script...library; SQL and PL/SQL editor;...objects; powerful grid; SQL statement execution plan;...popup window with database objects; script import;...

...Export Query to SQL for Microsoft SQL...results of a query execution as a...set of INSERT SQL statements. Predefined or...options make this tool flexible. The program...handy utility helps database developers and database...to create query-based SQL script within seconds....

...Fast! is a tool to automate the...associated with the SQL tuning process on...of all alternative query versions you create...during the tuning process, run them...EXPLAIN PLAN, capture plan from V$SQL_PLAN, set...statistics results and execution plans) in a...interface to Oracle10g`s Tuning Advisor functionality. Select...

...Universal SQL Editor is a lightweight...Intellisense-enabled database query tool. It allows...connect Oracle, DB2, SQL Server, Sybase and...and edit complex SQL with Intellisense-like autocompletion,...hinting, syntax highlighting, SQL formatting, plus other...efficiently. In additional, query results returned by...