1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

regarding session time out

Discussion in 'General' started by karthikeyanc2003, Oct 23, 2009.

  1. karthikeyanc2003

    karthikeyanc2003 Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    100
    hi folks,
    i have a procedure which has a update query of a table contain large volume say 10 million and it will take around 10 hours , but the problem is that when i run the sp it got the session time out error after six or seven hours becsuse of that whole sp fails how to retifi it how to extend the session timeout time
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Check the sqlnet.ora file on the database server; timeouts are configured there.