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!

Can we get Filesystem size from database?

user2017273Dec 17 2015 — edited Dec 18 2015

I want to get datafile filesystem size from database login. Is it possible?

SQL> select distinct substr(FILE_NAME,1,instr(FILE_NAME,'/',2)-1) as mount from dba_data_files

2 /

MOUNT

----------------------------------------------------------------------------------------------------

/u01

/u02

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2016

Added on Dec 17 2015

#general-database-discussions

6 comments

2,495 views