How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Scalability → PL/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
Performance and Scalability Considerations for Disk Groups → performance views Performance and Scalability Considerations for Disk Groups This section discusses the
2.3.2 System Scalability → Applications 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
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
2.3.3 Factors Preventing Scalability → scalability 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
2.3 Understanding Scalability → The 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
Scalability → code. After reinitialization, the mapping debug session starts from the beginning. Scalability … Scalability when debugging a mapping applies both to the amount of data that is passed and to the number
4.3.4 Improved Performance and Scalability → Performance and Scalability The following sections describe new and improved performance and scalability capabilities in this release.
Advantages of PL/SQL → Portability Scalability Manageability Support for Object-Oriented Programming Support for Developing Web Applications Support for Developing Server Pages
Scalability for Streams Notifications → AQ 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
Unmatched Performance and Scalability → applications receive the same benefits in performance, scalability, fail over, and load balancing as any other application.
Scalability of Oracle RAC → multiple systems. It provides scalability beyond the capacity of a single server. If your
Scalability → the scalability requirements of data warehouses. This section contains the following topics: Bigger
scalability → The ability to add additional nodes to Oracle RAC applications and achieve markedly improved scale-up and speed-up.
SERIALLY_REUSABLE Packages → packages 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
Extensions to Improve Application Performance and Scalability → OCI 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
5 Oracle Streams Advanced Queuing Performance and Scalability → This chapter discusses performance and scalability issues relating to Oracle Streams Advanced
Using Storage Parameters → Storage 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
Oracle Streams Advanced Queuing and Oracle Real Application Clusters → Oracle 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
Persistent Messaging Basic Tuning Tips → Oracle 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
Running Enqueue and Dequeue Processes Serially in a Single Queue Table → When 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
Oracle Streams Advanced Queuing in a Shared Server Environment → Queue 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
Buffered Messaging Tuning → Buffered messaging operations in a Oracle Real Application Clusters environment will be fastest on the OWNER_INSTANCE of the queue.
Performance Views → Oracle 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:
I/O Configuration → Because 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
Running Enqueue and Dequeue Processes Concurrently in a Single Queue Table → contention. Multiple queue tables may be used garnering horizontal scalability.
Creating Indexes on a Queue Table → Creating 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.
Persistent Messaging Performance Overview → When 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
Memory Requirements → Streams 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.
Other Tips → severe performance and scalability problems and can result in deadlocking the shared server processes
Propagation Tuning Tips → multiple job queue processes. Rather, they are load balanced. For better scalability, configure the number
Benefiting from the Scalability of DRCP in an OCI Application → Consider 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
PL/SQL Features for Oracle Database 11g Release 1 → scalability. You can use sequence_name. CURRVAL and sequence_name. NEXTVAL wherever you can use a NUMBER
Contents → /SQL Tight Integration with SQL High Performance High Productivity Portability Scalability
Performance and Scalability → Part V Performance and Scalability This part consists of chapters that discuss the Oracle Java
About Concurrency and Scalability → committed 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
Scalability and Manageability → A very important characteristic of a VLDB is its large size. Storage scalability and management is
scalability → The degree to which a system or application can handle increasing demands on system resources without significant performance degradation.
scalability → The ability to add additional nodes to Oracle Real Application Clusters applications and achieve markedly improved scale-up and speed-up.
Performance, Scalability, and Security Issues → Performance, 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.