Re: CPU_PER

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Thu, 6 Sep 2001 07:41:13 -0400
Message-ID: <gjJl7.32555$v%4.3088562@news20.bellglobal.com>

Hi Georgy,

I certainly don't claim to be an expert on this topic. One thing to consider though is that
the CPU_PER_CALL limit is a limit for each call, not a limit on the time that the query needs to run.

Hopefully, this will help,

Steve

"Georgy Mateev" <gmateev_at_yahoo.com> wrote in message news:6c73f7f0.0109051124.b124f75_at_posting.google.com...
> I tried to use CPU_PER_CALL lilitation.
>
> 1. I created PROFILE:
> CREATE PROFILE LIMIT1 LIMIT CPU_PER_CALL 20;
> 2. I altered user:
> alter user ins profile LIMIT1;
> 3. I executed statement:
> ALTER SYSTEM SET RESOURCE_LIMIT = TRUE; with SYSTEM account
>
> After that, i executed LONG QUERY (for example execution time > 2 sec).
> My execution did not break.
>
> Can anyone help me?
>
> Georgy Mateev
> gmateev_at_yahoo.com
Received on Thu Sep 06 2001 - 06:41:13 CDT

Re: CPU_PER_CALL