Re: Oracle Forms/Reports Server 6i success/failure stories

[Quoted] According to Forms Server documentation on Oracle's MetaLink, each CPU on a [Quoted] Unix box can support 200-400 users. Each user session can be expected to use [Quoted] 2-6MB of memory, depending on form size. From that information, a Unix box with 1 or 2 CPUs and 2GB of memory should [Quoted] be able to handle 300 users. When benchmarking with 30 users on such a box, [Quoted] 6i ran as fast or faster than standard client server. I have not seen the response time when the box is being run at full capacity, though. MetaLink will probably have similar information for you on NT boxes. My experience using an NT box for the Forms server was with Forms 5.0. The response time was terrible, but that may have been Forms 5.0 and not NT.

As far as small forms vs. large, some of the decision depends on how large your forms could be. If it uses 3 or 4 canvases with only a few tables, I don't think you'll get much benefit from splitting it up. However, if you have 10-15 canvases, including tabbed canvases, you could see some performance impact if you have 300 users all running forms of that size. One reason you may want to limit how much you split up the forms into many smaller forms: When testing performance of opening many forms, the Forms server did not appear to be releasing all of the memory when a form was closed. After opening and closing a small form 300 times within a single session, the memory usage for that session had increased from 2MB to 10MB.

John Alexander
www.SummitSoftwareDesign.com

Charlton Purvis <purvis386_at_my-deja.com> wrote in message news:8rkqgt$cbu$1_at_nnrp1.deja.com...
> Hi there:
>
> As project technical lead for a South Carolina state-wide legal case
> management solution, I have all but decided to rely exclusively on
> Oracle Forms/Reports 6i. We realize that client-server would be a fail-
> safe yet possibly slow solution, however I'm interested in any
> success/failure stories anyone has had w/ Forms/Reports Server.
>
> The final system may rely on as many as 3-4 large 8i replicated
> database servers, but the Forms/Reports Server would probably be housed
> on one NT box (although I haven't looked into multiple app servers for
> F/R Server) w/ a maximum of 300 concurrent users. Assuming everyone
> connects over the LAN at a decent speed (some T1, others ADSL, DSL,
> cable), what type of performance should I expect from F/R Server? Have
> you had a positive or negative experience?
>
> In terms of the design of the forms, I am currently investigating the
> effectivness of having many small forms rather than a few large forms.
> I don't know the trade-off value for many small vs. few large; I'm a
> little worried about overhead required to launch many forms rather than
> spending more lag time up-front to sync w/ releatively few but
> cumbersome forms. Any stories here?
>
> Thanks for your help.
>
> Charlton Purvis
>
> Advanced Solutions Group
> Department of Physics
> College of Science and Mathematics
> University of South Carolina
> Columbia, South Carolina 29208
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Sun Oct 08 2000 - 22:06:59 CEST