Re: Freelists and Freelist Groups

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Nov 2005 06:14:31 -0800
Message-ID: <1132323271.848432.316040@z14g2000cwz.googlegroups.com>

Freelists groups is an OPS/RAC parameters where each database instance pulls its freelist from different groups to reduce the likelihood that updates done on one instance will go to the same block as updates done from another instance.

What makes you think you need more freelists? We have run OPS from version 7.0 and have found that most tables work fine with only 1 freelist on 1 freelist group even in RAC.

You should post your full version, platform, the queries, and the results that you are basing your conclusion on so that board readers can determine if what you think is a problem is the problem.

Have you ran a short duration statspack during peak time that you can post numbers from?

HTH -- Mark D Powell -- Received on Fri Nov 18 2005 - 08:14:31 CST