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 Tue Aug 29 2000 - 13:59:44 CDT