OraFAQ Forum: Unix » Using ps -ef |grep LOCAL

Home » Infrastructure » Unix » Using ps -ef |grep LOCAL (Oracle 10g,solaris)

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

Using ps -ef |grep LOCAL [message #408100]

Sun, 14 June 2009 01:45

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

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408107 is a reply to message #408100]

Sun, 14 June 2009 03:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

LOCAL=YES => local connection
LOCAL=NO => remote connection

Regards
Michel

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408111 is a reply to message #408107]

Sun, 14 June 2009 04:15

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408174 is a reply to message #408113]

Mon, 15 June 2009 00:44

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

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408181 is a reply to message #408174]

Mon, 15 June 2009 01:59

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

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408182 is a reply to message #408181]

Mon, 15 June 2009 02:14

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

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408184 is a reply to message #408182]

Mon, 15 June 2009 02:24

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Thanks for your information Smile

Report message to a moderator

Re: Using ps -ef |grep LOCAL [message #408186 is a reply to message #408182]

Mon, 15 June 2009 02:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 06:05:31 CST 2024