| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: V$transaction query?
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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: oracledbam_at_hotmail.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).Received on Fri Jun 01 2001 - 14:41:23 CDT
 |
 |