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
1.267 SORT_AREA_SIZE → SORT_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle … . SORT_AREA_SIZE is retained for backward compatibility. SORT_AREA_SIZE specifies (in bytes) the … of the memory. Increasing SORT_AREA_SIZE size improves the efficiency of large sorts. Each sort in a … query can
SORT_AREA_SIZE → has been deprecated and you should use PGA_AGGREGATE_TARGET instead.
n/a Auto Manual The database automatically tunes the SGA based on an SGA target. You control the PGA… → for the IM column store in the SGA ( INMEMORY_SIZE ) PGA work area parameters such as SORT_AREA_SIZE
n/a Manual Manual You must manually configure SGA component sizes. You control the PGA manually, setting… → SORT_AREA_SIZE, HASH_AREA_SIZE, and BITMAP_MERGE_AREA_SIZE The database automatically configures the
5.1.8 Rollback Segments and Sort Area Size → parameter SORT_AREA_SIZE affects the amount of time required to create the index. The SORT_AREA_SIZE … a spatial index. To change the SORT_AREA_SIZE value, use the ALTER SESSION statement. For example … , to change the value to 20 million bytes: ALTER SESSION SET SORT_AREA_SIZE = 20000000;
21.2.1 Create Indexes After Inserting Table Data → initialization parameter SORT_AREA_SIZE. The database also swaps sort information to and from temporary
1.266 SORT_AREA_RETAINED_SIZE → Property Description Parameter type Integer Default value Derived from SORT_AREA_SIZE Modifiable … equivalent of two database blocks to the value of SORT_AREA_SIZE Basic No Note: Oracle does not recommend … SORT_AREA_RETAINED_SIZE is reached. The difference between SORT_AREA_RETAINED_SIZE and SORT_AREA_SIZE is … SORT_AREA_SIZE
6.4.5 Using Manual PGA Memory Management → of SQL work areas by setting the following parameters: SORT_AREA_SIZE, HASH_AREA_SIZE
Sizing the Program Global Area → the associated _AREA_SIZE parameter, such as the SORT_AREA_SIZE initialization parameter. This
Recommended Initialization Parameters for Parallelism → usage for sorts and joins automatically. If the memory parameters are set manually, SORT_AREA_SIZE
1.107 HASH_AREA_SIZE → Property Description Parameter type Integer Default value Derived: 2 * SORT_AREA_SIZE Modifiable
Changing Initialization Parameters → reduces checkpoints to a minimum (at log switching time). Increase the value of SORT_AREA_SIZE. The
17.4 CREATE INDEX → the rollback segment size and the SORT_AREA_SIZE parameter value are adequate, as described in
Configuring the Large Pool for Shared Server Architecture → shared servers, set the values of the SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE initialization
Tuning Queries with Blocking Operations → the result set containing these rowid and score pairs exceeds the SORT_AREA_SIZE initialization … disk causes extra overhead, you can improve performance by increasing the SORT_AREA_SIZE parameter … using ALTER SESSION as follows: alter session set SORT_AREA_SIZE =. For example, to set the buffer to … approximately 8 megabytes,
1.297 WORKAREA_SIZE_POLICY → SORT_AREA_SIZE ). Specifying MANUAL may result in sub-optimal performance and poor PGA memory utilization
Table 17-1 Oracle Database and Operating System Operational Parameters → … SORT_AREA_SIZE Determines I/O sizes and concurrency for sort operations. HASH_AREA_SIZE Determines the I
Which memory settings affect querying? → parameters dynamically. The SORT_AREA_SIZE parameter controls the memory available for sorting for ORDER BY … parameters Oracle Database Performance Tuning Guide for more information on memory allocation and setting the SORT_AREA_SIZE parameter
direct path read and direct path read temp → , then consider increasing the SORT_AREA_SIZE for the system (if the sorts are not too big) or for