Thursday, January 18, 2018

How to check SGA components size in oracle

Query:
================

set lines 300 pages 300
select COMPONENT, current_size/1024/1024 "CURRENT_SIZE", min_size/1024/1024 "MIN_SIZE", max_size/1024/1024 "MAX_SIZE", user_specified_size/1024/1024 "USER_SPECIFIED_SIZE" from v$memory_dynamic_components;

No comments:

Post a Comment