Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Location
    Bangalore
    Posts
    1

    Question Unanswered: SID is disappearing after some time

    Hi,
    I am using a java file to connect to the oracle database to retrieve some information and write it in to a file. I am just using select command to retrieve the data. There are no locks on the database (tables) and CPU utility is also normal. But while executing the program, after some time the connection is getting lost and my java program is still running.

    At the database end the SID is getting killed automatically after some time. That query actually takes some one and half hours to complete. Is there any concept of killing the session after some time if it is idle?

    Please help me out.

    Thanks
    ABCReddy.

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Hi,

    the execution time of the query is not taken as "idle". But, it is also possible to set the total elapsed time limit for a session in CONNECT_TIME parameter of user profile.

    You may find many articles about this:
    http://www.adp-gmbh.ch/ora/concepts/profile.html
    http://www.orafaq.com/wiki/Profiles_...ord_management
    http://asktom.oracle.com/pls/asktom/...:8966741067544
    And of course, it is also documented in SQL Reference book, which is available with all Oracle documentation e.g. online on http://tahiti.oracle.com/ Check the one for the Oracle version you use.

    If this a problem, ask your DBA to increase it (up to unlimited).

Posting Permissions

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