bizarre AQ problem

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Tue, 30 Oct 2001 02:03:42 -0800
Message-ID: <F001.003B8074.20011030013521@fatcity.com>

Hello,

I'm having a very strange AQ problem, and I can't for the life of me work out what's going wrong. The platform is Solaris 2.6 and 2.8, Oracle 8.1.7.2, C++ OCI application compiled with SunPro. There is a table with about a dozen columns, one of which is a primary key. The application does a SELECT on the primary key column, then reads these into an array. Then, for each element in this array it loops, doing SELECT * FROM table WHERE primarykey = element. We have isolated the problem to this specific bit of code.

If there are <700 rows in this table, or if the first query adds ' WHERE rownum < 700', everything works exactly as you would expect. If it tries to retrieve more than 700... the AQs for that schema just stop working, until the database is restarted. Has anyone come across something like this before? I can't understand how SELECT could cause this (there are triggers on this table for INSERT, UPDATE and DELETE, each of which does submit a message to an AQ).

Thanks,

--

Guy Hammond
AVT Technologies
1 Martha's Buildings
180 Old Street
London EC1V 9BP

Telephone: 020 7454 4174
Mobile: 07966 164687
Web: http://www.avt.co.uk/

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
INET: guy.hammond_at_avt.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 30 2001 - 04:03:42 CST