parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

 

Nope I think , and you dont require also. If MAXINSTANCES is greater than the number of free list groups in the table or cluster, then an instance number maps to the free list group associated with.

In a system with relatively few nodes, such as a clustered system, the FREELIST GROUPS option for a table should generally have the same value as the MAXINSTANCES option of CREATE DATABASE, which limits the number of instances that can access a database concurrently.

In a massively parallel system, however, MAXINSTANCES could be many times larger than FREELIST GROUPS so that many instances share one group of free lists.