Oracle 9i Product Documentation _oracle

Source: Internet
Author: User
Tags documentation memory usage new set pack prev time limit
The Oracle tutorial you are looking at is Oracle 9i product documentation.

I. Enhanced Scalability

Oracle9i Real application clusters is Oracle's next-generation parallel server series. Oracle9i Real application clusters provides transparent application scalability by designing a fast and efficient shared cluster cache register for accessing the same data. Oracle9i Real application clusters is the culmination of more than five years of research and development work, which includes 9 exclusive patents and 18 declared patent requests.

The unique oracle9i real application clusters is:

"Out-of-the-Box", near-linear transparent scaling

Good compatibility with other programs, no need to redesign

Fast-growing clusters that can quickly add nodes and disks

Second, why do you need flexible data partitioning flexible-partitioning

The cost of data server management, recovery of bad systems, and inefficient applications is often staggering. Using data partitions to maintain large data storage will reduce these costs.

Data partitioning reduces costs by splitting large data into smaller, manageable portions. But some data servers, when added to this feature, limit the number of partitioned data that limits your business development.

Oracle does not have any limitations on this data size.

While other data servers provide partitions, they provide only limited data partitioning methods. Oracle's Partitioning (partitioning Option) has a variety of hashes, range, and composite. The benefits of this flexible zoning approach are:

Target-Accurate data server management

High Availability

Application can improve

Due to structural constraints, the partitioning of most servers results in increased performance at the expense of target-accurate data server management and high availability. You have to make a choice between them. This is eliminated by Oracle's composite partitioning approach.

With Oracle partitions, data is stored, managed, accessed, and backed up exactly to your business requirements. For example, many companies like to partition by date, and when the data reaches a certain date, the data can no longer be queried. The Oracle range partition causes the expired partitions to still be queried.

Oracle partitions significantly improve the availability of data. A single partition can be taken offline independently and does not affect other data operations. Queries are always performed in the normal circumstances of all partitions. Oracle will never provide incomplete query results.

[NextPage]

Third, why do you need a non-escalating row-level lock (row-level locking)?

In today's online world, many customers just don't want to wait.

The ability to access data records is the key to your business. But the accuracy of data access, time limits, and business records needs to be compromised, due to your transactional system.

When an employee modifies the information, the data server locks the information until the operation is complete. No one else can change the locked information during this period. Lock information until a change is done to become data locked. This is the basic function of all transaction processing systems.

Many servers even prevent employees from reading locked data, causing some unnecessary business delays.

On the surface, most data servers seem to provide only row-level locks, locking only the data rows in those jobs. In fact, most data servers lock up more data than these. Servers are information that uses memory to track locks, which means they can only track limited details. As the system activity level increases, these servers begin to lock in a larger area of information for managing memory usage.

Because the lock is incremented, the user must wait for the other user's task to execute, even if the waiting for completion may be a completely different piece of information.

Oracle eliminates this difficulty by adopting a non-escalating row-level lock (row-level locking).

The Oracle data server is always locked in the data rows that are being updated. Other data rows will not be affected. Oracle does not use the computer's memory-tracking lock information. This allows Oracle to lock up the number of lines, all employees can update the data at the same time, do not delay the business.

Iv. Oralce clickstream Intelligence

As a component of oracle9i application Sever, Oralce Clickstream is a ready-made application that analyzes Web site data and enterprise data to improve site efficiency and user loyalty. To this end, Oralce intelligent-click Streaming leverages the Open data model of Oracle Warehouse development tools to provide a pre-established, open dataset and uses Oracle's portal framework to provide a set of pre-established reports. You can expand the first-built report, or you can add new reports.

With the power of the Oracle stack, the system is able to quickly consolidate and analyze large amounts of data, provide additional reflection times, and publish results in a user-defined portal that is accessed through the browser.

Using the Common Warehouse Metamodel (CWM) standard of Oracle Warehouse Builder, oralce clickstream intelligence can combine data from Oracle and other corresponding CWM repositories. This openness enables you to extract data from Customer relationship management (CRM) and Enterprise Resource Planning (ERP) systems. You can track marketing campaigns, website sales, and user loyalty. With formatted reports, you can automatically publish results in your Oracle Business intelligence portal, and you can customize and add new reports using Oracle Business Intelligence (BI) tools.

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

[NextPage]

V. Internet Developer Suite

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

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

