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 → 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
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,
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.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
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
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
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.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. 188.8.131.52 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 184.108.40.206 … set to ON.
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 Configuring and Using the Buffer Cache → For many types of operations, Oracle Database uses the buffer cache to store blocks read from disk … . Oracle Database bypasses the buffer cache for particular operations, such as sorting and parallel … reads. For operations that use the buffer cache, this section explains the following: Using the … Buffer Cache
7.2.1 Using the Buffer Cache Effectively → To use the buffer cache effectively, tune SQL statements for the application to avoid unnecessary … statements that perform many buffer gets have been tuned. When using parallel query, you can configure … the database to use the database buffer cache instead of performing direct reads into the PGA. This
7.2.5 Buffer Pool Data in V$DB_CACHE_ADVICE → You can use V$DB_CACHE_A DVICE to size all pools configured on a database instance. Make the initial cache size estimate, run the representative workload, then simply query the V$DB_CACHE_ADVICE view for the pool you want to use. For example, to query data from the KEEP pool: SELECT SIZE_FOR_ESTIMATE, BUFFERS_FOR_ESTIMATE, ESTD_PHYSICAL_READ_FACTOR, ESTD_PHYSICAL_READS FROM V$DB_CACHE_ADVICE WHERE
log buffer space → Waiting for space in the log buffer because the session is writing data into the log buffer faster … than LGWR can write it out. Consider making the log buffer bigger if it is small, or moving the log … information about potential causes of the log buffer space wait event
buffer busy waits → Wait until a buffer becomes available. There are four reasons that a session cannot pin a buffer in … the buffer cache, and a separate wait event exists for each reason: \"buffer busy waits\": A … session cannot pin the buffer in the buffer cache because another session has the buffer