Benefits

Wait Event Monitor

• Monitoring sessions assigning maximum 8 wait events concurrently

• Providing session lists occurring for assigned wait events

• Interfacing to Plan Tool for the query by double clicking the session list

Data Generation Tool

• Selecting a data generation method according to the column format and generating data randomly as many as the assigned numbers

Stats Manager

• Collecting statistics information using the DBMS_STATS package

Database Server

Oracle 7.3 and higher  

New Features

Schema Browser

• Directory, Queue, Scheduler, Job, Dimension Tap

SQL Tool

• Outputting all query results as a Grid Result in case of executing more than 2 statements

• Changing a Layout, the result window as Drag & Drop

Description Tool

• Searching object source based on source

• Searching segment data size (table, index, snap shot)

• Oracle 11g Support

Export / Import Tool

• Oracle 11g Data Pump Support

System Requirements

Operating System • Windows NT • Windows 2000 • Windows XP • Windows 2003 • Windows Vista • Windows 7

Installation Capacity  • 70MB

 ▶ Overview

As a database-client software, Orange is the tool to more exactly and quickly manage and develop database for database administrators and developers. It is easy to use for database administrators as well as developers and provides the reason and information of issues in time offering light and intuitional GUI interface. Also, it is possible to execute more than 16 designed to be minimized for resource consume without server load and you can use DB from Oracle to Altibase without any difficulty. Furthermore, it supports Instant Client, Data pump and AWR Report of Oracle. Orange is the only solution which supports all DBMS such as Oracle, DB2, MS-SQL, SYBASE IQ, SYBASE ASE, Altibase, Tibero and Telcobase. It has been upgraded for 13years consistently since it released 1.0 version in 2001 and now V. 6.0 is released and commercialized. It provides that it is the optimized solution for enterprises operating database thorough more than 200,000 users.

Development

Data structure checking & object management, SQL query writing, PL/SQL editing & debugging, execution and optimization

Monitoring

Malicious SQL extraction, Issued session confirmation and Monitoring Lock/Latch

Tuning

Malicious SQL improvement, improved performance and Top-N SQL analysis

DBA

DB operating status checking, key statistics information management and data recovery

▶ Functions

DBA Edition

Orange 6.0 DBA Edition can be utilized of all functions for Orange. It meets users’ various requirements and supports stable database operation and management function. Furthermore, it supports to be able to understand needing key information for operating databases such as all sorts of statistics information, security information, Health Check, reports and so on at a glance.

Instant Monitor

It displays the most important and favorite key statistics information among various statistics information related to server operation as 9 graphs so it helps to figure out the current server status at a glance.

Wait Event Monitor

It monitors the wait events when the performance is temporarily degraded. It displays the wait event data to show their changes at the refresh interval in seconds to the list, graph and chart.

Space Manager

It provides functions to check the overall status for the physical, logical location and the usage status per segment clearly and to manage it systemically.

Security Manager

It provides functions to search defined users and privileges and etc related to security in various viewpoints easily and to manage the information in real-time.

Stats Manager

It provides a function to generate statistics information for segment object like table, index and cluster easily.

Health Check

It categorizes (General, SGA, Wait Event, I/O, Space, Access Type, MTS, OPS) the services requested by a client after the database is executed and displays it as HTML format.

Log Miner

It searches the Redo Log saving the modified contents of databases as various options and recovers the changed things through Update, Insert and Delete

AWR Manager

It is usually used by database administrators and monitors database performance as a report format. It has various report sorts such as ADDM(Auto Database Diagnostic Monitor), AWR(Automatic workload Repository), AWR SQL, AWR Diff and ASH(Active Session History).

ER Viewer

Expresses a relationshipof all existing entities in Schema using a diagram. Properties of entities and specific attributes are also able to be found out at a look. Scripts => Entity Relation Diagram

      SQL automation

Provides SQL automationwhich shows objects or available words to use in Schema when filling SQL statements in.

   Supports forSecure-FTP                             

Supports a improved SFTP for security at the “Trace, Plan view” as well asgeneral FTP.

          Object Report

