Oracle_Optimal_Size_Type (Integer property)

Specifies an optimal size in bytes for a rollback segment. K and M specify the optimal size in kilobytes or megabytes. The Optimal keyword is relevant only to rollback segments. Oracle maintains the optimal size for the rollback segment by dynamically deallocating extents when their data is no longer needed for active transactions. Oracle deallocates as many extents as possible without reducing the total size of the rollback segment below the OPTIMAL value.

Tagged Values

Name Value
Data_TypeInteger
Long_Id{E7AB3CC0-47AD-4A10-8972-C0FB869EE7CB}+40202b96
tag_DBMS_Brands_And_VersionsOracle 8.0+
tag_Display_Name_ResourceOptimal Size Type
tag_Enum_Values{0|Null|Null}{1|Value|Specific Value}
tag_Has_Enum_Valuestrue
tag_Is_Physicaltrue

Valid values

ValueClass NameDisplay Name
0NullNull
1ValueSpecific Value