The Solution for Database Operation and Management, Development Support, Performance Tuning, and Quality Control
Comprehensive Database Management Solution
Orange by Editions
Orange 7.0 for Oracle Toolset
Key Features of Orange for Oracle
Comprehensive Database Management Solution
Orange is a database development and management solution that simplifies database management tasks and accelerates development to enhance productivity.
Convenient Tools for Admins
By providing a variety of monitors, Orange supports practical approaches for diagnosing bottleneck issues in database performance. It also provides a set of tools for resolving other issues. You can also effortlessly manage routine administrative tasks, including making and testing changes to a database, data migration and backups, and resource management.
Boosting Development Productivity
It offers a wide range of tools and practical convenience functions for database development. Shorten the overall work cycle – design, development, debugging, and tuning – to meet business requirements and create a more efficient work environment.
Data Quality Management
Orange provides a quality control function for data analysis. Testing for profiling duplicates and patterns enables the analysis of information, facilitating data cleanup and changes.
FEATURED
Orange Standard
Orange DBA Edition
|
Functions |
Descriptions |
|
Instance Monitor |
You can understand the most important and frequent statistic data in instance operations management with the help of nine different graphs. It enables you to save files, allowing you to load graphs displaying previous statistics at your convenience. |
|
Wait Event Monitor |
You can monitor Wait Events during temporary performance slowdowns. It offers a function to set the update interval in seconds, providing a comprehensive view of changes in Wait Event information over a specified time interval through lists, graphs, and charts. |
|
ASH Monitor |
Supports a real-time session-level monitoring using Active Session History (ASH) information from the last hour. Top SQL, Session, and Wait Event information for the selected interval assists in analyzing not only the causes of current failures and performance degradation at the session level but also those from the past. Available to 10g and above. |
|
Space Manager |
Provides a usage overview of tablespaces and data files in a variety of ways. Segment information is saved and sorted by tablespaces, allowing it to be categorized by segment types, users, or other factors for systematic management, providing better comprehension. |
|
Security Manager |
You can easily access all security-related information, such as users, roles, permissions, and profiles defined in the database from various perspectives. Making changes to user information, including adding new users and granting/revoking permissions, is also straightforward. |
|
Stats Manager |
In a Cost-based Optimizer operation environment, you can effortlessly manage statistical information about segment objects, such as tables, indexes, and clusters, through a variety of options. |
|
Health Check |
It is an online checkup service that derives and analyzes the elements of database load from a performance perspective, aiming to resolve issues and provide a measure for the health of key elements in database operations. |
|
Graph & Report |
Executes predefined/user-defined SQL queries to assess the status and performance of database operations, presenting the results through various types of graphs and reports. |
|
Log Miner |
Views Redo Log, storing the change history of the database, with various options, and offers the capability to recover changes such as update, insert, and delete commands. |
|
AWR Manager |
Primarily designed for database administrators, it enables the monitoring of database performance through the presentation of reports. Report types include Auto Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), AWR SQL, AWR Diff, and Active Session History (ASH) reports. |
|
Data Quality |
It analyzes data defects by verifying the data itself and provides support in terms of analysis for factors that may cause subsequent errors. Analysis items - Distinct Count / Null Count / Space Count / Minimum Value / Maximum Value / Various data analysis support. It also provides analytics such as Summary / Pattern / Distinct Value List and Chart based on these elemental data. Users input SQLs for the task regulations they need to analyze, receiving the results of registering and executing the business rule. |
Reorg Edition
Orange Reorg Manager is a valuable tool that prevents unnecessary disk dissipation and enhances search performance. It achieves this by recreating highly fragmented tables online, a result of frequent insert, update, and delete operations, while minimizing downtime. It moves tables along with indexes, constraints, triggers, annotations, object permissions, and statistics all in one step, offering a much easier and more efficient process compared to creating scripts manually. Reorg Manager also leverages the DBMS_REDEFINITION package that Oracle provides starting with 9i to ensure reliable performance.
Since the reorganization operation is performed online, the downtime of the database server can be minimized, making it suitable for systems that need to operate around the clock.
Operating Environment
Windows 7/8/8.1/10/11
Windows Server 2012/2016
Supported DBMS
Oracle 10g or above
Tibero 3 or above
Altibase HDB 5 or above,
XDB 6.5.1 or above
IBM DB2 UDB 9.1 or above
Sybase IQ 12.6 or above
Sybase ASE 12.5 or above
SQL Server 2000 or above
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved
