5 Replies Latest reply: Jan 7, 2013 2:39 PM by Hussein Sawwan-Oracle RSS

    changing priority of concurrent request

    937973
      Hi

      Please let me know is it possible to change the priority of a concurrent request submitted by the batch user(any particular user) only.

      1)
      I know we can use the profile option but that does not serve the purpose because i dont want the priority of all the other requests submitted by that user to be changed ,just for one particular concrrent request i want this to happen.
      2)
      From system admin also it can be done but this will make the priority of that request to change so it will be the same irrespective of the user.

      Actually i want to CHANGE the priority of a concurrent request only when it is submitted by a particular user (through CONCSUB utility)and that should affect the priority of other requests submitted by that user ,they should remain as it is.
        • 1. Re: changing priority of concurrent request
          Srini Chavali-Oracle
          Pl post details of OS, database and EBS versions

          The priority is associated with a particular user. I do not believe it can be set as a parameter using CONCSUB. One option you have is to create a new user, set the concurrent priority profile for the user, and use this user to submit just the one concurrent request.

          HTH
          Srini
          • 2. Re: changing priority of concurrent request
            Hussein Sawwan-Oracle
            Please let me know is it possible to change the priority of a concurrent request submitted by the batch user(any particular user) only.
            How the request is being submitted? Is it from the application or the OS or using an API?
            1)
            I know we can use the profile option but that does not serve the purpose because i dont want the priority of all the other requests submitted by that user to be changed ,just for one particular concrrent request i want this to happen.
            2)
            From system admin also it can be done but this will make the priority of that request to change so it will be the same irrespective of the user.

            Actually i want to CHANGE the priority of a concurrent request only when it is submitted by a particular user (through CONCSUB utility)and that should affect the priority of other requests submitted by that user ,they should remain as it is.
            Why don't you schedule the concurrent program from the application under that specific user and set the priority then?

            I also believe you cannot set priority if you use CONCSUB for a specific concurrent program under specific username.

            Thanks,
            Hussein
            • 3. Re: changing priority of concurrent request
              937973
              found the resolution myself.
              • 4. Re: changing priority of concurrent request
                Srini Chavali-Oracle
                Pl post the solution so it can help others in the future

                Thanks
                Srini
                • 5. Re: changing priority of concurrent request
                  Hussein Sawwan-Oracle
                  934970 wrote:
                  found the resolution myself.
                  Great! It would be nice if you could share the solution with us.

                  Thanks,
                  Hussein