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 cache


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


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

PL/SQL Function Result Cacheto 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

Category Cache Hit Rules \"Equal To\" Operator RulesRules 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,

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

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 Concepts, 12c Release 1 (12.1)

Memory Architecture

Database Buffer CacheThe 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.

Grid Infrastructure Installation Guide for Linux, 12c Release 1 (12.1)

Configuring Operating Systems for Oracle Grid Infrastructure and Oracle RAC

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

TimesTen Application-Tier Database Cache User's Guide, 12c Release 1 (12.1)

TimesTen Application-Tier Database Cache User's Guide - Contents

ContentsCache 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

TimesTen Application-Tier Database Cache Introduction, 12c Release 1 (12.1)

TimesTen Application-Tier Database Cache Introduction - Contents

ContentsDatabase 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

Server Result Cache ConceptsThe 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Instance Tuning Using Performance Views

library cache pinThis event manages library cache concurrency. Pinning an object causes the heaps to be loaded into

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

Client Result Cache ConceptsBenefits 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Shared Pool and the Large Pool

Cache Sequence NumbersAllocating 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.

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

About the Result CacheA 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

Configuring the Result CacheBenefits 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.

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

Monitoring the Result CacheTable 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Instance Tuning Using Performance Views

library cache lockThis 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.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Memory

6.6.4 Database Smart Flash Cache Initialization ParametersYou 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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Memory

6.6 Configuring Database Smart Flash CacheThe 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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Memory

6.6.2 Sizing Database Smart Flash CacheAs 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

Table 15-1 Server Result Cache Initialization ParametersSizing 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Result Cache

Configuring the Server Result CacheBy 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