Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i Task Prioritisation

Re: Oracle 8i Task Prioritisation

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 24 Jul 2006 06:39:51 -0700
Message-ID: <1153748391.107244.96930@p79g2000cwp.googlegroups.com>


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 Mon Jul 24 2006 - 08:39:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US