Soory For 9i

From: Nobody Win <application_erp_at_yahoo.com>
Date: Fri, 3 Nov 2000 21:37:18 -0800 (PST)
Message-Id: <10669.121147@fatcity.com>

Hi All,
I am really soory for this silly mistake which i done on this list i again list this documebt but in diffrent
format and why yahoo dont scan this doc i use the antivirus and i dont understand why it is in binary.

Soory to all.

This is the real Story of Oracle 9i.
ORACLE 9i SERVER

Oracle9i continues Oracle8i's focus on the Internet by providing a series of specific capabilities and product bundlestargeted at eBusiness environments. In addition, Oracle9i continues to add features and capabilities that extends existing investment in mission-critical infrastructure. Oracle9i has been designed with focus on certain key development areas.

LogMiner has also been enhanced in Oracle9i to provide comprehensive Log Analysis for all data types. LogMiner now supports index organized and clustered tables, chained rows, LOBs and LONGs, direct loads, scalar object types, and DDLs. LogMiner also displays the primary key, and supports queries on the logs based on content of change (for example, show all changes to employee 'Smith'). A new graphical user interface as well as other database features also make the product easier to both learn and use.

ONLINE DATA EVOLUTION
Oracle9i contains a new online reorganization and redefinition architecture that allows much more powerful reorganization capabilities. Administrators can now perform a variety of online operations to table definitions, including online reorganization of conventional tables. Essentially, Oracle9i now allows an online "CREATE TABLE AS SELECT" operation. In this new architecture the contents of the table are copied into a new table. While the contents are copied, the updates to the original table are tracked by the database. After the copy completes, the updates are applied to the new table. Once the updates are applied, indexes can be created on the new table. After the indexes are created, any additional updates are applied and the result table replaces the original table. The table is only locked in exclusive mode at the beginning and of the operation while the dictionary data is updated.
Using this new architecture, any physical attribute of the table can be changed online. The table can be moved to a new location, the table can be partitioned, the table can be converted from one organization (e.g. heap) to another (e.g. index organized).

Additionally, many logical attributes can be changed.
Column names, types, and sizes can be changed. Columns
can be added, deleted, or merged. The primary

restriction is that the primary key of the table can.not be modified.

Oracle9i now also supports online create, rebuild, etc. of secondary indexes on index organized tables. Indexes can now be created online and analyzed at the same time. Secondary indexes support efficient fixing of block hints.
Administrators are also able to rapidly quiesce the database in order to perform operations that demand no active transactions. Also, with Oracle9i the buffer cache and shared pool can be resized dynamically. Lastly, Oracle9i can also validate the structure of an object (Analyze Validate) while the object is online and accessed by users

PRECISION DATABASE REPAIR Oracle9i includes better prevention and improved handling of disk corruption. Should a block corruption need to be repaired via media recovery, a new block media recovery feature allows only the corrupt blocks to be recovered while the remainder of the table is online. Oracle9i is able to restore the database to a consistent state after log corruption is detected during recovery. LogMiner allows changes in the log after the corruption to be retrieved and applied. Trial recovery allows recovery to proceed after a corrupted database block is detected so that the administrator can determine if the corruption is an isolated event. If more corruption's are found, the recovery can be backed out.

Oracle9i can also recover from crashes more quickly using a new two-pass recovery algorithm that ensures that only the blocks that need be processed are read from and written to the datafiles. A new time-based mean time to recover (MTTR) parameter also makes it much easier to set a limit on crash recovery time. Recovery Manager backup and restore operations can now restart where they left off after a failure.

SELF SERVICE ERROR CORRECTION
Oracle9i contains very powerful techniques for handling human errors.

The DejaView feature of Oracle9i allows data to be queried from a point in the past. Users set the date and time that they would like to view, and then any SQL query that they execute will operate on data as it existed at that point in time. This new capability uses Oracle's multiversion readconsistency capabilities to restore data by applying undo as needed. Administrators can now configure undo retention by simply specifying how long undo should be kept in the database. Using DejaView, a user can query the database as it existed this morning, yesterday, or last week. The speed of this operations depends only on the amount of data being queried and the number of changes to the data that need to be backed out. Using LogMiner, the change history of a database can be queried from the logs. LogMiner now allows content based data filtering. For example, users can query just the changes to the customer John Smith. This capability enables change history to be queried at the row level. Since Redo and Undo are maintained by the database for internal consistency, enabling these capabilities adds no overhead.

