Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> queries hanging when avaiting alert

queries hanging when avaiting alert

From: Ales Krenek <ljocha_at_ics.muni.cz>
Date: Wed, 12 Aug 1998 07:05:04 GMT
Message-ID: <ExKECG.Bq8@news.muni.cz>


hello,

i'm developing an application which uses not very complicated database (~30 tables) which is never supposed to grow too much in volume, currently filled with half-production/testing data, 2000 rows in total (no long columns etc.) the server is a dedicated SGI INDY, 64M RAM (good enough for supposed load), Oracle server 7.3

there are triggers on several tables issuring single row updates to a particular table which in turn fire another trigger singaling an alert.

everything seems be ok as long as the signaled alert is not waited for. when i run a session (PRO*C program, the same or another SGI) which calls dbms_alert.waitone() on that alert, waits there and does nothing else, SQL statements issured to the database hang for a while (up to half a minute) sometimes and then execute without error. if the triggers should be fired they are, the alert is signaled and handled properly, perfect functionality. as long as those hanging statements are either updates causing the chained trigger to fire or successive commits, ooooo kay, who knows what is actually happening there. but this happens (with random distribution i observe) with even trivial selects on tables of 10 rows in transactions that haven't touched the triggers yet! very annoying indeed.

any ideas?

thanks,

ales krenek

n.b. the database is on local disk obviously but oracle binaries reside on AFS. might this be related? Received on Wed Aug 12 1998 - 02:05:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US