Re: Locked sessions
Date: 29 Nov 1994 12:53:47 GMT
Message-ID: <3bf88r$bub_at_news.xs4all.nl>
Karen Payten (karen_at_metz.une.edu.au) wrote:
: Hi everyone,
: We are having a problem with users locking up in Forms 30 applications,
: when they scroll a certain number of records before performing an insert
: or update. When they Commit, the session freezes, and the iap30 process
: starts to run wild.
: I can repeat the problem consistently in all our databases. In all
: cases, in the same form, I can update the 77th row, but freeze up when
: I attempt to update the 78th row. The size of the rows being retrieved
: is 62 characters + a date (is that 66 bytes?).
: In testing, I ran the form with the -b switch, to set the maximum
: number of records buffered in memory to be the same as the number of
: rows displayed plus a few. I was able to successfully update any
: row, but of course scrolling through the records was much slower.
: Maybe related to this problem, is the situation where a user scrolls
: very fast through a large number of records (by holding down the Down
: Arrow key). The application terminates abnormally, and displays
: an 'pid nnnnn (iap30) was killed on an unaligned access, at pc xxxxxx'
: 'Bus error', error message.
: We are using Oracle 6.0.37.6.1, with Forms 3 applications, but with
: mostly V2 triggers. We are on DEC Risc Ultrix 4.4, DEC 5000/260,
: with 256Mb memory.
: Can anyone help me? It is causing major problems in our production
: system, and I am getting nowhere with solving the problem.
: Many thanks
: Karen
: ---------------------------------------------------
: Karen Payten
: Database Administrator
: Computing and Communication Services
: University of New England, Armidale NSW
: Email: karen_at_metz.une.edu.au Phone: +61 67 733549
: ---------------------------------------------------
Have you tried to increase the Rows Buffered field in the block to a larger number. I once experienced a similar freeze in a screen after the user scrolled through the 40th record. After that, all was _very_ slow. The system monitor show iap was accessing the disk like a madman. Appearently, Forms is not using the IO buffer file very wise ;-) Increasing the Row Buffered field to 100 helped to solve the problem.
Teijo Doornkamp (doornkampt_at_vertis.nl) Received on Tue Nov 29 1994 - 13:53:47 CET