Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • ORA-3136 Oracle
  • cp_filesystem.sql Oracle
  • get_aix_vmstat.ksh Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • V$transaction notes for finding XID composition. Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • Generating XML from SQLPLUS Oracle
  • myfile Oracle
  • Pending Distributed Transations Oracle
  • cur_sql.sql Oracle
  • Find nth max and min. Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle

How to sort list of files on basis of their sizes.

Posted on 09-Nov-2006 By Admin No Comments on How to sort list of files on basis of their sizes.

tuningdb21->AWRTEST@(/db1/home/oracle)ls -rlt | sort +4

total 48

drwx—— 2 oracle dba 96 May 17 16:16 nsmail

drwxrwxr-x 3 oracle dba 96 Oct 3 2005 app

drwxr-xr-x 3 oracle dba 96 Oct 4 2005 patch

drwxr-xr-x 2 oracle dba 96 Oct 16 15:17 scripts

-rw-r–r– 1 oracle dba 124 Oct 3 2005 local.cshrc

-rw-r–r– 1 oracle dba 385 Oct 10 10:47 afiedt.buf

-rw-r–r– 1 oracle dba 582 Oct 3 2005 local.profile

-rw-r–r– 1 oracle dba 607 Oct 3 2005 local.login

drwxr-xr-x 3 oracle dba 1024 May 24 14:19 oraprocs

drwxr-xr-x 2 oracle dba 1024 Oct 19 2005 RMAN

drwxr-xr-x 5 oracle dba 7168 Nov 7 17:19 paresh

-rw-r–r– 1 oracle dba 10267 Oct 11 13:39 rr1

tuningdb21->AWRTEST@(/db1/home/oracle)

And for sorting in reverse order.

tuningdb21->AWRTEST@(/db1/home/oracle)ls -rlt | sort -r +4

-rw-r–r– 1 oracle dba 10267 Oct 11 13:39 rr1

drwxr-xr-x 5 oracle dba 7168 Nov 7 17:19 paresh

drwxr-xr-x 2 oracle dba 1024 Oct 19 2005 RMAN

drwxr-xr-x 3 oracle dba 1024 May 24 14:19 oraprocs

-rw-r–r– 1 oracle dba 607 Oct 3 2005 local.login

-rw-r–r– 1 oracle dba 582 Oct 3 2005 local.profile

-rw-r–r– 1 oracle dba 385 Oct 10 10:47 afiedt.buf

-rw-r–r– 1 oracle dba 124 Oct 3 2005 local.cshrc

drwxr-xr-x 2 oracle dba 96 Oct 16 15:17 scripts

drwxr-xr-x 3 oracle dba 96 Oct 4 2005 patch

drwxrwxr-x 3 oracle dba 96 Oct 3 2005 app

drwx—— 2 oracle dba 96 May 17 16:16 nsmail

total 48

Linux/Unix, shell

Post navigation

Previous Post: Locktree.sql
Next Post: oradebug ipcrm ipcs

Related Posts

  • Space padding in korn shell Linux/Unix
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • runsql_once.ksh Linux/Unix
  • Monitor and Trace Unix processes using truss Linux/Unix
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • Validating ORACLE_SID againt oratab file. Linux/Unix

Leave a Reply Cancel reply

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

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • v$event_name Oracle
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • kill all processes from specific user in solaris. Linux/Unix
  • process id based files and processes Linux/Unix
  • Renaming the column name Oracle
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme