G
gus bjorklund
Guest
no, they are not specific to client-server (nor to appservers). in theory, any database connection in multi-user could run out of locks during rollback. in single-user, there are no locks. yes, all from the same pool of locks, namely the lock table in shared memory. in theory, the lock table could be partially paged to disk in a memory-mapped scratch file, but it is not. increasing -Mxs is not the solution. you should increase the size of your lock table. -Mxs exists as an emergency workaround for bugs in the code that calculates how much shared memory is required. this is sort of done by calculating size of data structures times number of entries and adding them all up. -Mxs allows you to add more if the calculation is wrong and gives a size that is too small. currently it does not.
Continue reading...
Continue reading...