| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: bizarre AQ problem
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: guy.hammond_at_avt.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Thu Nov 01 2001 - 03:52:28 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |