Dick - Thanks for posting your results. We have a different ERP (Lawson),
and we have been considering whether Resource Management is worth the
effort. Currently all users access Oracle through a single userid, but there
is an option for each user to have a separate login. The price is that you
the
Ed,
The version is 8.1.6 and yes it was with two different usernames. In the
end since we wanted to apply this to PeopleSoft where everyone is the same
userid it was impossible too. Still looking for another solution.
Dick Goulet
Reply Separator
Auth
Dick,
Which version of Oracle ?
Was your test with 2 different user ID's ?
Our problem is that all users log on
with the same user id, which seems
to diminish the product's effectiveness.
thanks.
ed
- Original Message -
To: "Multiple recipients of list OR
Kirti,
I've toyed with the product due to a perceived need here. The experiment
was to have two users loggin to the database both running very nasty queries (we
have the GOD of obfuscated SQL here). On the first pass, with no resource
management in place both queries ran successfully in 30 m
Bambi,
Boy you ARE rested!! Yes you can, their in the user profile & they work
darn well if you set 'resource_limit=true' in the init.ora file. The only
problem is that it does not re-submit the query, it just terminates the session.
Saves my bacon more times than I care to add up.
DickG.