Support for any type of development: component-based Development, Java programs, visualization modeling, fast application based on 4GL development.

Use the Oracle portal to create a personalized integrated portal view that contains all of your programs

A single middle tier can be deployed for all your oracle9i application server-side applications

Leverage integrated Business information to provide enterprise reports and ad hoc queries

Develop programs that are appropriate for all your clients: Efficient Java client programs, generic HTML client programs, Cross-platform client programs

Enjoy the efficient Java IDE for professional Java developers creating Java applets

Developing EJB and CORBA components using a fully component-based development environment

Borrow Pl/sql (language) to use the most efficient development environment suitable for 4GL programmers

The Oracle Internet Developer Suite contains a complete set of Oracle's major application development, business information, and Enterprise Portal generation tools. Including:



VI. Business Intelligence

In the normal warp

[1] [2] [3] [4] Next page

The Oracle tutorial you are looking at is Oracle 9i product documentation. In the Jinan environment, information about your business is the key to doing your job well.

To date, building a comprehensive business intelligence program for your business requires a combination of several complex applications and some professionals to maintain it. Now, the Oracle9i built-in Business intelligence feature provides an integrated interface for your business and can be accessed from any location using any cocoa connected to the Internet.

Oracle makes online business intelligence a reality. This is because it integrates online analytical processing (OLAP), real-time personalization (real-time personalization) and extraction, transformation, and load (ETL) technologies into Oracle databases, rather than spreading these different functions across different servers. Oracle has now provided integrated business intelligence features in oracle9i application server, including enterprise portals, wireless access, and more.

Oracle9i's business intelligence can provide real-time, personalized information for thousands of concurrent users. Because it is based on open standards, data can be displayed on a variety of Internet-enabled devices. This means that your employees have access to more valuable information than ever before.

For more information about oracle9i Business intelligence and oracle9i application Server. Oracle9i Database, Oracle Warehouse Builder 3i and Oracle BI Beans will be available in spring 2001

[NextPage]

Vii. Ensuring high availability

Downtime is the worst thing for e-commerce, whether it's planned or not. When applied, downtime can lead to loss of revenue, lower productivity, loss of customers, impaired corporate reputation, and lack of confidence in your e-commerce. Oracle9i establishes a new set of high applicability standards by introducing powerful functions. New features provide protection against disasters, rapid recovery of system failures, transparent restoration of human error, and reduction of planned downtime.

Failure recovery

System failure Recovery

Human error

Reduce planned downtime

Failure recovery

Oracle9i Data Guard enables customers to recover quickly from disaster situations. The behavior of Data Guard is perfect, simple and fully automated in the execution of backup operations.

Physical Standby Database

The physical standby database is maintained by backing up the log files from the primary server to the standby server. Using an operation called roll forward, these log files are used by the media to adjust the contents of the standby server and the primary server. The standby server is in a physical structure consistent with the primary server and can be read-only.

Logical Standby Database

Oracle9i introduced a new standby database mechanism--the logical standby database. It differs from the physical standby database in terms of maintenance. Both types of databases rely on log files, which infer the SOL statement from the log file and apply the SQL statements to the standby server in the same way as any regular SQL commands collection. This method of SQL based maintenance enables a standby database to provide general read and write operations.

0 Data Loss Log transmissions

orical9i Data Guard Broker provides the ability to synchronize or not synchronize a log file directly from the primary service to the standby server. This provides a completely "lossless" disaster recovery solution, without having to use third-party products to mirror the online repeat operations log. Therefore, in any disaster recovery scenario, users can ensure that their standby database is fully updated to the point where the failure occurred.

Data Guard Broker

Oracle9i Data Guard Broker provides the necessary monitoring, control, and automation for both the management logic and the physical standby database. For example, Oracle9i Data Guard Broker provides a single step in recovery processing for both the primary server and any type of standby database.


System failure Recovery

Oracle9i Real application clusters has introduced a major breakthrough in cluster database technology. The technology, known as "cache Fusion," enables the system to provide both transparent application extensions and extremely fast recovery of data and applications for high efficiency.

Real Application clusters--17 sec troubleshooting

Compared to a single node configuration, the cluster architecture avoids fault concentration and provides a higher level of effectiveness. In a server with a two-node cluster configuration, even if a node system crashes, the application is allowed to continue running on the surviving node. Using oracle9i real application clusters, it takes only 17 seconds to recover from the first node to the automatic recovery operation on the second node, which reduces the impact on data and application effectiveness, essentially eliminating the impact on data and application effectiveness.

