SGA Resize Operations
--
-- 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
/