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