Re: V$transaction query?

See the post on Jun 2 titled 'Steps for removing jobs"

Jared

On Friday 01 June 2001 13:47, 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
>
> From: "Stephane Faroult (sfaroult_at_oriole.com)" <sfaroult_at_oriole.com>
>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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 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 dbms_jobs.remove packge.It show
> > > error.
> >
> > Which one ? You must be the user which created it to be able to
> >remove it, being a DBA is not enough (although you can magically become
> >anybody when you are a DBA - you may find become.sql, in the DBA toolkit
> >on the Oriole site, useful for this, as well as for grants and for
> >toying with private database links or more precisely recompiling stored
> >objects which refer to private database links).
> >
> > > When I try to kill session by alter system kill session command then
> > > it shows ORA-00031: session marked for kill error.I cann't find more
> > > information of metalink.Let me know how can solve this problem.
> >
> > Hmmm, jobs are a bit special. They are Oracle background processes in
> >the same respect as dbwr, lgwr and the like - they execute stored
> >procedures on your behalf, but they are not ordinary sessions. It is not
> >surprising you cannot kill them because the same snpxxx which is running
> >your job right now may be expected to run a job for somebody else
> >shortly after or even possibly refreshing a snapshot.
> >
> >IMHO you should log as the user on whose behalf the job is run and
> >remove it using the dbms_job package.
> >
> >Regards,
> >
> >Stephane Faroult
> >Oriole Corporation
> >Voice: +44 (0) 7050-696-269
> >Fax: +44 (0) 7050-696-449
> >Performance Tools & Free Scripts
> >--------------------------------------------------------------
> >http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> >--------------------------------------------------------------
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Stephane Faroult (sfaroult_at_oriole.com)
> > INET: sfaroult_at_oriole.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).