oralce9i Fail safe--Windows-enabled four-node recovery configuration

Oralce9i Fail Safe provides high efficiency and system failure protection for E-commerce on Windows NT and 2000 cluster architectures. The Oracle9i automatic fault protection device provides a recovery program for dual-node and four-node Windows NT, 2000 cluster data, and application servers.

Time-based fast start recovery

Oracle9i introduces a time-based, fast-start recovery that allows the database administrator to specify a target upper bound value for the recovery time. After the system crashes or after a failed reboot, users can reconnect to their application within the time limit of the target.

Quick instance freezes and restores

Database administrators generally face the challenge of how to identify the cause of the failure as quickly as possible and to balance the recovery of conventional services. By activating the "Instant Freeze" (Flash Freeze), the database administrator can get the whole system to diagnose the snapshot at the moment of failure, and then perform the off-line diagnostic analysis after fast reboot.


Human error

Oracle9i makes it easy to recover from errors such as error operations and human-caused failures that do not operate according to the program.

Oracle9i Flash-back queries (flashback query)

With an innovative performance of oracle9i-flashback queries, users and applications can query data as they have in the past. Using the Flashback query parameters, users and applications can specify a date in time, and then perform standard queries on the data, as if they were on a specified date query. Once the error is identified, canceling the update is a relatively simple step, and the database administrator can do without intervention. More importantly, the application does not have to shut down to complete the recovery.

A comprehensive log analysis

You can also complete the identification of data updates by analyzing the database log files. Oracle9i Logminer is a related utility that reads, analyzes, and interprets log files that are executed online or obtained through the Sol interface. With oracle9i Logminer, database administrators can test database updates, including data manipulation, definition, and management commands.

Recoverable declaration

Some large, long-running operations, such as data uploads and complex update processes, may have run out of resources (such as disk space) before they are complete. Long-running operations that do not end successfully may take a long time to run. Oracle9i handles this problem by allowing the database administrator to suspend operations that are impossible to complete. Once the operation is suspended, the database administrator can resolve the resource issue and then allow the statement to recover from the breakpoint.

Reduce planned downtime

Oracle9i allows fully scheduled maintenance operations that normally require downtime to run during normal service periods.

Online Schema modification

Oracle9i provides a mechanism that allows you to redefine the table structure while keeping the datasheet online and fully accessible to users and applications.

Reorganize tables and indexes online

Oralce9i also provides a simple mechanism to rearrange and define data tables while maintaining online and accessible to application users. Oracle9i's online table and indexing organization reduces planned downtime, increases application effectiveness, reduces disk fragmentation, and improves application performance.

Full online indexing operation

prev [1] [2] [3] [4] Next page

The Oracle tutorial you are looking at is Oracle 9i product documentation. > Using oracle9i, all table indexes can be created and recreated online. Without this kind of performance, users are prevented from running their applications when table indexes are created.

Dynamic database Parameters

Parameters that affect the amount of memory used by the database server in the Oracle9i database can now be reset online. This eliminates the need to offline and restart the database for parameter settings to take effect

[NextPage]

Eight, Dynamic Services

Oracle9i Dynamic Services enables your business to leverage the expertise of partners and other third parties by embedding a wide range of services on the Internet into your system.

Oracle9i Dynamic Services provides a single program architecture for accessing, assembling, managing, and implementing Internet services. This allows developers to increase the efficiency of developers and lower the cost of management without the complexity of interacting with multiple sources, multiple access protocols, and multiple channels.

At the heart of oracle9i Dynamic Services is a policy and service management engine that determines how services are executed. A variety of applications access dynamic services through the delivery of service requests to the Dynamics service engine. Search Dynamic Services registry dynamically service can be found at build time (development-time) or run time (run-time). Dynamic service descriptors can also be published in UDDI to facilitate the search of services across the Internet.

Oracle9i Dynamic Services provides a management environment that enables enterprises to define service policies such as priority, collection, and failure recovery. The Dynamic services engine crawls and records all information about service configuration and execution. A service monitor collects, for example, who, when, and at what frequency a service is requested. Audit features can be used for service execution records, failure notifications, and payments.

Because Oracle9i Dynamic Services is an open architecture (framework). Service providers and developers can easily customize dynamic services and launch channel services.

