/u01 is filling up -how to know the large files


 
Thread Tools Search this Thread
Operating Systems Solaris /u01 is filling up -how to know the large files
# 8  
Old 05-05-2015
You might want to include the -x flag for du to ensure that you don't read any sub-mounted filesystems.


Robin
# 9  
Old 05-05-2015
Find files younger than 7 days and bigger than 10 blocks, and sort by size; stay on the /u01 file system:
Code:
find /u01 -xdev -type f -mtime -7 -size +10 -ls | sort -k7n

# 10  
Old 05-06-2015
You should check to see if tracing is turned on in the database. Of the directories that you show, which directory has the diag directory and how large is the .../diag/rdbms/<sidname>/<sidname>/trace directory. If that is the directory that is growing, then you need to turn off tracing and clean up the old trace files. Another option would be if either the temp or undo table spaces can grow without limit. If so you should check the size of your temp and undo directories to see if they are way too large. Ultimately, this looks like a database issue.

Careful about deleting database files, unless you really want to practice your database recovery strategy. ;-)
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Merging two text files by a column and filling in the missing values

Hi, I have to text files that I want to merge by the first column. The values in the first column pretty much match for the first part. However there are some values that are present in column 1 and not present in column 2 or vice versa. For such values I would like to substitute X for the... (9 Replies)
Discussion started by: evelibertine
9 Replies

2. UNIX for Dummies Questions & Answers

Lot of warn files filling /

hi guys I have suse 11 sp1 and I have a lot of warn file filling / these are under /var/log there's this big one -rw-r----- 1 root root 3.9G Feb 1 10:28 warn warn: ASCII text and the others that are about 2.5 to 3MB - they are about 130 warn-*.bz2 -rw-r----- 1 root root 3.9G Feb... (2 Replies)
Discussion started by: karlochacon
2 Replies

3. Solaris

How to safely copy full filesystems with large files (10Gb files)

Hello everyone. Need some help copying a filesystem. The situation is this: I have an oracle DB mounted on /u01 and need to copy it to /u02. /u01 is 500 Gb and /u02 is 300 Gb. The size used on /u01 is 187 Gb. This is running on solaris 9 and both filesystems are UFS. I have tried to do it using:... (14 Replies)
Discussion started by: dragonov7
14 Replies

4. Shell Programming and Scripting

Divide large data files into smaller files

Hello everyone! I have 2 types of files in the following format: 1) *.fa >1234 ...some text... >2345 ...some text... >3456 ...some text... . . . . 2) *.info >1234 (7 Replies)
Discussion started by: ad23
7 Replies

5. UNIX for Dummies Questions & Answers

Renaming Large Files

When I have a file for example with the wrong name I normally use the cp {filename} {new filename} comand so I will have the original as well as the correct named file. Just for backup purposes. Problem: I have a file that is 24gb with a case sensitive filename. The file was named with upper... (3 Replies)
Discussion started by: trek88
3 Replies

6. UNIX for Dummies Questions & Answers

display large files

I'm looking to display the largest files in a file system without descending into subdirectories. The / file system is 65% full and I'm looking to display only the files in / without taking into consideration other filesystem/directories. I can execute this command du -sk ./* |sort -nr... (2 Replies)
Discussion started by: Steelysteel
2 Replies

7. UNIX for Dummies Questions & Answers

large files?

How do we check 'large files' is enabled on a Unix box -- HP-UX B11.11 (2 Replies)
Discussion started by: ranj@chn
2 Replies

8. UNIX for Dummies Questions & Answers

Large files

I am trying to understand the webserver log file for an error which has occured on my live web site. The webserver access file is very big in size so it's not possible to open this file using vi editor. I know the approximate time the error occured, so i am interested in looking for the log file... (4 Replies)
Discussion started by: sehgalniraj
4 Replies

9. UNIX for Advanced & Expert Users

large files in 32 bits?

How I can call routines for write large files' text if I've a libraries that can't be compiled in 64 bits? I tried whit open O_LARGEFILE option but if I see the rows whith cat are strange because I only see the first one. (1 Reply)
Discussion started by: glfuentes
1 Replies
Login or Register to Ask a Question