RE: High lngspins - IDS 9.30 UC2

update statistics -> -----Original Message----- -> From: hariog@yahoo.com [mailto:hariog@yahoo.com] -> Sent: Thursday, October 16, 2003 8:52 AM -> To: informix-list@iiug.org -> Subject: High lngspins - IDS 9.30 UC2 -> -> -> Hi All, -> -> We have recently upgraded IDS 9.21UC3 to IDS 9.30 UC3 on RHL 7.3 -> (Kernel - 2.4.18-27.7.xbigmem). Platform - Dell PE6600 - Quard Xeon, -> dual channel, 8GB RAM - HT. Channel-A has 8 72 GB mirror & stripped -> and Channel-B has got 8 36 GB mirror & stripped. -> -> I have been keeping an eye on the database performance and -> constantly -> observing that lngspins are keeps on growing. Within 2 days of -> running, -> lngspins gone upto more than 21000. Also notice high seqscans. -> -> So far as seqscans are concern, probably they have been there with -> IDS 9.21 UC3 as well. -> -> Could some one pl. advise ? Ofcourse - I am sure gurus like Art, Mark -> D, -> Bill, Obnoxio, J Leffler, J Parker, Tsutomu and manu more -> will respond -> to it. -> <SNIPPED> -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list