Oracle 816, Win2000
Profile has idle time set to 1 min.
Why is it that the sessions don't disconnect after the idle time is passed.
The status of some sessions are INACTIVE and some are SNIPED.
What does SNIPED mean and how do I get around this issue of disconecting or killing the sessions.
Sessions do not get disconnected hence max sessions exceeded.
Any suggestions .........
Check whether ur RESOURCE_LIMIT init.ora parameter is set to TRUE.
U can check it at the Servermanager prompt by typing
SVRMGR> show parameter resource
If u have resource_limit set to FALSE,then Oracle will not use the resource management used in the PROFILE.Password Management in profiles doesnot depend on RESOURCE_LIMIT parameter.
Change the init.ora file and make RESOURCE_LIMIT=TRUE
and bounce back the database.If u cannot shutdown the database enter the following command
SVRMGRL> alter system
Next time when ur database is shutdown and restarted RESOURCE_LIMIT will become FALSE.So better change the init.ora file and bounce the database.
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
Have already done that bit.
Please can someone tell me what does SNIPED mean ablut the status of connected user.
And why is the session not disconnecting after the 1 minute idle time.
Here is a thread that would help you a bit.
Oracle wouldn't allow the sessions user who had been marked sniped to reconnect. IF he/she were to try using the same session, it would say session expired. It would physically remove that connection only when the user gets to log out. That is my undestanding of it.
[Edited by sambavan on 04-27-2001 at 10:53 AM]
This is a mobile phone manufacturing plant.
Systems test phones and results logged into DB.
Now, everytime a phone is tested, the s/w opens a session to the DB and logs results to DB, not disconnecting it after its finished instead opens another session for the next phone tested results.
Results are generated ones every 2minutes and there are 10 systems(stations) testing now.
I have max sessions set to 1048 hoping it would be alright when there will be 100 stations running. This doesnt seem to be the case.
Now my question is if the session is marked as SNIPED does oracle count that particular session as 1+ to the max sessions or is it that the session is Killed hence not counted.
It looks like the sniped sessions are not cleaned up immediately.
Here is a metalink not that has the script that you could run to clean the sniped sessions.
If "init.ora" resource_limit = true, and idle_time set in profile.
When idle_time exceeds, the session status becomes 'sniped' in v$session,
but sniped sessions never get cleaned up.
Using 'alter system kill session' to kill the session, session status becomes
'killed' in v$session, but still is never cleaned up.
On Unix, and if using a dedicated server, use the following shell script to
kill the shadow process (script has been tested on Solaris, AIX, Tru64 and
sqlplus system/manager <
select p.spid from v\$process p,v\$session s
for x in `cat $tmpfile | grep "^"`
kill -9 $x
According to several bugs as shown in references, it's still expected behaviour
that sniped session may never clean up. The only workaround is to kill the
I have win2000 but i'll find a way to kill the SNIPED sessions.
Does this mean that SNIPED sessions are counted towards the max sessions, if so then the Profile IDLE time concept of Oracle is of no good.
I believe there is an explanation to this.
Thanks any way....
I've just noticed that SNIPED do disappear in a while, dont know how long they take though.
On that case it could be alive until the PMON gets to awake up and clean the stray session processes.
For further details on this issue, check the metalink.