I m using oracle 9i db, if i want to check size of tablespaces in db .. how much used and how much free space is available..

Question

let me know d query for the above requirement

Answer 1

You can query the same from v$tablespace, describe this table(desc v$tablespace)get the data according to the requirement