어느 가을날의 전환점

TOAD|오라클 세션 타임아웃으로 컨넥션이 끊기는 경우 토드 팁 본문

Database/Oracle

TOAD|오라클 세션 타임아웃으로 컨넥션이 끊기는 경우 토드 팁

어느가을빛 2014. 5. 21. 17:27

connection을 유지하기 위하여 주기적으로 DB에 작업을 요청하는 것으로

Toad에서는 DBMS Ouput의 Polling과 Session Browser의 Refresh 기능을 활용 할 수 있다.


------------------------------------------------------------------------------


Keeping database connections alive is generally not recommended


...


If you would still like to force connectivity at all times, you can do so by doing one of the following two suggestions.


A)

Turn ON the DBMS Output (Polling) in Toad, which is similar to Toad pinging the database.

Go to the Editor Window

--> DBMS Output Tab (lower half of the Editor window) 

--> click on the "Turn Output On" red icon --> then the icon will turn green.


NOTE: Starting Toad version 12.1, it’s little different. Also ensure the “Interval Polling” button or icon is 'depressed' as that is the one that sends the polling at every i.e. 5 seconds. You can set this to 60 seconds, which is the max.


B)

Start Database --> Monitor --> Session Browser, which has an auto refresh feature, which should cause some activities to occur on the database.


NOTE: The Session Browser feature requires DBA privileges.

0 Comments
댓글쓰기 폼