Home » SQL & PL/SQL » SQL & PL/SQL » oracle parallelism
oracle parallelism [message #251654] Sun, 15 July 2007 22:56 Go to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
i have a user test. i want to limit the no. of parallel stream this user get. how do i do that?
Re: oracle parallelism [message #251656 is a reply to message #251654] Sun, 15 July 2007 23:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't limit the degree of parallelism of ONLY one user or session.

Well, actually it is possible through resource manager with certain condition but it seems you're trying to solve an organization problem with a technical solution.
Who is TEST? Why do you want to limit it? What is its job? Why do you use it?...
Does it work on production system?

Regards
Michel
Re: oracle parallelism [message #251679 is a reply to message #251654] Mon, 16 July 2007 01:17 Go to previous messageGo to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
Test is just a normal user. This user can insert, update and delete on a table. Reason why i wanted to limit the no. of parallel stream is because when Test runs an insert statement it takes up the resources and when another user want to do a insert statement it will no more stream. So the answer is i cant limit it?
Re: oracle parallelism [message #251684 is a reply to message #251679] Mon, 16 July 2007 01:29 Go to previous message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer is already given.
You don't say what is the purpose of TEST user and why there are other users concurrent to it?
Why can't you limit the parallelism degree of your INSERT statement? Show hint PARALLEL.

Regards
Michel
Previous Topic: DBMS_SNAPSHOT.REFRESH
Next Topic: Regrading bulk upload(FOR ALL)
Goto Forum:
  


Current Time: Mon Dec 05 05:06:29 CST 2016

Total time taken to generate the page: 0.15468 seconds