How to check the connection timeout in Oracle

oracleoracle-12c

I need to check Oracle 12c timeout for an active connection. I don't have access to the database itself but I do have some creds. Is there a table to query to get this information?

Thank you!

Best Answer

These are properties of user profiles. Query DBA_PROFILES.

CREATE PROFILE

resource_parameters

...

CONNECT_TIME

Specify the total elapsed time limit for a session, expressed in minutes.

IDLE_TIME

Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.

...