Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
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
Previous
Go to next page
Next
View PDF

V$SGA_DYNAMIC_COMPONENTS

V$SGA_DYNAMIC_COMPONENTS displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup. All sizes are expressed in bytes.

Column Datatype Description
COMPONENT VARCHAR2(64) Component name
CURRENT_SIZE NUMBER Current size of the component
MIN_SIZE NUMBER Minimum size of the component since instance startup
MAX_SIZE NUMBER Maximum size of the component since instance startup
USER_SPECIFIED_SIZE NUMBER Value of the user parameter for the component
OPER_COUNT NUMBER Number of operations since instance startup
LAST_OPER_TYPE VARCHAR2(13) Last completed operation for the component:
  • STATIC

  • INITIALIZING

  • DISABLED

  • GROW

  • SHRINK

  • SHRINK_CANCEL

LAST_OPER_MODE VARCHAR2(9) Mode of the last completed operation:
  • MANUAL

  • DEFERRED

  • IMMEDIATE

LAST_OPER_TIME DATE Start time of the last completed operation
GRANULE_SIZE NUMBER Granularity of the grow or the shrink operation