V$Transaction

Hello There

I have 3 active jobs that i have scheduled on my db,
one of the other guy's here, already manually updated the tables & now i want to stop the job that is currently running?

Is there any way that i can do this? i.e. killing the session?

Or do i have to wait till the job is finished??

Thanks in advance for any help recieved.

You can kill it, how depends on the OS. Just keep in mind that after you kill it you will have to wait for Oracle to ROLLBACK.

MH

thanks for the quick reply

I am running on NT. Is there a specific Nt command

Will i use? the Oracle Kill Session command?

I THINK you can query the v$session.
SQL> select sid, serial#, username
friom v$session.

From there you need to know which session to kill.

MH