number of open objects sets the maximum number of objects that can be open simultaneously on SAP ASE.
|
Summary Information |
|
|---|---|
|
Default value |
500 |
|
Range of values |
100–2147483647 |
|
Status |
Dynamic |
|
Display level |
Basic |
|
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.