SGA of .ASM instance to view all ASM file sizes

There is no difference between SGA and RDMBS of ASM, including Buffer Cache, shared pool, Large poor and so on. You need to pay attention to the shared pool share pool, because to put the extent map in this part of memory, you need to estimate the size of the map based on the number and adjust it accordingly.

The size of Extent map can be calculated based on the sum of all file sizes. Use the following statement to calculate the sum of all files.

(note: enter these sql commands in the RDBMS instance)

SQL > select sum (bytes) / (1024-1024-1024) from vs. datafileterSQL > select sum (bytes) / (1024-1024-1024) from v$logfile a, v$log b where a.group#=b.group#

SQL > select sum (bytes) / (1024 / 1024 / 1024) from v$tempfile where status='ONLINE'

The sum of these three SUM corresponds to the sum of all file sizes stored in the database in ASM. For external redundancey disk groups, one megabyte of extent map is required for every 100g. Calculate the required space based on this ratio and add additional 2MB. However, there is generally no need to consider the configuration of ASM SGA in time work. Use the default values provided by ORACLE.

Picture: