Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i Task Prioritisation
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