User working in Toad gets kick out of a connected database session after 10 to 15 minutes. Does Toad for Oracle have a feature which limits the time of a session?
Toad itself does not have any features that would limit the time of a connected database session. Please check the following.
1. Check to see if a profile has been assigned to your schema. If there is a profile assigned, see if the profile has these tow parameters:
- CONNECT_TIME which specifies in seconds how long a session may remain connected to a database.
- IDLE_TIME which determines how long a session can remain idle.
2. Check to make sure that the RESOURCE_LIMIT initialization parameter is not set to "TRUE." A "TRUE" enforces the resource limits assigned to a user through profiles.
3. In the server's SQLNET.ora, check to see if you have SQLNET.EXPIRE_TIME parameter. If you do, you can comment it out or increase the value.
4. In the TNSnames.ora file, change the 'HOST =' parameter of the affected connection to the actual IP address rather than its alias Host name.
- For example:
Change From
-------------------
CONNECT.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = address.alias.com)(PORT = 1529))
)
(CONNECT_DATA =
(SERVICE_NAME = connect.world)
)
)
To Be
--------
CONNECT.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.101.101)(PORT = 1529))
)
(CONNECT_DATA =
(SERVICE_NAME = connect.world)
)
)
If you are not a DBA please consult your DBA on the consequences changing the above may have on the database. Please consult your Oracle literature or your DBA on whether or not the database has to be re-started for the above changes to take place.
