Oracle9i product documentation

Source: Internet
Author: User
Oracle9i product documentation

Oracle 9i product documentation

The ORACLE tutorial is: Oracle 9i product documentation.

I. Enhanced scalability

Oracle9i Real Application Clusters is the next-generation Parallel Server series of Oracle. Oracle9i Real Application Clusters designs fast and efficient shared Cluster High-speed buffer registers for accessing the same data, thus providing transparent Application scalability. Oracle9i Real Application Clusters is the result of more than five years of R & D work, including nine exclusive patents and 18 patent applications filed.

Oracle9i Real Application Clusters is unique in:

"Out-of-the-box", near-linear transparent Scaling

Good compatibility with other programs, no need to redesign

Fast-growing clusters allow you to quickly add nodes and disks

Ii. Why do you need Flexible Data Partitioning

Data Server Management, recovery of bad systems, and inefficient applications often result in amazing costs. Using Data Partition to maintain big data storage will reduce these costs.

Data Partitioning reduces costs by dividing large data into smaller and easier-to-manage parts. However, when some data servers increase this capability, the data in multiple partitions is limited, which limits your business development.

Oracle has no such data size limit.

Although other data servers provide partitions, they only provide limited data partition methods. Oracle partition options include hash, range, and composite. The advantages of this flexible partitioning method are:

Target and accurate data server management

High Availability

Application Performance Improvement

Due to structure restrictions, most server partitions cause high performance at the cost of precise data server management and high availability. You must select between them. Oracle's composite partitioning method eliminates this situation.

Using Oracle partitioning, data storage, management, access, and backup are all based on your business requirements. For example, many companies prefer to partition by date. When the data reaches a certain date, the data cannot be queried again. Oracle Range partitions make expired partitions still available for query.

Oracle partitions significantly improve data availability. A single partition can be taken offline without affecting other data operations. Query is always performed only when all partitions are normal. Oracle will never provide incomplete query results.


3. Why do you need Non-incremental Row-Level Locking )?

In today's online world, many customers are reluctant to wait.

The access capability of data records is the key to your business. However, data access capabilities, time constraints, and the accuracy of business records must be compromised. This is because of your transaction processing system.

When an employee modifies the information, the data server locks the information until the operation is completed. During this period, no one else can change the locked information. The lock information is locked until a change is completed. This is the basic function of all transaction processing systems.

Many servers even prevent employees from reading locked data, which causes unnecessary business delays.

On the surface, most data servers seem to only provide row-level locks, and only lock the working data rows. In fact, most data servers lock far more data than that. Servers use memory to trace locked information, which means they can only trace limited details. As the system activity level increases, these servers start to lock larger area information for managing memory usage.

Because of the increasing number of locks, the user must wait for other users to execute the task, even if the waiting for completion may be a completely different piece of information.

Oracle eliminates this difficulty by using non-incremental row-level locking.

The Oracle Data Server Always locks data rows that are being updated. Other data rows are not affected. Oracle does not use the computer's memory to track the lock information. Therefore, there is no limit on the number of lines that can be locked by Oracle. All employees can update data at the same time without delay.

Iv. Oralce Clickstream Intelligence

As a component of Oracle9i Application Sever, Oralce Clickstream Intelligence is a ready-made Application that can analyze website data and enterprise data to improve website efficiency and user loyalty. To this end, Oralce uses the open data model of the Oracle warehouse development tool to provide a pre-built and open data set, and uses the Oracle Portal framework to provide a set of pre-built reports. You can expand the first-created report or add a new report.

With the power of the Oracle stack, the system can quickly merge and analyze a large amount of data, provide additional reflection times, and publish results in a custom portal accessed through a browser.

Oralce Clickstream Intelligence can combine data in Oracle and other corresponding CWM repositories based on the "common repository metadata model" (CWM) Standard of Oracle Warehouse Builder. This openness allows you to extract data from the customer relationship management (CRM) and Enterprise Resource Planning (ERP) systems. You can track marketing activities, website sales, and user loyalty. With formatted reports, you can automatically publish results on your Oracle BI portal. You can use Oracle BI to customize and add new reports.

Oralce Clickstream Intelligence can meet the demanding requirements of e-commerce, including fast implementation, scalability, operability, availability and manageability.


5. Internet Developer Suite

