1

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 '18 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 – Dmitry Senkovich Sep 19 '18 at 13:08
1

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.

...

  • 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 – Dmitry Senkovich Sep 19 '18 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 – Michael Kutz Sep 19 '18 at 13:12
  • @Balazs Papp makes sense. but what are the public synonyms may be? – Dmitry Senkovich Sep 19 '18 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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