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

Thread: weird session

  1. #1
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    weird session

    this bothers me guys,

    when I use OEM to view session to be killed, I can't see it.
    But when I use sqlplus i did see it and eventually killed it.
    I did kill it in sqlplus but the session remained.
    What seems to be the problem? current status right now is KILLED.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Wait till PMON clears the process.. Or go and kill the OS process itelf.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Do I just have to wait the smon(or was it pmon?) to clean this mess,
    or there's a workaround?

    This happens when power failure occurs and some users doesn't have a UPS and when they logged the next time they can't, because there is still a session left under there username.

    May workaround for now is to assign them to a profile with much higher number of login, but of course this is not a good practice for ease of maintenance seak.


    Thanks in advance.

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by SANJAY_G
    Wait till PMON clears the process.. Or go and kill the OS process itelf.
    thanks SANJAY_G,
    you just remind me the kill -9 osprocess command in SOLARIS

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