V$Transaction

[Barabas]

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.

[Mr.Hanky]

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

[Barabas]

thanks for the quick reply

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

Will i use? the Oracle Kill Session command?

[Mr.Hanky]

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