kalyan_ck

 Profile Answers by kalyan_ck 

• Mar 30th, 2009

 

To check the process use
ps -ef |grep pmon
ps -ef

To check the alert log file
tail -f alert.log

To check the cpu usage
top
vmstat 2 5

fnlin

 Profile Answers by fnlin 

• Oct 31st, 2010

 

The question refers to a "file", not a process. As far as file, DBA should check the file system capacity and usage via "df -hk ." command (or "df -hk /db?", if the database is using /db? directories for datafile, etc.) on Unix.  Of course, you may ask SA what kind of file system /db? reside. Monitor a file "tail -f filename" may need sometimes. Copy a file ("cp original_filename new_filename") or move a file ("mv original_filename new_filename") (note: mv will keep the original timestamp and cp will use current timestamp) is frequently used, too. To create a new empty file, "touch filename" or "> filename"will be needed once awhile. To see the contents of a file, "vi filename" or "cat filename" is a common way. To delete (remove) a file, "rm filename". To delete all archive log files in a directory (and subdirectories) which are older than 7-days, "find . -type f -name "*.trc" -meantime +7 -exec rm {};" To change a permission of a file "chmod nnn filename" (Type "man chmod" for the nnn details).

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

 

/etc/hosts

/etc/passwd

/var/opt/oratab

/var/adm/messages (Solaris) var/log/messages(Linux)

df -k (df -h on Solaris 5.10+)