Hi, I have faced a serious problem with AOS. i.e., When quering the following statement all the user get locked. This problem particularly raises when more than 125 user login with the server. But client purchased license for 150 users. Futhermore this problem occured for a single company.However application have 8 companies.
SELECT /*+ INDEX(A I_273SERIESIDX) FIRST_ROWS */A.NUMBERSEQUENCE ,A.TXT,A.LOWEST,A.HIGHEST,A.NEXTREC,A.BLOCKED,A.FORMAT,A.CONTINU OUS,A.CYCLIC,A.CLEANATACCESS,A.INUSE,A.NOINCREMENT,A.DEL_RESTRIC TIONLEVEL,A.CLEANINTERVAL,A.LATESTCLEANDATE,A.LATESTCLEANTIME,A. ALLOWCHANGEUP,A.ALLOWCHANGEDOWN,A.MANUAL,A.FETCHAHEADQTY,A.FETCH AHEAD,A.DEL_FORCEDATEORDER,A.MODIFIEDTRANSACTIONID,A.RECID FROM NUMBERSEQUENCETABLE A WHERE ((SUBSTR(NLS_LOWER(DATAAREAID),1,3)= NLS_LOWER(:in1)) AND (SUBSTR(NLS_LOWER(NUMBERSEQUENCE),1,10)=NLS _LOWER(:in2))) FOR UPDATE Your suggestions and solutions are appreciable Thanks and Regards, Narayanan.v . __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
