RE: LIOs on INSERT?

  • From: Martic Zoran <zoran_martic@xxxxxxxxx>
  • To: Patty.Charlebois@xxxxxxxxxxxxxx
  • Date: Thu, 10 Feb 2005 08:18:19 -0800 (PST)

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@xxxxxxxxxxxxxx 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 
 

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

Other related posts: