NM.Mathan Oracle Apps DBA
Friday, 14 October 2011
datafile-free-used size
select a.name,a.bytes/1024/1024 "Size",b.bytes/1024/1024 "Free",(a.bytes-b.bytes)/1024/1024 "Used" from v$datafile a,dba_free_space b where a.file#=b.file_id;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment