7.3.2? baby now 5, THERE was a real geek's database
--- Guy Hammond <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
