Re: [Urgent] Resouce Limits & DBMS JOB

I have no experience with it, but you can create profiles (CREATE PROFIL E
... LIMIT ...) for each user or group of users (ALTER USER ... PROFILE

...). This way you can have other cpu-usage settings for each user if

that is what you want.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-08-29, 20:59:44, schreef salman z g_at_hotmail.com over het thema

Re: [Urgent] Resouce Limits & DBMS JOB:

> This means ... that if a job exhausts its session resouces it cannot
> run any further. How to overcome this? Anyway to revive the values
> again?
 

> Where does oracle stores the values for resources utilized. e.g.
> CPU Usage done by a session/job.
 

> Can we modify that data?
 

> Thanks.
 

> Salman

> In article <967545511.3292.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > Answers embedded
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <salman z g_at_hotmail.com> wrote in message
> > news:8oe9da$n75$1_at_nnrp1.deja.com...
> > > Are the DBMS JOBs being run under a user are affected by the
 resource
> > > limits on that user?
> > >
> >
> > Yes of course
> >
> > > e.g. If CPU-USAGE-TIMEOUT occurs ... it looks to me like no job
 would
> > > be allowed to execute any further in the future.
> > >
> > > Is this true?
> > >
> >
> > No
> > all limits are per session limits and a job corresponds to a session
 .
> > > Is there any article/link addressing this issue?
> >
> > The Oracle docs?
> >
> > >
> > > Thanks.
> > >
> > >
> > > SALz
> > > //
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 30 2000 - 00:38:37 CDT