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

Thread: V$Transaction

  1. 02-25-2002, 10:32 AM #1
    Barabas
    Barabas is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 02-25-2002, 10:50 AM #2
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
  3. 02-25-2002, 11:02 AM #3
    Barabas
    Barabas is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. 02-25-2002, 11:11 AM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width