Oracle Internet Developer Suite combines Oracle application development tools into a complete product. Based on Internet standards such as Java, XML, CORBA, and HTML, Oracle Internet Developer Suite provides an efficient development environment and a set of tools to respond to rapidly changing market and user needs.

Oracle Internet Developer Suite allows you to benefit from the flexibility of development tools without sacrificing the portability of integration solutions.

Supports any development method: Component-based development, Java programs, visual modeling, and fast applications developed based on 4GL.

Use the Oracle Portal to create a personalized Integrated Portal view containing all your programs

You can deploy a single middle layer for all your applications that use Oracle9I Application Server as the Server.

Use integrated business information to provide enterprise reports and special queries

Develop programs suitable for all your clients: Efficient java client programs, common HTML client programs, cross-platform client programs

Enjoy the efficient Java IDE for professional Java developers to create Java applets

Use a fully component-based development environment to develop EJB and CORBA components

Use PL/SQL (language) to use the most efficient development environment suitable for 4GL programmers

Oracle Internet Developer Suite provides a complete set of major Oracle application development, business information, and enterprise portal generation tools. Including:

Vi. Business Intelligence

In normal longitude


The ORACLE tutorial is: Oracle 9i product documentation. In the economic environment, information about your business operations is the key to your work.

So far, building a comprehensive business intelligence solution for your company requires connecting several complex applications and maintaining it by some professionals. Currently, the built-in business intelligence function of Oracle9i provides an integrated interface for your enterprise and can be accessed from any site using any cocoa connected to Internet devices.

Oracle makes online business intelligence a reality. This is because it integrates Online Analytical Processing (OLAP), real-time personalization (real-time personalization), extraction, conversion, and loading (ETL) technologies into the Oracle database, instead of distributing these different functions on different servers. Oracle currently provides integrated business intelligence functions in Oracle9i Application Server, including enterprise portal and wireless access.

Oracle9i Business Intelligence provides real-time and personalized information for thousands of concurrent users. Because it is based on open standards, data can be displayed on various devices with Internet functions. This means that your employees can access more valuable information than before.

For more information, see Oracle9i business intelligence and Oracle9i Application Server .. Oracle9i Database, Oracle Warehouse Builder 3i and Oracle BI Beans will be available in the spring 2001


7. Ensure high availability

Downtime is the worst thing for e-commerce, whether or not it is under planning. The loss of revenue, productivity, loss of customers, loss of company reputation, and lack of confidence in your e-commerce. Oracle9i has established a new set of High-Applicability standards by introducing powerful functions. New features provide protection measures to avoid disasters, quickly recover system faults, transparently recover human errors, and reduce planned shutdown.

Fault recovery

System fault recovery

Human error

Reduce planned shutdown

Fault recovery

Oracle9i Data Guard enables customers to quickly recover from disasters. Data Guard is complete, simple, and fully automated when performing backup operations.

Physical backup database

The physical backup database backs up log files from the master server to the backup server for maintenance. These log files are used to adjust the content on the backup server and master server through media using an operation called "roll forward. The physical structure of the backup server is the same as that of the master server and can be read-only.

Logical standby Database

Oracle9i introduces a new backup database mechanism-logical backup database. It is different from the physical standby database in the maintenance mode. Both types of databases depend on log files, and the standby database pushes the SOL statement from the log file, these SQL statements are applied on the slave server in the same way as any conventional SQL command set. This SQL-based maintenance method allows a standby database to provide general read/write operations.

Zero data loss log Transmission

Orical9i Data Guard Broker provides the ability to synchronize or not synchronize log files directly from the master service to the backup server. In this way, a completely "lossless" disaster recovery solution is provided, instead of using third-party products to mirror online repeated operation logs. Therefore, in any disaster recovery scenario, users can ensure that their standby database is completely updated to the fault occurrence point.

Data Guard Broker

Oracle9i Data Guard Broker provides necessary monitoring, control, and automatic operations for management logic and physical standby databases. For example, Oracle9i Data Guard Broker provides one-step troubleshooting for the master server and any type of backup database.

System fault recovery

Oracle9i Real Application Clusters brings significant breakthroughs in cluster database technology. The "High-speed cache fusion" technology enables the system to provide transparent application expansion and ultra-fast fault recovery for highly effective data and applications.

Real Application Clusters -- troubleshooting in 17 seconds

