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_RESIZE_OPS

V$SGA_RESIZE_OPS displays information about the last 100 completed SGA resize operations. This does not include in-progress operations. 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

Requested value of the parameter after the resize

FINAL_SIZE

NUMBER

Real value of the parameter after the resize

STATUS

VARCHAR2(6)

Completion status of the operation:

  • NORMAL
  • CANCEL
  • ERROR

START_TIME

DATE

Start time of the operation

END_TIME

DATE

End time of the operation