Web Development

Ask something
Discussion Locked

Get filesystem size from within Oracle..

0 helpful
3 replies

by technontology

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm trying to get the filesystem sizes for filesystems on multiple unix servers, from
within an Oracle database instance.

e.g. I have 3 servers, each running Oracle. I want to get the filesystem sizes for the Oracle-owned directories on each server. the following code finds the size - from U*ix cmd line:
find /opt /export /oradata /oracle -user oracle -ls 2>/dev/null | awk '{total+=$7}
END {printf("Total size: %14.2f B\n", total/(1024*1024)));}'

From the SQL*Plus prompt, I can escape this with "!" and still get the answer from the server I'm on.
What I want is to log onto one server and database instance, execute a command on the others via a db_link from which I can return a value to populate a database table row from.
Theservers are SunOS 5.6/5.8 and AIX 4.3. The Oracle instances are 7.3.4, 8.0.5, 8.1.6, and 8.1.7

3 replies

This discussion is closed to new replies.