RE: LIOs on INSERT?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Thu, 10 Feb 2005 08:18:19 -0800 (PST)
Message-ID: <20050210161819.3499.qmail@web52604.mail.yahoo.com>

Hi Patty,

How many LIOs per one insert do you have? How many indexes do you have on the table? Hope no functional indexes :)

Simple algorithm for LIO for simple insert should be = N*M + X

where N = number of indexes
M = depth level (usually up to 4 on big tables) X = number of blocks the insert can fit into (1 for normal size row)

Is your number bigger then with this simple formula?

Regards,
Zoran Martic

• Patty.Charlebois_at_greenshield.ca wrote:

> The only constraint on this table is a primary key
> constraint to ensure=20=
> uniqueness=2E
>
                

---

Do you Yahoo!?
The all-new My Yahoo! - Get yours free! http://my.yahoo.com  

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

Received on Thu Feb 10 2005 - 11:21:26 CST