I submitted a TAR and Oracle seem to think it's because the shared pool is too small. Hmmm. Upping it did seem to resolve the problem, but... this is a scenario in which a bit of Oracle functionality just stops working, without throwing an exception from the trigger code, nor even making an entry in the alert log. I wonder what else is lurking under the hood.
8.1.6 is more or less desupported now, which is annoying. I miss 7.3.2, now *there* was a real man's database :0) g -----Original Message----- Sent: 30 October 2001 18:05 To: Multiple recipients of list ORACLE-L 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). -- 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).