V$Transaction
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: V$Transaction

  1. #1
    Join Date
    Aug 2000
    Posts
    68
    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.
    Carpe Diem

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    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
    I remember when this place was cool.

  3. #3
    Join Date
    Aug 2000
    Posts
    68

    reply?

    thanks for the quick reply

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

    Will i use? the Oracle Kill Session command?
    Carpe Diem

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    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
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width