7.3.2? baby
now 5, THERE was a real geek's database
- Guy Hammond <guy.hammond_at_avt.co.uk> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohan, Ross
> INET: MohanR_at_STARS-SMI.com
>
> 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).
> --
> 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).
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: wisernet100_at_yahoo.com
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 Thu Nov 01 2001 - 07:44:21 CST