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

From: Syltrem <syltrem_at_videotron.ca>
Date: Mon, 23 Apr 2001 09:02:46 -0400
Message-ID: <zEVE6.3977$y54.466929@wagner.videotron.net>

> Possibly, It depends on your OS. Oracle doesn't have such a facility
> built in, your OS may have a general purpose utility for this.

On OpenVMS use the SYS$SCHED function call. It does exactly what you are asking for.

Another poster told about Oracle's CREATE PROFILE but that sets limits and will make the process abort if they are outrun (unless I'm very well mistaken). That's not what you want.

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site)

Received on Mon Apr 23 2001 - 08:02:46 CDT