SET PAGESIZE 9999

SET VERIFY off

COLUMN component FORMAT a24 HEAD 'Component Name'

COLUMN current_size FORMAT 9,999,999,999 HEAD 'Current Size'

COLUMN min_size FORMAT 9,999,999,999 HEAD 'Min Size'

COLUMN max_size FORMAT 9,999,999,999 HEAD 'Max Size'

COLUMN user_specified_size FORMAT 9,999,999,999 HEAD 'User Specified|Size'

COLUMN oper_count FORMAT 9,999 HEAD 'Oper.|Count'

COLUMN last_oper_type FORMAT a10 HEAD 'Last Oper.|Type'

COLUMN last_oper_mode FORMAT a10 HEAD 'Last Oper.|Mode'

COLUMN last_oper_time FORMAT a20 HEAD 'Last Oper.|Time'

COLUMN granule_size FORMAT 9,999,999 HEAD 'Granule Size'

component

, current_size

, min_size

, max_size

, user_specified_size

, oper_count

, last_oper_type

, last_oper_mode

, TO_CHAR(last_oper_time, 'DD-MON-YYYY HH24:MI:SS') last_oper_time

, granule_size

v$sga_dynamic_components

component DESC