Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unhappy Unanswered: How to give a restrict elapsed time CPU to an USER ORACLE

    Hi everybody.

    I've got two questions for you...

    One : How can we limit the CPU TIME for a requester ( USER ORACLE or THREAD )

    TWO : How can we give more priority to a user rather than another ... ??

    I've USER1 and USER2 and I want that USER2 Has the result of his query faster and earlier than USER1

    Can we do that with Oracle PACKAGES ..????

    Thanks for your response....


  2. #2
    Join Date
    Oct 2005
    You can do that using Oracle Profiles.

  3. #3
    Join Date
    Dec 2003
    For priority look into Resources, or Resource Manager.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts