Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

orawsv performance tunning and debugging

941879Feb 17 2013 — edited Feb 17 2013
Hi all ,
first I hope I've reached the right forum .

we've developed a .net <--> oracle application , which use oracle web services a lot , and it is great since it reduce our development time (no need to setup middle tier application server for webservice)

However , when trying to scale/stress the solution we've encountered serveral issues , which I would like to know if others has them as well:

1. it seems that the servlet is opening a db connection for every call , this seems a little expensive (I've not tested yet if it a logical connection using shared server of dedicate one -- anyone know ?? ) .
it there a way to tell the servlet to work with connection pool ? or keep the connections open ?

2. if i want to profile/debug/monitor the servlet ? where are the logfiles ?
it seems that the listener log is written for every call (which make sence ) but the it grows big

3. I want to know if anyone is using it on production with large scale (about 100 request per min ) ? or should i think on using web-service middle tier .?

thanks amihay .

we are using 11.2.0.1 on windows 2008 64 bit .

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 17 2013
Added on Feb 17 2013
1 comment
183 views