This content has been marked as final. Show 12 replies
Can someone tell me what I am doing wrong? IAgain? - You want us to tell you again?
OK, for consumer_group1 you use just = instead of =>
And, there are no arguments called
They are called
Why not focus on the question ou already asked in another and the correct answers given there.
Do we have to start all over, again?
Maybe rude behaviour in general is your trademark, anonymous number
Status Level: Newbie
Registered: Dec 12, 2012
Total Posts: 49
Total Questions: 14 (14 unresolved)
First and foremost before you make a comment that is uncall for you need to gather all of facts. I am not rude, maybe rude is your trademark! You will never find a rude comment in this forum that is associated to my handle. I attempted to pick up where I left off, but for whatever reason I am not able to.
It considered rude never to close any threads.
It is also considered rude, to open exact same thread, after having at least to correct answers for very same question.
I do not need to gather all facts, but it would be nice if you could apply the them.
Why not start with why you do not belive this question is answered already?
Maybe you are facing some problem that we have not yet been able solve, but why start from very beginning of syntax simply being wrong?
Are you not able two understand two different people saying that your arguments are named (And used) wrongly?
976505 wrote:it works for me!
I have taken the advice and tried everything suggestion that was given and I am still getting the same error message along with others. I am new to the forum so again before you call someone rude, you need to know the facts.
1 BEGIN 2 DBMS_RESOURCE_MANAGER.create_simple_plan ( 3 simple_plan => 'system_plan', 4 consumer_group1 => 'APPUSER', 5 group1_cpu => 60, 6 consumer_group2 => 'Low_group', 7 group2_cpu => 40 8 ); 9* END; SQL> / PL/SQL procedure successfully completed.
976505 wrote:As stated in the docs, you linked to yourself in previous thread:
I am curious, is there a way to designate a different level, if that makes any sense?
Each consumer group specified in the plan is allocated its CPU percentage at level 2So, like SY said in that thread, you would probably have to look into Creating Complex Resource Plans
P.S: If you want to ask more detailed questions about the Database Resource Manager, then PL/SQL forum is probably not the best place to do so
Edited by: Peter on Mar 9, 2013 12:35 PM
I greatly appreciate your help.No problem , and sorry if I have been rude myself.
Yes, my question has been answered to close this thread?Yes, that would do it. This you can do at any time. Also old threads if you are happy with the answer and/or nothing more is being said.
(Upper left corner of each of your threads has "Mark as answered")