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
BUFFER → determine 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,
BUFFER → Default: 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
Redo Log Buffer → Figure 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 Buffer Cache → The 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
buffer → A main memory address in the database buffer cache. A buffer caches currently and recently used
7.4.2 Log Buffer Statistics → The 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
10.3.1 buffer busy waits → This 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
10.3.14 log buffer space → This 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
10.3.8 free buffer waits → This 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 buffer … buffer
3.2.5 Configuring Storage NFS Mount and Buffer Size Parameters → If 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
BUFFER → Is 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
buffer → A 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
buffer deadlock → deadlock by the cache layer. The cache layer cannot get a buffer in a certain mode within a certain
buffer latch → The 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
7.2.6 Buffer Pool Hit Ratios → The 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
7.2.4 Considering Multiple Buffer Pools → A 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
7.4.1 Sizing the Log Buffer → Figure 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
7.2.2 Sizing the Buffer Cache → When configuring a new instance, it is impossible to know the correct size for the buffer cache … or over configured. 22.214.171.124 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 126.96.36.199 … set to ON.
3.2.6 Checking NFS Mount and Buffer Size Parameters for Oracle Clusterware → On the cluster member nodes, you must set the values for the NFS buffer size parameters rsize and
3.2.7 Checking NFS Mount and Buffer Size Parameters for Oracle RAC → If 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