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 INMEMORY_SIZE


1 to 20 of 27 results.


Database Reference, 12c Release 1 (12.1)

INMEMORY_SIZE

1.116 INMEMORY_SIZEProperty Description Parameter type Big integer Syntax INMEMORY_SIZE = integer [K | M | G] Default … . INMEMORY_SIZE sets the size of the In-Memory Column Store (IM column store) on a database instance … Guide for an example of using the INMEMORY_SIZE parameter

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 … ( LARGE_POOL_SIZE ) Java pool size ( JAVA_POOL_SIZE ) Optional size for the IM column store ( INMEMORY_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…size for the IM column store ( INMEMORY_SIZE ) in the SGA PGA work area parameters such as

Database Concepts, 12c Release 1 (12.1)

Concepts for Database Administrators

Starting in Oracle Database 12c Release 1 12.1.0.2, the In-Memory Column Store IM column store is an…method you use, you must size the IM column store separately with the INMEMORY_SIZE initialization … automatic area resize algorithm. Thus, if you set MEMORY_TARGET to 5 GB, and INMEMORY_SIZE to 1 GB … , then the overall memory target is 5 GB (not 6 GB), and the INMEMORY_SIZE is always 1 GB. Figure 20-6

Database Concepts, 12c Release 1 (12.1)

Memory Architecture

Availability is the degree to which an application, service, or functionality is available on demand.… Configuration is simple. The INMEMORY_SIZE initialization parameter specifies the amount of memory reserved … Database Reference to learn about the INMEMORY_SIZE and INMEMORY_FORCE initialization parameters

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

Tuning the System Global Area

Sizing the In-Memory Column StoreColumn Store based on their compression methods, you can set its size by using the INMEMORY_SIZE … initialization parameter. To set the size of the In-Memory Column Store: Set the INMEMORY_SIZE … the INMEMORY_SIZE initialization parameter Example 12-3 shows an example of setting the size of the In … -Memory Column Store to 100

Database Concepts, 12c Release 1 (12.1)

Concepts for Database Administrators

Table 20-1 Memory Management Methodstable includes the INMEMORY_SIZE initialization parameter, which is available starting in Oracle … Database 12c Release 1 (12.1.0.2). The IM column store is optional, but the INMEMORY_SIZE parameter is … store ( INMEMORY_SIZE ) in the SGA n/a Auto Auto The database automatically tunes the SGA based on an … ( INMEMORY_SIZE

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

Tuning the System Global Area

Sizing the SGA Components Manually-memory column store is an optional static SGA pool. It is sized using the INMEMORY_SIZEINMEMORY_SIZE parameter. The INMEMORY_SIZE parameter is a static parameter; so after altering the size

Database Concepts, 12c Release 1 (12.1)

Memory Architecture

With Hybrid Columnar Compression, the database stores the same column for a group of rows together.…keywords control the distribution of objects. Note: Setting INMEMORY_SIZE to 0 for a specific node

Database Reference, 12c Release 1 (12.1)

INMEMORY_QUERY

1.115 INMEMORY_QUERYenables in-memory queries for the entire database by default when the INMEMORY_SIZE parameter is … : \" INMEMORY_CLAUSE_DEFAULT \" \" INMEMORY_FORCE \" \" INMEMORY_MAX_POPULATE_SERVERS \" \" INMEMORY_SIZE

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

Data Warehousing Logical Design

Using the Oracle In-Memory Column Storestore data in the IM column store: Configure the INMEMORY_SIZE initialization parameter to specify … the amount of memory that must be assigned to the IM column store. INMEMORY_SIZE = 100 GB See Also … : Oracle Database Reference for more information about the INMEMORY_SIZE parameter Specify the database

Database Reference, 12c Release 1 (12.1)

INMEMORY_MAX_POPULATE_SERVERS

1.114 INMEMORY_MAX_POPULATE_SERVERSINMEMORY_SIZE parameter is also set to a positive value. The value to use for this parameter … \" \" INMEMORY_FORCE \" \" INMEMORY_QUERY \" \" INMEMORY_SIZE \" Oracle Database Concepts for overview

Database Reference, 12c Release 1 (12.1)

INMEMORY_FORCE

1.113 INMEMORY_FORCE\" \" INMEMORY_SIZE \" Oracle Database Concepts for overview information on the IM column store Oracle Database

Database Reference, 12c Release 1 (12.1)

INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT

1.117 INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENTproblematic, depending on other workload. This parameter has meaning only if the INMEMORY_SIZE

Database Reference, 12c Release 1 (12.1)

Changes in This Release for Oracle Database Reference

Deprecated FeaturesINMEMORY_CLAUSE_DEFAULT INMEMORY_FORCE INMEMORY_MAX_POPULATE_SERVERS INMEMORY_QUERY INMEMORY_SIZE

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

Managing Memory

6.7.3 Enabling the IM Column Store for a DatabaseINMEMORY_SIZE initialization parameter to a non-zero value. When you set this parameter in a server … store by entering the following in SQL*Plus: SHOW PARAMETER INMEMORY_SIZE See Also: Oracle Database … Initialization Parameters \" Oracle Database Reference for more information about the INMEMORY_SIZE initialization parameter Starting

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

Data Warehousing Logical Design

About the Oracle In-Memory Column Store-Memory Column Store Configuring the IM column store is simple. You set the INMEMORY_SIZE

Database Reference, 12c Release 1 (12.1)

Parameters by Functional Category

1.4.1 Parameters by Functional CategoryINMEMORY_SIZE INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT MEMORY_MAX_TARGET MEMORY_TARGET Miscellaneous

Database Reference, 12c Release 1 (12.1)

V$IM_SEGMENTS

8.2 V$IM_SEGMENTSINMEMORY_SIZE NUMBER Size of the in-memory version of the segment, in bytes BYTES NUMBER Total size of

Database Reference, 12c Release 1 (12.1)

V$IM_USER_SEGMENTS

8.3 V$IM_USER_SEGMENTSTABLESPACE_NAME VARCHAR2(30) Name of the tablespace containing the segment INMEMORY_SIZE NUMBER Size of the