Warevalley

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

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

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

Orange DBA Edition
function	Explanation
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.

What is Orange Reorg Manager?
Orange Reorg Manager is a useful tool to prevent wasting unnecessary use of disks and enhance retrieval function by recreating table online while handling downtime of tables that are highly fragmented due to frequent insertion, update, and deletion. Using the tool makes the work easier and more efficient than manually creating scripts since it helps integrate index, constraint, trigger, comment, object permission, and statistics into one step. Also, Reorg Manager ensures reliable performance by utilizing DBMS_REDEFINITION package which is provided in Oracle 9i or above.
Minimizes downtime as the work proceeds online
The downtime of the database server can be minimized as reorganization is proceeded online, hence making Reorg Manager suitable for the 24-hour operating system.

FEATURED

FEATURED +

SUPPORTED
DATABASE

DataSheet

FEATURED

FEATURED +

SUPPORTED DATABASE

DataSheet

SUPPORTED
DATABASE