> The hash function in this case is based on the session id of the > connecting user. (mod(SID,FREELISTS)+1). > > eg SID=10, FREELISTS=3, HASH = mod(10,3)+1 = 1+1 = 2 I believe the hash function is applied to Oracle PID, not SID. This should be in docs as well. Tanel. -- //www.freelists.org/webpage/oracle-l