IX. Application Server Appliance

Oracle9i Application Server Appliance is a next-generation Oracle Network development tool based on Oracle9i application server and its original Web caching technology. With this latest Oracle tool, small or medium-sized enterprises or this type of enterprise can deploy their Web sites based on the industry's rapid application server and save costs. Alternatively, users can leverage Oracle's millions of dollars to guarantee their performance and quickly deploy their sites with existing web infrastructures.

The Oracle9i Application Server appliance has the following advantages:

Rapid Deployment Oracle9i Application Server Appliance is simple and can be used quickly and intuitively.

Low Total Cost: The organization using this tool can reduce the total cost of ownership (often up to 40%) compared to maintaining a traditional multi-purpose database server.

Simple to manage: Oracle 9i Application Server Appliance is Oracle Enterprise Manager (OEM) software with appliance Management Pack. The Appliance Management Pack expands

Oracle Enterprise Manager (OEM) performance not only manages databases, but also manages the entire software environment on Oracle appliances and a variety of running Oracle hardware devices.

Oracle8i Database Appliance Application on Microsoft NT SQL Server is 82% of the original total cost. With ORACLE9II application Server's powerful scalability and Web caching technology, customers are able to provide richer, more personalized web content to more users. Oracle9i Application Server uses an open Internet software standard that runs on a widely used Intel platform, giving customers a final combination of performance, reliability, and scalability.

Once the tool is installed, it will automatically install and automatically allocate work 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 configured automatically, automatically reassign workloads, and run better without the Web site stopping service.

[NextPage]

Ten, strong scalability

Oracle9i real application clusters from Oracle Parallel Server revolutionary upgrade products, after 6 years of hard development, 9 partners to participate in the registration of 18 technology patents, and there are still new patented technology in the registration.

The unique technologies offered by Oracle9i Real application clusters include:

Excellent, near-linear scalability transparency.

Compatibility with a variety of applications, no redesign is required.

Fast-growing clusters that quickly increase the capacity of nodes and disks.

Based on the architecture of Oracle Cache Fusion, oracle9i real application clusters provides transparent application scalability by quickly and efficiently sharing data that is frequently accessed on all servers in a cluster. Solve the competition between the servers.

When multiple servers want to access the same data, there are three scenarios to consider:

Read/read

A user reads a piece of information on one server while one user already reads the information on another server.
Read/write

A user will read a piece of information on one server while one user has updated the information on another server.

Write/write

A user updates a piece of information on one server while one user has updated the information on another server.

Under the cache Fusion structure, the read request may come from any memory cache in the cluster database. To ensure that the data in the cache is updated in a timely manner, it is important to collaborate between caches on each server to ensure that the data is read and updated consistently and correctly.

If a query request is provided by a remote cache, the information is transferred from one node cache to the cache on another node through a high-speed cluster connection. The occurrence of this caching fusion is completely automated and transparent to the application. This transparency is the key technology that oracle9i real application clusters can provide for high-speed, efficient scalability.

Xi. Real-time personalized management

Oracle personalized processing enables 1:1 of E-commerce services by providing real-time, dynamic personalized referral services to registered and anonymous visitors.

Oracle Personalized services provide powerful, scalable, and real-time personalization for e-business as Oracle products provide an integrated, real-time recommendation engine that is fully embedded in the Oracle9i database.

With the scalability of the Oracle9i database, Oracle Personalized services can maintain the uniqueness of each customer relationship while analyzing a large number of customer information. This will enable E-commerce services to provide customized, 1:1 of customer service, so that browsers comply with customer needs.

The use of data mining technology can be derived from the site of a large number of customer clicks, transactions, ratings and chart statistics to find the real need for electronic

prev [1] [2] [3] [4] Next page

The Oracle tutorial you are looking at is Oracle 9i product documentation. Business data. Oracle Personalized Services can answer the question:

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

The customer likes or has bought the product, then he may also buy other products?

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

Suppose a customer likes or is buying some other product, then he may buy those products?

Oracle Personalization Service is Oracle's first embedded data mining algorithm in the database. Other algorithms and targeted applications, such as customer retention/loss rates, response modeling, and customer information rollups, are then embedded.

Relevant pricing and product bundle information will be released prior to the new product listing.

Previous page

prev [1] [2] [3] [4]

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: info-contact@alibabacloud.com 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.