OrangeIt improves work convenience

集成开发工具

 Can greatly facilitate database management and

User's data access process

Orange是

DBOperations management and development solutions

Through convenient and powerful functions

Fast visual programming front end

以便浏览数据分析和可视化

一、开发商介绍

Ware Valley成立于2001年,is a global software company,It is also the only one in Korea for safety、Administration and operation are provided with simple and quick guidanceDBMS.

Wear Valley主要有DB/SERVER访问控制解决方案（Chakra Max）、DB运营管理/开发解决方案（Orange）、Integrated log management solution（Log Catch）、Security diagnostic management solutions（Cyclone）、DB加密解决方案（Galea）9category of business.One of the main productsOrange,By simplifying and facilitating database administration tasks,使用图形UIFeatures speed up development,This in turn increases user productivity.

迄今为止,Wear Valley管理的DBOperations management and development solutions（Orange）被全球50,000Downloaded and used by many enterprises and organizations.除此之外,Wear ValleyAfter-sales services such as support for preventive inspections and maintenance are also available,High customer satisfaction in the industry.

二、关于Orange

By providing convenient tools to work with databases

Prove optimal solutions for database operations

Orange Ade功能

• 提供直观且易于使用的GUI

• Unicode Support for use in multilingual projects

• 多任务同时执行,Implement a multithreaded structure

• Improved color and label settings,Each session can be differentiated when multiple sessions are connected

• Use multiple at the same time with a single programDBMS

• Schema Browser Get quick and easy access to database object information

• 方便的SQL语法开发

• A table editor to help with changing data、Loaders and Unloaders

• ER查看器,用于创建、Compare and analyze object diagrams

• Generates object reports for various object specifications in the form of reports

• Database object creation script function

• 提供语法、functions and hints to help with writingSQL

• Other handy development tools

Orange Standard功能

• Easy LOB、XML、Geometry Data editing functionDBMS XplanThe function shows the actual execution plan

• Tuning Advisor功能提供SQLStatement tuning advice

• 编写SQLautomatically displayed when the statement is madeSchemaObjects or available words in

• by showing eachDBSession labels and colors to distinguish the organization of development or operations sessions

• 支持SFTPReal-time tracking and planning views,这是Orange的主要功能

• Schema BrowserGet quick and easy access to database object information

• 方便开发SQL或PL/SQL语法

• Tuning Advisor功能提供SQLStatement tuning advice

• A table editor to help with changing data、Loaders and Unloaders

• ER 查看器,用于创建、Compare and analyze object diagrams

• Generates object reports for various object specifications in the form of reports

• Database object creation script function

• 提供语法、functions and hints to help you writeSQL 的函数

• Other handy development tools

• SQL MonitorCan easily and quickly check the resulting database in memorySQLperformance is degradedTop N SQL

• Session Monitor,Query a list of sessions connected to the database by using various options,Session troubleshooting can be easily done

• Provides session and process information for all running transactions、Information about rollback segments and transaction status, etc.

• Provides lock and lock tree information generated per session

Orange DBA版功能

• 使用ASHSession-level real-time monitoring capabilities

• 简易LOB、XML、Geometry data editing function

• Shows the actual execution planDBMS Xplan函数

• Tuning Advisor功能提供SQLStatement tuning advice

• 编写SQLautomatically displayed when the statement is madeSchemaObjects or available words in

• by showing eachDBSession labels and colors to distinguish the organization of development or operations sessions

• 支持SFTPReal-time tracking and planning views,这是Orange的主要功能

Orange Reorganized version function

Orange Reorg Manager是一个有用的工具,Frequent inserts can be digested simultaneously by recreating the table online、Downtime for tables that are fragmented by update and delete operations,This prevents unnecessary disk waste and improves search performance.It's easier than creating scripts manually、更高效,Because it will all index、约束、触发器、注释、Object permissions and statistics are moved into a process along with the table.

此外,Reorg Manager通过利用Oracle自9iprovided since DBMS_REDEFINITIONpackage to ensure stable performance.

三、支持的数据库

• Oracle 7.3或更高版本

• Tibero 3 或更高版本

• Altibase HDB 5或更高版本

• XDB 6.5.1或更高版本

• IBM DB2 UDB 9.1或更高版本

• Sybase IQ 12.6或更高版本

• Sybase IQ ASE 12.5或更高版本

• SQL Server 2000或更高版本

• PetaSQL 1或更高版本

Orange支持哪些Oracle客户端版本

Orange for Oracle v7需要Oracle Client 9.2或更高版本. 

如果Oracle Server版本为12c 或更高版本,则必须安装Oracle Server所需的Oracle Client 版本. 

Orange v6下的Ansi产品需要Oracle Client 8.0.6或更高版本,Unicode产品需要Oracle Client 9.2或更高版本.

Orange for Oracle

从Orange for Oracle 5.0（旧：2009 / 2010）开始支持 Oracle Instant Client. 

OrangeThe setting method of using the instant client is as follows.

1.在菜单【工具】-【orange option】-【常用】-【环境】中将【客户端类型】设置为“Use an instant client”

2. 在[Instant Client Path]中,Specifies the path where the instant client is installed.

3.Run again after exiting orange

4.Created using the network configuration tooltnsnames.ora文件（创建在[Instant Client Path]中指定的路径中）