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
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
Sizing the Flash Cache → As a general rule, size the 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 the flash cache between 2 times and 10 times the size of SGA_TARGET. Using
Flash Cache Initialization Parameters → Table 6-4 describes the initialization parameters that you use to configure the flash cache. Table … 6-4 Flash Cache Initialization Parameters Parameter Description db_flash_cache_file Specifies the … path and file name for the file to contain the flash cache, in either the operating system file system … creates it during startup.
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
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
Configuring Database Smart Flash Cache → This section contains the following topics on configuring Database Smart Flash Cache (the flash … cache): When to Configure the Flash Cache Sizing the Flash Cache Tuning Memory for the Flash Cache … Flash Cache Initialization Parameters Flash Cache in an Oracle Real
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
10.3.12 library cache pin → This event manages library cache concurrency. Pinning an object causes the heaps to be loaded into
Database Smart Flash Cache → feature is a transparent extension of the database buffer cache using solid state device (SSD … ) technology. The SSD acts as a Level 2 cache to the (Level 1) Oracle system global area (SGA). SSD … storage is faster than disk storage, and cheaper than RAM. Database Smart Flash Cache with SSD storage … amount of disk I/O at a lower
10.3.13 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.
When to Configure the Flash Cache → Consider adding the flash cache when all of the following are true: Your database is running on the … Solaris or Oracle Linux operating systems. The flash cache is supported on these operating systems … STATSPACK report indicates that doubling the size of the buffer cache would be beneficial. db file … sequential read is a top
Tuning Memory for the Flash Cache → For each database block moved from the buffer cache to the flash cache, a small amount of metadata … about the block is kept in the buffer cache. For a single instance database, the metadata consumes … flash cache. If you are managing memory manually, increase the size of the buffer cache by an amount
cache → Also known as buffer cache. All buffers and buffer pools.
CACHE → Within an aggregation specification, a CACHE statement tells Oracle OLAP whether to cache or store … using detail data from another variable, and whether to cache NA values when a summary values … calculates to NA. Note: The CACHE statement is only one factor that determines whether variable data that … Determines
CACHE → Specifies slightly different internal behavior. Specify this keyword only when the original performance is extremely slow. dimension The name of a dimension of the result; or, the name of a relation between one dimension of boolean-expression and another dimension that you want as a dimension of the result. By default, ANY returns a single YES or NO value. When you indicate one or more dimensions
CACHE → CHANGED keyword AW LIST shows the analytic workspace as unattached. Cache Size By default the list … on the cached at one time and as new workspaces are added to the cache list, earlier workspaces are … : 1) mywk1, 2) mywk2. Now you issue an AW DETACH CACHE command for mywk3. Oracle OLAP removes mywk1 … from the cache
Cache → -7 Cache Attributes Attribute Description Cache Page Specify whether to enable page caching by … selecting Yes or No. Page caching can improve performance because the page displays from cache instead of … displaying dynamically. Cache Timeout Specify the amount of time for which a cached page remains … valid.
V$CACHE → from the cache because another instance has forced it out of this instance's cache by requesting the … block to cache because this instance had used the block and another instance had requested the lock on
7.1.4 Dynamically Changing Cache Sizes → can choose to dynamically reconfigure the sizes of the shared pool, the large pool, the buffer cache … : Configuring and Using the Buffer Cache Configuring and Using the Shared Pool and Large Pool Configuring and … . Memory for the shared pool, large pool, java pool, and buffer cache is allocated in units of … SGA_MAX_SIZE parameter.