标准版和企业版ORACLE区别中文版

1、bookmarkgo to endoracle9i 功能和高可用性选项the oracle9i database is available as oracle9i standard edition, oracle9i enterprise edition, and oracle9i personal edition. not all features and options are available with all editions of the oracle9i database.oracle9i personal edition is available on windows nt a

2、nd windows98 and includes, at no extra cost, all features and options that are available with oracle9i enterprise edition, such as oracle高级安全性、oracle分区技术, and so forth. due to limitations of the windows98 operating system, not all features are available on the windows98 version of the oracle9i datab

3、ase server.this section contains the following topics:· options · features optionsthe following table lists the options available with this release. options which are new, or whose factoring status has changed, are noted in bold italic print.oracle9i release 9.0.1 optionsoption  oracl

4、e9i standard edition oracle9i enterprise edition oracle9i personal edition notes oracle advanced security n y y oracle高级安全性提供有关网络加密，sso服务，智能卡，象征性和生命期的用户身份验证的统一集成。oracle change management pack  n y y oracle change management pack(变更管理包)消除在应用

5、更新后导致数据库升级的情况下的数据错误和丢失。该管理包分析应用变更对自动执行数据库升级造成的依赖复杂程度。oracle data mining n y y oracle data mining包含了为做分类、预测和联合等数据挖掘功能。所有的内建模型和scoring功能均通过统一的java-based api接口进行访问。 oracle diagnostics pack n y y oracle diagnostics pack是一套用于监控数据库状态、系统精细化、分析、以及修复数据库漏洞的高级工具。

6、60;oracle label security n y y oracle标签安全特性是一种先进的行一级安全out-of-the-box解决方案，它允许用户定义和加强对于oracle数据库的表级访问控制策略。oracle management pack for oracle applications n y n extends oracle enterprise manager to enable the monitoring, diagnosis, capacity planning, and tuning of

7、 the oracle applications environment. oracle management pack for sap r/3 n y n offers real time monitoring for sap r/3, systems, capacity planning for historical analysis and future planning purposes, event integration, and a single point of administration of the host, datab

8、ase, and application. oracle olap n y y oracle olap provides the oracle olap api, which provides support for complex, multidimensional queries. oracle partitioning n y y oracle partitioning allows large tables to be broken into smaller pieces that im

9、prove manageability, availability, and scalability.  oracle programmer y y y oracle programmer is a family of products consisting of three sql-style interfaces: precompilers, sql*module, and sqlj; four call level interfaces: oracle call interface (oci), oracle c+ call interf

10、ace (occi), odbc, and jdbc; oracle objects for ole; and object type translator and jpub. oracle real application clusters n y n oracle real application clusters allows database workload to be distributed across a cluster, resulting in high scalability. high availability is a

11、ssured, because even if one node fails, the remaining nodes still can access the database. oracle spatial n y y oracle spatial is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently in an oracle

12、 database.  oracle tuning pack  n y y oracle tuning pack provides database administrators with expert performance management for the oracle environment, including sql tuning and storage optimization. featuresthe following table lists the major features available with re

13、lease 9.0.1. features which were new to oracle9i, or whose factoring status changed in oracle9i, are noted in bold italic print.  area feature  oracle9i standard edition oracle9i enterprise edition oracle9i personal edition notes content management dynamic ser

14、vices y y y provides web service aggregation and transformation, administration, definition and registration, and delivery. ice 1.0 support. content management oracle database workspace manager y y y creates heretical workspaces and uses metadata and

15、 views to version enabled tables in a long transaction framework. content management parallel text index creation n y y enables parallel text index creation on non-partitioned as well as partitioned tables content management ultra search y y y&#

16、160;provides unified searching across the oracle database, the web (html), and external data sources. data warehousing and vldb analytic functions y y y built-in sql functions to provide a variety of sophisticated analytical computations. these include rank, moving aver

17、age, and ratio-to-report, and many others. data warehousing and vldb automated parallel query degree n y y automated parallel query optimization based on system utilization. data warehousing and vldb bitmapped indexes and bitmapped joined indexes n y