INCREASED TRANSACTION THROUGHPUT ON ORACLE PARALLEL SERVER
The completion of Cache Fusion in Oracle9i allows customers to easily take advantage of the scalability provided by Oracle Parallel Server, with little or no reduced performance cost. This allows customers to horizontally scale the database tier as usage and demand continues to grow.
The Oracle9i Cache Fusion architecture utilizes the collective caches of all the nodes in the cluster to satisfy database requests. Query requests can now be satisfied by both the local cache or any of the other caches. This reduces diskI/O. Update operations do not require disk I/O for synchronization since the local node can obtain the needed blockdirectly from any of the cluster database node caches. Expensive disk I/Os are only performed when none of the col-lectivecaches contain the necessary data and when an update transaction performs a COMMIT operation that requires disk write guarantees. This implementation effectively expands the working set of the database cache and reduces disk I/O to dramatically speed up database operation. Oracle9i Cache Fusion directly ships data blocks from one node's cache to another node's cache in read/read, read/write, and write/write contention situations. This builds on the previous Oracle8i Cache Fusion implementation that handled read/write contention. Because the full Cache Fusion implementation in Oracle9i eliminates the latencies associated with disk based cache coordination, applications can now scale effectively without having to be cluster aware. This means that for the first time a cluster can be treated as a truly scalable single system.

OPTIMIZE FEATURES CRITICAL FOR EBUSINESS Specific performance improvements in Oracle9i are focused on improving performance in areas critical for eBusiness solutions.

Support for native compilation and improved optimization of PL/SQL improves the performance of many of today's business applications, often significantly. The addition of memory and CPU costs to the cost based optimizer results in better optimization plans, less resource usage, and faster overall performance. Latch contention in several areas has been eliminated or reduced and improves performance on large systems. General I/O improvements, including self tuning direct I/O, prefetching and skip/scan row source operations on indexes also improve performance in Data Warehouse and OLTP environments.

By providing VI support, CPU utilization for network communication is reduced by more than 60% on servers and clients in Oracle9i . Virtual Interface (VI) is an emerging communication protocol for clustered server environments. Unlike TCP/IP, VI is a "thin" protocol specially designed for cluster environment, it places most of the messaging burden upon high-speed network hardware and frees the CPU for more important tasks.

DEVELOPMENT PLATFORM - CREATE THE MOST COMPLETE PLATFORM FOR DEVELOPING EBUSINESS APPLICATIONS Oracle9i continues to offer the best development platform for eBusiness and traditional application development.

Key focus areas include:
o Enterprise Java Engine
o XDB and XDK
o SQL and PL/SQL improvements. Oracle for E-Business Managers

ENTERPRISE JAVA ENGINE
Oracle9i JVM (previously JServer) extends its support for Java 2 Enterprise Edition APIs and containers through
o A robust base architecture (session-based, optimized process and memory management,

    Unicode support)
o A comprehensive set of infrastructure services
(JNDI, JTA, Java 2 Security, JMS,

    RMI/IIOP, Persistence, etc)
o A Servlet 2.2 compliant Oracle Servlet Engine, a JavaServer Pages 1.1 compliant

    OracleJSP Engine), for assembling Web components

o A comprehensive CORBA and EJB architecture including support for Entity EJB,

   XML deployment descriptors and a persistence service interface for CMP-EJB, for

    e-business process's and components development o A comprehensive set of JDBC 2.0 drivers ( including an OCI client driver, 100% Java thin driver,

   A server-side driver and a client-side "Ultra thin" proxy driver) , an ANSI ISO compliant

   SQLJ translator and, optimized Java Stored procedures support, for data access and management o A native Java bytecode Accelerator and Memory profiler, for deployment

    performance The Oracle8i JVM which is embedded within both Oracle9i and

    Oracle iAS, allows reliable, flexible, scalable and secure e-Business applications deployment.

