# Integrated development tool that helps all users manage database and handle data quickly and easily, hence enhancing work convenience
# Provides intuitive GUI
# Readily available for developers as well as DBA, administrators, and consultants
# Since its launch in 2001, it has provided many customers and users with convenient tools to handle databases, proving optimal solutions for database operations

Comprehensive database management solution
Provides various tools for development processes for developers

Provides convenience tools for various monitors and performance management for administrators
Orange Ade Edition supporting various DBMS with a single program

Supports online reorganization for DBA
Provides various editions customized to administrators and DBA roles (Standard/DBA/Reorg Edition)

GS certification level 1

Orange Ade

Provides intuitive and easy-to-use GUI
Available in multilingual projects with Unicode support
Performs multiple tasks simultaneously using multi-thread oriented structure
Enhances color and label settings to distinguish each session when connecting multiple sessions
Uses a variety of DBMS simultaneously with a single program
Schema Browser that can quickly and easily grasp the object information of database
Convenient development of SQL syntax
Table Editor, Loader, and Unloader to help change data
ER Viewer to create, compare and analyze object relationship diagrams
Object Report that generates various object specifications in a report form
Various object creation scripts in the database
Provides grammars, functions, and hints to help create SQL
Other convenient development tools

Orange Standard

Easy data editing of LOB, XML, Geometry. DBMS Xplan function that shows the actual execution plan
Tuning Advisor that presents SQL statement tuning opinion
Automatic display of objects or available words in the schema when creating SQL syntax
Organized to distinguish development or operation sessions by displaying labels and colors for each DB session
Supports SFTP in real-time trace and plan view, which are the main functions of orange
Schema Browser that can quickly and easily grasp the object information of database
Convenient development of SQL or PL/SQL syntax
Tuning Advisor that presents SQL statement tuning opinion
Table Editor, Loader, and Unloader to help change data
ER Viewer to create, compare and analyze object relationship diagrams
Object Report that generates various object specifications in a report form
Various object creation scripts in the database
Provides grammars, functions, and hints to help create SQL
Other convenient development tools
SQL Monitor that can easily and quickly check the Top N SQL that causes performance degradation for SQL in the memory of the database
Session Monitor that facilitates session troubleshooting by retrieving a list of sessions connected to the database with various options
Provides session and process information for all running transactions, information about related rollback segments and transaction status, etc.
Provides lock and lock tree information generated in each session

Orange DBA Edition

Real-time monitoring at session level using ASH
Easy Data Editing of LOB, XML, Geometry
DBMS Xplan function that shows the actual execution plan
Tuning Advisor that presents SQL statement tuning opinion
Automatic display of objects or available words in the schema when creating SQL syntax
Organized to distinguish development or operation sessions by displaying labels and colors for each DB session
Supports SFTP in real-time trace and plan view, which are the main functions of orange

Instance Monitor (Database Monitor)

It finds the most important and frequently viewed critical statistics of instance operational management statistics on nine graphs. By supporting the file storage feature, graphs representing past statistics can be rechecked at any time.

Wait Event Monitor

A Wait Event can be monitored in a transient performance degradation situation. It sets the update interval in seconds to provide the feature to view the Wait Event information that changes according to a given time interval at a glance through the list, graph, and chart.

ASH Monitor

It supports real-time monitoring at the session level using ASH (Active Session History) information in the latest 1 hour. When selecting a specific section, Top SQL, Session, and Wait Event information that was performed in the selected section can be used to analyze the failure and the cause of performance degradation not only in the present but also in the past at the session-level. Available to use from 10g.

Space Manager

It provides usage for table spaces and data files in a variety of forms. All the situations can be systematically managed by showing stored segment information by segment type and user which used to be provided by table space.

Security Manager

All security-related information such as user, role, permission, and profile, defined in the database can be easily retrieved from a variety of perspectives, and user information changes can be easily made, including adding a new user and granting/withdrawal of permission.

Stats Manager

In a Cost-Based Optimizer operating environment, statistical information on segment objects such as tables, indexes, and clusters can be easily managed through various options.

Health Check

As an online check service to identify and analyze the cause of database load in terms of performance, and to improve problems, the feature determines the health metrics of key elements for database operation.

Graph & Report

By performing pre-defined/user-defined SQL to grasp database operation status and performance, the results are provided as graphs and reports in various forms.

Log Miner

The Redo Log, which stores the history of changes in the database, can be retrieved with various options and can recover changes such as Update, Insert, and Delete.

AWR Manager

It is mainly used by database administrators and the performance of the database can be monitored in a report format. The report types include Auto Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), AWR SQL, AWR Diff, and Active Session History (ASH) reports.

Data Quality Manager

Analyzes the data defect through the verification of the data itself, and supports analyzing the factors that can cause errors later. Analysis item – Distinct Count / Null Count / Space Count / Minimum Value / Maximum Value / Various data analysis support. It also provides analysis data such as Summary / Pattern / Distinct Value List and Chart based on these element data. The user enters SQL for the business rules required for analysis to register the business rule and provide execution results.

FEATURED +

Provides integrated security function by interworking with Chakra Max and Trusted Orange solution

SUPPORTED DATABASE

Oracle 7.3 or later

Tibero 3 or later

Altibase HDB 5 or later

XDB 6.5.1 or later

IBM DB2 UDB 9.1 or later

Sybase IQ 12.6 or later

Sybase IQ ASE 12.5 or later

SQL Server 2000 or later

PetaSQL 1 or later

Orange Ade

Apache hive

Mysql

Maria

Cubrid

PostgreSQL

Greenplum

PPAS

Teradata

SAP HANA

Orange Standard

Oracle

Microsoft SQL Server

IBM DB2

Sybase IQ ASE

Sybase IQ

Tibero

Altibase

PetaSQL