메뉴 바로가기 본문 바로가기
Orange Database Development and Management Tools
Orange is your trusted partner for handling databases.

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.

KEY ADVANTAGES
  • Equipped with easy-to-use intuitive GUI
  • Applicable in multilingual projects through
    Unicode support
  • Capable of simultaneously carrying out multiple
    tasks due to multithread structure
  • Provides statistical information on execution plans that have actually been carried out without requiring TRACE
  • Provides easily-accessible viewing, editing, and saving functions for LOB data
  • Provides real-time monitoring
    of session levels
  • Provides a function to set colors and labels to differentiate between sessions when connecting multiple sessions
New Advantages
  • Equipped with easy-to-use intuitive GUI
  • Applicable in multilingual projects through Unicode support
  • 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.
AWR Manager This function is generally used by database administrators to monitor database performances in a report format. Report types include ADDM (Auto Database Diagnostic Monitor), AWR (Automatic Workload Repository), AWR SQL, AWR Diff, and ASH (Active Session History) reports.
Data Quality Manager 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.
Supported DB
  • ORACLE