You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for scalability


1 to 40 of 294 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database PL/SQL Language Reference, 11g Release 2 (11.2)

Overview of PL/SQL

ScalabilityPL/SQL stored subprograms increase scalability by centralizing application processing on the … \". For further scalability, you can use Oracle Connection Manager to multiplex network connections. For

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Disk Groups

Performance and Scalability Considerations for Disk Groupsperformance views Performance and Scalability Considerations for Disk Groups This section discusses the

Database Performance Tuning Guide, 11g Release 2 (11.2)

Designing and Developing for Performance

2.3.2 System ScalabilityApplications that are accessible through the Internet have more complex performance and availability requirements. Some applications are designed and written only for Internet use, but even typical back-office applications—such as a general ledger application—might require some or all data to be available online. Characteristics of Internet age applications include the following: Availability 24 hours

Database Performance Tuning Guide, 11g Release 2 (11.2)

Designing and Developing for Performance

2.3.1 What is Scalability?Scalability is a system's ability to process more workload, with a proportional increase in system … resource usage might exceed twice the original workload. Examples of poor scalability due to

Database Performance Tuning Guide, 11g Release 2 (11.2)

Designing and Developing for Performance

2.3.3 Factors Preventing Scalabilityscalability in mind from the start. 2.3.3 Factors Preventing Scalability When building applications … , designers and architects should aim for as close to perfect scalability as possible. This is … sometimes called linear scalability, where system throughput is directly proportional to the number of … CPUs. In

Database Performance Tuning Guide, 11g Release 2 (11.2)

Designing and Developing for Performance

2.3 Understanding ScalabilityThe word scalability is used in many contexts in development environments. The following section … provides an explanation of scalability that is aimed at application designers and performance … specialists. This section covers the following topics: What is Scalability? System Scalability Factors Preventing Scalability

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Creating PL/SQL Mappings

Scalabilitycode. After reinitialization, the mapping debug session starts from the beginning. ScalabilityScalability when debugging a mapping applies both to the amount of data that is passed and to the number

Database New Features Guide, 11g Release 2 (11.2)

Oracle Database 11g Release 2 (11.2.0.1) New Features

4.3.4 Improved Performance and ScalabilityPerformance and Scalability The following sections describe new and improved performance and scalability capabilities in this release.

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Overview of PL/SQL

Advantages of PL/SQLPortability Scalability Manageability Support for Object-Oriented Programming Support for Developing Web Applications Support for Developing Server Pages

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

What's New in Oracle Streams Advanced Queuing?

Scalability for Streams NotificationsAQ Event Notification Infrastructure provides asynchronous communication of database events from the suppliers/publishers of their events to the consumers/registrations. The event monitor sends these notifications. In order to meet the demands of increased notification use, the notification server in 11g is enhanced to a parallel notification server consisting of a coordinator and a set of subordinate

OLAP User's Guide, 11g Release 2 (11.2)

Overview

Unmatched Performance and Scalabilityapplications receive the same benefits in performance, scalability, fail over, and load balancing as any other application.

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Design and Deployment Techniques

Scalability of Oracle RACmultiple systems. It provides scalability beyond the capacity of a single server. If your

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Using Partitioning in a Data Warehouse Environment

Scalabilitythe scalability requirements of data warehouses. This section contains the following topics: Bigger

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Glossary

scalabilityThe ability to add additional nodes to Oracle RAC applications and achieve markedly improved scale-up and speed-up.

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Packages

SERIALLY_REUSABLE Packagespackages let you design applications that manage memory better for scalability. If a package is not … scalability. The package state can persist for the life of a session, locking UGA memory until the session

Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2)

OCI: Introduction and Upgrading

Extensions to Improve Application Performance and ScalabilityOCI provides several feature extensions to improve application performance and scalability … , and scalability improvements have been made by reducing the amount of state information that must be … interface's TM_JOIN operation Improved scalability by providing the ability to concentrate connections

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