XDB AND XDK
Oracle9i features a number of enhanced database operations to store XML in the databases via SQL and render traditional database data as XML. These are key areas of functionality required to support the focus areas of B2B and B2C eBusiness, Packaged Applications, and Internet Content Management. The two main areas of XML support in

Oracle9i are:
o Built in XML Developer Kits (XDKs)
o Native XML Database Support (XDB) With the Java XML Developer Kit (XDK) pre-loaded, and the C XDK linked, into Oracle9i, developers are able to easily access World Wide Web Consortium (W3C)-based functionality that generate, manipulate, render and store XML-formatted data in Oracle9i. Also available in PL/SQL and C++, the XDKs offer XML/XSLT parsers, XML
Schema processors, XML Class Generators, XML Transviewer Beans, and the XSQL Servlet, providing basic building block features that allow developers to quickly XML-enable their applications. In addition, for developers who have requirements to store and retrieve large amounts of complex XML through their content management applications, XML database support
(XDB) in Oracle9i provides native XML storage
capabilities to optimize performance. To achieve this, XDB stores XML natively by introducing XMLType, a new object datatype, and features extremely fast, "navigational" access and search for XML documents. Other XDB features include JNDI support as the standard navigational access API, standard APIs for manipulating content, and content management services such as WebDAV to support authoring and versioning on top of XDB.

SQL AND PL/SQL IMPROVEMENTS
SQL and PL/SQL have continued to be improved in Oracle9i to meet modern development requirements. In addition to native compilation, overall PL/SQL compilation has also been improved. Multi-language server side debugging has also been added, allowing IDE's to debug both Java and PL/SQL within the same framework. To increase the usefulness of Objects, inheritance, type evolution and dynamic method dispatch are all supported in Oracle9i - greatly reducing the maintenance cost of using objects in application development.
New ANSI requirements are also supported, including support for the CASE statement, ANSI compliant joins, and reserved name versioning. To aid migration to Oracle9i from non-Oracle databases, scrolling cursor support has been added.

Some other improvements to PL/SQL include: o Integrated front-end for SQL compilation - this means PL/SQL immediately supports

    all SQL syntax changes (in SQL embedded in PL/SQL)..Oracle for E-Business Managers
o SQL parallel query mechanism has been extended to stored procedures written in

    3GL languages (PL/SQL, Java, as well as external routines). Stored procedures can

     now pipeline (incrementally return) data to the calling SQL statement.
o Full support for ANSI style CASE statements and expressions
o Better support for compute intensive applications through native compilation support
o The SQL and PL/SQL runtime engines have been more tightly integrated to

     improve performance.
o Also, the overhead of calling PL/SQL procedures from SQL has been reduced.

MAKE THE DATABASE SELF MANAGING IN CERTAIN KEY AREAS Oracle9i databases are capable of managing their own undo (Rollback) segments - no longer will administrators need to carefully plan and tune the number and sizes of rollback segments or bother about how to strategically assign transactions to a particular rollback segment. Oracle9i also allows administrators to allocate their undo space in a single undo tablespace with the database taking care of issues such as undo block contention, consistent read retention and space utilization.
Memory Management is another area which has been given significant attention in Oracle9i. Traditionally administrators have needed to shutdown the instance in order to grow or shrink
 System Global Area (SGA) components. Oracle9i introduces a dynamic memory management feature which allows for re-sizing of the buffer cache and shared pool dynamically. It also provides administrators with advisories to help them size the SGA for optimal database performance. Furthermore, Oracle9i provides for transparent management of working memory for SQL execution by self tuning the initialization runtime parameters controlling allocation of private memory. This feature helps low end users to reduce the time and effort required to tune memory parameters for their Data Warehouse and Reporting applications, while high end users are able to avoid memory tuning for individual work loads.

STREAMLINE AND IMPROVE THE OPERATIONAL MANAGEMENT OF AN ORACLE9I DATABASE Other traditional management areas of the database are also improved. With the introduction of a persistent INIT.ORA feature in Oracle9i, parameter changes persist across multiple shutdowns. This feature also allows the administrator to startup the database from remote machines without a local copy of INIT.ORA. This is of immense help in database performance tuning as parameter changes made by performance management tools
(Oracle Enterprise Manager) and internal self-tuning
now persist across shutdowns.

