Home > Uncategorized > Oracle Database: HOWTO determine the granule size on your release/platform

Oracle Database: HOWTO determine the granule size on your release/platform

Problem description:

Upon starting an Oracle Database Instance, memory gets allocated in granule sized memory units. If you set the sga_target parameter to a specific value (e.g. 2500MB), it will be rounded up to the next full granule (e.g. 2512MB on platforms with 16MB granule size).

The granule size depends on the platform you are running Oracle on, which version you are using and your SGA size.

Problem resolution:

To determine the granule size for your Oracle Database instance, just execute the following query:

SELECT * FROM v$sgainfo WHERE name = 'Granule Size';

Example for 11.2.0.2 on AIX:

oracle@aix01 /home/oracle # sqlplus "/ as sysdba"
 
SQL*Plus: Release 11.2.0.2.0 Production ON Mon May 22 13:18:16 2011
 
Copyright (c) 1982, 2010, Oracle.  ALL rights reserved.
 
 
Connected TO:
Oracle DATABASE 11g Release 11.2.0.2.0 - 64bit Production
WITH the REAL Application Clusters AND Automatic Storage Management options
 
SQL> SELECT * FROM v$sgainfo WHERE name = 'Granule Size';
 
NAME                                  BYTES RES
-------------------------------- ---------- ---
Granule SIZE                       16777216 No
 
SQL>
Categories: Uncategorized Tags:
  1. No comments yet.
  1. No trackbacks yet.

Connect with Facebook