Re: Restricting user's resource access

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 19 Jul 2002 14:36:16 +1000
Message-ID: <9AMZ8.38293$Hj3.115369@newsfeeds.bigpond.com>

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
"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?
Received on Thu Jul 18 2002 - 23:36:16 CDT