Re: CREATE PROFILE QUESTION

With resource management in Oracle 8i, not before.

Pete

jacob wrote:

> Ok,
> i read the "Create pofile" dml statement.
>
> See its like this, we have say 20 online users, doing simple queries and
> such
> but then we have one user who is able to execute very complex queries.
> (multple tables,outer joins etc etc). Can we use ":Create profile" to stop
> this user from eating away system resources, so it wont bother the other 20
> users.
>
> Is it possible to execute the complex query but on a lower priority, because
> "Create profile" causes
> the session the abort if it is too "gready"...
>
> thanks in advance.

Received on Tue Sep 07 1999 - 12:44:44 CDT