checking disk space

[so.nimda]

hi,

how do i check if there are enough disk space to be allocated to a filesystem?

we are running v11.23 sap/oracle and i need to increase a tablespace...

any help is much appreciated...

thanks ! :)

[Rick Garland]

More info is needed as there are several variables to be aware of. An example, are you running LVM or Veritas file systems?

Briefly, here are some options that you could investigate to try and find some answers.

The 'bdf' command will provide you info. Has the values for the Total space in a filesystem, the Used space, and the Available space, with a percentage.

If you are looking at LVM commands, the vgdisplay command will provide details such has how many extents are allocated to a volume group and if there are any Free Extents that you can use the lvextend command.

If you are using Veritas filesystems, use the vxprint -hrt command.

[so.nimda]

Hi Rick,

I'm using LVM.

From bdf, I can see that a file system has reached 91%. All the filesystems reside in /dev/vg00.

How do I check if I still have enough disk space to assign to this filesystem?

Is there a way for me to check how much disk space I have (in total) and how much of it has been assigned to (all) the filesystems?

Thanks

[Prashanth.D.S]

Hi,


Check available space using vgdisplay command.

example: vgdisplay /dev/vg00

--- Volume groups ---
VG Name /dev/vg00
VG Write Access read/write
VG Status available
Max LV 255
Cur LV 2
Open LV 2
Max PV 16
Cur PV 2
Act PV 2
Max PE per PV 1016
VGDA 4
PE Size (Mbytes) 4
Total PE 476
Alloc PE 36
Free PE 440
Total PVG 0

The above example shows that we have 440 Free PE's and that each PE
is 4 MB in size for total unallocated space = 1760 MB.

If not enough space is available it may be necessary to create a new
Volume Group or extend an existing Volume Group.

You can also use #vgdisplay /dev/vg* to find out details about all the vg's configured for a particular server..

Best Regards,
Prashanth

[Michael Steele_2]

Regarding "...From bdf, I can see that a file system has reached 91%.

1) What file system?

Regarding "...All the filesystems reside in /dev/vg00....".

2) Can you verify this. Its uncommon to put oracle and SAP in vg00, which is usually reserved for the HP-UX O/S and nothing else. Paste in :

# strings /etc/lvmtab

3) Is Oracle running in 'raw' file format? Verify this with your DBAs. If 'raw' then there is no file system, just the logical volume configurations. Paste in :

# bdf

4) If not raw then usually oracle databases are built utilizing 99% to 100% of the filesystems from the O/S level. This is because of the fixed database size. The database could be only half full from the oracle side, but because its fixed at the O/S side, it will always show up at 99% to 100%. This is not unusal.