Is there a way for TDP to ping the database at specified interval times or is there a Keep Alive or a Ping feature to prevent network timeouts? Gets error: ORA-03135: connection lost contact Process ID: 0 Session ID: 618 Serial number: 29841.
Ask your Network or IT Helpdesk to increase the network timeout for you.
1) Open an Editor Window.
2) At the bottom part of screen, click on the “Messages” Tab.
3) Click or depress the “Poll DBMS Output for lines” icon (looks like a clock icon).
4) You can increase the Poll Frequency from 5 seconds, but max is 30 seconds.
5) From then on, TDP will send a code similar the one below to your database. This will act like a ‘ping’ to keep your database connection alive.
Timestamp: 6/21/2011 3:48:14 PM
begindbms_output.get_lines(lines => :lines, numlines => :numlines); end; -- 145
Elapsed time: 0.000