t;Stephane Faroult ([EMAIL PROTECTED])" <[EMAIL PROTECTED]>
>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: V$transaction query?
> >Date: Fri, 01 Jun 2001 12:08:41 -0800
> >
> >Seema
Seema Singh wrote:
>
> Job has removed but there is still entry available in dba_jobs_running table
> and v$session.How can I solve it.
>
> Thx
> -Seema
>
Short of rebouncing your database, I do not really see anything ...
--
Regards,
Stephane Faroult
Oriole Corporation
Voice: +44 (0) 7050
AIL PROTECTED]>
>Subject: Re: V$transaction query?
>Date: Fri, 01 Jun 2001 12:08:41 -0800
>
>Seema Singh wrote:
> >
> > Hi
> > If I have sid or serial no of session then how can I know which
>trasaction
> > is going on in v$trasaction table.
>
>Look for
t;To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: V$transaction query?
>Date: Fri, 01 Jun 2001 10:57:19 -0800
>
>Hi
>If I have sid or serial no of session then how can I know which trasaction
>is going on in v$trasaction table.
>Another
Seema Singh wrote:
>
> Hi
> If I have sid or serial no of session then how can I know which trasaction
> is going on in v$trasaction table.
Look for statements in 'ACTIVE' state in V$SQLAREA.
> Another query: some job is haning frequently in our database
> (Oracle8.1.7).When I try to remove by
Hi
If I have sid or serial no of session then how can I know which trasaction
is going on in v$trasaction table.
Another query: some job is haning frequently in our database
(Oracle8.1.7).When I try to remove by dbms_jobs.remove packge.It show
error.When I try to kill session by alter system ki