Re: Buffer gets

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Wed, 20 Apr 2011 20:54:38 +0200
Message-ID: <BANLkTinLLzvypJ2+JxCA7guoOpuVP9mmqw_at_mail.gmail.com>

You're not telling us what type of constraint(s) you are enabling.

Assuming, for instance, it's a foreign key: Oracle has to validate all current data in the two (parent and child) involved tables. Validating the current data, causes buffer gets.

Why it's causing that many, with that low number of rows, we need more info.

Exactly what type of constraint on what table are you enabling?

On Wed, Apr 20, 2011 at 8:46 PM, Joe Smith <joe_dba_at_hotmail.com> wrote:

> Why would enabling constraints on tables with ~180000 records create a lot
> of buffer gets ( millions plus ).
>
> Thanks
>

-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 20 2011 - 13:54:38 CDT