Home » Infrastructure » Linux » How to check size of a datafile greater than 10GB (linux 4.0 with oracle 10g)
How to check size of a datafile greater than 10GB [message #541161] Sun, 29 January 2012 00:15 Go to next message
faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India
Junior Member

Hi All,

Can anyone tell me how to see the size of a datafile which is greater than 10GB.
We have all the datafiles on Autoextend on feature

I tried with df -h * but that gives the space allocated and the maxsize.

Thanks for your help
Faiz
Re: How to check size of a datafile greater than 10GB [message #541164 is a reply to message #541161] Sun, 29 January 2012 00:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
man find

find -size

      -size n[cwbkMG]
              File uses n units of space.  The following suffixes can be used:

              `b'    for  512-byte blocks (this is the default if no suffix is
                     used)

              `c'    for bytes

              `w'    for two-byte words

              `k'    for Kilobytes (units of 1024 bytes)

              `M'    for Megabytes (units of 1048576 bytes)

              `G'    for Gigabytes (units of 1073741824 bytes)

              The size does not count  indirect  blocks,  but  it  does  count
              blocks in sparse files that are not actually allocated.  Bear in
              mind that the `%k' and `%b' format specifiers of -printf  handle
              sparse   files  differently.   The  `b'  suffix  always  denotes
              512-byte blocks and never 1 Kilobyte blocks, which is  different
              to the behaviour of -ls.

Re: How to check size of a datafile greater than 10GB [message #541168 is a reply to message #541164] Sun, 29 January 2012 01:23 Go to previous message
faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India
Junior Member

Appreciate your help...Thanks a lot
Previous Topic: Oracle Developer 10g Installation on Linux
Next Topic: Oracle not available
Goto Forum:
  


Current Time: Thu Mar 28 06:54:30 CDT 2024