Compared with a single-node configuration, the cluster architecture avoids a fault set and provides a higher level of effectiveness. In a server configured in a dual-node cluster, even if a node system crashes, the application can continue to run on the surviving node. Using Oracle9i Real Application Clusters, it takes only 17 seconds from the first point of failure to automatic recovery on the second point, which reduces the impact on data and Application validity, in essence, the impact on data and application effectiveness is eliminated.

Oralce9i Fail Safe -- supports four-node fault recovery configuration for Windows

Oralce9i Fail Safe provides high efficiency and System Fault Protection for e-commerce in the Windows NT and 2000 cluster architectures. The Oracle9i automatic fault protection device provides fault recovery programs for Windows NT, 2000 cluster data, and application servers at both nodes and four nodes.

Time-based Quick Start recovery

The time-based Quick Start recovery introduced by Oracle9i allows the database administrator to specify an upper limit for the recovery time. After a system crash or a fault restarts, You can reconnect to your application within a period of time beyond the target limit.

Quick instance freezing and recovery

Database administrators are faced with the challenge of balancing how to identify the cause of failure and recover regular services as quickly as possible. By activating Flash Freeze, the database administrator can obtain diagnostic snapshots for the entire system at the time of failure. After the snapshot is restarted quickly, the database administrator can perform offline diagnostic analysis.

Human error

Oracle9i makes it easy to recover failures caused by human reasons such as incorrect operations and non-program operations.

Oracle9i Flashback Query)

With an innovative performance of Oracle9i-Flashback query, users and applications can query data, just as they did in the past. With the flash back query parameter, you and the application can specify a date in time and then perform a standard query on the data. The result is like a query on a specified date. Once the error is confirmed, canceling the update is a relatively simple step, and the database administrator does not have to intervene. More importantly, the application can be restored without stopping services.

Comprehensive Log Analysis

You can also identify data updates by analyzing database log files. Oracle9i LogMiner is a related utility that reads, analyzes, and interprets online or obtained log files through the SOL interface. With Oracle9i LogMiner, the database administrator can test database updates, including data operations, definitions, and management commands.

Recoverable statement

Some large operations that take a long time, such as data uploading and complex update processes, may have exhausted resources (such as disk space) before they are completed ). Operations that run for a long time but fail to end may take a long time. Oracle9i allows the database administrator to suspend operations that cannot be completed to solve this problem. Once the operation is suspended, the database administrator can solve the resource problem and allow the statement to be restored from the breakpoint.

Reduce planned shutdown

Oracle9i allows all planned maintenance operations that usually require shutdown to run during normal use.

Online architecture modification

Oracle9i allows you to redefine the table structure while keeping data tables online and completely accessible to users and applications.

Online table reorganization and Indexing

Oralce9i also provides a simple mechanism to reorganize and define data tables while keeping them online and accessible to application users. The reorganization of Oracle9i online tables and indexes reduces the planned shutdown, improves the effectiveness of applications, reduces disk fragments, and improves application performance.

Full Online indexing


The ORACLE tutorial is: Oracle 9i product documentation.> With Oracle9i, all table indexes can be created and re-created online. Without such performance, users are prohibited from running their applications when creating table indexes.

Dynamic Database Parameters

The parameters that affect the memory usage of the database server in the Oracle9i database can be reset online. In this way, the database does not need to be offline and restarted for the parameter settings to take effect.


VIII. Dynamic Services

Oracle9i Dynamic Services embeds a wide range of Services on the Internet into your system, allowing your business to take advantage of the expertise of partners and other third parties.

Oracle9i Dynamic Services provides a single program architecture for accessing, gathering, managing, and implementing internet Services. This makes it unnecessary for developers to interact with a variety of information sources, multiple access protocols, and the complexity of multiple channels, improving the efficiency of developers and reducing management costs.

The core part of Oracle9i Dynamic Services is a policy and service management engine, which determines how Services are executed. Various Applications Access Dynamic Services by passing service requests to the Dynamic Services engine. You can search for Dynamic Services Registry Dynamic Services to find the Dynamic service at the time of development or run-time. Dynamic service descriptors can also be published in UDDI to facilitate search for services on the Internet.

Oracle9i Dynamic Services provides a management environment for enterprises to define service policies, such as priority, set, and failure recovery. The Dynamic Services engine captures and records all information about service configuration and execution. A Service monitor collects such information as who, when, and how often a service is requested. Audit features can be used for Service Execution records, failure reporting, and payment.

Oracle9i Dynamic Services is an open framework ). Service providers and developers can easily customize dynamic services and launch Channel services.

