Sunday, April 27, 2014

Windows : Continous ping ipaddress

using this command you can ping ipaddress continously to monitor stablity of network between you pc to the ipaddress.

ping 192.168.2.201 -t

UNIX : Kill PID

How to kill process in UNIX ?

first get pid by using grep command.

root 21122 21123 0 13:00:01 ? 0:00 /temp/dummyscript.sh

get the PID number, yellow highlight for above output.

run this command : kill -9 21122 21123

or you can run multiple process by just add the pid number.

example : kill -9 12343 24437 372846 8364 8273 82746

Unix : Grep


grep specific program

ps -ef | grep *batch*
ps -ef | grep batch.sh


grep by username

ps -ef | grep root
ps -ef | grep unixuser



Friday, April 25, 2014

Oracle : How to find all indexes under certain table.

How to find all indexes under certain table.

select index_name, column_name
 from user_ind_columns
 where table_name = '<table_name>';