Re: B-TREE management under Oracle AIX3.2.5

In article <3noeo6$g93_at_snlsu1> faraldi_at_montrouge.sc.slb.com (Yen Bach-Faraldi) writes:
>From: faraldi_at_montrouge.sc.slb.com (Yen Bach-Faraldi)
>Subject: B-TREE management under Oracle AIX3.2.5
>Date: 27 Apr 1995 15:54:46 GMT
 

>We have a performance problem due to I/O requests on an index.
>Our index is composed by two columns ( number(19), date ).
>Our B-TREE is composed by 215458 Leaf/blocks, 3698 Branch/blocks.
>We have 7398854 LEAF/rows.
>Our block size is 2048 Bytes.
>Our application is working on an RS/6000 580
>Our index's access is completely random, so we do not have
>a lot of chance for working with database buffers in SGA and
>the worst is that Oracle's DBWR is always reorganizing his B-TREE.
>Does anybody have an idea to improve our performance or
>do you think taht we reached the highest oracle's performance ???
>Any of your comments are welcome.

Spread the index across several physical devices. Received on Mon May 01 1995 - 00:00:00 CEST