| 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?
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
-- 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).Received on Fri Jun 01 2001 - 13:56:44 CDT
 |
 |