filesystem has 25 gb free but script maxbytes gave 333.763657 GB
The filesystem ora1 has 25 gb free.
I want to understatnd what does it means the following script. does it means that if all datafiles use its maxsize the filesystem ora1 will become in zero bytes?
This is the script and the result:
SQL> select sum(bytes)/1024/1024/1024,sum(maxbytes)/1024/1024/1024 from dba_data_files where file_name like '%/psprdb01/prd/ora1%';
SUM(BYTES)/1024/1024/1024 SUM(MAXBYTES)/1024/1024/1024
------------------------- ----------------------------
106.322266 333.763657
SQL>
This is the script and the result:
SQL> select sum(bytes)/1024/1024/1024,sum(maxbytes)/1024/1024/1024 from dba_data_files where file_name like '%/psprdb01/prd/ora1%';
SUM(BYTES)/1024/1024/1024 SUM(MAXBYTES)/1024/1024/1024
------------------------- ----------------------------
106.322266 333.763657
SQL>
0