GV$SGA_RESIZE_OPS
select op.inst_id, -- INST_ID NUMBER gv.component, -- COMPONENT VARCHAR2(64) decode -- OPER_TYPE VARCHAR2(13) (op.opcode, 0, 'STATIC', 1, 'INITIALIZING', 2, 'DISABLED', 3, 'GROW', 4, 'SHRINK', 5, 'SHRINK_CANCEL', NULL), decode -- OPER_MODE VARCHAR2(9) (op.opmode, 1, 'MANUAL', 2, 'DEFERRED', 3, 'IMMEDIATE', NULL), pn.name, -- PARAMETER VARCHAR2(80) op.initsize -- INITIAL_SIZE NUMBER * gv.gransize, op.targsize -- TARGET_SIZE NUMBER * gv.gransize, op.realsize -- FINAL_SIZE NUMBER * gv.gransize, decode -- STATUS VARCHAR2(9) (op.status, 0, 'INACTIVE', 1, 'PENDING', 2, 'COMPLETE', 3, 'CANCELLED', 4, 'ERROR', 5, 'ERROR', 6, 'CANCELLED', 7, 'CANCELLED', NULL), op.starttime, -- START_TIME DATE op.endtime -- END_TIME DATE from x$kmgsop op, x$kmgsct gv, v$parameter pn where (op.grantype = gv.grantype) and (op.parno = pn.num) order by op.starttime

home |  up  |  mailbox