What is the view name which we use to look for the size of a data file. Also what is the view name to look for the free space in a table space ? Thank you in advance for your reply.
asked
What view would we use to look at the size of a data file?
You could look at this:
SELECT * FROM v$datafile
I'd also suggest you use the operating system directory command to check the OS' opinion of the file size.
Check out the DBA_FREE_SPACE data dictionary view
Calculating freespace isn't so clear when you have the data files growing automatically with or without quotas.
DBA_DATA_FILES - This view is used to look for the size of a data file. DBA_FREE_SPACE - This view is used to look for the free space in a table space.
