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

Thread: killing sessions

  1. 10-15-2002, 05:26 AM #1
    NormBro
    NormBro is offline Junior Member
    Join Date
    Oct 2002
    Location
    London
    Posts
    7
    I have killed a long running user session that was disconected from the application that started it,
    using alter system kill session.

    The process is now marked as killed but still shows as running and updating a table in v$session/v$sqltext.

    When does this get removed from Oracle ? Is it only after retsarting the database? Is is not in reality still runing ? (oracle 8.1.7)

    Thanks for any info.
    Reply With Quote Reply With Quote
  2. 10-15-2002, 05:40 AM #2
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    It is still running, and Oracle will clean up memory as soon as it finished or when you restart server. It not always stop process immediately after you kill session.
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  3. 10-15-2002, 11:00 AM #3
    tycho
    tycho is offline Member
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Wink

    Hi

    Maybe rolling back the updates?

    Tycho
    Reply With Quote Reply With Quote
  4. 10-15-2002, 02:08 PM #4
    virajvk
    virajvk is offline Member
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    Dear sir

    I have faced similar problems How frequently in terms of Seconds V$session view is refreshed ???
    I have seen people loggin out their sqlplus sessions/Applications sessions and still Sessions are active in V$session.

    Also How does PMON roll backs user transactions at what rate it queries the user Processes.

    I am sure we are not able to Tune PMON.

    Thanks

    Viraj

    A Wise Man Knows How much he doesn't know !!!
    Reply With Quote Reply With Quote
  5. 10-15-2002, 02:32 PM #5
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by virajvk
    How frequently in terms of Seconds V$session view is refreshed ???
    V$SESSION as any other V$ view is a simple, normal view (ie stored query), so it is never "refreshed".
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    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