Re: Database Tuning
On Mon, 09 Aug 2004 14:56:07 -0400, Roger Cariah wrote:
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
PLEASE DO NOT POST MIME to this newsgroup/maillist. Doing so triples the
bandwidth required to distribute your posting and most denizens use text only
readers anyway. Oh yeah, and no attachments, only in-body text.
> Hi All,
>
> I recently started to experience slow response times on my informix based
> application suite. When I checked the database for the possibility of
> fragmentation, it was observed that most of major tables used just had one
> extent hence ruling out this cause. I ran one invocation of"onstat -p" to
> monitor the performance of my IDS Database ( Informix 7.31). Both my read
> and write cache returned values >99% as well as there was no indication of
> foreground writes. I did observes very large values for bufwrites (
> 7867339), lockreqs ( 14404458417) , pagereads, bufreads etc etc..
>
> I'm unsure how to interpret these high values. Can anyone shed some light
> into the reason for these high values witnessed.
Not enough information. Post the following and someone will likely spot
something:
onstat -p
onstat -P
onstat -d
onstat -D
onstat -R
onstat -F
onstat -g glo
onstat -g iov
The contents of your ONCONFIG file and the time since startup or since onstat
-z was last run to zero the stats reported by onstat.
Art S. Kagel
> Will appreciate any advice on the above related matter..