Re: Oracle 8i Task Prioritisation

Hi Charles,

Thanks for your response. I've discussed it here and we're going to use the Resource Manager instead, although profiles would have assisted us if this wasn't available.

Thanks.

James

Charles Hooper wrote:
> Jimbo1 wrote:
> > Hi there,
> >
> > I've just been asked a question by our project manager to which I do
> > not know the answer with 100% confidence.
> >
> > We are running Oracle 8i (8.1.7) for Windows NT.
> >
> > We have a release process which is encapsulated within a package in the
> > database. When we execute the procedure that kicks off the release
> > process, is it possible to somehow convey to the database that this is
> > to be given lower execution priority than any other tasks that
> > resources are being used for?
> >
> > I suspect it's not; I always thought Oracle alone chose which tasks to
> > allocate resources to. However, if anybody knows differently, please do
> > not hesitate to let me know.
> >
> > Thanks in advance.
> >
> > James
>
> Take a look at Managing Resources with Profiles in the Oracle8i
> Administrator's Guide starting on page 511 (22-21). If the user
> name that executes the release process is assigned to a non-default
> profile, you might be able to control priority given to the release
> process. Example from the documentation:
> CREATE PROFILE clerk LIMIT
> SESSIONS_PER_USER 2
> CPU_PER_SESSION unlimited
> CPU_PER_CALL 6000
> LOGICAL_READS_PER_SESSION unlimited
> LOGICAL_READS_PER_CALL 100
> IDLE_TIME 30
> CONNECT_TIME 480;
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
Received on Tue Jul 25 2006 - 04:40:53 CDT