Since objects can begenerated in user-defined report form, it is possible to manage documents systematically using outcomes. In addition to this, basic report forms for Table Report/View Report/Object List Report are provided, and also provides a function to manage reports generated by a user additionally.

Schema Browser

As a package of schema object (Table, Index, Trigger, Constraint, View, Synonym, Sequence, Procedure, Function, Trigger, User), it provides the directory object and the table space information which is one of database factors that users often see. Also, it has functions to search and create multiple objects and modify objects per the characteristics.

Template Browser

It arranges the DML, DDL, PL/SQL, PL/SQL Control Structure, Pseudo Column, SQL Function and SQL Optimizer Hint lists in a tree form so that the users can easily generate the command without having to worry about the complex command rule. Double click a command to create the template in the editor window of the SQL tool. Also, it focuses on convenient and easy generation in case of SQL writing by opening Template Browser as a separate window.

SQL Tool

It provides the functions to create and execute the SQL and save procedure as well as to check the result. The double frame at the top and bottom allows the result to be checked in real-time while editing. It can be executed all at once, sequentially or only the selected SQL statements.

PL / SQL Tool

As a tool to quickly generate PL/SQL procedure, function or package to help application development and database tuning, PL/SQL Tool has functions for debugging and compiling and it provides a source lock function. It guarantees the exclusiveness of the source to users in the same time.

Plan Tool

It provides the real time Trace information for SQL statements and multiple execution plans. Also, you can compare execution plans of SQL statements returned for same results conveniently. Besides, it provides details of schema object included in query.

Table Editor

It provides data editing (delete, insert and update) of the accessible table, selecting of partial data according to condition and saving.

Trace Tool

As it provides the parsing information and execution plan data in real time by analyzing the trace file of local DB or remote DB, it helps more quickly tuning SQL(s) which has negative effects by extracting SQL occurring of inefficient database access or huge physical disk I/O.

Description Tool

It provides details including the configuration script for multiple database objects such as table, view, stored procedure and etc in database and search function based on object name, created date and changed date.

Database Information

It displays the operating environment parameter configuration information including the database version and it can be adjusted on the UI.

Data Dictionary Tool

It categorizes various views existed in Oracle according to characteristics and roles, and provides the descriptions, so that users can easily understand and query various views.

Query Builder

It helps the application program developers, database administrators and general users to generate the logical database object model in the GUI environment. The queries can be generated by adding the objects or setting the relation between objects, and the queries can be added or changed using the Select, From, Where, Group By, Having, and/or Order By tabs described below.

Network Configuration Tool

It supports SQL*Net network configuration from a client and provides a function to easily execute Ping test, TNS Ping test and Oracle connection test.

SQL Monitor

It provides a function to find malicious queries through various search conditions such as execution time, the number of blocks read, the number of blocks read for each unit execution and the number of execution in the SQL statements stored in the memory.

Session Monitor

It searches the list of the connected sessions in the database as multiple options and provides the SQL statement which is running by a certain session, Transaction/Lock/Latch event generation and session statistical data.

Import Tool / Export Tool

It is a tool providing GUI to import and export data conveniently using Imp, Exp utility and Data Pump provided by Oracle.

Load Tool / Unload Tool

It is a tool to store the existing data in a text/excel file to table and it provides multiple options to load data. Unload Tool is a tool to unload the existing data in table as TXT/CSV/XLS files.

Data Generation Tool

It generates arbitrary data and inserts them in a desired table. It supports random numbers (integers and real numbers), random character string, formatted character string, random dates and so on.

Script Generation Tool

It generates objects owned by users to a script file. Object Type can be selected for a script and it can filter the selected Object Type.

▶ The Ten Reasons Why You Should Choose Orange

1. DB application program development and performance management tool with the most

    reasonable price.

2. Proven Tool with more than 200,000 worldwide customers

3. Lower PC Memory Resource Use Compared With Competitor Products

4. Included all key functions of competitor

5. Providing the real time Trace Information and Various Execution Plans for SQL statements

6. Dedicated SQL Monitor Tool for Query Tuning

7. Integrated Graph of Data File Information

8. Various UI Options for users

9. Automatic and Real Time Malicious Query Trace

10. Integrated View for session information