Home » Infrastructure » Unix » Using ps -ef |grep LOCAL (Oracle 10g,solaris)
Using ps -ef |grep LOCAL [message #408100] Sun, 14 June 2009 01:45 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


Hi ,


Can anybody let me know the purpose of these 2 commands and their impact in oracle

ps -ef |grep LOCAL=NO

ps -ef |grep LOCAL=YES


Mohan
Re: Using ps -ef |grep LOCAL [message #408107 is a reply to message #408100] Sun, 14 June 2009 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LOCAL=YES => local connection
LOCAL=NO => remote connection

Regards
Michel
Re: Using ps -ef |grep LOCAL [message #408111 is a reply to message #408107] Sun, 14 June 2009 04:15 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

I faced a situation where my database was taking
long time to down when i issued shutdown immediate
( at that time some users were still connected).
so can i use ps -ef |grep LOCAL=NO to list and
kill processes using kill -9 spid (connecting remotely)
that are still in action if i face such situation
from nxt time ?

I think if i kill the processes which lists
from ps -ef |grep LOCAL=YES
will end up in trouble
ie the local connection will get closed.

Please correct me if im wrong.




[Updated on: Sun, 14 June 2009 04:17]

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408113 is a reply to message #408111] Sun, 14 June 2009 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use shutdown abort if you don't want to wait.
Of course you have to know the drawbacks (as well as those when you kill the process).

Database Concepts
Chapter 12 Database and Instance Startup and Shutdown

Regards
Michel
Re: Using ps -ef |grep LOCAL [message #408174 is a reply to message #408113] Mon, 15 June 2009 00:44 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
I faced a situation where my database was taking
long time to down when i issued shutdown immediate
( at that time some users were still connected).
so can i use ps -ef |grep LOCAL=NO to list and
kill processes using kill -9 spid (connecting remotely)
that are still in action if i face such situation
from nxt time ?

I think if i kill the processes which lists
from ps -ef |grep LOCAL=YES
will end up in trouble
ie the local connection will get closed.


As per as i know; try to kill those session
 ( ps -ef | grep local=yes and ps -ef | grep local=no )


Thanks

Babu
Re: Using ps -ef |grep LOCAL [message #408181 is a reply to message #408174] Mon, 15 June 2009 01:59 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


But babu ,we are not supposed to kill sessions listing from ps -ef | grep local=yes because its a local connection and your current session will be hanged/closed.so it s advisable to kill those sessions that are remote connections ( ps -ef | grep local=no ) .

For your information, check the answer given my michel.


Correct me if i am wrong


Regards,
Balaji
Re: Using ps -ef |grep LOCAL [message #408182 is a reply to message #408181] Mon, 15 June 2009 02:14 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


As per Mr Mic; shutdown abort should work; but as per as i know; don't try to use shutdown abort; Try to kill your known session instead of doing shutdown abort.

If your not able to find session; Then follow Mr Mic suggestion.

Thanks
Re: Using ps -ef |grep LOCAL [message #408184 is a reply to message #408182] Mon, 15 June 2009 02:24 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


Thanks for your information Smile .
Re: Using ps -ef |grep LOCAL [message #408186 is a reply to message #408182] Mon, 15 June 2009 02:36 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gentlebabu wrote on Mon, 15 June 2009 09:14

As per Mr Mic; shutdown abort should work; but as per as i know; don't try to use shutdown abort; Try to kill your known session instead of doing shutdown abort.

Why?
It is better to shutdown abort and let Oracle kill its processes than to kill the processes by yourself and let Oracle discovers they have been killed.

Regards
Michel

Previous Topic: Script to create data for testing
Next Topic: Wipro Uwin - Unix Simulator - Anybody worked
Goto Forum:
  


Current Time: Thu Mar 28 21:11:40 CDT 2024