Re: Restricting user's resource access

In article <9AMZ8.38293$Hj3.115369_at_newsfeeds.bigpond.com>, "Richard says...
>
>Hi Red,
>
>Your question has been answered quite validly by other posters. However,
>depending on *why* you want to limit someone's resources, you may want to
>check out the Database Resource Manager. Particular now with 9i where such
>queries can be prevented from executing in the first place with the new
>MAX_ESTIMATED_EXEC_TIME limit (whereas with profiles, resources are
>potentially wasted in executing parts of such queries).
>
>Might be worth investigating (check out the Administrator's Guide which
>explains it all).
>
>Good Luck
>
>Richard

Only problem with that idea is that from what I understand the Resource Manager only kicks in when the resource being managed (I/O, CPU etc.) is already exhausted. I don't think that meets the OP's requirement.

Pete
>"Red Valsen" <red_valsen_at_yahoo.com> wrote in message
>news:3da2a85c.0207180419.323c567f_at_posting.google.com...
>> Can the Oracle database server restrict the amount of resources,
>> namely memory and disk, that a single user can consume for a query?
>> If so, how is this done? What has to be set up? Does it work? Any
>> limitations?
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Jul 19 2002 - 11:09:56 CDT