OraFAQ Forum: SQL & PL/SQL » oracle parallelism

Home » SQL & PL/SQL » SQL & PL/SQL » oracle parallelism

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle parallelism [message #251654]

Sun, 15 July 2007 22:56

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?

Report message to a moderator

Re: oracle parallelism [message #251656 is a reply to message #251654]

Sun, 15 July 2007 23:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle parallelism [message #251679 is a reply to message #251654]

Mon, 16 July 2007 01:17

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?

Report message to a moderator

Re: oracle parallelism [message #251684 is a reply to message #251679]

Mon, 16 July 2007 01:29

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	DBMS_SNAPSHOT.REFRESH
Next Topic:	Regrading bulk upload(FOR ALL)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:51:02 CST 2024