Sign in or 
Share this
Showing 10 posts
|
jeegar |
Inactive sessions
Feb 7 2008, 5:02 AM EST
Dear Experts,We are using EMC SQUARE documentum application , and oracle 10g R2 database in sun solaris on seperate servers. Apps connects database unsing oracle client . In peak hours , oracle's inactive sessions are very high. How to overcome this issue ? I am looking for solution , which automatically disconnects after some time. I have one solution that is sqlnet.expiray_time wil it help me ?/ 1 out of 5 found this valuable. Do you? |
aarfie |
1. RE: Inactive sessions
Feb 8 2008, 12:35 AM EST
Dear jeegar,in Oracle inactive session are managed automatically, but even though u wana check the sessions status live and all the other things related to sessions like PGA size, logon time, phs reads, excute time, parse counts, rollback count, commit count, os-username, machine.... and so on. then you must go in the administrative tools. then area is top session system/manager. here you can see all the related things with session. and you graphically manage the session even kill the sessions. Muhammad Ahmad 0 out of 6 found this valuable. Do you? |
|
rjanci |
2. RE: Inactive sessions
Feb 8 2008, 3:15 PM EST
Hi Jeegar,This parameter is used for abnormal terminated connections - not inactive. I think better will be IDLE_TIMEOUT. Regards 0 out of 4 found this valuable. Do you? |
|
rjanci |
3. RE: Inactive sessions
Feb 8 2008, 3:23 PM EST
Hi,this may be another solutions - create profile for these users with IDLE_TIME definition. Try to use resource manager maybe. I think there might be some other solutions. Try official documentation. Regards 1 out of 4 found this valuable. Do you? |
|
pgajar |
4. RE: Inactive sessions
Feb 27 2008, 4:41 PM EST
We used to have this issue.Then with the help of the DBA's we scheduled a script which kills the inactive session after say n hours.This has really helped us.Thanks 2 out of 3 found this valuable. Do you? |
yngmrmoon |
5. RE: Inactive sessions
Mar 7 2008, 4:28 PM EST
One of the best ways that we managed at my last place of employment was to run a pl/sql procedure that looked at the the current status, logon_time, and the last_call_et. If the last_call_et was over 2 hours and the session was inactive, the package in turn ran the job to kill the session. I'm sure there are a lot of variations on this but that one worked very well for us.
3
out of
3 found this valuable.
Do you?
|
|
jmacaskill |
6. RE: Inactive sessions
Mar 8 2008, 7:20 PM EST
Your best bet is to activate Dead Connection Detection and let Oracle manage this automatically. Simply set SQLNET.EXPIRY_TIME=(Desired time in minutes) in the SQLNet.ora file and let Oracle do its job. Worth noting that this probably shouldn't be used in critical windows based environments as it can lead to Thread leak problems due to different architecture. John MacAskill 2 out of 3 found this valuable. Do you? |
Harsh.Chawla |
7. RE: Inactive sessions
Mar 12 2008, 1:18 AM EDT
Hi, You can create a profile in which there is a parameter idle_time . U can set that paramater to the time in mins as per the requirement. After this much time oracle database changes the state of the session to sniped. u can schedule the script which could kill all the sniped sessions. that is one of the best solution. Do you find this valuable? |
|
rogermiller2006@yaho |
8. RE: Inactive sessions
Apr 2 2008, 10:17 AM EDT
please i have a problem with this OTN how do i ask questions dont laugh or blame me i just joined the website newlythanks 0 out of 1 found this valuable. Do you? |
|
rogermiller2006@yaho |
9. RE: Inactive sessions
Apr 2 2008, 10:20 AM EDT
hello i just passed my OCP exam and am looking for friends that help me know more about oracle and how i can get the documentation handbooks from nigeria here thanks 0 out of 1 found this valuable. Do you? |
