--

-- SGA Resize Operations

--

SET pause ON

SET pause 'Press Return to Continue'

SET pagesize 60

SET line 300

COLUMN component FOR a26

COLUMN oper_type FOR a12

COLUMN oper_mode FOR a9

COLUMN parameter FOR a22

COLUMN s_siz_mb FOR 999, 999

COLUMN t_siz_mb FOR 999, 999

COLUMN e_siz_mb FOR 999, 999

SELECT component,

       oper_type,

       oper_mode,

       parameter,

       To_char(initial_size / 1024 / 1024, '999,999') AS S_SIZ_MB,

       To_char(target_size / 1024 / 1024, '999,999')  AS T_SIZ_MB,

       To_char(final_size / 1024 / 1024, '999,999')   AS E_SIZ_MB,

       status,

       To_char(start_time, 'DD-MON-YY HH24:MI:SS')    AS STIME,

       To_char(end_time, 'DD-MON-YY HH24:MI:SS')      AS ETIME

FROM   v$sga_resize_ops

/