Oracle Table Space vs AIX JFS space

[jriordan]

Hello All,
Looking to see if any of you have developed or have UNIX tools that you are using to report on table space usage within a file system. I administer several RS/6000's with
Oracle databases. I have weekly reports that give me my JFS file systems stats, (total space allocated, free space) etc.. However when the tables were created on the filesytems, most of the allocated file system space was taken up by the table. Returning a 95% used when I look at the filesystem. Knowing that the actual data in the table could be far less than that.
I created an sql script to report on the table space size and physical data within the table space. That output is passed to an awk script that goes out and does a "df" on the file systems that the tables reside in. It is ok if I am only looking at one instance but most of the servers have several instances with different passwords. I
wonder if there is an easer way.
Are any of you comparing table space size vs filesystem size, and if so do you have any suggestions on how I might do it another way.

Thanks in advance and sorry so long winded.
John

 

[alexhu]

I'm not sure why you would want to do this

I have my systems set up such that the Oracle data files are all on partitions easily recognisable as belonging to Oracle i.e /u01 - /u18.

If any of them are at 100% full it is of no concern because I know they cannot 'go full' - autoextend is not used so nothing grows in the Oracle filesystems

I have an SQL to tell me how full the tablespaces are and use df -k for the 'growable' filesystems

Alex