number of open objects

number of open objects sets the maximum number of objects that can be open simultaneously on SAP ASE.

Summary Information

Default value


Range of values




Display level


Required role

System administrator

Configuration groups

Memory Use, Meta-Data Caches, SQL Server Administration

If you are planning to make a substantial change, such as loading databases with a large number of objects from another server, use sp_helpconfig to recalculate an estimated metadata cache size. sp_helpconfig displays the amount of memory required for a given number of metadata descriptors, as well as the number of descriptors that can be accommodated by a given amount of memory. An object metadata descriptor represents the state of an object while it is in use, or cached between uses.