| priority query [message #148713] |
Sat, 26 November 2005 19:09  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Hi guys: here is some thing I am searching around. Is there a way we can put priority on the query. To make it clear, let's say, there are two users A and B. Can We put an oracle curse on user A so that his query will be always given a low priority and takes longer time to run compared to user B even if they both running the same query.
I am wondering,if we script a sql query and embeded inside a korn script and fire with a high nice value, does it lower down its priority and takes longer time to complete. My assumption that when the user running the query inside a korn subshell, it is an unix process and if we put a high nice value, then it would get less attention from kernel (cpu) and so run slower. Correct me please on this issue.
thanks.
|
|
|
|
|
|
|
|
| Re: priority query [message #149202 is a reply to message #148713] |
Wed, 30 November 2005 09:16  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Agreed, use profiles where you can control cpu and memory and other resource utilization at the user level.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
