Re: LOCKS

Sahrul Hidayat wrote: > > Dear all, > > I have a question about LOCKS. > > If we configure LOCKS, let say 1.000.000, Online allocates about 40 MB of > resident shared memory for LOCKS. So, When locks active i.e 6 users (i.e > result of onstat -k), the allocated of shared memory still 40 MB, even the > limit of locks doesn't reach the maximum ..?? or the allocation will be > smaller than 40 MB. The entire lock table of 1,000,000 entries, or about 40MB, is allocated to shared memory when the engine starts up and neither shrinks nor grows while the engine remains in memory. So yes the 40MB is always allocated. Art S. Kagel