4 Replies Latest reply: Nov 6, 2013 8:37 AM by user12077236 RSS

    Forms max user session 11gR2

    user12077236

      Hi,

       

      I have three simple questions, can anyone help me to find out the answers.

       

      What is the max user session for oracle forms 11.1.2.1 version?

      If the max user sessions limit reached how can we handle it?

      How can i get max user session for forms 11.1.2.1 version through sql code?

       

      Thank You!

      Dilli Babu. S

        • 1. Re: Forms max user session 11gR2
          Paul M.

          What is the max user session for oracle forms 11.1.2.1 version?


          How can i get max user session for forms 11.1.2.1 version through sql code?

          Not sure what you mean by "max user session", but since you mention sql code, then I have to think that you mean database sessions. If so, you can check out SESSIONS parameter :

          SQL> sho parameter sessions

          If you mean something different, please clarify.

          • 2. Re: Forms max user session 11gR2
            user12077236

            Hi PaulM,

            Thanks for your reply...

             

            Its not related to Oracle database..I am talking about Oracle forms and reports.

             

            When user access forms application in web, a forms User session will be visible in OEM.

             

            My question is How many concurrent users can access oracle forms 11.2.1.1 application through web at a time?

             

            Is there any limit? if so how we can know number of users accessing the Oracle forms application 11.2.1.1 through web?  Is there any parameter to display the number of users accessing the forms application ?

            • 3. Re: Forms max user session 11gR2
              Paul M.
              When user access forms application in web, a forms User session will be visible in OEM.

              So you can see how many forms user sessions are there at any time.


              You may get this information at OS level as well, using the command "opmnctl status".

              My question is How many concurrent users can access oracle forms 11.2.1.1 application through web at a time?

              Is there any limit?

              You can set it in formsapp administration console, the default value is -1, which means unlimited.

              • 4. Re: Forms max user session 11gR2
                user12077236

                Thank you ....