Oracle9i also introduces the concept of "Oracle Managed Files" which simplifies database administration by eliminating the need for administrators to directly manage the files comprising an Oracle database. Oracle9i now internally uses standard file system interfaces to create and delete files as needed. While administrators still need to be involved in space planning and administration, this feature automates the routine task of creation and deletion of database files.

With the introduction of default temporary tablespace, the SYSTEM tablespace is no longer used as the default storage location for temporary data. Oracle9i also allows for better control over database downtime by enabling administrators to specify the mean time to recover (MTTR) from system failures in number of seconds. This feature coupled with more dynamic initialization parameters help administrators further improve database availability.

Oracle9i also introduces a new capability called resumable statements, which allows an administrator to temporarily suspend a large operation, such as a batch update or data load. For example, such operations can be suspended if they start to encounter out of space errors, allowing the administrator to fix the problem, and then resume the operation from the point of interruption - all without disrupting normal database operation.

Oracle9i also supports databases created with multiple block sizes, and allows administrators to configure corresponding 'sub caches' within the buffer cache for each alternative block size. This capability allows administrators to locate objects in tablespaces of appropriate block size in order to minimize I/O performance, and also allows tablespaces to be transported between different databases, for example, from an OLTP environment to a Data Warehousing environment.

Execution plan history is also maintained in Oracle9i, allow administrators to investigate reported performance problems without needing to re-execute the offending queries.

To ease backup and recovery operations, Recovery Manager in Oracle9i provides for one time backup configuration,automatic management of backups and archived logs based on a user specified recovery window, restartable backups and restores, and test restore/recovery. Recovery Manager implements a recovery window, a new policy to control when backups expire. This allows administrators to establish a period of time during which it will be possible to discover logical errors and fix the affected objects by doing a database or tablespace point-in-time recovery. Recovery
Manager will also automatically expire backups that are no longer required to restore the database to a point-in-time during the recovery window. These features are designed to reduce the time and effort spent by administrators in performing routine backup activities tasks by providing for automation for most commonly performed tasks. The new controlfile autobackup feature also allows for
restoring/recovering a database even when a Recovery Manager repository is not available. Recovery Manger in Oracle9i also features enhanced reporting, a more user friendly interface and the ability to specify a highly flexible backup configuration to suit varied requirements depending on the nature of databases and business needs.

CLOSE INTEGRATION WITH WINDOWS 2000 Oracle9i supports better integration with Microsoft Transaction Services, Microsoft Message Queuing and Internet Information Services. The PKI infrastructure and single signon capabilities in Oracle9i have also been well integrated with Windows 2000, Active Directory and Microsoft Certificate Store. In Oracle9i, IIS web services allows seamless high performance access to Oracle Java and PL/SQL web components in Microsoft IIS environment. Oracle9i also provides an enhanced solution to allow the Oracle database to participate as a Resource Manager in Microsoft Transaction Server/COM+ Transactions environment.
Windows security (PKI, Microsoft Certificate Store) supports Oracle wallets in Registry/Active Directory and allows Oracle products to use Microsoft Certificate Store.

For Windows developers, Oracle9i offers an enhanced native OLE DB provider. XML, COM+ Events and Oracle9I extensions have been supported through Oracle Data Objects for Windows (formerly Oracle Objects for OLE). Server side debugging of PL/SQL is supported in Microsoft Script Debugger environment, and further application wizards have been added. Server side Java callouts to COM Automation Servers are also supported.

INTERNET CONTENT MANAGEMENT
CONSOLIDATE ALL INTERNET CONTENT IN ORACLE DATABASES Oracle9i allows customers to store, manage and aggregate all types of multimedia content into a single database.
Oracle9i significantly enhances the capabilities of the Oracle8i database to serve as a platform to create, manage and deliver Internet content. Key focus areas are:
o Storing and managing all types of Content - files, multimedia, e-mail ...
o Content Syndication for Internet applications o Searching and indexing all types of content efficiently
o Organization of content for collaborative projects o Location-enabled, mobile-ready content

