9.33 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 name |
|
|
Current size of the component |
|
|
Minimum size of the component since instance startup |
|
|
Maximum size of the component since instance startup |
|
|
Value of the user parameter for the component |
|
|
Number of operations since instance startup |
|
|
Last completed operation for the component:
|
|
|
Mode of the last completed operation:
|
|
|
Start time of the last completed operation |
|
|
Granularity of the grow or the shrink operation |
|
|
The ID of the container to which the data pertains. Possible values include:
|