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

Thread: Session blocked

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    Session blocked

    Hi, I was asked in an interview. Why do sessions gets blocked?

    Can I get an answer for this.


    thanks,

  2. #2
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    2 things i can recall now:
    1. when users r trying to upadate the rows on which others sessions have acquired a lock..
    2. when d database is quiesced. Without the ability to quiesce the database, you would be required to shut down the database and reopen it in restricted mode
    lucky

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    Quote Originally Posted by iris View Post
    Hi, I was asked in an interview. Why do sessions gets blocked?

    Can I get an answer for this.


    thanks,
    a very easy answer, when a session tries to do something what some other session is already doing and has not completed (commited) his task yet. :P

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