How do you find files that are greater than 3GB in HP unix?
find / -size +3000000000c -exec ls -l {} \;
Sharing real time knowledge,issues on Oracle Apps DBA and Oracle DBA
Showing posts with label Unix Important. Show all posts
Showing posts with label Unix Important. Show all posts
Monday, November 10, 2008
Friday, October 31, 2008
Check all logs for ORA- errors
Check all logs for ORA- errors
grep ^ORA- *log |cut -f2 -d"-"|cut -f1 -d:|awk '{print "ORA-" $1}'|sort -u
grep ^ORA- *log |cut -f2 -d"-"|cut -f1 -d:|awk '{print "ORA-" $1}'|sort -u
Thursday, October 23, 2008
Find out Top 10 Memory consuming processes?
How to Find out Top 10 Memory consuming processes?
UNIX95=1 ps -eo vsz,pid,args | sort +0n -1 | grep oracle | tail -10
Pass Database Name in places of SID
UNIX95=1 ps -eo vsz,pid,args | sort +0n -1 | grep oracle
Pass Database Name in places of SID
Find out Mount points Which exceeds 80%
Find out mount points starts with oracle which exceeds 80%?
bdf|grep -e oracle grep '[7-9].%'
bdf|grep -e oracle grep '[7-9].%'
Wednesday, September 03, 2008
Unix Important
1. How do you delete 3 days old log files?
Usage: find /location -name "*.log" -mtime +3 -exec rm -rf{} \;
Example : find ./ -name "*.req" -mtime +4 -exec ls -ltr {} \;
2. Display latest 20 largest files/directories in current directory?
Solution: du -ka sort -n tail -20
3. How do you display/remove Specifice Month files in Unix?
Solution: rm `ls -l grep Jun awk '{print $9}'`
4. How do you find the files which contains a specific Word?
Solution : find /home/ganesh \( -type f \) -exec grep -l test {} \;
Usage: find /location -name "*.log" -mtime +3 -exec rm -rf{} \;
Example : find ./ -name "*.req" -mtime +4 -exec ls -ltr {} \;
2. Display latest 20 largest files/directories in current directory?
Solution: du -ka sort -n tail -20
3. How do you display/remove Specifice Month files in Unix?
Solution: rm `ls -l grep Jun awk '{print $9}'`
4. How do you find the files which contains a specific Word?
Solution : find /home/ganesh \( -type f \) -exec grep -l test {} \;
Subscribe to:
Posts (Atom)
Oracle EBS integration with Oracle IDCS for SSO
Oracle EBS integration with Oracle IDCS for SSO Oracle EBS SSO? Why is it so important? Oracle E-Business Suite is a widely used application...

-
Enabling TLS in Oracle Apps R12.2 Here we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...
-
Oracle EBS integration with Oracle IDCS for SSO Oracle EBS SSO? Why is it so important? Oracle E-Business Suite is a widely used application...
-
Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well ...