ASE 12.5.1: number of open objects -
09-07-2004
, 08:35 AM
Hi,
on a 12.5.1 ASE (Linux) I have to set "number of open objects"
higher than the value of sp_countmetadata:
1> sp_countmetadata "number of open objects"
2> go
There are 1244 user objects in all database(s), requiring 8703 Kbytes of
memory.
The 'open objects' configuration parameter is currently set to 8000.
(return status = 0)
1> sp_monitorconfig "number of open objects"
2> go
Usage information at date and time: Sep 7 2004 3:32PM.
Name Num_free Num_active Pct_act Max_Used
Reused
------------------------- ----------- ----------- ------- -----------
------
number of open objects 2466 5534 69.17 5534 No
(return status = 0)
And the value of "Max_Used" is rising.
Jürgen Bajdala |