OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Sniped process (Oracle 10.2.0.4 AIX 6L )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sniped process [message #483478]

Mon, 22 November 2010 06:57

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

Please explain what does 'SNIPED' status in v$session mean? It is killed/ clear from instance automatically or need to kill manually for releasing the resource.

Regards,
Jay vardhan

Report message to a moderator

Re: Sniped process [message #483483 is a reply to message #483478]

Mon, 22 November 2010 07:36

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SNIPED means the session was killed due resource limit exceeded. Session resources (like locks) are freed.
Oracle is then waiting for the user to ask it something to answer that its session is killed, then the session is cleared from v$session.

Regards
Michel

Report message to a moderator

Re: Sniped process [message #483488 is a reply to message #483483]

Mon, 22 November 2010 07:45

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Michel,

So this means in any of the case we are not in need to kill sniped session manually. It will be cleared by Oracle automatically.

Regards,
Jay vardhan

Report message to a moderator

Re: Sniped process [message #483513 is a reply to message #483488]

Mon, 22 November 2010 10:53

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have not to kill it, it is already killed by Oracle.

Quote:

Is there is any package or utility that I can use to fulfill the requirements?

Yes as soon as the user tries to do something, anything.

Regards
Michel

Report message to a moderator

Previous Topic:	environment variables
Next Topic:	Migration of Oracle Jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 20:08:03 CDT 2024