Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find the free space of autoextensible enabled tablespaces

vbkJan 7 2011 — edited Feb 28 2011

Hi All,

I need to create a shell script to find the free space of an autoextensible tablespaces and send an alert when the free space is < 700MB.
I tried checking with the dba_free_space, but I did not get the exact free space.

Can someone tell me the logic to find the exact free space of autoextensible enabled tablespaces?

Thanks,
VBK

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2011

Added on Jan 7 2011

#general-database-discussions

7 comments

3,909 views