9. Application Server Appliance

Oracle9i Application Server Appliance is a next-generation Oracle Network Development Tool Based on Oracle9i Application Server and its original Web Cache Technology. With this latest Oracle tool, small and medium-sized enterprises or such enterprises can deploy their Web sites based on the rapid application servers in the industry, saving costs. Alternatively, you can use the existing Web infrastructure to quickly deploy your site with Oracle's $1 million guarantee on its performance.

Oracle9i Application Server Appliance has the following advantages:

Quick deployment of Oracle9i Application Server Appliance is very simple and can be used quickly and intuitively.

Low total cost: Compared with maintaining traditional multi-purpose database servers, organizations using this tool can reduce the total cost of ownership (often up to 40% ).

Simple Management: Oracle 9i Application Server Appliance is an Oracle Enterprise Manager (OEM) software with Appliance Management Pack. Extended Appliance Management Pack

Oracle Enterprise Manager (OEM) not only manages databases, but also manages the entire software environment on Oracle Appliances and various running Oracle hardware devices.

The Application of Oracle8i Database Appliance on the SQL Server of Microsoft NT is 82% of the original total cost. With the powerful scalability and Web Cache Technology of Oracle9Ii Application Server, customers can provide richer and more personalized network content to more users. Oracle9i Application Server is based on open Internet software standards and runs on an intel platform that is widely used. It combines performance, reliability, and scalability.

Once the tool is installed and run, it will automatically install and allocate workload to improve real-time performance. If the server fails, the network administrator can remove the server and replace it with a new application server tool. The tool can be automatically configured to automatically reallocate the workload and run better without stopping services on the Web site.


10. Powerful scalability

Oracle9i Real Application Clusters is a revolutionary upgrade product from Oracle Parallel Server. After six years of hard development, nine partners participated and registered 18 technical patents, there are still new patented technologies under registration.

Oracle9i Real Application Clusters provides the following unique technologies:

Excellent close-to-linear scaling transparency.

It is compatible with various applications and does not require any re-design.

Rapidly growing clusters, rapidly increasing node and disk capabilities.

The Oracle-based Cache Fusion structure allows Oracle9i Real Application Clusters to provide transparent Application scaling performance by quickly and effectively sharing data frequently accessed on all servers in a cluster. The competition between servers is solved.

When multiple servers want to access the same data, consider the following three situations:


One user needs to read a piece of information on one server, and one user has read this information on another server.

A user needs to read a piece of information on one server, and a user has updated this information on another server.


A user needs to update a piece of information on one server, and a user has already updated this information on another server.

In the Cache Fusion structure, read requests may come from any memory Cache of the cluster database. To ensure that the data in the cache is updated in a timely manner, it is very important to coordinate the cache on each server to ensure the consistency and correctness of Data Reading and updating.

If a query request is provided by a remote cache, the information will be transmitted from the cache on one node to the cache on another node through the high-speed cluster connection. This cache fusion is completely automated and transparent to applications. This transparency is the key technology that Oracle9i Real Application Clusters can provide high-speed and effective scaling performance.

11. Real-Time Personalized Management

Oracle personalized processing provides real-time and dynamic personalized recommendation services for registered users and anonymous visitors, making e-commerce services at possible.

Since Oracle products provide an integrated real-time recommendation engine fully embedded in Oracle9i databases, Oracle personalized services provide powerful, scalable, and Real-Time Personalized processing for e-commerce.

With the scalability of Oracle9i Database, Oracle personalized service can maintain the uniqueness of each customer relationship while analyzing a large amount of customer information. This will enable the e-commerce service to provide customized, customer services, so that the browser can meet customer needs.

Using data mining technology, you can find the electronics you really need from the clicks, transactions, ratings, and chart statistics of a large number of customers on the website.


The ORACLE tutorial is: Oracle 9i product documentation. Business data. Oracle personalized service can answer the following questions:

What is the customer's favorite or most likely product?

If this Customer prefers or has already purchased this product, what other products may he purchase?

How likely is this customer to love and buy a product?

If a customer prefers or is buying another product, what products does the customer likely buy?

Oracle personalized service is the first data mining algorithm embedded in Oracle databases. Other algorithms and targeted applications, such as customer retention rate/loss rate, response modeling, and customer information Summary, will also be embedded.

Pricing and product bundle information will be released before new products are listed.

Previous Page


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.