I am using toad for oracle client.
In which the session is disconnected after a while. How to enable it at any time.
See Dell website :
Maintaining database connections in general is not recommended...If you still want to force the connection, you can do this by doing one of the following two sentences.A)Include the DBMS output (poll) in Toad, which is similar to Toad, a ping database. Go to editor window | DBMS Output tab (lower half of the editor window) | click on the “Turn Output On” icon red icon | then the icon will turn green.. Toad 12.1, . , " " "", , 5 . 60 , .B)| | Session Browser, , .. Session Browser .
Maintaining database connections in general is not recommended
...
If you still want to force the connection, you can do this by doing one of the following two sentences.
A)
Include the DBMS output (poll) in Toad, which is similar to Toad, a ping database. Go to editor window | DBMS Output tab (lower half of the editor window) | click on the “Turn Output On” icon red icon | then the icon will turn green.
. Toad 12.1, . , " " "", , 5 . 60 , .
B)
| | Session Browser, , .
. Session Browser .
. - " ( )" .
--- > () .
, , .
,
--- > --- > "" . TestConnections (Reconnect) .
" (DCD) EXCERPT: " DCD , , - ".
JDBC .
JDBC : EXCERPT: " , ".
: Automic Applications Manager
1. sqlnet.ora :
SQLNET.EXPIRE_TIME=10 # some number less than the firewall
1b. .
lsnrctl reload listener
tnsnames.ora
(ENABLE = BROKEN) # : ( =
. Toad , . , Auto Open. View/Toad Options/Windows, Session Auto open. ☺