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 SGA_TARGET


1 to 20 of 86 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

SGA_TARGET

1.257 SGA_TARGETProperty Description Parameter type Big integer Syntax SGA_TARGET = integer [K | M | G] Default … operating system-dependent Basic Yes SGA_TARGET specifies the total size of all SGA components. If … SGA_TARGET is specified, then the following memory pools are automatically sized: Buffer cache … available for SGA_TARGET

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

Tuning the System Global Area

Setting the SGA_TARGET Parameterin Oracle Enterprise Manager You can change the value of the SGA_TARGET parameter in Oracle … SGA_TARGET Parameter in the Command-Line Interface You can change the value of the SGA_TARGET parameter … command. Setting the SGA_TARGET Parameter This section describes how to enable and disable automatic … shared memory

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

Managing Memory

Some SGA components are automatically sized when SGA_TARGET is set.6.4.2.6 Setting Minimums for Automatically Sized SGA Components You can exercise some control over the size of the automatically sized SGA components by specifying minimum values for the parameters corresponding to these components. Doing so can be useful if you know that an application cannot function properly without a minimum amount of memory in specific components. To specify the minimum amount

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

Tuning the System Global Area

User Interfaces for Setting the SGA_TARGET ParameterThis section describes the user interfaces for setting the value of the SGA_TARGET parameter. This … section contains the following topics: Setting the SGA_TARGET Parameter in Oracle Enterprise Manager … Setting the SGA_TARGET Parameter in the Command-Line Interface

Database Reference, 12c Release 1 (12.1)

SGA: sga_target resize

C.3.139 SGA: sga_target resizeevent was 'wait for sga_target resize'. Wait Time: 10 msec Parameters: None

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…operator. You set: SGA target size ( SGA_TARGET ) Optional SGA maximum size ( SGA_MAX_SIZE ) Optional size

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

Managing Memory

6.6.2 Sizing Database Smart Flash Cacheof SGA_TARGET. Using 80% of the size of SGA_TARGET instead of the full size would also suffice for this calculation.

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

Managing Memory

6.4.3 Using Manual Shared Memory Management6.4.2.7 Dynamic Modification of SGA_TARGET The SGA_TARGET parameter can be dynamically increased up … the value of SGA_TARGET, the system identifies one or more automatically tuned components for which to … release memory. You can reduce SGA_TARGET until one or more automatically tuned components reach … their

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

Managing Memory

Table 6-2 Automatically Sized SGA Components and Corresponding ParametersSGA Target Size You enable the automatic shared memory management feature by setting the SGA_TARGET … memory management feature: Set the SGA_TARGET initialization parameter to a nonzero value. Note: The … Express automatically generates the ALTER SYSTEM statements to set SGA_TARGET to the specified size … information. If you use

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

Managing Memory

6.5.2 Before Enabling Force Full Database Caching Modethe entire database. When a database is configured to use the SGA_TARGET or MEMORY_TARGET … block sizes with the DB_ n K_CACHE_SIZE initialization parameter. With SGA_TARGET or MEMORY_TARGET, the … use SGA_TARGET, then you can estimate the buffer cache size as 60% of SGA_TARGET. If you plan to

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

Managing Memory

6.3.2 Enabling Automatic Memory Management… Calculate the minimum value for MEMORY_TARGET as follows: Determine the current sizes of SGA_TARGETSGA_TARGET NAME TYPE VALUE … ------------------------------------ ----------- -------------------------- sga_target big integer 272M SHOW PARAMETER PGA_AGGREGATE_TARGET NAME TYPE VALUE … \" Enabling Automatic Shared

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

Tuning the System Global Area

Using Automatic Shared Memory ManagementSGA_TARGET parameter. Changes in the value of the SGA_TARGET parameter automatically resize these … value of the SGA_TARGET parameter when automatic shared memory management computes the values of the … the SGA_TARGET parameter: User Interfaces for Setting the SGA_TARGET Parameter Setting the

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

Managing Memory

Query Resultmanagement: Run the following query to obtain a value for SGA_TARGET: SELECT ( (SELECT SUM(value) FROM V … $SGA) - (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY) ) \"SGA_TARGET\" FROM DUAL; Set the … value of SGA_TARGET, either by editing the text initialization parameter file and restarting the … database, or by issuing

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

Managing Memory

The dynamic performance view V$MEMORY_DYNAMIC_COMPONENTS shows the current sizes of all dynamically…on a value for SGA_TARGET. To monitor and tune the SGA target size: Query the V$SGAINFO and V … provides an easy-to-use graphical memory advisor to help you select an optimal size for SGA_TARGET

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

Managing Memory

6.8.2 Memory Management Data Dictionary Viewsand shrink operations for SGA_TARGET and PGA_AGGREGATE_TARGET. V$SGA_RESIZE_OPS Displays information … $SGA_TARGET_ADVICE Displays information that helps you tune SGA_TARGET. V$PGA_TARGET_ADVICE Displays information

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

About Automatic Memory Management for Oracle ASM

About Automatic Memory Management for Oracle ASMSGA_TARGET=0 statement. Unless specified, the behaviors of the automatic memory management parameters

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

Tuning the System Global Area

Sizing the SGA Components Manuallyfollowing initialization parameters: STATISTICS_LEVEL to TYPICAL or ALL SGA_TARGET to a nonzero value … The SGA_TARGET parameter can be set to a value that is less than or equal to the value of the … SGA_MAX_SIZE initialization parameter. Set the value of the SGA_TARGET parameter to the amount of memory … automatic shared memory

Database 2 Day DBA, 12c Release 1 (12.1)

Modifying Memory Settings - Automatic Shared Memory Management

5.4.5 Modifying Memory Settings - Automatic Shared Memory Management: Potential values for the SGA_TARGET initialization parameter (in MB) are represented on the horizontal … axis of the graph. The current setting of the SGA_TARGET initialization parameter is indicated by a … . The plotted values are expressed as a percentage relative to the current setting of the SGA_TARGETSGA_TARGET

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

Tuning the Result Cache

Configuring the Server Result Cacheshared pool using the SGA_TARGET initialization parameter, Oracle Database allocates 0.50% of the … value of the SGA_TARGET parameter to the result cache. Manual shared memory management If you are

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

Managing Memory

6.6.3 Tuning Memory for Database Smart Flash Cachemanagement, then increase the size of SGA_TARGET. Also, for an Oracle RAC database that uses the flash