Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$SGA_CURRENT_RESIZE_OPS

V$SGA_CURRENT_RESIZE_OPS displays information about SGA resize operations which are currently in progress. An operation can be a grow or a shrink of a dynamic SGA component. All sizes are expressed in bytes.

Column Datatype Description

COMPONENT

VARCHAR2(64)

Component name

OPER_TYPE

VARCHAR2(6)

Operation type:

  • GROW
  • SHRINK

OPER_MODE

VARCHAR2(6)

Operation mode:

  • MANUAL
  • AUTO

PARAMETER

VARCHAR2(64)

Name of the parameter for the resize operation

INITIAL_SIZE

NUMBER

Parameter value at the start of the operation

TARGET_SIZE

NUMBER

Desired value of the parameter after the resize

CURRENT_SIZE

NUMBER

Current value of the parameter

START_TIME

DATE

Start time of the operation

LAST_UPDATE_TIME

DATE

Last time progress was made for the operation