RE: partition buffer summary - Btree percentage

We encountered a similar problem with IDS 7.30.UC7XB and SAP 3.x. To resolve it, we upgraded to IDS 7.30.UC7XK and set the NOLRUPRIO environment variable. OSS note 167846 contains information regarding this issue. Before this upgrade, 70-90% of the buffer pages showed up as BTREE. Now this percentage is 20-30%. > -----Original Message----- > From: Vardan Aroustamian [mailto:vaar@geocities.com] > Sent: Monday, September 20, 1999 09:25 > To: informix-list@iiug.org > Subject: partition buffer summary - Btree percentage > > > Hello, > > I'm new to SAP environment and would like to get some input > from experienced users. > > Anyone knows of some "usual" percentage for Data vs. Btree > pages in the buffer pool (from onstat -P output). > > Currently I have > > Percentages: > Data 20.09 > Btree 77.75 > Other 2.16 > > I heard about some bug when Btree is more than 90%. > I'm not sure will I reach that number. > > Informix 7.30.UC7XB > SunOS 5.5.1 > > Database ~50GB > SAP 4.5 > > Actually I believe this is not SAP specific question. > Anyway, thanks for any information. > > Vardan > > -- > Vardan Aroustamian > vaar@geocities.com > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. >