Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: finding disk space utilization using shell scripts
I wrote some events for a monitoring system that can do that and more.
This system is based on shell and sql scripts you can get it at aspeda.com
The things you are asking for (tablespace usage) are actually available with the free version.
Here's the demo/download link:
http://www.aspeda.com/download/html/download_demo.html
Vitaliy
DBAToolZ.com
"Dave" <opnets_at_yahoo.co.uk> wrote in message news:c9e9d941.0305291226.6f568d5d_at_posting.google.com...
> Hi all,
>
> I need to otain disk utilization, free space one the machines running
> oracle.So, shell scripts should be run using tsnames on all the
> machines and then finding for the space using
>
> select tablespace_name,sum(bytes) from dba_data_files
>
> select tablespace_name,sum(bytes) from dba_free_space
>
> Could anyone please help me out with the scripts.
>
> Thanks in advance.
>
> Dave.
Received on Thu May 29 2003 - 23:57:59 CDT