Oracle9i includes the version 1.2 release of the Internet File System (iFS), a revolutionary extension to the Oracle8I database. Oracle iFS provides the best of both the relational database and file system worlds. Organizations can install. Oracle for E-Business Managers Oracle iFS and get, out of the box, a file system that has built-in capabilities not available in other file systems. Oracle iFS can store all ontent, from e-mail to web content to word processing documents, in the same folders. End users can access all this content through Windows, the web, FTP, and an e-mail client without any special client installation. Oracle iFS also gives the end user content management features-versioning, content-based searching using interMedia Text, multiple foldering of files, extensible file attributes, ACL-based security, and check in/check out-to better manage the process of creating and publishing file-based content. And, of course, all of this functionality has the ease of the file systems end users already know how to use.

With Oracle9i, iFS adds more content management features, such as WebDAV, an emerging standard for Internet collaboration. Oracle iFS will also be surfacing into the file system interMedia's capabilities to index, search, and manipulate graphics, audio, and video.

LOCATION-ENABLED, MOBILE-READY CONTENT For eBusiness and mobile applications Oracle9i and Oracle Spatial offer the ability to search, index and deliver data based on the location attributes of the content or the proximity. Support for mobile devices, protocols (WAP) and. Oracle for E-Business Managers formats (such as WBMP) and delivery through Oracle iAS Wireless (formerly Portal-to-Go), make Oracle9i a complete platform for the delivery of content for mobile applications. Content stored in Oracle9i can now be associated with related location criteria and services. Interactive Voice Response (IVR) formats used in mobile
applications are now supported in interMedia. New support for online mapping, yellow pages, driving directions, traffic, and geocoding services allow online content to be merged with database content.

PROVIDING A STANDARD INFRASTRUCTURE TO CREATE STOREFRONTS, EXCHANGES AND PORTALS Oracle9i includes a set of pre-developed, pre-tested and pre-integrated business service objects, developed in Java and compliant with J2EE, that provide faster time to market for customers to build and integrate web based storefronts, exchanges and hosted applications.
The eBusiness service objects seamlessly blends open Internet technologies and standards with reliable, scaleable Oracle technologies and products. The eBusiness service objects allow developers to rapidly build complex multi-tiered
Internet applications based on open standards, such as HTML, XML, JavaScript, Java Servlets, Java Beans, and Java Server Pages.

SCALABILITY, PERFORMANCE, AND MANAGABILITY Performance, scalability, and manageability are basic requirements for business-intelligence applications. As in previous database releases, Oracle9i offers considerable new enhancements in each of these areas. Oracle9i's partitioning capabilities have been expanded to support list partitioning, and base partitioning capabilities have been extended to cover all data types available in Oracle8i, including index organized tables, objects and nested tables. This allows organizations to effectively store, manage and search very large amounts of any type of information. Oracle9i's self-tuning memory not only simplifies the tuning of business-intelligence applications and ensure equitable distribution of memory among concurrent process's, but more importantly also improves query performance.
Oracle9i also continues to improve query performance in other areas, with innovative new technologies such as considerable enhancements to materialized view's, and the introduction of bitmap join indexes.

COMPLETE BUSINESS INTELLIGENCE PLATFORM: INTEGRATED ANALYSIS AND PERSONALIZATION CAPABILITIES However, Oracle9i for business intelligence goes far beyond the primary requirements of performance, scalability, and manageability. Oracle9i is designed to be a full data warehouse platform, leveraging the Oracle database as the scalable data engine for all operations on data warehousing data. Oracle9i provides ground-breaking new functionality in three areas: Online Analytical Processing (OLAP),
Extraction, Transformation and Loading (ETL), and Data-Mining.
Oracle9i introduces OLAP Server, a scalable, high-performance OLAP calculation engine with fully integrated management and administration. Leveraging Oracle Express Server technology and Oracle8i's analytic SQL capabilities, OLAP Server provides a robust platform for delivering analytic applications.

To increase the efficiency and reduce time taken to load and refresh critical data warehouses, Oracle9i provides support for external tables, allowing data from external systems to be quickly loaded into the database. In addition, a new data capture facility will allow incremental changes from target sources to be captured and applied to the data warehouse automatically. Other data load capabilities provided to increase data load scalability and reduce complexity include multi table insert and upsert semantics. This new ETL functionality will also be leveraged by Oracle Warehouse Builder. Received on Fri Nov 03 2000 - 23:37:18 CST