Due to the nature of their jobs, developers require tools that allow them to easily check the structure of data, generate SQL, view, create and modify data, develop PL/SQL, and more in order to establish database-based systems. Furthermore, DBAs and consultants require tuning tools to conduct real-time monitoring on and enhance database performances. Orange is a simple and easy-to-use solution for developers, DBAs, and consultants by providing users with outstanding intuitive GUI.It offers quick and easy development and tuning of SQL and PL/SQL, and simplified the real-time monitoring and overall database management process, resulting in increased user productivity.Orange is the only solution to uniformly support not just Oracle, DB2, SQL servers, SYBASE IQ, and SYBASE ASE, but also Korean DBMSs such as Altibase, Tibero, and PetaSQL. Since its release in 2001 under version 1.0, Orange has proven itself time and time again as a database development and performance management tool, and supports over 3,500 companies and 400,000 users around the world.

Capable of simultaneously carrying out multiple tasks due to multithread structure

Provides a function to set colors and labels to differentiate between sessions when connecting multiple sessions

Use various DBMS simultaneously with a single program

Orange Ade Features

A Schema Browser that allows users to quickly and easily identify the object information in the database

Allows for the convenient development of SQL statements

Comes with table editor, loader, and unloader to help with data modification tasks

Comes with an ER Viewer that generates Entry-Relationship Diagrams (E-R Diagram) to help with comparison and analysis

Comes with an Object Report that takes a variety of object specifications and generates them in report format

Comes with a script to generate various entities in the database

Comes with grammar, function, and hint provision to help with writing SQL

Contains other convenient development tools

Supported DB

APACH HIVE

MYSQL

MARIADB

CUBRID

POSTGRESQL

GREENPLUM

PPAS

TERADATA

New Advantages

Comes with easy LOB, XML, and geometry data editing function

Comes with DBMS Xplan, which shows execution plans that have actually been carried out

Comes with Tuning Advisor to suggest SQL statement tuning opinions

Automatically displays objects or usable words within the schema when writing SQL statements

Uses labels or colors to mark according to DB sessions, organizing development or operation sessions to make them distinguishable from one another

Supports SFTP in its main function of real-time trace and plan viewing

Standard Edition Features

A Schema Browser that allows users to quickly and easily identify the object information in the database

Convenient development of SQL or PL/SQL statements

Comes with Tuning Advisor to suggest SQL statement tuning opinions

Comes with table editor, loader, and unloader to help with data modification tasks

Comes with an ER viewer that generates Entity-Relationship Diagrams (E-R Diagrams) to help with comparison and analysis

Comes with an Object Report that takes a variety of object specifications and generates them in report format

Comes with a script to generate various entities in the database

Comes with grammar, function, and hint provision to help with writing SQL

Contains other convenient development tools

Comes with an SQL Monitor that allows users to easily and quickly confirm the Top N SQL responsible for causing performance degradation among the SQL within a database’s memory

Comes with a Session Monitor that views the session lists connected to the database through several different options to easily resolve issues with sessions

Provides information on sessions and processes of all transactions currently running and information on related rollback segments and transactions states

Provides information on lock and lock tree occurring by session

Supported DB

ORACLE

MICROSOFT SQL SERVER

IBM DB2

SYBASE ASE

SYBASE IQ

TIBERO

ALTIBASE

PETASQL

New Advantages

Comes with real-time monitoring function for session levels using ASH

Comes with easy LOB, XML, and geometry data editing function

Comes with DBMS Xplan, which shows execution plans that have actually been carried out

Comes with Tuning Advisor to suggest SQL statement tuning opinions

Automatically displays objects or usable words within the schema when writing SQL statements

Uses labels or colors to mark according to DB sessions, organizing development or operation sessions to make them distinguishable from one another

Supports SFTP in its main function of real-time trace and plan viewing

DBA Edition Features

DBA EDITION FEATURES

Function

Description

Instance Monitor (Database Monitor)

Users can utilize 9 different types of graphs to understand the most vital and often-seen core statistical information among instance operation management statistical information. This function supports file saving, allowing users to check graphs that show past statistical data as needed.

Wait Event Monitor

Users can monitor wait events in cases of temporary performance degradation. Refresh rates can be set by seconds to see information on how the wait event changes during a given time frame at a glance through lists, graphs, and charts.

ASH Monitor

This function supports real-time monitoring of session levels by using ASH (Active Session History) of the most recent hour. Upon selecting a specific time frame, users can analyze the causes for present and past failures and performance degradations on a session level basis through information on Top SQL, sessions, and wait events that took place during that selected time frame. It can be used from 10g

Space Manager

This function informs users on the usage status of tablespaces and data files through various methods. It allows users to systematical manage all types of situations clearly by providing information on the segments saved in table spaces according to segment type and user, so that the users can confirm them.

Security Manager

Users can easily view all security-related matters, such as users, rules, rights, and profiles defined in databases, from various viewpoints, and easily make changes to user information, such as adding new users or granting/rescinding rights.

Stats Manager

Users can easily manage statistical information on segment objects such as tables, indexes, and clusters in a Cost-Based Optimizer operating environment through the use of various options.

Health Check

This online inspection service uncovers and analyzes the factors for database load from a performance perspective, and seeks to troubleshoot the issue. It allows users to check the health of the core factors needed to operate the database.

Graph & Report

This function carries out pre-defined/user-defined SQL in order to get a grasp of the current status and performance of the database’s operation, and provides the results in various forms of graphs and reports.

Log Miner

This function allows users to view the Redo Log, which stores the records of changes made in the database, through a variety of options, and can even undo changes such as updates, inserts, and deletions.

This function analyzes data defects by inspecting the data itself, and supports the analysis of factors that might cause errors. Analysis fields include Distinct Count / Null Count / Space Count / Minimum Value / Maximum Value / Various Data Analysis Support. Additionally, it provides users with materials for analysis such as summaries, patterns, distinct value lists, and charts based on these factors. Once users input the SQL for the business rules necessary for the analysis, the function registers the business rules and provides materials on the results of carrying out the business rules.

Supported DB

APACH HIVE

MYSQL

MARIADB

CUBRID

POSTGRESQL

GREENPLUM

PPAS

TERADATA

SAP HANA

Reorg

Reorg refers to the task of reorganizing a database’s tables and indexes. As inputs, modifications, and deletions become frequent in the disk space used by the database, the increase in data fragmentation results in a waste of disk space. This is when Reorg should be used. With Reorg, users can reorganize their databases and increase performance with regard to disk block access.

What is the Orange Reorg Manager?

The Orange Reorg Manager is a handy tool that manages downtime by taking tables, which have become greatly fragmented due to frequent input, modification, and deletions tasks, and recreating them in online states to prevent unnecessary waste of disk space and improve view performances. As it moves tables, indexes, constraints, triggers, comments, object privileges , and statistic information in a single process, it is far easier and more efficient than manually generating scripts.

Downtime is Minimized as the Work is Done Online

As the Reorganization task is performed online, database server downtime can be minimized, and thus it is suitable for systems that are operated for 24 hours a day.