5 Oracle Streams Advanced Queuing Performance and ScalabilityThis chapter discusses performance and scalability issues relating to Oracle Streams Advanced

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Using Storage ParametersStorage parameters can be specified when creating a queue table using the storage_clause parameter. Storage parameters are inherited by other IOTs and tables created with the queue table. The tablespace of the queue table should have sufficient space to accommodate data from all the objects associated with the queue table. With retention specified, the history table as well as the queue table can

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Oracle Streams Advanced Queuing and Oracle Real Application ClustersOracle Real Application Clusters (Oracle RAC) can be used to ensure highly available access to queue data. The entry and exit points of a queue, commonly called its tail and head respectively, can be extreme hot spots. Because Oracle RAC may not scale well in the presence of hot spots, limit usual access to a queue from one instance only. If an instance failure occurs, then messages managed by the

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Persistent Messaging Basic Tuning TipsOracle Streams Advanced Queuing table layout is similar to a layout with ordinary database tables and indexes. See Also: Oracle Database Performance Tuning Guide for tuning recommendations

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Running Enqueue and Dequeue Processes Serially in a Single Queue TableWhen enqueue and dequeue processes are running serially, contention on the same data segment is lower than in the case of concurrent processes. The total time taken to deliver messages by the system, however, is longer than when they run concurrently. Increasing the number of processes helps both enqueuing and dequeuing. The message throughput rate may be higher for enqueuers than for dequeuers when

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Oracle Streams Advanced Queuing in a Shared Server EnvironmentQueue operation scalability is similar to the underlying database operation scalability. If a … processes can cause severe performance and scalability problems and can result in deadlocking the

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Buffered Messaging TuningBuffered messaging operations in a Oracle Real Application Clusters environment will be fastest on the OWNER_INSTANCE of the queue.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Performance ViewsOracle provides views to monitor system performance and troubleshooting: (G)V$PERSISTENT_QUEUES: All Active Persistent Queues in the Instance (G)V$PERSISTENT_SUBSCRIBERS: All Active Subscribers of the Persistent Queues in the Instance (G)V$PERSISTENT_PUBLISHERS: All Active Publishers of the Persistent Queues in the Instance (G)V$BUFFERED_QUEUES: All Buffered Queues in the Instance. (G)V$BUFFERED_SUBSCRIBERS:

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

I/O ConfigurationBecause Oracle Streams Advanced Queuing is very I/O intensive, you will usually need to tune I/O to remove any bottlenecks. See Also: \"I/O Configuration and Design\" in Oracle Database Performance Tuning Guide

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Running Enqueue and Dequeue Processes Concurrently in a Single Queue Tablecontention. Multiple queue tables may be used garnering horizontal scalability.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Creating Indexes on a Queue TableCreating an index on a queue table is useful if you: Dequeue using correlation ID An index created on the column corr_id of the underlying queue table AQ$_ QueueTableName expedites dequeues. Dequeue using a condition This is like adding the condition to the where-clause for the SELECT on the underlying queue table. An index on QueueTableName expedites performance on this SELECT statement.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Persistent Messaging Performance OverviewWhen persistent messages are enqueued, they are stored in database tables. The performance characteristics of queue operations on persistent messages are similar to underlying database operations. The code path of an enqueue operation is comparable to SELECT and INSERT into a multicolumn queue table with three index-organized tables. The code path of a dequeue operation is comparable to a SELECT operation

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Memory RequirementsStreams pool size should be at least 20 MB for optimal multi-consumer dequeue performance in a non-RACdatabase. Persistent queuing dequeue operations use the streams pool to optimize performance, especially under concurrency situations. This is, however, not a requirement and the code automatically switches to a less optimal code path.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Other Tipssevere performance and scalability problems and can result in deadlocking the shared server processes

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Propagation Tuning Tipsmultiple job queue processes. Rather, they are load balanced. For better scalability, configure the number

Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2)

OCI Programming Advanced Topics

Benefiting from the Scalability of DRCP in an OCI ApplicationConsider the following three types of application scenarios and note how each benefits from DRCP: Applications that do not use OCI session pooling and also do not specify any connection class or purity setting (or specify a purity setting of NEW ) get a new session from the DRCP. Similarly, when the application releases a connection back to the pool, the session is not shared with other instances

Database PL/SQL Language Reference, 11g Release 2 (11.2)

What's New in PL/SQL?

PL/SQL Features for Oracle Database 11g Release 1scalability. You can use sequence_name. CURRVAL and sequence_name. NEXTVAL wherever you can use a NUMBER

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Database PL/SQL Language Reference - Contents

Contents/SQL Tight Integration with SQL High Performance High Productivity Portability Scalability

Database JDBC Developer's Guide, 11g Release 2 (11.2)

Performance and Scalability

Performance and ScalabilityPart V Performance and Scalability This part consists of chapters that discuss the Oracle Java

Database 2 Day Developer's Guide, 11g Release 2 (11.2)

Building Effective Applications

About Concurrency and Scalabilitycommitted isolation is perfect. Oracle Database has features that improve concurrency and scalability—for … improving the concurrency and scalability of your application. See Also: Oracle Database Concepts for … decrease in scalability. If you can use either an approach that runs slightly faster during development or

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Storage Management for VLDBs

Scalability and ManageabilityA very important characteristic of a VLDB is its large size. Storage scalability and management is

TimesTen In-Memory Database Operations Guide, 11g Release 2 (11.2)

Glossary

scalabilityThe degree to which a system or application can handle increasing demands on system resources without significant performance degradation.

Database 2 Day + Real Application Clusters Guide, 11g Release 2 (11.2)

Glossary

scalabilityThe ability to add additional nodes to Oracle Real Application Clusters applications and achieve markedly improved scale-up and speed-up.

Database JDBC Developer's Guide, 11g Release 2 (11.2)

Diagnosability in JDBC

Performance, Scalability, and Security IssuesPerformance, Scalability, and Security Issues Although the logging feature enables you to trace or debug your … application and generate detail log output, it has certain performance, scalability, and security … issues. Performance and Scalability Issues Logging has substantial impact on performance. However … impact on performance.