Thursday, June 30, 2016

How to check SGA resize operations?

select
    component,
    oper_type,
    oper_mode,
    initial_size/1024/1024 "Initial",
    TARGET_SIZE/1024/1024  "Target",
    FINAL_SIZE/1024/1024   "Final",
    status,
    to_char(start_time,'dd-mon hh24:mi:ss') start_time,
    to_char(end_time,'dd-mon hh24:mi:ss')   end_time
 from
    v$sga_resize_ops;

select
    component,
    current_size/1024/1024 "CURRENT_SIZE",
    min_size/1024/1024 "MIN_SIZE",
    user_specified_size/1024/1024 "USER_SPECIFIED_SIZE",
    last_oper_type "TYPE",
    to_char(LAST_OPER_TIME,'dd-mon hh24:mi:ss') "LAST_OPER_TIME"
 from
    v$sga_dynamic_components;

No comments:

Post a Comment