What is Orange?
Where's the database, there's an orange.
To create a database-based system, developers need tools that make it easier to verify the structure of the data, write SQL, query, create, modify, and develop PL/SQL.
DBAs and consultants also need tuning tools to monitor database performance and improve it.
Orange provides an intuitive and excellent graphical interface, easy to use for DBAs and consultants, as well as developers.
Improve user productivity by making SQL and PL/SQL development and tuning quick and easy, and simplifying real-time monitoring and general database administration.
Orange is the only solution that supports Oracle, DB2, SQL Server, SYBASE IQ, SYBASE ASE and altibase domestic DBMS, Tibero, PetaSQL. Database development and performance management tool.
Main advantages
- Intuitive and easy-to-use GUI
- Provides easy search, edits and saves lob data function
- Unicode support for use in multilingual projects
- Provides real-time session-level monitoring
- Performs multiple tasks simultaneously with a multithreaded framework
- Provides color and label configuration function to distinguish each session when connecting multiple sessions
- Provides statistical information of the execution plan actually executed without the use of TRACE
Ade Orange
- Intuitive and easy-to-use GUI
- Unicode support for use in multilingual projects
- Performs multiple tasks simultaneously with a multithreaded framework
- Enhanced color and label configuration function to distinguish each session when connecting multiple sessions
- Uses multiple DBMSs at the same time
- Schema Browser to quickly and easily capture information about database objects
- Convenient development of SQL syntax
- Table editor, loader, unloader to help change data
- ER viewer to create, compare, and analyze entity relationship diagrams
- Object report to generate multiple object specifications in the report form
- Script function for creating multiple database objects
- Function to provide syntax, function, and hint to help write SQL
- Other useful development tools
Standard
- Easy editing of the DBplan Xplan function of LOB, XML, and Geometry data that shows the actual execution plan
- Tuning Advisor feature to suggest SQL statement tuning comments
- Automatic display of objects or words available in the schema when creating SQL statements
- Organize to distinguish the development or operation session by displaying label and color for each database session
- SFTP support in real-time tracking, plant visualization
- Schema Browser to quickly and easily capture information about database objects
- Convenient development of SQL or PL/SQL statements
- Tuning Advisor feature to suggest SQL statement tuning comments
- Table editor, loader, unloader to help change data
- ER viewer to create, compare, and analyze entity relationship diagrams
- Object report to generate multiple object specifications in the report form
- Script function for creating multiple database objects
- Function to provide syntax, function, and hint to help write SQL
- Other useful development tools
- SQL Monitor lets you quickly and easily identify Top N SQL that causes degradation in SQL performance in database memory
- Session Monitor makes it easy to troubleshoot sessions by querying the list of sessions connected to the database with multiple options.
- Provides session and process information, related reversal threads, and transaction status for all running transactions.
- Provides lock and lock tree information generated by each session
DBA
- Real-time session-level monitoring using ASH
- Easy editing of LOB data, XML, and geometry - DBMS XMS function showing the actual execution plan
- Tuning Advisor feature to suggest SQL statement tuning comments
- Automatic display of objects or words available in the schema when creating SQL statements
- Organize to distinguish the development or operation session by displaying label and color for each database session
- SFTP support in real-time tracking, plant visualization
Reorg Edtion
Reorg is the reorganization of tables and indexes in a database. The disk space used by the database is increased in data fragmentation due to frequent inputs, modifications, and deletions, resulting in an increase in disk waste. In this case, try rearranging. Reorganizing the reorganization can also improve the performance of disk block access.
System Requirements
A 64-bit processor (also known as x86-64, x64, x86_64, AMD64, and Intel 64)
2 GB of RAM.
8 GB of disk space.
A screen capable of resolution of 1024 x 768 or higher
