[Building Sakai] [SAMIGO Problem] Submit for grading button hang when student write large text in textbox of "Short Answer/Essay" type test

[Jehan Badshah]

Dear All

I am using oracle9i and sakai2.8.2

I have created a "Short Answer/Essay"  type samigo test, when students
write large text in textbox, it hangs and can't proceed.

 We faced that problem during exam of 60 students,that time oracle
sessions, processes and active sessions were increasing rapidly. Active
sessions were not decreasing as in MCQ type test.

Now I simulated same problem with few students, attempted same type test
with large data, and I observed same behaviour (e.g., active sessions and
processes were increasing).

However in MCQ type test we are not facing any problem even if 500 students
attempt a test simultaneously.


Inside folder  "sakai/samigo/AnswerUploadRepositoryPath" some files
(e.g., upload_74cacce_13bfc762aa5_7ffd_00000135.tmp) were created with same
text which students wrote in textboxes


I have checked all parameter of my database it is working perfectly,

For testing purpose using sqlDeveloper I updated
"SAM_ITEMGRADING_T.answertext" of 300 records with 6mb data using following
query, and I did not face any problem.



update SAM_ITEMGRADING_T
set answertext=
(
select answertext || answertext|| answertext|| answertext|| answertext||
answertext ||answertext || answertext|| answertext|| answertext||
answertext|| answertext
||
 answertext || answertext|| answertext|| answertext|| answertext||
answertext ||answertext || answertext|| answertext|| answertext||
answertext|| answertext
||
 answertext || answertext|| answertext|| answertext|| answertext||
answertext ||answertext || answertext|| answertext|| answertext||
answertext|| answertext
||
 answertext || answertext|| answertext|| answertext|| answertext||
answertext ||answertext || answertext|| answertext|| answertext||
answertext|| answertext
||
 answertext || answertext|| answertext|| answertext|| answertext||
answertext ||answertext || answertext|| answertext|| answertext||
answertext|| answertext


from SAM_ITEMGRADING_T where itemgradingid=560351

)
where itemgradingid>560000


any help please ?


Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130103/3e74e1d3/attachment.html