Re: performance penalty with RESOURCE

From: Fred Stojentin <stojentin_at_orgdv.din.de>
Date: Tue, 22 Jun 1999 12:30:28 GMT
Message-ID: <376f8021.2033103@news.cis.dfn.de>

On Mon, 21 Jun 1999 17:20:24 -0500, "Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote:

>
>Any performance issues for non-limited users/sessions on a system where
>RESOURCE_LIMIT is turned on ?
>

Hi,

there is no performance impact when limiting some/all sessions via resource_limit, because the data needed to compare with the limits is always collected (look at v$sqlstat).

Maybe you can see a little bit slower execution of very fast/rapidly executed sql statements in procedures (less then 1% when using resource limits on statement level and executing more then some 1000 per second).

Fred Stojentin Received on Tue Jun 22 1999 - 07:30:28 CDT

Re: performance penalty with RESOURCE_LIMIT??