Re: LOCKS

In article <6rjaap$da$1@news.xmission.com>, Sahrul_Hidayat@fmi.com (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. > > Thank's a bunch ;) > > Sahrul > > Sahrul_Hidayat@fmi.com > MIS Dept. > 62-901-432453 (Direct) > "They put me trough hoops" > > > You've asked for 1000000 locks and that needs 40MB ish. Once the engine has allocated it that's it, it will remain at 40MB. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #