Wednesday, November 5, 2014

Commonly used UNIX command for DBA



#This command kills the process used by the oracle. By using this command we can avoid the restart of the machine.
#ps -ef | grep "oracle" | awk '{print $2}' | xargs kill


#This command is used to view the port used at the os level.
#netstat -a


#This command is used to view all the processes run by the oracle users.
#ps -ef  | grep oracle


#This command is used to find the running database in unix system.
#ps -ef  |  grep pmon


#This command is used to view the memory untilization , cpu utilization , swapping at the os level
# topas

export TZ=Asia/Kolkata


http://www.cyberciti.biz/tips/what-is-devshm-and-its-practical-usage.html


# mount -o remount,size=8G /dev/shm

No comments:

Post a Comment