Useful Linux Commands for Apps DBA’s

Check Used Space on  a Disk/ Mount Point
———————
The du command summarizes your disk usage. The sort command sorts the files by size. The command shown below sorts from smallest to largest all files in the current directory and all directories contained below the starting directory. Because the sort starts with the smallest file, the end of the list shows the largest files.

Deleting a large file is usually more efficient than deleting many small files. Often the largest files are core files or cache files, both of which you can delete.

du -h –max-depth=1
du -a | sort -k 1n,1|tail -30
du -sk * | sort -n | tail

Files more than 5mb
——————-

find . -mount -size +50000000c -print | ls -lh
find . -size +100000000c -print
find . -size +50000000c -print | xargs ls -l
find . -size +10000000c -print
find . -size +10000 -print

Files more than 30 day old.
—————————

find . -name “*.aud” -mtime +7

find . -name *.req -mtime +30|xargs gzip

find . -name “TEST01_*.out” -mtime +2 |xargs ls -l

find . -name “*.log” -mtime -1|xargs ls -l

Files modified in the last 6hrs ago
————————————
find . -name “*.log” -mmin 360|xargs ls -l
find . -mmin 360|xargs ls -l

find . -mtime +1|xargs ls -l

?+++++++++++++++++++++++++++++++++++++++++++++++++
find . -size +30000000c -xdev -exec ls -l {} ;

?+++++++++++++++++++++++++++++++++++++++++++++++++

13 thoughts on “Useful Linux Commands for Apps DBA’s”

  1. I all the time emailed this web site post page
    to all my contacts, as if like to read it after that my contacts will
    too.

    Feel free to surf to my web blog :: nordvpn coupons inspiresensation (wc.tv.br)

  2. Hello it’s me, I am also visiting this web site daily, this web site is
    truly good and the users are in fact sharing fastidious thoughts.

    Also visit my webpage – Vpn

  3. Hi there to all, for the reason that I am genuinely keen of reading this website’s post to be updated on a regular basis. It carries pleasant stuff.

  4. Hello would you mind stating which blog platform you’re using?
    I’m planning to start my own blog soon but I’m having a tough time choosing between BlogEngine/Wordpress/B2evolution and Drupal.

    The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique.
    P.S My apologies for getting off-topic but I had to ask!
    https://tinyurl.com/23ww4xyv gamefly

  5. You’re so awesome! I don’t believe I have read a single thing like that before. So great to find someone with some original thoughts on this topic. Really.. thank you for starting this up. This website is something that is needed on the internet, someone with a little originality!

  6. What you said was very logical. But, think on this, suppose you added a little information? I mean, I don’t want to tell you how
    to run your website, but suppose you added something that grabbed a person’s attention? I
    mean Useful Linux Commands for Apps DBA’s – Apps DBA Diaries is a
    little boring. You ought to peek at Yahoo’s home page
    and see how they create post headlines to get
    viewers interested. You might add a video or a pic
    or two to grab readers excited about what you’ve got to say.
    Just my opinion, it might make your website a little bit more interesting.
    https://tinyurl.com/2dhs6xmh what is vpn stand for

Leave a Reply

Your email address will not be published. Required fields are marked *