Cool! Sounds like a buffer thing..... what is AVG_ROW_LEN on table? what is event, p1,p2,p3 for that sid in v$session_wait? what if table is EMPTY ( well, ok...put in faux PKs, at least) and then, there are all the AQ settings to consider....
-----Original Message----- Sent: Tuesday, October 30, 2001 4:35 AM To: Multiple recipients of list ORACLE-L 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, g -- 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
