Re: How to restrict Oracle session using too many CPU usage

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Mon, 23 Apr 2001 11:16:36 +0200
Message-ID: <9c0viq$b9q$1@papyrus.erlm.siemens.de>

Oracle allows you to create own profiles [CREATE PROFILE] and assign these profiles to users. The profile allows settings for (e.g.) cpu_per_session (CPU time limit for a session, expressed in hundredth of seconds), cpu_per_call (CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds), sessions_per_users,...

Klaus
Anthony <nospam_at_newsranger.com> schrieb in im Newsbeitrag: 5XRE6.1619$QV4.129217_at_www.newsranger.com...
> Is there any way to restrict one Oracle session to use too many CPU usage
(e.g.
> only allowed to use 10% of overall CPU usage)? Is Oracle having some
global
> parameters to do such setting?
>
>
Received on Mon Apr 23 2001 - 04:16:36 CDT