How do I check the connection timeout in Oracle?
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.
  
  ...