>I am still learning about the select statement and I wanted to make sure >that I get the syntax correct before I run it. What I need is a select >statement that will look for all files with the following name: >/ut0/oradata/arch/*.arc and how much space it takes up on an individual >node. Does anyone have any suggestions? Thanks!
Joni - You really have to perform such queries from the client, as very little detail is available from the server, because the details are OS-dependent. Select queries will yield size info in terms of Aggregates, which won't help you. Richard Sims, BU