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 SORT_AREA_SIZE


1 to 20 of 32 results. Previous page Prev  Next next page


Database Reference, 12c Release 1 (12.1)

SORT_AREA_SIZE

1.267 SORT_AREA_SIZESORT_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

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

PGA_AGGREGATE_TARGET

SORT_AREA_SIZEhas been deprecated and you should use PGA_AGGREGATE_TARGET instead.

Database Concepts, 12c Release 1 (12.1)

Concepts for Database Administrators

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

Database Concepts, 12c Release 1 (12.1)

Concepts for Database Administrators

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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Rollback Segments and Sort Area Size

5.1.8 Rollback Segments and Sort Area Sizeparameter 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;

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.2.1 Create Indexes After Inserting Table Datainitialization parameter SORT_AREA_SIZE. The database also swaps sort information to and from temporary

Database Reference, 12c Release 1 (12.1)

SORT_AREA_RETAINED_SIZE

1.266 SORT_AREA_RETAINED_SIZEProperty 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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Memory

6.4.5 Using Manual PGA Memory Managementof SQL work areas by setting the following parameters: SORT_AREA_SIZE, HASH_AREA_SIZE

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Program Global Area

Sizing the Program Global Areathe associated _AREA_SIZE parameter, such as the SORT_AREA_SIZE initialization parameter. This

Database Data Warehousing Guide, 12c Release 1 (12.1)

Refreshing Materialized Views

Recommended Initialization Parameters for Parallelismusage for sorts and joins automatically. If the memory parameters are set manually, SORT_AREA_SIZE

Database Reference, 12c Release 1 (12.1)

HASH_AREA_SIZE

1.107 HASH_AREA_SIZEProperty Description Parameter type Integer Default value Derived: 2 * SORT_AREA_SIZE Modifiable

Database Utilities, 12c Release 1 (12.1)

Changing Initialization Parameters

Changing Initialization Parametersreduces checkpoints to a minimum (at log switching time). Increase the value of SORT_AREA_SIZE. The

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

CREATE INDEX

17.4 CREATE INDEXthe rollback segment size and the SORT_AREA_SIZE parameter value are adequate, as described in

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Shared Pool and the Large Pool

Configuring the Large Pool for Shared Server Architectureshared servers, set the values of the SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE initialization

Text Application Developer's Guide, 12c Release 1 (12.1)

Tuning Queries with Blocking Operations

Tuning Queries with Blocking Operationsthe 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,

Database Reference, 12c Release 1 (12.1)

WORKAREA_SIZE_POLICY

1.297 WORKAREA_SIZE_POLICYSORT_AREA_SIZE ). Specifying MANUAL may result in sub-optimal performance and poor PGA memory utilization

Database Performance Tuning Guide, 12c Release 1 (12.1)

I/O Configuration and Design

Table 17-1 Oracle Database and Operating System Operational ParametersSORT_AREA_SIZE Determines I/O sizes and concurrency for sort operations. HASH_AREA_SIZE Determines the I

Text Application Developer's Guide, 12c Release 1 (12.1)

Frequently Asked Questions About Query Performance

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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Instance Tuning Using Performance Views

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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Managing Operating System Resources

Using Operating System Resource Managersby PL/SQL, such as PL/SQL tables SORT_AREA_SIZE initialization parameter In Oracle Database, the