• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11378
  • Last Modified:

oracle session timeout

Is there any variable through which we can control oracle session time out period
0
iTeamIndia
Asked:
iTeamIndia
  • 2
1 Solution
 
diasroshanCommented:
0
 
schwertnerCommented:
You can provide your users ROLES.
In the roles you can limit session and idle time.

To kill DEAD (no software waiting on the client side) session
in SQLNET.ORA file set
SQLNET.EXPIRE_TIME = 20

This will kick oout dead sessions every 20 minutes.

You can customize these parameters to fit your shop and developer environment.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now