18、 y index type commonly used in a data warehouse for columns with small number of distinct values, such as 'y' or 'n', resulting in dramatic performance gains in a data warehouse application. bitmapped joined indexes improve join performance and makes it possible to create a

19、n index on one table based on a set of columns from another table. data warehousing and vldb descending indexes y y y provides better performance when indexed data needs to sorted in descending order. data warehousing and vldb direct path load api y 

20、y y allows complete access to all load functionality via oci api for creation of high performance load programs. data warehousing and vldb export transportable tablespaces n y y quickly moves or creates a copy of tablespace data. a transportable tablespace can

21、 be "plugged in" to all editions of the database. data warehousing and vldb import transportable tablespaces y y y quickly "plugs in" a transportable tablespace. data warehousing and vldb external tables y y y enables ac

22、cessibility within the database to external data sources (such as flat files) as read-only tables. data warehousing and vldb function-based indexes from 9.2y y allows indexes to be created on expressions or functions. data warehousing and vldb long operations monit

23、or y y y progress of long running database and application operations can be monitored and information can be displayed, such as percent complete. data warehousing and vldb materialized views y y y includes summary management functionality, join inde

24、xes, multi-tier materialized views, and summary advisor. automatically redirects queries to stored summary tables, improving query performance dramatically. data warehousing and vldb merge y y y an incremental refresh of a table requires two tasks: new records are inser

25、ted and existing records are updated. merge allows both tasks to be performed simultaneously in a single sql statement. data warehousing and vldb optimizer statistics management y y y schema object statistics, used by the cost based optimizer, can be copied and moved to

26、 another database. data warehousing and vldb parallel analyze n y y the analyze statement, used to gather statistics on tables, can be run using parallel processing. this feature requires the partitioning option. data warehousing and vldb parallel bitmap star

27、query optimization n y y this algorithm utilizes single-table bitmap indexes and an advanced star query join method, resulting in excellent performance while efficiently utilizing space. data warehousing and vldb parallel dml (insert/update/ delete) n y y

28、 divides dml operations transparently across multiple processes. this feature requires the partitioning option. data warehousing and vldb parallel index build n y y creates indexes using parallel processes, significantly improving performance of the operation. 

29、;data warehousing and vldb parallel index scans n y y queries that use an index can scan the index in parallel with multiple processes. this requires the partitioning option data warehousing and vldb parallel load y y y loads of data quickly wit

30、h multiple, parallel processes. data warehousing and vldb parallel query n y y transparently distributes query execution across multiple processes, resulting in outstanding performance. data warehousing and vldb pipelined table functions y y y&#

31、160;allows result sets to be pipelined back to calling statement, dramatically improving performance. data warehousing and vldb sample scan y y y scans of a sampling of data to determine approximate averages or other data analysis quickly even in extremely large tables.

32、 data warehousing and vldb star query optimization y y y this algorithm utilizes b-tree indexes (not bitmap indexes) data warehousing and vldb synchronous change data capture n y y captures, publishes, and allows applications to subscribe t

33、o change data in a controlled fashion. database features advanced queuing y y y provides direct support in the database for high performance queuing and messaging operations, integrated with ldap. database features database event triggers y y y&

34、#160;fires off database triggers, such as database startup or shutdown triggers, ddl statement triggers, and logon/logoff triggers, when the event occurs. database features dbms_repair package y y y detects and corrects software and hardware corruption early. datab

35、ase features drop column y y y removes an unwanted column from a table. database feature flashback query y y y allows data to be queried from a point in the past. database features globalization support y y y provid

36、es native language support with enhanced unicode capabilities. database features index coalesce n y y defragments free space in index leaf blocks while a table is online. database features index-organized tables y y y stores data in a table

37、 in a b*-tree index structure for better performance and reduced storage. database features instead-of triggers y y y executes triggers instead of the dml that caused the trigger to fire. database features lob (large object) support y y y provides datatypes and func