Home » RDBMS Server » Server Administration » IDLE_TIME terminates the JDBC connection
IDLE_TIME terminates the JDBC connection [message #641577] Tue, 18 August 2015 07:29 Go to previous message
sgautam
Messages: 4
Registered: August 2015
Location: INDIA
Junior Member
Hello Experts,

I am new to oracle database and facing some issues.



    When user logged in the application (front end) and fetching the data, At the backend V$SESSIONS shows its session INACTIVE. I am not able to understand,why?


      I have set the value of IDLE_TIME parameter to make sessions inactive to snipped. It is working but it also disconnect the datasource.
      After this no user can login from front end until I restart the datasource from application server (JBOSS server). What should I do?

      Please help.

      Thanks!
      • Attachment: sql.txt
        (Size: 0.35KB, Downloaded 1608 times)

      Report message to a moderator

      [Message index]
       
      Read Message
      Read Message
      Read Message
      Read Message
      Read Message
      Read Message
      Read Message
      Previous Topic: Share tablespace between OLTP and OLAP
      Next Topic: ORA-01652 error
      Goto Forum:
        

      [ Syndicate this forum (XML) ] [ RSS ]

      Current Time: Thu Apr 18 21:30:46 CDT 2024
      .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.