SET LINESIZE 3500
SET PAGESIZE   100
SET VERIFY     OFF
SET FEEDBACK   OFF

alter session set nls_numeric_characters = ',.';

@@header_dbinfo 107 DC


CLEAR COLUMNS
COLUMN tipo      FORMAT A9             HEADING "Operacion"
COLUMN modo      FORMAT A9             HEADING "Modo"
COLUMN parameter FORMAT A17            HEADING "Parameter"
COLUMN start FORMAT A17            HEADING "start"
COLUMN end FORMAT A17            HEADING "end"
COLUMN initial   FORMAT 99999 HEADING "Initial_mb"
COLUMN target   FORMAT 99999 HEADING "Target_mb"
COLUMN final   FORMAT 99999 HEADING "Final_mb"

select tipo,modo,parameter,"start","end","initial","target","final"
from(
SELECT oper_type tipo,oper_mode modo,parameter,to_char(start_time,'ddmmyyyy hh24:mi:ss') "start",
to_char(end_time,'ddmmyyyy hh24:mi:ss') "end", 
initial_size/1024/1024 "initial",target_size/1024/1024 "target",final_size/1024/1024 "final"
FROM V$SGA_RESIZE_OPS
WHERE COMPONENT='large pool'
order by end_time desc
)
where rownum < 10;