LMT problems ...

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 26 Jul 2002 08:36:42 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026BF72D@lnewton.leeds.lfs.co.uk>

Hi Richard,

Trouble maker - me ?
I have a rep for breaking software - when I first joined this company they told me 'go play with the software and see if you can find any bugs' so I logged over 40 in my first morning. The MD came to see me in the afternoon and asked me to keep it up :o)

The only things these tables have in common is :

the same tablespace
they are reasonably biggish (about 40,000 rows)
they are analyzed (sic) compute but estimate is the same
they have DATEs, VARCHAR2 and NUMBER(m,n). Some have a LONG column but not all (yes I know, but we're getting there !)
no CLOBS etc

It happens if the table is exported and imported into a new user so I'm presuming that there is something about the table structure that is causing LMTs grief - I just havent tracked it down yet.

Support were of the opinion that I was hitting bug 1502537 - but that was because the alertfile said there was a trace file, but there wasn't. I managed to recreate one in another session and this time got a trace. When support saw it, they reckon I have a new problem and one which is present in 9i as well. When I told them it works fine on DMT it gave them something else to worry about :o)

I think we're still in the info gathering stage really, but it is unlikely that we will be affected by the problem - unless, like 1502537, it turns up on DELETEs as well. Even then, we don't delete much in our system :o(

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Richard Foote [mailto:richard.foote_at_bigpond.com] Posted At: Friday, July 26, 2002 7:00 AM Posted To: server
Conversation: LMT problems ...
Subject: Re: LMT problems ...

Hi Norman,

Gee you're a trouble maker :)

Do any of these problem tables have anything in common ? Have support made
any suggestions as to the reason for the problem if not the bug in question
?

Cheers

Richard Received on Fri Jul 26 2002 - 02:36:42 CDT