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!

  • Can you please clarify what you mean by "timeout for an active connection"? Are you referring to CONNECT_TIME in the resource profile? something else?
    – mustaccio
    Sep 19, 2018 at 13:01
  • @mustaccio I don't know how to name properly in Oracle database terms but I mean how long I can keep a connection open using it Sep 19, 2018 at 13:08

1 Answer 1


These are properties of user profiles. Query DBA_PROFILES.





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


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.


  • thank you for the answer! I've tried it using SELECT CONNECT_TIME FROM SCHEMA_NAME.DBA_PROFILES; but it gives me ORA-00942: table or view doesn't exist Sep 19, 2018 at 13:06
  • SYS owns DBA_PROFILES. Their is also a public synonym for it. If you can't see it, then you don't have the proper "creds". Your DBA should be able to help if you don't have the proper credentials Sep 19, 2018 at 13:12
  • @Balazs Papp makes sense. but what are the public synonyms may be? Sep 19, 2018 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.