Creating an Oracle Database. This section discusses the initialization parameters that affect the amount of memory allocated to the System Global Area SGA. Except for the SGAMAXSIZE initialization parameter, they are dynamic parameters whose values can be changed by the ALTER SYSTEM statement. Fj9DP47eA/TQvMCeiofsI/AAAAAAAAIQc/EVClZTX1YKk/2010-12-18_043827_thumb%5B1%5D.jpg?imgmax=800' alt='Oracle 10G For Windows 8 64 Bit' title='Oracle 10G For Windows 8 64 Bit' />Welcome to the Oracle Database 10g Documentation Library. Here you can research new information, look up reference information, and search across the entire library. The size of the SGA is dynamic, and can grow or shrink by dynamically altering these parameters. Components and Granules in the SGAThe SGA comprises a number of memory components, which are pools of memory used to satisfy a particular class of memory allocation requests. Examples of memory components include the shared pool used to allocate memory for SQL and PLSQL execution, the java pool used for java objects and other java execution memory, and the buffer cache used for caching disk blocks. All SGA components allocate and deallocate space in units of granules. Oracle Database tracks SGA memory use in internal numbers of granules for each SGA component. The memory for dynamic components in the SGA is allocated in the unit of granules. Vray 3 For Maya. Granule size is determined by total SGA size. Generally speaking, on most platforms, if the total SGA size is equal to or less than 1 GB, then granule size is 4 MB. Oracle 10G For Windows 8 64 Bit' title='Oracle 10G For Windows 8 64 Bit' />It is sometimes a bit of a hassle, to have the latest patch name or number on hand, when you need them. Ok, you may search on My Oracle Support and save it as custom. For SGAs larger than 1 GB, granule size is 1. MB. Some platform dependencies may arise. For example, on 3. Windows NT, the granule size is 8 MB for SGAs larger than 1 GB. Consult your operating system specific documentation for more details. You can query the VSGAINFO view to see the granule size that is being used by an instance. The same granule size is used for all dynamic components in the SGA. Step One Installation of the Oracle 10g Release 2 64bit client software. Barbell Workout Chart Pdf. I will leave it up to you to secure the software by either download from their site or. Oracle Database 11g Release 2 Express Edition for Windows 64 now available for download. Oracle Database 11g Release 2 Express Edition downloads for Linux x86 and Windows. If you specify a size for a component that is not a multiple of granule size, Oracle Database rounds the specified size up to the nearest multiple. For example, if the granule size is 4 MB and you specify DBCACHESIZE as 1. MB, the database actually allocates 1. MB. Limiting the Size of the SGAThe SGAMAXSIZE initialization parameter specifies the maximum size of the System Global Area for the lifetime of the instance. You can dynamically alter the initialization parameters affecting the size of the buffer caches, shared pool, large pool, Java pool, and streams pool but only to the extent that the sum of these sizes and the sizes of the other components of the SGA fixed SGA, variable SGA, and redo log buffers does not exceed the value specified by SGAMAXSIZE. If you do not specify SGAMAXSIZE, then Oracle Database selects a default value that is the sum of all components specified or defaulted at initialization time. If you do specify SGAMAXSIZE, and at the time the database is initialized the value is less than the sum of the memory allocated for all components, either explicitly in the parameter file or by default, then the database ignores the setting for SGAMAXSIZE. Using Automatic Shared Memory Management. You enable the automatic shared memory management feature by setting the SGATARGET parameter to a non zero value. This parameter in effect replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized tuned as needed. Note. The STATISTICSLEVEL initialization parameter must be set to TYPICAL the default or ALL for automatic shared memory management to function. The SGATARGET initialization parameter reflects the total size of the SGA. Mozilla Firefox 39 For Windows 7. Table 2 3 lists the SGA components for which SGATARGET includes memorythe automatically sized SGA componentsand the initialization parameters corresponding to those components. Table 2 3 Automatically Sized SGA Components and Corresponding Parameters. SGA Component. Initialization Parameter. Fixed SGA and other internal allocations needed by the Oracle Database instance. NAThe shared pool. SHAREDPOOLSIZEThe large pool. LARGEPOOLSIZEThe Java pool. JAVAPOOLSIZEThe buffer cache. DBCACHESIZEThe Streams pool. STREAMSPOOLSIZEThe parameters listed in Table 2 4, if they are set, take their memory from SGATARGET, leaving what is available for the components listed in Table 2 3. Table 2 4 Manually Sized SGA Components that Use SGATARGET Space. SGA Component. Initialization Parameter. The log buffer. LOGBUFFERThe keep and recycle buffer caches. DBKEEPCACHESIZEDBRECYCLECACHESIZENonstandard block size buffer caches. DBn. KCACHESIZEIn addition to setting SGATARGET to a non zero value, you must set the value of all automatically sized SGA components to zero to enable full automatic tuning of these components. Alternatively, you can set one or more of the automatically sized SGA components to a non zero value, which is then used as the minimum setting for that component during SGA tuning. This is discussed in detail later in this section. Note. An easier way to enable automatic shared memory management is to use Oracle Enterprise Manager EM. When you enable automatic shared memory management and set the Total SGA Size, EM automatically generates the ALTER SYSTEM statements to set SGATARGET to the specified size and to set all automatically sized SGA components to zero. If you use SQLPlus to set SGATARGET, you must then set the automatically sized SGA components to zero or to a minimum value. The VSGATARGETADVICE view provides information that helps you decide on a value for SGATARGET. For more information, see Oracle Database Performance Tuning Guide. Enabling Automatic Shared Memory Management. To enable automatic shared memory management If you are migrating from a manual management scheme, execute the following query on the instance running in manual mode to get a value for SGATARGET. SELECT SUMvalue FROM VSGA. SELECT CURRENTSIZE FROM VSGADYNAMICFREEMEMORY. SGATARGET. Set the value of SGATARGET, either by editing the text initialization parameter file and restarting the database, or by issuing the following statement. ALTER SYSTEM SET SGATARGETvalue SCOPESPFILEMEMORYBOTH. SGA component sizes and SGAMAXSIZE. For more information on the SCOPE clause, see Using ALTER SYSTEM to Change Initialization Parameter Values. Do one of the following For more complete automatic tuning, set the values of the automatically sized SGA components listed in Table 2 3 to zero. Do this by editing the text initialization parameter file, or by issuing ALTER SYSTEM statements similar to the one in step 2. To control the minimum size of one or more automatically sized SGA components, set those component sizes to the desired value. See the next section for details. Set the values of the other automatically sized SGA components to zero. Do this by editing the text initialization parameter file, or by issuing ALTER SYSTEM statements similar to the one in step 2. For example, suppose you currently have the following configuration of parameters on a manual mode instance with SGAMAXSIZE set to 1. M SHAREDPOOLSIZE 2. MDBCACHESIZE 5. MLARGEPOOLSIZE2. MAlso assume that the result of the queries is as follows. SELECT SUMvalue FROM VSGA 1. M. SELECT CURRENTSIZE FROM VSGADYNAMICFREEMEMORY 2. M. You can take advantage of automatic shared memory management by setting Total SGA Size to 9. M in Oracle Enterprise Manager, or by issuing the following statements. ALTER SYSTEM SET SGATARGET 9. M. ALTER SYSTEM SET SHAREDPOOLSIZE 0. ALTER SYSTEM SET LARGEPOOLSIZE 0. ALTER SYSTEM SET JAVAPOOLSIZE 0. ALTER SYSTEM SET DBCACHESIZE 0. ALTER SYSTEM SET STREAMSPOOLSIZE 0. M 1. 20. 0M minus 2.