Buffer allocated to data, index and other

Greeting All, IDS 10.0.FC6, Linux AS4 Need some help in understanding the buffer allocated to data, Index and others from onstat -P | tail output. From my memory, in one of the article/script (probably by Art or may be other guru), it was suggested that in OLTP, data % should be > 90%. One of our PROD database servers occasionally shows data % as low as 30% and Index % as 60%. Sometimes other % appears to be 40%, Index % 50% and data 10%. Something like this. I have a feeling that when I see index % or other % higher than data %, server appears to have some performance issues. Can someone please point me to the right direction for? 1. What is buffer allocated to data, index and others? 2. What may be the cause of this? 3. Could it be related to update stats as update stats are being done by distribution only? 4. What ONCONFIG parameter(s) need an attention? Please let me know if I need to post any onstat output. Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Hi If % used of buffer (hit rate) is low (100% is the 'desired' percentual), probably the buffer pool size should be increased. What is the Shared Memory allocated when the instance start? run: onstat -s and show us the result.How many processors in box? How much memory? When you run update statistics, I suggest: update statistics for table drop distribution update statistics HIGH for table (first index columns) update statistics medium for table (other index columns) > To: ids@iiug.org> From: hariog@yahoo.com> Subject: Buffer allocated to data, index and other [10286]> Date: Tue, 30 Oct 2007 14:56:57 -0500> > Greeting All, > > IDS 10.0.FC6, Linux AS4 > > Need some help in understanding the buffer allocated to data, Index and others > from onstat -P | tail output. From my memory, in one of the article/script > (probably by Art or may be other guru), it was suggested that in OLTP, data % > should be > 90%. One of our PROD database servers occasionally shows data % as > low as 30% and Index % as 60%. Sometimes other % appears to be 40%, Index % > 50% and data 10%. Something like this. I have a feeling that when I see index > % or other % higher than data %, server appears to have some performance > issues. > > Can someone please point me to the right direction for? > > 1. What is buffer allocated to data, index and others? > 2. What may be the cause of this? > 3. Could it be related to update stats as update stats are being done by > distribution only? > 4. What ONCONFIG parameter(s) need an attention? > > Please let me know if I need to post any onstat output. > > Thanks. _________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmai ltagline