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
PL/SQL Function Result Cache → to cache the results of PL/SQL functions in a shared global area (SGA), which is available to every … relieves you of the burden of designing and developing your own caches and cache-management policies … . When a result-cached function is invoked, the system checks the cache. If the cache contains the … cached
Category Cache Hit Rules \"Equal To\" Operator Rules → Rules for a Cache Hit Each time a result-cached function is invoked with different parameter values … , those parameters and their result are stored in the cache. Subsequently, when the same function is … invoked with the same parameter values (that is, when there is a cache hit ), the result is … retrieved from the cache,
CACHE Hint → \", tablespec::= ) The CACHE hint instructs the optimizer to place the blocks retrieved for the table at … the most recently used end of the LRU list in the buffer cache when a full table scan is performed … . This hint is useful for small lookup tables. In the following example, the CACHE hint overrides the … default caching
Database Buffer Cache → The database buffer cache, also called the buffer cache, is the memory area that stores copies of … temporarily caches a currently or recently used data block. All users concurrently connected to a database instance share access to the buffer cache.
4.14 Enabling the Name Service Cache Daemon → , enable the Name Service Cache Daemon ( nscd ). To check to see if nscd is set to load when the system
Contents → Cache Concepts Data management design Overview of a cache grid Overview of cache groups Cache … instance Cache group types Transmitting updates between the TimesTen and Oracle databases Loading data … into a cache group: Explicitly loaded and dynamic cache groups Sharing
Contents → Database Cache Why is Oracle TimesTen In-Memory Database fast? TimesTen and TimesTen Cache feature … between servers Cached data with the TimesTen Cache Load data from an Oracle database into a … System monitoring Administration and utilities 2 Using TimesTen and TimesTen Cache Uses for TimesTen … Uses for TimesTen
Server Result Cache Concepts → The server result cache is a memory pool within the shared pool. This memory pool consists of the … SQL query result cache—which stores results of SQL queries—and the PL/SQL function result cache … , which stores values returned by PL/SQL functions. This section describes the server result cache and … contains
library cache pin → This event manages library cache concurrency. Pinning an object causes the heaps to be loaded into
Client Result Cache Concepts → Benefits of Using the Server Result Cache The benefits of using the server result cache depend on … views that materialize queries in the result cache instead of using tables. See Also: Oracle Database … Data Warehousing Guide for information about using the result cache and advance query rewrite with … equivalences
Cache Sequence Numbers → Allocating sufficient cache space for frequently updated sequence numbers significantly reduces the … frequency of dictionary cache locks, which improves scalability. To configure the number of cache … entries for each sequence: Use the CACHE keyword in the CREATE SEQUENCE or ALTER SEQUENCE statement.
About the Result Cache → A result cache is an area of memory, either in the Shared Global Area (SGA) or client application … types of result cache and contains the following topics: Server Result Cache Concepts Client Result Cache Concepts
Configuring the Result Cache → Benefits of Using the Client Result Cache OCI drivers, such as OCCI, the JDBC OCI driver, and … ODP.NET, support client result caching. Performance benefits of using the client result cache include … directly from the client cache memory, resulting in faster query response time. More efficient use of … making the server more scalable.
Monitoring the Result Cache → Table Annotation The FORCE table annotation forces the database to cache results at the table level … Result Cache To view information about the server and client result caches, query the relevant database … cache. Table 15-5 Views and Tables with Information About the Result Cache View/Table Description V … $RESULT_CACHE_STATISTICS
library cache lock → This event controls the concurrency between clients of the library cache. It acquires a lock on the … the object This lock is also obtained to locate an object in the library cache.
6.6.4 Database Smart Flash Cache Initialization Parameters → You can use a set of initialization parameters to configure Database Smart Flash Cache. Table 6-4 … Database Smart Flash Cache Initialization Parameters Parameter Description DB_FLASH_CACHE_FILE … Specifies a list of paths and file names for the files to contain Database Smart Flash Cache, in either … device. If you configure
6.6 Configuring Database Smart Flash Cache → The Database Smart Flash Cache feature is a transparent extension of the database buffer cache … using solid state device (SSD) technology. Database Smart Flash Cache can greatly improve the … equivalent amount of RAM. See Also: \" Memory Architecture Overview \" for a description of Database Smart Flash Cache
6.6.2 Sizing Database Smart Flash Cache → As a general rule, size Database Smart Flash Cache to be between 2 times and 10 times the size of … the buffer cache. Any multiplier less than two would not provide any benefit. If you are using … automatic shared memory management, make Database Smart Flash Cache between 2 times and 10 times the size
Table 15-1 Server Result Cache Initialization Parameters → Sizing the Server Result Cache Using Initialization Parameters Table 15-1 lists the database … initialization parameters that control the server result cache. Table 15-1 Server Result Cache … server result cache. To disable the server result cache, set this parameter to 0 … . RESULT_CACHE_MAX_RESULT
Configuring the Server Result Cache → By default, on database startup, Oracle Database allocates memory to the server result cache in the … value of the SGA_TARGET parameter to the result cache. Manual shared memory management If you are … Database allocates 1% of the shared pool size to the result cache. Note: Oracle Database will not … allocate more than 75% of