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 buffer


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


Database Utilities, 11g Release 2 (11.2)

Original Export

BUFFERdetermine the default value for this parameter. Specifies the size, in bytes, of the buffer used to … Export. Use the following formula to calculate the buffer size: buffer_size = rows_in_array … . Note: The BUFFER parameter applies only to conventional path Export. It has no effect on a direct … path Export. For direct path Exports,

Database Utilities, 11g Release 2 (11.2)

Original Import

BUFFERDefault: operating system-dependent The integer specified for BUFFER is the size, in bytes, of the … buffer through which data rows are transferred. BUFFER determines the number of rows in the array … inserted by Import. The following formula gives an approximation of the buffer size that inserts a … buffer

Database Concepts, 11g Release 2 (11.2)

Memory Architecture

Redo Log BufferFigure 14-6 Buffer Search Description of \"Figure 14-6 Buffer Search\" In general, accessing data … through a cache hit is faster than through a cache miss. The buffer cache hit ratio measures how … often the database found a requested block in the buffer cache without needing to read it from disk. The … database

Database Concepts, 11g Release 2 (11.2)

Memory Architecture

Database Buffer CacheThe database buffer cache, also called the buffer cache, is the memory area that stores copies of … data blocks read from data files. A buffer is a main memory address in which the buffer manager … database instance share access to the buffer cache. Oracle Database uses the buffer cache

Database Concepts, 11g Release 2 (11.2)

Glossary

bufferA main memory address in the database buffer cache. A buffer caches currently and recently used

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

Configuring and Using Memory

7.4.2 Log Buffer StatisticsThe statistic REDO BUFFER ALLOCATION RETRIES reflects the number of times a user process waits for … space in the redo log buffer. This statistic can be queried through the dynamic performance view V … running: SELECT NAME, VALUE FROM V$SYSSTAT WHERE NAME = 'redo buffer allocation retries'; The value … of redo buffer

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

Instance Tuning Using Performance Views

10.3.1 buffer busy waitsThis wait indicates that there are some buffers in the buffer cache that multiple processes are … attempting to access concurrently. Query V$WAITSTAT for the wait statistics for each class of buffer … . Common buffer classes that have buffer busy waits include data block, segment header, undo header … value of

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

Instance Tuning Using Performance Views

10.3.14 log buffer spaceThis event occurs when server processes are waiting for free space in the log buffer, because all … the redo is generated faster than LGWR can write it out. Actions Modify the redo log buffer size. If … the size of the log buffer is reasonable, then ensure that the disks on which the online redo logs … reside do not suffer from

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

Instance Tuning Using Performance Views

10.3.8 free buffer waitsThis wait event indicates that a server process was unable to find a free buffer and has posted the … database writer to make free buffers by writing out dirty buffers. A dirty buffer is a buffer whose … situations: The I/O system is slow. There are resources it is waiting for, such as latches. The bufferbuffer

Grid Infrastructure Installation Guide for Linux, 11g Release 2 (11.2)

Configuring Storage for Oracle Grid Infrastructure for a Cluster and Oracle RAC

3.2.5 Configuring Storage NFS Mount and Buffer Size ParametersIf you are using NFS for the Grid home or Oracle RAC home, then you must set up the NFS mounts on the storage so that they allow root on the clients mounting to the storage to be considered root instead of being mapped to an anonymous user, and allow root on the client server to create files on the NFS filesystem that are owned by root. On NFS, you can obtain root access for clients writing to the

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Oracle Dynamic SQL: Method 4

BUFFERIs a data buffer that stores the value or name of a select-list item, bind variable, or indicator … variable. ADDRESS Is an integer variable that returns the address of the data buffer. A call to … SQLADR stores the address of BUFFER in ADDRESS. The next example uses SQLADR to initialize the select

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

Glossary

bufferA main memory address where the buffer manager caches currently and recently used data read from … disk. Over time, a buffer can hold different blocks. When a new block is needed, the buffer manager

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

buffer deadlockdeadlock by the cache layer. The cache layer cannot get a buffer in a certain mode within a certain

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

buffer latchThe session waits on the buffer hash chain latch. Primarily used in the dump routines. Wait Time: 1 … where addr = latch addr and a.latch# = b.latch#; chain# The index into array of buffer hash chains

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

Configuring and Using Memory

7.2.6 Buffer Pool Hit RatiosThe data in V$SYSSTAT reflects the logical and physical reads for all buffer pools within one set … of statistics. To determine the hit ratio for the buffer pools individually, query the V … writes. The buffer pool hit ratio can be determined using the following formula: 1 - (physical_reads

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

Configuring and Using Memory

7.2.4 Considering Multiple Buffer PoolsA single default buffer pool is generally adequate for most systems. However, users with detailed … knowledge of an application's buffer pool might benefit from configuring multiple buffer pools. With … buffer pools: the KEEP pool and the RECYCLE pool. A segment's access pattern may be atypical if it is … batch

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

Configuring and Using Memory

7.4.1 Sizing the Log BufferFigure 7-2 Redo Log Buffer Description of \"Figure 7-2 Redo Log Buffer\" 7.4.1 Sizing the Log … Buffer Applications that insert, modify, or delete large volumes of data usually need to change the … default log buffer size. The log buffer is small compared with the total SGA size, and a modestly sized

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

Configuring and Using Memory

7.2.2 Sizing the Buffer CacheWhen configuring a new instance, it is impossible to know the correct size for the buffer cache … or over configured. 7.2.2.1 Buffer Cache Advisory Statistics You can use several statistics to … examine buffer cache activity, including the following: V$DB_CACHE_ADVICE Buffer cache hit ratio 7.2.2.2 … set to ON.

Grid Infrastructure Installation Guide for Linux, 11g Release 2 (11.2)

Configuring Storage for Oracle Grid Infrastructure for a Cluster and Oracle RAC

3.2.6 Checking NFS Mount and Buffer Size Parameters for Oracle ClusterwareOn the cluster member nodes, you must set the values for the NFS buffer size parameters rsize and

Grid Infrastructure Installation Guide for Linux, 11g Release 2 (11.2)

Configuring Storage for Oracle Grid Infrastructure for a Cluster and Oracle RAC

3.2.7 Checking NFS Mount and Buffer Size Parameters for Oracle RACIf you use NFS mounts, then you must mount NFS volumes used for storing database files with special mount options on each node that has an Oracle RAC instance. When mounting an NFS file system, Oracle recommends that you use the same mount point options that your NAS vendor used when certifying the device. Refer to your device documentation or contact your vendor for information about recommended